Where is relation between Category and Products....

[vijjendra]

Hi,All
When user click on the category the product list is shown but in Database there is no relation between them.
I have read the forum topics related to this, there is discussion about Object_Assn what is this and where we find this.
I want to show wishlist Item in Category based like

wishlist.jpg

[jmestep]

It is in the ac_CatalogNodes table.

[vijjendra]

In ac_CatalogNodes table there is 4 column
1. CategoryId
2.CatalogNodeId
3.CatalogNodeTypeID
4. OrderBy
now please tell me which colum and waht value relate to Category and Product.

[mazhar]

First of all catalog node entries can have 4 type of entries Category, Product, WebPage and Link

1. CategoryId
Contains the parent category id for any of above 4 items

2.CatalogNodeId
Contains the catalog node id of above 4 items. Keep in mind that catalognodeid could have same value for above four items. If you want to load some specific item then you need to provide both catalognodeid and catalognodetype in you query for filtration.

3.CatalogNodeTypeID
Contains the type of current catalognode entry

4. OrderBy
Contains the ordervby value for catalog node item.