Mapping data for Magento product import

Closed - This job posting has been filled and work has been completed.
Web, Mobile & Software Dev Ecommerce Development Posted 1 year ago

Hourly Job

More than 30 hrs/week
More than 6 months

Expert Level

I am willing to pay higher rates for the most experienced freelancers


I can get multiple spreadsheets from vendors that each have partial product information, but when combined it contains the complete product import data that I need.  

I need a program that will allow me to import the various spreadsheets into a GUI-Graphical User Interface database, merge the data, map the data to my requirements, and export the data to an excel sheet.

The mapping of the requirements should be with a GUI-Graphical User Interface which shows the merged excel data and allows me to the data to predefined column titles/names.

Additionally the mapping will require to combine data from a few cells/fields.

Only apply to the job if you have strong background and programming experience which combines databases with Graphical user interfaces.

Please download excel files for future reference.

1. All products with UPC- this is the extended file with all options-Color-Sizes-Weight, case qty  and UPC codes
2.Copy of 2014 Dist price list- is the vendor price list with simple data
3.Copy of product import- this is the data we need
4.Occunomix joined with vendor spreadsheet 2013-11-03 - Site Scrape, Lots of data including Image url links

Please provide sample with required data.

About the Client

(4.37) 8 reviews

United States
Spring Valley 08:38 AM

26 Jobs Posted
43% Hire Rate, 2 Open Jobs

$813 Total Spent
14 Hires, 0 Active

$11.85/hr Avg Hourly Rate Paid
42 Hours

Member Since Dec 15, 2013