Converting Lightspeed Barcodes to Shopify POS (Check Number Calculator!)

[@d.e.m.p.s.e.y]

Formula: =A1&(ROUNDUP(((MID(A1,2,1)+MID(A1,4,1)+MID(A1,6,1)+MID(A1,8,1)+MID(A1,10,1)+MID(A1,12,1))*3)+(MID(A1,1,1)+MID(A1,3,1)+MID(A1,5,1)+MID(A1,7,1)+MID(A1,9,1)+MID(A1,11,1)),-1)-(((MID(A1,2,1)+MID(A1,4,1)+MID(A1,6,1)+MID(A1,8,1)+MID(A1,10,1)+MID(A1,12,1))*3)+(MID(A1,1,1)+MID(A1,3,1)+MID(A1,5,1)+MID(A1,7,1)+MID(A1,9,1)+MID(A1,11,1))))

[@PuraExperiencebyDiego]

if anyone is off by 5 , cuz lightspeed try to add it so the general bar code extra number would not work, use this formula after with just the last digit you got ....=IF(C11>4,SUM(B11-5))+IF(AND(C11>=1,C11

[@AdrienLamoureux]

@@PuraExperiencebyDiego Im having the 5-digit off issue. I don't seem to understand how to implement this extra code. thnx for any help

[@AdrienLamoureux]

i figured it. took me a sec. Thanks so much everybody.

[@d.e.m.p.s.e.y]

@@AdrienLamoureux 🤝 glad this helped 💪

[@gabriellegriffis]

So awesome! And so great of you to share and hopefully help others with the same problem!

[@d.e.m.p.s.e.y]

🥰🥰 thanks G! This will save me sooooo much time!

[@BlythewoodBeeCompany]

@D.E.M.P.S.E.Y- Did all of your products match line for line between Lightspeed and Shopify? I was able to complete the conversion, but my thought was that my Shopify has some products that are not in my Lightspeed POS. They won't match row to row. Wondering if you ran into the same issue.

[@d.e.m.p.s.e.y]

All the products showed up but what I did find is that all my matrix products came in as individual products and I could not find a way to load them as variants. I tried a million different things and it just wouldn't work so all my matrix products I had to individually build and Shopify. For instance a soap line that had 20 different types of soap all came in as individual products, so I had to build that product in Shopify and then add all 20 variants and delete the old one from the import. Otherwise everything showed up which was good!

[@Myurbantoddlerkids]

I am trying to find the way to convert the system id to a 8 digit barcode (these are already on my products) I am migrating from lightspeed to shopify, can you help? thanks

[@FelixDivineSilhouette]

Bro thanks so much!! Just did a double backflip!! Now I just need to figure out how to handle the exchanges issue since Shopify doesn't accept negative values in an order. Have you encountered this scenario while migrating?

[@d.e.m.p.s.e.y]

Glad this helped! This one took me a lot of painful research to figure out! I'm not sure on the negative value part unfortunately, I already migrated everything and I've been with Shopify for over a year now so I don't have that answer for you, but one thing I'd mention is that if the order has already been completed and your migrating to a new system then it's not necessarily critical that you have the order completed in the new system if it was a return, (negative quantity) but I'm not sure if I'm understanding the question. Either way best of luck with that!

[@woolyn1538]

Thank you so much for this! I'm migrating from Lightspeed and the barcode situation is flummoxing me. I tried the formula and it seemed to add 5 to the last digit. So if it is 0 on the barcode, it returns 5. Any clues which number I change to get it to fix that?

[@woolyn1538]

I think this has something to do with that my label prints an 8 digit number, not a 12 digit one.

[@d.e.m.p.s.e.y]

If you put the lights peed export into the formula it'll give you the correct barcode with the check digit, it changes drastically by the input numbers, it's super a complicated formula so I'd recommend copying the formula, put it in excel, put in a sample lightspeed exported code, then see if it calculates right and gives you the number you see on the printed barcode from that same item. Good luck!

[@woolyn1538]

@@d.e.m.p.s.e.y It gives the incorrect number compared to what Lightspeed has already generated. The random digit is off by 5 in every case.

[@carlarippstein3797]

@@woolyn1538 We just had this exact same problem with the numbers being off by 5 and went to the page @d.e.m.p.s.e.y links above and a person in the comments had a slightly shorter formula. I tried that one and added 5 at the end, and so far it works for us! The formula we used is: =A2& MOD( 10-MOD(3*(MID(A2,2,1)+MID(A2,4,1)+MID(A2,6,1)+MID(A2,8,1)+MID(A2,10,1)+MID(A2,12,1))+(MID(A2,1,1)+MID(A2,3,1)+MID(A2,5,1)+MID(A2,7,1)+MID(A2,9,1)+MID(A2,11,1))+5,10) ,10). Hope that helps!

[@PuraExperiencebyDiego]

@@woolyn1538 YES, you are correct and lightspeed try to f w us so we dont leave the platform....there is formula figure it out that will help. The catch was is they sum or subtract the 5 to screw us. First do the Dempsy formula above, the do the TEXT to Column function and have the last number pull from the whole number, than use this formula to calculate your number =IF(B1>4,SUM(B1-5))+IF(AND(B1>=1,B1