Stock item in multiple categories

robspan <[email protected]>
Newsgroups gmane.comp.web.oscommerce.features
Message-ID <8eaa0383db3b8a004ec5b1fedbb75a56@osCommerce-Forums>
This message was sent from: Features
http://forums.oscommerce.com/viewtopic.php?p=188355#188355
----------------------------------------------------------------

If you are using a category->subcategory[..]->products setup,

one cheat is to edit the format (with mysqlcc) of the `categories` table, and remove the "index" and "auto-increment" features from the `categories_id` field.

This allows you to assign the same `categories-id` to more than one `parent_id` !
You won't need to touch the `categories_description` or `products_to_categories` tables.

However you'll have to edit the table manually.   :wink: 

Simple & effective  :D 

-rob-[/quote]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.