rob_illinois 0 Posted September 7, 2015 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 Share this post Link to post Share on other sites
burt 5,558 Posted September 7, 2015 Which version of osCommerce are you using ? Help shape the future of Phoenix; join the Phoenix Club Share this post Link to post Share on other sites
rob_illinois 0 Posted September 8, 2015 Version 2.3.3 Share this post Link to post Share on other sites
burt 5,558 Posted September 8, 2015 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 Help shape the future of Phoenix; join the Phoenix Club Share this post Link to post Share on other sites
rob_illinois 0 Posted September 8, 2015 So you have version 2.3.4? Share this post Link to post Share on other sites
burt 5,558 Posted September 8, 2015 Responsive (bootstrap) Version of 2.3.4 Help shape the future of Phoenix; join the Phoenix Club Share this post Link to post Share on other sites
rob_illinois 0 Posted September 8, 2015 What do I need to do to get mine to that version? Is it hard to do? Share this post Link to post Share on other sites
rob_illinois 0 Posted September 9, 2015 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. Share this post Link to post Share on other sites
♥Tsimi 525 Posted September 9, 2015 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. Share this post Link to post Share on other sites
rob_illinois 0 Posted September 10, 2015 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 Share this post Link to post Share on other sites