Moving your WooCommerce products from one store to another might feel a bit overwhelming, but it doesn’t have to be that way. Whether you’re starting fresh with a new store, rebranding, or just merging a few shops, you can skip the tedious hours of manually copying product details.
Thanks to WebToffee’s Product Import Export for WooCommerce plugin, the whole process is quick, reliable, and hassle-free. Say goodbye to those messy spreadsheets filled with errors or missing product info; you can export your products from the old store and import them into the new one in just a few clicks.
In this guide, we’ll show you how to effortlessly migrate your WooCommerce products using the free version of the WooCommerce Product Import Export plugin, so you can focus on what really counts: growing your store and serving your customers.
Exporting WooCommerce Products
To move your WooCommerce products, the first step is exporting them as a CSV file. With the Product Import Export for WooCommerce plugin, this process is simple. With just a few clicks, you’ll have a ready-to-import file generated for you.
Here’s a step-by-step guide to help you export your products with ease.
Step 1: Install WebToffee Product Import Export Plugin
From your WordPress dashboard
- Go to Plugins > Add New Plugin.
- Search for the plugin “Product Import Export for WooCommerce”.
- Once found, Install and Activate the plugin.
Step 2: Select Product as Post Type
Once the plugin is installed and activated:
- Go to WebToffee Import Export (Basic) > Export from your WordPress dashboard.
- Under Post Type, select Product to specify that you want to export your store’s products.
- Click the Select an export method button to proceed to the next step.
Step 3: Select an Export Method
The plugin gives you two flexible ways to export your products:
- Quick Export: Perfect if you want speed and simplicity. This option instantly exports all your products along with their essential details in just one click.
- Advanced Export: Ideal when you need more control. You can customize your export by selecting specific products, choosing the fields you want, and applying filters to fine-tune the data.
Pick the method that best matches your needs. Whether it’s a full product dump for migration or a selective export for more focused tasks.
Step 3: Filter Export Data
This step lets you refine exactly which products get included in your export file. Instead of exporting your entire catalog, you can apply filters to narrow it down.
Step 4: Map & Reorder Columns
In this step, you decide how your product data will be structured in the exported CSV file. The plugin gives you full control over what to include and how it should appear:
- Choose exactly which product data fields (like SKU, product name, price, stock, categories, etc.) you want in your file.
- Customize the column headers by specifying the names you want to appear in the CSV. This is helpful if you’re migrating to another site or platform with different naming conventions.
- Use the simple drag-and-drop interface to rearrange the order of columns in your file, ensuring the output matches your preferred layout.
Step 5: Export Products
This is the final step in exporting your WooCommerce products. Here’s what you need to do before generating the CSV:
- Export file name: Specify a file name for your exported file.
- Export in batches of: Decide how many products will be processed in each cycle. For large stores, smaller batch sizes help prevent timeouts during export.
- Delimiter: Select the column separator for your CSV file (commonly a comma or semicolon). This ensures the file can be read correctly by your target system.
Once your preferences are set, hit the Export button. The plugin will generate the CSV file with your chosen settings, ready to be downloaded and used for import on your new WooCommerce store.
Once the export process is complete, a pop-up window will appear with a Download File button. Simply click this button to save the exported CSV file to your computer.
The file will include all the products and data columns you selected and filtered earlier, organized exactly according to your mapping and settings. This CSV is now ready to be imported into your new WooCommerce store.
Importing WooCommerce Products
Now that you’ve exported your products, the next step is to bring them into your new WooCommerce store. Using the Product Import Export for WooCommerce plugin, this process is just as simple as exporting.
Before you begin, make sure your CSV file is UTF-8 encoded to avoid errors with product names, special characters, or descriptions during the import.
Here’s how to import your products step by step:
Step 1: Select Product Post Type for Import
From your WordPress dashboard:
- Navigate to WebToffee Import Export (Basic) > Import.
- Under Post Type, choose Product to specify that you’re importing product data.
- Click Select Import Method to proceed to the next step.
Step 2: Choose Import Method
You have two ways to bring products into WooCommerce:
- Quick Import: Use this if the CSV was created with the same plugin. Just upload the file and click Import for a fast transfer.
- Advanced Import: Choose this for more control. After selecting this method, upload your CSV, select a delimiter (comma, semicolon, etc.), then click Map Import Columns to match fields before importing.
Step 3: Reorder Columns of the Products CSV File
Make sure your CSV columns line up with WooCommerce product fields:
- The plugin will auto-map columns if the headers match WooCommerce fields.
- If any don’t match, manually select the correct headers from the drop-down.
- Click Advanced Options to confirm and adjust settings if needed.
Double-check your mappings before proceeding. Accurate column alignment is key to avoiding import errors.
Step 4: Configure Advanced Import Options
Before importing, fine-tune the settings to control how products are handled:
- Choose to import or skip new products.
- Select ID or SKU for product matching.
- Decide whether to skip or update existing products.
- Set the batch size for imports.
Once your preferences are set, click Import to upload products from the CSV into your WooCommerce store.
Once the import is complete, all your WooCommerce products, along with their details, will be successfully transferred to your new store. This ensures your data stays intact and makes the setup process much smoother.
For even greater flexibility, consider upgrading to the premium version of the Product Import Export for WooCommerce plugin. The premium version unlocks advanced features like more detailed filtering, scheduled imports/exports, and broader support for product types, making large-scale migrations and ongoing store management even more efficient.
Conclusion
Migrating WooCommerce products doesn’t have to be stressful. With the WebToffee Product Import Export plugin, you can move products between stores quickly and accurately, saving time, avoiding errors, and keeping your business running smoothly.
By following the steps outlined in this guide, you’ll ensure a seamless product migration so you can focus on what really matters: growing your store and serving your customers.
And suppose you need to transfer more than just products. In that case, WebToffee also offers powerful plugins like WooCommerce Order Import Export and WordPress Users Import Export for importing and exporting orders and users, giving you a complete toolkit for store data migration.
We hope this guide helped simplify the process for you. If you have any questions or feedback, feel free to drop them in the comments.
