WPSyncSheets For Woocommerce

WooCommerce Google Spreadsheet Addon

Sheet Headers & Order Status

For guidance to Create Google API settings. Go through Video Tutorial

WooCommerce Order Status (Google Sheet Name)
  1. Pending Orders
  2. Processing Orders
  3. On Hold Orders
  4. Completed Orders
  5. Cancelled Orders
  6. Refunded Orders
  7. Failed Orders
  8. Trashed Orders
  9. {Custom} Orders

Google Spreadsheet Headers ( Order Wise )
  1. Order Id
  2. Product name(QTY)
  3. Order Currency
  4. Order Total
  5. Payment Method
  6. Transaction ID
  7. Billing First name
  8. Billing Last Name
  9. Billing Address 1
  10. Billing Address 2
  11. Billing City
  12. Billing State
  13. Billing Postcode
  14. Billing Country
  15. Billing Address (All in one)
  16. Billing Company Name
  17. Shipping First Name
  18. Shipping Last Name
  19. Shipping Address 1
  20. Shipping Address 2
  21. Shipping City
  22. Shipping State
  23. Shipping Postcode
  24. Shipping Country
  25. Shipping Address (All in one)
  26. Shipping Company Name
  27. Email
  28. Phone
  29. Customer ID
  30. Customer Note
  31. Created Date
  32. Status Updated Date
  33. Order Completion Date
  34. Shipping Method Title
  35. Tax Total
  36. Coupons Codes
  37. Order URL
  38. Prices Include Tax
  39. Subscription Price
  40. Subscription Sign Up Fee
  41. Subscription Period
  42. Subscription Period Interval
  43. Subscription Length
  44. Subscription Trial Period
  45. Subscription Trial Length
  46. Subscription Limit
  47. Subscription One Time Shipping
  48. Subscription Payment Sync Date

Google Spreadsheet Headers ( Product Wise )
  1. Order Id
  2. Product ID
  3. Product name
  4. SKU
  5. Product Quantity
  6. Product Base Price
  7. Product Total
  8. Order Currency
  9. Order Total
  10. Payment Method
  11. Transaction ID
  12. Billing First name
  13. Billing Last Name
  14. Billing Address 1
  15. Billing Address 2
  16. Billing City
  17. Billing State
  18. Billing Postcode
  19. Billing Country
  20. Billing Address (All in one)
  21. Billing Company Name
  22. Shipping First Name
  23. Shipping Last Name
  24. Shipping Address 1
  25. Shipping Address 2
  26. Shipping City
  27. Shipping State
  28. Shipping Postcode
  29. Shipping Country
  30. Shipping Address (All in one)
  31. Shipping Company Name
  32. Email
  33. Phone
  34. Customer ID
  35. Customer Note
  36. Created Date
  37. Status Updated Date
  38. Order Completion Date
  39. Shipping Method Title
  40. Tax Total
  41. Coupons Codes
  42. Order URL
  43. Prices Include Tax
  44. Subscription Price
  45. Subscription Sign Up Fee
  46. Subscription Period
  47. Subscription Period Interval
  48. Subscription Length
  49. Subscription Trial Period
  50. Subscription Trial Length
  51. Subscription Limit
  52. Subscription One Time Shipping
  53. Subscription Payment Sync Date
Get best support while using WPSyncSheets For WooCommerce
to sync orders with Google Spreadsheet.
Support
Copyright © 2021 WPSyncSheets. All Rights Reserved.
Disclaimer: WPSyncSheets is an independent product by Creative Werk Designs. It does not represent WooCommerce, Elementor, Contact Form 7, Gravity Forms and WPForms websites.