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