Amending names on customer reviews

[Long Tall Sally]

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 - is there any way of just having first names as the reviewer as opposed to the full name which is generated automatically.

MTIA
Jayne

[birdoasis]

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.

[Long Tall Sally]

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.

[lauten]

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.

[atomage]

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.

[TheOracle]

Sounds challenging. I like.

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.