Sync Master
← 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. 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

Step by step.

  1. STEP 1

    Choose the quantity rule

    “Overwrite” keeps the later row's quantity; “Sum” adds every duplicate row together.

  2. STEP 2

    Choose the metafield value

    For metafield values such as dates, use the last row's value or the first row's value (default: last row).

  3. STEP 3

    One update per variant

    Duplicates are resolved before anything is sent, so Shopify receives a single update per variant.

Spec highlights

At a glance.

Quantity
Overwrite | Sum
Default
Overwrite
Metafield value
Last row | First row (default: last)
Applies to
Within and across sheets (Sync All)

Use cases

Where it earns its keep.

Multi-row warehouses

When a sheet lists the same SKU once per shelf, sum to get total on-hand.

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, connect the spreadsheet you already use, and start syncing stock with ease.