I currently have a small business where I sell products to 2 different vendors. I have a basic spreadsheet with the item code, my cost of goods sold, the vendors from which I purchased the materials, the vendor to which I sell it, and the price for which I do sell it. I also keep the date of the original order, the date that I shipped it in, and the date that received payment, as well as the shipping tracking number.
I have been sorting this through Excel, and that has been going ok. However, I am wondering if perhaps Access would be a better program for me. Part of what I am wanting to do is evaluate which vendor is the best, how long it's taking to receive payment, etc. My spreadsheet is currently around 600+ lines, and it gets time consuming to maintain, particularly after I work 20 hours a week on this business already, sourcing and preparing product.
Also, I am wanting to have more simple notifications that orders have been received and then paid. My paying vendor allows me to type in an order number and check the status of the order that I sent in (steps are Received and Received, Awaiting Payment, and Paid.) I have to manually check each one of those, but I'd like to find some way to have my spreadsheet (or Access program) update itself. I have looked at the source code for the page where this data is, but it's all in AJAX type coding, and the data isn't actually there on the page.
I'd love to hear your thoughts and suggestions.