Magento

When setting a product to the visibility of “Nowhere”, it still shows up in both the search and the /catalog/category list.

The “Visibility” attribute is local, which means its value is set differently for each store.

Make sure that in the left top corner “Select Store” dropdown you have “English store” before changing this attribute.

Ah HA!  That did it.  Are there plans to make it so if I have “all stores” selected, that it’ll recurse through the list and set them all one way or the other?

In future releases there will be no problem marking all attributes as “Global” and that will create the effect you desire.

Actually it is right now is possible too.

Moshe - 10 January 2008 04:25 PM

Actually it is right now is possible too.

Greetings!

I’ve got the same problem here, like in the first post…

I used 1.1.8. version. I’ve just upgraded to 1.2.0.3. (Followed the wiki instructions)

it works fine, but I have two problem:
- any product visibility set to “nowhere”
or
- any product status set to “disabled”

makes no effect. Still showing up in product listing, in category menu, search etc. Everywhere in the frontpage.

I don’t have top left select store dropdown, because I have only one store.

I set ‘visibility’ and ‘status’ atributes to global. But the example product still showing up,

I cleared cache at backend, also manualy in /var/cache (and /var/session).

It was a problem in 1.1.8., that’s why I upgraded. But still can’t figure out, what’s wrong…

If I make a product manually, the two attributes works well(not showing the product when I change them). If I make database sql dump, or export -> import porducts, the problem stand still.

I use Hungarian language at my backend, but I didn’t changed the two attributes value, or name.

Any ideas?

This is a problem with the table catalog_category_product_index. When setting visibility to global it will be updated in catalog_product_entity_int ( attributecode 85) but NOT in catalog_category_product_index.

SOLUTION:

- set the scope of visibility back to store view and update each store view individually.

- setup a cronjob that performs an update query between catalog_category_product_index and catalog_product_entity_int
Use this solution only when you want a global use of visibility for your products!!!

Use this query to update catalog_category_product_index for the second solution listed above:

UPDATE catalog_category_product_index c, catalog_product_entity_int i SET c.visibility = i.value WHERE i.attribute_id = 85 AND i.entity_id = c.product_id

Note: Always backup your data

Moshe - 10 January 2008 04:07 PM

The “Visibility” attribute is local, which means its value is set differently for each store.

Make sure that in the left top corner “Select Store” dropdown you have “English store” before changing this attribute.

Thank you, I searched for hours, and in the end it’s so simple! Ahrggh, I can kick myself not thinking about this earlier.
Anyway, a big thanks!!