Siirry sisältöön
Menu
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Tämä kysymys on merkitty
1 Vastaa
150 Näkymät

I imported all my products from Excel, with their respective barcodes. From another system.


In Inventory/Products, the scanner finds them.

But not in the POS.


I've checked the basics: the numbers are in the correct field, the products are available for POS, etc., but I can't get it to work, and the strange thing is that they work perfectly in the inventory.


I have the basic 18.1 version. POS.


Regards!

Avatar
Hylkää

Are you using the same barcode scanner (the same device) for both tests?

Tekijä

SOLVED!

The problem was that I was carrying over an error from the previous system import.

There were invisible spaces in the barcode field of the Excel spreadsheet.

Using the formula =SPACES, I was able to clear all the codes in Excel before importing.

Thanks and best regards!

Tekijä Paras vastaus

Thanks for your response, Christoph!


Yes, exactly the same for everything.


I don't think it's an error in the export process because the inventory reads them perfectly.


Something I tried was overwriting the code in the product sheet with the same reader. Once I did that, it worked.

The problem is that I'd have to do the same thing for more than 1,000 products.


That's why I'm interested in getting them to work directly from the import.


Thanks!

Avatar
Hylkää