Quick Start Guide
Set up your inventory sync in minutes with this step-by-step guide for StockSync Sheets.
Back to Guides6 Steps to Getting Started
Follow these simple steps to connect your sheet, run tests, review matches and go live.
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 your WooCommerce inventory always correct.