Configure WooCommerce Google Sheet Connector PRO Data Settings

This guide walks you through the WooCommerce Data Settings page of the WooCommerce Google Sheet Connector – Pro Version. After successfully completing the Google integration and configuring the necessary permissions, this is where you’ll connect your spreadsheet, choose which order statuses and data tabs to sync, filter by category, set up 2-Way Sync, add extra columns, schedule syncing, and style your sheet — all in one place.

Before You Begin

• Complete the Pro Version Installation and check the Requirements doc.

• Complete the (Automatic Integration, Manual Integration, or Service Account) method that fits your setup, and confirm the plugin shows a Connected status under the Integration tab.

• Make sure WooCommerce is active on your site, with at least one product ready so you can test the sync once setup is complete.

WooCommerce Data Setting

From your WordPress dashboard, go to: WooCommerce → Google Sheet → WooCommerce Data Settings.

The Pro version’s Data Settings page is organized into a clear, step-by-step flow — spreadsheet selection, tab translation, order status and custom tabs, sync formatting, category filters, 2-Way Sync, extra columns, scheduling, and header styling. Let’s go through each section in order.

Step 1: Choose Your Google Spreadsheet

This is where you connect the Google Spreadsheet that will receive your WooCommerce data.

1. Use the Sheet Name dropdown to select your Google Spreadsheet. Click the eye icon to view the selected sheet directly, or click Select the Google Sheet linked to your OAuth account to confirm it matches your connected Google account.

2. If your sheet isn’t listed, click “If Not showing Sheet Name? Then Click here to fetch it” to refresh the list of spreadsheets pulled from your Google Drive.

3. Don’t have a sheet yet? Choose the Create a New Sheet option and the plugin will generate one automatically in your Google Drive.

4. Once selected, click Save to continue.

Step 2: Translate Google Sheets Tab Names

This displays your Google Sheet tab names in the language selected for your WordPress site, instead of the default English labels.

• Turn on Enable Language Translation and choose your site’s language so your tab names automatically match it.

Step 3: Order Status Sheet Tabs

This section controls which WooCommerce order statuses get their own tab inside your Google Spreadsheet.

• Enable the toggle next to each status you want synced as its own tab — Pending Orders, Processing Orders, On Hold Orders, Failed Orders, Completed Orders, Cancelled Orders, Refunded Orders, Trashed Orders, and All Orders (a combined tab with every order regardless of status).

• Use Select All to enable every status tab at once.

Step 4: Custom Order Sheet Tabs

If your store uses custom order statuses — created by another plugin such as Custom Order Status for WooCommerce, or statuses like Quality Check, Ready to Ship, VIP Priority Processing, Backordered, Returned – Inspection Required, Delivered – Pending Confirmation, Ready for Pickup, Customization in Progress, or Draft — this section lets you create a dedicated Google Sheet tab for each one.

• Any custom order statuses active on your site appear here automatically — simply toggle on the ones you want synced to their own tab.

Step 5: Sync Additional Sheet Tabs

Beyond orders, you can sync other WooCommerce data types into their own dedicated tabs.

• Toggle on All Products, All Products Variation, All Customers, and/or All Coupons to create and keep dedicated tabs updated automatically for each data type. Enabling these fields will reveal their individual settings further down the page.

Step 6: How Orders Are Synced

This section controls the format used to write your order rows.

• Order Wise: a single entry (row) is saved per order in your Google Sheet, even if it contains multiple products.

• Product Wise: each product is shown as its own entry, with the same Order ID repeated if an order contains multiple products — giving you line-item level detail.

• Sorting: choose Ascending (entries added in increasing order, e.g. 1, 2, 3…100) or Descending (entries added in decreasing order, e.g. 100, 99, 98…1) — this format and sorting is applied across all tabs in the sheet.

Step 7: Order Category Filter

Use this to sync only orders containing products from specific categories, instead of every order.

1. Enable Select Category to turn on category-based filtering for orders.

2. Toggle on the categories you want included. When enabled, only orders matching the selected categories are added, updated, and synced; when disabled, all categories are included.

Step 8: Product Category Filter

This works the same way as the Order Category Filter above, but applies to your Products tab.

1. Enable Select Category, then toggle on the specific categories you want synced.

2. Only products in the selected categories will be added, updated, and synced to your Google Sheet.

Step 9: 2-Way Sync

2-Way Sync lets you manage WooCommerce data directly from your Google Sheet, not just view it. For a deeper look, see the dedicated 2-Way Sync – Pro Version guide.

