Add a brand new row to spreadsheet when a brand new order is positioned in your web site.
You may add it to any variety of sheet with no restrictions.
Submitted information is added as a brand new row within the chosen Sheet throughout the Spreadsheet, permits mapping of order information to sheet headers in order that solely selective information is added to sheet.
 |
 |
 |
Order information which could be added to Sheet:
- -Order ID
- -Order Quantity
- -Order Date
- -Order Standing
- -Transport Methodology Title
- -Fee Methodology Title
- -Transaction ID
- -View Order URL
- -Person ID
- -Billing First Identify
- -Billing Final Identify (Surname)
- -Billing Firm Identify
- -Billing Electronic mail Handle
- -Billing Telephone Quantity
- -Billing Handle
- -Billing Handle (Line 1)
- -Billing Handle (Line 2)
- -Billing Metropolis
- -Billing State/Province
- -Billing State/Province Identify
- -Billing Postcode / Zipcode
- -Billing Nation (2 letter code)
- -Billing Nation Identify
- -Transport First Identify
- -Transport Final Identify (Surname)
- -Transport Firm Identify
- -Transport Handle
- -Transport Handle (Line 1)
- -Transport Handle (Line 2)
- -Transport Metropolis
- -Transport State/Province
- -Transport State/Province Identify
- -Transport Postcode / Zipcode
- -Transport Nation (2 letter code)
- -Transport Nation Identify
- -Foreign money Code
- -Curency Image
- -Merchandise Depend
- -Order Line Gadgets
- -Do Costs Embrace Tax?
- -Order Whole
- -Order Subtotal
- -Tax Whole
- -Low cost Cart Quantity
- -Coupons Codes
- -Transport Whole Quantity
- -Transport Tax Quantity
- -Buyer Word
- -Order Notes Record
Finest Assist, Simple to Use, Free Lifetime Updates
Options:
-Choice to pick out order standing for which the info can be added to sheet.
-Choice to pick out the Spreadsheet to which new row of knowledge can be appended.
-Choice to pick out the Sheet inside Spreadsheet.
-Choice to map type fields with Sheet headers.
-Use on any variety of varieties.
-Totally different varieties can ship information to totally different sheets.
Woo Sheet Headers Mapping Screenshot:
FAQ:
Can I add information to totally different sheets?
Sure you possibly can add information to any sheet accessible in your google account.
Can I ship information to sheet based mostly on order standing?
Sure you possibly can ship information to sheet based mostly on order standing. Order Standing supported proper now are Pending, Failed, On-hold, Processing, Accomplished, Refunded, Cancelled.
Can I map sheet columns with order fields?
Sure you possibly can map sheet columns with order fields from the feed settings.
Changelog
Model 3.0 (14 Aug 2020) ------------------------------------------------------------------------------------ - Fastened Google Authorization circulation. Model 2.5 (19 Dec 2019) ------------------------------------------------------------------------------------ - Added choice to ship solely Date. Model 2.4 (12 Dec 2019) ------------------------------------------------------------------------------------ - No prefix earlier than product title is there's only one product so as. Model 2.3 (27 Aug 2019) ------------------------------------------------------------------------------------ - Added Product Identify to ship to sheet. Model 2.2 (18 Might 2019) ------------------------------------------------------------------------------------ - Simplified Google Auth course of. Model 2.1 (19 April 2019) ------------------------------------------------------------------------------------ - Fastened Deauthorize button not working. - Added filter 'wc_googlespreadsheet_row_data' earlier than sending information to sheet. Model 2.0 (twenty second March 2019) ------------------------------------------------------------------------------------ - Added choice to course of feed based mostly on Order Standing. Model 1.1 (twenty eighth Jan 2019) ------------------------------------------------------------------------------------ - Fastened problem the place woocommerce pricing metabox was not displaying if plugin is activated. Model 1.0 (10 Sep 2018) ------------------------------------------------------------------------------------ -Preliminary Model
