Quick Start Guide for Stock Sync Sheets

Use this step-by-step setup guide to connect Google Sheets to WooCommerce, run your first dry sync, review uncertain matches, and go live with more confidence.

Back to Guides View Product Page

6 steps to getting started

Follow these steps in order so your first live sync is based on a clean setup instead of guesswork.

Step 1: Go to the Settings page

Start by setting up the Google Sheet connection and the fields the plugin needs to read correctly.

Create or prepare your Google Sheet for stock data.
Enter your Google API key.
Add the Google Sheet ID.
Choose the tab name you want to sync.
Set the model code column.
Set the quantity column.
Set the row range you want to read, such as 5–100.
Save your settings before moving on.

Step 2: Open the Viewer page

This is where you run your first sync test and start checking how your sheet matches to WooCommerce products.

Open the Viewer page from your WordPress admin menu.
Turn Dry Run ON for your first test.
Optionally enable Scheduled Sync later, but do not rely on it yet.
Click “Sync to WooCommerce” to begin your first dry sync.

Step 3: Review matches

Your first dry sync shows how the plugin is interpreting your rows before any live stock changes happen.

Confident matches are auto-matched automatically.
Unclear matches appear in the Manual Match section.
Use this stage to check whether your matching fields are working as expected.
Do not move to a live sync until this stage looks clean enough.

Step 4: Handle manual matches

This is where you fix anything the plugin could not confidently match on its own.

Use the dropdown or search box to assign the correct WooCommerce product.
If the correct product is not listed, search for it manually.
If the product does not exist in WooCommerce, select “None of these”.
This sends the model code to Ignored Matches.
Click Save Matches to confirm your selections.
Use this step carefully because it helps build cleaner future syncs.

Step 5: Check the Confirmed Matches page

This page shows which matches are now saved and ready to help future syncs run more cleanly.

All successful auto and manual matches are listed here.
Some auto-matches may be marked as auto or exact.
If an auto-match is wrong, send it back to manual review.
You can disable future auto-matching for that model code if needed.
That model code can move to Blacklisted Matches until you decide otherwise.

Step 6: Run your final sync test

Before going live, run one more dry sync to confirm that the workflow is clean enough to trust.

Run another dry sync after manual review is complete.
Check that the logs are clean enough.
Check that auto-matches look accurate.
Check whether there are still manual or ignored products needing attention.
Turn Dry Run OFF only when you are satisfied with the results.
Run your first real sync.
Set a schedule only after the live workflow is behaving properly.

Once fully set up, your stock can update much more cleanly and with far less manual work — helping keep WooCommerce aligned with your Google Sheets workflow.

Using Product Builder or Sheet Push as well?

Stock Sync Sheets includes more than the core stock sync workflow, but this quick start guide is focused on helping you get stock syncing working first.

Other included tools

Once your stock sync workflow is working properly, you can also make use of these included tools:

Product Builder helps you create or update WooCommerce products from your sheet data.
Sheet Push helps push WooCommerce stock data back to Google Sheets.

This page keeps the focus on getting your core stock sync setup working first, because that is the safest place to start.

Before you go live

A clean first live sync usually comes down to checking a few important things properly before turning Dry Run off.

Use this checklist before your first live update

These checks help reduce early setup mistakes and give you a safer starting point.

Make sure your Google Sheet ID, tab name, and columns are correct.
Confirm that the row range is pulling the rows you expect.
Run a dry sync before any live stock change.
Review unclear matches instead of forcing a guess.
Check Confirmed Matches after successful matching.
Only enable scheduled syncs once your dry run and first live sync look reliable.

Ready for the next step?

Go back to the main guides page for more setup help, videos, and documentation, or view the product page if you are still comparing before purchase.

Back to Guides View Product Page