Product/Customer/Transaction Program that Reads/Writes into CSV Files/Local Database

Peruttu Julkaistu May 9, 2012 Maksettu toimituksen yhteydessä
Peruttu

We need an application that we can use to store product information, customer information, previous transaction information, and has the ability to output tailored messages that have customized information such as their name, address, and custom entry fields as well.

We do require data to be able to be imported/exported to csv for reading in Excel, however if you choose a primary means of storage to be a database we will require it to be local and the service to have a small footprint.

## Deliverables

We need an application that we can use to store product information, customer information, previous transaction information, and has the ability to output tailored messages that have customized information such as their name, address, and custom entry fields as well.

The customer information consists of 11 fields - a unique ID number (not auto generating, we need to be able to enter and edit this), Customer First Name, Customer Last Name, Customer Address (This may be multiple addresses, minimum of 2000 characters will be required), Number of previous transactions, Email, Website URL, Phone Number, and 3 notes field that can contain a minimum of 1000 characters.

The transaction information will be 6 fields and needs to be stored in a separate csv file than the user csv file, but we need to be able to identify which product(s) a customer bought on previous dates (and be able to sort through them), when the item was bought, amount paid, etc.; so a method of linking a customer to their transactions is required. A customer purchasing multiple items will be stored as multiple transactions, so we do not need a method of entering multiple items into a single transaction.

The fields for the transaction is Unique Item Number (also not auto generating), Item Department, Item Category, Item Name, Item Price Wholesale, Item Price Retail, UPC code, Item Description (up to 4000 characters minimum), and 2 Notes Sections that can contain a minimum of 1000 characters.

We need to be able to select a previous customer via a dropdown or similar method and view their information (name, address, etc.) as well as their previous transactions, a way of viewing the item via clicking/interacting with a specific customer transaction. We need to be able to edit previous entries and create new transaction entries.

We also need to be able to create a new buyer profile manually. All information needs to be able to be edited.

The messaging will need to be able to let us manually write and store messages so we can use them in templates to send to customers email (or snail mail in the event of no email). This means we need the ability to copy and paste from a text box as well as print the message. We need to have the options to either include or exclude information about the selected customer or their transaction in the message, such as a their name, their address, and other information from the user list; transaction data such as item purchased, date of purchase, cost, and other information from the transaction list; and Item name, item number, item link (plain text, not html), item cost, and other information from the product database.

We will need to be able to select multiple stored messages (up to 32) to use in a single template, along with the information about customer/transaction/product at various points, and we need to be able to save and edit these templates. We need the ability to include both custom messages and information from csv file in the same template, as well as having them consist of entirely message templates, entirely csv information, or a mix of both in customizable order.

We do need a way to format the way csv values are displayed in the messages and save them (and be able to edit them later), so we would be able to include, for example, a raw value ("19.95") or a custom format ("$19.95 + Tax") when we opt to include select information in the message templates.

The program needs to be XP/7 compatible and work with 32 bit and 64 bit architectures. The program will not be required to send emails nor connect to the internet, although we do need it to be able to function with a networked printer that is not attached directly to the terminal.

We will only be running the program on a single terminal at a time, and will only be installed on one at a time so networking across several terminals is not needed. We need the option to import and export the csv files from the hard disk, flash drive, etc. in the event of a system failure or switching system.

Excel Microsoft Access Microsoft Exchange Powerpoint Windows Desktop Word

Projektin tunnus: #2740116

Tietoa projektista

12 ehdotusta Etäprojekti Aktiivinen May 31, 2012

12 freelanceria on tarjonnut keskimäärin $13/tunti tähän työhön

pr0digysl

See private message.

$18.2 USD / tunti
(58 arvostelua)
5.8
sbhask2k

See private message.

$10.01 USD / tunti
(34 arvostelua)
4.7
satvainfotech

See private message.

$18.2 USD / tunti
(7 arvostelua)
4.5
serapissobek

See private message.

$10 USD / tunti
(13 arvostelua)
4.2
rajhansh

See private message.

$15 USD / tunti
(18 arvostelua)
4.2
oasis21

See private message.

$16.38 USD / tunti
(21 arvostelua)
4.0
vnoutsourcingvw

See private message.

$18.2 USD / tunti
(15 arvostelua)
3.9
saumilmodi

See private message.

$5.46 USD / tunti
(13 arvostelua)
3.2
gybersantos

See private message.

$7.28 USD / tunti
(1 arvostelu)
1.0
parvej35

See private message.

$5.46 USD / tunti
(0 arvostelua)
0.0
parttimecon

See private message.

$17 USD / tunti
(0 arvostelua)
0.0
arkotechsofvw

See private message.

$11 USD / tunti
(0 arvostelua)
0.0