Product Reviews from Buyers Only

[smcelligott]

When I first created my ZC shop several years ago, I opted against Product Reviews - not sure what my logic was . . . ;)

In any event I want to re-enable some kind of Product Review functionality, but I'm not sure ZC's off-the-shelf version is going to cut it.

I see lots of people want to offer review functionality to guests, but I want to do the opposite. I only want actual buyers of a product to be able to review it. I don't really care if Joe Random likes our product, if he is not a buyer, and has not actually "experienced" what we are selling. I get general product opinions on our Facebook Page, but I want our site product reveiws to really mean something. I think it also adds more credibility if one must be an actual user, in order to offer a review...but that is my opinion.

I suppose the way I would want to get reviews is to send follow-up e-mails, two weeks after purchase. These would ask buyers (and perhaps incentivise them) to review the product, and/or offer a general testimonial. Additionally, the next time the customer logs in, he/she would be reminded to review not-yet-reviewed products purchased previously (one reminder, and then let it go).

Is this all too complicated, or would it be easier to create this outside of Zen Cart, and then somehow integrate the reviews back in? Would be interested in chatting with someone who has done this, or somebody who knows of some sites (zen or non-zen) that do this well.

Look forward to your feedback/suggestions.

[Ajeh]

As a start, customize the file:
/includes/modules/pages/product_reviews_write/header_php.php

and add the code in RED:

if (!$_SESSION['customer_id']) {
  $_SESSION['navigation']->set_snapshot();
  zen_redirect(zen_href_link(FILENAME_LOGIN, '', 'SSL'));
}
// bof: check customer bought product before allowing creation of a review
$customers_query_raw = "select c.customers_id, c.customers_firstname, c.customers_lastname, sum(op.products_quantity * op.final_price)+sum(op.onetime_charges) as ordersum from " . TABLE_CUSTOMERS . " c, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS . " o where c.customers_id = o.customers_id and o.orders_id = op.orders_id and op.products_id = :productsID";
$customers_query_raw = $db->bindVars($customers_query_raw, ':productsID', $_GET['products_id'], 'integer');
$customers_query = $db->Execute($customers_query_raw);
if ($customers_query->EOF) {
//  $messageStack->add_session('header', 'Customer Bought this', 'caution');
} else {
  $messageStack->add_session('header', 'Customer did NOT buy this', 'caution');
  zen_redirect(zen_href_link(FILENAME_PRODUCT_REVIEWS, zen_get_all_get_params(array('reviews_id'))));
}
// eof: check customer bought product before allowing creation of a review

NOTE: you could make this the only change or get fancier based on where the customer is, are they logged in, did they buy the product, etc. etc. etc.

[diamond1]

Hello Ajeh I tried your code, but I do not work once you put the code you insert any reviews yet. Even if the customer has already bought the product. Can you help me with this code

thanks

V1.5.1

[Ajeh]

Could you explain what you mean by "I do not work" ... are you getting error messages? Or what is happening?

[diamond1]

Sorry for the bad English. It seems to work, but I'm not even enter the reviews there is no box to type in, check the message that says Customer did NOT buy this.

[diamond1]

I put a print, and in fact as if the client had not purchased the product

[Ajeh]

All that this change does is that if the Customer tries to use the Write Review a chack is done on the Orders made by the customer and if there is not an Order of the Product then the message in yellow shows that says:
Customer did NOT buy this

and the Customer cannot write a review ... and the Customer is taken to the page for:
product_reviews

for that Product ...

You can change the message to anything you want it to be ...

What actually isn't working right for you? Based on the image you are showing, it is doing exactly that ...

[diamond1]

The message I know that I can change. the problem is that the customer bought the product but does not write the review also when he bought the product. And as if the customer has not bought the product.

[Ajeh]

Try making two changes to that code, the first replace the whole line with this new line of code:

$customers_query_raw = "select c.customers_id, c.customers_firstname, c.customers_lastname from " . TABLE_CUSTOMERS . " c, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS . " o where c.customers_id = o.customers_id and o.orders_id = op.orders_id and op.products_id = :productsID";

and the second add the !:

if (!$customers_query->EOF) {

See if that works better for you ...

[diamond1]

Mr. Ajeh! you are a magician works great thank you very much
This deserves another donation