Export/Import WooCommerce Orders and Customers

[@simongondeck]

Hi guys! If your products on Site A and Site B don't have the same product IDs, ensure to add SKUs to your products on Site A before exporting your orders. Then, on Site B, upload/merge your products with updated SKUs to ensure your imported orders don't get skipped. You also could enable the option to "allow unknown products" during the import order process. Also see the FAQs here: sgwp.dev/moving-orders/#faqs. Let me know if you have any questions! 👉 CSV Export plugin: sgwp.dev/9f8eb​ 👉 CSV Import plugin: sgwp.dev/ce590

[@jamesgriffith5128]

Once you have installed the Disabled Email plugin and then imported the customers and orders can you delete the Disabled Email plugin? Because if its an Ecommerce website you will obviously be getting new orders and will need to have the Woocommerce emails going out again. Please give me your advice about this?

[@simongondeck]

@@jamesgriffith5128 yes you can delete the plugin and you have completed the import.

[@jamesgriffith5128]

@@simongondeck So as soon as the import is completed you can delete the Disable Emails plugin and you will get no automated Woocommerce emails sent?

[@simongondeck]

@@jamesgriffith5128 correct!

[@jamesgriffith5128]

@@simongondeck Thank you. I have learned so much from your tutorial. Definitely the best on this subject on KZbin!

[@FarzadKeyhani]

Thank you for your your very complete tutorial, I am just wondering if there is anyway that we can keep both "Post ID" and "Order ID" for the WooCommerce orders when importing to the staging site (Site B)? I understand that by use of WooCommerce Sequential Order Numbers plugin, we can have the similar Order Numbers in both sites, my main concerns is when the "Post ID" changes, it wont be same to "Order ID" in the URL. This is causing wrong mapping for my custom integration and zappier plugins.

[@Brocollipy]

Thanks for the video. I've always had a morbid fear of woocommerce orders and customer import/export, nice to see it stepped through.

[@simongondeck]

@Abi, no problem and glad it was helpful!

[@raygringo]

Really appreciate you taking the time to make this video. I was faced with the very same scenario as in this video and following your tutorial saved the dy. Cheers!

[@simongondeck]

Glad it was helpful Ray! Sometimes I make these videos and do not know if others will be in this exact situation lol. Thank you for watching :)

[@Taha_Edits25]

Thank you very much for your effort. What I want to ask is, are the IDs of the products on the old site that we want to transfer transferred to the new site as is, or are they given a new ID?

[@gurushakti69]

im subscribing right away! a really educational video with some detailed and insightful fixes! much needed!

[@simongondeck]

thank you for the feedback! I will strive to only make high-quality content like this!

[@sidiq_eq]

Thanks for the video. but i have question, how if there plugin working automatic? it means always migrate costumer to site B

[@simongondeck]

Can you provide more detail on your question? Are you referencing if the plugin is migrating the customer to Site B?

[@RS-lq2ek]

When I exported the orders from site A and imported in site B it was not showing users subscriptions in woocommerce subscription area and users were also not able to see their subscription in their account area, I chose the options "Export subscription Order " when I was exporting orders from Site A.

[@simongondeck]

Exporting and Importing subscription orders is complicated. The reason users are not seeing their 'subscriptions' is cause you most likely only exported the subscription orders and not their "subscription". For example, are you seeing users 'subscriptions' under WooCommerce > Subscriptions? Each 'subscription' has related orders that contain the parent order and then the renewal orders. The parent order and renewal orders are separate from the 'subscription'. To export/import 'subscriptions' (not orders that are apart of a subscription), I would use WooCommerce Subscriptions Importer and Exporter: github.com/woocommerce/woocommerce-subscriptions-importer-exporter

[@kokomei8619]

After site B goes live and you're ready to accept woocommerce orders and send emails, I'm guessing you must deactivate the "deactivate emails" plugin. My question is, will doing that trigger the emails you didn't want to send from the imported orders or will the system just resume sending emails from new activity/orders?

[@simongondeck]

It will not trigger the emails you didn't want to send. It will only allow emails from new activity orders. Let me know if any other questions!

[@kokomei8619]

@@simongondeck thanks for following up so quickly, I appreciate it and your tutorial was very helpful!

[@capturedbybasman1536]

Great video. Thank you What if the order still in progressing status? will there be any problem? please answer

[@BradleyStockAu]

Skip to 2:00

[@simongondeck]

Thanks for the insight Brad! Did you find the video helpful?

[@Vimalanvijay]

Can I export using this plugin from WooCommerce to SnipCart/Webflow?

[@simongondeck]

If migrating from WooCommerce to SnipCart this would be a awesome plugin to use to export all your orders and customers into a CSV file to re-import to SnipCart.

[@dezignationNYC]

I'm not sure if this is wordpress to wordpress store migration or can I export wordpress orders to Shopify?

[@simongondeck]

Hey there! The tutorial is for WordPress to WordPress but the CSV Export plugin (in description) can be used to export all orders and prepare to import to Shopify. Hope this helps :)

