1

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:

  • sp1-Donut
  • sp1-Coffee
  • sp1-Tea

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?

Improve this question

1 Answer 1

Reset to default
2

Hi fran35 and welcome to MageOverflow!

What about just using the mass edit feature of the product grid? Or do you want to do it automatically?

On stackoverflow is a great post how to do it: https://stackoverflow.com/a/26365562/1480397

Improve this answer
2
  • hello Fabian, thanks for the suggestion. Mass edit worked wonders on a short test, hopefully magento won't choke when in production (about 6000 products on current store). Regards!
    – fran35
    Commented Jun 11, 2015 at 18:44
  • As long as you increase max_input_vars high enough, I don't see a problem.
    – Fabian Blechschmidt
    Commented Jun 11, 2015 at 18:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.