Re-formatting Excel Data

Closed - This job posting has been filled and work has been completed.
Accounting & Consulting Other - Accounting & Consulting Posted 2 years ago

Fixed Price

Delivery by July 12, 2013




Re-formatting Excel Data
Attached are two .csv files that need to be reformatted to the format accepted by our e-commerce system.
The columns you will be working with are:
• !PRODUCTID - This matches the variant to the product it will be listed on.
• !VARIANTID - This is a unique ID for the variant.  There should only be one of each of these.
• !VARIANTCODE - This is the SKU which matches the accompanying options.
• !CLASS - This describes the type of option in the column to its immediate right.  Each line must have a class to match the option.  They are already matched up.
• !OPTION - This is the option, which is part of the variant (a combination of options creates a variant).  Each line must have an option, and it must match with the function to its left.  They are currently matched, so it important to keep the option and class side by side.

About the Client

(4.99) 35 reviews

United States
Philadelphia 08:19 PM

84 Jobs Posted
52% Hire Rate, 2 Open Jobs

$5,343 Total Spent
49 Hires, 0 Active

$2.00/hr Avg Hourly Rate Paid
2 Hour

Member Since Feb 3, 2011