We currently receive daily csv files from our distributors giving us the usual product info ie product codes, pricing, descripion and stock levels. We upload this to a number of platforms including our own ecommerce site. What we are looking for if possible (and i dont know if this is possible in excel or if we would need to buy some sort of stocking system programme - advice would be appreciated) is a programme written in excel that can do the following;
1. Look at two csv files (one a master with our own SKU's) and and assign the correct SKU from the manufacturers codes.
2. Highlight any products that dont match SKU's i.e. new products
3. Highlight any products that have had a price change
Once this is done we can then compare and upload new stock levels and prices were needed to the relevant sites.
24 freelancers are bidding on average $72 for this job
Hi Carol, According to your description of the project, i will be able to deliver the project in 3-4 days It's much better if you can provide me some sample excel file to have a proper idea of your requirement