The code for the sort order should be the same as for the other pages

BR,
ThemeBurn team

Hi,

Unfortunately, the “sort by best selling product” option will really require a custom DB query and a lot more fuss.

We’ve found a similar topic that could be useful for you (if you haven’t checked it yet):

http://stackoverflow.com/questions/16057751/opencart-sort-by-bestselling-product

BR,
ThemeBurn team

Hi again,

I’ve actually changed the code in the file you said:
tb_themes/shoppica2/catalog/controller/BrandCategoryController.php

i’ve added this in my vqmod file:

<file name="tb_themes/shoppica2/catalog/controller/BrandCategoryController.php">
  
<operation>
      <search position="replace"><![CDATA[$sort = 'p.sort_order';]]></search>
      <add><![CDATA[
        $sort = 'p.date_added';

      ]]></add>
    </operation>
    <operation>
      <search position="replace"><![CDATA[$order = 'ASC';]]></search>
      <add><![CDATA[
        $order = 'DESC';
      ]]></add>
    </operation>
    
  </file>

But it didn’t made any difference at all.

If you check this page here:
http://www.theportugalonlineshop.com/index.php?route=category/manufacturer&c_id=20&man_id=41

You’ll see that the sorting options are completely different from the ones in categories or the manufacturers under brands…

Sorry, we’ve meant the “sort by bestseller” option.

The “sort by date added” option should work. We’ve tested it with p.price locally and it works. Have you tried to modify the file without vQmod? Generally, all files under tb_themes should be rewritable with vQmod, but just for a case.

BR,
ThemeBurn team