How to identify products where Comments are not turned on

General Forums General Questions
#1

I want to make sure all my products have comments and reviews turned on. I can't set this for all products in admin via global update because there are too many products for admin to display and I just get a blank page. Can someone point me to where in the tables I can can determine which products do not have comments and reviews turned on?



Thanks.

#2

[quote name='novista' timestamp='1315161259' post='120957']

I want to make sure all my products have comments and reviews turned on. I can't set this for all products in admin via global update because there are too many products for admin to display and I just get a blank page. Can someone point me to where in the tables I can can determine which products do not have comments and reviews turned on?



Thanks.

[/quote]

Hello, novista!



You should check the “cscart_discussion” table then:



object_id - the ID of your product,

object_type - “P” if it is product,

type - “B” - Communication and Rating, “C” - Communication, “R”- Rating, “D” - Disabled.

#3

Thanks orangegirl, new it had to be in there somewhere.