1. Turn on Enable 2-Way Sync to allow changes made in Google Sheets to update WooCommerce data.

2. Under Select Sync Modules, choose which data types are eligible — Orders, Products, Products Variation, Customers, and/or Coupons.

3. Under Allowed Actions, choose which operations are permitted from the sheet side — Insert, Update, and/or Delete.

Step 10: Add Extra Google Sheet Columns (Google Sheet Headers)

This section gives you full control over exactly which columns appear in your Google Sheet, across five tabs — Orders, Products, Product Variation, Customers, and Coupons.

1. Use Select Field to pick a field and enter a custom Column Name, then click ADD to include it in your sync. This is how you add extra fields related to the order (for example, the customer’s IP address), extra fields related to the order’s product (for example, tax class), custom static headers (for example, IP Address or Site Name), or custom static blank/placeholder headers.

2. Turn on Enable All Columns if you want every available field synced at once.

3. Below that, you’ll find the full list of default fields for the selected tab, shown as individual toggles. Toggle any field on or off to control exactly what appears in your sheet, and use the pencil icon next to a field to rename its column header. Developers who want to go further can also add or modify fields using the Filters, Hooks & Snippets doc.

Orders Header Fields

Toggling these fields on creates a matching column in your Orders tab:

• Order ID – Unique identifier for the order.
• Status / Order Status – Current status of the order (Processing, Completed, etc.).
• Product Name – The name of the product (with quantity/SKU if enabled).
• Product Id – Unique identifier for the product.
• Product Image – The image URL of the product.
• Product Meta – Meta data associated with the product (e.g., product attributes).
• Product Variation – Variation details if the product is a variation (size, color, etc.).
• SKU – The Stock Keeping Unit identifier for the product.
• Product Quantity – The quantity of each product purchased.
• Product Base Price – The base price of the product before discounts or taxes.
• Product Total – Total cost of the product (quantity × price).
• Product Tax – Tax applied to the product.
• Product Categories – Categories associated with the product.
• Partial Refund Amount – The amount refunded if the order was partially refunded.
• Order URL – URL to view the order details.
• Status Updated Date – The date the order status was last updated.
• Transaction ID – The unique identifier for the payment transaction.
• Customer ID – Unique identifier for the customer.
• Order Completion Date – The date the order was completed.
• Order Paid Date – The date the order was paid.
• Order Notes – Notes attached to the order by the store admin.
• Currency – The currency in which the order was paid.
• Tax Total – Total tax applied to the order.
• Order Total – The total order amount (including taxes, shipping, and discounts).
• Order Total (Excl. Shipping Charges and Other Fees) – The total order value excluding shipping and other fees.
• Payment Method – The method of payment used (e.g., PayPal, Credit Card).
• Billing First Name / Last Name – Name on the billing address.
• Billing Address 1 / Address 2 – Billing address lines.
• Billing City / State / Postcode / Country – Billing location fields.
• Billing Company Name – The company name (if any) on the billing address.
• Shipping First Name / Last Name – Name on the shipping address.
• Shipping Address 1 / Address 2 – Shipping address lines.
• Shipping City / State / Postcode / Country – Shipping location fields.
• Shipping Method Title – The shipping method used (e.g., Flat Rate, Free Shipping).
• Shipping Company Name – The company handling shipping (e.g., USPS, FedEx).
• Discount Total – Total discounts applied to the order.
• Discount Tax – Tax amount applied to the discount.
• Shipping Total – Total cost of shipping.
• Shipping Tax – Tax applied to the shipping cost.
• Cart Tax – Tax applied to the cart before discounts.
• Coupon Codes – Any coupon codes applied during checkout.
• Email – The email address associated with the order.
• Phone – The customer’s phone number.
• Customer Note / Customer Notes – Notes provided by the customer at checkout.
• Created Date – The date the order was created.
• Customer Total Orders – Total number of orders placed by the customer.
• Customer Total Revenue – Total revenue spent by the customer.
• Customer Average Order Value – Average order value for the customer.
• Product URL – The URL to the product page.

Products & Product Variation Header Fields

