product_listing sort prices with taxes

[jouret]

What do I have to do to make the product_listing to sort by price values with taxes added?

 

As I can see the sorting is done in the index.php, but I can't see where to make the sort by price values to include taxes. (final_price is now excluding taxes)

 

Any kind of hint will be gladly recieved. :)

[jouret]

No one got a clue?

[jouret]

Ok, no one got a clue..

 

For me it seems like I have to remake this..

 

// We show them all

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

 

..to not ask for values in the db (because there are no values with taxes added) but make their own with taxes added.

Can anyone confirm that?!?

 

(Yes, I know I could make a try by my self BUT I do see myself as a "trainie" about php and I think this might be something interesting to others as there are NO other threads about this issue..