Mapping data for Magento product import

Mapping data for Magento product import

Closed - This job posting has been filled and work has been completed.

Job Description

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.
https://www.dropbox.com/sh/ytmz5ee55s9dg8k/27UsjGd4QM

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 - Occunomix.com Site Scrape, Lots of data including Image url links

Please provide sample with required data.

Other open jobs by this client