Product Data Gathering & Updating Prices - ON GOING PROJECT -
- or -
Post a project like this$50
- Posted:
- Proposals: 12
- Remote
- #2194966
- Expired
LinkedIn Lead Expert, Web Scraping, Data Entry, Data mining, Web Crawling, Data extraction and Email Lists
London
Customer Support, Bookkeeping, Data entry, Product listing, Virtual assitant
Coimbatore
Data Entry, PDF Conversion, Fillable PDF Form,Data Mining, CRM, Email list, MS-Excel, Transcription.
Burhanpur
81580419467871235423128591985816230639324347741256421229599454501024797452235198
Description
Experience Level: Entry
We have multiple pricing that we receive on a quarterly basis and we need to update monthly. If we receive a new price sheet, we need it to be updated no later than the following week. *7 business days*. We have a folder that we have in place that we add our products into called "Brands pricing". We add the products into that folder and you will need to update the google excels with all new product information per excel. You will also need to be responsible to update discontinued models that are no longer on the new price sheets.
***This project is for consistent work & pays bi-weekly **
Exact Steps:
Open the Brand-pricing folder> choose a brand> choose 2018 Active> and select the Excel or PDF.
Open Online Price Sheets folder> and open Online Master Sheet
In the Online Master Sheet Copy the Manufacturer, SKU, Discontinued, Cost, MAP, Weight, Category from the manufacturer Excel or PDF opened in step 1 and paste it into the column’s SKU and Cost.
Then you will need to start adding the SKUS of what you copied to the Store Specific Folder.
Online Price Sheets> open Amazon Folder> Open the excel> Follow instructions on the first tab of the excel and fill in the sheets required information accordingly.
Then Open the sheet Roadmap 2018 and select the second tab Brands Added & Updated and fill in the appropriate columns for the brand you finished which are: In Master Price Sheet, Last Updated, Where and if it's listed, completed by, Total Product Line.
Once finished move to the next Brand in step 1 and repeat steps 2-5.
Once a new price sheet is added to the brands folder you will need to do steps 1-6 and you will need to add a yes to the discontinued column on the Online Master Sheet for all items that are not listed on the new price sheet for the Brand you are working on.
***This project is for consistent work & pays bi-weekly **
Exact Steps:
Open the Brand-pricing folder> choose a brand> choose 2018 Active> and select the Excel or PDF.
Open Online Price Sheets folder> and open Online Master Sheet
In the Online Master Sheet Copy the Manufacturer, SKU, Discontinued, Cost, MAP, Weight, Category from the manufacturer Excel or PDF opened in step 1 and paste it into the column’s SKU and Cost.
Then you will need to start adding the SKUS of what you copied to the Store Specific Folder.
Online Price Sheets> open Amazon Folder> Open the excel> Follow instructions on the first tab of the excel and fill in the sheets required information accordingly.
Then Open the sheet Roadmap 2018 and select the second tab Brands Added & Updated and fill in the appropriate columns for the brand you finished which are: In Master Price Sheet, Last Updated, Where and if it's listed, completed by, Total Product Line.
Once finished move to the next Brand in step 1 and repeat steps 2-5.
Once a new price sheet is added to the brands folder you will need to do steps 1-6 and you will need to add a yes to the discontinued column on the Online Master Sheet for all items that are not listed on the new price sheet for the Brand you are working on.
Vince M.
95% (4)Projects Completed
5
Freelancers worked with
6
Projects awarded
50%
Last project
26 Nov 2018
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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