PDA

View Full Version : Product categories

eee
09-30-2005, 12:58 PM
I am trying to modify product categories for the shopping cart module
in a more graceful manner than deleting and redoing
as this upsets all my assigned products and gives me a lot of work.
Bradnjxn
09-30-2005, 03:32 PM
You could always edit your data table in MySQL, just change the category name in CART_CATEGORY. This will change the name of the category without affecting the products associated with it. Just make sure not to change the keyfield.

I am trying to modify product categories for the shopping cart module
in a more graceful manner than deleting and redoing
as this upsets all my assigned products and gives me a lot of work.
eee
09-30-2005, 06:29 PM
doesnt that then associate my products with the wrong categories

You could always edit your data table in MySQL, just change the category name in CART_CATEGORY. This will change the name of the category without affecting the products associated with it. Just make sure not to change the keyfield.
Bradnjxn
10-02-2005, 05:19 PM
No. Your products are associated with the keyfields in your database not actually the name of your categories. Say if your product category name was "music", with a keyfield of "2". You could change the name to "videos" and leave the keyfield as "2" and all your music products are now in the videos category.
doesnt that then associate my products with the wrong categories
eee
10-03-2005, 09:09 AM
thats what i mean
you are changing product associations
i want to keep the same associations
but change the order of the categories


No. Your products are associated with the keyfields in your database not actually the name of your categories. Say if your product category name was "music", with a keyfield of "2". You could change the name to "videos" and leave the keyfield as "2" and all your music products are now in the videos category.
Bradnjxn
10-03-2005, 11:50 AM
I see. I wan't clear that was your intent.

I would probably still modify my tables thru MySQL before I reentered all my products again. It would only take a few minutes.

thats what i mean
you are changing product associations
i want to keep the same associations
but change the order of the categories