I would like to create a web program to calculate the profits of my amazon store. Currently I have one just in excel but it takes a lot of manuel work and I would like to stream line it with a sql database or something to make it easier. I have attached a sample of my currently program and documents that are used in the file from UPS report - stamps report. On my old program i would scrape all the tracking number but would like to match it but name because the scraping program took way to long.
I would like to create a webpage to upload the docuemtents needed they are put into the database and they spit out the information of the profits and loss. Like they do on the 1st page of the sample month.(copyofmay is the file) (total profits of the item and how many units sold.) This should have filters so it can be moved around to i can order by units sold or by total profit. I would also like to be able to look at all the transactions of a certain item. I would also like to be able to download it to a file in excel.
Currenty the program is set up as a cover page. The transaction report gets the profits and losses then looks at the order report to get the name of the buyer so it can look at the stamps or ups report. I would also like it to check to make sure they are looking up the correct person by zip code. Also it the person has a double order with the same tracking I only want to be chaged shipping on 1 of the items.