Program for Keeping track of Orders (like for the eshop that I run)

Necrosaro420

Senior member
Apr 24, 2005
576
0
0
Im looking for a good program that will keep track of all of the orders that I have received on my website, keep track of their names, if it has shipped or not, what the order is, etc etc.

Anyone have any recommendations? Thanks!
 

EagleKeeper

Discussion Club Moderator<br>Elite Member
Staff member
Oct 30, 2000
42,589
5
0
For simplicity sake, a spreadsheet or small database should be able to suit your needs.

Or are you expecting it to interact with the web site directly?
 

Necrosaro420

Senior member
Apr 24, 2005
576
0
0
Originally posted by: EagleKeeper
For simplicity sake, a spreadsheet or small database should be able to suit your needs.

Or are you expecting it to interact with the web site directly?


Just a program I can open up and have a buyers name/address/item purchased/shipped yes or no basically


I could use a spreadsheet, but I have no clue how to set those up


 

Brazen

Diamond Member
Jul 14, 2000
4,259
0
0
As EagleKeeper asked: is this something that you want to interact directly with the website? Do you want the website to automatically fill in that data? Or do you want to check the website and then type the data into this new application by hand?
 

EagleKeeper

Discussion Club Moderator<br>Elite Member
Staff member
Oct 30, 2000
42,589
5
0
Do you have MS Access on your system or any other type of database application?



For a spreadsheet, just have each column contain the informational type that you desire.
You can use Row #1 to Label the Columns

First Col - Name
Second - Address
Third -State
Fourth - Zip
Fifth - Phone
Sixth - item purchased
Seventh - Date
Eight - Shipped (Y/N)
Nine - Cost


For a Database you would want 3 tables
Table #1 - Customer Info
Table #2 - Product Info
Table #3 - Transaction Info
 

Necrosaro420

Senior member
Apr 24, 2005
576
0
0
Originally posted by: EagleKeeper
Do you have MS Access on your system or any other type of database application?



For a spreadsheet, just have each column contain the informational type that you desire.
You can use Row #1 to Label the Columns

First Col - Name
Second - Address
Third -State
Fourth - Zip
Fifth - Phone
Sixth - item purchased
Seventh - Date
Eight - Shipped (Y/N)
Nine - Cost


For a Database you would want 3 tables
Table #1 - Customer Info
Table #2 - Product Info
Table #3 - Transaction Info

You talking about excel? or whatever? I have it, but I have no clue how to work it really lol

 

EagleKeeper

Discussion Club Moderator<br>Elite Member
Staff member
Oct 30, 2000
42,589
5
0
Spreadsheet == Excel

Database == MS Access or MySQL