close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Linking categories with products

Thread began 2/16/2013 11:28 am by Jon Cunningham | Last modified 2/19/2013 4:20 pm by Jon Cunningham | 584 views | 6 replies |

Jon CunninghamBeta Tester

Linking categories with products

Hi Guys, I have run into a problem and hope someone may be able to help.

I have an (Admin) Product inset page which contains a categoryID for the category Table which works fine. see table below.

I have run DA to create a (customer) category results page that lists all the categories.

Where i am failing is that i want to make make links from the category results page to a product result page showing only the products in the chosen category.

I really hope that this makes sense and also hope some one can help.

kind regards

Jonathon

I have added my categories page if this helps anyone point me in the right direction

Category Table
CategoryID
CategoryName
CategoryImage

Product Table
ProductID
ProductCategoryID
ProductSKU
and so on

Attached Files
categories.zip
Sign in to reply to this post

Jason ByrnesWebAssist

run through the Data Assist wizard to create the products search, results and details. on the manage pages tab, edit the configure field settings section, and set the ProductCategoryID column to be a menu, set it to use the categories table, use the category name as the label, and the category ID as the value.

after the products pages are created, open the product search page, select a category and submit the search, make note of the URL variables, you can use that search string as a base for the links from the category details pages to the products results pages, just substitute the category ID from the Category details recordset in the link.

Sign in to reply to this post

Jon CunninghamBeta Tester

Hi Jason,

In the admin Backend i have it so the customer can add new categories. like wise on the frontend i have run DA to show a list of categories and this is where i want to make the link dynamic.

So when the customer adds a new category it will show on the frontend with a link to the products in the new category.

If this can be done can you help with the query statement

Kind regards

Jonathon

Sign in to reply to this post

Jason ByrnesWebAssist

if you create the pages like i outlined previously, there shouldn't be a need for changing the query, the links should be generated automatically.

Sign in to reply to this post

Jon CunninghamBeta Tester

Hi Jason, Sorry I think i am missing something here and apologise if i am being stupid but can you explain to me how the link will be generated automatically on the category page to link to the associated products page without intervention from me everytime that the customer adds a new category.

Sorry if this sounds a little stupid.

Jonathon

Sign in to reply to this post

Jason ByrnesWebAssist

use the search page to get the link structure

then add a link on the category page using the search as a guide and replace the static category ID with the ID from the reocrdset on the product details page.

Sign in to reply to this post

Jon CunninghamBeta Tester

Thank you i will try this.

kind regards

Jonathon

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...