Custom product list in backend

[FireFoxII]

Hi all

 

I need in backend to show a list of all product with wholesale price and retail price...

 

Is a possibility to obtain this? Or a module?

 

I haven't find anything about this...

 

Then I also try to create a custom backend page and then work on css but I get this error

 

An error occurred while updating an object. tab (Unknown column 'hide_host_mode' in 'field list')

 

Thanks for help

[NemoPS]

To fix that error you need to add the hide_host_mode column to ps_tab in the database (as TINYINT type)

 

As for the rest, indeed you need to query the database where a product has both prices set, so you are right in creating the new tab

I take it as you are creating a new backend controller, correct? Using a module?

[FireFoxII]

Thanks, the error was resolved by adding the column in the database...

 

For the other question, I have added this code in AdminProductsControllers to show also wholesale price

 

 

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

[NemoPS]

Yes, that should work as long as the wholesale price is picked in the query. If not, try adding it to the $_select variable