Modify the AdminProducts view in BO ?

[bea.deli]

Hi everybody,

I do a small development to add new columns in my BO product page to generate CSV files for a translation agency.

And I have added in the BO menu a new page called "Traduction" where I have duplicated the product controller to see all my products, but I need to modify this page.

So I want  to do 2 things :

1rst : See only products where "traduire" are at 1 and to have the green check button like "activé" button (see attachment screen shot).

2nd : I want to add columns for "product description","meta_title", "meta_keywords" and "meta_description".

I have added the short description column with this code in this path : controllers\admin\AdminProductsController.php:

$this->fields_list['description_short'] = array(

                  'title' => $this->l('Résumé'),
                  'align' => 'left',
                );

But when i do same for the other columns I want, this error appears :
SQL Request error
Column 'meta_description' in field list is ambiguous

Someone can help me please?

 

I use PS 1.6.0.14

 

Best regards,

 

Bea972

[bea.deli]

Ok I solved the 2nd part of my request, it was missing the "filter_key" to see the content for the other columns.

if that can help someone an example with description column:

 

$this->fields_list['description'] = array(

                  'title' => $this->l('Description'),
                  'align' => 'left',

                  'filter_key' => 'b!description'
                );

 

But i didn't find the green check button like "activé" button someone can Help me pls ?