Documentation

Stock Sync Sheets Documentation

Stock Sync Sheets helps WooCommerce stores run stock, product, and sheet-based workflows from Google Sheets.

You can use it to sync stock quantity and stock status, run dry syncs before live updates, review uncertain product matches, save confirmed matches, manage ignored and blacklisted matches, work with supplier sheets, push WooCommerce stock data back to Google Sheets, use Push on Sale, and create or update WooCommerce products with Product Builder.

The safest setup order is:

Set up Stock Sync first.
Run Dry Run before live updates.
Resolve Manual Review items.
Confirm correct matches.
Enable scheduling only after testing.
Then expand into Product Builder, Sheet Push, Push on Sale, AI Review, and the Price Sync add-on if needed.

Installation

↑ Back to top

To start using Stock Sync Sheets from WooCommerce.com:

Go to your WooCommerce.com account.
Open My subscriptions.
Find Stock Sync Sheets.
Use Add to store or download the plugin ZIP.
Install and activate the plugin on your WordPress site.

After activation, open your WordPress admin area and go to:

WooCommerce > Stock Sync Sheets

The plugin opens from the WooCommerce admin menu.

Main admin pages

↑ Back to top

Stock Sync Sheets is split into separate admin pages so each part of the workflow is easier to understand.

Dashboard — overview of all major modules.
Stock Sync — run stock syncs, dry runs, sheet preview, manual review, and logs.
Settings — configure Google Sheets, columns, row ranges, schedules, and stock sync settings.
Confirmed Stock — manage saved stock matches.
Ignored Stock — manage ignored stock items.
Blacklist Stock — manage bad stock match pairs.
Price Sync — available when the separate Price Sync add-on is installed.
Ignored Price — manage ignored price items when the Price Sync add-on is active.
Confirmed Price — manage confirmed price matches when the Price Sync add-on is active.
Blacklist Price — manage bad price match pairs when the Price Sync add-on is active.
Product Builder — create or update products from mapped Google Sheet data.
AI Review — review staged AI product drafts before import.
Sheet Editor — sheet-related editing and workflow tools.
Sheet Push — push WooCommerce stock data back to Google Sheets.

Dashboard

↑ Back to top

The Dashboard is the home screen for Stock Sync Sheets.

It is read-only. It does not run syncs, save settings, import products, or push data. It gives you a quick overview and links to the correct pages.

Dashboard cards

↑ Back to top

The dashboard can show cards for:

Stock Sync
Price Sync
Product Builder
Sheet Push
AI Review

Stock Sync card

↑ Back to top

The Stock Sync card can show:

Configured sheet count
Dry Run status
Schedule status
Next scheduled run
Pending manual matches
Confirmed stock matches
Ignored and blacklist counts
Latest stock sync log summary

Price Sync card

↑ Back to top

The Price Sync card shows whether the separate Price Sync add-on is active. If the add-on is missing, it should show that Price Sync is not detected instead of causing an error.

Product Builder card

↑ Back to top

The Product Builder card can show configured builder sheets, preview state, AI status, AI API key status, and staged draft counts.

Sheet Push card

↑ Back to top

The Sheet Push card can show Sheet Push availability, incremental push status, Push on Sale status, mapping status, and latest push summary.

AI Review card

↑ Back to top

The AI Review card can show AI enabled status, API key status, pending drafts, approved drafts, and imported drafts.

Quick Start Guide

↑ Back to top

Use this setup flow for the safest first sync.

Step 1: Prepare your Google Sheet

↑ Back to top

Your stock sheet should have clear columns for the data you want to sync.

Common stock sheet columns include:

SKU
Model code
Product name
Quantity
Stock status
Product type
Parent SKU
Variation attributes

Your exact sheet can be different, but the columns must match the settings you configure in the plugin.

Step 2: Configure Stock Sync settings

↑ Back to top

Go to:

WooCommerce > Stock Sync Sheets > Settings

Configure your sheet details, including:

Google API key
Sheet name or supplier label
Google Sheet ID
Tab name or gid
Column mappings
Row start and row end
Category filters, if used
Schedule settings, if needed

