Populate Product Spreadsheet with Details
Budget: $30 – $250 AUD
Job Title: Data Entry – Lookup & Complete Product Spreadsheet (1,376 SKUs)
Overview:
I have an Excel spreadsheet containing 1,376 product SKUs (item codes) and their quantities on hand.
Your job is to look up each SKU Product code on my supplier’s website (login access will be provided) and fill in missing product details in a new spreadsheet.
What You’ll Do:
Column A: Product Code
Search the SKU/item code on the supplier’s website.
Copy the exact product name/description into Column B.
Fill in the following:
Column C: Quantity on hand (already filled)
Column D: Retail Price (from website)
Column E: Trade Price (from website)
Column F: Total Retail = Quantity × Retail Price
Column G: Total Trade = Quantity × Trade Price
Column H: Product Category (based on item type: e.g. tapware, fittings, accessories, tools). Use broad categories only.
Overview:
I have an Excel spreadsheet containing 1,376 product SKUs (item codes) and their quantities on hand.
Your job is to look up each SKU Product code on my supplier’s website (login access will be provided) and fill in missing product details in a new spreadsheet.
What You’ll Do:
Column A: Product Code
Search the SKU/item code on the supplier’s website.
Copy the exact product name/description into Column B.
Fill in the following:
Column C: Quantity on hand (already filled)
Column D: Retail Price (from website)
Column E: Trade Price (from website)
Column F: Total Retail = Quantity × Retail Price
Column G: Total Trade = Quantity × Trade Price
Column H: Product Category (based on item type: e.g. tapware, fittings, accessories, tools). Use broad categories only.
Related categories:
Data Processing
Data Entry
Excel
Web Scraping
Data Cleansing
Data Analysis
Data Collection
Data Management