Order Spree::Product by price ?

[tknew]

Hi,

Is it possible to order Spree::Product by price ?

I tried Spree::Product.find(:all, :order => 'price ASC'), it doesn't work 

Thanks 

[tknew]

versicolor_ answered me on the IRC channel :

@products = Spree::Product.joins(:variants_including_master).find(:all, :order => 'price ASC')

Thanks !!!

[Khalid Shaikh]

Thank you !!!

[Joshua Farrar]

If you check out search_scopes on Spree::Product, you'll see quite a few options for sorting:

pry(main)> Spree::Product.search_scopes
=> [:ascend_by_master_price,
 :descend_by_master_price,
 :price_between,
 :master_price_lte,
 :master_price_gte,
 :in_taxon,
 :in_taxons,
 :with_property,
 :with_property_value,
 :with_option,
 :with_option_value,
 :with,
 :in_name,
 :in_name_or_keywords,
 :in_name_or_description,
 :with_ids,
 :descend_by_popularity,
 :not_deleted,
 :available,
 :active,
 :taxons_name_eq,
 :price_range_any,
 :brand_any,
 :selective_brand_any,
 :in_taxon]

Spree::Product.ascend_by_master_price.each do |product|

  puts product.price
end