Import data into existing database

  • Resolved elisagilis

    (@elisagilis)


    4 years ago

    Hi,

    I need to import data I’ve exported from a WP+Woocommerce site (wholesale) into another WP+Woocommerce site with existing data (regular store).

    The problem I’m running into is users/customers are being skipped when importing because of matching IDs (although they’re not the same customers, different name, different email). What can I do to avoid this? I’m exporting as CSV using this plugin, and importing using this plugin as well.

    Thank you!

Viewing 9 replies - 1 through 9 (of 9 total)
  • Thread Starter elisagilis

    (@elisagilis)

    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.

    Plugin Author WebToffee

    (@webtoffee)

    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.

    Thread Starter elisagilis

    (@elisagilis)

    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.

    Plugin Author WebToffee

    (@webtoffee)

    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.

    Thread Starter elisagilis

    (@elisagilis)

    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?

    Thread Starter elisagilis

    (@elisagilis)

    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?

    Plugin Author WebToffee

    (@webtoffee)

    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.

    Thread Starter elisagilis

    (@elisagilis)

    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?

    Plugin Author WebToffee

    (@webtoffee)

    Hi @elisagilis,

    You may please delete the order ID of the conflicting orders from the CSV file and then import.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Import data into existing database’ is closed to new replies.

Tags