Smart searches on product fields

Tomas Gomez

Posted on 24/06/2020 15:55:41

Hi,

I am using Smart searches to categorize users according the products they have seen or bought. The options to select the products are indidually or by its parent group.

It would be possible to automatically select the products by a product field? For instance, products with price higher than a certain amount.

This could be easily achieved if the product queries of the repositories would be available in the selection window, but only the Ecom groups are displayed.

Any suggestions are welcome!

Regards,
Tomas

Replies

Nicolai Pedersen

Posted on 24/06/2020 16:00:25

This post has been marked as an answer

So you want to find users who bought products with a price higher than X?

It is not possible with the current data.

You can however create a custom field on the user (or more than one) and then setup a scheduled task using SQL and update all users that bought a product above a specific price and set the field to a value. Then you can create a smartsearch that look at that custom user field.

BR Nicolai

Votes for this answer: 1

Tomas Gomez

Posted on 25/06/2020 11:24:02

Hi Nicolai,

Thanks for the trick :-)

Regards,
Tomas

You must be logged in to post in the forum

Developer forum

Smart searches on product fields

Replies