PREFLIGHT CHECK
Validate Mercari Shops SKU management codes and JAN values for documented length and character rules.
Analysis stays in your browser; the file itself is not sent to BlueprintLab.
| Severity | Row | Column | Issue | Value |
|---|
Live service-side state, account-specific settings, remote server reachability and current master data are not asserted. Always prefer the latest official service information.
Validate management-code and JAN/GTIN length and allowed characters without hiding surrounding spaces.
商品名,SKU1_商品管理コード,SKU1_JANコード テスト商品,SKU_001,JAN0001
Management codes allow up to 50 characters and JAN/GTIN values up to 14. Mercari Shops documents ASCII letters, digits, hyphen and underscore as valid characters for both.
Blank cells are allowed because these fields are optional; populated cells are validated.
The previous implementation trimmed values before checking them, so a value such as ` SKU001` could slip through. The checker now validates the original cell for both length and allowed characters.
A surrounding half-width space is therefore an error even when the visible code looks familiar.
Many JAN codes are numeric in practice, but Mercari Shops documents letters, digits, hyphen and underscore as allowed characters in this CSV field.
The checker follows that platform rule instead of inventing a stricter digits-only rule.
During bulk updates, SKU IDs and inventory-edit fields also need to line up correctly.
Use the Mercari Shops bulk-update checker when you are editing an exported update CSV.