Stock Sync Sheets

Stock Sync Sheets allows your WooCommerce store to keep product stock levels and stock status automatically in sync with one or more Google Sheets.

Setup and configuration

↑ Back to top

Getting started

↑ Back to top

1. In your store’s WP Admin dashboard, navigate to WooCommerce > Settings > Stock Sync Sheets.
2. Tick the checkbox to Enable.
3. Enter a description for Stock Sync Sheets (optional: this is just for your reference).
4. Save changes.

Quick-start guide

Set up your inventory sync in minutes using this step-by-step guide.

Step 1: Go to the settings page

1. Create a Google Sheet and name it (e.g. Stock or Inventory).
2. Enter your Google API Key (from Google Developer Console).
3. Fill in Sheet Details:
   • Google Sheet ID
   • Tab name (e.g., Stock)
   • Model Code column
   • Quantity column
   • Row range (e.g. 5–100)
4. Click Save Settings

Step 2: Open the Page Viewer

1. Go to Viewer Page in your store’s WP Admin dashboard.
2. Set Dry Run ON (for testing).
3. Enable Scheduled Sync (optional).
4. Click Sync to WooCommerce to begin.

Step 3: Review matches

1. Confident Matches: Auto-matched automatically.
2. Needs Review: Appears in Manual Match section.

Step 4: Handle manual matches

1. Use the drop-down or search to assign the correct product.
2. If product doesn’t exist in WooCommerce, select None of these.
3. This sends the model code to Ignored Matches.
4. Click Save Matches to confirm.
5. Manual match will show close auto-match suggestions.
6. If the correct product isn’t listed, use the search box to find your WooCommerce product.

Step 5: Check the Confirmed Matches page

1. All successful auto and manual matches are listed here.
2. Auto-matches may be marked [Auto] Exact.
3. If an auto-match is incorrect:
   • Check the box to disable auto-matching in the future.
   • Click Send to Manual Review to rematch.
   • Model code moves to Blacklisted page.
   • You can reverse this by removing the model from Blacklisted Matches.

Step 6: Final sync test

1. Run another Dry Sync and confirm:
   • Clean logs
   • Accurate auto-matches
   • No manual or ignored products remaining
2. Turn Dry Run OFF and run a real sync.
3. Set schedule if desired.
4. Once fully set up, your stock updates automatically — ensuring your WooCommerce inventory is always correct.

Advanced configuration

↑ Back to top

You can fine-tune Stock Sync Sheets to match the way your store works:

• Sync schedule: Choose how often the extension should pull data from your Google Sheets (manual only, hourly, twice daily, or daily) so you stay in sync without overloading your site.
• Dry run mode: Run a preview sync that only logs the changes it would make, without updating any products. This is the safest way to test a new sheet or configuration.
• Category filters: Limit syncing to specific product categories so only the products you select are updated from a given sheet.
• Model/SKU matching:Decide whether rows should be matched by SKU, model code, or product name. You can also use the fuzzy-match + manual review workflow for suppliers whose naming is inconsistent.
• Per-sheet settings: Each connected sheet can have its own column mapping, row range, and category filters. This is useful when different suppliers use different formats.

These options are optional, but using them will give you much more control over which products are updated, how often, and from which sheets.

Usage

↑ Back to top

Very simple UI, easy to understand and easy to use, with in-page manuals and tips.

What Stock Sync Sheets is for

↑ Back to top

Stock Sync Sheets keeps your WooCommerce product stock in sync with one or more Google Sheets.

Instead of logging into WooCommerce to update stock manually (or regularly importing CSV files), you update a spreadsheet and allow the extension to push those changes into WooCommerce for you.

It’s ideal if:

• You already manage stock in Google Sheets
• Your suppliers send you stock sheets
• You want your store to show accurate In stock / Out of stock status without manual work

How to use it (basic flow)

↑ Back to top

1. Install and activate the extension
   Install Stock Sync Sheets on your WooCommerce store and activate your license.
2. Connect your Google Sheet
   • Create or open a Google Sheet with your inventory.
   • Add columns for SKU or Model Code and Quantity.
   • In the extension settings, paste the Sheet ID and choose which columns to use.
3. Map products to rows
   The extension reads each row, matches it to the correct WooCommerce product (by SKU/model code), and prepares stock updates.
4. Run a dry sync
   • Start with a dry run so no stock is actually changed.
   • Review the results: which products will be updated and how.
5. Run a real sync/schedule it
   • When you’re happy, run a live sync to update WooCommerce stock.
   • Optionally turn on scheduled syncs so it updates automatically on a regular schedule.
6. Keep updating the sheet
   From then on, just keep your Google Sheet up to date. The extension will use it as the source of truth for your WooCommerce stock levels.

Troubleshooting

↑ Back to top

Most issues with Stock Sync Sheets come down to sheet setup, API access, or the sync schedule. Work through the checks below before opening a support ticket.

No products are updating

• Make sure the sheet is shared correctly (or the API key is valid) and the ID/tab name in the settings matches the sheet you’re using.
• Check that the row range actually includes your product rows.
• Confirm that the name/SKU/model code column in the sheet matches what you selected in the extension settings.

Only some products update

• Check that those products are in the categories selected for this sheet. If a category filter is set, products outside those categories will be ignored.
• Make sure there are no typos in SKUs or model codes – even an extra space can prevent a match.
• Look in the sync log to see whether rows were skipped and why.

Wrong products are being updated

• If you’re using fuzzy matching, lower the confidence threshold or send suspicious matches to manual review first.
• For critical suppliers, switch to exact SKU or model code matching instead of product name matching.

Sync runs but nothing changes

• Check whether the sync was run in Dry run mode – in this mode it only logs what would change. Turn off Dry run and sync again.
• Confirm that the quantity or stock status values are actually different from what is already in WooCommerce.

Scheduled syncs don’t seem to run

• Ensure a schedule is selected (for example: Hourly / Twice daily / Daily) and that Dry run is turned off.
• If your host has disabled WP-Cron, you may need a real cron job that calls wp-cron.php – your host’s documentation can help with this.

Errors when connecting to Google Sheets

• Double-check the Sheet ID and tab name.
• Make sure the Google API key (or sharing link) hasn’t been changed or revoked.
• If you recently edited the sheet structure (moved columns or rows), update the column and range settings in the extension to match.

If you’ve checked all of the above and still have trouble, include a screenshot of your sheet, the relevant extension settings, and a copy of the latest sync log when contacting support.

FAQs

↑ Back to top