If email matches with buyer email display text?

  • Posts: 1119
  • Thank you received: 114
8 years 10 months ago #226700

Hi,

So I have installed third party review component and it works fine.
However what I would like to have is to display some jtext if entered email in review matches order email. So people would know that this review was left by the buyer and not random people...Is there a way to have it?

Thanks

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
8 years 10 months ago #226732

Hi,

What you're asking for is related to the third party review component.
So please contact their support.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 1119
  • Thank you received: 114
8 years 10 months ago #226825

Hi,

Thanks for replay. I understand it is not related to hikashop but how to call such function/ check to hikashop itself. It i would like to add such text somewhere in hikashop view.
I thought if i would know how to do it in hikashop i could modify that code and add it by my self.

Anyway thanks

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
8 years 10 months ago #226829

Hi,

To know if the user have bought the product ; you need to perform a SQL query on the table "order" joined with the table "order_product".
By using the function "hikashop_loadUser(false)" you can retrieve the current HikaShop user id ; that id will be useful for the query on the table "order", for the field "order_user_id".
About the product, you will be able to find it in the table "order_product" in the field "product_id" and the field "order_id" should be use for the join between the table "order" and the table "order_product".
In order to be sure that the user have bought the product and not just create an order with that product into ; you also need to filter the orders on the order_status ; it could be also useful to only retrieve the orders with an "order_type" set to "sale".

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

Time to create page: 0.064 seconds
Powered by Kunena Forum