Denver Research

General Category => ezPower => Topic started by: ikefor on August 02, 2012, 03:39:47 PM

Title: Excel and UPC Codes Upload
Post by: ikefor on August 02, 2012, 03:39:47 PM

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

Title: Re: Excel and UPC Codes Upload
Post by: ronaldrwl on August 03, 2012, 05:40:02 AM

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.

Title: Re: Excel and UPC Codes Upload
Post by: ronaldrwl on August 09, 2012, 05:10:57 AM

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

Title: Re: Excel and UPC Codes Upload
Post by: ikefor on August 09, 2012, 03:43:43 PM

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

Title: Re: Excel and UPC Codes Upload
Post by: drivethru on September 02, 2012, 05:16:48 AM

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

Title: Re: Excel and UPC Codes Upload
Post by: ronaldrwl on September 05, 2012, 05:53:38 AM

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

Title: Re: Excel and UPC Codes Upload
Post by: Mark Cumming on November 29, 2012, 03:16:27 PM

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

Title: Re: Excel and UPC Codes Upload
Post by: ronaldrwl on November 30, 2012, 08:27:03 AM

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