Product Reviews Ablecommerce 7.05

[edinos]

With the new upgrade to 7.05 you have to manually enable product reviews for every product. Not easy when you have thousands of products. Our webhosting company says enabling this was not part of the deal with our upgrade. Just curious does anybody know why they changed this?

Thanks

[compunerdy]

I upgraded and all of mine already have allow reviews checked.

[edinos]

hmm, thats interesting. My hosting company told me i need to go manually check all 4,000 of my products. To me thats crazy. I think they should have them alreaddy checked but they are disagreeing with me.

[mazhar]

If you want to turn on the reviews for all products where they are turned off you can run following query to do that

Code: Select all

UPDATE [ac_Products]
   SET [AllowReviews] = 1
WHERE AllowReviews = 0

[jmestep]

On 7.0.5 sites I've worked on, you have to enable reviews on the product level. On upgrades, the current reviews are still visible after the upgrade, but there is no link to allow the customer to add a review unless the Allow Reviews box is checked on the product page.
Info from Able's change log at http://help.ablecommerce.com/upgrades/a ... _7.0.5.htm

8043 enhancement Store Template Allow individual product reviews

8669 normal Admin UI Update product batch edit module for editing of AllowReviews field

Here is a quote from bugzilla about 8043:

There is a database field for allow reviews, I think it's Product.AllowReviews.
Add somewhere on the add/edit product form to allow this value to be toggled.
The toggle switch should only appear if reviews are enabled for the site. Also
update the product review forms - product review forms should only appear for
customers to use if product reviews are enabled for the site AND for the
product.

[macromark]

If you want to turn on the reviews for all products where they are turned off you can run following query to do that

Code: Select all

UPDATE [ac_Products]
   SET [AllowReviews] = 1
WHERE AllowReviews = 0

Mazhar - Where is this "query" done? Do you execute it from within the admin area somewhere?

[mazhar]

I used SQL Server Management Studio to do this via connecting directly to Database. So if you can connect to database using SQL Management Studio then its good otherwise go to your hosting and hopefully you will find some sort of Query tool in Database options.