Hi. How can we help?

Leading SKUs removed when opening product export CSV


  • Retail POS for Mac or PC
  • Excel


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.


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

  1. Navigate to Catalog -> 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

Was this article helpful?