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
