Knowing I also need to import orders and have everything linked correctly (orders+customers+products bought). I’m using Webtoffee Import Export on both sites for this.
Hi @elisagilis,
If you are receiving ID conflict during import then you can overcome this by either unmapping or deleting the ID column during import. WordPress will automatically assign the next available ID to the imported users.
What about orders then? How would they be linked to the right customer without the ID?
I tried editing the CSV file to change customers IDs before asking here, which resolved the conflict issue, but then orders would be labelled as ‘guest customer’ instead of being linked to the right customer.
Hi @elisagilis,
The order and user are linked using the email address and not the ID. Just make sure that the email address in the order import file and the email of the user are the same.
Hi,
I just double-checked, and they are?! Still, it says ‘Guest’ instead of linking to the right customer.
Should I try removing the customer ID columns in both orders.csv and customers.csv?
I figured out what was wrong: I had the billing email, not the customer email in orders.csv
I tried an import unmapping the ID and so far so good. This was on a clean database though, so I’ll give it another try with already a few users/orders in there to see how that goes.
There’s no risk of overriding previous orders/customers if I unmap the ID, is there? Any other necessary precautions?
Hi @elisagilis,
The already existing orders and customers will not be overridden if the ID is unmapped. WordPress will assign the next available ID to the imported orders.
Just make sure that you move the users and products first before importing the orders for successful linking.
Hi @webtoffee
I’ve tried importing orders into an existing staging store. Some of them failed because of existing post IDs (Pages and posts, images).
861 392 – About Importing order(ID) conflicts with an existing post.
Do I need to unmap order IDs as well? If so, I can’t see an option for me to do that?
Hi @elisagilis,
You may please delete the order ID of the conflicting orders from the CSV file and then import.
