Change Product Visibility Status via CSV Import

[WorldACA]

I am working with Prestashop 1.5.2. I have been successfull with importing several products via csv however I need to change the 'Visibility' of the product from 'EVERYWHERE' to 'SEARCH' and I would prefer to do this via csv as opposed to manually updating hundreds of products. My question is, can this be done via csv import (changing the 'Visibility' of the product from 'EVERYWHERE' to 'SEARCH') or would I need to manually change this status? Please note that I am not referring to the 'Status' of the product being enabled or disabled.

 

Do you have any suggestions on how to implement this? I would greatly appreciate your input and instructions on how to achieve this.

 

Thank you

Ann

[duker]

Меня тоже интересует этот вопрос, если кто нашел решение, отпишитесь пожалуйста. 

[vekia]

Меня тоже интересует этот вопрос, если кто нашел решение, отпишитесь пожалуйста. 

 

please use correct language version, we are in english section.

thanks in advance.

[ernestus2001]

Hello.

I have same issue. I would like to change visibility for selected products from "both" to "search".

I can't do this through .csv file (no such column), but can I do this throou SQL?

 

I can see that in table "ps_product" there is a column "visibility" - will it be enough to just make a simple update that will change for selected products attribute from "both" to "serach" or will such thing somehow "break" the database?

 

Best, Pawel

[iDrasaly]

Property Product->visibility has bad value (allowed values are: both, catalog, search, none)