Coupons, where is stored the quota per user?

  • Posts: 6
  • Thank you received: 0
12 years 11 months ago #31779

Hello Nicolas
I would like to set manually (or by a php-script) the quota per user
e.g. if some members didn't use their coupons trough the webshop, they used it in a direct selling point.
So I searched the database to find the table where this quota is stored.
I did not succeed.

Thanks for a hint

Wilfried

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
12 years 11 months ago #31818

Hi,

That's normal. That information is not stored anywhere.
Each time a customer wants to use a coupon code which has a user quota, there is a dynamic query made to the database to check the number of orders made by that user with this coupon code and it will refuse the coupon code if that number reached the quota.

The solution would be to create each time a fake order for that user with the coupon code in it. You should be able to do that with the latest version of HikaShop via the backend. You could also create a script to add that fake order manually.

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

  • Posts: 6
  • Thank you received: 0
12 years 11 months ago #31877

OK, thank you.

Wilfried

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

Time to create page: 0.060 seconds
Powered by Kunena Forum