I am using CartThrob for an e-commerce site. They want reviews for items, but would also like to show ‘verified buyers’ or even limit reviews to actual buyers. Not sure if we will use Channel Ratings be DevDemon or Ratings by Solspace.

I imagine this can be done by a query that checks if the field in the DB that tracks orders can be checked for a value, then show/hide the review form (if limiting who can review) or show a ‘verified’ badge. Correct? If so…any tips on where to start?

Since orders placed are tied to a member id, you can check the database to see if that member ID has been used in an orders entry. If you’re also using the purchased items channel, it’d be real easy to see, as well, if that member is tied to a specific product.

SOMETHING like this. I don’t know that i have the column names right, etc, but something like this is where I’d start:

If any results are returned, then that person is in the database, and therefore “verified”