Validation Rules

A required column header is missing from the file.

Fix: Add the missing column to the header row. Check for typos and extra spaces.

The file contains columns not part of the required set.

Fix: No action needed. Extra columns are ignored during validation.

A row could not be parsed (wrong number of columns, unclosed quotes, etc.).

Fix: Check that values containing the separator character are wrapped in double quotes.

The file contains no data rows (header only or completely empty).

Fix: Ensure at least one data row is present below the header.

The sku column is empty for this row.

Fix: Every product must have a non-empty unique reference.

This SKU value appears more than once in the file.

Fix: Remove or rename duplicate SKUs. Each product reference must be unique.

The SKU value has leading or trailing whitespace.

Fix: Trim the SKU value. Some ERP importers treat " REF001" and "REF001" as different products.

The name column is empty for this row.

Fix: Every product must have a non-empty name.

The product name exceeds 255 characters.

Fix: Shorten the product name. Many ERP systems limit product names to 255 characters.

The price column is empty for this row.

Fix: Provide a valid price. Use 0 only if the product is genuinely free.

The price value is not a valid number, is negative, or is zero.

Fix: Use a positive numeric value. Remove currency symbols, spaces and thousands separators.

The price uses a comma as the decimal separator (e.g. 49,90).

Fix: Replace the comma with a dot (49.90). Some ERP importers do not accept comma decimals.

The vat_rate column is empty for this row.

Fix: Provide a valid VAT rate.

The VAT rate is not one of the allowed values: 0, 2.1, 5.5, 10, 20.

Fix: Use one of the authorised French VAT rates. Remove the % symbol if present.

The stock column is empty for this row.

Fix: Provide a numeric stock value. Use 0 for out-of-stock products.

The stock value is not a non-negative integer.

Fix: Use a whole number ≥ 0. Remove decimal points, text and negative signs.