Guides › How to Export WooCommerce Products to CSV Automatically
How do I export WooCommerce products to CSV automatically?
WooCommerce's built-in product exporter is a manual download. To export automatically, connect your store to Export Stash, create a product export with the columns you want, choose CSV, XLSX or Google Sheets and a destination, then set a schedule from every 15 minutes to monthly. Nothing is installed in WordPress.
What you need
- A WooCommerce store served over HTTPS
- A WordPress admin account that can approve a WooCommerce REST API key
- A destination: an email address, an FTP or SFTP server, or a Google Sheet
Steps
- Go to exportstash.com/woocommerce, enter your email, a password and your store URL, and click Sign up and connect store.
- In WordPress admin, click Approve. WooCommerce creates a REST API key for Export Stash and sends you back to the dashboard.
- Open Products and click Export Products.
- Add fields: choose the product and variation columns, such as SKU, price, stock quantity, categories and image URLs.
- Set export method: choose CSV, XLSX or TXT and send it by email, FTP, SFTP or FTPS, or write it to a Google Sheet.
- Click Set Schedule on the profile and choose every 15 or 30 minutes, hourly, daily, weekdays, weekends, specific days or monthly.
Good to know
- Each variation is its own row and repeats the parent product's values. A simple product is one row.
- Variation attributes come out as Option 1 to 3 Name and Value columns, so sizes and colors are easy to filter in a spreadsheet.
- Rename and reorder the column headers from the profile's menu, for example to match a supplier's or marketplace's template.
- Google Sheets exports can overwrite the sheet, append rows or write a new sheet each run.
- Run any profile on demand without waiting for the schedule.
Fields you can export
- Product: Product ID, Product Name, Product Type, Status, Base SKU, Regular Price, Sale Price, Stock Quantity, Stock Status, Weight, Categories, Tags, Product URL, Description, Short Description, Image URL and Images.
- Variation: Variation ID, Variant SKU, Variant Regular Price, Variant Sale Price, Variant Stock Quantity, Variant Stock Status, Variant Weight, Variant Image URL, and Option 1 to 3 Name and Value.
Common uses
- Send a daily stock and price file to a marketplace, a dropshipper or a wholesale customer.
- Keep a live product catalog in Google Sheets for your team without giving them WordPress logins.
- Back up your WooCommerce catalog to your own FTP server every night.
Limits
- Products are exported, not imported. Export Stash doesn't change WooCommerce products.
- One WooCommerce store per Export Stash account.
- The store must use HTTPS.
FAQ
Can WooCommerce export products on a schedule by itself?
No. WooCommerce's exporter under Products › Export is a one-off download. Export Stash runs the export on a schedule and delivers the file for you.
Do I need to install a WordPress plugin?
No. Export Stash connects through WooCommerce's own REST API key approval. You click Approve once in WordPress admin and nothing is added to your site.
Are variations exported?
Yes. Each variation is its own row with its SKU, prices, stock, weight, image and option values, plus the parent product's values.
Can I export only stock levels?
Yes. Pick just SKU, Stock Quantity and Stock Status in Add fields to send a lightweight inventory file.
How do I disconnect Export Stash?
Delete the Export Stash key under WooCommerce › Settings › Advanced › REST API. Export Stash loses access straight away.
Connect your WooCommerce store to Export Stash — free for 7 days.
More guides
- BigCommerce CSV Import: Bulk Import Products from CSV
- BigCommerce Inventory Sync to eBay, Matched by SKU
- Update BigCommerce Stock & Prices from a Supplier File
- BigCommerce Google Shopping Feed Setup for Merchant Center
- Google Shopping Profit Margin Labels for BigCommerce
- Export BigCommerce Orders to Google Sheets Automatically
- How to Create a BigCommerce Facebook & Instagram Feed
- How to Schedule a BigCommerce Product Export to CSV
- BigCommerce Shipment Tracking: Bulk Upload Tracking Numbers
- Auto-Export WooCommerce Orders to CSV or Google Sheets
- WooCommerce Google Shopping Feed Without a Plugin
Updated 2026-11-14 · FAQ · Compare · Help Centre