Reviews - Updated [Support Thread]

[mikestaps]

I have a couple of things...
1. message stack/notice is not showing up when customer is not logged in and tries to write a review with Enable product reviews by guests? set to 0.

2. I had previously added reply to reviews functionality to my 1.3.9h store. I am trying to add it to this with some problems. I am hoping that someone notices and can correct my mistake/s and/or omissions.
All I have been getting is a blank page with no right side boxes, and no myDebug out put either...???
here is a list of my mods...

SQL

ALTER TABLE  `reviews_description`
  ADD  `reviews_reply_text` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

modules/pages/product_reviews_info/header_php.php:

// addition of reviews_reply_text below

  $review_info_query = "SELECT rd.reviews_text, r.reviews_rating, r.reviews_id, r.customers_name,  rd.reviews_reply_text,

                               r.date_added, r.reviews_read, p.products_id, p.products_price,

                               p.products_tax_class_id, p.products_image, p.products_model, pd.products_name

                        FROM " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd

                        WHERE r.reviews_id = :reviewsID

                        AND r.reviews_id = rd.reviews_id

                        AND rd.languages_id = :languagesID

                        AND r.products_id = p.products_id

                        AND p.products_status = '1'

                        AND p.products_id = pd.products_id

                        AND pd.language_id = :languagesID " . $review_status;



  $review_info_query = $db->bindVars($review_info_query, ':reviewsID', $_GET['reviews_id'], 'integer');

  $review_info_query = $db->bindVars($review_info_query, ':languagesID', $_SESSION['languages_id'], 'integer');

  $review_info = $db->Execute($review_info_query);



  $products_price = zen_get_products_display_price($review_info->fields['products_id']);



  $products_name = $review_info->fields['products_name'];

//addition of reviews reply
  if ($review_info->fields['reviews_reply_text']) != '') {
		$reviews_reply_text = $review_info->fields['reviews_reply_text'];
		}

  if ($review_info->fields['products_model'] != '') {

    $products_model = '<br /><span class="smallText">[' . $review_info->fields['products_model'] . ']</span>';

  } else {

    $products_model = '';

  }

languages/english/YOUR_TEMPLATE/product_reviews_info.php

define('TEXT_OF_5_STARS', '');

define('TEXT_PRODUCT_INFO', 'Take Me to the Details');

define('TEXT_REVIEW_ADDITIONAL', 'Read More Reviews');
//addition of review reply heading
define('TEXT_REVIEW_REPLY_HEADING','<strong>' . STORE_NAME . ''s Reply:</strong>');

templates/YOUR_TEMPLATE/templates/tpl_product_reviews_info_default.php

ADDED TO THE BOTTOM, JUST BEFORE THE LAST </div>

<!--bof Reviews Reply -->

<br class="clearBoth"/>

<?php
if ($reviews_reply_text) != ''){
?> 
<div id="reviewsInfoDefaultMainContent" class="content"><?php echo TEXT_REVIEW_REPLY_HEADING; ?><br /><?php echo zen_break_string(nl2br(zen_output_string_protected(stripslashes($review_info->fields['reviews_reply_text']))), 60, '-<br />'); ?></div>

<?php } ?>
<!--eof Reviews Reply-->
</div>

My hope is to get this working properly, and then add the ability to write your reply on the "edit review" page in the admin. I am currently just writing the reply's through phpMyAdmin and then approving the review there.

The working 1.3.9 version of this is here

Non working 1.5.1 is here - (this store is not yet public!)

[mikestaps]

Ok, so the reply is working now. Once I get the edit aspect of it working I'll post it!

[lat9]

I have a couple of things...
1. message stack/notice is not showing up when customer is not logged in and tries to write a review with Enable product reviews by guests? set to 0.

I'm not sure what notice you're expecting, but on a "stock" Zen Cart v1.5.1 install with this plugin installed ... if "Enable product reviews by guests?" is set to 0, the "Write Reviews" button still shows but clicking it takes the customer to the login page with a message that reads "You need to sign into your account before you can write a review."

[mikestaps]

The message "You need to sign into your account before you can write a review." doesn't show up....
I'll dig into that tomorrow, I was all focused on the reply thing.

[lat9]

The message "You need to sign into your account before you can write a review." doesn't show up....
I'll dig into that tomorrow, I was all focused on the reply thing.

It's a header-message, so it will depend on where those messages are displayed in your template. For the "Classic" template, the message shows at the very top of the screen.

[pwdan]

Does this address the duplicate review content issue? Reviews currently appear on multiple pages, which isn't great from an seo standpoint.

[tom97zr2]

Does this address the duplicate review content issue? Reviews currently appear on multiple pages, which isn't great from an seo standpoint.

Hello, I installed this add on and it isn't working for me. I just created my store recently with the new 1.51 version. I am using the fast and easy checkout, and only using guest checkout, forcing the customer to go to the enter billing information step one page after clicking the go to checkout. my site is http://cardiozonetreadmills.com . I am sure I installed this correct. if I enter in my billing information and go to the next step in the checkout, I am then allowed to write reviews if I go back to a product page and click the write review button. I am sure I have all the configurations set correctly. Everything else is working good. I have done quite alot of customizing to my site and had to learn alot to do it, been spending so much time on it everyday.

Anyone know what might be needed or fixed?

I realized with the shopping cart and free shipping in the header add on that the english file needed to be put in the main english folder, not one step further into my templates folder like the instructions says. I'm not using that add on right now until I get it looking right on my site.

Thanks everyone alot for all the free information and assistance. I've read alot here.

[picandnix]

Hello, I installed this add on and it isn't working for me. I just created my store recently with the new 1.51 version. I am using the fast and easy checkout, and only using guest checkout, forcing the customer to go to the enter billing information step one page after clicking the go to checkout. my site is http://cardiozonetreadmills.com . I am sure I installed this correct. if I enter in my billing information and go to the next step in the checkout, I am then allowed to write reviews if I go back to a product page and click the write review button. I am sure I have all the configurations set correctly. Everything else is working good. I have done quite alot of customizing to my site and had to learn alot to do it, been spending so much time on it everyday.

Anyone know what might be needed or fixed?

I realized with the shopping cart and free shipping in the header add on that the english file needed to be put in the main english folder, not one step further into my templates folder like the instructions says. I'm not using that add on right now until I get it looking right on my site.

Thanks everyone alot for all the free information and assistance. I've read alot here.

To be honest I'm not 100% sure what your actual question is.
However I'm surmising: if you are using FEC with it set to guest checkout only and only a registered customer can write a review (yes?) then logically you wouldn't be able to write a review until the system knows your information/account details anyway, right? Hence you being able to write a review only *after* submitting your personal details and not beforehand.