About this plugin
Stock Sync Sheets Lite connects WooCommerce with Google Sheets so store owners can update WooCommerce stock from spreadsheet data.
The plugin focuses on safe stock-sync workflow:
- Sync WooCommerce stock quantities from Google Sheets.
- Sync stock status, including in stock and out of stock.
- Configure sheet ID, tab name, row range, and column mapping.
- Use dry run before applying live changes.
- Review uncertain matches before updating products.
- Save confirmed matches for future syncs.
- Manage ignored and blacklisted matches.
- View sync logs and preview output.
Stock Sync Features
Stock Sync reads configured Google Sheets and updates WooCommerce products using mapped sheet data.
Features include:
- Sync stock quantity.
- Sync stock status.
- Configure sheet ID and tab name.
- Configure row start and row end values.
- Configure column-letter mapping.
- Use product name, SKU, or model-code based matching where configured.
- Restrict sync by product category.
- Run manual sync from the admin page.
- Run manual stock syncs from the admin page. Scheduled background sync is available separately in the Pro version.
- Run dry run before live updates.
- View preview and log output.
- Send uncertain matches to manual review.
- Reuse confirmed matches.
- Manage ignored matches and blacklist entries.
Matching and Manual Review
Stock Sync Sheets Lite is designed to reduce unsafe blind updates.
Matching tools include:
- Confirmed product matches saved for future syncs.
- Pending manual review for uncertain matches.
- Product search inside the manual review workflow.
- Ignored match management.
- Blacklist management for wrong product pairings.
- Logs showing matched, skipped, changed, and warning entries.
Dry Run and Preview Tools
Dry run lets the store owner check what would happen before changing WooCommerce products.
Dry run and preview tools include:
- Preview selected rows before syncing.
- Test sync results without updating products.
- Review skipped rows and unmatched products.
- Confirm manual matches before future live syncs.
- Inspect sync logs before applying changes.
External Services
This plugin connects to Google Sheets only when the store owner configures a Google Sheets API key and sheet details.
Service used by the plugin:
- Google Sheets API: https://sheets.googleapis.com/
Data sent to Google:
- The configured Google Sheet ID, tab/range details, and API request needed to read the configured sheet.
Purpose:
- To read spreadsheet rows selected by the site administrator and use that data for WooCommerce stock sync.
The plugin does not send sheet data to developer-owned servers for stock syncing.
Service terms and privacy:
- Google APIs Terms of Service: https://developers.google.com/terms
- Google Privacy Policy: https://policies.google.com/privacy
Third-Party Libraries
13, licensed under the MIT License. com/select2/select2
Data Storage
The plugin stores settings and workflow data in WordPress.
Stored data can include:
- Plugin settings.
- Sheet configuration.
- Column mappings.
- Row ranges.
- Confirmed matches.
- Pending manual matches.
- Ignored match lists.
- Blacklist data.
- Sync logs.