After its Integrated as per the above instruction,
First Click On Click here to Fetch sheets,then select your Google Spreadsheet Name or you can Create a New Sheet.
WooCommerce Google Sheets Setting : #
Now in Google Sheets/Tab Name,Enable Tabs that you want to insert into Google SpreadSheet.Enabling Check All will put all tabs into your Google Sheet.
WooCommerce orders row’s management : #
-
Manage row’s by : Choose Products or Orders Based on How Your Business Fits.
If you choose Order wise then Single Entry will be saved in Google Sheet.
If you Choose Products wise then your each Entry will be shown product wise with the same order Id,if multiple products are there in order.
-
Sorting : Choose Descending Sorting if it is your need.
Ascending Sorting : if you choose ascending sorting then your entry will be in ascending order. Ex. 1,2,3…..100
Descending Sorting : if you choose descending sorting then your entry will be in descending order. Ex. 100,99,98…..1
Product Category Filter : #
You can Choose whether to manage Google Spreadsheets Product-Category wise.
Google Sheet Headers (Column Name) : #
In Google Sheets Headers Section , There are 3 tabs : Orders Header,Products Header & Customers Header.
Orders Header : #
Order Header is a tab setting of Headers related to order.
-
Extra Header Related To Order : to add extra fields in google sheet related to order. Ex. user-IP-address .
- Extra Header Related To Order’s Product : to add extra fields in google sheet related Order’s Product.ex. Tax-class.
After this, There’s orders header fields.
Orders Header Fields :
The Orders Header’s tab contains header’s related orders.
By enabling product header fields , it will create header in Google Sheet.
Using Check All feature all fields will be created in Google Sheet with one click.
Products Header : #
The Products Header’s tab contains header’s related products.
By enabling product header fields , it will create header in Google Sheet.
Using Check All feature all fields will be created in Google Sheet with one click.
Products Variation Header : #
The Products Header’s tab contains header’s related products Variation.
By enabling products variation header fields , it will create header in Google Sheet.
Using Check All feature all fields will be created in Google Sheet with one click.
Customer Header : #
The Customer Header’s tab contains header’s related Customers.
By enabling product header fields , it will create header in Google Sheet.
Using Check All feature all fields will be created in Google Sheet with one click.
Google Sheet Setting #
In Google Sheet Setting ,there are some google sheet’s features like Freeze Header,Header Background Color,etc.
Freeze Header : #
- using this feature your google sheets headers will be freezed.
Header Background : #
-
using this feature u can add header background.
Odd rows Background : #
-
using this feature you can add odd rows Background.
Even rows Background : #
- using this feature you can add Even rows Background.
Google Sheet Sync #
Google Sheet Sync is for syncing data to Google Sheet.
Sync Orders : Sync Orders is for syncing orders in Ascending manner or descending manner for a specific period of time.
Sync Products : Sync Products is for syncing products in Ascending manner or descending manner for a specific period of time.
Sync Customers : Sync Customers is for syncing customers in Ascending manner or descending manner for a specific period of time.
Download Google Sheet (Orders,Products,Customers) : You can download your google sheet offline.
