You will be given a excel workbook with one primary contact worksheet as master list and merge with 3 other contact worksheets base on the following:
[url removed, login to view] ecommerce data base- This is the database that came out of our existing ecommerce site ( kecommerce). It has very limited information put has the most current email addresses. The address should be the same as what is in [url removed, login to view] all primary address export file.
[url removed, login to view] Import def and [url removed, login to view] Definitions- Check the final import file to make sure that all the data is format to this specification.
The below worksheets will be the data to merge in order. Meaning the fields will be imported into the master database using the following a. Primary ecommerce as the primary but import any other data of the 3 databases GP, GP email, GL shipping and lastly Goldmine that has all the custom fields (Orange column).
The primary field ( yellow) will be the customer number in all the databases.
If there are duplicate data in all fields you will take the most current in order from from 1-4
The Shipping address will have the same primary customer number as the main primary customer number and will be import as shipping addresses and nothing else.
You will need to also separate the First and last names ( Pink columns)
Blue columns will have a value of True
Important Note: You will see one columns that has Customer new number (Gray Column) this will be the new account number for the customers that alpha acct numbers and will be replace at time of import with numeric )
Need the final import file no later than Wednesday.
Preferably like for you to do this remotely along with voice Skype. I have a hard time explaining this in writing but it would be very simple once you get online and we talk. I see no reason why this would take more than 1 hour. We can import this into sql to write the queries and once clean up then could be exported to a csv export file