Kryptronic Software Support Forum

daviat · 03-06-2005 22:51:24

Hi,

What do you think is best for editting products? Using the Admin in CCP or using Excel to directly edit the CSV file? Excel seems quicker. Just curious on what everyone's ideas are.

Daniel

EagleWolf · 03-06-2005 22:57:13

It all depends on how many you have to edit. For one or two, I tend to use the admin, for multiple changes I like to use the csv.

daviat · 03-06-2005 23:01:48

Well . . . there are 650 products. I may need to change the shipping on these since a new print catalogue us out and there are new shipping costs. Also will Excel alter the formating of the CSV file when I upload it back to the server folder? Any experience on this before I do anything? Though I will back up a second file just in case.

Also . . . . do you prefer adding products one by one through the admin or adding them via excel? Just looking for a quicker way of adding products by hand since adding them one by one through the admin can get time consuming.

dtwg · 03-07-2005 07:50:32

I always do bulk adds/edits using Excel and have never had a problem. You just have to be reasonably careful in what you do -- and make sure you have a backup copy of your last good product.csv file.

Be sure to FTP in Binary mode.

Good luck,

Dave

Quizno · 03-07-2005 08:48:31

I use Excel for all editing of the product table, including new products. It's a lot quicker to simply copy and paste data that is the same for several or all products. I use the related items feature, and all of the information I need to enter into a new item's entry is right there in the table.

Like Dave says, you have to be somewhat careful when you use Excel; for example, it drops leading zeros.

daviat · 03-07-2005 11:47:39

Uh oh . . . . many of the Product Reference Numbers begin with numerous zeros. Are you saying then I will have trouble with Excel since it drops leading zeros?

thanks,
Daniel

redmanstudios · 03-07-2005 12:13:41

you may have to convert that collem to "text" under format cells. it will leave all the "0"'s in your part number but you may want to be safe and put some letter in from of it like

A00025-69

Just to be safe of course.

hope that helps
james

daviat · 03-07-2005 12:23:40

Cool . . . but I may need to think of another way since I am running an HTML based cart with direct links and changing the reference numbers will probably change the links.

thanks,
Daniel

Graham · 03-07-2005 13:04:12

daviat,03/06/2005 11:01:48 PM wrote:
Well . . . there are 650 products [...]
Also . . . . do you prefer adding products one by one through the admin or adding them via excel?

With that number of products and what you want to do, Excel is really the best way to go.

If you start changing stuff directly via admin unless you back up the product.csv file first you lose the opportunity to go back to an earlier version if you make a mistake or if, for some reason, the file on your site gets corrupted.

What I do is to have a copy of product.csv called eg product_01-03-05.csv on my system. If I need to make changes, I load that file into Excel and *immediately* save it as eg product_07-03-05.csv, then input the data I want to amend before uploading it to the site.

This means that if there are any problems with the updated version I can revert back to the older version until I find the problem and fix it.

daviat · 03-09-2005 00:25:47

Thanks everyone. I appreciate the info.

Daniel

Kryptronic Software Support Forum

#1 03-06-2005 22:51:24

Editing Products, Ccp Admin Or Excel?

#2 03-06-2005 22:57:13

Re: Editing Products, Ccp Admin Or Excel?

#3 03-06-2005 23:01:48

Re: Editing Products, Ccp Admin Or Excel?

#4 03-07-2005 07:50:32

Re: Editing Products, Ccp Admin Or Excel?

#5 03-07-2005 08:48:31

Re: Editing Products, Ccp Admin Or Excel?

#6 03-07-2005 11:47:39

Re: Editing Products, Ccp Admin Or Excel?

#7 03-07-2005 12:13:41

Re: Editing Products, Ccp Admin Or Excel?

#8 03-07-2005 12:23:40

Re: Editing Products, Ccp Admin Or Excel?

#9 03-07-2005 13:04:12

Re: Editing Products, Ccp Admin Or Excel?

daviat,03/06/2005 11:01:48 PM wrote:

#10 03-09-2005 00:25:47

Re: Editing Products, Ccp Admin Or Excel?

Board footer