The Products and Product Variation tabs use their own header sets, covering fields such as Product Name, Product Status, Short/Full Description, Slug, Link, Categories, SKU, Type, Image, Tags, Attributes, Regular/Sale Price and Sale Dates, Stock and Stock Status, Weight/Dimensions, Shipping Class, Tax Status/Class, Virtual/Downloadable flags, Download Limit/Expiry, Backorders, Date Created/Modified, Total Sales, and — for variations specifically — Variation ID, Variation SKU, Variation Image, Variation Price/Stock/Weight/Dimensions, and Grouped Product IDs. Toggle each one on or off the same way as the Orders tab.

Customers & Coupons Header Fields

The Customers tab covers fields like Customer ID, Username, Role, First/Last Name, Nickname, Display Name, Email, Website, Bio, Profile Image, and full Billing/Shipping address details. The Coupons tab covers Coupon ID, Coupon Code, Description, Discount Type, Coupon Amount, Status, Free Shipping, Expiry Date, Min/Max Spend, Individual Use Only, Exclude Sale Items, Applicable/Excluded Products and Categories, Allowed Emails, and Usage Limits (per coupon and per user).

Step 11: Cron Settings

By default, orders sync in real time as they happen. If you’d rather sync on a schedule instead, use this section. This pairs well with the Feed Settings feature if you’re managing multiple sheets or feeds.

1. Turn on Enable Cron Sync, then choose Set Schedule or No Schedule.

2. Pick a Schedule Type — Repeat Weekly for recurring syncs, or Run Once for a single scheduled sync — then set the Date and Time.

3. Keep Real Time Sync enabled if you also want new orders to sync instantly in addition to your cron schedule.

Step 12: Header Settings

Customize how your Google Sheet’s header row and data rows look. If you also want to adjust how dates appear, see How to Change Date/Time Format and Time Zone in Google Sheets.

• Header Behavior: turn on Freeze Header to keep the header row visible while scrolling.

• Header Style: set the header’s font style, font size, font color, and background color.

• Row Style: enable Row Appearance and set font style/size, plus separate colors for odd and even rows for readability.

• Turn on Spreadsheet Download if you’d like a download option available for your synced sheet — though since it’s a normal Google Sheet, you can always download it as Excel (.xlsx) or CSV via File → Download in Google Sheets too.

Step 13: Save Your Data Settings

Once you’ve selected your spreadsheet, enabled the tabs you need, reviewed your columns, and configured 2-Way Sync, Cron, and Header settings, click the Save Settings button at the bottom of the page.

Step 14: Google Sheets Data Sync (Manual Sync)

In addition to automatic syncing, use these tools to manually backfill existing data. For each, choose Ascending or Descending order and a From Date to To Date range, then click the sync button.

• Sync Orders — also lets you filter by order status (All Orders, Pending, Processing, On Hold, Completed, Cancelled, Refunded, Failed, Trashed, or any custom status you’ve created).

• Sync Products and Sync Products Variation — push existing product and variation data into your sheet.

• Sync Customers and Sync Coupons — push existing customer and coupon records into their tabs.

What Happens After You Save?

• Every new WooCommerce order, product, customer, or coupon will automatically be added as a new row in your connected Google Sheet, based on the tabs you enabled.
• Each enabled tab updates independently with its own data.
• You can return to the Data Settings page anytime to enable/disable tabs, adjust columns, or change the connected spreadsheet.

Quick Checklist

• Google Sheet selected (or newly fetched/created) and saved
• Required Order Status Tabs (and any Custom Order Status tabs) enabled
• Row management (Order Wise / Product Wise) and Sorting chosen
• Category filters reviewed, if needed
• 2-Way Sync configured, if needed
• Google Sheet columns reviewed and customized
• Compatibility Mode enabled under WooCommerce → Settings → Advanced → Features (if extra headers are missing)
• Data Settings saved by clicking Save Settings
• Test order placed to confirm data is syncing correctly

Related Guides

If you haven’t completed these steps yet, or run into any issues while configuring the settings above, check out the following related guides:

• Automatic Integration with Google – Connect WooCommerce with Google Sheets using the quick, one-click method.
• Manual Integration with Google (OAuth) – Connect using your own Google Cloud Project, Client ID, and Client Secret.
• Service Account Authentication Guide – Connect using a Google Service Account and JSON Key file instead of OAuth login.
• WooCommerce Data Settings – Free Version – See what’s available without Pro.
• Feed Settings – (New) – Manage multiple sync feeds.
• Filters, Hooks & Snippets – Customize fields further with code.
• 2-Way Sync – Pro Version – Manage store data directly from your sheet.
• System Status and Common Errors & Google Quota Issues – Troubleshoot sync failures and API quota limit errors.