Hi. How can we help?

Common errors with product spreadsheet imports

To avoid problems importing your product file into Retail POS 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 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 Retail POS, open the file in Notepad (Windows) or Text Edit (Mac) and check that the SKU column has not truncated the number.

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:

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 the correct format:

The handle field cannot have spaces or any special characters, aside from a hyphen, which is autogenerated at the time of creation. Unless it is a variant product, your product handles must also be unique.

Outlet names not matching those set up in Retail POS:

The product file import will create fields in Retail POS 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 Retail POS. 

Unusual characters:

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

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

Was this article helpful?