Loosing first zero on barcode after importing

[Roddy]

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 May 6, 2020 by Roddy
Sorry, I've put this in the wrong section.

[Christine]

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. 

 

 

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

[Roddy]

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.

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.

 

 

[Christine]

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!