I need to add several products with different categories in a magento store and leave them disabled. After certain date, I need to enable all of them and disable current enabled product.
My first thought is to: Add special name int prodcut name, for instance:
afterwards select all items via sql and set their status on disabled
select all items that contain sp1 and enable those.
Would there be another option in order to do that?