Add column to Product Grid

[Geronimo2012]

Hi,

I'm trying to add a column to the Product administration page.
I created a module for that, see code below.
The hooks to modify the grid definition and query are not called ever.
I cleared the cache, refreshed everything, checked that ps_hook_module contains the desired hooks, which it does.
However I still cannot manage to get the extra column to show up.

<?php

use PrestaShop\PrestaShop\Core\Grid\Column\Type\Common\DataColumn;
use PrestaShop\PrestaShop\Core\Grid\Filter\Filter;
use Symfony\Component\Form\Extension\Core\Type\DateTimeType;

class JsGridProduct extends Module
{
    /** @var array */
    public const MODULE_HOOKS = [
        'actionProductGridDefinitionModifier',
        'actionProductGridQueryBuilderModifier',
    ];

    /** @var string */
    public const DATE_ADD_FIELD_NAME = 'date_add';

    public function __construct()
    {
        $this->name = 'jsgridproduct';
        $this->author = 'Jeroen van der Schoot';
        $this->version = '1.0.0';
        $this->ps_versions_compliancy = ['min' => '1.7.7.0', 'max' => _PS_VERSION_];

        parent::__construct();

        $this->displayName = $this->l('Add column on the product list');
        $this->description = $this->l('Displays the added date of the product on your products list in back office');
    }

    /**
     * Installer.
     *
     * @return bool
     */
    public function install()
    {
        return parent::install()
            && $this->registerHook(static::MODULE_HOOKS);
    }

    public function hookActionProductGridDefinitionModifier(array $params)
    {
        /** @var \PrestaShop\PrestaShop\Core\Grid\Definition\GridDefinitionInterface $definition */
        $definition = $params['definition'];

        $definition
            ->getColumns()
            ->addAfter(
                'active',
                (new DataColumn(static::DATE_ADD_FIELD_NAME))
                    ->setName($this->l('Date added'))
                    ->setOptions([
                        'field' => static::DATE_ADD_FIELD_NAME,
                ])
            )
        ;

        $filters = $definition->getFilters();
        $filters->add((new Filter(static::DATE_ADD_FIELD_NAME, DateTimeType::class))
            ->setTypeOptions([
                'required' => false,
            ])
            ->setAssociatedColumn(static::DATE_ADD_FIELD_NAME)
        );
    }

    public function hookActionProductGridQueryBuilderModifier(array $params)
    {
        /** @var \Doctrine\DBAL\Query\QueryBuilder $queryBuilder */
        $queryBuilder = $params['search_query_builder'];

        $queryBuilder->addSelect('p.`date_add`');
    }
}

 

[Daresh]

As far as I know, product list is not a Grid so it won't work.

[Geronimo2012]

2 hours ago, Daresh said:

As far as I know, product list is not a Grid so it won't work.

Here I found something similar for Orders,
is the implementation for Orders different than for Products?

[Daresh]

Yes it is.

[endriu107]

In product list grid was added in prestashop 8.1.

[Geronimo2012]

Is there a way to customize the administration product list?

[Daresh]

What version of PrestaShop do you have?

[Geronimo2012]

6 minutes ago, Daresh said:

What version of PrestaShop do you have?

8.1.2

[endriu107]

14 minutes ago, Geronimo2012 said:

8.1.2

Yes, easiest way is use module. My module in products list now allow to enable/disable column like: EAN13, UPC, MPN, ISBN and weight, but can be extend on other column. You can create your own module and manage needed columns or buy any module that have option you need.

 

[Daresh]

In 8.1.2 your code should work, I just tested it out by extending my Gridder module with date_add and date_upd columns, your code looks quite good. Are you sure the hooks got attached? The Symfony debugger may be helpful here.

[Geronimo2012]

2 hours ago, Daresh said:

In 8.1.2 your code should work, I just tested it out by extending my Gridder module with date_add and date_upd columns, your code looks quite good. Are you sure the hooks got attached? The Symfony debugger may be helpful here.

When I open Product page in bottom I notice:

Should I expect hooks hookActionProductGridDefinitionModifier and hookActionProductGridQueryBuilderModifier here?

 

[Daresh]

Yes, like this:

[Geronimo2012]

3 minutes ago, Geronimo2012 said:

When I open Product page in bottom I notice:

Should I expect hooks hookActionProductGridDefinitionModifier and hookActionProductGridQueryBuilderModifier here?

 

[Geronimo2012]

I tried to Debug this with xdebug but I don't hit breakpoints in DoctrineGridDataFactory.getData()

[Geronimo2012]

Anyone any clue why hooks are not called? Or pointers how to debug this?

[Smart-Web]

On 1/23/2024 at 4:05 AM, endriu107 said:

Yes, easiest way is use module. My module in products list now allow to enable/disable column like: EAN13, UPC, MPN, ISBN and weight, but can be extend on other column. You can create your own module and manage needed columns or buy any module that have option you need.

 

Do you have a demo of your module online? Looks very promising, but I would like to see this work first.

[endriu107]

No there is no demo available currently, all I can show now i video from very first version od this module

 

[Smart-Web]

23 hours ago, endriu107 said:

No there is no demo available currently, all I can show now i video from very first version od this module

 

Hi, this looks good and your English is good too.

However your entire website is in Polish only? I don't speak Polish and google translate is not doing a great job. If you want to sell your modules, please provide an english version of your site.

Thanks