Migrating Barcode Issue - Lightspeed to Shopify - One Extra Number

[hiddensouth]

Hi, I'm attempting to migrate my POS from Lightspeed to Shopify. I was able to download a spreadsheet of all of my products with UPC numbers from Lightspeed. Unfortunately the number that Lightspeed allows you to download is not the same as what is printed on my products. The printed number on my products has one additional digit at the end. I'm told that this number is there to validate the UPC.  Unfortunately  when I try to scan any of my products with the Shopify Go scanner it doesn't find the product because of the additional number on the printed barcode. 

The work around that I've been using is that I scan the product into the search field on the Shopify Go device and then manually delete the last number. When I get rid of that number it finds the product and I can add it to the sale. Obviously this isn't an ideal solution. 

I'm trying to figure out a way to fix this problem and I'm open to any solution including an app, custom code, using different hardware, anything that keeps me from having to retag 5000+ products. I simply need whatever scanner I'm using to ignore the last number in the code.

Any help that will get me closer to a solution would be much appreciated. 

[FlaskFWW]

Have you tried opening the exported lightspeed csv file with LibraOffice?

[mthomas524]

Probably too late for you, but I think we can generate the check digit in excel and add it to the upc number exported from Lightspeed and upload.  

[lagunasolutions]

@mthomas524 I'm having the same issue. How would you export the check digit from lightspeed to excel? Their support was not helpful and they cant seem to provide me a way to export them.

[FlaskFWW]

Export your inventory from Lightspeed and don't change anything in the csv file. Open excel and click file-import then import it as a CSV, comma delimited, and select text formatting and it'll show all of the leading 0s 

[lagunasolutions]

Thanks for your reply. In my case, there is no UPC in the Lightspeed export. My understanding is that my client didnt fill these information. Instead it uses the last digit of the System ID and add a check digit at the end to make it a 8 digits barcode. That's very weird and the support at Lightspeed told me it was not possible to retrieve this barcodes since they are not in the export file 🙄... 

[FlaskFWW]

Are you sure about that? Can you post a screenshot of one of their product details pages?

[mthomas524]

I can’t find my working files, but I think it went something like this.  There is a formula on the internet somewhere for the check digit that can be used in excel.  I created a formula to use only the digits in the system ID column that I needed and then created the check digit with the formula and spot checked what the barcode is printed on the stickers to what i had in the newly created ‘UPC’.  Then I copied values in my formula field and filled in the UPC field in the excel file.  Sorry, I wish I had more details to give you but know that it’s possible!  I do remember that there were a few different formulas found in google and i think only 1 of them really worked.  I hope this helps.  Let me know if you have more questions.