Common errors with Product CSV import

Latest update: - Team Vend

To avoid problems importing your CSV file into Vend we have compiled the following list of common errors.

Check your CSV file for the following:

For large imports, import 1000 products at a time. If the import is then rejected, this will make it easier for you to find where the problem may be.

Export some products first to use as a sample CSV. This will help to ensure you have the right fields and data for import and that you have all the mandatory fields. 

To test that your imports are working OK, please:

  1. Search for a single product in Vend
  2. Export this product to a CSV file
  3. Open in your spreadsheet application and make a minor change (i.e., the description)
  4. Reimport to Vend, to see if it updates

Common errors with CSV imports

Errant Commas:

Double commas and commas in unusual places (e.g. before an entry) may cause the CSV import to reject.

Unusual characters:

Anything that is not an alphanumeric character in the SKU or handle field may cause the CSV file to be rejected; these can include:

Apostrophe ( ' )

Grave accent ( ` )

Parentheses ( )

Square brackets []

Hyphen (-)

Period (.)

Comma (,)

Colon (:)

Ampersands (&)

Quote Marks (")

Asterisks (*)

Duplicate SKUs:

Each SKU must be different. Before importing into Vend, open the CSV in Notepad (Windows) or Text Edit (Mac) and check that the SKU column has not truncated the number before importing the CSV.

Microsoft Excel has an unfortunate habit of 'truncating' long numbers in Excel. Turning 8 or 9 digit numbers into numeric references like 8.765+E.

If you encounter this error, here are a couple of ways to resolve it:

1. Use Open Office; this does not truncate numbers when saving to CSV

2. Set the format properties of the SKU column in Excel to 'Text' (select column, right click 'properties', change to text under 'Format')

Missing mandatory name field:

The name column is a mandatory field. If you do not fill out this field, the CSV will not import.

Handle is not in correct format:

The handle field cannot have spaces or any special characters. Unless it is a variant product, your product handles must also be unique.

Uploading an .xls file instead of a .csv file:

When saving the file, ensure you save it as a .csv file type.

Outlet names not matching those set up in Vend:

The CSV import will create fields in Vend for example brands, suppliers, tags, tax rates, etc.; however, it will not create outlets. Therefore check that the outlet spelling in the CSV import matches the outlet spelling in Vend.