I created a list of all products in our store using excel with columns like in sample. Saved it in .csv utf-8.

After importing a portion of the list there was an issue, the leading 0 in upc code had disappeared in excel before import. It was because I had to alter the cell format from text to general or number for database to accept the doc. All cells in “code” column were in text format because some UPC barcodes have 0 as starting number. When I changed to general or number format all leading 0 in column disappeared (which I did not notice until uploading 280 items in the same fashion and testing barcode scanning items on POS). How to allow database to accept import with text format cells?

Also, I have 1500 items to import but I am having a terrible time by importing 1 to 25 items per import. Now, nothing I try is importing.