Amending names on customer reviews

can't see this is covered anywhere - apologies if I have missed it.

I have got quite a few customer reviews - but some of my reviewers don't want their full names on the site :cool: - is there any way of just having first names as the reviewer as opposed to the full name which is generated automatically.

MTIA
Jayne

There is a way, but I have to look at it to figure it out.

I'm sure that you either just have to either remove the last name field or if it's a script adding the first and last name with a space in between then the script has to be edited to just pull the first name.

It would be nice to have just the first initial and the last name. I think that looks more professional.

In the meantime you can have instructions on leaving reviews informing the customer that their full name will be shown. That way they won't leave a review if they don't want to have their name showing.

Thanks JP - I take the point that I need to put this on the instructions so that people know.
I have removed product reviews in the past at the request of customers who hadn't realised that their full name would be on there.

I'm looking for a solution to this issue also. It would be great to grab the first name and first letter of last name. Or even just first and location city or state.

I'm also very interested in doing this. If anyone knows how to do this, that would be great. My customers would actually prefer to have only their first name shown... no last name.

Sounds challenging. I like. :smile:

In your includes/modules/<your_template>/pages/reviews/header_php.php file,

find:

$reviews_query_raw = "SELECT r.reviews_id, left(rd.reviews_text, 100) AS reviews_text, r.reviews_rating, r.date_added, p.products_id, pd.products_name, p.products_image, r.customers_name 
                      FROM " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd 
                      WHERE p.products_status = '1' 
                      AND p.products_id = r.products_id 
                      AND r.reviews_id = rd.reviews_id 
                      AND p.products_id = pd.products_id 
                      AND pd.language_id = :languageID 
                      AND rd.languages_id = :languageID" . $review_status . " 
                      ORDER BY r.reviews_id DESC";

replace with:

$reviews_query_raw = "SELECT r.reviews_id, left(rd.reviews_text, 100) AS reviews_text, r.reviews_rating, r.date_added, p.products_id, pd.products_name, p.products_image, c.customers_firstname
                      FROM (" . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CUSTOMERS . " c)
                      WHERE p.products_status = '1' 
                      AND p.products_id = r.products_id 
                      AND r.reviews_id = rd.reviews_id 
                      AND p.products_id = pd.products_id 
                      AND pd.language_id = :languageID 
                      AND rd.languages_id = :languageID" . $review_status . " 
                      ORDER BY r.reviews_id DESC";

Then, in your includes/templates/<your_template>/templates/tpl_reviews_default.php file,

find this peace:

<?php echo sprintf(TEXT_REVIEW_BY, zen_output_string_protected($reviews->fields['customers_name'])); ?>

replace with:

<?php echo sprintf(TEXT_REVIEW_BY, zen_output_string_protected($reviews->fields['customers_firstname'])); ?>

This should output the customer's firstname only rather than the full name. :wink2:

Thanks to all for your support :clap:- and a HUGE thank you to TheOracle for the time and effort.:hug:
Will let you know how we get on with it.

Thanks for your positive input. Keep me posted. :smile:

It would be great to have an update for the above modifications. :smile:

Thank you! I will try this later this week. Hope it works out! Very appreciated.

TheOracle:

It would be great to have an update for the above modifications. :smile:
OK, so 2 years later and finally some feedback.... it doesn't work.

I did what you said above and changed the code on those two files but the reviews still show the customers full name.

Is there a way to make the reviews show the customers first name and city only?

NOTE: this will change new reviews ... old reviews you will need to edit in the database ...

All it did for me is replaced First Name, Last Name with blank.

"Reviewed by"

Is this old code that doesn't work with latest version?

Sorry I did not read how poorly the SELECT statement was on this ...

Peek at the code change on post #3 of:
http://www.zen-cart.com/forum/showthread.php?t=84346

To only see the customers_firstname vs the customers_firstname and customers_lastname ...

This is really the cleaner way to get the correct data added to the review ...

Thank you, that worked for list of reviews, but didn't for individual review selected.

Finally I just hardcoded "tpl_product_review" info and default files with predefined response: "Community member"

Make sure you are looking at new reviews ...

The Review is being build with just the customer's first name so you should not see anything but the first name anywhere on the reviews by changing that code to just contain the customers_firstname ...

For existing Reviews you would need to edit the customers_name field in the reviews table ...