=== Stock Sync Sheets Lite ===
Contributors: appnest
Tags: woocommerce, google sheets, stock sync, inventory sync, stock management
Requires at least: 5.8
Tested up to: 7.0
Requires PHP: 7.4
Stable tag: 1.0
License: GPLv2 or later
License URI: https://www.gnu.org/licenses/gpl-2.0.html
WC requires at least: 6.4.1
WC tested up to: 10.7

Sync WooCommerce stock from Google Sheets with dry run, manual review, confirmed matches, ignored matches, blacklist tools, and logs.

== Description ==

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 ==

This plugin includes Select2 4.0.13, licensed under the MIT License. Source: https://github.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.

== Installation ==

1. Upload the plugin ZIP through Plugins > Add New, or upload the plugin folder to `/wp-content/plugins/`.
2. Activate the plugin through the Plugins screen.
3. Make sure WooCommerce is installed and active.
4. Open Stock Sync Sheets under WooCommerce.
5. Add your Google Sheets API key.
6. Add your sheet settings.
7. Set the sheet tab, row range, and column mappings.
8. Run a dry run or preview first.
9. Review unmatched products in Manual Review.
10. Run a live sync only after the preview looks correct.

== Frequently Asked Questions ==

= Does this plugin support stock sync from Google Sheets? =

Yes. The plugin includes the stock sync workflow.

= Can I preview changes before syncing? =

Yes. Use preview or dry run to check changes before applying live updates.

= What happens if a product is not matched? =

It can be sent to Pending Manual Matches, where an admin can select the correct WooCommerce product.

= Are confirmed matches reused? =

Yes. Confirmed matches are saved and reused automatically in future syncs.

= Can I stop a wrong match from happening again? =

Yes. Incorrect matches can be blacklisted so the same code-to-product pair is not reused.

= Does read-only stock sync require Google OAuth? =

No. The stock sync workflow uses the Google Sheets API key method for reading configured sheet data.

== Screenshots ==

1. Stock Sync settings and sheet configuration.
2. Stock Sync preview and dry run output.
3. Pending Manual Matches review.
4. Confirmed Matches management.
5. Ignored and blacklist management.
6. Sync logs.

== Changelog ==

= 1.0 =
* First edition.
