1. Home
  2. Docs
  3. WooCommerce GSheetConnect...
  4. 2-Way Sync Products

2-Way Sync Products

2-Way Sync Products Configuration: Sheet to WooCommerce

We’re excited to introduce the Google Sheet to WooCommerce Sync feature. This feature will be available in the beta version: 2.0.27-beta2 and the stable version will be released in 2.0.27.

Now, you can seamlessly add single or bulk products within your connected sheet. Simply follow the provided instructions, click to sync, and watch as your products are seamlessly integrated into your WooCommerce store.

In this article, I will show you a step-by-step configuration, while explaining how it works.

Connected WooCommerce Google Sheet

Within the Connected WooCommerce Google Sheet, you’ll see the linked sheet. Please note that sheet settings cannot be updated from this interface.

2-Way Sync Products Connected Sheet

Sync Settings for Two-Way Sync

These sync settings facilitate the seamless transfer of records to WooCommerce within the selected Google Sheet.

Considerations for Two-Way Sync

  • Ensure the header names remain unchanged from the default settings during synchronization.
  • Leave the Product ID field blank; it will be automatically updated once the sync is processed. If a Product ID is present, the sync will fail and display an error.
  • To add multiple Product Categories and tags, separate them with commas (,).
  • Mandatory fields include Product Name, with a dash (-) added in the last column.
  • Specify the rows for synchronization. For a single row, input the same number in both text boxes.
  • Example of Single Row: If the product is in row 5, enter ‘5’ in both boxes and click to sync.
  • Example of Multiple Rows: If products are listed in rows 5-10, input ‘5’ and ’10’ in the respective boxes and initiate the sync.
  • In the Image column, upload the image from media, copy the uploaded image path, and paste it in the corresponding column for each product.
  • For the Product Downloadable Files column, upload a single file from media, copy the uploaded file path, and paste it in the relevant column for each product.

Supported Fields for Synchronization

Please note that only the following list of fields will sync. If you’re using any other custom fields or columns based on third-party plugins, they will not sync:

  • Product Id
  • Product Name
  • Product Status
  • Product Short Description
  • Product Description
  • Product Slug
  • Product Link
  • Product Categories
  • Product SKU
  • Product Type
  • Product Image
  • Product Tags
  • Product Regular Price
  • Product Sale Price
  • Product Sale Price Dates From
  • Product Sale Price Dates To
  • Product Stock
  • Product Stock Status
  • Product Weight
  • Product Height
  • Product Width
  • Product Length
  • Product Total Sale
  • Product Purchase Note
  • Product Dimensions
  • Product Sold Individually
  • Manage Product Stock
  • Product Shipping Class
  • Product Tax Status
  • Product Tax Class
  • Virtual Product
  • Date Created
  • Date Modified
  • Product Downloadable
  • Product Downloadable Files
  • Product Downloadable File Names
  • Product Download Limit
  • Product Download Expiry
  • Product Allow Backorders
  • Grouped Products Ids
  • External Product Button Text
  • External Product Link

In Google Sheet

Go to the connected Google Sheet, add product info as you prefer, and insert a dash (-) in the final column.

2-Way Sync Google Sheet Setting

Google Sheet Configuration for 2-Way Sync

In 2-Way Sync Tab

Insert and Update Products

Sheet to WooCommerce Insert

Start by reviewing the considerations provided. Once you have a clear understanding, proceed to indicate the range of rows where you wish to insert new data. For example, specify the range as starting from the second(2) row and ending at the second(2) row.

Then, click on “Click to Sync Insert,” and your product will be generated based on the provided product information.

Sync Insert Example for 2-Way Sync

Sheet to WooCommerce Update

Update the Google Sheet accordingly. Then navigate to the WordPress Dashboard and locate the WooCommerce Google Sheet Connector – 2-Way Sync plugin. Enter the desired row range, for example, from 2 to 200, as per your preference.

Click “Click to Sync Update,” and your product will be updated based on the provided product information.

Sync Update Example for 2-Way Sync

Note: If you encounter a quota limit error while syncing from the sheet to WooCommerce, consider authentication with the manual method, as this limit is set by the Google API.

How can we help?