So, I've created a variant property called SortOrder. How would I go about using that here:

@foreach (Product myVariant in myVariants.OrderBy())

Anyone?  This:

myVariants.OrderBy(v => v["SortOrder"].Value)

Only, that will work

@foreach(Product myVariant in myVariants.OrderBy(v => v.ProductDefinitionField.Name == "SortOrder"))

I can output that value as a string and it's what I want. Why can't I sort on it?

@foreach(Product myVariant in myVariants.OrderBy(v => v.ProductDefinitionField.Name == "SortOrder"))

I can output that value as a string and it's what I want. Why can't I sort on it?

OK. For anyone lese that might be having the same problem; I used this query

var variants = from product in Product.All()
               join sort in ProductProperty.All()
                   on product.ProductId equals sort.ProductId
               where product.ParentProductId == int.Parse(Request.QueryString["product"])
                   && product.AllowOrdering
                   && sort.ProductDefinitionField.Name == "SortOrder"
               orderby sort.Value.Length == 1 ? "0" + sort.Value : sort.Value
               
               select product;

Hi Tony,

The issue is probably that we store all the custom values as strings so you're ending up doing a alpha numerical sort. If you do a ToList on the query you'll be able to convert the value and sort it as a numeric value instead.

var products = products.ToList();

products = products.OrderBy(x => Convert.ToInt32(x["SortOrder"]));

Cannot implicitly convert type 'System.Linq.IOrderedEnumerable' 
to 'System.Collections.Generic.List'. 
An explicit conversion exists (are you missing a cast?)

It doesn't like that at all

Silly me. I keep forgetting :)

is working on a reply...