Multi-row warehouses
When a sheet lists the same SKU once per shelf, sum to get total on-hand.
← Features
Data quality
Duplicate Key Handling
Same key on two rows? Sum them, or take the last one.
Real spreadsheets contain duplicate barcodes and SKUs. duplicateKeyMode tells Sync Master what to do when the same key appears on more than one row: aggregate the quantities into a single update, or overwrite with the last value seen.
How it works
Step by step.
- STEP 1
Pick a mode
Choose 'sum' to add all duplicate rows together, or 'overwrite' to keep the last row's value.
- STEP 2
Sync Master groups duplicates
Duplicates are detected before any API call, so Shopify only sees one update per variant.
- STEP 3
Logs report the resolution
Each merged row is reported in the sync log so you can audit what was combined.
Spec highlights
At a glance.
- Modes
- sum | overwrite
- Default
- overwrite
- Detection
- Pre-flight, before any update
- Audit
- Logged per merged group
Use cases
Where it earns its keep.
Versioned exports
When the sheet appends new rows over time, overwrite to take the latest.
Stop pasting stock numbers by hand.
Install Sync Master on Shopify and run your first sync in under five minutes.