Plugin Settings – PRO Version

After successfully completing the integration with Google with the preferred method and configuring the necessary permissions as described in the last article, proceed to your WooCommerce Google Sheet dashboard – WooCommerce Data Settings.

First, click on Click here to Fetch sheets, then select your Google Spreadsheet Name or you can Create a New Sheet.

Save the settings.

WooCommerce Google Sheets Setting : #

Now, in Google Sheets/Tab Name, enable the tabs that you want to insert into Google Spreadsheet. Enabling Check All will put all tabs into your Google Sheet.

WooCommerce Custom Order Status : #

Now in Google Sheets/Tab Name, enable tabs for custom order statuses that you want to insert into Google Spreadsheet. Enabling Check All will put all tabs into your Google Sheet.

You can create custom order statuses using Custom Order Status for WooCommerce

WooCommerce All Orders, All Products, All Product Variations & All Coupons : #

Now in Google Sheets/Tab Name, enable tabs for all different types of categories that you want to insert into Google Spreadsheet. Enabling Check All will put all tabs into your Google Sheet.

By enabling these fields, each field’s setting will be shown.

WooCommerce Orders Row’s Management : #

Manage rows by: #

Choose Products or Orders based on how your business fits.

If you choose Order wise, then a single entry will be saved in Google Sheet.

If you choose Product wise, then each entry will be shown product wise with the same order ID, if multiple products are there in an order.

Sorting : #

Choose Descending Sorting if it is your need.

1. Ascending Sorting : #

If you choose ascending sorting, then your entries will be in ascending order (Ex: 1, 2, 3…100).

2. Descending Sorting : #

If you choose descending sorting, then your entries will be in descending order (Ex: 100, 99, 98…1).

Product Category Filter : #

You can save entries for specific categories or select all categories to have all types of categories in the Google Sheet.

You can choose whether to manage Google Spreadsheets Product-Category wise.

Order Category Filter : #

You can save entries for specific categories or select all categories to have all types of categories in the Google Sheet.

You can choose whether to manage Google Spreadsheets Order-Category wise.

Google Sheet Headers (Column Name) : #

In Google Sheets Headers Section, there are 3 tabs: Orders Header, Products Header, & Customers Header.

Orders Header : #

Orders Header is a tab setting of headers related to orders.

Extra Header Related To Order : #

To add extra fields in the Google Sheet related to the order (e.g., user IP address).

Note: If the extra headers aren’t showing properly in the dropdown, go to the WooCommerce Dashboard. Then, navigate to Settings → Advanced → Features. In the Order Storage section, check if the “Enable compatibility mode (synchronizes orders to the posts table).”

Extra Header Related To Order’s Product : #

To add extra fields in the Google Sheet related to the order’s product (e.g., Tax-class).

Custom Static Headers #

To add extra static headers in Google Sheet (e.g., IP Address, Site Name).

Custom Static Blank Headers #

To add extra blank fields in Google Sheet (e.g., Tax-class).

After this, there are the orders header fields.

Orders Header Fields : #

The Orders Header’s tab contains headers related to orders.

By enabling product header fields, it will create a header in the Google Sheet.

Using the Check All feature, all fields will be created in the Google Sheet with one click.

Default Order Header Fields : #

