StockSync for Google Sheets

 Quick Start Guide: Stock Sync Sheets
Set up your inventory sync in minutes with this step-by-step guide.

 Step 1: Go to the Settings Page
 Create a Google Sheet and name it (e.g., Stock or Inventory).

 Enter your Google API Key (from Google Developer Console).

 Fill in Sheet Details:

Google Sheet ID

Tab name (e.g., Stock)

Model Code column

Quantity column

Row range (e.g., 5–100)

 Click Save Settings

 Step 2: Open the Page Viewer
 Go to Viewer Page from your WordPress admin menu.

 Set Dry Run ON (for testing).

 Optionally enable Scheduled Sync.

 Click “Sync to WooCommerce” to begin.

 Step 3: Review Matches
 Confident Matches → Auto-matched automatically.

 Needs Review → Appears in Manual Match section.

 Step 4: Handle Manual Matches
 Use dropdown or search to assign the correct product.

 If product doesn’t exist in WooCommerce → Select “None of these”.

This sends the model code to Ignored Matches.

 Click Save Matches to confirm.

 Manual match will show close auto-match suggestions.

 If correct product isn’t listed → Use search box to find your WooCommerce product.

 Step 5: Check the Confirmed Matches Page
 All successful auto & manual matches are listed here.

 Auto-matches may be marked [Auto] Exact.

 If an auto-match is incorrect:

 Check 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
 Run another Dry Sync and confirm:

 Clean logs

 Accurate auto-matches

 No manual or ignored products remaining

 Turn Dry Run OFF and run a real sync.

 Set schedule if desired.

 Once fully set up, your stock updates automatically — keeping WooCommerce inventory always correct.