PREFLIGHT CHECK

Mercari Shops condition code 1–6 checker

Validate Mercari Shops condition codes as the documented numeric values 1 through 6.

Check CSV

＋Choose a CSV fileTap/click to choose. Drag and drop also works on desktop.

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

What this tool checks

Blank condition values
Values outside 1–6
Non-ASCII numeric formats

What it cannot determine

This unofficial checker covers only rules that can be verified in the browser. Live account settings, remote server state and later service-side validation remain authoritative.

How to use this tool

Check that Condition is exactly one ASCII digit from 1 to 6 with no surrounding spaces.

Use Try sample to inspect the included sample.
Set ＋ Choose a CSV file Tap/click to choose. Drag and drop also works on desktop..
Use Check CSV to process the input.
Compare the result with your source data and return to the input to make corrections.

＋ Choose a CSV file Tap/click to choose. Drag and drop also works on desktop.: .csv,text/csv

Input and settings example

商品名,商品の状態
サンプルTシャツ,1

Condition is entered as a code from 1 to 6

The bulk-registration CSV expects an ASCII digit: 1=new, 2=like new, 3=no noticeable damage, 4=some damage, 5=damaged, and 6=poor condition.

This is not a field where you type the display label itself.

A value such as “ 1 ” is not the same as 1

The old implementation trimmed values before validation, which could hide surrounding spaces. The checker now requires the cell itself to be exactly one ASCII digit from 1 to 6.

That matters because half-width spaces outside the permitted text fields can cause import errors.

Older exports or converted files can contain display labels or a different coding scheme. Before upload, normalize the field to the current Mercari Shops 1–6 values rather than trusting an old template.

A valid code does not prove the selected condition is truthful

This tool checks CSV syntax, not the physical product. Whether a real item should be classified as condition 2 or 4 still requires a human review of the item and listing details.

Zero errors means the code format is valid, not that the merchandising judgment is correct.

Shipping method is another coded required field

A correct condition code does not compensate for a missing or unsupported shipping method.

Run the shipping-method code checker next to catch the same class of input error.

Go one step deeper

Five checks before a bulk CSV import →