Troubleshooting CSV Product Import Issues

When importing products via CSV, several common issues can cause the import to stop, skip rows, or fail entirely. Below are the known causes and how to troubleshoot them.

CSV File Structure Issues

Missing Headers

If your CSV file does not include headers, you can still import it by mapping fields using the column index instead of column names.

• Ensure each required field is mapped correctly by selecting its index.
• This is often necessary when working with supplier files that don't define column names.

Excel Reformatting Numeric Identifiers

When editing CSV files in Excel, long numeric identifiers (such as ISBNs) may be reformatted automatically (e.g., shortened or converted to scientific notation). This can cause:

• All identifiers to become identical
• Only the first row imports successfully
• Remaining rows being ignored

To avoid this:

• Format identifier columns as Text before entering or pasting data.
• Alternatively, use a CSV-safe editor that does not auto-format numbers.

Mapping and Attribute Issues

Incorrect Variant Mapping

If variant-related fields are mapped incorrectly, the import may fail with errors such as:

• "Option value name is too long"

Review your mapping to ensure:

• Option names and values are taken from correct fields
• Only required attributes are mapped
• Variant fields use proper formatting when extracted (e.g., using split and strip)

Import Without Variants

If your products do not include variations, you can run the import without any variant mapping.

• Remove all variant-related fields
• Preview the import to verify correctness

Image Import Issues

Image fields may be mapped correctly but still fail to appear in previews or imports. This can be caused by:

• Incorrect image URLs
• Temporary processing issues
• Structural issues in the source file

If images are mapped correctly but do not appear:

• Re-run the preview after confirming URLs are valid
• Contact support if the issue persists, as it may require technical review

Additional Troubleshooting Cases

Import stuck at "Queuing"

The first update/import of a new feed may take longer than usual. If the feed contains more than the free test limit, additional credits may be required before processing continues.

Invalid attachment errors (Email feeds)

If you see an "invalid attachment" error when processing CSV files via email feed:

• Ensure the attachment is fully uploaded or sent
• Re-send the file if the email client delayed attachment upload
• Attach the CSV directly rather than linking it when possible

General Tips

• Always preview the feed before running a full import.
• Ensure each product has a unique identifier (SKU, barcode, etc.).
• Check that your feed updates align with your desired sync frequency.
• If uncertain, share sample SKUs to help isolate issues.

This guide consolidates common problems and steps gathered from user troubleshooting cases to help you resolve CSV import issues efficiently.

Updated on: 12/06/2026