Page 1 of 1
Product Reviews Ablecommerce 7.05
Posted: Wed Dec 01, 2010 12:19 pm
by 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
Re: Product Reviews Ablecommerce 7.05
Posted: Wed Dec 01, 2010 12:28 pm
by compunerdy
I upgraded and all of mine already have allow reviews checked.
Re: Product Reviews Ablecommerce 7.05
Posted: Wed Dec 01, 2010 11:12 pm
by 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.
Re: Product Reviews Ablecommerce 7.05
Posted: Thu Dec 02, 2010 5:48 am
by 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
Re: Product Reviews Ablecommerce 7.05
Posted: Thu Dec 02, 2010 7:29 am
by 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.
Re: Product Reviews Ablecommerce 7.05
Posted: Tue Mar 08, 2011 11:11 am
by macromark
mazhar wrote: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?
Re: Product Reviews Ablecommerce 7.05
Posted: Wed Mar 09, 2011 3:43 am
by 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.