Multi-row warehouses
When a sheet lists the same SKU once per shelf, sum to get total on-hand.
Data quality
Same key on two rows? Sum them, or take the last one.
Real spreadsheets contain duplicate barcodes and SKUs. In Sync All, “Duplicate key handling” decides the quantity when the same key appears on more than one row — overwrite with the later row, or sum them all. It applies within one sheet and across sheets alike, and metafield values can come from the last or the first row.
How it works
“Overwrite” keeps the later row's quantity; “Sum” adds every duplicate row together.
For metafield values such as dates, use the last row's value or the first row's value (default: last row).
Duplicates are resolved before anything is sent, so Shopify receives a single update per variant.
Spec highlights
Use cases
When a sheet lists the same SKU once per shelf, sum to get total on-hand.
When the sheet appends new rows over time, overwrite to take the latest.
Install Sync Master on Shopify, connect the spreadsheet you already use, and start syncing stock with ease.