March 20, 20242 yr I have problems with my items. I’m having troubles when I scan my items in my shop, when I scan the item, it shows me error notification and when I exported my items list, I saw that my items looks like this? Why does it show different barcodes? This is supposed to be 7480000000001 but in the file, it shows me this when I export the file.
March 20, 20242 yr Have you tried turning off the Excel’s Scientific Notation feature? Based on my experience, this is sometimes the default from any spreadsheet especially if the spreadsheet is not in CSV format Here’s how I did it: The numbers in the formula cell should be 0
March 20, 20242 yr Author But I have already imported this file on my Back Office. All my barcodes looks like this: Is there any way to undo this from Loyverse?
March 20, 20242 yr Solution Hello @Maria_12! If you imported your CSV file into your Back Office with the scientific notation option turned on, it treated the scientific format as the actual barcode number, similar to Excel. Consequently, when exported, the modified format remained, leading to incorrect barcode numbers. Essentially, the system transferred the information from the Excel file directly into the barcode items without adjusting them. Could you please check if you have the old file you used before importing? If so, you can import it again, but this time ensure that scientific notation is disabled. After importing, you should be able to view the barcodes with the correct numbers and scan them accordingly from the POS.
March 20, 20242 yr Author Yes! I do still have the old file here in our PC. I did try your suggestion and it worked! 🙂 Thank you so much!
June 21, 20242 yr On 3/20/2024 at 9:05 AM, Hanna said: Hello @Maria_12! If you imported your CSV file into your Back Office with the scientific notation option turned on, it treated the scientific format as the actual barcode number, similar to Excel. Consequently, when exported, the modified format remained, leading to incorrect barcode numbers. Essentially, the system transferred the information from the Excel file directly into the barcode items without adjusting them. Could you please check if you have the old file you used before importing? If so, you can import it again, but this time ensure that scientific notation is disabled. After importing, you should be able to view the barcodes with the correct numbers and scan them accordingly from the POS. Hi, Im having the same issue, but setting the cell format to number with 0 decimals doesnt help, is there another way to disable scientific notation?
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now