WooCommerce products often need to be imported and exported in bulk, especially as a store grows. Tasks like syncing with a supplier feed, migrating from another platform, or even just backing up product information all depend on seamless importing and exporting of WooCommerce product data.
WooCommerce, however, does not have a built-in system for importing and exporting products at scale. This is where WP All Import and WP All Export come in. Both plugins are built specifically to fill that gap, giving store owners a way to move product data into WooCommerce or out of it, field by field, without manual entry. This guide covers the complete workflow for both directions.
📑 Table of Contents
Importing WooCommerce Products
The Basic WooCommerce Product Import Loop
The core WooCommerce product import workflow happens in four quick steps with WP All Import:
- Start the import. Go to All Import → New Import from the WordPress admin dashboard. Upload a CSV, Excel or XML import file and choose WooCommerce Products as the import type.
- Add filters (if needed). Click Create Filters to get access to the Review Import File screen. From here you can review the incoming data and add filters to limit the number of products that will be imported. If not required for the import, click Set Up Import to proceed.
- Map the fields. On the Drag & Drop screen, map the data elements from the import file on the right to the corresponding fields on the left. There are multiple panels for each data category, e.g., Title & Description, WooCommerce Add-On, Images, Custom Fields, etc. Go section by section to fully connect each data element. Click Continue to Import Settings to move to the final steps.
- Review import settings, then run the import. On the Import Settings screen, configure a Unique Identifier for the import and set options for what happens if the import is run again. Click Continue to reach the Confirm & Run screen, review the import summary, and then click Confirm & Run Import to execute the import.
The imported products appear immediately under Products → All Products. Review them to ensure everything is as it should be.
What You Can Import for WooCommerce Products with WP All Import
Beyond the simple WooCommerce product import covered in the previous section, WP All Import also handles other more complex product data. It maps into WooCommerce for:
Products with images
A product rarely only has one image attached to it. WP All Import maps featured images and gallery images from file paths or URLs in the same product import, so a full visual listing goes live without requiring a separate media step. See more details in How to Import WooCommerce Products with Images.
Variable products
When you have a product offered in five colors and four sizes, it isn't twenty separate products; it's one product with twenty variations. WP All Import imports the parent product and every variation together, each retaining its own SKU, price, and inventory count. How to Import and Export WooCommerce Variable Products covers this in detail.
Product attributes
It doesn’t matter whether it's a size chart shared across the whole store or a one-off spec for a single product; WP All Import is built to import both global and custom attributes, including the attributes that define variations. See How to Export and Import Product Attributes in WooCommerce.
Product categories
WP All Import ensures that products with categories land in the right place in the catalog structure on import. Existing category hierarchies are respected, and new categories are created automatically when needed. See How to Export and Import Product Categories in WooCommerce.
Product tags
Similar to product categories, WP All Import makes it possible for product tag assignments to import alongside the product, applying existing tags or creating new ones as needed. See How Do I Import Product Tags in WooCommerce.
Custom fields
If your store uses ACF, Meta Box, or JetEngine to create custom fields for WooCommerce products, WP All Import can import that field data directly into products, alongside standard WordPress custom fields. More details can be found in How Do I Import Custom Fields to WooCommerce Products?
Product reviews
With WP All Import, reviews import either alongside the products they belong to or as a standalone import into an existing catalog, useful for migrating a store's full review history. See How to Import and Export Product Reviews in WooCommerce.
Product prices
For catalogs that just need updated pricing, WP All Import can run an update-only import that touches nothing but the price field. Details for this can be found in WooCommerce Update Product Prices.
Subscriptions are the exception. Since subscription data lives in WooCommerce order records, not product records, it's handled through a separate workflow. See WooCommerce Export Import Orders: The Complete Guide.
Advanced WooCommerce Product Import Capabilities
Scheduling recurring product imports
For supplier feeds or data sources that update regularly, the idea of running the import manually each time isn't practical. WP All Import is able to trigger the import automatically on a set interval, with the setup explained in How Do I Automatically Import Products into WooCommerce?
Bulk uploading variable products
Having to add hundreds of variable products individually to a WooCommerce store would take far too long and isn’t practical in the long run. WP All Import brings in the full batch, parent products and every variation, in one pass. See How Do I Bulk Upload Variable Products in WooCommerce? for details.
Importing products from Amazon
Store owners expanding beyond Amazon marketplace selling can bring their existing listings into WooCommerce directly. The mapping process is explained in How To Import Amazon Products to WooCommerce.
Importing products from Shopify
A Shopify export doesn't map cleanly to WooCommerce's product structure without some translation. WP All Import handles that translation automatically, with the process covered in How To Easily Import Products From Shopify to WooCommerce.
Bulk editing products via Import
Making updates to products in a WooCommerce catalog, such as updating pricing information or correcting stock details, works through an export, edit, and reimport cycle. The full workflow is detailed in How to Bulk Edit WooCommerce Products in Simple Steps.
Exporting WooCommerce Products
The Basic WooCommerce Product Export Loop
Exporting a WooCommerce product with WP All Export mirrors the steps covered in the import loop, but just in reverse:
- Start the export. Navigate to All Export → New Export from the WordPress admin dashboard and select WooCommerce Products as the post type. WP All Export shows a summary of how many products are available to export. There’s also a panel with filtering options to narrow the export to records matching specific criteria. Add filters if necessary and then click Customize Export File to proceed.
- Choose the fields. On the Drag & Drop screen, the available WooCommerce product fields such as title, price, SKU, description, and more are listed and organized by category, ready to drag into the column selection area. You can do this in whatever order makes sense for the export.
- Choose the format. Expand the Export Type panel and pick Spreadsheet for CSV or Excel output, or Feed for XML, then select the specific format from the dropdown.
- Run the export. Click Continue to proceed to the Export Settings screen. Then click Confirm & Run Export to execute the export.
What You Can Export for WooCommerce Products with WP All Export
Just like WP All Import, WP All Export goes well beyond handling just the simple product export scenario that’s covered in the basic loop section. Other layers it covers include:
Products with Images
WP All Export supports featured images and full product galleries export alongside product data, with image URLs included in the file so they can be reimported or referenced elsewhere. See Export WooCommerce Products with Images.
Variable Products
A product with multiple variations is exported as one structured record with WP All Export. Every variation's SKU, price, and stock level is included. More information on this is provided in How to Import and Export WooCommerce Variable Products.
Product Attributes
Global and custom attributes are exported seamlessly with WP All Export, including variation-defining attributes. See How to Export and Import Product Attributes in WooCommerce for details.
Product categories
It doesn’t matter if a product is assigned to just one category or a hierarchical one; WP All Export handles it all, preserving parent/child dependencies. Useful for auditing catalog structure or migrating to a new store. More details can be found in How to Export and Import Product Categories in WooCommerce.
Product tags
Like with product categories, WP All Export handles product tag exports efficiently, ensuring that tag assignments export alongside product data. See How Do I Export Product Tags from WooCommerce?
Product reviews
WP All Export exports review data on its own or bundled with the products it belongs to, useful for preserving review history during a migration. See How to Export and Import Product Reviews in WooCommerce for details.
Custom fields
With WP All Export, ACF, Meta Box, and JetEngine product field data can be selected in the export field list to ensure a more comprehensive WooCommerce product export. How Do I Export Custom Fields from WooCommerce covers this.
Advanced WooCommerce Product Export Capabilities
Filtering which products get exported
An export does not have to include all products in the catalog every time. WP All Export includes a filtering mechanism to limit an export to specific categories, stock statuses, product types, or any other product field, covered in Filter Exported WordPress Data.
Scheduling recurring product exports
Backups and sync feeds that need to stay current can't rely on someone remembering to run the export manually. WP All Export's scheduling functionality handles this, detailed in How Do I Schedule Product Exports in WooCommerce.
Generating a Google Merchant Center feed
Google Shopping requires that product data is presented in a very specific way a standard export does not produce. To fill this gap, WP All Export includes a purpose-built Google Merchant Center export type, covered in How to Export WooCommerce to the Google Merchant Center.
Passing exported data through custom PHP functions
WooCommerce product fields that need to be built on the fly, combined from multiple sources, or reformatted before export aren't limited to what's available in the Available Data panel. WP All Export supports custom PHP functions for this, detailed in How to Pass Exported WordPress Data Through PHP Functions
Why Use WP All Import and WP All Export for WooCommerce Product Import and Export
Most store owners can attest to the fact that a store’s product data needs rarely stay fixed. What starts as a simple CSV import for a handful of products often grows into scheduled supplier syncs, platform migrations, or Google Merchant Center feeds.
WP All Import and WP All Export are built to handle both ends of that progression without requiring a different tool once the requirements get more complex. The same plugin pair that imports and exports a single product in under a minute also handles thousands of variable products with custom fields and recurring schedules.
Ready to bring speed and efficiency to your import and export tasks for WooCommerce products? Sign up today or test drive the features for free with a live demo.
WooCommerce Product Import and Export —Frequently Asked Questions
WP All Import and WP All Export are the best import/export plugins for WooCommerce, built specifically for moving WooCommerce product data in both directions. WP All Import handles bringing products in, and WP All Export handles pulling them out, both through the same Drag & Drop field-mapping interface. They cover simple products, variable products, images, attributes, categories, custom fields, and everything else in between.
The type of file you need to import products in WooCommerce is CSV, Excel, or XML. WP All Import reads all three formats and automatically configures its field-mapping screen based on which one is uploaded. This ensures that no manual file conversion is required beforehand.
You can export all products from WooCommerce with WP All Export. The steps are as follows:
Go to All Export → New Export
Select WooCommerce Products as the post type
Leave filtering blank to capture the entire catalog
Select fields in the Drag & Drop screen
Choose CSV, Excel, or XML as the export file type, click Confirm & Run Export, then download the file as CSV, XML, or Excel
You can import/export products from WooCommerce with WP All Import and WP All Export. WP All Import handles the import side and WP All Export handles the export side, both using the same Drag & Drop mapping approach. To import: go to All Import → New Import, upload a file, map the columns to WooCommerce fields, and run the import. To export: go to All Export → New Export, select the fields to include, choose a format, and run the export.
