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.
BASE new-product blank default value checkerWarn when new BASE product rows leave price, stock or publication fields blank and therefore rely on defaults.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.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.BASE product image ZIP structure checkerCheck a BASE image ZIP for nested folders, non-ASCII filenames and the 1 GB batch limit before import.BASE variation name duplicate and length checkerCheck BASE product CSV variation names for duplicates within a product and values longer than 255 characters.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.ColorMe CSV comma, newline and quote checkerDetect malformed quoting and row-width changes caused by commas, newlines or double quotes in ColorMe CSV files.ColorMe customer CSV checkerCheck the customer import format and common field errors.ColorMe product CSV checkerCheck product create/update CSVs before upload.ColorMe product option CSV checkerCheck the option CSV, name/item order and numeric fields.e-Hiden III CSV format checkerCheck encoding, delimiter, CSV syntax and signs of Excel tab conversion.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.Mercari Shops 130-character product name checkerFind blank or over-130-character product names in a Mercari Shops bulk registration CSV.Mercari Shops 3,000-character description checkerFind product descriptions longer than the documented 3,000-character limit before Mercari Shops import.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.Mercari Shops bulk update CSV preflight checkerCheck product IDs, SKU IDs and multi-column requirements for inventory and image updates before upload.Mercari Shops condition code 1–6 checkerValidate Mercari Shops condition codes as the documented numeric values 1 through 6.Mercari Shops CSV encoding checkerCheck whether a Mercari Shops CSV decodes cleanly as Shift_JIS or UTF-8 before upload.Mercari Shops CSV image name and URL checkerCheck image name and URL columns for spaces, URL syntax, extensions and duplicates before import.Mercari Shops half-width space CSV checkerFind half-width spaces outside product name and description fields, a documented Mercari Shops import error cause.Mercari Shops inventory delta flag checkerCheck that Mercari Shops inventory delta flags (1/2) and positive delta quantities are paired correctly.Mercari Shops product CSV preflight checkerCheck encoding, headers, length limits, spaces and required values before importing a Mercari Shops product CSV.Mercari Shops product_import_result CSV error analyzerRead a Mercari Shops product_import_result CSV and group common import errors by row.Mercari Shops shipping method code 1–6 checkerValidate Mercari Shops shipping method codes as the documented numeric values 1 through 6.Mercari Shops SKU management code and JAN checkerValidate Mercari Shops SKU management codes and JAN values for documented length and character rules.Shopify continue-selling policy CSV checkerValidate Continue selling when out of stock as deny, continue or blank/default.Shopify CSV duplicate Handle and missing Title checkerFind duplicate product handles and handle rows without titles before Shopify CSV import.Shopify CSV Image Src URL checkerCheck Shopify Image Src values for http/https syntax, spaces, duplicates and obvious non-direct links.Shopify CSV “Illegal quoting on line” preflight checkerCheck UTF-8 encoding and malformed CSV quoting that can trigger Shopify “Illegal quoting on line” errors.Shopify CSV “options are not unique” checkerDetect duplicate option-value combinations within the same Shopify product handle before import.Shopify Fulfillment service handle checkerCheck standard fulfillment values and the lowercase-hyphen syntax for custom fulfillment service handles.Shopify Inventory tracker CSV checkerCheck Shopify Inventory tracker values and flag entries outside the documented/common values.Shopify product CSV preflight checkerCheck UTF-8, Handle, Title, price, fulfillment service, duplicate options and image URLs before Shopify import.Shopify product Status value checkerValidate Shopify product CSV Status values as active, draft or archived.Shopify variant-field Option1 dependency checkerCheck that rows updating SKU, barcode, weight or inventory also include the required Option1 name/value context.Shopify weight value and unit CSV checkerCheck integer gram weight values and display units g, kg, lb or oz in Shopify product CSV files.STORES inventory CSV 5,000-row limit checkerCount STORES inventory CSV rows and flag uploads that exceed the documented 5,000-item limit.STORES inventory CSV bulk-update checkerCheck the 5,000-item limit, duplicate variation IDs and invalid stock values before a STORES inventory CSV upload.STORES inventory CSV duplicate variation ID checkerFind duplicate variation IDs in a STORES inventory CSV before upload.STORES inventory CSV stock value checkerValidate STORES inventory update values as integers from 0 to 9,999 or the supported unlimited value.STORES item CSV checkerCheck encoding, price, stock and duplicate values before import.WooCommerce catalog visibility CSV checkerValidate WooCommerce catalog visibility values as visible, catalog, search or hidden.WooCommerce Images field and URL checkerSplit WooCommerce Images entries and validate external image URLs and whitespace before import.WooCommerce price, weight and dimension number checkerCheck regular/sale prices, weight and dimensions for plain numeric values before WooCommerce import.WooCommerce product CSV preflight checkerCheck UTF-8, required names, duplicate SKUs, product types, statuses, parents and images before WooCommerce import.WooCommerce Published value CSV checkerValidate WooCommerce Published values as 1, 0, -1, 2, true or false.WooCommerce stock and backorders CSV checkerCheck WooCommerce In stock?, Stock and Backorders allowed? values before import.WooCommerce Tax status CSV checkerValidate WooCommerce Tax status values as taxable, shipping or none.WooCommerce variation Parent and SKU checkerCheck WooCommerce variation rows for duplicate SKUs, missing Parent references and missing attribute values before import.
Related references
Keep the relevant formats and units close while you work.