I am running an E-commerce store and my inventory is downloaded and uploaded using csv files. I also downloaded an inventory list (xls) from my wholesaler and sorted it alphabetically by product name and set it to include only items that are in stock and are of the type that I want. I organized my store's inventory the same way. What I need to do is this:
1. Whenever a product exists on both lists, overwrite the amount in stock in my store with the amount in stock from my wholesaler
2. Whenever a product exists in my inventory, set the amount in stock to 0
3. Whenever a product exists on my wholesalers list, but not mine, either ignore it, or append it to the end of my inventory list (this is not crucial, I am more worried about maintaining my current inventory)
My personal experience:
I have limited experience with PERL, more extensive experience with Java, C++, Python, and BASIC, but I have never programmed with Excel and I have no experience with sorting and searching algorithms other than what I have read. I honestly don't know where to start with Excel, but I really only need to perform this function.
Bookmarks