Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 01-10-2014 22:22:22

watchtime
Member
From: Melbourne, Australia
Registered: 10-24-2003
Posts: 83
Website

Change category identifier name

Is there a way one can change the category identifier name/description?


with thanks,
George

Offline

 

#2 01-11-2014 00:56:00

robash
Member
Registered: 02-10-2013
Posts: 344

Re: Change category identifier name

You could just clone one of the category's, change the identifier and deleted the old one.


Rob

God Save The Queen

Offline

 

#3 01-13-2014 07:03:48

watchtime
Member
From: Melbourne, Australia
Registered: 10-24-2003
Posts: 83
Website

Re: Change category identifier name

Yes, I am aware of this but then you have to associate all the products with this category again, which is rather time consuming when there are many products.


with thanks,
George

Offline

 

#4 01-13-2014 09:16:53

nigel
Member
From: Peterborough, UK
Registered: 04-27-2008
Posts: 418
Website

Re: Change category identifier name

I would have thought that if you changed the identifier you would lose all associations anyway? I think I would change the identifier than use the find and replace function on a spreadsheet to change all the associations? Best to make a backup in case it doesn't work

Offline

 

#5 01-13-2014 16:15:02

watchtime
Member
From: Melbourne, Australia
Registered: 10-24-2003
Posts: 83
Website

Re: Change category identifier name

I was looking for a short cut :-(


with thanks,
George

Offline

 

#6 01-21-2014 17:44:38

JayCR48
Member
From: Ohio
Registered: 03-27-2008
Posts: 87
Website

Re: Change category identifier name

Change the category id to what ever you want it to be then run the following SQL statement:

update ecom_prod set xcat = replace(xcat, 'old category id', 'new category id');


We distribute high quality steel auto body panels for use in the rust repair industry.

Offline

 

#7 01-22-2014 10:01:22

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Change category identifier name

Be careful with that statement!  If you have other ids that have any part of 'old category id', those xcats will be changed too.


Nick Hendler

Offline

 

#8 01-24-2014 13:19:18

JayCR48
Member
From: Ohio
Registered: 03-27-2008
Posts: 87
Website

Re: Change category identifier name

Good point.  Maybe add a good where to that statement.


We distribute high quality steel auto body panels for use in the rust repair industry.

Offline

 

Board footer