1. 1. Order ID – Unique identifier for the order.
   2. Created Date – The date when the order was created.
   3. Product Id – Unique identifier for the product.
   4. Product Image – The image URL of the product.
   5. Product Name – The name of the product.
   6. Product Meta – Meta data associated with the product (for example, product attributes).
   7. Product Variation – Specific variation details if the product is a variation (like size, color).
   8. SKU (Stock Keeping Unit) – The unique identifier for the product.
   9. Product Quantity – The quantity of each product purchased.
   10. Product Base Price – The base price of the product before any discounts or taxes.
   11. Product Total – Total cost of the product (quantity * price).
   12. Product Categories – Categories associated with the product.
   13. Partial Refund Amount – The amount refunded if the order was partially refunded.
   14. Order URL – URL to view the order details.
   15. Status Update Date – The date when the order status was last updated.
   16. Transaction ID – The unique identifier for the payment transaction.
   17. Customer ID – Unique identifier for the customer.
   18. Order Completion Date – The date when the order was completed.
   19. Order Paid Date – The date when the order was paid.
   20. Order Notes – Notes attached to the order by the store admin.
   21. Order Status – Current status of the order (Processing, Completed, etc.).
   22. Currency – The currency in which the order was paid.
   23. Tax Total – Total tax applied to the order.
   24. Order Total – The total amount of the order (including taxes, shipping, and discounts).
   25. Payment Method – The method of payment used (e.g., PayPal, Credit Card).
   26. Billing First Name – The first name in the billing address.
   27. Billing Last Name – The last name in the billing address.
   28. Billing Address 1 – The first line of the billing address.
   29. Billing Address 2 – The second line of the billing address (if applicable).
   30. Billing City – The city in the billing address.
   31. Billing Company Name – The company name (if any) in the billing address.
   32. Shipping First Name – The first name in the shipping address.
   33. Shipping Last Name – The last name in the shipping address.
   34. Shipping Address 1 – The first line of the shipping address.
   35. Shipping Address 2 – The second line of the shipping address (if applicable).
   36. Shipping City – The city in the shipping address.
   37. Shipping State – The state in the shipping address.
   38. Shipping Postcode – The postal code in the shipping address.
   39. Shipping Country – The country in the shipping address.
   40. Shipping Method – The shipping method used for the order (e.g., Flat Rate, Free Shipping).
   41. Shipping Company – The company that is handling the shipping (e.g., USPS, FedEx).
   42. Discount Total – The total amount of discounts applied to the order.
   43. Discount Tax – The tax amount applied to the discount.
   44. Shipping Total – The total cost of shipping.
   45. Shipping Tax – The tax applied to the shipping cost.
   46. Cart Tax – The tax applied to the cart before any discounts.
   47. Coupon Codes – Any coupon codes applied during checkout.
   48. Email – The email address associated with the order.
   49. Phone – The phone number of the customer.
   50. Customer Notes – Notes provided by the customer during checkout.
   51. Order Total (Excl. Shipping Charges and Other Fees) – The total order value excluding shipping and other fees.
   52. Product Type – The type of product (Simple, Variable, etc.).
   53. Product Tax – Tax applied to the product.
   54. Customer Total Orders – The total number of orders placed by the customer.
   55. Customer Total Revenue – The total amount of revenue spent by the customer.
   56. Customer Average Order Value – The average value of each order made by the customer.

Products Header : #

The Products Header’s tab contains headers related to products.

By enabling product header fields, it will create a header in the Google Sheet.

Using the Check All feature, all fields will be created in the Google Sheet with one click.

Default Product Header Fields : #

