2-Way Sync - PRO Version (New) – Google Sheet Connector

2-Way Sync Guide (v2.1.0)

2-Way Sync for WooCommerce and Google Sheets: The Complete Guide (v2.1.0)

If you’ve ever wished you could manage your WooCommerce products, orders, customers, or coupons straight from a spreadsheet, this update is for you. With version 2.1.0 of WooCommerce Google Sheet Connector, 2-Way Sync is faster to set up and easier to use than ever, and it now works consistently across four areas of your store: Products, Orders, Customers, and Coupons.

The core idea hasn’t changed: you edit a row in your connected Google Sheet, flag it as an insert, update, or delete, and the plugin pushes that change into WooCommerce. What’s new in 2.1.0 is how much smoother that process feels — clearer columns, a confirmation step before anything touches your live store, and a summary that tells you exactly what’s about to change.

This guide walks through the setup and day-to-day workflow for each of the four sync types. If you haven’t installed or connected the plugin yet, start with our WooCommerce Google Sheet Connector documentation to get the base integration running first — 2-Way Sync builds on top of that connection.

Before you start: 2-Way Sync only recognizes WooCommerce’s own built-in fields. If a field comes from a third-party plugin, it may still show up in your Google Sheet feed, but editing it there won’t change anything in your store. Keep changes to standard WooCommerce fields to avoid confusion.

How 2-Way Sync Works, in Plain Terms

Every synced Google Sheet gets three extra columns at the end: Insert, Update, and Delete. To make something happen in WooCommerce, you put a 1 in the right column for that row, then trigger the sync from your WordPress dashboard. Nothing changes automatically the moment you edit the sheet — you’re always shown a summary first, and you decide whether to apply it or cancel.

Syncing Products: Sheet to WooCommerce

Step 1: Turn on Product Feed Sync

In your WordPress dashboard, go to GSheetConnector → Feed Settings.
Open the Product Feed section.
Switch on “2-Way Sync Products”.
Click “Submit Data” to save.

Enabling 2-Way Sync Products in WooCommerce Google Sheet Connector — Turn on 2-Way Sync Products under Feed Settings → Product Feed, then save with Submit Data.

Step 2: Find the “Sync from Google Sheet” Button

Once you’ve saved, scroll back up to the 2-Way Sync Products section — you’ll now see a new button, “Sync from Google Sheet.” That’s the button you’ll come back to every time you want to push changes from your sheet into WooCommerce.

Sync from Google Sheet button for products — After saving, the Sync from Google Sheet button appears in the 2-Way Sync Products section.

Step 3: Do a Full Sync First

Before you touch anything manually, head to the Sync Products section and run a full sync. This pulls your current WooCommerce catalog into the sheet so you’re editing real, up-to-date data rather than starting from a blank slate.

Running an initial full product sync — Run a full sync from the Sync Products section before making any manual edits.

Step 4: Get Familiar with the Sheet Columns

Open the connected sheet — by default it’s named “GSC Products Feed.” Scroll to the far right and you’ll spot the three columns that drive everything: Insert, Update, and Delete. You’ll also see these same three listed under “Google Sheet Headers” in your Product Feed settings, so there’s no guesswork about which columns matter.

Insert, Update, and Delete columns in the Product Feed sheet — The Insert, Update, and Delete columns sit at the far right of your GSC Products Feed sheet.

Step 5: Make Your Changes in the Sheet

What you do next depends on what you’re trying to accomplish:

Updating an existing product: Edit the fields you want to change, then put 1 in the Update column for that row.
Deleting a product: Put 1 in the Delete column for that product’s row.
Adding a new product: Add a new row with the product’s details — title, price, and so on — but leave Product ID blank. Then put 1 in the Insert column.

Marking product rows for Insert, Update, or Delete — Flag each row with a 1 in the Insert, Update, or Delete column based on the action you want.

Step 6: Push the Changes to WooCommerce

Go back to Feed Settings → Product Feed → 2-Way Sync Products.
Click “Sync from Google Sheet.”
A popup will ask you to confirm — this is your chance to double-check before anything changes.
Click OK to continue.

Confirming a product sync from Google Sheet — Confirm the popup to review your pending Insert, Update, and Delete changes.

You’ll see a quick summary of what’s about to happen, something like:

1 Product Inserted
1 Product Updated
1 Product Deleted

If that looks right, click “Process” to apply it. If something looks off, click “Cancel” and go back to fix your sheet — nothing gets applied until you confirm.

Sync summary showing product changes ready to process — Review the summary, then click Process to apply the changes or Cancel to back out.

That’s it — your WooCommerce store and Google Sheet are now synced both ways for products.

Syncing Orders: Sheet to WooCommerce

Step 1: Turn on Order Feed Sync

Go to GSheetConnector → Feed Settings.
Open the Order Feed section.
Switch on “2-Way Sync Orders.”
Click “Submit Data” to save.

Enabling 2-Way Sync Orders in WooCommerce Google Sheet Connector — Turn on 2-Way Sync Orders under Feed Settings → Order Feed, then save with Submit Data.

Step 2: Find the “Sync from Google Sheet” Button

Scroll back to the 2-Way Sync Orders section after saving, and you’ll see the same “Sync from Google Sheet” button, ready to use.

Sync from Google Sheet button for orders — The Sync from Google Sheet button appears once 2-Way Sync Orders is saved.

Step 3: Run an Initial Sync

Head to the Sync Orders section first and run a full sync, so your order data in the sheet actually reflects what’s currently in WooCommerce.

Running an initial full order sync — Run a full sync from the Sync Orders section before editing anything manually.

Step 4: Know Your Columns

Open the sheet — usually named “GSC Orders Feed” — and look at the far right for the same three columns: Insert, Update, and Delete. They’re also listed under “Google Sheet Headers” in the Order Feed settings.

Insert, Update, and Delete columns in the Order Feed sheet — The three action columns sit at the far right of your GSC Orders Feed sheet.

Step 5: Edit Order Data in the Sheet

Updating an order: Change what you need — order status, billing address, shipping address, notes — then put 1 in the Update column.
Deleting an order: Put 1 in the Delete column for that row.
Adding a new order: Fill in customer details, product info, and status in a new row, leave Order ID blank, and put 1 in the Insert column.

Marking order rows for Insert, Update, or Delete — Flag each order row with a 1 in the appropriate action column.

Step 6: Sync Back to WooCommerce

Go to Feed Settings → Order Feed → 2-Way Sync Orders.
Click “Sync from Google Sheet.”
Confirm the popup.
Click OK.

Confirming an order sync from Google Sheet — Confirm the popup to review your pending order changes.

You’ll get a summary like:

1 Order Inserted
1 Order Updated
1 Order Deleted

Click “Process” to confirm, or “Cancel” if you’d rather not apply the changes yet.

Order sync summary ready to process — Review the summary before deciding to process or cancel.

Your orders and Google Sheet are now fully in sync, in both directions.

Syncing Customers: Sheet to WooCommerce

Step 1: Turn on Customer Feed Sync

Go to GSheetConnector → Feed Settings.
Open the Customers Feed section.
Switch on “2-Way Sync Customers.”
Click “Submit Data” to save.

Enabling 2-Way Sync Customers in WooCommerce Google Sheet Connector — Turn on 2-Way Sync Customers under Feed Settings → Customers Feed, then save with Submit Data.