Code

WooCommerce Google Spreadsheet Addon

WooCommerce Google Spreadsheet Addon

Add a new row to spreadsheet when a new order is placed on your site.

You can add it to any number of sheet with no restrictions.

Submitted data is added as a new row in the selected Sheet within the Spreadsheet, allows mapping of order data to sheet headers so that only selective data is added to sheet.

Knowledgebase WooCommerce Google Spreadsheet Addon - 1 Support

Order data which can be added to Sheet:

  • -Order ID
  • -Order Number
  • -Order Date
  • -Order Status
  • -Shipping Method Title
  • -Payment Method Title
  • -Transaction ID
  • -View Order URL
  • -User ID
  • -Billing First Name
  • -Billing Last Name (Surname)
  • -Billing Company Name
  • -Billing Email Address
  • -Billing Phone Number
  • -Billing Address
  • -Billing Address (Line 1)
  • -Billing Address (Line 2)
  • -Billing City
  • -Billing State/Province
  • -Billing State/Province Name
  • -Billing Postcode / Zipcode
  • -Billing Country (2 letter code)
  • -Billing Country Name
  • -Shipping First Name
  • -Shipping Last Name (Surname)
  • -Shipping Company Name
  • -Shipping Address
  • -Shipping Address (Line 1)
  • -Shipping Address (Line 2)
  • -Shipping City
  • -Shipping State/Province
  • -Shipping State/Province Name
  • -Shipping Postcode / Zipcode
  • -Shipping Country (2 letter code)
  • -Shipping Country Name
  • -Currency Code
  • -Curency Symbol
  • -Item Count
  • -Order Line Items
  • -Do Prices Include Tax?
  • -Order Total
  • -Order Subtotal
  • -Tax Total
  • -Discount Cart Amount
  • -Coupons Codes
  • -Shipping Total Amount
  • -Shipping Tax Amount
  • -Customer Note
  • -Order Notes List

Best Support, Easy to Use, Free Lifetime Updates

Features:

-Option to select order status for which the data will be added to sheet.

-Option to select the Spreadsheet to which new row of data will be appended.

-Option to select the Sheet within Spreadsheet.

-Option to map form fields with Sheet headers.

-Use on any number of forms.

-Different forms can send data to different sheets.

Woo Sheet Headers Mapping Screenshot:

WooCommerce Google Spreadsheet Addon - 2

FAQ:

Can I add data to different sheets?

Yes you can add data to any sheet available in your google account.

Can I send data to sheet based on order status?

Yes you can send data to sheet based on order status. Order Status supported right now are Pending, Failed, On-hold, Processing, Completed, Refunded, Cancelled.

Can I map sheet columns with order fields?

Yes you can map sheet columns with order fields from the feed settings.

Changelog


Version 2.0 (22nd March 2019)
------------------------------------------------------------------------------------
- Added option to process feed based on Order Status.

Version 1.1 (28th Jan 2019)
------------------------------------------------------------------------------------
- Fixed issue where woocommerce pricing metabox was not displaying if plugin is activated.

Version 1.0 (10 Sep 2018)
------------------------------------------------------------------------------------
-Initial Version
by
by
by
by
by
by