• Product Name – The name of the product.
• Product Status – Whether the product is published, draft, or pending review.
• Product Short Description – A brief description of the product (usually shown on the product page).
• Product Description – Full description of the product, often used in the product detail section.
• Product Slug – URL-friendly version of the product name.
• Product Link – The URL to the product page.
• Product Categories – The categories the product is assigned to.
• Product SKU – Stock Keeping Unit, a unique identifier for inventory.
• Product Type – The type of product (simple, variable, etc.).
• Product Image – The main image for the product.
• Product Tags – Tags associated with the product for better searchability.
• Product Attribute – Attributes like size, color, etc., assigned to the product.
• Product Regular Price – The standard selling price of the product.
• Product Sale Price Dates From – The start date for the sale price (if applicable).
• Product Sale Price Dates To – The end date for the sale price (if applicable).
• Product Stock – The number of items available in stock.
• Product Stock Status – The current stock status (in stock, out of stock).
• Product Weight – The weight of the product, typically used for shipping calculations.
• Product Height – The height of the product.
• Product Width – The width of the product.
• Product Length – The length of the product.
• Product Total Sale – Total number of units sold.
• Product Purchase Note – Any additional information to be shown to the customer after purchase.
• Product Dimensions – The overall dimensions (length, width, height) of the product.
• Product Sold Individually – Whether only one unit of the product can be purchased at a time.
• Manage Product Stock – Whether stock management is enabled for the product.
• Product Shipping Class – The shipping class assigned to the product (affects shipping cost).
• Product Tax Status – The tax status of the product (taxable, none, etc.).
• Product Tax Class – The tax class assigned to the product.
• Virtual Product – Whether the product is virtual (doesn’t require shipping).
• Date Created – The date the product was created.
• Date Modified – The date the product was last modified.
• Product Downloadable – Whether the product is downloadable (e.g., digital goods).
• Product Downloadable Files – The files available for download with the product.
• Product Downloadable File Names – The names of downloadable files associated with the product.
• Product Download Limit – The limit on how many times the product can be downloaded.
• Product Download Expiry – The expiry date for the downloadable files.
• Product Allow Backorders – Whether customers can order out-of-stock items.
• Product Variation ID – The unique identifier for product variations.
• Product Variation SKU – The SKU for the variation of the product.
• Product Variation Image – The image associated with a product variation.
• Product Variation Regular Price – The regular price of the product variation.
• Product Variation Sale Price – The sale price of the product variation.
• Product Variation Sale Price Dates From – The start date for the variation sale price.
• Product Variation Sale Price Dates To – The end date for the variation sale price.
• Product Variation Stock – The stock quantity of the variation.
• Product Variation Stock Status – The stock status of the variation (in stock, out of stock).
• Product Variation Weight – The weight of the product variation.
• Product Variation Dimensions – The dimensions of the product variation (length, width, height).
• Product Variation Manage Product Stock – Whether stock management is enabled for the variation.
• Product Variation Shipping Class – The shipping class of the product variation.
• Virtual Product Variation – Whether the variation is a virtual product.
• Product Variation Description – The description for the product variation.
• Downloadable Product Variation – Whether the product variation is downloadable.
• Product Variation Downloadable Files – The downloadable files for the product variation.
• Product Variation Download Limit – The download limit for the product variation.
• Product Variation Download Expiry – The expiry date for the downloadable files of the variation.
• Grouped Products IDs – The IDs of products grouped together.
• Product Variation Allow Backorders – Whether backorders are allowed for the variation.
• Product Variation Total Sale – Total number of units sold for the variation.
• External Product Button Text – The text displayed for the external product button.
• External Product Link – The link to the external product.
• Product Sale Price – The sale price for the product.

 

Product Variation Header : #

The Products Header’s tab contains headers related to product variations.

By enabling product variation header fields, it will create a header in the Google Sheet.

Using the Check All feature, all fields will be created in the Google Sheet with one click.

Default Product Variation Fields : #

• Product ID – The unique identifier for each product.
• Variation ID – The unique identifier for each product variation.
• Product Name – The name of the product.
• Product Variation Name – The name of the product variation.
• Product Variation SKU – The SKU for the product variation.
• Product Variation Image – The image associated with the product variation.
• Product Variation Regular Price – The regular price of the product variation.
• Product Variation Sale Price – The sale price of the product variation.
• Product Variation Sale Price Dates From – The start date for the sale price of the variation.
• Product Variation Sale Price Dates To – The end date for the sale price of the variation.
• Product Variation Stock – The stock quantity of the product variation.
• Product Variation Stock Status – The stock status of the product variation (in stock, out of stock).
• Product Variation Weight – The weight of the product variation.
• Product Variation Dimensions – The dimensions of the product variation (length, width, height).
• Product Variation Manage Product Stock – Whether stock management is enabled for the product variation.
• Product Variation Shipping Class – The shipping class assigned to the product variation.
• Virtual Product Variation – Whether the product variation is virtual (no shipping required).
• Product Variation Description – The description for the product variation.
• Downloadable Product Variation – Whether the product variation is downloadable (e.g., digital products).
• Product Variation Downloadable Files – The downloadable files associated with the product variation.
• Product Variation Download Limit – The number of times the downloadable files for the product variation can be downloaded.
• Product Variation Download Expiry – The expiry date for the downloadable files for the product variation.
• Product Variation Allow Backorders – Whether backorders are allowed for the product variation.
• Product Variation Total Sale – Total number of units sold for the product variation.
• Product Type – The type of product (simple, variable, etc.).
• Product Categories – The categories the product is assigned to.

Customer Header : #

The Customer Header’s tab contains headers related to customers.

By enabling product header fields, it will create a header in the Google Sheet.

