Common errors with Product spreadsheet imports

To avoid problems importing your Product file into Vend we have compiled the following list of common errors. If you've received one of the following errors when trying to import your spreadsheet, check out this information below:

Please use commas to separate values specifically for CSV files:

If you see the screen below, the contents of the file you have tried to import may not be separated correctly. The best way to fix this up is to run through the steps for creating your CSV using our premade template. To find these steps, click here. 

Please upload a valid spreadsheet file:

If you see the screen below, the file type you have tried to import may either be incorrect or corrupt. Double check that this file is a .csv, .xlsx or .xls file and reimport it.

Products Ignored on import

Make sure the products have matching tax_names as those set up in your store. You can find your tax names in Setup > Sales Taxes. If your Store sales tax is "GST", but "Tax" has been entered in the column in the spreadsheet, this product will be ignored.

Duplicate SKUs:

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

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 is a way to resolve it:

1. Use Open Office, and follow How to format CSV files in Open Office to format the file so your numbers do not truncate when saving to CSV

Errant Commas:

Double commas and commas in unusual places (e.g. before an entry) may cause the product file to be rejected.

Missing mandatory name field:

The name column is a mandatory field. If you do not fill out this field, the file 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.

Outlet names not matching those set up in Vend:

The product file 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 product import matches the outlet spelling in Vend. 

Unusual characters:

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

  • Apostrophe ( ' )
  • Grave accent ( ` )
  • Parentheses ( )
  • Square brackets []
  • Hyphen (-)
  • Period (.)
  • Comma (,)
  • Colon (:)
  • Ampersands (&)
  • Quote Marks (")
  • Asterisks (*)