WooCommerce Google Spreadsheet Addon

Description

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.

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:

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.5 (19 Dec 2019)
------------------------------------------------------------------------------------
- Added option to send only Date.

Version 2.4 (12 Dec 2019)
------------------------------------------------------------------------------------
- No prefix before product name is there is only 1 product in order.

Version 2.3 (27 Aug 2019)
------------------------------------------------------------------------------------
- Added Product Name to send to sheet.

Version 2.2 (18 May 2019)
------------------------------------------------------------------------------------
- Simplified Google Auth process.

Version 2.1 (19 April 2019)
------------------------------------------------------------------------------------
- Fixed Deauthorize button not working.
- Added filter 'wc_googlespreadsheet_row_data' before sending data to sheet.

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