Excel and UPC Codes Upload

[ikefor]

Hi, I recently exported my products and changed the markup for all products. After importing the products (while zeroing the stock), i realise that i lost all my UPC codes as excel has applied scientific formating to them.

Luckily i have a backup, but the problem is that excel keeps applying scientific formating even when i change the format to "Text".

I know this is more of an excel question, but any help will be appreciated.

Pete
Damara P

[ronaldrwl]

You are correct to set the field to Text.  It shouldn't convert the data to a number if the field is text.  I've used Excel this way thousands of times.  Double check that everything is formated to text.

[ronaldrwl]

Also, when saving from Excel use the Save As... and set the file format to Text with Tab delimited.

[ikefor]

Thanks, i got it, both comments actually saved the day for me.

[drivethru]

When I tried converting to excell the program stripped all the front leading zero's off the upc codes.

[ronaldrwl]

Excel will do that if you don't use the Text format.

[Mark Cumming]

Hi everyone, we have just started to import products into this program, however from my suppliers in the csv product file, i have differant terms for items, SKU .
What is a UPC ?
Can i add terms like SKU NUMBERS?
How can i do this?
Thanks for your help
Mark
Ink Gallery NOWRA

[ronaldrwl]

UPC is the barcode number on the lable.  You can't add fields.  The best option is to find the closest match.