Thread: Which category is this product in?

Greetings all,

Supposing I have a product mapped to multiple categories.

If someone with no cookie or previous browsing history on the site lands on a product page (from google for example), which category will be chosen to appear in the breadcrumb & which categories skin will be displayed (supposing I have a different skin assigned to each of the relevant categories). In fact - is this effectively one question rather than two?

I'm just trying to get my head around the rules that decide this & if I can influence them in any way.


TTFN

BFG

in this specific case, for SEO reasons, we try to find their last category cookie, and if not, we find the first mapped category for the product. The code is all on the showproduct code behind, You can step through it.

Thans for the help !!


TTFN

BFG

Following on to this:

In previous versions the product links used to include the category ID that you were coming from. This is no longer the case, how would we show a category specific header on a product detail page?

I guess the question is how would you determine the category in the xmlpackage?

rc

I guess the question is how would you determine the category in the xmlpackage?

Set the package to debug mode. You will see in the runtime XML that the parent entity type (eg. category/department) and the entity ID is stored in the system runtime data. You can access it via XPath in the package.

Hi,

How do I find which category a particular product is in via query? There are some items in our database that are not in any category. I want a query to find their sku and productid so that I can delete them. Thanks.

Ram

select categoryid from productcategory where productid = 123

How can I find items that are not in any of the categories? When you search such items on the admin site, the category column will be empty.

Code:

select productid from product where productid not in (select productid from productcategory)

will return a list of all unmapped products.

Item A belongs to Category B in the ProductCategory table. Category B exists in the Category table and is marked as not deleted but when I try to open that category, it redirects to default.aspx and when I search for Item A in the Admin section, the category column is empty. How do I find such items? Lot of data needs to be cleaned up. Hope someone could help me. Thanks.

is that category published?

What do you mean by published? That category is active in the Category table but when I try to open it, it redirects to default.aspx.

Yes, published = 1.

then the query dan posted will accomplish this

No, it doesn't.

Originally Posted by AspDotNetStorefront

in this specific case, for SEO reasons, we try to find their last category cookie, and if not, we find the first mapped category for the product. The code is all on the showproduct code behind, You can step through it.

I'm struggling a little here..............

I can see that the showproduct codebehind uses EntityHelper.GetProductsFirstEntity to determine a category for the product.
Where can I see exactly the logic that EntityHelper.GetProductsFirstEntity uses - I need to mimic it in my left nav xmlpackage.


We have products mapped to multiple categories & if there's no lastviewedentityinstanceid (or one that isn't relevant) I sometimes find that the breadcrumb & my left nav disagree.....

Here's what I use in my left nav xml package if there's no (relevant) lastviewedentityinstanceid :-

Code:

SELECT TOP 1 CategoryID from dbo.ProductCategory where ProductID = @prod ORDER BY ProductID asc

TTFN

BFG

Anyone?

Alternatively, is there any function I can use to find out which category the breadcrumb is using?

or some way to use EntityHelper.GetProductsFirstEntity within an xmlpackage?


TTFN

BFG