--- title: "WooCommerce Migration: Posts, Pages, Products, Orders, Customers, & Coupons (Complete Guide)" url: https://www.wpsyncsheets.com/woocommerce-migration/ date: 2024-09-21 modified: 2026-07-07 lang: en author: "Arpit G Shah" description: "Are you looking for ways to implement WooCommerce migration? Whether you are migrating from one WooCommerce store to another or a different CMS platform, in this article you learn: How..." categories: - "How Tos" tags: - "woocommerce coupons migration" - "woocommerce customer migration" - "woocommerce pages migration" - "WooCommerce Post Migration" image: https://www.wpsyncsheets.com/wp-content/uploads/2024/09/woocommerce-migration-2-1024x538.png word_count: 1315 --- # WooCommerce Migration: Posts, Pages, Products, Orders, Customers, & Coupons (Complete Guide) ![WooCommerce Migration ](https://www.wpsyncsheets.com/wp-content/uploads/2024/09/woocommerce-migration-2-1024x538.png) Are you looking for ways to implement WooCommerce migration? Whether you are migrating from one WooCommerce store to another or a different CMS platform, in this article you learn: - How to **export data **out of your WooCommerce website so that they can be imported to another website  - And how to **import data **into a WooCommerce store  The article will be WooCommerce-specific so it won’t cover the import of WooCommerce data into other CMS like Shopify, Magento, BigCommerce, or PrestaShop. We are only covering how to migrate WooCommerce to new site.  We will show you how to migrate posts, pages, products, orders, coupons, and customers (including users) with ease.  Without further ado, let’s dive into the tutorial.  ## WooCommerce Migration: Which Tool to Use? WooCommerce has an inbuilt import-export tool but it comes with a lot of limitations. It - Cannot migrate customers - Cannot import orders  - Cannot migrate orders and products in .xlsx or Google Sheets formats  This is why many WooCommerce store owners prefer using third-party import-export plugins. And while there are many import-export plugins out there, not all plugins can migrate WooCommerce data as well as a dedicated WooCommerce migration tool.  This is where the [**WPSyncSheets For WooCommerce**](https://www.wpsyncsheets.com/wpsyncsheets-for-woocommerce/) plugins come in.  We built this plugin specifically for WooCommerce migration.  It can import-export WooCommerce data like products, orders, customers, and coupons with ease.  For migrating posts and pages, however, you need the** [WPSyncSheets For Core](https://www.wpsyncsheets.com/wpsyncsheets-for-core/)** plugin.  In the next section, we will show you how to use these plugins to WooCommerce migrate data in and out of our store.  **IMPORTANT: **But before we proceed, it’s worth mentioning that WPSynSheets For WooCommerce comes in two forms.  There’s [**WPSynSheets For WooCommerce Lite**](https://wordpress.org/plugins/wpsyncsheets-woocommerce/) which is a free plugin and allows only the export of orders, products, customers, and coupons.  Then there’s [**WPSyncSheets For WooCommerce Pro**](https://www.wpsyncsheets.com/wpsyncsheets-for-woocommerce/) – the paid plugin that allows you to import and export all those data and costs $59 annually for a single website license.  In the following tutorial, we are using the Pro plugin but you can still follow the steps because the Lite plugin operates in the same way. It’s just that you can’t import data into your WooCommerce store using the Lite plugin. ## Import Export Orders, Products, Customers, & Coupons ### 1. Install & Activate WPSyncSheets For WooCommerce To start importing WooCommerce data, you need to first install and activate the WPSyncSheets For WooCommerce in your store.  Next, Pro plugin users need to activate their license which can be done by opening your WordPress dashboard and going to **WPSyncSheets → For WooCommerce → License**.  You will find your license in your WPSyncSheets account or your welcome email. Just add them to the site to activate the license. ![License Key ](https://www.wpsyncsheets.com/wp-content/uploads/2024/09/Migration-1-1-1024x394.png) ### 2. Connect Website With GDrive After that, it’s time to connect your website with your GDrive. Your store data will be exported in Google Sheets which is why the connection has to be made. WPSyncSheets For WooCommece will help you make that connection. All you need to do is go to **WPSyncSheets → For WooCommerce → API Integration**. Then open your Google Cloud Platform (or create an account if you don't have one already) and generate a **Client ID, Client Secret Key, **and **Client Token**. Here’s a guide on the same: [**Google Sheets API Settings**](https://docs.wpsyncsheets.com/wpssw-google-sheets-api-settings/). Add the Client ID, Secret Key, and Token to the API Integration page and hit the **Save **button.  Your store will be connected with your GDrive in a jiffy.  ![Google API Settings ](https://www.wpsyncsheets.com/wp-content/uploads/2024/09/Migration-2-1-1024x674.png) ### 3. Export WooCommerce Orders to Google Sheets We will first show you how to export orders from your WooCommerce store, and then in the next step, we will cover how to export products, customers, coupons, and events.  Go to **WPSyncSheets → For WooCommerce → Settings → Order Settings **and toggle on the **Order Settings **option.  As soon as you do that, the page will populate with many options.  Scroll down to the **Sheet Headers **section. These are the headings to Google Sheets columns where you will export your WooCommerce orders.  In order to remove any of the headers just **disable it **from the Sheet Headers section and re-enable them if you need to in the future.  ![Sheet Headers ](https://www.wpsyncsheets.com/wp-content/uploads/2024/09/Migration-3-1-1024x435.png) Here’s how the sheet headers will look on your Google Sheets: ![Sheet Header Google Sheet ](https://www.wpsyncsheets.com/wp-content/uploads/2024/09/sheet-headers.png) Next, scroll down to the **Sync Orders **section and choose the date range in case you want to export order data from within a certain timeframe. This is an option step. If you wish to export all orders, skip this step and move to the next one.  ![Sync Orders ](https://www.wpsyncsheets.com/wp-content/uploads/2024/09/woocommerce-export-orders-1024x252.png) ### 4. Review Miscellaneous Settings  We recommend taking a look at the other options on the Order Settings page and changing whatever needs modification.  For instance, in the **Default Order Status as Sheets **section, you can enable or disable sub-sheets within the Google Sheets where you will be exporting order data.  ![Default Order Status as Sheets ](https://www.wpsyncsheets.com/wp-content/uploads/2024/09/Migration-5-1-1024x400.png) This is what we mean by sub-sheets: ![Order Status ](https://www.wpsyncsheets.com/wp-content/uploads/2024/09/order-status-1024x147.png) You can also look into the **Select Category **section which allows you to set categories from which orders will be exported. Orders from categories that are not selected will not be exported.  ![Select Category ](https://www.wpsyncsheets.com/wp-content/uploads/2024/09/woocommerce-export-categories-1024x378.png) We recommend reviewing all the options before proceeding to the next step.  To export order data from your store to a Google Sheet, go to **Google Spreadsheet Settings → Create New Spreadsheet**, add a **name **to the sheet, and hit **enter**. A Google Sheet with that name will be generated.  Next, choose the **Select Existing Spreadsheet **option, select the Google Sheets that you generated, and hit the **eye **button to open the Google Sheets in a new tab or hit the **download **button to download the spreadsheet to your local computer.  ![Google Spreadsheet Settings ](https://www.wpsyncsheets.com/wp-content/uploads/2024/09/m-7-1024x254.png) If you need more assistance, please consult this article: [Import Export WooCommerce Orders](https://www.wpsyncsheets.com/how-to-import-export-woocommerce-orders-step-by-step-guide/). ### 5. Export Products, Customers, & Coupons The steps for exporting products, customers, and coupons are almost identical to exporting orders. The only difference that instead of using the Order Settings page, you need to navigate to the **Product Settings**, **Customer Settings**, and **Coupon Settings **pages.  You will be generating a new Google Sheet for products, customers, and coupons. ![Export Product, Customer, Coupon Settings ](https://www.wpsyncsheets.com/wp-content/uploads/2024/09/m-8-1024x407.png) For assistance, use the following guides and help docs: - [**Import Export WooCommerce Products**](https://www.wpsyncsheets.com/import-export-woocommerce-products/) - [**Migrate WooCommerce Customers**](https://www.wpsyncsheets.com/migrate-woocommerce-customers/) - [**WPSyncSheets For WooCommerce Help Doc**](https://docs.wpsyncsheets.com/wpssw-introduction/) ### 6. Import Orders, Products, Customers, & Coupons By now you should have four different Google Sheets with exported data of orders, products, customers, and coupons. You will use these spreadsheets to import new orders, products, customers, and coupon data into your WooCommerce store.  First, open the dedicated **Settings** pages for orders, products, customers, and coupons. Then scroll down to the **Import **section, enable it, and then enable the **Insert, Update, and Delete **options. Go to the Sync section and hit the **Click to Sync **button. This will add new columns to the four Google Sheets you generated with exported data.  You will use these columns to import new data into your store.  ![Add Column Sheet ](https://www.wpsyncsheets.com/wp-content/uploads/2024/09/add-column-1024x418.png) We have already covered how to import data in the following help docs:  - [**How to Import Orders**](https://docs.wpsyncsheets.com/how-to-import-orders/) - [**How to Import Products**](https://docs.wpsyncsheets.com/how-to-import-products/) - [**How to Import Customers**](https://docs.wpsyncsheets.com/how-to-import-customers/) - [**How to Import Coupons**](https://docs.wpsyncsheets.com/how-to-import-coupons/) ## Import Export Posts & Pages The steps to import export posts and pages are identical to those covered in the previous section. We have written separate guides for posts and pages. Kindly follow them:  - [**How to Import Export Posts**](https://www.wpsyncsheets.com/import-export-wordpress-posts/) - [**How to Import Export Pages**](https://www.wpsyncsheets.com/import-export-pages-wordpress/) That’s it, folks! Now you know how to migrate WooCommerce to another site.  ## Conclusion Migrating WooCommerce websites can feel like a daunting task but with the help of proper import-export plugins, it's not as time-consuming nor as difficult.  While there are many import-export plugins out there not every plugin can handle the migration of the WooCommerce store.  We have a dedicated plugin called [**WPSyncSheets For WooCommerce**](https://www.wpsyncsheets.com/wpsyncsheets-for-woocommerce/) that helps import export orders, products, customers, and coupons without breaking a sweat. You can migrate posts and pages, using the** [WPSyncSheets For Core](https://www.wpsyncsheets.com/wpsyncsheets-for-core/)** plugin.  That’s it for this one folks! If you have any questions about WooCommerce migration, let us know in the comment section below.