2-Way Sync PRO Version 2.1.0

Introducing an Improved Google Sheet to WooCommerce Sync – Now Smarter in Version 2.1.0 #

We’re excited to share that the Google Sheet to WooCommerce Sync feature has been enhanced in version 2.1.0 to make it easier and more efficient for users to manage products directly from Google Sheets.

This functionality already existed in earlier versions, but we’ve now improved the way it works to ensure it’s more user-friendly and seamless. With just a few simple steps, you can now add or update single or bulk products from your connected sheet directly into your WooCommerce store.

In this article, we’ll guide you step by step on how to configure and use this updated feature effectively.

🔔 Important Note for 2-Way Sync (v2.1.0)

The 2-Way Sync feature works only with default WooCommerce product fields.

If you update fields that are added by third-party plugins, those changes will not reflect on your WooCommerce store. While these third-party plugin fields may appear in your Google Sheet feed, updating them via 2-Way Sync will not update the actual store data.

Only fields supported by WooCommerce itself are eligible for syncing back to the store.

Please keep this in mind while using 2-Way Sync to avoid any confusion or data mismatch.

Step 1: Enable Product Feed Settings #

1. Go to  Feed Settings in your WordPress dashboard.

2. Open the Product Feed section.

3. Enable the option “2-Way Sync Products”.

4. Click the “Submit Data” button to save your settings.

Step 2: Display “Sync from Google Sheet” Button #

1. After submitting, scroll back up to the “2-Way Sync Products” section.

2. You will now see a “Sync from Google Sheet” button.

Step 3: Perform Initial Sync #

1. Before using the sync from Google Sheet, go to the “Sync Products” section.

2. Perform a full sync to make sure your WooCommerce product data is up to date in the Google Sheet.

Step 4: Understanding Google Sheet Columns #

Open your connected Google Sheet named “GSC Products Feed”. At the end of the sheet, you’ll see three additional columns:

• Insert

• Update

• Delete

These same headers will also appear under the “Google Sheet Headers” section in the Product Feed settings.

 

Step 5: Modify Product Data in Google Sheet #

Depending on what you want to do, follow the instructions below:

• To Update a Product:

  • Enter 1 in the Update column for the corresponding product row.

  • Make your changes in the respective columns.

• To Delete a Product:

  • Enter 1 in the Delete column for the corresponding product row.

• To Insert a New Product:

  • Add a new row with product details (e.g., title, price, etc.) excluding Product ID.

  • Enter 1 in the Insert column.

Step 6: Sync Changes Back to WooCommerce #

1. Go back to Feed Settings > Product Feed > 2-Way Sync Products.

2. Click the “Sync from Google Sheet” button.

3. A confirmation popup will appear asking if you’re sure about syncing changes.

4. Click OK to proceed.

You will now see a summary like:

• 1 Product Inserted

• 1 Product Updated

• 1 Product Deleted

• Click the “Process” button to apply these changes to your WooCommerce store.

• If you don’t want to apply the changes, click the “Cancel” button.

You’re Done! #

Now your WooCommerce store and Google Sheet are successfully synced both ways.

2-Way Sync Orders Configuration: Sheet to WooCommerce #

Step 1: Enable Order Feed Settings #

1. Go to GSheetConnector > Feed Settings in your WordPress dashboard.

2. Open the Order Feed section.

3. Enable the option “2-Way Sync Orders”.

4. Click the “Submit Data” button to save your settings.

Step 2: Display “Sync from Google Sheet” Button #

1. After submitting, scroll back up to the “2-Way Sync Orders” section.

2. You will now see a “Sync from Google Sheet” button.

Step 3: Perform Initial Sync #

1. Before syncing from the Google Sheet, go to the “Sync Orders” section.

2. Perform a full sync to ensure your WooCommerce order data is available and up to date in the connected Google Sheet.

Step 4: Understanding Google Sheet Columns #

Open the connected Google Sheet named ex.“GSC Orders Feed”. At the end of the sheet, you’ll see three special columns:

• Insert

• Update

• Delete

These headers are also visible under the “Google Sheet Headers” section in the Order Feed settings.

Step 5: Modify Order Data in Google Sheet #

Depending on the action, do the following:

• To Update an Order:

  • Enter 1 in the Update column of the desired row.

  • Update the status or details as needed (e.g., Order Status, Billing Address, Shipping Address, Notes).

• To Delete an Order:

  • Enter 1 in the Delete column of that order row.

• To Insert a New Order:

  • Add a new row with all required order information (like customer details, product info, status).

  • Do not fill the Order ID column.

  • Enter 1 in the Insert column.

 

Step 6: Sync Changes Back to WooCommerce #

1. Go back to Feed Settings > Order Feed > 2-Way Sync Orders.

2. Click the “Sync from Google Sheet” button.

3. A popup will appear asking for confirmation.

4. Click OK to proceed.

You’ll see a confirmation like:

• 1 Order Inserted

• 1 Order Updated

• 1 Order Deleted

5. Click the “Process” button to apply these changes to your WooCommerce store.

6. If you don’t want to proceed, click the “Cancel” button.

Now your WooCommerce Orders and Google Sheet are fully synced both ways using the WooCommerce GSheetConnector plugin.