Export/Import WooCommerce Orders and Customers
Vložit
- čas přidán 30. 07. 2024
- In this video, you will learn how to successfully migrate WooCommerce customers and orders between two sites without changing the customer’s password or over writing existing orders and post IDs👇
-- PLUGINS NEEDED FOR MIGRATION --
Below are the following plugins we use in this tutorial:
🚀 CSV Export plugin: sgwp.dev/9f8eb
🚀 CSV Import plugin: sgwp.dev/ce590
-- OPTIONAL PLUGINS --
- Disable Emails plugin: sgwp.dev/disable-emails
- Sequential Order Numbers Pro plugin (PRO): simongondeck.com/go/sequentia...
Here's a breakdown of what you'll learn:
First, you'll purchase, download and activate the Order/Customer CSV Export and CSV Import plugins to complete the migration.
Next, we export our customers from Site A to a CSV file.
Then, we will import the customers into Site B.
Next, we will export our orders from Site A.
Then, it's time to import the orders into Site B. But before we import the orders into the destination site, we need to download the Disable emails Plugin to make sure order notification emails do not send.
Finally, it's time to import your orders into Site B.
Of course before importing all orders, I recommend to import 1 single order first in case something goes wrong. Then, if everything goes smoothly, import the rest of the orders into Site B.
In short, if you want to learn How To Migrate WooCommerce Customers and Orders between sites, I recommend checking out today's video.
Want to see the full written tutorial? Check it out at: sgwp.dev/moving-orders
Timemarkers:
00:00 Introduction
02:49 Install and set up WooCommerce Customer/Order CSV Export plugin
04:24 Export customers from Site A
05:08 Install and set up WooCommerce Customer/Order/Coupon CSV Import plugin
07:46 Import customers to Site B
10:53 Export orders from Site A
11:48 Import orders to Site B
17:27 Install and use WooCommerce Sequential Order Numbers plugin
18:36 Troubleshoot orders that didn't import
24:55 Summary
⚡ Related Content
- How to export Woo Customers? • How to Export WooComme...
- How to import WooCommerce Customers? • How to Import WooComme...
- How to migrate WooCommerce Orders and Customers (another example) • How to Migrate WooComm...
- How to setup Sequential Order Numbers Pro plugin? • WooCommerce Sequential...
🚀 SUPPORT THE CHANNEL
If you want to support the channel, migrate to my favorite fast and easy to setup WordPress hosting provider: simongondeck.com/go/kinsta/
-- DESK SETUP --
Standing Desk: amzn.to/40QdBO6
Monitor: amzn.to/3E8Sa0T
Monitor Arm: amzn.to/3YzegC8
Power Hub: amzn.to/3Ikj3kV
Cable Management Tray: amzn.to/3xmZy57
Microphone: amzn.to/413zgT8
Boom Arm: amzn.to/3Ile8jP
Logitech C922 Webcam: amzn.to/3XrT3Zl
Desk Video Light: amzn.to/3XnAWUd
Headphones: amzn.to/3xgZHXE
Keyboard: amzn.to/3xmFobe
Logitech Mouse: amzn.to/3KcMvKW
Xbox Controller: amzn.to/3IkObAJ
Laptop Stand: amzn.to/3K873V1
Stool: www.autonomous.ai/fitness/erg...
Lightstrip: amzn.to/3lwqtbU
Chair: amzn.to/3YS37Mt
Macbook Pro '15: amzn.to/3k1pO1H
SanDisk 500GB External SSD: amzn.to/3K6IvvO
#WooCommerce
DISCLOSURE: We often review or link to products & services we regularly use and think you might find helpful. Wherever possible we use referral links, which means if you click one of the links in this video or description and make a purchase we may receive a small commission or other compensation. - Jak na to + styl
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
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?
@@jamesgriffith5128 yes you can delete the plugin and you have completed the import.
@@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?
@@jamesgriffith5128 correct!
@@simongondeck Thank you. I have learned so much from your tutorial. Definitely the best on this subject on CZcams!
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!
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 :)
Thanks for the video. I've always had a morbid fear of woocommerce orders and customer import/export, nice to see it stepped through.
@Abi, no problem and glad it was helpful!
im subscribing right away! a really educational video with some detailed and insightful fixes! much needed!
thank you for the feedback! I will strive to only make high-quality content like this!
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.
amazing video . very good example !
thanks!
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?
Great video. Thank you
What if the order still in progressing status? will there be any problem? please answer
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?
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.
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
Thanks for the video. but i have question, how if there plugin working automatic? it means always migrate costumer to site B
Can you provide more detail on your question? Are you referencing if the plugin is migrating the customer to Site B?
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.
for sure Brian. The dry run feature is awesome!
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?
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!
@@simongondeck thanks for following up so quickly, I appreciate it and your tutorial was very helpful!
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!
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.
I'm not sure if this is wordpress to wordpress store migration or can I export wordpress orders to Shopify?
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 :)
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?
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: czcams.com/video/rsMwOxLdewQ/video.html or sgwp.dev/moving-orders/. Did this help or still having issues? Let me know!
@@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?
Can I export using this plugin from WooCommerce to SnipCart/Webflow?
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.
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 :(
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
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
@@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?
@@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...)
@@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
This looks like affiliate marketing, am I correct? You are getting a commission for each plugin that is sold via this page?
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 CZcams videos and need to make money somehow 😎
Skip to 2:00
Thanks for the insight Brad! Did you find the video helpful?
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
You are not wrong. WooCommerce should include both export/import plugins as apart of their core :)
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 :)
@@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...
@@gsboss81fr @WebToffee has released an import/export suite that might help: www.webtoffee.com/product/woocommerce-import-export-suite/