[Skip to main content](#vessel-content) # How to limit coupons to certain products only ## - **[aimlesslady](/forum/user/7696-aimlesslady "View aimlesslady's Profile")** - [![aimlesslady's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7696-aimlesslady "View aimlesslady's Profile") Topic Author - [ Offline](/forum/user/7696-aimlesslady) Less More - Posts: 108 - Thank you received: 2 - - 7 years 4 months ago [\#307726](#307726) by [aimlesslady](/forum/user/7696-aimlesslady "View aimlesslady's Profile") *[How to limit coupons to certain products only](/forum/46-discount-coupon/897693-how-to-limit-coupons-to-certain-products-only#307726 "-- HikaShop version -- : 4.1.0 -- Joomla version -- : 3.9.8 -- PHP version -- : 7.0.31 -- Browser(s) name and version -- : Firefox 61.0.2 Is there a limit to how many products can be added to the coupon? If there is, is there another way to isolate certain products perhaps using a zone?")* was created by *[aimlesslady](/forum/user/7696-aimlesslady "View aimlesslady's Profile")* -- HikaShop version -- : 4.1.0 -- Joomla version -- : 3.9.8 -- PHP version -- : 7.0.31 -- Browser(s) name and version -- : Firefox 61.0.2 Is there a limit to how many products can be added to the coupon? If there is, is there another way to isolate certain products perhaps using a zone? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84OTc2OTMtaG93LXRvLWxpbWl0LWNvdXBvbnMtdG8tY2VydGFpbi1wcm9kdWN0cy1vbmx5P3RtcGw9bWFya2Rvd24=) 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: 14304 - - 7 years 4 months ago [\#307730](#307730) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How to limit coupons to certain products only](/forum/46-discount-coupon/897693-how-to-limit-coupons-to-certain-products-only#307730 "-- HikaShop version -- : 4.1.0 -- Joomla version -- : 3.9.8 -- PHP version -- : 7.0.31 -- Browser(s) name and version -- : Firefox 61.0.2 Is there a limit to how many products can be added to the coupon? If there is, is there another way to isolate certain products perhaps using a zone?")* Hi, Yes and no. There is no limit in the code. However, the field discount_product_id of the table hikashop_discount where that data is saved is a varchar(255) type. So it can't store more than 255 characters. We do that for performance optimization. If you want to increase that though, it's easy. Just change the type of that column to "text" via your phpmyadmin. That will allow for around 65 000 characters, enough to store a few tens of thousands of products selected in that option. However, I would recommend instead to create an unpublished category, assign that category to the coupon, and add that category as second category to all the products you want to be linked to the coupon. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi84OTc2OTMtaG93LXRvLWxpbWl0LWNvdXBvbnMtdG8tY2VydGFpbi1wcm9kdWN0cy1vbmx5P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & 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.041 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)