Jump to content
  • Sign Up

Loosing first zero on barcode after importing


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

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


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.


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

Create an account or sign in to comment

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

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By Thecheeseman
      Hi everyone, first post here. I'm just setting up Loyverse for my cheese shop, all going well so far. But my scales that weigh cut pieces of cheese prints labels with the cheese name, weight, price with a bar code. Does anyone know how I can ensure that bar code (with different weights and prices each time) will "connect" to the named cheese on Loyverse? I've added the cheese name, category and cost price but haven't yet assigned a barcode yet. I'm working remotely right now and won't be at the shop for a few days to experiment, but thought I would check here before I waste too much time adding too many cheese details into this system. Thanks!
    • By Aleksandr3001
      I want to buy a "Sunmi T1-mini" POS device. Can I connect barcode scanners to this system? If yes, then what the scanner model?

    • By SuperAir
      When I scan barcode (weight type) same product 2 times, receipt will auto merge both weight together.
      But I want to show weight each package on receipt.
    • By RRBS01
      I'm having issues on an IOS device where the images for the barcode are not scanning and are reversed is there any thing I can do to solve this problem
    • By HigherStandard
      Is it possible for the system to prompt a user when they add an item with a barcode that already exist in the system?

Loyverse Point of Sale





  • Create New...