Plugins Plugin hub Backup SEO Caching Security Forms WooCommerce Images Best backup plugins
Hosting Hosting directory Shared hosting Managed WordPress Cloud hosting VPS hosting By reader location Hosting finder
Themes & builders Compare Rank Math vs Yoast
Tools All tools Hosting finder Plugin stack builder Cost calculator Salt generator Theme detector Who is hosting this? Speed test Headline analyzer robots.txt generator Redirect generator Uptime calculator Blog name generator
Blog Best backup plugins Deals
Guides All guides Speed up WordPress Choose hosting Back up WordPress
How we test

WooCommerce · Guide

How to Export WooCommerce Products to CSV (Built-in Exporter Guide)

How to Export WooCommerce Products to CSV (Built-in Exporter Guide)

Short answer

To export WooCommerce products, go to Products > All Products and click Export at the top of the screen. Choose the columns, product types and categories you want, tick the option to export custom meta if needed, then click Generate CSV to download the file. The same CSV can be imported on another store through Products > Import.

Key takeaways

  • WooCommerce has a built-in product CSV exporter under Products.
  • You can limit the export by columns, product types and categories.
  • Images are exported as URLs, not as files.
  • Custom meta is optional and may include plugin data.
  • Use Products > Import with the same CSV format to move products.

How do you export WooCommerce products?

Go to Products > All Products, click Export, choose which columns, product types and categories to include, decide whether to export custom meta, then click Generate CSV and save the file.

The exporter is built into WooCommerce, so no extra plugin is needed for most stores.

The WooCommerce documentation for the Product CSV Importer and Exporter explains every option on the screen.

Large catalogs take longer. Keep the browser tab open until the download starts.

Which export options can you choose?

The exporter lets you pick specific columns, limit the file to certain product types or categories, and include custom meta fields stored by plugins.

OptionWhat it doesWhen to use it
Which columnsPicks fields such as SKU, price, stockSmall, focused updates
Which product typesSimple, variable, grouped, external, variationsSplitting large exports
Which categoryLimits to selected categoriesMoving part of a catalog
Export custom metaAdds plugin and custom field dataFull migrations

Leave everything blank to export all columns and all products. This is the safest choice for a first export, because you can always delete columns later in a spreadsheet.

For price or stock updates, exporting only ID, SKU, price and stock columns keeps the file small and easy to edit.

What does the product CSV include?

The CSV includes product IDs, types, SKUs, names, descriptions, prices, stock, categories, tags, attributes, image URLs, shipping details and parent links for variations.

Each row is a product or a variation. Variations sit under their parent product and reference it in the Parent column.

The official product CSV import schema lists every column and the format it expects.

Open the file in a spreadsheet app to check it before using it anywhere else. Look for empty SKUs, missing prices and categories with odd spelling.

How are images exported?

Images are exported as URLs pointing to your current site's media files, separated by commas when a product has several images.

When you import on another store, WooCommerce downloads images from those URLs. Keep the original site online until the import finishes.

How do you export stock levels only?

Select only the ID, SKU, Stock and In stock columns, leave product types empty, and generate the CSV for a small file that is easy to update and re-import.

This is useful for stocktakes. Count stock in the spreadsheet, then import the file to update every product at once.

How do you export variable products correctly?

Include both the Variable product and Product variations types so each parent and its variations are exported together, with attributes and prices for each variation.

Exporting only variable products leaves out the individual sizes, colors and prices.

Check a few variable products in the CSV. Each variation row should show its parent and attribute values.

Global attributes must exist on the target store, or the import creates them from the CSV values.

Custom attributes set on a single product travel inside that product's row. They do not need to exist on the target store first.

Should you include custom meta?

Include custom meta when moving a full store, because it carries data added by SEO, product add-on and custom field plugins; skip it for simple price or stock edits.

Custom meta columns start with meta: in the header. They can be numerous on stores with many plugins.

Some meta only makes sense with the same plugin installed. Install matching plugins on the target store before importing.

Remove meta columns you do not need. Smaller files import faster and with fewer errors.

How do you edit products in the CSV?

Open the file in a spreadsheet app, change values such as prices, stock or descriptions, keep the column headers unchanged, and save it again as CSV with UTF-8 encoding.

Never change the ID or SKU of products you want to update. WooCommerce uses them to match rows to existing products.

