Importing Order Data (with Product Data) from an old store

[tonygets]

Hi,

I am trying to import Order Data from an old e-commerce store into AC 7.0.3

I have a CSV file containing all the Order Data, Product Data related to each Order and Customer Data related to each order. I am able to import Customer Data, Order Data and Product Data using the Dataport however I cannot match the imported Product Data to each related Order.

I plan to upload the Product Data and Order Data and obtain new Product and Order ID's, then ensure the new Product and Order ID's are matched to the previous Products and Orders in Excel via a VLookup.

Please advise what I need to know in order to write some type of script that will allow me to match the new Product IDs to their Related Orders in AC7?

Thanks and regards,

Tony

[igavemybest]

If you need any type of custome importer, please let me know. We have done a couple of custom importers for ac7.0.3 from csv files where the standard dataimporter was way too limited, including importing products in their categories and respective subcategories while creatiing all the categories they belong in, processing updates on the database, etc.