Sign inBlogSupportContact
WooCommerce

Export your WooCommerce products to CSV in one command

Your entire product catalog in a spreadsheet before your coffee gets cold.

4 min read May 2026 export products csv

Your marketing team needs the product list. Right now.

It's 3pm. Your marketing manager needs every product with prices, categories, and image URLs to build tomorrow's campaign. They don't have WordPress access. They need a spreadsheet.

You navigate to Products, click Export, pick columns, click Generate, wait for the file, download it, realize it timed out because the store has 800 products. Start over. This time with WooCommerce's built-in exporter that loads everything into memory and crashes on shared hosting.

What most people do instead

Every option adds unnecessary steps to a simple task.

WooCommerce built-in export6 clicks, a column picker, and a wait. Times out on large catalogs. No progress indicator.
Export plugins (WP All Export)Powerful but overkill for "give me a CSV of my products." Adds admin pages, database tables, and a learning curve.
SQL export via phpMyAdminRequires server access and SQL knowledge. Product data spans multiple tables. Categories need joins.

A better way: one command, complete CSV

Open the TrueCommander navigator. Type export products csv. Hit enter.

Every published product gets exported with 18 data columns: ID, SKU, name, prices, stock, categories, dimensions, images, and URLs. The file opens cleanly in Excel (UTF-8 BOM included). Download link expires in 1 hour.

TrueCommander
284 products exported
CSV Export284 rows
Filenameproducts_publish_20260315_090400.csv
Size342.7 KB
Columns18
Statuspublish
Download CSVexpires in 1 hour

Opens correctly in Excel. UTF-8 BOM included. Product names with accented characters, currency symbols, and special characters display correctly without manual encoding steps.

How it works

Batch processing handles catalogs of any size.

1
Queries products in batches of 200Writes rows to disk as they're fetched. Memory stays constant regardless of catalog size.
2
Builds 18 columns per productID, SKU, name, prices, stock, categories, tags, dimensions, description, image URL, product URL.
3
Generates a secure download linkToken-based, admin-only, 1-hour expiry. File is stored in a protected directory.
DetailValue
Command nameexport products csv
Columns18 (ID, SKU, prices, stock, categories, dimensions, etc.)
Status filter-status=publish|draft|private|pending|any
Row limit-limit=500 (max 5,000)
Batch size200 products per query
RequiresWooCommerce active
Can be used in

Real example

Your client runs a WooCommerce store with 284 products. Their marketing team needs a product spreadsheet for a holiday campaign — names, prices, categories, and image URLs to build promotional materials.

You open the navigator, type export products csv, and hit enter. Three seconds later: 284 products exported, 342 KB, 18 columns. You click Download and email the CSV to the marketing team.

Next week, the client wants draft products too. You run export products csv -status=any. Same result, now with 312 rows including 28 drafts. Total effort: one command, one click.

Goes further with TrueCommander

Manual exports work. Scheduled exports keep everyone updated automatically.

Ready?

Your product catalog, one command away.

This is one of 91 commands. All included with every license.

Cookies. The short version.

Essential cookies keep the cart and theme working. Analytics only fire if you say yes. Read our policy.