rob_illinois Posted September 7, 2015 Share 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 Quote Link to comment Share on other sites More sharing options...
burt Posted September 7, 2015 Share Posted September 7, 2015 Which version of osCommerce are you using ? Quote Link to comment Share on other sites More sharing options...
rob_illinois Posted September 8, 2015 Author Share Posted September 8, 2015 Version 2.3.3 Quote Link to comment Share on other sites More sharing options...
burt Posted September 8, 2015 Share 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 Quote Link to comment Share on other sites More sharing options...
rob_illinois Posted September 8, 2015 Author Share Posted September 8, 2015 So you have version 2.3.4? Quote Link to comment Share on other sites More sharing options...
burt Posted September 8, 2015 Share Posted September 8, 2015 Responsive (bootstrap) Version of 2.3.4 Quote Link to comment Share on other sites More sharing options...
rob_illinois Posted September 8, 2015 Author Share Posted September 8, 2015 What do I need to do to get mine to that version? Is it hard to do? Quote Link to comment Share on other sites More sharing options...
rob_illinois Posted September 9, 2015 Author Share 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. Quote Link to comment Share on other sites More sharing options...
♥Tsimi Posted September 9, 2015 Share 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. Quote Link to comment Share on other sites More sharing options...
rob_illinois Posted September 10, 2015 Author Share 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 Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.