TOOL TOPIC
E-commerce import tools
Check field limits, code values, row counts, image references, variants, and other common failure points before importing product data.
49tools
Freeno sign-up
JA / ENlanguages
Common tasks in this topic
Preflight tools for product-import CSVs used by Mercari Shops, BASE, STORES, Shopify, WooCommerce, ColorMe, and other e-commerce platforms.
1
Check product CSVs before upload
2
Find image, SKU, and variant inconsistencies
3
Validate platform-specific values and limits
Tools in this topic
Choose the tool that most closely matches the task you need to finish.
Mercari Shops 130-character product name checkerFind blank or over-130-character product names in a Mercari Shops bulk registration CSV.Open →Mercari Shops 3,000-character description checkerFind product descriptions longer than the documented 3,000-character limit before Mercari Shops import.Open →Mercari Shops condition code 1–6 checkerValidate Mercari Shops condition codes as the documented numeric values 1 through 6.Open →Mercari Shops shipping method code 1–6 checkerValidate Mercari Shops shipping method codes as the documented numeric values 1 through 6.Open →Mercari Shops inventory delta flag checkerCheck that Mercari Shops inventory delta flags (1/2) and positive delta quantities are paired correctly.Open →BASE new-product blank default value checkerWarn when new BASE product rows leave price, stock or publication fields blank and therefore rely on defaults.Open →Shopify CSV Status CheckerValidate Shopify product CSV Status values as active, draft or archived.Open →Shopify Inventory Tracker CSV CheckerCheck Shopify Inventory tracker values and flag entries outside the documented/common values.Open →Shopify Continue Selling CSV CheckerValidate Continue selling when out of stock as deny, continue or blank/default.Open →Shopify Weight CSV CheckerCheck integer gram weight values and display units g, kg, lb or oz in Shopify product CSV files.Open →Shopify Fulfillment Service CSV CheckerCheck standard fulfillment values and the lowercase-hyphen syntax for custom fulfillment service handles.Open →Shopify Variant CSV CheckerCheck that rows updating SKU, barcode, weight or inventory also include the required Option1 name/value context.Open →WooCommerce Published value CSV checkerValidate WooCommerce Published values as 1, 0, -1, 2, true or false.Open →WooCommerce catalog visibility CSV checkerValidate WooCommerce catalog visibility values as visible, catalog, search or hidden.Open →WooCommerce Tax status CSV checkerValidate WooCommerce Tax status values as taxable, shipping or none.Open →WooCommerce stock and backorders CSV checkerCheck WooCommerce In stock?, Stock and Backorders allowed? values before import.Open →WooCommerce price, weight and dimension number checkerCheck regular/sale prices, weight and dimensions for plain numeric values before WooCommerce import.Open →WooCommerce Images field and URL checkerSplit WooCommerce Images entries and validate external image URLs and whitespace before import.Open →Mercari Shops CSV encoding checkerCheck whether a Mercari Shops CSV decodes cleanly as Shift_JIS or UTF-8 before upload.Open →Mercari Shops half-width space CSV checkerFind half-width spaces outside product name and description fields, a documented Mercari Shops import error cause.Open →Mercari Shops SKU management code and JAN checkerValidate Mercari Shops SKU management codes and JAN values for documented length and character rules.Open →Mercari Shops 10,000-row product CSV limit checkerCount product rows and flag CSV files that exceed the documented 10,000-product bulk registration limit.Open →BASE product image ZIP structure checkerCheck a BASE image ZIP for nested folders, non-ASCII filenames and the 1 GB batch limit before import.Open →BASE variation name duplicate and length checkerCheck BASE product CSV variation names for duplicates within a product and values longer than 255 characters.Open →STORES inventory CSV 5,000-row limit checkerCount STORES inventory CSV rows and flag uploads that exceed the documented 5,000-item limit.Open →STORES inventory CSV duplicate variation ID checkerFind duplicate variation IDs in a STORES inventory CSV before upload.Open →STORES inventory CSV stock value checkerValidate STORES inventory update values as integers from 0 to 9,999 or the supported unlimited value.Open →ColorMe CSV 59/60-column count checkerCount columns per row and flag ColorMe CSV rows that do not match the documented 59-column registration or 60-column update formats.Open →ColorMe CSV comma, newline and quote checkerDetect malformed quoting and row-width changes caused by commas, newlines or double quotes in ColorMe CSV files.Open →Shopify Handle Duplicate CheckerFind duplicate product handles and handle rows without titles before Shopify CSV import.Open →Shopify Duplicate Options CSV CheckerDetect duplicate option-value combinations within the same Shopify product handle before import.Open →Shopify CSV Quoting CheckerCheck UTF-8 encoding and malformed CSV quoting that can trigger Shopify “Illegal quoting on line” errors.Open →WooCommerce variation Parent and SKU checkerCheck WooCommerce variation rows for duplicate SKUs, missing Parent references and missing attribute values before import.Open →Mercari Shops product CSV preflight checkerCheck encoding, headers, length limits, spaces and required values before importing a Mercari Shops product CSV.Open →Mercari Shops product_import_result CSV error analyzerRead a Mercari Shops product_import_result CSV and group common import errors by row.Open →Mercari Shops bulk image upload preflight checkerCheck image formats, the 8 MB per-image limit, 1 GB batch size and duplicate filenames before bulk upload.Open →Mercari Shops bulk update CSV preflight checkerCheck product IDs, SKU IDs and multi-column requirements for inventory and image updates before upload.Open →Mercari Shops CSV image name and URL checkerCheck image name and URL columns for spaces, URL syntax, extensions and duplicates before import.Open →BASE product CSV and image ZIP consistency checkerMatch image filenames referenced by a BASE product CSV against a ZIP archive and find missing or risky filenames.Open →BASE product ID and variation CSV safety checkerCheck blank product/variation IDs and stock-field combinations that can create new products or fail updates in BASE.Open →STORES inventory CSV bulk-update checkerCheck the 5,000-item limit, duplicate variation IDs and invalid stock values before a STORES inventory CSV upload.Open →Shopify CSV Validator — Product Import PreflightCheck UTF-8, required fields, prices, fulfillment values, duplicate options and image URLs before Shopify import.Open →Shopify Image URL CSV CheckerCheck Shopify Image Src values for http/https syntax, spaces, duplicates and obvious non-direct links.Open →WooCommerce product CSV preflight checkerCheck UTF-8, required names, duplicate SKUs, product types, statuses, parents and images before WooCommerce import.Open →ColorMe product CSV checkerCheck product create/update CSVs before upload.Open →STORES item CSV checkerCheck encoding, price, stock and duplicate values before import.Open →ColorMe customer CSV checkerCheck the customer import format and common field errors.Open →ColorMe product option CSV checkerCheck the option CSV, name/item order and numeric fields.Open →e-Hiden III CSV format checkerCheck encoding, delimiter, CSV syntax and signs of Excel tab conversion.Open →
Related guides
Use these when you need the decision context around the tools.
Your Shopify CSV passed the check. What should you verify next?Review decisions, failure points and workflow context.Read →Is the built-in WooCommerce CSV import still enough?Review decisions, failure points and workflow context.Read →Five checks before a bulk CSV importReview decisions, failure points and workflow context.Read →Margin, markup and break-even: keep the denominators straightReview decisions, failure points and workflow context.Read →
Browse by use case
Start from the job and follow the tools used in that workflow.
Related references
Keep the relevant formats and units close while you work.