Importing CSV file into excel file and updating some felids only! PLEASE HELP!?
Question by BusinessIdeas: Importing CSV file into excel file and updating some felids only! PLEASE HELP!?
Hey Everyone,
I’m currently trying to setup an online store, my wholesaler provides all their product info daily via .CSV file. The file from my wholesaler has about 2400 items. I cleaned up the file in Excel to show only the products that i will sell in my store. What I want to do is update the PRICE and STOCK fields within the excel sheet with updated figures from the CSV file. So basically i only want to update to fields. Each product has its own unique ID, which is same in both files (Excel and CSV).
Is there a software or a script that i can use to compare both files and updates the excel file with any products updates?
what i hop to then is create a updated CSV file from my excel file and then upload that to my store to update my products.
Any help and suggestion will be much appreciated.
Best answer:
Answer by Cozmosis
In your product file that has just the products that you sell (Let’s call it Products.xls).
Column A is the ID
Column B is the item description
Column C is the price
Column D is the stock
Put this in C2
=INDEX([Supplier.xls]Sheet1!$ C:$ C, MATCH(A2, [Supplier.xls]Sheet1!$ A:$ A, 0))
This will lookup the ID from cell A2 and look for it in an Excel file called Supplier.
It will look for the the ID in Supplier.xls within column A
It will return the value from Supplier.xls column C for that ID
Put this in D2 to get the stock amount for the ID in A2
=INDEX([Supplier.xls]Sheet1!$ D:$ D, MATCH(A2, [Supplier.xls]Sheet1!$ A:$ A, 0)
Copy C2:D2 and paste the cells down columns C and D for each item you have.
Now if you open any new CSV file from your supplier and then save it as Supplier.xls, Your Products in Products.xls will update.
Give your answer to this question below!
