What I would like is a tool to create invoices, shipping labels and a package checklist from my Ebay csv sales history. Also, it needs to create a history of all the sales. [url removed, login to view] is a file downloaded from eBay that contains all the information needed to create the invoices, labels and package checklist.
The program needs to merge the files for multiple items into one invoice. There are 2 ways in which multiple items are displayed. One is via individual purchases where they went through the checkout twice, and have 2 sets of complete information. The other is if they go through the process and checkout multiple items through one transaction. Sometimes, people might do both in one csv file. The program needs to account for this and merge all of the purchases into the same invoice. It also needs to create a custom invoice number per transaction, which will also be used for later in the database. They then need to be all displayed on a screen, in which they can be inspected for errors, before being printed off all at once.
The shipping labels need to contain the information as specified, and in that order. Only one label per eBay UserID is needed, but I need the option to be able to print more if needed at a later stage. They then need to be all displayed on a screen, in which they can be inspected for errors, before being printed off all at once.
The package checklist needs to be a list of all the packages, by User ID that contains the UserID, the name of the person, the address and then the products they ordered. The very end of each name on the very right hand side of the screen needs to have an empty box in which once printed, can be checked off (by pen). They then need to be all displayed on a screen, in which they can be inspected for errors, before being printed off all at once.
All the items need to be sorted by the Paid on Date. Also, before being printable, all the documents created need to be viewable to quickly check for any errors.
The last bit requires all these transaction to be put into a list or a database which contains all previous transactions so that they can be searched for warranty purposes.
I will have attached a 6 files, an example CSV file, an example of invoice and shipping label documents that needs to be created, and the same documents with mail merge fields indicating what information goes where and an example of the checklist.
It can be done in access or excel.
It really is quite an easy task!