I had a data dump, spreadsheet style, from my old shopping cart.
I fairly carefully cleaned up the data, and assigned OSC Product IDs, and Customer IDs for the new customers, and Order IDs.
I worked in Access, and appended the new records to my local, empty MySQL database, then I dumped the data back out, and added it to my production database.
None of the IDs collides with the ones that were in OSCMax.
In the Admn, now, I can see the Customers I added, but not their orders.
There is some field in the query that I didn't fill in, likely. Can anyone tell me what it might be?
Or is it perhaps that I didn't add Orders_Total records...
Thanks,
Ken
Bookmarks