Available in: Pro · Requires: WooCommerce
The WooCommerce Orders data type exports orders to Google Sheets. It appears when WooCommerce is active, and works with both of WooCommerce’s order storage options: High-Performance Order Storage (HPOS) and posts.
Fields
- Order: Order ID, Order Number, Status, Order Date, Payment Method, Transaction ID, Currency
- Totals: Subtotal, Discount Total, Shipping Total, Tax Total, Order Total
- Billing: first name, last name, email, phone, company, address lines 1 and 2, city, state, postcode, country
- Shipping: first name, last name, address line 1, city, country, shipping method
- Items: Line Items, Item Count, Coupon Codes
- Customer Note
Filters
- Order status
- Date range: from and to
Real-time sync
Real-time jobs can send a row when an order is created, updated, changes status or is deleted.
Import: update orders
Import jobs update existing orders; they never create new ones. You can map Order ID, Order Number, Status, Customer Note, Tracking Number, Tracking Provider, Tracking URL and a Private Order Note.
- Unique key: Order ID or order number.
- Setting: add an order note when an import changes the status.
Ideas
- Send each new order to a fulfilment sheet.
- Build a sales report that refreshes every hour.
- Update order statuses and tracking numbers in bulk from a sheet.
For coupons, refunds, reviews and product categories, see WooCommerce coupons, refunds, reviews and categories.