[@RS-lq2ek]

When I exported customers from site A(old) to site B(New) customers are not able to login with passwords, and i do not see password column in the exported file as I see in this demo video, I have tried both with or without hashing the password it's still not working, any suggestions to fix this?

[@simongondeck5762]

Are you using the CSV Export and CSV Import suite plugins that are in the description box above? Also, are you exporting your customers in the "CSV Import" format. For example, see on this video: kzbin.info/www/bejne/qKSwqIKugcmYrbM or sgwp.dev/moving-orders/. Did this help or still having issues? Let me know!

[@RS-lq2ek]

@@simongondeck5762 yes, I'm using the CSV IMPORT and VSV Export plug-in, and I'm exporting them as CSV format, any thoughts why its not showing up paswords column in the export file?

[@marekwisniewski997]

one question: is it possible to migrate orders and avoid changing orders id? Once I used this plugin. I had the new version od data csv and imported this into the wordpress after clearing all old version. The result: my imported orders get new order ID :( :( :( and it was realy big problem - or rather disaster. :( :( I havn't found any trick to avoid order ID changing and definietely resigned from this plugin as it was not useful. It was better to merge those data manually :(

[@simongondeck]

Did you watch the entire tutorial? Go back and watch at 13 minutes for how I formatted the CSV file to not include the "order id" column. You can also reference this starting at 17 minutes into the video. To solve this you need to purchase, install and download the Sequential Order Numbers plugin (link in bio). See the FAQ on my site here: sgwebpartners.com/moving-orders-in-woocommerce/#faqs

[@marekwisniewski997]

I will eatch it once again carefully, however my problrm was how to keep orders id unchanged (keep it the same as it is in imported file). If my order id in imported file is for example #234, i want it to be still #234 even if i import this file into empty woocommerce

[@simongondeck]

@@marekwisniewski997 can you explain in more detail why you are migrating your orders between sites? For example, are you developing a new site on a staging server at the moment? Are you just switching hosting providers?

[@marekwisniewski997]

@@simongondeck Yes - I was developing my site and everythig was changed - i just wanted to move orders from old version to new version - however inside new version there was a lot of test orders - so i cleared them and tried to move data from the old site to the new site and keep orders' numbers. But even if I clear all test orders in new site, the orders numbers after import changed, starting from first number after the last order number of cleared orders. For example the numbers of test orders in new version were 1,2,3. I cleared them and imported orders from old site which had numbers 1,2,3,4,5. After import, #1 changed to #4 (as a continuation of 1,2,3...)

[@simongondeck]

​@@marekwisniewski997 I would recommend using the Sequential Order Numbers plugin to align the order numbers from your old site to new site. I go over this in the video: sgwp.dev/dw1

[@lraloeveraproducts6126]

Hi. Something is wrong. I used your tutorial and now first invoice from 04.04.2021 is number one and invoice from 1 january is 84. What to do?

[@BrianOpyd]

Great video, I like the dry run feature, I've used Webtoffee before, and I don't think they have that same feature available. I could see how the dry run feature could be extremely useful to ensure you don't mess something up.

[@simongondeck]

for sure Brian. The dry run feature is awesome!

[@maestro7676]

So, I need tobuy 2 plugins and spend 158 USD to move customers and orders from a site to another. I think is not fair to sell 2 plugins for the same use. Very unfair I see around cloud services that cast 50 USD. I suggest everyone to use those

[@simongondeck]

You are not wrong. WooCommerce should include both export/import plugins as apart of their core :)

[@safwanata7960]

You can use this plugin www.webtoffee.com/product/order-import-export-plugin-for-woocommerce/ for both import and export functions on your WooCommerce website :)

[@gsboss81fr]

​@@safwanata7960 Yes, but you'll miss the customers data...so you may need another Pro plugin from Webtoffee for that (69$ as well)... so, in conclusion, it's pretty much the same...

[@safwanata7960]

@@gsboss81fr @WebToffee has released an import/export suite that might help: www.webtoffee.com/product/woocommerce-import-export-suite/

[@FirebrandVOCALS]

Hi Simon, Just a Quick Noobie question here. When a customer registers and logs in to a site made with wordpress + woocommrece. Where is this imformation stored and how is it managed from within Wordpress. Cheers!

[@webbyvivvek]

customer registration and login information are stored in the WordPress database, managed through the Users section of the WordPress admin dashboard. WooCommerce extends this functionality to handle e-commerce-specific data, such as order history and billing addresses, stored in custom database tables.

[@entecodigitalrealestatemar8611]

Nice video!

[@gurushakti69]

amazing video . very good example !

[@simongondeck]

thanks!

[@BeFoundOnTheWeb]

This looks like affiliate marketing, am I correct? You are getting a commission for each plugin that is sold via this page?

[@simongondeck]

Scott Allen yes that is true :). I do use these plugins when migrating clients sites I do contract work though! I do not get paid by the plugin author to make these KZbin videos and need to make money somehow 😎