How to add a wholesale price column to the back office product list

[climaticmoments]

Hello,

 

One of my suppliers is going to be adjusting their wholesale prices on 4000 plus products over the next couple weeks. I am trying to prepare by adding a wholesale price column to the back office product list so I can see it without having to click the product every time.

I don't know if this what I should edit on the AdminProductsController.php.

        $this->_select .= 'shop.name as shopname, a.id_shop_default, ';
        $this->_select .= 'MAX('.$alias_image.'.id_image) id_image, cl.name `name_category`,       '.$alias.'.`price`,'.$alias.'.`wholesale_price`, 0 AS price_final, a.`is_virtual`, pd.`nb_downloadable`, sav.`quantity` as sav_quantity, '.$alias.'.`active`, IF(sav.`quantity`<=0, 1, 0) badge_danger';
        
And..

        $this->fields_list['wholesale_price'] = array(
            'title' => $this->l('Wholesale price'),
            'width' => 90,
            'type' => 'price',
            'align' => 'right',
            'filter_key' => 'wholesale_price'     <--------- How do I get the filter key?
        );

Would something like this work? Or am I way off?

I am so confused and would really appreciate if someone could help me add a wholesale price column to the back office product list.

I currently have version 1.6.0.14

Thank you

 

Athena

[Iryna]

Hello

 

I can recommend you Store Manager for PrestaShop application, that allows to adjust product grid and add extra columns to it, including Wholesale Price. You can instantly filter products (or configure custom filters) and update them using Mass Product Changer.      

 

 

Check how it works using fully-functional Store Manager for PrestaShop trial - http://addons.prestashop.com/en/administration-tools-prestashop-modules/2937-store-manager-for-prestashop.html

[bea.deli]

If someone fall on this topic I take an answer:

 

  $this->fields_list['wholesale_price'] = array(
            'title' => $this->l('Wholesale price'),
            'width' => 90,
            'type' => 'price',
            'align' => 'right',
            'filter_key' => $alias.`!wholesale_price`  
        );

 

Cheers!

[Jose A. Alfons]

 This is the best solution for me:

   $this->fields_list['wholesale_price'] = array(
   'title' => $this->l('PVL'),
   'width' => 90,
   'type' => 'price',
   'align' => 'right',
   'filter_key' => 'a!wholesale_price'
  );

 

A regard.

[pobuk]

Hello,

It has been a great help !! Many thanks.

 

I would like to know if there is possibility to add a new column with the wholesale price with tax included.

 

Thank you very much in advance!!

[mechcalvin]

What about if i want to add a features by its ID? anyone can help?