Sheet Headers & Order Status
For guidance to Create Google API settings. Go through Video Tutorial
WooCommerce Order Status (Google Sheet Name)
- Pending Orders
- Processing Orders
- On Hold Orders
- Completed Orders
- Cancelled Orders
- Refunded Orders
- Failed Orders
- Trashed Orders
- {Custom} Orders
Google Spreadsheet Headers ( Order Wise )
- Order Id
- Product name(QTY)
- Order Currency
- Order Total
- Payment Method
- Transaction ID
- Billing First name
- Billing Last Name
- Billing Address 1
- Billing Address 2
- Billing City
- Billing State
- Billing Postcode
- Billing Country
- Billing Address (All in one)
- Billing Company Name
- Shipping First Name
- Shipping Last Name
- Shipping Address 1
- Shipping Address 2
- Shipping City
- Shipping State
- Shipping Postcode
- Shipping Country
- Shipping Address (All in one)
- Shipping Company Name
- Phone
- Customer ID
- Customer Note
- Created Date
- Status Updated Date
- Order Completion Date
- Shipping Method Title
- Tax Total
- Coupons Codes
- Order URL
- Prices Include Tax
- Subscription Price
- Subscription Sign Up Fee
- Subscription Period
- Subscription Period Interval
- Subscription Length
- Subscription Trial Period
- Subscription Trial Length
- Subscription Limit
- Subscription One Time Shipping
- Subscription Payment Sync Date
Google Spreadsheet Headers ( Product Wise )
- Order Id
- Product ID
- Product name
- SKU
- Product Quantity
- Product Base Price
- Product Total
- Order Currency
- Order Total
- Payment Method
- Transaction ID
- Billing First name
- Billing Last Name
- Billing Address 1
- Billing Address 2
- Billing City
- Billing State
- Billing Postcode
- Billing Country
- Billing Address (All in one)
- Billing Company Name
- Shipping First Name
- Shipping Last Name
- Shipping Address 1
- Shipping Address 2
- Shipping City
- Shipping State
- Shipping Postcode
- Shipping Country
- Shipping Address (All in one)
- Shipping Company Name
- Phone
- Customer ID
- Customer Note
- Created Date
- Status Updated Date
- Order Completion Date
- Shipping Method Title
- Tax Total
- Coupons Codes
- Order URL
- Prices Include Tax
- Subscription Price
- Subscription Sign Up Fee
- Subscription Period
- Subscription Period Interval
- Subscription Length
- Subscription Trial Period
- Subscription Trial Length
- Subscription Limit
- Subscription One Time Shipping
- Subscription Payment Sync Date