0

In the product views of my drupal commerce site, I want to list the products sorted by amount(price).

The product has 4 categories. They are added as relationships in the view: enter image description here

Now to sort them by price, I am doing the following: enter image description here

This is working perfectly fine in another view where I am using Contextual filters(Product category).

But in this view, where I am displaying products of all categories, the sorting is not working. What is happening in this case is:

  • First all the Poultry items are coming in sorted(by price) order.

  • Then all the Fish items in sorted(by price) order.

  • And so on.

What I want is :

All Items should be collectively sorted by price.

2 Answers 2

2

This isn't working as configured because you're using separate product reference fields per content type. This instructs the query to attempt a sort based on non-existent values for those rows where the content type does not have the expected reference field. To sort this View properly, you'd need the base table to be the Products and then some sort of a reverse reference to content referencing those products.

2
  • Thanks for the answer. For making the base table as products, do I need to create a new view ? Or is it possible/practical to do it in the same view ? May 7, 2018 at 9:31
  • 1
    You would need a new View for it. May 8, 2018 at 15:35
0

I sorted my view using hook_views_pre_render() and array_multisort().

function MY_MODULE_views_pre_render(&$view) {
      if($view->name == 'MY_VIEW'){   
        $price_array = array();
        foreach($view->result as $key => $row) {
          $price = '0';
          if(isset($row->field_commerce_price[0])){
            $price = $row->field_commerce_price[0]['raw']['amount'];
          } elseif (isset($row->field_commerce_price_1[0])) {
            $price = $row->field_commerce_price_1[0]['raw']['amount'];
          } elseif (isset($row->field_commerce_price_2[0])) {
            $price = $row->field_commerce_price_2[0]['raw']['amount'];
          } elseif (isset($row->field_commerce_price_3[0])) {
            $price = $row->field_commerce_price_3[0]['raw']['amount'];
          }
          $price_array[$key] = $price;
        }
        array_multisort($price_array, SORT_ASC, $view->result);
      }
    }

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.