Add backoffice "Total sold" to columns products list

[Sergio Martins]

Hi,

i need help to add custom columns in product list in backoffice, what i'd like is get Total sold value like it show on Best Sellers.

 

PS1.6.0.9

[Sergio Martins]

Some one can help please?

[Sergio Martins]

Some one can help please?

[ventura]

Something like that ?

 

[Sergio Martins]

Yes, just like that.

I appreciate your help.

[ventura]

1.Upload the attach file to the folder override / controllers / admin

2.Delete this file to be generated again cache / class_index.php

 

AdminProductsController.php

[folkifoon]

hi ventura i uploaded the file but no luck so far. i dont have class_index.php in my cache folder?

[Ress]

In /var/cache/prod and /var/cache/dev

[folkifoon]

Hi Ress, i deleted both class_index.php but no luck.

The file AdminProductsController.php i uploaded in /override/controllers/admin

Maybe i can try adding code to the original AdminProductsController.php to see of it works?

[Ress]

Of course, you can change directly there, to be sure that everything is fine.
These changes will be lost when you update prestashop, so until then, you will have to resolve the override.

[folkifoon]

i am still trying to get this work. I was looking on the forums for a solution and i see our old conversation.

can we somehow create a simple module for this?

 

[4presta]

Hi.

The module for Prestashop 1.7 exists 😉

Module settings:

 

Product list:

[folkifoon]

I would like to thank 4you.software, they have a free module for this. Because of my older version of Prestashop (1.7.4.3) the module didnt work (as the code mentioned in this topic). They adjusted the module and now it works like a charm. 

[janoroh]

I'm looking for the same thing. Does anyone still have a currently working solution for this for PS 1.7.8? The user "4you.software" with their free module doesn't seem to exist anymore.

[Nickz]

34 minutes ago, janoroh said:

I'm looking for the same thing. Does anyone still have a currently working solution for this for PS 1.7.8? The user "4you.software" with their free module doesn't seem to exist anymore.

This thread is from 2015. Better open a new one and explain what you are looking to accomplish.

Name the Theme, versions, if over module and which one. Update history is a nice surplus.

Edited January 23 by Nickz (see edit history)

[janoroh]

6 hours ago, Nickz said:

This thread is from 2015. Better open a new one and explain what you are looking to accomplish.

Name the Theme, versions, if over module and which one. Update history is a nice surplus.

Sure, I'm aware of that. But I don't need any module support, I would just like to achieve the exact same thing that this thread is about ("total sold" column in the product list). And the last post is from 2022 from a user who implemented it in 1.7, so everything still applies, I guess. Just looking for an easy solution for this, I don't mind if it's a module or just an override/edit to AdminProductsController.php.

[Daresh]

It seems there is no easy way to achieve it in PS 1.7.8, it lacks useful hooks.

I came out to some simple and dirty solution, resulting in that column displayed, but without sorting or filtering.

Files to change:

\src\PrestaShopBundle\Controller\Admin\ProductController.php

Add:

foreach ($products as &$product) {
            $product['total_sales'] = (int) \Db::getInstance()->getValue('SELECT `quantity` FROM `'._DB_PREFIX_.'product_sale` WHERE `id_product` = '.$product['id_product']);
}

After line 165:

$lastSql = $productProvider->getLastCompiledSql();

 

\src\PrestaShopBundle\Resources\views\Admin\Product\CatalogPage\Lists\list.html.twig

Add:

        <td class="text-center">
           {{ product.total_sales }}
        </td>

After line 76, containing:

{% endif %}

\src\PrestaShopBundle\Resources\views\Admin\Product\CatalogPage\Lists\products_table.html.twig

Add:

          <th scope="col" class="text-center">
             {{ "Sales"|trans({}, 'Admin.Global') }}
          </th>

After line 69, containing:

{% endif %}

And add:

<th>&nbsp;</th>

After this block:

<th class="text-center"></th>
          {% if configuration('PS_STOCK_MANAGEMENT') %}
          <th class="text-center">
            {% include '@PrestaShop/Admin/Helpers/range_inputs.html.twig' with {
              'input_name': "filter_column_sav_quantity",
              'min': '-1000000',
              'max': '1000000',
              'minLabel': "Min"|trans({}, 'Admin.Global'),
              'maxLabel': "Max"|trans({}, 'Admin.Global'),
              'value': filter_column_sav_quantity,
              'disabled': filters_disabled,
            } %}
          </th>
          {% else %}
            <th></th>
          {% endif %}

And for more recent PrestaShop versions, check out the Gridder module:
https://codecanyon.net/item/gridder-add-and-remove-columns-from-prestashop-back-office-lists/33859071

Edited July 9 by Daresh (see edit history)

[janoroh]

Thanks so much, this is exactly what I was looking for. Hope it will be helpful for someone else in the future, too!

[4presta]

On 1/23/2025 at 7:08 PM, janoroh said:

I'm looking for the same thing. Does anyone still have a currently working solution for this for PS 1.7.8? The user "4you.software" with their free module doesn't seem to exist anymore.

Hi.

I changed my name and website 🙂

The module is still available for free.

However, it is currently disabled, like other modules, due to an upgrade for Prestashop 9.x versions.

It should be available by the end of the week.

Free modules page ;-)

Edited July 16 by ps8modules (see edit history)

[janoroh]

6 hours ago, ps8modules said:

I changed my name and website 🙂

The module is still available for free.

Ah, nice! Thanks a lot to you, too! I'll have a look next week then.