Assign Automatically A Product To A Category

[Serial]

Hi,

 

I can't assign products to a category.

My problem is about sales.

 

I update products with the csv import.

In this, we can assign categories to a product by enter ids of categories separated by a comma.

 

But, at sales period, I have a hundred of products who must pass to "On Sales" category, in addition to his categories.

 

How can I do this automatically ?

 

I have a parameter at the product "is_solde" where the value is 0 by default because the product isn't in sale. But If the product is on sale, the value is 1.

 

What is the most simple ?

 

I thought to create my category and to do a query who displays the list of products who have this parameter equal at 1. But to do this, I don't know

 

Thanks for your help !