I am trying to import a product list in .csv format. The p.barcode column values have a leading 0 in the file, which is being deleted on import (which otherwise works fine). The 12 digit product bar code on the products really do have a leading 0 so I need to have it in the database. I can modify the barcode one a ta time once imports to have the leading 0, but that is a lot of work for 7334 items in my import. I have the barcode type set to UPC in the barcode module.
I tried to import using .xlsx format but it times out after 5 minutes while doing the simulated import.
Is there a way to get the import to put the full barcode string into the field?