Try the Demo

Magento

eCommerce Software for Online Growth

Magento Forum

Our new hosted solution for small & emerging businesses
   
Catalog - Product Information - General - Visibility Bug
 
Azkul
Jr. Member
 
Avatar
Total Posts:  17
Joined:  2008-01-10
 

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

 Signature 

Thanks,
Azkul

The Lens Flare - Art and Photography Gallery

 
Magento Community Magento Community
Magento Community
Magento Community
 
Moshe
Magento Team
 
Avatar
Total Posts:  1770
Joined:  2007-08-07
Los Angeles
 

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.

 Signature 

- I would love to change the world, but they won’t give me the source code -

 
Magento Community Magento Community
Magento Community
Magento Community
 
Azkul
Jr. Member
 
Avatar
Total Posts:  17
Joined:  2008-01-10
 

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?

 Signature 

Thanks,
Azkul

The Lens Flare - Art and Photography Gallery

 
Magento Community Magento Community
Magento Community
Magento Community
 
Moshe
Magento Team
 
Avatar
Total Posts:  1770
Joined:  2007-08-07
Los Angeles
 

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

 Signature 

- I would love to change the world, but they won’t give me the source code -

 
Magento Community Magento Community
Magento Community
Magento Community
 
Moshe
Magento Team
 
Avatar
Total Posts:  1770
Joined:  2007-08-07
Los Angeles
 

Actually it is right now is possible too.

 Signature 

- I would love to change the world, but they won’t give me the source code -

 
Magento Community Magento Community
Magento Community
Magento Community
 
Darken
Jr. Member
 
Total Posts:  11
Joined:  2008-11-05
 
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?

 
Magento Community Magento Community
Magento Community
Magento Community
 
chris-nextlinq
Jr. Member
 
Avatar
Total Posts:  4
Joined:  2009-02-13
The Netherlands, Groningen
 

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!!!

 Signature 

Magento Specialist. Please visit our website http://www.nextlinq.nl or check out our latest project on http://www.bandenanders.nl.

 
Magento Community Magento Community
Magento Community
Magento Community
 
chris-nextlinq
Jr. Member
 
Avatar
Total Posts:  4
Joined:  2009-02-13
The Netherlands, Groningen
 

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

 Signature 

Magento Specialist. Please visit our website http://www.nextlinq.nl or check out our latest project on http://www.bandenanders.nl.

 
Magento Community Magento Community
Magento Community
Magento Community
 
coer
Jr. Member
 
Total Posts:  11
Joined:  2011-03-14
 
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!!

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top
 
© Copyright 2012 Magento Inc.
Privacy Policy|Terms of Service
Magento Community Count
704029 users|1882 users currently online|497356 forum posts