Save the settings before running a sync.

Step 3: Open Stock Sync

↑ Back to top

Go to:

WooCommerce > Stock Sync Sheets > Stock Sync

Use the Stock Sync page to:

Select which sheets to include
Choose Dry Run or Live Sync
Load a sheet preview
Run a sync
Review logs
Resolve pending manual matches

Step 4: Run Dry Run first

↑ Back to top

Before running a live sync, tick Dry Run for the sheet you want to test.

Dry Run lets you check the workflow without changing live WooCommerce stock.

After Dry Run, review:

Matched products
Products that would update
Skipped rows
Manual review items
Errors or warnings

Step 5: Resolve Manual Review

↑ Back to top

If the plugin cannot safely match a row to a WooCommerce product, it can send the row to Manual Review.

For each manual review item, you can:

Select a suggested product
Search WooCommerce products
Choose none of the suggestions
Save the correct match for future syncs

Step 6: Run live sync

↑ Back to top

After Dry Run looks correct and Manual Review items are resolved, run a live sync.

Live sync updates WooCommerce based on your configured workflow.

Step 7: Enable schedules later

↑ Back to top

Only enable scheduled sync after you have tested the sheet, row range, mapping, dry run, and manual review workflow.

Stock Sync page

↑ Back to top

The Stock Sync page is where you run and inspect stock workflows.

What this page does

↑ Back to top

Shows configured sheets
Lets you select Dry Run or Live Sync per sheet
Shows next scheduled sync where applicable
Loads sheet preview rows
Runs selected sheet syncs
Shows sync logs
Exports logs to CSV
Displays pending manual product matches

Sheets to Include

↑ Back to top

The Sheets to Include table controls which sheets are included for Dry Run or Live Sync.

Dry Run simulates the sync and logs what would happen.
Live Sync applies updates to WooCommerce.
Next Scheduled Sync appears only when scheduling is enabled for a sheet.

Sheet Preview

↑ Back to top

Use Load Sheet Preview to fetch and inspect the latest sheet rows before syncing.

This helps confirm:

The sheet is connected
The row range is correct
The expected products are being read
Quantities look correct
Variation or parent fields are visible where used

Sync Log

↑ Back to top

The Sync Log shows what happened during preview, dry run, or sync.

Use logs to check:

Matched products
Updated products
Skipped rows
No-match rows
Manual review items
Errors from Google Sheets
Warnings about mapping or row data

Settings page

↑ Back to top

The Settings page controls the stock sync configuration.

Common settings

↑ Back to top

Google API key — used to read Google Sheet data.
Sheet ID — the Google Sheet ID.
Tab name or gid — the tab inside the Google Sheet.
Column mappings — tells the plugin which columns contain model code, SKU, product name, quantity, stock status, or other fields.
Row range — controls which rows are read.
Category filters — limits matching or syncing to selected WooCommerce categories where applicable.
Schedule — controls automatic sync timing.
Dry Run — lets you test without live updates.

Row range

↑ Back to top

Use row ranges to avoid reading the wrong part of the sheet.

Row Start is usually 2 if row 1 contains headers.
Row End can be left blank if you want to read all rows after the start row.

If your sync reads nothing, check the row range first.

Column letters

↑ Back to top

Use column letters only, such as:

A
B
C
AA
AB

Do not enter cell references like A2 or B10 unless a field specifically asks for a cell.

Manual Review

↑ Back to top

Manual Review protects your store from uncertain product matches.

If the plugin cannot confidently match a sheet row to the correct WooCommerce product, the item can be shown for review.

How to resolve a manual match

↑ Back to top

Open the Stock Sync page.
Scroll to Pending Manual Product Matches.
Review the model, quantity, and suggested products.
Select the correct WooCommerce product, or search for it manually.
If none are correct, choose none of the suggestions.
Confirm and sync the selected matches.

Why Manual Review matters

↑ Back to top

Manual Review is important when:

Supplier names are inconsistent
SKUs are missing
Products have similar names
Variation names look similar
A model code could match more than one product
You want control before live stock changes

