can you populate a thumbs_list with products that have a certain [@promo_tag@]?

I wish to set up a "Sales Product page" (https://developers.neto.com.au/documentation/neto-designer-documentation/tweak-documents/content-page/sale-products-page/).

But have the thumb_list only populate with products from a certain promo.

For example I have a promotion that covers multiple brands, and I want the "sales_product" page to populate with just this promo, not every sale item.

Basic Database query would be something like:

SELECT: *

FROM: Products

WHERE: [@promo_tag@] = "Black Friday"

I tried a filter_promo_tag: 'Black Friday' in the [%THUMB_LIST...%] line but no joy.

Is this even possible or am I barking up the wrong tree?

Thanks for any assistance.

Find more posts tagged with

Orders & Inventory

Accepted answers

All comments

Erik Merkley

In Matthew's code, you want to use filter_sku instead of filter_inventory_id.

It is actually possible to do this dynamically, with some very tricky code. The basic idea is to list all products currently on promo, test each one to see if it has the right promo tag, use this to generate a list of applicable SKUs, and then filter to this SKU list.

[%thumb_list type:'products' limit:'100' show_all:'1' show_child_products:'0' filter_inpromo:'1' template:'' %]

[%param filter_sku%]

[%thumb_list type:'products' limit:'12' show_all:'1' show_child_products:'0' filter_inpromo:'1' %]

[%param *body%]

[%product sku:'[@sku@]';%]

[%param *body%]

[%if [@promo_id@] eq 'MYPROMOTAG'%][@SKU@], [%/if%]</p>

[%/param%]

[%/product%]

[%/param%]

[%/thumb_list%]

[%/param%]

....

[%/thumb_list%]

Tony Ovenden

Thank you both Matthew @Matthew Hamilton? and Erik @Erik Merkley?

It's all looking a little complicated for something that in theory should be simple.

In looking around, trying to muddle my way through it, I stumbled on the "New inventory Custom Fields" where @misc17@ and @misc18@ state that they are "addition filter field... filter id = filter1"

if I was to deploy one of these as a True/False call it Promo2 (because I want it to be a separate promotion page to the On-Sale page) would I be able to generate a thumb list that was just items were Promo2 = True? and if so how would I code it? I would assume it would be Filter1='1' or Filter1 eq 't'

This would then allow me to re-use the same template for other sales quickly and easily?

Thanks again for your assistance, these filters and thumbs are messing with my mind.

Erik Merkley

Yep that would probably work. But if you're intending on manually maintaining the list of products which are in that promo, why not just assign them to a category? Neto supports multiple categories per product, so each product can live in its usual place plus in a "Christmas Specials" category. Then just hide/remove the category when you are done. Much simpler than messing around with custom fields and it should achieve the same thing. We use this technique with great success.

Neto's tweak is intended to automate the process, where you don't want to have to bother specifying which products are on your "Specials" page.

Tony Ovenden

@Erik Merkley? the answer to your question "why not just assign them to a category?" is because I have the ability to over look the obvious and simple solution in search of a complicated (but hopefully elegant) one, or put simply: I over think everything.

thank you for this suggestion, it will work perfectly for my needs.