Adding subcategories to Powerstore – next step

Hi,

I'm in the process of adjusting Powerstore to add subcategories. I'm going through the steps that are outlined in the following thread:

showthread.php?t=2785&highlight=modify+product+insert+update+pages

I've created the pages for the backend using dataAssist and have got this working, but I've found that I may need to update another page before going on to revising the front end (this wasn't a step outlined in the above thread but I'm assuming this needs to be done?).

I noticed that on the Products_Insert.php page, there's a select menu for choosing a category in which to insert the product. Since there will now be an optional Subcategory, can someone tell me if I need to insert the same type of select menu for the subcategory? If yes, would it just involve creating a record set of my new Subcats table and then populating the menu dynamically via the property inspector?

Would I also need to update the server behaviours on this page so that the product gets inserted into the correct subcategory in the side menu on the main pages (which currently only display category and product)? If yes, which behaviours do I need to revise?

Would really appreciate some assistance here.

Thanks

The step that you noted is mentioned in the thread, it just says to update the product insert and update pages to include your new sub category select list. You would implement this just as you have said by creating the recordset, then the select list. You will also need to update the insert or update server behavior to record this new information.

You will not do any editing on this page to get the product to show in the menus correctly. That will occur when you modify the menus on the front end to include the sub categories.

Hi Eric, Ive got all that is required for sub categories (i think) except the actual linking of the submenu.

currently using menuwriter the link for Categories is:
/Products_Results.php?Search=true&CategoryID=[CategoryID]

I placed the link for subcategory menus by just adding Sub:
/Products_Results.php?Search=true&SubCategoryID=[SubCategoryID]

what do i need to add or adjust in the Products_Results.php page to return subcategory results? currently when i select any of the submenus the result page shows all products.

thanks for the help.

Andre

You would first need to modify the search server behavior on the results page. You will need to add a new search criteria to filter on the subCategory URL parameter that you are passing.

To do this you would need to open the search page and edit the current DataAssist Search server behavior that is on the page. In here you will need to create a new criteria that will look at the subcategory column and compare it to your new URL parameter.

If you set it up like this you should be able to get the sub category specified in the link by having the recordset filtered for that particular sub category.