PREFLIGHT CHECK

STORES inventory CSV duplicate variation ID checker

Find duplicate variation IDs in a STORES inventory CSV before upload.

Check file

Analysis stays in your browser; the file itself is not sent to BlueprintLab.

What this tool checks

  • Find duplicate variation IDs in a STORES inventory CSV before upload.

What it cannot verify

Live service-side state, account-specific settings, remote server reachability and current master data are not asserted. Always prefer the latest official service information.

How to use this tool

Check STORES Variation IDs for blanks, duplicates and surrounding whitespace with row numbers.

  1. Use Try sample to inspect the included sample.
  2. Set + Choose CSV file Tap/click to choose. Drag and drop also works on desktop..
  3. Use Check CSV to process the input.
  4. Compare the result with your source data and return to the input to make corrections.
+ Choose CSV file Tap/click to choose. Drag and drop also works on desktop.
.csv,text/csv

Input and settings example

バリエーションID,更新する在庫数
VAR001,10

Variation ID identifies the exact stock record to update

In a STORES inventory CSV, the Variation ID determines which inventory record is changed. Repeating the same ID can make the same target appear more than once in one upload.

This checker reports blank and duplicate IDs with row numbers.

Zero duplicates does not prove every ID belongs to the intended product. Start from a recent inventory CSV exported by STORES and avoid inventing or manually retyping Variation IDs whenever possible.

Surrounding whitespace is worth treating as a warning

An ID is a machine key, not display text. Spaces introduced by copy/paste can change matching behavior even when the cell looks normal.

This wave surfaces leading or trailing spaces instead of silently trimming them away.

Treat the result as a preflight check, not a guarantee that the platform will accept the upload. Account state and current admin settings can add conditions that a browser-only checker cannot prove.

When a duplicate appears, confirm intent before deleting a row

Duplicates can come from merged CSVs or parallel edits. Decide which stock change is intended before removing one of the rows.

Simply deduplicating does not guarantee the remaining number is correct.

A unique ID still does not validate the stock value

Choosing overwrite instead of increase/decrease can cause an inventory incident even with perfectly unique IDs.

Use the stock-value checker next.