Automate updating inventory on an existimg sheet?
Once a month we receive 5-7 files in csv format from vendors with an inventory update. I made each file into a sheet and then made a report with all sheets to have a master sheet. We add columns to track what inventory needs to be reordered and when an item is about to expire or needs to be tested to extend the expirstion date. These are all columns we add and set up manually.
The issue comes when its time to update line items. We get new files from the vendor which may contain new line items. This causes the row postion of an item on a sheet to change. So if we simply copy and paste the new data into the sheet to override the old data, the columns we set up detailing reorder levels and retest dates wont match up. While I am hoping we can ask the vendors to give us a file where any new line items are all the bottom lines in the file, I think it would still present a large opportunity for error as we would need to verify each row matches prior to transferring the data from the vendor file to the smartsheet.
Im stumped on a solution that doesnt require a ton of manual checking by eye.