Confirmed Stock Matches

↑ Back to top

Confirmed Matches store correct product matches so future syncs can use them again.

Use this page to:

View saved stock matches
Check which product a model code is linked to
Remove incorrect confirmed matches
Send a match back to Manual Review where supported
Export confirmed match data where available

If a confirmed match is wrong, remove it or send it back for review before running another live sync.

Ignored Stock Matches

↑ Back to top

Ignored Matches are used for rows or model codes you do not want to sync.

Use Ignored Matches when:

A sheet item should not update WooCommerce
A supplier row is not relevant to your store
A product is discontinued
You want to skip a model code without deleting it from the sheet

You can remove ignored entries later if you want them to be considered again.

Stock Blacklist

↑ Back to top

The Stock Blacklist helps stop known bad matches from repeating.

Use it when a model code was matched to the wrong product and you do not want that exact bad match to happen again.

Example:

Sheet model code: Flower 1
Wrong WooCommerce product match: Flower 12
Blacklist that bad pair so the same incorrect match is blocked in future auto-matching.

The blacklist should be used carefully. It is for blocking bad match pairs, not for removing products from your store.

Product Builder

↑ Back to top

Product Builder lets you create or update WooCommerce products from mapped Google Sheet data.

What Product Builder can do

↑ Back to top

Create new products from sheet rows
Update existing products from sheet rows
Use SKU or product ID for updates depending on your setup
Map product fields to sheet columns
Preview rows before importing
Stage AI product drafts where AI is enabled
Review logs after product creation or updates

Product Builder supported field examples

↑ Back to top

Depending on your mapping, Product Builder can work with fields such as:

Product types

↑ Back to top

Product Builder is designed for sheet-driven product workflows including product types such as:

Simple products
Variable products
Variation rows
Grouped products
External or affiliate products
Virtual products
Downloadable products

For variations, make sure your sheet includes the correct parent information and variation attributes.

Recommended Product Builder process

↑ Back to top

Create or prepare your product builder sheet.
Open Product Builder.
Add a sheet section if needed.
Enter the sheet URL or sheet details.
Configure row range.
Map product fields to sheet columns.
Save settings.
Run preview.
Review rows carefully.
Import only after the preview looks correct.

AI Settings and AI Review

↑ Back to top

AI tools are designed to stage product content for review before import.

AI Settings

↑ Back to top

AI Settings can include:

Enable AI
OpenAI API key
Model selection
Connection test

AI requests use your configured API key.

AI Review

↑ Back to top

AI Review is where you review staged AI product drafts.

Drafts should be reviewed before import. This avoids automatic live content changes.

Depending on your workflow, staged draft data may include:

Product title
Short description
Long description
Bullet features
SEO title
Meta description
Focus keyphrase

Recommended AI workflow

↑ Back to top

Enable AI in Product Builder.
Save your API key and model.
Run Product Builder preview.
Select rows for AI generation.
Generate staged drafts.
Open AI Review.
Review and approve drafts.
Import approved content only when ready.

Sheet Editor

↑ Back to top

Sheet Editor provides sheet-related workflow tools inside the plugin.

Use it when you need to access sheet tools from the same Stock Sync Sheets workflow instead of jumping between multiple areas.

The exact options shown can depend on the current plugin version and enabled modules.

Sheet Push

↑ Back to top

Sheet Push sends WooCommerce stock data back to Google Sheets.

This is useful when WooCommerce changes should be reflected in your sheet workflow.

Common Sheet Push uses

↑ Back to top

Push WooCommerce stock quantities back to a Google Sheet
Export stock data to a sheet
Keep a central sheet updated from WooCommerce
Support multi-store shared inventory workflows

Sheet Push setup

↑ Back to top

Open Sheet Push.
Enter the target Google Sheet details.
Configure mappings.
Save settings.
Test with a small workflow first.
Enable incremental push only after testing.

Push on Sale

↑ Back to top

Push on Sale updates the sheet workflow when WooCommerce sales reduce stock.

This is useful for shared stock workflows.

