Jump to content

Loosing first zero on barcode after importing


Roddy
Go to solution Solved by Christine,

Recommended Posts

I export the items list to make changes to multiple items but when I import it again any barcodes that begin with a zero is missing the zero at the beginning.

Is there a way to stop that happening because it's playing havoc with our stock figures and causing problem at the till.

 

Edited by Roddy
Sorry, I've put this in the wrong section.
  • Like 1
Link to comment
Share on other sites

  • Solution

Hello Roddy!

You make a good point to using Excel for actions with .csv types of files. 

Excel is a good program, I like it. But we must be careful with it. Sometimes Excel can change the data type. For example, I can export Item list and open it in Excel, but what I can see in a barcode field do not make me happy. As you see in screenshot the barcode I enter manually in system lost a zero at beginning. 

image.png.d7b5a8af263215a5e653235148be0d85.png 

 

image.thumb.png.74d2b915cf09baa355c861c5414ed861.png

So I make a changes in Excel on the way how to open the .csv file:

Data--> from Text/CSV --> choose a file --> and I change a Data type detection to "Do not detect data types" --> button Load 
And here I have correct Barcode I entered in system

image.thumb.png.8f9f81d5ac94719eda02e44465bf598a.png

Link to comment
Share on other sites

Hi Christine

Thanks very much for that. Since I posted I've found another way of doing it.

In the text import file box that comes up when you open the file, change the barcode column from "standard" to "text" and the leading zero's are left intact and remain so after saving the file.

Screenshot_20200511_195636.thumb.jpg.59bc4bb5243246843ff9cf79d31346c9.jpg

This works in Libreoffice calc which is similar to excel so I would imagine it would work there too.

Thanks again for taking the time to reply. 🙂

 

 

  • Like 1
Link to comment
Share on other sites

You are welcome! 

Thank you for sharing your way to do it. It can give to other users different options how to act in similar case. 

 

Take care! 

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