Validation rules
The checks implemented in the current local engine, what triggers them, and the exact scope of each deterministic repair.
Structural rules
Unresolved replacement characters
Flags a mapped cell containing the � replacement character. The current engine does not guess or recover an unknown source encoding.
Column rules
Required columns present
Maps exact header names and known aliases, then reports destination-required fields that remain unmapped.
Unmapped source columns
Reports source columns with no destination mapping. They are omitted from the destination-shaped corrected CSV.
Row rules
Duplicate identifiers
For destinations whose identifier is unique, matches it case-insensitively, keeps its first occurrence, and excludes later duplicates from corrected output. Shopify product Handles are not deduplicated.
Empty mandatory cells
Flags blanks in mapped required fields. Vendor or Brand can be filled only when a dominant non-empty value exists in the current run; other blanks remain manual.
Value rules
Price format
Converts a simple comma decimal such as 19,99 to 19.99. It does not strip currency symbols, append currency, or judge the business value.
Email casing
Lowercases mapped email values after trimming outer whitespace.
Basic email syntax
Flags mapped email values that do not match a conservative local syntax check. It does not contact the mailbox or predict deliverability.
Supported country-name mapping
Converts a limited built-in set of country names to two-letter codes. Other values are preserved for manual review.
Size limits
Local input limit
Rejects empty files and applies format-specific limits: CSV 25 MiB, XLSX 10 MiB, and XLS 5 MiB. Every current run validates and exports at most the first 100 non-empty data rows; files are not split automatically.
Destination schemas
Shopify Products, Shopify Customers, WooCommerce, Google Merchant and Mailchimp each apply the shared rules above against their current core field definitions. These are focused schemas, not complete certifications of every rule maintained by each external platform.