Leading SKUs removed when opening product export CSV

Setup

  • Vend for Mac or PC
  • Excel

Cause

This is due to the way that Excel handles CSV files (this issue doesn't occur with XLSX files). It will automatically remove the zeros from the start of the SKUs when opening the file.

Solution

Export your product list as an XLSX file and use the XLSX format throughout the whole process instead of CSV:

  1. Click Products
  2. Click Export List...
  3. Click XLSX format (For Excel and other spreadsheet apps)
  4. Open the file in Excel
  5. The SKUs will now be intact
Did this answer your question?
Have more questions? Contact us so that we can help you out.