The CSV format rules are described in RFC 4180. Fields with commas or line breaks must stay inside quotes, which spreadsheet apps handle automatically.

Spreadsheet apps can reformat numbers and dates. Check that prices and SKUs did not lose leading zeros.

Which encoding should the CSV use?

Save the file as CSV with UTF-8 encoding so accented letters, currency symbols and other special characters survive the round trip.

Some spreadsheet apps default to other encodings. If names show strange symbols after import, re-save the file as UTF-8 and try again.

Should you back up before a bulk import?

Yes. Take a full backup or at least a fresh product export before importing changes, so you can restore the old prices and stock if something goes wrong.

Keep the original export file untouched. Make edits in a copy with a clear name and date.

How do you import products into another store?

On the target store go to Products > Import, upload the CSV, map the columns, choose whether to update existing products, then run the importer.

To update products that already exist, tick the option to update existing products. Matching uses ID or SKU.

Import categories and attributes first if the target store needs a specific structure. The importer can create them, but names must match exactly.

Run a small test import with ten rows before importing thousands of products.

After importing, open a few products of each type in the editor. Check prices, stock, images, categories and variations against the source store.

What does the exporter leave out?

The product CSV does not include orders, customers, reviews, coupons, store settings or most extension data, so those need their own exports or a full migration.

Orders have their own export options. Our guide on exporting WooCommerce orders to CSV covers them.

Reviews are comments, which the WordPress content export can include.

For moving a whole store, a full site migration keeps everything together. Our guide on migrating a site with UpdraftPlus is one option.

How do you export very large catalogs?

Split large exports by category or product type, raise PHP memory if needed, or use a dedicated export plugin or WP-CLI for catalogs with tens of thousands of products.

The built-in exporter runs in batches, but slow hosting can still time out on huge stores.

Our guide on how many products WooCommerce can handle covers performance limits that also affect exports.

The WP-CLI project supports command-line tools that some export plugins build on for big jobs.

Can you export products for Google Shopping or marketplaces?

Not directly with the default CSV; Google Merchant Center and marketplaces need their own feed formats, which feed plugins or channel integrations create.

Google's product data specification lists the fields a shopping feed needs, such as GTIN, brand and availability.

The WooCommerce CSV is still useful for checking product data before setting up a feed.

How do you schedule regular exports?

The built-in exporter is manual, so use an export extension or plugin if you need automatic daily or weekly product files for suppliers, accountants or backups.

Scheduled exports can save to a server folder, email or cloud storage, depending on the tool.

Keep exported files private. They contain your pricing and stock, which competitors would like to see.

Name scheduled files with the date. That makes it easy to compare stock or prices between two points in time.

What problems can happen during export?

Common problems are timeouts on big catalogs, missing variations because a product type was not selected, garbled characters from wrong encoding and blank files caused by plugin conflicts.

If products are missing from the shop itself, fix that first. Our guide on products not showing in the shop page covers visibility settings.

Test the export on a staging copy if the live store is busy. Exports use server resources while they run.

If the download is empty, check the WooCommerce status logs and your server error log. They usually name the plugin or limit that stopped the export.

Frequently asked questions

Where is the WooCommerce product export option?

Go to Products, then All Products, and click the Export button at the top of the screen. The exporter opens with options for columns, types and categories.

Does WooCommerce product export include images?

It includes image URLs, not the image files. When importing on another store, WooCommerce downloads the images from those URLs.

How do I export only some WooCommerce products?

Choose specific product types or categories in the exporter. You can also select only the columns you need, such as SKU, price and stock.

Can I update prices with a CSV export?

Yes. Export ID, SKU and price columns, edit prices in a spreadsheet, then import the file with the option to update existing products turned on.

Does the product export include orders or customers?

No. The product CSV covers products and variations only. Orders, customers and coupons need separate exports or a full site migration.

Sources

  1. Product CSV Importer and Exporter WooCommerce Docs
  2. Product CSV Import Schema WooCommerce on GitHub
  3. RFC 4180: Common Format for CSV Files RFC Editor
  4. Product data specification Google Merchant Center Help
  5. WP-CLI WP-CLI

Is your product missing, or something out of date?

Tell us what to add or correct. We read every note and reply when we need a source. A message does not buy a ranking.

About the editors

Written and checked byWPLegible Editorial Team Independent WordPress reviews and guides

Researched from the primary sources listed above and checked against our editorial rules before publishing.