Title: Import data into existing database Last modified: March 2, 2021 --- # Import data into existing database * Resolved [elisagilis](https://wordpress.org/support/users/elisagilis/) * (@elisagilis) * [5 years, 3 months ago](https://wordpress.org/support/topic/import-data-into-existing-database/) * 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](https://wordpress.org/support/users/elisagilis/) * (@elisagilis) * [5 years, 3 months ago](https://wordpress.org/support/topic/import-data-into-existing-database/#post-14120805) * 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](https://wordpress.org/support/users/webtoffee/) * (@webtoffee) * [5 years, 3 months ago](https://wordpress.org/support/topic/import-data-into-existing-database/#post-14121791) * Hi [@elisagilis](https://wordpress.org/support/users/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](https://wordpress.org/support/users/elisagilis/) * (@elisagilis) * [5 years, 3 months ago](https://wordpress.org/support/topic/import-data-into-existing-database/#post-14121852) * 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](https://wordpress.org/support/users/webtoffee/) * (@webtoffee) * [5 years, 3 months ago](https://wordpress.org/support/topic/import-data-into-existing-database/#post-14126324) * Hi [@elisagilis](https://wordpress.org/support/users/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](https://wordpress.org/support/users/elisagilis/) * (@elisagilis) * [5 years, 3 months ago](https://wordpress.org/support/topic/import-data-into-existing-database/#post-14126337) * 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](https://wordpress.org/support/users/elisagilis/) * (@elisagilis) * [5 years, 3 months ago](https://wordpress.org/support/topic/import-data-into-existing-database/#post-14126750) * 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](https://wordpress.org/support/users/webtoffee/) * (@webtoffee) * [5 years, 3 months ago](https://wordpress.org/support/topic/import-data-into-existing-database/#post-14132575) * Hi [@elisagilis](https://wordpress.org/support/users/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](https://wordpress.org/support/users/elisagilis/) * (@elisagilis) * [5 years, 3 months ago](https://wordpress.org/support/topic/import-data-into-existing-database/#post-14158809) * Hi [@webtoffee](https://wordpress.org/support/users/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](https://wordpress.org/support/users/webtoffee/) * (@webtoffee) * [5 years, 3 months ago](https://wordpress.org/support/topic/import-data-into-existing-database/#post-14160536) * Hi [@elisagilis](https://wordpress.org/support/users/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. * ![](https://ps.w.org/users-customers-import-export-for-wp-woocommerce/assets/ icon-256x256.gif?rev=3065206) * [Export and Import Users and Customers](https://wordpress.org/plugins/users-customers-import-export-for-wp-woocommerce/) * [Frequently Asked Questions](https://wordpress.org/plugins/users-customers-import-export-for-wp-woocommerce/#faq) * [Support Threads](https://wordpress.org/support/plugin/users-customers-import-export-for-wp-woocommerce/) * [Active Topics](https://wordpress.org/support/plugin/users-customers-import-export-for-wp-woocommerce/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/users-customers-import-export-for-wp-woocommerce/unresolved/) * [Reviews](https://wordpress.org/support/plugin/users-customers-import-export-for-wp-woocommerce/reviews/) ## Tags * [csv](https://wordpress.org/support/topic-tag/csv/) * 9 replies * 2 participants * Last reply from: [WebToffee](https://wordpress.org/support/users/webtoffee/) * Last activity: [5 years, 3 months ago](https://wordpress.org/support/topic/import-data-into-existing-database/#post-14160536) * Status: resolved