Home / Features / Products

Products, reviews, categories and tags

WooCommerce product import and export

Import and export simple, variable, grouped and external products with variations, images, attributes and custom meta. Reviews, categories and tags use the same screens. CSV is free; Pro adds Excel, XML and Google Sheets.

Product export

Types

Simple, Variable, Grouped, External

What moves

Everything attached to a product

A product is more than a title and a price. These are the parts you can move together.

Products

Simple, variable, grouped and external products with IDs, SKUs, attributes, gallery images, low-stock thresholds and custom meta.

Product import and export →

Reviews

Rating, content, author, verified-purchase flag and approval state. Reviews are matched to products by ID or SKU.

Order export and coupons →

Variations

Exported as their own rows, linked to the parent by parent SKU, with attribute, stock and price inheritance.

Images

Featured and gallery images move as URLs and are downloaded during import, with optional resizing.

Export

Filter products before they leave the store

Pull only the products you need. The export screen filters by status, product type, date range, category, tag, brand, stock status and a list of product IDs. Pick the columns you want and the file arrives without the noise.

Import

Import products from a CSV file in five steps

Do the dependencies in the order below so records can find each other.

Back up

Take a database backup, then install and activate the plugin. WooCommerce must be active.

Open Import

Go to WC Data Manager and choose Import, then Product.

Upload the file

Upload your CSV. Set the delimiter if it is not a comma.

Map columns

Headers that match are mapped for you. Assign the rest by hand.

Run and review

Start the import. Check the History tab for status and errors.

Full walkthroughs: how to import, variable products, product images and large catalogs.

Free vs Pro

What you get for products

The free Products plugin covers the core job. Pro adds formats and automation.

FREE

Products plugin

PRO

Pro plugin

Keep reading

WooCommerce Product Import: Bulk Import Products from CSV

Step-by-step guide

What Is the Correct WooCommerce CSV Format?

Field-by-field reference

Bulk edit WooCommerce products

Change prices and stock in one import

Migrate a WooCommerce store

Move products, orders and customers

Faq

Product questions

Can I import variable products with their variations?

Yes. Variations are exported as their own rows and linked to the parent through the parent SKU. They import back with attributes, stock and pricing intact. Keep the parent row in the file and match the SKU exactly.
Will importing overwrite my existing products?

A product whose ID or SKU matches an existing record is updated, not duplicated. A popup reminds you to back up before the import runs. Pro adds rules for skipping, updating or creating new.
How are product images imported?

Images travel as URLs. Each URL has to be publicly reachable and your host must allow outbound requests. For a big catalog, import the data first and add images in a second pass.
Is there a limit on the number of products?

No hard limit. Jobs run in batches, and you can set the batch size in Settings to balance speed against server load.
Can I import categories with their parents?

Yes. Parent categories are resolved by name or slug, and descriptions, thumbnails, display type and term meta come along.

Move your catalog without the cleanup

Install the free Products plugin and run a test import with ten rows.