Page 1 of 1
Where is relation between Category and Products....
Posted: Sat May 02, 2009 3:25 pm
by 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
Re: Where is relation between Category and Products....
Posted: Sat May 02, 2009 4:40 pm
by jmestep
It is in the ac_CatalogNodes table.
Re: Where is relation between Category and Products....
Posted: Sun May 03, 2009 2:59 am
by 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.
Re: Where is relation between Category and Products....
Posted: Mon May 04, 2009 2:42 am
by 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.