Common WooCommerce Product CSV Import Rejections We Resolve
WordPress & WooCommerce product importers enforce strict decimal and encoding rules. Here is how CleanMyCSV repairs your file:
1. Price Column & Decimal Formatting (Regular & Sale Price)
WooCommerce requires prices as clean numeric values with dot decimals (e.g., 19.99). Values containing currency symbols (19,99 € or $19.99) or European comma decimals cause price fields to import as zero or fail completely. CleanMyCSV strips currency tags and standardizes decimals instantly.
2. Semicolon Delimiter & Column Realignment
Excel exports in Europe separate columns with semicolons (;) instead of commas (,). Importing this file into WooCommerce compresses all attributes (Title, SKU, Price, Description) into the Product Name field. CleanMyCSV auto-detects and converts delimiters to standard commas.
3. Corrupted Product Titles, Descriptions & Categories
French and international accents in product titles and category hierarchies (e.g., Vêtements > T-Shirts) turn into unreadable code (Vêtements) when saved in Windows ANSI format. CleanMyCSV forced-converts your file to UTF-8 BOM to ensure clean rendering.
4. SKU & Barcode Leading Zero Protection
WooCommerce uses SKUs to match product variations and update stock levels. Excel strips initial zeros from SKUs (turning 00412 into 412), breaking variation mapping. Our Anti-ID safeguard preserves and restores SKU string integrity.