Categories in AC7

dittohead · Post by **dittohead** » Wed Feb 27, 2008 4:05 pm

Can anyone tell me where in the database schema the category id(s) are assigned to the product when a product has been added to the store?

I have reviewed the Categories and the CategoryParents table, but I cannot find the table that assigns the category(s) to the product.

Can anyone provide some insight?

Dave

AbleMods · Post by **AbleMods** » Wed Feb 27, 2008 6:28 pm

viewtopic.php?t=6641

dittohead · Post by **dittohead** » Mon Mar 03, 2008 12:22 pm

Thanks Joe for the post!

Then to confirm there are only 3 tables involved in creating a category:
Categories
CategoryParents
CategoryNodes

How does the Category Nodes work? Also, where in the database will a product get assigned to a category?

Thanks!

Dave

AbleMods · Post by **AbleMods** » Mon Mar 03, 2008 12:34 pm

Careful with the table names, it's:

Categories
CategoryParents
CatalogNodes

I don't have my head completely wrapped around how they inter-relate. I switched to using the Able methods and classes so I wouldn't blow something else up.

There are some good code examples of how to parse category information from product records in RC2's categorygridpage4.ascx user control.

dittohead · Post by **dittohead** » Tue Mar 04, 2008 2:54 pm

Thanks, will do.

Now have good handle on categories. The CatalogNodes are the backbone of the 3 tables.

Thanks for your imput!