Ordering/ Sorting product displays on the product category page I have created product displays which are now showing on the relevant category pages (product-category/%). The product category page is created in views which is great but I want to have full control over the order of which the products are displayed (top to bottom).

At the moment in 'Sort Criteria' of views I only have options to sort by Title, ID, Date posted and Category which is not useful. I want to sort by something like SKU or some other field of the product.

Any ideas?
How about re-making your view so it shows Commerce Products, and add
  the relationship to the product display the other way round to get
  node data? That way you should definitely have SKU available as a sort
  option from the base table (commerce_product)
  - Clive


Thanks Clive - this worked.