Features
Every feature, in one place.
Sync Master is built to handle the boring parts of inventory work — at scale, on schedule, with a paper trail.
What it does
Sync Master, at a glance.
Three pictures, one workflow: your Google Sheet becomes the source of truth, the app verifies and pushes updates to Shopify, and a schedule keeps everything in lockstep — automatically.
Your Google Sheet is the source of truth.
A 3-step integration workflow — connect & map, verify with a sample read, push updates — plus the advanced capabilities behind it: selective and whole-sheet sync, metafield mapping with normalization, and automated scheduling.
Optimized for warehouse inventory workflows.
Pin a worksheet to a location, set the sync to run daily at a fixed time, and tune the logic to your operation: zero out items missing from the sheet, deduct committed-but-unfulfilled orders, and read every run's summary at a glance.
Set it on a schedule, or run it on demand.
Define precise schedules, see when the next run will fire, and trigger an immediate Sync Now whenever you need to. Set-and-forget automation for the syncs that should just happen — manual control for the ones that shouldn't wait.
Sync engines
Sync Selected Items
Update specific rows by barcode or SKU. Paste a list, pick a location, and sync.
Sync the Whole Sheet
Read an entire spreadsheet and push every row to one or more Shopify locations.
Sync Metafields
Map spreadsheet columns to Variant metafields (Variant category only) with full bulk updates.
Automation
Scheduled Syncs
Run syncs daily, monthly, or on a custom cadence — fully unattended.
Background Runs
Syncs run asynchronously with live progress, so the UI never blocks.
Resume on Failure
Checkpointed runs continue from where they stopped instead of restarting.
Data quality
Value Normalization
Trim, lowercase, uppercase, date format, boolean mapping — built in.
Custom Replace Rules
Map your own values, like Y → true / N → false, before they hit Shopify.
Missing → Zero
Optionally zero out variants that aren't present in the sheet.
Deduct Unfulfilled Orders
Subtract pending order quantities from on-hand stock during sync.
Duplicate Aggregation
Choose to sum or overwrite when the same key appears twice.
Column → Metafield Mapping
Point any spreadsheet column at any variant metafield, with type-aware conversion built in.
Clear on Empty
Optionally clear a metafield when the corresponding cell is blank, instead of leaving stale values behind.
Auto-Activate Inventory
If a variant isn't tracked at the target location yet, Sync Master activates it automatically before writing.
Control & visibility
Test Connection
Sync Master fetches the first 3 rows of your configured cells so you can verify the column mapping before running the sync.
Test Connection & Sample Data
Verify the sheet, the worksheet and the column mapping with a live sample before any write happens.
Multi-Location Support
Sync to one location or every location in a single run.
Sync Presets
Save and reuse configurations for your most common runs.
Detailed Logs
Per-row success and error tracking, kept for review and audit.
Run Results Summary
Every run reports updated, skipped, errored and metafield-touched counts at a glance.
CSV Export
Export the result of any run as CSV for sharing, archiving or downstream reconciliation.
Stop Mid-Sync
Pause at any point — completed rows stay updated.
Scale & reliability
Batched Inventory Writes
Inventory updates are sent in batches of 100, staying inside Shopify's API limits even on huge catalogs.
Batched Metafield Writes
Metafield updates are sent in batches of 25, the maximum Shopify allows in a single bulk call.
Checkpointed Recovery
Every run writes its progress. After a failure, the next run resumes exactly from the last successful checkpoint.
Background Sync Engine
Long-running syncs execute server-side. Close the browser, come back later — the run keeps going.
Live Progress Tracking
Watch the run advance in real time, with row counts, ETA and a stop button always at hand.
Deep dives
Read the spec on each feature.
- →
Sync engines
Sync Selected Items
Surgical inventory updates. Paste a list, pick a location, sync only what you need.
- →
Sync engines
Sync the Whole Sheet
One pass. Every row. Every location.
- →
Sync engines
Metafield Sync
Push variant metafields from spreadsheet columns — with normalization built in.
- →
Automation
Scheduled Syncs
Hourly, daily, monthly. Timezone-aware. Fully unattended.
- →
Data quality
Missing → Zero
Variants not in the sheet? Force them to zero on sync.
- →
Data quality
Deduct Unfulfilled Orders
Subtract pending order quantities from on-hand stock during sync.
- →
Data quality
Duplicate Key Handling
Same key on two rows? Sum them, or take the last one.
- →
Control & visibility
Progress, Stop, and Logs
Live progress while it runs. Stop on demand. A log for every row.