I am testing out Shopify POS and we are very serious about moving our two stores from Lightspeed POS next month. Unfortunately we’ve hit a serious wall. We are unable to scan our Lightspeed barcodes into Shopify, because at the end of every product ID, lightspeed seems to generate a random number at the end. So simply downloading my Product ID’s does not work, and I’m told by Lightspeed support that there is no way to download our barcodes so I can then upload them. We do not want to close in order to reticket manually thousands of barcodes, and scanning in would take twice as long. Since we already work with Accumula to sync our inventory I am awaiting a response from them but I’m not hopeful. Has anyone encountered this challenge and if so what was the outcome?
I quickly realized that Shopify POS won’t work for us, but am still considering using Shopify for eCom. How has your experience been with using Accumula to connect the two?
After speaking to a few lightspeed representatives, one of them did give me
a few algorithms that I then passed on to my shopify representative. The
expert on the shopify side was able to come up with different formulas
which then were applied to the various barcodes and we were able to then
get most of our items scanning. It’s been a bumpy transition but so far its
been worth it to get out of working with Lightspeed. Accumula was totally
fine to work with, we had very few issues with them.
Actually I found the formula online. The goal is to transofrm the systemid to a upc8. So I found this formula: =MOD(-SUM(MID(TEXT(B2,“00000000000\0”),{1,3,5,7,9,11;2,4,6,8,10,12},1)*{3;1}),10)
We had the same problem when we implemented our Lightspeed R Series > Accumula > Shopify tech stack a few months ago and have been having it ever since. This is definitely one of those “not as advertised” problems I wish I’d known about before investing all the time and money into our new technology. I mean, I wouldn’t have switched to this tech stack at all if I’d known we wouldn’t be able to scan items at the register.
We have about 20,000 SKUs that change frequently, so monkeying around with formulas to correct barcodes ongoing isn’t in the cards for us. Instead, I plan to see if we can use the Lightspeed ID as the Custom SKU in Shopify and get items to scan that way. If so, we’re going to have to re-sticker everything, which will suck bigtime. Once we’re through that, everything should scan in both Shopify and Lightspeed without additional manipulation of the barcodes.
To be honest it is Lightspeed’s data exports that are just lame across the board. The solution is to generate the last digit called the check digit. You can test it with a calculator like this.
To transform many barcodes, I can help with that with a batch import using Google Sheets.
It seems like you would like to scan barcodes printed from Lightspeed using you Shopify POS system. The default label barcode in Lightspeed (System ID) adds a check digit to the end of the barcode, with this check digit your shopify system is not able to read the barcode.
How to fix this:
In Lightspeed, change your barcode type to Code128 formatting. this will allow you to scan barcodes you print using lightspeed in your Shopify POS.
Caveat: this only works if either the SKU or Barcode field is shopify euals the lightspeed system ID in Lightspeed.
Has anone come up with a solution to this? We use both Litespeed for retail and shopify for ecommerce, we need to use litespeed due to the nature of our buisness. its basically just that last digit that is causing us to not be able to scan items in shopify, maybe someone has an update?