If you encounter issues with missing zeroes (0) in your Excel sheet when wanting to upload barcodes to your BackOffice, this article will provide a workaround solution!
Workaround for Errors in Barcodes
Open 'TextEdit' on (MacOS) or open 'Notepad' (Microsoft Windows).
Open the CSV file in TextEdit / Notepad.
Press CTRL + A to select all, CTRL + C to copy the raw text to Google Sheets.
Open Google Sheets. Paste the data at Column A1.
Go to Format > Number > Change the entire sheet to Plain Text.
Highlight the 1st column (Column A), go to Data > Split Text to Column. After that, all leading zeroes will appear in the barcode column.
Finally, apply a Filter or Pivot Table to find out which barcode has the leading zero.
And you're done! You should now be able to upload your barcodes to the BackOffice error-free.
Need further assistance?
Contact our Customer Care Team