Display Tags In Backoffice Columns Products List.

[Cloud Nine]

Hi,

 

I would like to display a column with the product tags in admin (in product listing) :

(On the screenshot, i’ve translated the column name "tag" by "artists" but it is the tag datas)

 

 

I’ve created an override of AdminProductsController.php

 

Then, I’ve extended the query in order to display tags in a column.

 

$this->_join .= ' LEFT JOIN `' . _DB_PREFIX_ . 'product_tag` AS p_tag ON (p_tag.`id_product` = a.`id_product`) ';

 

Now, i can display the tag id in a column.

 

How can i have now the tag name (column name of tag table)

 

I don’t know how to make this double join in pretsashop ? 

Edited March 7, 2016 by Cloud Nine (see edit history)

[Cloud Nine]

ok, finally, it was a simple sql syntax :

$this->_join .= ' LEFT JOIN `' . _DB_PREFIX_ . 'product_tag` AS p_tag ON (p_tag.`id_product` = a.`id_product`) LEFT JOIN `' . _DB_PREFIX_ . 'tag` AS t ON (p_tag.`id_tag` = t.`id_tag`) ';

[mathieuRutabago]

Hello,

 

I have managed to get to this point ... but this only display one tag!  I don't know how to modify the SQL query to return more than the last tag.

Any idea ?

 

Thanks

[prestol]

hello is module for this avalible for buy somwhere

[Cloud Nine]

@prestol It's an old post but if I remember correctly, it was custom development. Don't know if there is a module.

[prestol]

hello cloud nine okay please say if there module is sold when you find it

[Cloud Nine]

It is not a module, it is custom dev made by me (php, sql). But this is too old to explain what I did.

[prestol]

hello cloud nine 

okay how much cost for make it module?? pls let me know it

[dhc1973]

Hi,
Got the same issue, I would like to search for a tag in the back office/
Ex: 
In tags, I put product reference, that, I can search in front office, to check available quantity.
When quantity is zero = automatically, product is not visible any more, neither the tag.
But then, When I receive new products or new stock, to check if the product/article sheet exists or not, in my thousand of article, i need to be able to search by tag if I already insert this product/article sheet.