Using the Check All feature, all fields will be created in the Google Sheet with one click.

Default Customer Header Fields : #

• Customer ID – The unique identifier for each customer.
• Customer Username – The username chosen by the customer for their account.
• Customer Role – The role assigned to the customer (e.g., customer, administrator).
• Customer FirstName – The first name of the customer.
• Customer LastName – The last name of the customer.
• Customer Nickname – A nickname for the customer (if provided).
• Customer Display Name – The name displayed publicly for the customer (can be set by the customer).
• Customer EmailID – The email address of the customer.
• Customer Website – The website URL provided by the customer (if applicable).
• Customer Biographical Info – A short bio or description of the customer.
• Customer Profile Image – The profile image or avatar associated with the customer.
• Billing FirstName – The first name for the billing address.
• Billing LastName – The last name for the billing address.
• Billing Company Name – The company name for the billing address (if applicable).
• Billing Address1 – The first line of the billing address.
• Billing Address2 – The second line of the billing address (optional).
• Billing City – The city for the billing address.
• Billing Postcode / ZIP – The postcode or ZIP code for the billing address.
• Billing Country – The country for the billing address.
• Billing State – The state/province for the billing address.
• Billing Phone Number – The phone number provided for the billing address.
• Billing EmailID – The email address provided for the billing address.
• Shipping FirstName – The first name for the shipping address.
• Shipping LastName – The last name for the shipping address.
• Shipping Company Name – The company name for the shipping address (if applicable).
• Shipping Address1 – The first line of the shipping address.
• Shipping Address2 – The second line of the shipping address (optional).
• Shipping City – The city for the shipping address.
• Shipping Postcode / ZIP – The postcode or ZIP code for the shipping address.
• Shipping Country – The country for the shipping address.
• Shipping State – The state/province for the shipping address.

Coupons Header : #

The Coupons Header’s tab contains headers related to coupons.

By enabling product header fields, it will create a header in the Google Sheet.

Using the Check All feature, all fields will be created in the Google Sheet with one click.

Default Coupon Header Fields : #

• Coupon ID – A unique identifier for the coupon.
• Coupon Code – The alphanumeric code that customers enter to redeem the coupon.
• Description – A brief explanation of what the coupon offers.
• Discount Type – The form of discount (e.g., percentage, fixed amount).
• Coupon Amount – The value of the discount, based on the discount type.
• Status – Whether the coupon is active, expired, or inactive.
• Allow Free Shipping – Indicates whether the coupon includes free shipping as a benefit.
• Coupon Expiry Date – The date the coupon will no longer be valid.
• Minimum Spend – The minimum amount a customer must spend to use the coupon.
• Maximum Spend – The maximum amount a customer can spend and still use the coupon.
• Individual Use Only – Whether the coupon can be used in combination with other offers.
• Exclude Sale Items – Whether the coupon is applicable to sale items.
• Products – Specific products the coupon can be applied to.
• Exclude Products – Specific products that the coupon cannot be applied to.
• Applied Product Categories – Categories of products that the coupon can be used on.
• Exclude Categories – Categories of products that the coupon cannot be applied to.
• Allowed Emails – The email addresses or domains eligible to use the coupon.
• Usage Limit Per Coupon – The maximum number of times the coupon can be used.
• Limit Usage To X Items – The number of items that the coupon can be applied to.
• Usage Limit Per User – The maximum number of times a single user can use the coupon.

Google Sheet Setting #

In Google Sheet Settings, there are some Google Sheet features like Freeze Header, Header Background Color, etc.

Freeze Header Rows : #

Select whether you need to freeze the header row or not.

Header Background Color : #

Choose the header background color for your Google Sheet.

Header Text Color : #

Choose the text color of your Google Sheet header.

Column Width : #

Choose whether you want to manually adjust the width of columns.

Font Size : #

Choose the font size of your Google Sheet.

After configuring all the necessary settings, save your settings to make everything work efficiently and effectively.

Step-by-Step Guide to Enable WooCommerce Sync for Google Sheets #

To sync orders and products in WooCommerce with Google Sheets, follow the step-by-step guide below. This configuration is essential to ensure proper synchronization:

