Verified Purchaser Reviews

[rob_illinois 0]

   I have reviews on my site now, users can leave a review when they are and are not logged in. I would like to have it added so when someone does a review, and they actually purchased the item it will have a logo or bold text by their name saying "Verified Purchaser". If they did not buy it then it will not show the logo/text.Is there an add-on for this, or a way I can add this in so it does this?

 

 

Thanks

[burt 5,275]

Which version of osCommerce are you using ?

[rob_illinois 0]

      Version 2.3.3

[burt 5,275]

I've done something similar for the latest version but it wont work for the version you have.

 

In general:

 

sql:  add a new column to reviews called "verified".  0 = no, 1 = yes

 

1.  when a review is submitted, see if the reviewer has purchased the product.

2.  if yes, update the verified column to 1

3.  now you need to add verified to the SQL call in the review display page

4.  check if the SQL verified call = 1 and if it is ... display a "verified buyer" label

[rob_illinois 0]

  So you have version 2.3.4?

[burt 5,275]

Responsive (bootstrap) Version of 2.3.4

[rob_illinois 0]

  What do I need to do to get mine to that version? Is it hard to do?

[rob_illinois 0]

   How about an approval process so not anyone can leave a review? The Admin has to approve it before it goes live on the website.

[♥Tsimi 525]

I might be wrong but i thought that this is already existing. The admin can view and approve every review and then set its status to green or keep it red or even edit it before publish.

[rob_illinois 0]

  Yes I see it now, Thanks.

 

How every I do see it has on the Review stars (low end says Bad high-end says* Good and I would like to change out the Good for Excellent. Where is the code for this so I can change out this one word?

 

 

Thanks