I am looking for the option values for the attribute visibility. We have a import script running, which is delivering all articles to magento and automatically sets the visibility for simple products to "Katalog and Search" which is value 4.

So now I want to change that to make the simple products visible just through "Search". I was searching for the value within the MySQL database but couldn´t find anything yet. Does anyone of you know or have an idea in which table to find that option values of visbility?

Would be great if anybody could help me on this.

1 Answer 1


These are constants, held in the class Mage_Catalog_Model_Product_Visibility

const VISIBILITY_IN_SEARCH      = 3;
const VISIBILITY_BOTH           = 4;

It's preferred to use them, and not the values directly.

  • It works, tanks very much.
    – user37184
    Apr 20, 2016 at 7:39

Your Answer

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

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