Sort a Product By Price in a View

I would loved to be able to do this, but this only figure for the price is the starting price. You this can be altered on the fly with the help of charges so you can add tax, levies and even discounts directly to the final product price even before you start manipulating them in the transaction.

There are kludges that you could do but they would only work on a small number of products and if you just directly sorted the products by price this will end up very confusing for the customer where products could end up out of order.

Also before you ask adding the final price to the database is not really an option because this can be altered based upon any number of things and the final price could be different between customers based upon any number of modifications to the charge.

Suggestion: make the price available under the name 'base price' and make it clear that it's the price before all the magic. It works for simple shops, and those doing funny things with prices will just have to deal with it.

(I should make a patch.. Yes.. I'll put it on my todo)

Just come across the same roadblock recently myself, coincidence that this is a fresh discussion. I'm new to Drupal so I doubt that I've addressed this in the recommended way but my changes seem to be in line with what a patch would do rather than an override of some kind. Without further ado...

I modified ec_product.views.inc, more specifically the $data['ec_product']['price'] array:

  $data['ec_product']['price'] = array(
    'title' => t('Price'),
    'field' => array(
      'handler' => 'ec_product_views_handler_field_price',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );

Cleared my cache and it seems to work. The product_list view lets me add a sort criteria "Product: Price". Is there anything I've missed or any better way of doing this?

@Xen, that is a great idea, If you want to submit a price and I will commit it.

@runbblemasta this is ok, but the reason I didn't do this is because results will vary, and may give unexpected outcomes depending on how you configure additional charges. The suggestion of having a base price which gives the raw price will work great.

Added in a base_price field.

Submit it again against the dev branch so the testing is run.

#7: 763238.patch queued for re-testing.

+++ ec_product/ec_product.views.inc	12 May 2010 15:37:56 -0000
@@ -62,11 +62,24 @@ function ec_product_views_data() {
+    'field' => array(
+      'handler' => 'ec_product_views_handler_field_price',
+      'click sortable' => TRUE,
+    ),

This handler this going to display the adjusted price and not the base price.

This is going to need a new display handler which just works on the field.

Powered by Dreditor.

Thought it was to quick.

I implemented this on my site, works a treat