Guides › Auto-Export WooCommerce Orders to CSV or Google Sheets
How do I export WooCommerce orders to CSV or Google Sheets automatically?
Connect your WooCommerce store to Export Stash, create an order export, pick the order, customer and line item columns, filter by date and status, and choose CSV, XLSX or Google Sheets. Then set a schedule, from every 15 minutes to monthly. Export Stash can also move exported orders to another status, such as Completed.
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, sign up with your email, a password and your store URL, then click Approve in WordPress admin.
- Open Orders and click Export Orders.
- Add fields: choose order, billing, shipping and line item columns.
- Custom fields (Optional): add order or line item meta by key, such as a delivery date or gift message from checkout, or a fixed value column.
- Select order filters: choose a date range and the statuses to include, for example Processing only.
- Set export method: choose CSV, XLSX or TXT by email, FTP or SFTP, or a Google Sheet.
- More export settings: optionally move exported orders to another status, for example Processing to Completed, and set the date format. Then click Set Schedule on the profile.
Good to know
- Each line item is one row, and every row repeats the order, billing and shipping values, which is the layout most warehouses and accounting imports expect.
- Statuses use WooCommerce's own: pending, processing, on-hold, completed, cancelled, refunded and failed.
- With a date format set, dates are shown in your store's timezone.
- Total Refunded sums every refund on the order, so partial refunds are counted.
- Rename and reorder column headers from the profile's menu to match your 3PL's or accountant's template.
Fields you can export
- Order: Order ID, Order Number, Status, Date Created, Date Paid, Date Completed, Currency, Payment Method, Transaction ID, Customer ID, Customer Note, Discount Total, Shipping Total, Total Tax, Order Total, Total Refunded, Coupon Codes, Shipping Method and Fees.
- Billing: First Name, Last Name, Company, Address 1 and 2, City, State, Postcode, Country, Email and Phone. Shipping has the same set without Email.
- Line item: Item ID, Product ID, Variation ID, SKU, Name, Quantity, Price, Subtotal, Total and Tax.
Common uses
- Send new Processing orders to a fulfilment partner's FTP every 15 minutes, then mark them Completed so they aren't sent twice.
- Keep a live sales sheet in Google Sheets for bookkeeping or reporting.
- Email a daily order summary to a supplier.
Limits
- Rows are always one per line item; there's no one-row-per-order layout for WooCommerce yet.
- Orders are filtered by date and status. Filters on order total, item count or postcode aren't available for WooCommerce yet.
- The store must use HTTPS.
FAQ
Can WooCommerce export orders to CSV without a plugin?
Not on its own: WooCommerce has no built-in order CSV export. Export Stash does it from outside WordPress through the REST API, so there's no plugin to install or update.
How do I avoid exporting the same order twice?
Filter on the Processing status and set More export settings to move exported orders to Completed. The next run only picks up orders that are still Processing.
Can I export custom checkout fields?
Yes. Add a Custom Field (Checkout) column with the order meta key, or a Custom Field (Product) column with the line item meta key.
Can orders go straight into Google Sheets?
Yes. Choose Google Sheet as the export method and the sheet updates on every scheduled run.
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
- How to Export WooCommerce Products to CSV Automatically
- WooCommerce Google Shopping Feed Without a Plugin
Updated 2026-11-14 · FAQ · Compare · Help Centre