How to Export WooCommerce Products to CSV with Product Variations
To export WooCommerce products to CSV with product variations, open a supported WooCommerce store in Chrome, click WooCommerce Product Scraper & CSV Exporter, and choose Export Products. The extension creates a structured CSV file containing publicly accessible product data. When a variable product exposes native WooCommerce child variations through compatible public Store API responses, the related variation rows can be included with available attributes, SKUs, prices, stock details and image URLs.
A WooCommerce product CSV is useful when you need a product spreadsheet for catalog review, public product research, data organization or store migration preparation. Instead of copying product names, descriptions, SKUs, prices and images manually, you can organize the available catalog data in a downloadable file.
What is a WooCommerce product CSV export?
A WooCommerce product CSV export is a spreadsheet-style file in comma-separated values format. Each row represents a product record or, where available, a related variation record. Each column stores a particular field, such as the product name, SKU, category, regular price, sale price, stock status, description or image URL.
WooCommerce also provides a built-in CSV importer and exporter for store administrators. Official WooCommerce documentation explains that CSV files can be used to import large volumes of products, including attributes, categories and images, and to export product data for migration, backup and analysis. If you own the source store and have dashboard access, the native admin export is often the first option to consider. If you are reviewing a supported public catalog from the storefront, a browser-based WooCommerce product scraper can create a structured spreadsheet without requiring source-side admin access.
How variable WooCommerce products are different from simple products
A simple product is typically sold as one product record. A variable product can offer multiple native options, such as size, color or finish. WooCommerce documentation explains that variable products let merchants control details such as prices, stock and images for individual variations.
For example, a shirt may have a variable-product parent row and several child variation rows:
| Type | SKU | Attributes | Regular price | Stock status |
|---|---|---|---|---|
| Variable parent | TSHIRT | Color, Size | From 25.00 | In stock |
| Variation | TSHIRT-BLK-S | Color: Black | Size: Small | 25.00 | In stock |
| Variation | TSHIRT-BLK-M | Color: Black | Size: Medium | 25.00 | In stock |
| Variation | TSHIRT-WHT-S | Color: White | Size: Small | 25.00 | In stock |
This parent-child structure matters when you review, clean or migrate product data. A spreadsheet that shows only the parent product may hide important variation-specific details.
How the public WooCommerce Store API handles product variations
The WooCommerce Store API provides public product data so that products can be rendered on the storefront. Only published products are available through the Store API. WooCommerce developer documentation also states that variations are excluded from the default product listing and must be requested explicitly using the variation product type.
This explains why a basic product scraper may detect variable products but miss some child rows: it may retrieve the default product collection without separately requesting the publicly exposed native variations.
How to export WooCommerce products and variations to CSV
- Open a supported WooCommerce store. Visit the public storefront in Chrome.
- Click the extension icon. Open WooCommerce Product Scraper & CSV Exporter.
- Confirm store detection. The popup should indicate that the active tab is a compatible WooCommerce store.
- Select Export Products. The extension retrieves the publicly accessible catalog records exposed by compatible Store API responses.
- Download the CSV. Open the exported spreadsheet in Excel, Google Sheets or your preferred CSV editor.
- Review parent and child rows. Confirm that variable products and their public native variation rows are structured as expected.
Which product fields should you review?
A useful WooCommerce product spreadsheet may include the following fields when the store exposes them publicly:
- Product ID and product type
- Product name and SKU
- Parent-product reference
- Full description and short description
- Categories and tags
- Featured image URL and additional image URLs
- Regular price and sale price
- Stock status and stock quantity
- Attribute names and attribute values
- Native child variation rows
- Variation-specific SKUs, prices, stock details and images
Why can some product options still be missing?
Not every option displayed on a product page is a native WooCommerce variation. Some stores use product add-on plugins, custom configurators or frontend option systems. Those options may appear as dropdowns, checkboxes, swatches, text fields or accessory selectors, but they may not exist as separate WooCommerce child products.
Read Native WooCommerce Variations vs Product Add-ons: Why Some Options Are Missing for a detailed explanation.
How many products can you export for free?
The free version of WooCommerce Product Scraper & CSV Exporter includes up to 500 top-level product exports per browser profile. A publicly exposed variable product counts as one top-level product. Related public native variation rows are included without consuming extra free product credits. An optional Pro license unlocks unlimited product exports for larger catalogs.
Public storefront export versus store-admin export
There are two different WooCommerce CSV export scenarios. The first is an admin export: the store owner signs into WordPress and uses WooCommerce's built-in product exporter or another approved store-management tool. The second is a public storefront export: a browser extension organizes catalog information that a supported storefront exposes publicly.
Choose the workflow that matches your situation. Use the native WooCommerce dashboard tools when you own the source store and need a complete private backup. Use a public WooCommerce product scraper only for permitted workflows involving public storefront information. Public exports should not be treated as a replacement for a store-owner backup because private metadata, unpublished products and plugin-specific settings may not be publicly available.
WooCommerce CSV export validation before migration
After you export WooCommerce products to CSV, do not treat the first download as a final import file. Create a copy and validate the structure. Sort by product type, place variable parents beside their child variations, filter blank SKUs, review empty prices and open a sample of image URLs. If the spreadsheet will be used for migration preparation, compare the category names in the product file with a separate category export.
A useful validation sample includes at least one simple product, one variable parent, several child variations, a product with a sale price, a product with multiple categories and a product with a featured image. This small sample catches structural problems before you spend time cleaning thousands of rows.
Common WooCommerce product export questions
Can I export WooCommerce variable products to CSV?
Yes. When a supported store exposes native WooCommerce child variations through compatible public Store API responses, the extension can include parent-product rows and related variation rows in the CSV file.
Does a variation row always have its own SKU?
Not necessarily. WooCommerce allows stores to configure variations in different ways. Review the exported spreadsheet and treat blank variation SKUs as a data-quality issue when unique identifiers are required for your workflow.
Can I import the exported CSV directly into another store?
Use the exported file as a structured starting point. Always review column mapping, required fields, parent-child relationships, image URLs, stock values and category structures before importing into another store. Run a small test import first.
What should I do after exporting the CSV?
Use the checklist in How to Review WooCommerce SKUs, Prices, Stock and Product Images in CSV before relying on the spreadsheet for a migration or catalog update.
Related guides
- How to Export WooCommerce Categories and Collections to CSV
- WooCommerce Catalog Migration Checklist for CSV Product Files
- How to Review WooCommerce SKUs, Prices, Stock and Product Images in CSV
- WooCommerce Product Scraper support and troubleshooting
Official WooCommerce references
- WooCommerce Store API Products endpoint
- WooCommerce Variable Products documentation
- WooCommerce Product CSV Importer and Exporter documentation
Responsible use: Use catalog-export tools only for lawful workflows. Export data only when you have the right or permission to use it, and follow applicable website terms, privacy requirements, intellectual-property rules and data-use regulations.
