{"id":318838,"date":"2026-06-26T20:34:47","date_gmt":"2026-06-26T20:34:47","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/stock-sync-sheets\/"},"modified":"2026-06-26T20:34:24","modified_gmt":"2026-06-26T20:34:24","slug":"stock-sync-sheets-lite","status":"publish","type":"plugin","link":"https:\/\/wordpress.org\/plugins\/stock-sync-sheets-lite\/","author":23323229,"comment_status":"closed","ping_status":"closed","template":"","meta":{"version":"1.0","stable_tag":"1.0","tested":"7.0","requires":"5.8","requires_php":"7.4","requires_plugins":null,"header_name":"Stock Sync Sheets Lite","header_author":"RixonApps","header_description":"Sync WooCommerce stock from Google Sheets with dry run, manual review, confirmed matches, ignored matches, blacklist tools, and logs.","assets_banners_color":"","last_updated":"2026-06-26 20:34:24","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"https:\/\/appsforwp.com\/stock-sync","header_author_uri":"https:\/\/appsforwp.com\/","rating":0,"author_block_rating":0,"active_installs":0,"downloads":39,"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":{"1.0":{"tag":"1.0","author":"appnest","date":"2026-06-26 20:34:24"}},"upgrade_notice":[],"ratings":[],"assets_icons":[],"assets_banners":[],"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.0"],"block_files":[],"assets_screenshots":[],"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."}},"plugin_section":[],"plugin_tags":[25296,152463,59098,171167,286],"plugin_category":[45],"plugin_contributors":[269056],"plugin_business_model":[],"class_list":["post-318838","plugin","type-plugin","status-publish","hentry","plugin_tags-google-sheets","plugin_tags-inventory-sync","plugin_tags-stock-management","plugin_tags-stock-sync","plugin_tags-woocommerce","plugin_category-ecommerce","plugin_contributors-appnest","plugin_committers-appnest"],"banners":[],"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/stock-sync-sheets-lite.svg","icon_2x":false,"generated":true},"screenshots":[],"raw_content":"<!--section=description-->\n<p>Stock Sync Sheets Lite connects WooCommerce with Google Sheets so store owners can update WooCommerce stock from spreadsheet data.<\/p>\n\n<p>The plugin focuses on safe stock-sync workflow:<\/p>\n\n<ul>\n<li>Sync WooCommerce stock quantities from Google Sheets.<\/li>\n<li>Sync stock status, including in stock and out of stock.<\/li>\n<li>Configure sheet ID, tab name, row range, and column mapping.<\/li>\n<li>Use dry run before applying live changes.<\/li>\n<li>Review uncertain matches before updating products.<\/li>\n<li>Save confirmed matches for future syncs.<\/li>\n<li>Manage ignored and blacklisted matches.<\/li>\n<li>View sync logs and preview output.<\/li>\n<\/ul>\n\n<h3>Stock Sync Features<\/h3>\n\n<p>Stock Sync reads configured Google Sheets and updates WooCommerce products using mapped sheet data.<\/p>\n\n<p>Features include:<\/p>\n\n<ul>\n<li>Sync stock quantity.<\/li>\n<li>Sync stock status.<\/li>\n<li>Configure sheet ID and tab name.<\/li>\n<li>Configure row start and row end values.<\/li>\n<li>Configure column-letter mapping.<\/li>\n<li>Use product name, SKU, or model-code based matching where configured.<\/li>\n<li>Restrict sync by product category.<\/li>\n<li>Run manual sync from the admin page.<\/li>\n<li>Run manual stock syncs from the admin page. Scheduled background sync is available separately in the Pro version.<\/li>\n<li>Run dry run before live updates.<\/li>\n<li>View preview and log output.<\/li>\n<li>Send uncertain matches to manual review.<\/li>\n<li>Reuse confirmed matches.<\/li>\n<li>Manage ignored matches and blacklist entries.<\/li>\n<\/ul>\n\n<h3>Matching and Manual Review<\/h3>\n\n<p>Stock Sync Sheets Lite is designed to reduce unsafe blind updates.<\/p>\n\n<p>Matching tools include:<\/p>\n\n<ul>\n<li>Confirmed product matches saved for future syncs.<\/li>\n<li>Pending manual review for uncertain matches.<\/li>\n<li>Product search inside the manual review workflow.<\/li>\n<li>Ignored match management.<\/li>\n<li>Blacklist management for wrong product pairings.<\/li>\n<li>Logs showing matched, skipped, changed, and warning entries.<\/li>\n<\/ul>\n\n<h3>Dry Run and Preview Tools<\/h3>\n\n<p>Dry run lets the store owner check what would happen before changing WooCommerce products.<\/p>\n\n<p>Dry run and preview tools include:<\/p>\n\n<ul>\n<li>Preview selected rows before syncing.<\/li>\n<li>Test sync results without updating products.<\/li>\n<li>Review skipped rows and unmatched products.<\/li>\n<li>Confirm manual matches before future live syncs.<\/li>\n<li>Inspect sync logs before applying changes.<\/li>\n<\/ul>\n\n<h3>External Services<\/h3>\n\n<p>This plugin connects to Google Sheets only when the store owner configures a Google Sheets API key and sheet details.<\/p>\n\n<p>Service used by the plugin:<\/p>\n\n<ul>\n<li>Google Sheets API: https:\/\/sheets.googleapis.com\/<\/li>\n<\/ul>\n\n<p>Data sent to Google:<\/p>\n\n<ul>\n<li>The configured Google Sheet ID, tab\/range details, and API request needed to read the configured sheet.<\/li>\n<\/ul>\n\n<p>Purpose:<\/p>\n\n<ul>\n<li>To read spreadsheet rows selected by the site administrator and use that data for WooCommerce stock sync.<\/li>\n<\/ul>\n\n<p>The plugin does not send sheet data to developer-owned servers for stock syncing.<\/p>\n\n<p>Service terms and privacy:<\/p>\n\n<ul>\n<li>Google APIs Terms of Service: https:\/\/developers.google.com\/terms<\/li>\n<li>Google Privacy Policy: https:\/\/policies.google.com\/privacy<\/li>\n<\/ul>\n\n<h3>Third-Party Libraries<\/h3>\n\n<p>This plugin includes Select2 4.0.13, licensed under the MIT License. Source: https:\/\/github.com\/select2\/select2<\/p>\n\n<h3>Data Storage<\/h3>\n\n<p>The plugin stores settings and workflow data in WordPress.<\/p>\n\n<p>Stored data can include:<\/p>\n\n<ul>\n<li>Plugin settings.<\/li>\n<li>Sheet configuration.<\/li>\n<li>Column mappings.<\/li>\n<li>Row ranges.<\/li>\n<li>Confirmed matches.<\/li>\n<li>Pending manual matches.<\/li>\n<li>Ignored match lists.<\/li>\n<li>Blacklist data.<\/li>\n<li>Sync logs.<\/li>\n<\/ul>\n\n<!--section=installation-->\n<ol>\n<li>Upload the plugin ZIP through Plugins &gt; Add New, or upload the plugin folder to <code>\/wp-content\/plugins\/<\/code>.<\/li>\n<li>Activate the plugin through the Plugins screen.<\/li>\n<li>Make sure WooCommerce is installed and active.<\/li>\n<li>Open Stock Sync Sheets under WooCommerce.<\/li>\n<li>Add your Google Sheets API key.<\/li>\n<li>Add your sheet settings.<\/li>\n<li>Set the sheet tab, row range, and column mappings.<\/li>\n<li>Run a dry run or preview first.<\/li>\n<li>Review unmatched products in Manual Review.<\/li>\n<li>Run a live sync only after the preview looks correct.<\/li>\n<\/ol>\n\n<!--section=faq-->\n<dl>\n<dt id=\"does%20this%20plugin%20support%20stock%20sync%20from%20google%20sheets%3F\"><h3>Does this plugin support stock sync from Google Sheets?<\/h3><\/dt>\n<dd><p>Yes. The plugin includes the stock sync workflow.<\/p><\/dd>\n<dt id=\"can%20i%20preview%20changes%20before%20syncing%3F\"><h3>Can I preview changes before syncing?<\/h3><\/dt>\n<dd><p>Yes. Use preview or dry run to check changes before applying live updates.<\/p><\/dd>\n<dt id=\"what%20happens%20if%20a%20product%20is%20not%20matched%3F\"><h3>What happens if a product is not matched?<\/h3><\/dt>\n<dd><p>It can be sent to Pending Manual Matches, where an admin can select the correct WooCommerce product.<\/p><\/dd>\n<dt id=\"are%20confirmed%20matches%20reused%3F\"><h3>Are confirmed matches reused?<\/h3><\/dt>\n<dd><p>Yes. Confirmed matches are saved and reused automatically in future syncs.<\/p><\/dd>\n<dt id=\"can%20i%20stop%20a%20wrong%20match%20from%20happening%20again%3F\"><h3>Can I stop a wrong match from happening again?<\/h3><\/dt>\n<dd><p>Yes. Incorrect matches can be blacklisted so the same code-to-product pair is not reused.<\/p><\/dd>\n<dt id=\"does%20read-only%20stock%20sync%20require%20google%20oauth%3F\"><h3>Does read-only stock sync require Google OAuth?<\/h3><\/dt>\n<dd><p>No. The stock sync workflow uses the Google Sheets API key method for reading configured sheet data.<\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>1.0<\/h4>\n\n<ul>\n<li>First edition.<\/li>\n<\/ul>","raw_excerpt":"Sync WooCommerce stock from Google Sheets with dry run, manual review, confirmed matches, ignored matches, blacklist tools, and logs.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/318838","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=318838"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/appnest"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=318838"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=318838"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=318838"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=318838"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=318838"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=318838"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}