The WooCommerce Orders provider allows you to export order data from your store to Google Sheets. This is one of the most popular use cases for SyncSheets, enabling powerful reporting and order management workflows.
Requirements
WooCommerce must be installed and activated on your site. The provider will automatically appear when WooCommerce is detected.
Available Fields
Export a comprehensive set of order data including:
- Order ID — The unique order number.
- Order Status — Current status (processing, completed, on-hold, etc.).
- Order Date — When the order was placed.
- Order Total — The total amount including tax and shipping.
- Subtotal — Order total before tax and shipping.
- Tax Total — Total tax amount.
- Shipping Total — Shipping cost.
- Discount Total — Applied coupon discounts.
- Payment Method — The payment gateway used.
- Currency — The order currency.
- Billing Fields: First name, last name, email, phone, company, address, city, state, postcode, country.
- Shipping Fields: First name, last name, company, address, city, state, postcode, country.
- Line Items — Product names, quantities, and totals.
- Customer Note — Any note left by the customer.
Filtering Options
- Order Status: Filter by specific statuses (e.g., only completed orders).
- Date Range: Export orders from a specific time period.
Real-time Sync
Real-time sync for orders supports the following triggers:
- Create: New order is placed.
- Update: Order details are modified.
- Status Change: Order status transitions (e.g., processing → completed).
- Delete: Order is trashed or permanently deleted.
Import Support
You can import order updates from Google Sheets, such as updating order statuses or adding order notes. Use Order ID as the unique key for matching.
Example Use Cases
- Export daily orders to a Google Sheet for fulfillment teams.
- Create an automated sales report updated every hour.
- Track order status changes in real time.
- Share order data with your accountant or bookkeeper.
- Bulk update order statuses from a spreadsheet.