1. Go to the WooCommerce Dashboard.
2. Navigate to Settings > Advanced > Features.
3. In the Order Storage section, locate the option “Enable compatibility mode (synchronizes orders to the posts table)”.
4. Ensure this option is enabled by ticking the checkbox. If it is not ticked, check it and save the settings.

By enabling this option, WooCommerce will correctly sync your orders and products with Google Sheets.

You can download your google sheet offline.

If syncing isn’t functioning properly, head to the WooCommerce Dashboard. From there, navigate to Settings, then Advanced, and then finally Features. In the Order Storage section, make sure to check whether “Enable compatibility mode (synchronizes orders to the posts table)” is ticked. If it’s not, be sure to tick it.

Before syncing products, orders, customers, or any data to Google Sheets, it’s essential to first use the Integration with Google Manual Method Authentication. This ensures that if you’re dealing with large volumes of data, you won’t encounter any Google quota limit issues.

Note: If you have a large volume of data exceeding 1,000 rows, you must manually add more rows to the sheet, as shown in the image.

Sync Orders #

In the first dropdown menu, you can choose between Ascending or Descending order.

In the second dropdown, you can specify the date range by selecting From Date to To Date.

Finally, in the last dropdown, you can choose the order status to filter the sync, with the following options:

1. All Orders
2. Pending Orders
3. Processing Orders
4. On Hold Orders
5. Completed Orders
6. Cancelled Orders
7. Refunded Orders
8. Failed Orders
9. VIP Priority Processing
10. Backordered
11. Returned – Inspection Required
12. Delivered – Pending Confirmation
13. Ready for Pickup
14. On Hold
15. Customization in Progress
16. Pending Payment
17. Draft
18. Trashed Orders

You can select the specific order status you want to sync based on the available options.

Sync Orders : #

Sync Orders allows you to synchronize orders in either ascending or descending order for a specific time period. If you have a large volume of data, ensure you select a date range of 15 days or one month to avoid Google Quota Limit issues.

• In the first dropdown menu, you can choose between Ascending or Descending order.
• In the second dropdown, you can specify the date range by selecting From Date to To Date.
• In the third dropdown, you can select from options like All Orders, Pending Orders, Processing Orders, Completed Orders, Cancelled Orders, Refunded Orders, and more.

Sync Orders is for syncing orders in Ascending manner or descending manner for a specific period of time.

Sync Products : #

Sync Products allows you to synchronize orders in either ascending or descending order for a specific time period. If you have a large volume of data, ensure you select a date range of 15 days or one month to avoid Google Quota Limit issues.

• In the first dropdown menu, you can choose between Ascending or Descending order.
• In the second dropdown, you can specify the date range by selecting From Date to To Date.

Sync Products is for syncing orders in Ascending manner or descending manner for a specific period of time.

Sync Products Variation : #

Sync Products Variation allows you to synchronize orders in either ascending or descending order for a specific time period. If you have a large volume of data, ensure you select a date range of 15 days or one month to avoid Google Quota Limit issues.

• In the first dropdown menu, you can choose between Ascending or Descending order.
• In the second dropdown, you can specify the date range by selecting From Date to To Date.

Sync Products Variation is for syncing products variation in Ascending manner or descending manner for a specific period of time.

Sync Customers : #

Sync Customers allows you to synchronize orders in either ascending or descending order for a specific time period. If you have a large volume of data, ensure you select a date range of 15 days or one month to avoid Google Quota Limit issues.

• In the first dropdown menu, you can choose between Ascending or Descending order.
• In the second dropdown, you can specify the date range by selecting From Date to To Date.

Sync Customers is for syncing customers in Ascending manner or descending manner for a specific period of time.

Sync Coupons : #

Sync Customers allows you to synchronize orders in either ascending or descending order for a specific time period. If you have a large volume of data, ensure you select a date range of 15 days or one month to avoid Google Quota Limit issues.

• In the first dropdown menu, you can choose between Ascending or Descending order.
• In the second dropdown, you can specify the date range by selecting From Date to To Date.

Sync Coupons is for syncing Coupons  in Ascending manner or descending manner for a specific period of time.

Google Sheet Sync is for syncing data to Google Sheet.