Example shared stock workflow

↑ Back to top

A customer buys a product from Store A.
WooCommerce reduces stock in Store A.
Push on Sale sends the stock change back to the Google Sheet workflow.
Store B or another connected store syncs from the updated sheet.
The stock level stays better aligned across stores.

For best results, test Push on Sale with a small number of products before relying on it for your full catalogue.

Price Sync add-on

↑ Back to top

Price Sync is separate from the main Stock Sync Sheets plugin.

The main plugin includes Stock Sync, Product Builder, AI Review, Sheet Push, Push on Sale, Manual Review, Confirmed Matches, Ignored Matches, Blacklist controls, schedules, and logs.

The separate Price Sync add-on is used when you want to sync regular prices and sale prices from Google Sheets.

Price Sync add-on pages

↑ Back to top

When the add-on is active, you may see:

Price Sync
Confirmed Price
Ignored Price
Blacklist Price

Recommended Price Sync process

↑ Back to top

Set up and test Stock Sync first.
Install and activate the Price Sync add-on.
Configure price sheet settings.
Use confirmed matches where required.
Run a dry price sync first.
Review price sync logs.
Run live price sync only after testing.

Multiple sheets and suppliers

↑ Back to top

Stock Sync Sheets can be used with one or more sheet sources.

This is useful when:

You have multiple suppliers
Each supplier uses a different sheet
Different sheets use different row ranges
You want separate schedules per sheet
You want to test one sheet without syncing all sheets

Keep sheet names clear. Use labels that make sense to your team, such as supplier names or workflow names.

Shared inventory across multiple stores

↑ Back to top

A shared Google Sheet can act as the central stock hub for multiple WooCommerce stores.

A typical workflow is:

All stores use the same shared stock sheet.
Stock Sync pulls stock from the sheet into each store.
Push on Sale pushes sale-based reductions back to the sheet.
Other stores sync from the updated sheet.

This kind of workflow should be tested carefully before being used on a live multi-store setup.

Recommended testing steps:

Use a small group of products first
Run Dry Run on each store
Check confirmed matches
Test one sale
Check the sheet update
Check the connected store sync
Only then expand to more products

Troubleshooting

↑ Back to top

No products are updating

↑ Back to top

Check the following:

The plugin is enabled.
The Google Sheet ID is correct.
The tab name or gid is correct.
The row range includes product rows.
The column letters are correct.
The matching field is correct.
The selected categories are not excluding products.
Dry Run is not enabled when you expect live updates.
The sync log does not show Google API errors.

Only some products update

↑ Back to top

Check:

Category filters
Row range
Missing SKUs or model codes
Manual Review items
Ignored Matches
Blacklisted match pairs
Variation parent fields
Product status in WooCommerce

Wrong products are being matched

↑ Back to top

Use Manual Review and Confirmed Matches.

If a specific wrong match keeps happening, add that bad pair to the blacklist where supported.

Then run Dry Run again and confirm that the wrong match no longer happens.

Sync runs but nothing changes

↑ Back to top

Check:

Dry Run mode
Quantity values in the sheet
Whether the same stock value already exists in WooCommerce
Whether the products are excluded by category filters
Whether rows are ignored or blacklisted
Whether the row range is reading the correct rows

Scheduled syncs do not run

↑ Back to top

Check:

The schedule is enabled.
The schedule frequency is not set to none.
The correct sheets are enabled for scheduling.
WP-Cron is working on the site.
The dashboard or Stock Sync page shows the expected next run.
Server caching or cron restrictions are not blocking scheduled tasks.

Google Sheets connection errors

↑ Back to top

Check:

The Google API key is valid.
The sheet is accessible.
The sheet ID is copied correctly.
The tab name or gid is correct.
The sheet has not been deleted or made private.
The API project has access to the required Google Sheets API.

Product Builder preview is empty

↑ Back to top

Check:

The sheet URL or sheet ID is correct.
The tab/gid is correct.
The row range includes data rows.
The delimiter is correct for CSV sources.
Required mapping fields are filled.
The sheet has product rows, not only headers.

