Jump to content

Is it my set up or is there an issue with barcodes exporting in scientific format and losing leading zeros.


Gram
Go to solution Solved by Andrew de Freitas,

Recommended Posts

Barcode changes to scientific format on export. Leading zeros lost.

1. I have found that I have to change the barcode column's format to 'number' in excel then upload the file to google sheets before I can reimport it without issues. (Merely changing the format, resaving and importing without touching goolge sheets leads to the barcodes being imported in scientific format.)

2. Any leading zeros in barcodes are lost on export and import.

Link to comment
Share on other sites

  • Solution

that's an excel issue. Defaulting the cells to to that format.

you can try another csv software and see if that helps

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