Thread: Variants Question

I need to have a category that displays the second variant rather than the default variant. Any one know how this can be achieved?

Thanks!

There's no way to configure a category to to adhere to that behavior but a relatively simple SQL query like the following could likely accomplish what you're looking for.

Code:

 
SELECT PV.VariantID, PV.ProductID, PV.[Name] AS VariantName, CAT.[Name] AS CategoryName
	INTO #TEMP
FROM 
Product AS P 
INNER JOIN ProductVariant AS PV 
	ON P.ProductID = PV.ProductID
INNER JOIN ProductCategory AS PC
	ON P.ProductID = PC.ProductID
INNER JOIN Category AS Cat
	ON PC.CategoryID = Cat.CategoryID
WHERE Cat.[Name] = 'YourCategory'
Order By PV.VariantID Desc

UPDATE ProductVariant SET IsDefault = 0 WHERE VariantID IN (SELECT VariantID FROM #TEMP)
UPDATE ProductVariant SET IsDefault = 1 WHERE VariantID IN (SELECT TOP 1 VariantID FROM #TEMP)

Dusty
AspDotNetStorefront Staff

I was thinking along the lines that I would have a custom XML package for the category. for what you sent is that something I would need the source code for?