[Skip to main content](#vessel-content)

#   Coupons, where is stored the quota per user?

##

- **[prinzipal](/forum/user/4357-prinzipal "View prinzipal's Profile")**
- [![prinzipal's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4357-prinzipal "View prinzipal's Profile") Topic Author
- [ Offline](/forum/user/4357-prinzipal)

Less More

- Posts: 6
- Thank you received: 0
-
-

14 years 11 months ago [\#31779](#31779) by [prinzipal](/forum/user/4357-prinzipal "View prinzipal's Profile")  *[Coupons, where is stored the quota per user?](/forum/4-how-to/31779-coupons-where-is-stored-the-quota-per-user#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")* was created by *[prinzipal](/forum/user/4357-prinzipal "View prinzipal's Profile")*

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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMxNzc5LWNvdXBvbnMtd2hlcmUtaXMtc3RvcmVkLXRoZS1xdW90YS1wZXItdXNlcj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86556
- Thank you received: 14305
-
-

14 years 11 months ago [\#31818](#31818) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Coupons, where is stored the quota per user?](/forum/4-how-to/31779-coupons-where-is-stored-the-quota-per-user#31818 "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")*

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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMxNzc5LWNvdXBvbnMtd2hlcmUtaXMtc3RvcmVkLXRoZS1xdW90YS1wZXItdXNlcj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[prinzipal](/forum/user/4357-prinzipal "View prinzipal's Profile")**
- [![prinzipal's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4357-prinzipal "View prinzipal's Profile") Topic Author
- [ Offline](/forum/user/4357-prinzipal)

Less More

- Posts: 6
- Thank you received: 0
-
-

14 years 11 months ago [\#31877](#31877) by [prinzipal](/forum/user/4357-prinzipal "View prinzipal's Profile")  Replied by *[prinzipal](/forum/user/4357-prinzipal "View prinzipal's Profile")* on topic *[Re: Coupons, where is stored the quota per user?](/forum/4-how-to/31779-coupons-where-is-stored-the-quota-per-user#31877 "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")*

OK, thank you.

Wilfried

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMxNzc5LWNvdXBvbnMtd2hlcmUtaXMtc3RvcmVkLXRoZS1xdW90YS1wZXItdXNlcj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.049 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
