Updating product cost prices and retail values from old spreadsheet into new sheet, so these can be uploaded into website.
I have initially 1,000 products from various suppliers, in different spreadsheet that need matching up, via SKU/Product Code, and the cost and retail values entering.
If a good job is done, I have another 8,000 that will need doing.
This could possibly done via VLookup I think.
I have attached a sample sheet of the supplier sheet, and the new CSV sheet that will be uploaded, so please have a look before bidding on the job.
Cost Prices and Retail ex VAT values to be taken from "AF Rayspeed Cost Prices" and entered into "AF Rayspeed List"
I need accuracy, care and speed for this job, must be done in the next few days.
Dan G.100% (22)
Create an account now and send a proposal now to get this job.Sign up
Clarification Board Ask a Question
Can you provide another sample please? The suppliers list file doesn't seem to have any prices and it is not a useful CSV file. Thank you
are you able to adjust your budget?
May I have the new sheet in excel format? as the csv is quite messy. Thanks :)