Variations are not importing correctly

↑ Back to top

Check:

Variation rows have the correct product type.
Parent SKU or parent ID is mapped correctly.
Variation attributes are mapped correctly.
Variable parent rows and variation rows are separate where required.
Default attributes are used on variable parents, not variation rows.

AI drafts are not appearing

↑ Back to top

Check:

AI is enabled.
The API key is saved.
The connection test passes.
A supported model is selected.
Rows were selected for AI generation.
Product Builder preview has loaded rows.
The AI Review page is checking the correct sheet/draft set.

FAQs

↑ Back to top

What does Stock Sync Sheets sync?

↑ Back to top

The core Stock Sync workflow updates WooCommerce stock quantity and stock status from Google Sheets.

Does it change prices?

↑ Back to top

The core stock workflow focuses on stock. Price syncing is handled by the separate Price Sync add-on.

Does it create products?

↑ Back to top

Yes. Product creation and product updates are handled through Product Builder.

Can I use more than one Google Sheet?

↑ Back to top

Yes. You can configure multiple sheet workflows.

Can I use supplier sheets?

↑ Back to top

Yes. Supplier sheets are a common use case.

Can I preview changes before updating WooCommerce?

↑ Back to top

Yes. Use Dry Run and Sheet Preview before live sync.

What happens when a product does not match clearly?

↑ Back to top

It can be sent to Manual Review so you can choose the correct WooCommerce product.

What are Confirmed Matches for?

↑ Back to top

Confirmed Matches save approved matches for future syncs.

What are Ignored Matches for?

↑ Back to top

Ignored Matches are for rows or model codes that should not be synced.

What are Blacklisted Matches for?

↑ Back to top

Blacklisted Matches help stop known bad match pairs from being automatically repeated.

Does Stock Sync Sheets include Product Builder?

↑ Back to top

Yes. Product Builder is included in the main plugin.

Does Stock Sync Sheets include Sheet Push?

↑ Back to top

Yes. Sheet Push is included in the main plugin.

Does Stock Sync Sheets include Push on Sale?

↑ Back to top

Yes. Push on Sale is part of the broader sheet workflow.

Does Stock Sync Sheets include AI Review?

↑ Back to top

Yes. AI Review is used for staged AI product drafts that can be reviewed before import.

Can I use this for multiple WooCommerce stores?

↑ Back to top

Yes. A shared Google Sheet workflow can help multiple WooCommerce stores stay better aligned, especially with scheduled syncs, Sheet Push, and Push on Sale.

Should I run live sync immediately?

↑ Back to top

No. Run Dry Run first, check logs, resolve manual matches, and only then run live sync.

Support checklist

↑ Back to top

If you contact support, include as much detail as possible.

Helpful support information includes:

Which page you are using
What you expected to happen
What actually happened
Screenshots of your settings
Recent sync log lines
Example sheet row
Example WooCommerce product
Whether Dry Run or Live Sync was used
Whether the item is in Manual Review, Confirmed Matches, Ignored Matches, or Blacklist

Recommended first setup path

↑ Back to top

Install and activate Stock Sync Sheets.
Open the Dashboard.
Go to Settings.
Add your first stock sheet.
Map the required columns.
Save settings.
Open Stock Sync.
Load Sheet Preview.
Run Dry Run.
Review the Sync Log.
Resolve Manual Review items.
Check Confirmed Matches.
Run Live Sync.
Enable scheduling only after testing.
Then set up Product Builder, Sheet Push, Push on Sale, AI Review, or Price Sync add-on as needed.

Need more help?

↑ Back to top

Review the Quick Start Guide above.
Check your latest Sync Log.
Check Manual Review.
Check Confirmed Matches.
Check Ignored Matches.
Check the Blacklist page.
Run Dry Run before making live updates.
Contact support from your WooCommerce.com account with screenshots and log details.

Related Products

Offer add-ons like gift wrapping, special messages or other special options for your products.

Add shipment tracking information to your orders.

30-day money-back guarantee

Support teams across the world

Safe and secure online payments