Hi, I am working on the inventory for a website that sits in a nice csv file with many columns. The unique ID in the spreadsheet is the SKU #'s of the product.
I have 3200 items currently in the system, I just got another spreadsheet with 3800 items and all the prices that need to added.
So I have 600 more items on the new file, I can't just sort, copy and paste the prices because of the new items.
Is there a way to merge the two without redoing the entire csv file? I know this sounds odd so please ask questions if it helps.
Logically I see it like this (A is my current csv file and B is my new file with prices and 600 more items) SKU and price are columns
If SKU from A is in B, assign price of B to A ... If SKU from B is not listed in the SKU's from A, add SKU and price from B to a new row in A (can even be on a new sheet and I can add it to file A). This would add 600 items or create a new sheet with these items from B that are not in A)
confused? I am
but a neat challenege
I have 3200 items currently in the system, I just got another spreadsheet with 3800 items and all the prices that need to added.
So I have 600 more items on the new file, I can't just sort, copy and paste the prices because of the new items.
Is there a way to merge the two without redoing the entire csv file? I know this sounds odd so please ask questions if it helps.
Logically I see it like this (A is my current csv file and B is my new file with prices and 600 more items) SKU and price are columns
If SKU from A is in B, assign price of B to A ... If SKU from B is not listed in the SKU's from A, add SKU and price from B to a new row in A (can even be on a new sheet and I can add it to file A). This would add 600 items or create a new sheet with these items from B that are not in A)
confused? I am
but a neat challenege
