Mass action configuration

Hi,

I am looking for help in mass action configuration.

1. We want to put products to discount category based on product price and select products only who were created more then 3 months ago...

So as example if product price is lower or equal to 10 euros then it should go into category "discount -15%" and if it's more then 3 months old.
But it still effects products who were created like only 1 month ago. Is there something wrong with screenshot attached?

Hi,

Thanks for help.

Another question.
We also would like to filter by product name which contains word "Jeans" and word "Bridges". Basically we need to select products with those names only. How should we deal with that?

Can we add multiply words in contains and seperate it with comma or we should create filter for each word?

Thanks

Another question.

How can we add category to products who are in 2 different categories?

So if we have 2 categories with names "Dresses" and "Shoes". We need select product from only this categories and add category with name "Sale".

Should we create mass action for each category or this somehow can be added into one?
If we do like in the screenshot bellow, we get error "1052 Column 'product_id' in where clause is ambiguous".

Hi,

Thanks for explanation. So it seems we will have to create mass action for each category. How many mass actions system can handle?

Thanks