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

[Necrosaro420]

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]

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]

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]

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]

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]

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]

Spreadsheet == Excel

Database == MS Access or MySQL

 

[Necrosaro420]

shrug lol

Are there any programs prebuilt for this?

 

[EagleKeeper]

Originally posted by: Necrosaro420
shrug lol

Are there any programs prebuilt for this?

You have PM