Jump to content

Excel scientific notation


Maria_12
Go to solution Solved by Hanna,

Recommended Posts

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.

image.png.8bf705d332e1462383668e13822e7803.png

Link to comment
Share on other sites

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:

Barcodes.thumb.gif.40531a16fad362a319d6d1ea95f7d996.gif

The numbers in the formula cell should be 0

Link to comment
Share on other sites

But I have already imported this file on my Back Office.

All my barcodes looks like this:

image.thumb.png.16a618e4506be19c23c1e32da8e63da9.png

Is there any way to undo this from Loyverse?

Link to comment
Share on other sites

  • 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.

Link to comment
Share on other sites

Yes! I do still have the old file here in our PC. 

I did try your suggestion and it worked! 🙂 

Thank you so much!

Link to comment
Share on other sites

  • 3 months later...
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?

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Loyverse Point of Sale

 

 

 

 

×
×
  • Create New...