33 replies to this topic

[kreasta]

Hi there, i don't know if i posted in the right category but here it is.

I want to have the product features or the tags in the ProductList after the description.

So. Lets say i have the Iphone as a product. I want to have his features under the description

like: Wifi, Touchscreen, Bluetooth, etc...

In the attachament i put some icons, simbolic to the features.. because i want to make something like

feature_name

or
tag1, tag2, tag3,

Attached Files

•  example.jpg   94bytes   2036 downloads

[Radu]

in product.php get the feature list or tag list from tables:product_tag, feature_product


in themes/yourtheme/product-list.tpl you can display them

[Radu]

my mistake in Category class you have getProducts - just modify the query to include tags

[kreasta]

merci radu.

Can you please help me a little bit... i can't pull it off.
i get he error hack attempt when i play in Category.php (from classes)

Can you please tell me what line should i edit, thx

(salutari din bucuresti/greetings from bucharest)

[Radu]

I've needed only one tag in product listing page - but you can manage to get them all - there are more posibilities.

in Category class the new query (the latest added tag):

        $sql = '
        SELECT p.*, tg.name as tag_name, pa.`id_product_attribute`, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, i.`id_image`, il.`legend`, m.`name` AS manufacturer_name, tl.`name` AS tax_name, t.`rate`, cl.`name` AS category_default, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL '.(Validate::isUnsignedInt(Configuration::get('PS_NB_DAYS_NEW_PRODUCT')) ? Configuration::get('PS_NB_DAYS_NEW_PRODUCT') : 20).' DAY)) > 0 AS new,
                    (p.price - IF((DATEDIFF(reduction_from, CURDATE()) <= 0 AND DATEDIFF(reduction_to, CURDATE()) >=0) OR reduction_from = reduction_to, IFNULL(reduction_price, (p.price * reduction_percent / 100)),0)) AS orderprice 
        FROM `'._DB_PREFIX_.'category_product` cp
        LEFT JOIN `'._DB_PREFIX_.'product` p ON p.`id_product` = cp.`id_product`
        LEFT JOIN `'._DB_PREFIX_.'product_attribute` pa ON (p.`id_product` = pa.`id_product` AND default_on = 1)
        LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON (p.`id_category_default` = cl.`id_category` AND cl.`id_lang` = '.intval($id_lang).')
        LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = '.intval($id_lang).')
        LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1)
        LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = '.intval($id_lang).')
        LEFT JOIN `'._DB_PREFIX_.'tax` t ON t.`id_tax` = p.`id_tax`
        LEFT JOIN `'._DB_PREFIX_.'tax_lang` tl ON (t.`id_tax` = tl.`id_tax` AND tl.`id_lang` = '.intval($id_lang).')
        LEFT JOIN `'._DB_PREFIX_.'manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`        
        LEFT JOIN `'._DB_PREFIX_.'tag` tg ON (tg.id_lang='.intval($id_lang).' AND tg.id_tag=(SELECT id_tag FROM product_tag WHERE id_product=p.id_product ORDER BY id_tag DESC LIMIT 1))
        WHERE cp.`id_category` = '.intval($this->id).($active ? ' AND p.`active` = 1' : '').'
        '.($id_supplier ? 'AND p.id_supplier = '.$id_supplier : '');

in product-list.tpl from themes I've used:

{$product.tag_name}

---------------------------------------------------------------------------------------------------------
However in your case you need all the features/tags (i think it's better using tags because you only need to place some images - there is no need for features that have name/value)

so you can use for each product Tag::getProductTags($product_id); to get all product tags after this line in category.php

$cat_products = $category->getProducts(intval($cookie->id_lang), intval($p), intval($n), $orderBy, $orderWay);

[roback]

I am trying to do a similar thing. I need my feature (Size) to be displayed in the product listing. I modified the product.tpl to move the feature from the data sheet up to right below the short desc. I then tried copying that bit of code:

        {foreach from=$features item=feature}
            
{$feature.name|escape:'htmlall':'UTF-8'} {$feature.value|escape:'htmlall':'UTF-8'}

        {/foreach} 
        

But it does not display anything.

Reading the above it would seem I need to add something to classes/Products.php, but it is not clear from the above what exactly I have to add.

Also is there a way to get the manufacturer to display right below the Feature on both the product info page and the product listing page? I could not seem to find the variable to include.

Any help would be appreciated.

thanks

[eshop2k9]

Hi,

Have you got solution, i am looking for something like this.. I want to display tags in products list page. Please share with me.

Thanks in advance
regards

[mohsart]

Not sure if this is what you want, but in my shop http://mohsart.se/ I display manufacturer, supplier, and tags (renamed to publisher, book series, and author).
My problem is that the tags appears for each language, apart from that I am very satisfied.

/Mats

[eshop2k9]

HI

Thanks a lot for your reply. I would like to display tags in product list, please look through attached screen shot.
I have modified query in category.php class file but unable to display tags info. Please someone could help me on this

Attached Files

•  tags.jpg   58bytes   1204 downloads

[mohsart]

This is my code in product.tpl to show the tags when viewing the product:

    {if $product->tags}
        
{l s='Tags'}:
            {foreach from=$product->tags item=tag1}
            {foreach from=$tag1 item=author}
                {$author}
            {/foreach}
            {/foreach}
        

    {/if}

Maybe entering that or something similar in product-list.tpl will do the trick?

/Mats

[mohsart]

I took a look in the code and the expected (by me) $product.tags doesn't contain the tags, so I don't know...
Is there a way to find out what eg $product contains, for me a not too experienced nor skilled programmer (if I can call me that at all) it would be a great help.

/Mats

[rocky]

I would use the following code in the PHP file just before assigning the variables to the template:

echo var_dump($products);

The output is plain text and doesn't display well in the browser though. It is best to view the source of the code so you can see the line breaks.

[mohsart]

Great, thanks rocky

[mohsart]

I keep losing track when looking through the code. :-( A bit similar feeling as when I try to figure out how to show the tags for just one language (in product.tpl)...
I found that in product-list.tpl, $tags holds all the tags (for all products) so maybe one way is to filter out the correct tags from that array. Don't know how to do that though.

/Mats

[eshop2k9]

mohsart & rocky

Thanks a lot for your efforts. I could not able to figure out how to display tags in products-list.tpl, tried $tags but it did not show anything.

Thanks

[mohsart]

$tags is an array, look in eg blocktags module for how to see the tags, though as I said I don't know how to filter out the ones associated with the product...

/Mats

[rocky]

Here's how the tags for the product are set in classes/Product.php:

Tags::getProductTags($id_product);

[mohsart]

Thanks rocky, I'll see if I can figure out how to access it

/Mats

[eshop2k9]

Hi All

any help on this

Thanks

[lafondadebaco]

Hi All,

What I made here is to add the array of tags in the list of properties of the product.

To do that go to classes/Product.php, and within the getProductProperties function you should include the following line where the data is stored, about line 2200:

$row['tags'] = Tag::getProductTags($row['id_product']); 

Then all you need to do is to include the following loop of tags into the product-list.tpl:

{if $product.tags}
    {foreach from=$product.tags item=tag1}
    {foreach from=$tag1 item=tag}
        
       
        {$tag|escape:'htmlall':'UTF-8'}                        
        

    {/foreach}
    {/foreach}
{/if}

Hope this helps... :D