Transfer of Cost Prices for Products from 1 Excel Sheet to Another
- or -
Post a project like this$$
- Posted:
- Proposals: 46
- Remote
- #2097932
- Expired
Virtual Assistant / Data Entry Operator / Graphics Designer / Web Designer / Business Support / Product Listing
Dhaka
Website Development, Mobile App Development, Basic WordPress website creation and Admin Support
Sivakasi
Pipedrive | Hubspot CRM | Zapier | Tableau | Excel | Google Sheets | Mailchimp | Shopify
Pune
Data Modeling in Excel & Power BI With Power Pivot, Power Query, DAX and Google Data Studio Expert.
Dhaka
2121287138759412114101571571152349623055941946714233059511139312331169
Description
Experience Level: Intermediate
The Task
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.
Many Thanks,
Dan
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.
Many Thanks,
Dan
Dan G.
100% (45)Projects Completed
24
Freelancers worked with
9
Projects awarded
78%
Last project
1 Jul 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Dan,
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
Zoran -
Hi Dan,
are you able to adjust your budget?
cheers,
Agnes -
May I have the new sheet in excel format? as the csv is quite messy. Thanks :)
688263688199688196
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies