Jump to content
  • 0
Roddy

Loosing first zero on barcode after importing

Question

Posted (edited)

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.

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 0

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

Share this post


Link to post
Share on other sites
  • 0

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

 

 

Share this post


Link to post
Share on other sites
  • 0

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! 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Sign in

Already have an account? Sign in here.

Sign In Now

Loyverse Point of Sale

 

 

 

 

×
×
  • Create New...