Stock Sync Sheets helps WooCommerce stores run stock and product workflows from Google Sheets.
You can use it to sync stock quantity and stock status, review uncertain matches before live updates, work with supplier sheets, manage shared inventory workflows, push WooCommerce changes back to Google Sheets, and use Product Builder to create or update products from sheet data.
It is designed for stores that already manage stock or product data in spreadsheets, receive supplier sheets, or want a cleaner workflow than manual WooCommerce edits and repeated CSV imports.
Installation
↑ Back to topTo start using a product from WooCommerce.com, you can use the Add to store functionality on the order confirmation page or the My subscriptions section in your account.
- Navigate to My subscriptions.
- Find the Add to store button next to Stock Sync Sheets.
- Follow the instructions on the screen and the product will be added to your store.
Alternative options and more information:
Managing WooCommerce.com subscriptions
What Stock Sync Sheets includes
↑ Back to topStock Sync Sheets is more than a basic stock importer. The wider workflow can include:
- Stock Sync
Sync WooCommerce stock quantity and stock status from one or more Google Sheets. - Dry Run
Preview likely changes before applying live updates. - Manual Match / Manual Review
Review uncertain matches before updates go live. - Confirmed Matches
Save successful matches so future syncs become faster and cleaner. - Ignored Matches and Blacklisted Matches
Control how problem model codes are handled in future syncs. - Scheduled Sync
Run syncs automatically on your chosen schedule. - Sheet Push
Push WooCommerce stock data back to Google Sheets. - Push on Sale
Push sale-based stock changes back to the shared sheet workflow. - Product Builder
Create or update WooCommerce products from mapped Google Sheet data.
Recommended setup order: set up and test the core stock sync workflow first, then expand into Product Builder, Sheet Push, Push on Sale, and any broader workflow tools.
Setup and configuration
↑ Back to topGetting started
↑ Back to top- In your store’s WP Admin dashboard, navigate to WooCommerce > Settings > Stock Sync Sheets.
- Tick the checkbox to Enable.
- Enter a description for Stock Sync Sheets if you want one for your own reference.
- Save changes.
Quick Start Guide
↑ Back to topUse this flow for the safest first setup. The goal is to confirm your matching and sheet settings before any live stock changes happen.
Step 1: Go to the Settings page
- Create or prepare your Google Sheet for stock data.
- Enter your Google API key.
- Fill in your sheet details.
- Google Sheet ID
- Tab name
- Matching field or model code column
- Quantity column
- Stock status column, if used
- Row range
- Save your settings.
Step 2: Open the Viewer page
- Go to the Viewer page in your store’s WP Admin dashboard.
- Turn Dry Run ON for testing.
- Leave Scheduled Sync off for now unless you are testing scheduling later.
- Click Sync to WooCommerce to begin your first dry sync.
Step 3: Review matches
- Strong matches may auto-match automatically.
- Items that need review appear in the Manual Match section.
- Use this stage to confirm your matching setup is behaving correctly before any live stock changes happen.
Step 4: Handle manual matches
- Use the dropdown or search to assign the correct WooCommerce product.
- 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.
- Manual Match can also show close suggestions to speed up review.
- If the correct product is not listed, use the search box to find your WooCommerce product.
Step 5: Check the Confirmed Matches page
- All successful auto and manual matches are listed here.
- Auto-matches may be marked [Auto] Exact.
- If an auto-match is incorrect, send it back to manual review.
- Optionally disable auto-matching for that model code in the future
- Click Send to Manual Review to rematch
- The model code can move to the Blacklisted Matches page if you choose to stop future auto-matching
- You can reverse this later by removing the model code from Blacklisted Matches
Step 6: Final sync test
- Run another Dry Sync and confirm the results are clean.
- Clean logs
- Accurate auto-matches
- No remaining manual or ignored items that still need action
- Turn Dry Run OFF and run a live sync.
- Set a schedule if desired.
- Once the core workflow is confirmed, expand into Product Builder, Sheet Push, or other included tools as needed.
Advanced configuration
↑ Back to topYou can fine-tune Stock Sync Sheets to better match your store workflow:
- Sync schedule
Choose how often the extension should pull data from Google Sheets. - Dry Run mode
Run a preview sync that logs what would change without updating live products. - Category filters
Limit syncing to selected product categories where supported by your workflow. - Model code / SKU / product name matching
Decide how sheet rows should match WooCommerce products. - Per-sheet settings
Each connected sheet can use its own column mapping, row range, and category filtering.
These options are optional, but they give you much more control over how syncing behaves.
What Stock Sync Sheets is for
↑ Back to topStock Sync Sheets helps WooCommerce stores use Google Sheets as a practical workflow hub.
You can keep stock synced, reduce manual stock edits, review uncertain matches before live changes, work with one or more supplier sheets, and build a cleaner WooCommerce workflow around the sheet process your business already uses.
It is especially useful if:
- You already manage stock in Google Sheets
- Your suppliers send you stock sheets
- You want more accurate stock quantity and stock status without constant manual work
- You want dry runs and manual review before live changes
- You want a cleaner workflow that improves over time as matches are confirmed
- You want to keep one or multiple WooCommerce stores better aligned from a shared sheet workflow
Basic workflow
↑ Back to top- Install and activate the extension.
- Connect your Google Sheet.
- Map rows to WooCommerce products using your preferred matching fields.
- Run a dry sync first.
- Review matches and fix any unclear items.
- Run a live sync.
- Optionally enable scheduled syncs.
- Keep updating the sheet as your source of truth.
After the core stock workflow is set up properly, you can expand into Product Builder, Sheet Push, Push on Sale, and other wider workflow tools.
Other included tools
↑ Back to topStock Sync Sheets also includes other tools as part of the wider workflow:
- Product Builder
Create or update WooCommerce products from mapped sheet data. - Sheet Push
Push WooCommerce stock data back to Google Sheets as part of a broader sheet workflow. - Push on Sale
Push sale-based stock changes back to the shared sheet workflow to help connected stores stay aligned faster.
The core stock sync workflow should be set up first before expanding into these additional tools.
Troubleshooting
↑ Back to topMost issues with Stock Sync Sheets come down to sheet setup, API access, matching configuration, or sync scheduling.
No products are updating
↑ Back to top- Make sure the sheet ID and tab name are correct.
- Check that the row range includes your product rows.
- Confirm that the selected matching column is correct.
- Make sure your Google API key is valid.
- Check whether Dry Run is still enabled.
Only some products update
↑ Back to top- Check whether category filters are excluding products.
- Look for typos or extra spaces in model codes, SKUs, or other matching fields.
- Review the sync log to see which rows were skipped and why.
- Check whether some items still need Manual Match review.
Wrong products are being updated
↑ Back to top- Use Manual Match instead of relying on weak automatic matching.
- For critical suppliers, use exact SKU or model code matching instead of product name matching.
- Review suspicious auto-matches on the Confirmed Matches page.
- Use Blacklisted Matches if you need to stop a model code from auto-matching again.
Sync runs but nothing changes
↑ Back to top- Check whether the sync was run in Dry Run mode.
- Confirm that the quantity or stock status values are actually different from what is already in WooCommerce.
- Check whether your sheet values are being read from the correct range and columns.
Scheduled syncs do not seem to run
↑ Back to top- Make sure a schedule is selected.
- Make sure Dry Run is turned off.
- If your host disables WP-Cron, you may need a real cron job calling
wp-cron.php. - Check whether your site receives enough traffic for WP-Cron to run reliably.
Errors when connecting to Google Sheets
↑ Back to top- Double-check the Google Sheet ID and tab name.
- Make sure the API key has not changed or been revoked.
- If you changed sheet structure, update the column and range settings to match.
If you still have trouble, include screenshots, relevant settings, and the latest sync log when contacting support.
FAQs
↑ Back to topWhat does Stock Sync Sheets sync?
↑ Back to topThe core Stock Sync workflow updates WooCommerce stock quantity and stock status based on Google Sheets data.
Does it change prices, titles, or descriptions?
↑ Back to topThe core Stock Sync workflow focuses on stock syncing. Broader product creation and update workflows are handled through Product Builder. Price syncing is handled separately.
Can I use more than one Google Sheet or supplier?
↑ Back to topYes. You can connect multiple sheets, including one per supplier, with separate settings for each.
Can I preview changes before updating live stock?
↑ Back to topYes. Use Dry Run mode to preview likely changes before running a live sync.
What happens when a product does not match clearly?
↑ Back to topIt can be sent to Manual Match so you can choose the correct WooCommerce product or send it to Ignored Matches.
What are Confirmed Matches for?
↑ Back to topConfirmed Matches save successful product matches so future syncs become faster and more reliable.
What are Blacklisted Matches for?
↑ Back to topBlacklisted Matches help stop specific model codes from being auto-matched again when you do not want that to happen.
Does Stock Sync Sheets include Product Builder and Sheet Push?
↑ Back to topYes. Product Builder and Sheet Push are included in the wider workflow, but the stock sync setup should be completed first.
Can I use Stock Sync Sheets for multiple WooCommerce stores?
↑ Back to topYes. Shared Google Sheet workflows, Sheet Push, Push on Sale, and scheduled syncs can help keep multiple WooCommerce stores better aligned from one inventory workflow.
Need more help?
↑ Back to top- Read the Quick Start Guide
- Review your latest sync logs
- Check Confirmed Matches, Ignored Matches, and Blacklisted Matches
- Contact support with screenshots and details if needed
