Closed

Extract, Arrange, Categorise & Verify Product Data. Compile "Master Spreadsheet" for bulk ecommerce upload.

This project received 33 bids from talented freelancers with an average bid price of $133 AUD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 AUD
Total Bids
33
Project Description

We require a freelancer to extract product information from supplied catalogues, image folders & product data sheets (.xls & .pdf files), then arrange this data into the appropriate columns in our 'master spreadsheet' so it is in the correct format for upload to our ecommerce website.

The work required will be as follows:

-----------

PART ONE – Product Data:

We require you to extract information from PDF catalogues & product data spreadsheets (.csv or .xls files) & enter this information into the appropriate fields on our master spreadsheet (an .xls file) so we are able to upload these products to our site.

The columns in our master sheet are as follows, and we require you to enter as many as you can provide (image names / item name & description are most important) – see "SPORTE x [url removed, login to view]" for an example of what we are looking for once the master sheet is completed.

COLUMNS
(fill as many of these as possible – items in bold MUST be included):

• ItemNumber – eg. “PRODUCTA”
• ProductName eg. “Recycled PET Tote Bag”
• Description eg. “A tote bag made from 100% post-consumer PET….”
• Features
• Dimensions
• PrintArea
• BrandingOptions
• AvailableColours
• Category – (choose appropriate category for the product based on list of available categories - list will be supplied)
• ProductThumbnail - Image filename of corresponding image (eg. [url removed, login to view])
• ProductLargeImage – filename of the largest corresponding image ([url removed, login to view])
• ProductHighResImage - filename of the largest corresponding image ([url removed, login to view])
• LineDrawing filename – .pdf / .eps artwork for the file (if supplied)


--------

PART TWO – Multiple Product Images:

If there are multiple images for the same product, we will need you to include this data in the second spreadsheet attached “ sporte multi example”…
We need 2 spreadsheets back.

i.e. if a “Product A” has more than one image it should show this in the second spreadsheet as a new line for each image.

EXAMPLES

PRODUCT A - [url removed, login to view]
PRODUCT A - [url removed, login to view]
PRODUCT A - [url removed, login to view]
PRODUCT B - [url removed, login to view]
PRODUCT B - [url removed, login to view]
PRODUCT B - [url removed, login to view]

-------

PART 3 - Verify Data

We then ask you go through this data & check that each line in the spreadsheet (each product) has an image file name, matching product name, description etc to ensure that there will be no problems in the upload.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online