PREFLIGHT CHECK

Mercari Shops CSV image name and URL checker

Check image name and URL columns for spaces, URL syntax, extensions and duplicates before import.

Check CSV

🔒 Analysis runs in your browser. The CSV file itself is not uploaded to BlueprintLab.

What this tool checks

  • Automatic image-column detection
  • http / https URL syntax
  • Spaces inside URLs
  • Basic image extension check
  • Duplicate image names or URLs

What this tool cannot verify

The tool does not claim to verify live service-side master data, account-specific state, or network reachability that cannot be established reliably in-browser. The service’s own validation remains authoritative.

How to use this tool

Check image name and URL columns for spaces, URL syntax, extensions and duplicates before import.

  1. Use Try sample to inspect the included sample.
  2. Set + Choose a CSV file Tap or click to choose. Drag & 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 a CSV file Tap or click to choose. Drag & drop also works on desktop.
.csv,text/csv

Input and settings example

商品名,商品画像名
サンプルA,https://example.com/a.jpg

The same product-image field can contain a filename or a URL

If images were uploaded to Mercari Shops first, the CSV can refer to a filename such as `sample.jpg`. If a directly linked image URL is available, that URL can also be entered in the product image field.

The checker therefore validates URL-like values as URLs and other values as expected jpg/jpeg/png filenames.

Product images stop at image 20

Mercari Shops documents product image fields through `商品画像名_20`. Adding more numbered columns does not create an unlimited image list.

The checker now flags more than 20 image columns and explicit headers such as `商品画像名_21`.

A well-formed URL is not proof that the image is usable

A local browser check cannot establish whether the remote URL is public, actually returns an image, or will remain available. Whitespace and malformed URL syntax are errors, while reachability remains a service-side check.

Repeated filenames or URLs can be intentional reuse, so duplicates are warnings rather than automatic failures.

For local-file workflows, check the upload batch too

If your CSV references previously uploaded filenames, use the Mercari Shops image upload preflight checker first for format, 8 MB-per-file, 1 GB batch size and duplicate filenames.