[Skip to main content](#vessel-content) # Can not add coupon to product ## - **[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")** - [![mojweb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5128-mojweb "View mojweb's Profile") Topic Author - [ Offline](/forum/user/5128-mojweb) Less More - Posts: 431 - Thank you received: 22 - 6 years 5 months ago [\#318067](#318067) by [mojweb](/forum/user/5128-mojweb "View mojweb's Profile") *[Can not add coupon to product](/forum/46-discount-coupon/899662-can-not-add-coupon-to-product#318067 "-- HikaShop version -- : 4,2,3 -- PHP version -- : 7,2 We use coupon for product (free shipping)and when I want to add product to coupon wont save. We have some 50 product listed on that coupon. Now I can not add any new product. I can select, but when I save, product is missing.")* was created by *[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")* -- HikaShop version -- : 4,2,3 -- PHP version -- : 7,2 We use coupon for product (free shipping)and when I want to add product to coupon wont save. We have some 50 product listed on that coupon. Now I can not add any new product. I can select, but when I save, product is missing. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2Rpc2NvdW50LWNvdXBvbi84OTk2NjItY2FuLW5vdC1hZGQtY291cG9uLXRvLXByb2R1Y3Q/dG1wbD1tYXJrZG93bg==) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 6 years 5 months ago [\#318074](#318074) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Can not add coupon to product](/forum/46-discount-coupon/899662-can-not-add-coupon-to-product#318074 "-- HikaShop version -- : 4,2,3 -- PHP version -- : 7,2 We use coupon for product (free shipping)and when I want to add product to coupon wont save. We have some 50 product listed on that coupon. Now I can not add any new product. I can select, but when I save, product is missing.")* Hi, That's because of the size of the column in the database. You can open the hikashop_discount table via your phpmyadmin and edit the column discount_product_id and change its type to text instead of varchar and you'll be able to enter thousands of products in a coupon. However, I would rather recommend to create an unpublished category and select it in the coupon. Then, you can just add that category as a second category in the products for which you want the coupon to apply. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2Rpc2NvdW50LWNvdXBvbi84OTk2NjItY2FuLW5vdC1hZGQtY291cG9uLXRvLXByb2R1Y3Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")** - [![mojweb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5128-mojweb "View mojweb's Profile") Topic Author - [ Offline](/forum/user/5128-mojweb) Less More - Posts: 431 - Thank you received: 22 - 6 years 5 months ago [\#318172](#318172) by [mojweb](/forum/user/5128-mojweb "View mojweb's Profile") Replied by *[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")* on topic *[Can not add coupon to product](/forum/46-discount-coupon/899662-can-not-add-coupon-to-product#318172 "-- HikaShop version -- : 4,2,3 -- PHP version -- : 7,2 We use coupon for product (free shipping)and when I want to add product to coupon wont save. We have some 50 product listed on that coupon. Now I can not add any new product. I can select, but when I save, product is missing.")* Thank you. All clear. Is there a way to limit shipping metod to that coupon? We have free delivery for new products (we manage this manualy and it is ok). We use that coupon (limited to products and now to category) to give customer automatic coupon for delivery cost. But on checkout is that visible as coupon in the end, but delivery is still stated as some cost. Sorry for my english, hope I explain ok. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2Rpc2NvdW50LWNvdXBvbi84OTk2NjItY2FuLW5vdC1hZGQtY291cG9uLXRvLXByb2R1Y3Q/dG1wbD1tYXJrZG93bg==) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 6 years 5 months ago [\#318176](#318176) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Can not add coupon to product](/forum/46-discount-coupon/899662-can-not-add-coupon-to-product#318176 "-- HikaShop version -- : 4,2,3 -- PHP version -- : 7,2 We use coupon for product (free shipping)and when I want to add product to coupon wont save. We have some 50 product listed on that coupon. Now I can not add any new product. I can select, but when I save, product is missing.")* Hi, It's not possible to limit shipping methods based on the coupon in the cart. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2Rpc2NvdW50LWNvdXBvbi84OTk2NjItY2FuLW5vdC1hZGQtY291cG9uLXRvLXByb2R1Y3Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")** - [![mojweb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5128-mojweb "View mojweb's Profile") Topic Author - [ Offline](/forum/user/5128-mojweb) Less More - Posts: 431 - Thank you received: 22 - 3 years 11 months ago - 3 years 11 months ago [\#346863](#346863) by [mojweb](/forum/user/5128-mojweb "View mojweb's Profile") Replied by *[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")* on topic *[Can not add coupon to product](/forum/46-discount-coupon/899662-can-not-add-coupon-to-product#346863 "-- HikaShop version -- : 4,2,3 -- PHP version -- : 7,2 We use coupon for product (free shipping)and when I want to add product to coupon wont save. We have some 50 product listed on that coupon. Now I can not add any new product. I can select, but when I save, product is missing.")* > nicolas wrote: Hi, > > That's because of the size of the column in the database. You can open the hikashop\_discount table via your phpmyadmin and edit the column discount\_product\_id and change its type to text instead of varchar and you'll be able to enter thousands of products in a coupon. > > However, I would rather recommend to create an unpublished category and select it in the coupon. > Then, you can just add that category as a second category in the products for which you want the coupon to apply. Is there any change on that? Im adding 100+ products to some discount, and cant enter more than 50. Last edit: 3 years 11 months ago by [mojweb](/forum/user/5128-mojweb "View mojweb's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2Rpc2NvdW50LWNvdXBvbi84OTk2NjItY2FuLW5vdC1hZGQtY291cG9uLXRvLXByb2R1Y3Q/dG1wbD1tYXJrZG93bg==) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 3 years 11 months ago [\#346868](#346868) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Can not add coupon to product](/forum/46-discount-coupon/899662-can-not-add-coupon-to-product#346868 "-- HikaShop version -- : 4,2,3 -- PHP version -- : 7,2 We use coupon for product (free shipping)and when I want to add product to coupon wont save. We have some 50 product listed on that coupon. Now I can not add any new product. I can select, but when I save, product is missing.")* Hi, There is no change. You can easily do it with a slight modification in the database as I was saying. It shoudl take no more than 5 minutes to do it if you have the PHPMyAdmin access from your hosting. The following user(s) said Thank You: [mojweb](/forum/user/5128-mojweb "View mojweb's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2Rpc2NvdW50LWNvdXBvbi84OTk2NjItY2FuLW5vdC1hZGQtY291cG9uLXRvLXByb2R1Y3Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")** - [![mojweb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5128-mojweb "View mojweb's Profile") Topic Author - [ Offline](/forum/user/5128-mojweb) Less More - Posts: 431 - Thank you received: 22 - 3 years 10 months ago [\#346908](#346908) by [mojweb](/forum/user/5128-mojweb "View mojweb's Profile") Replied by *[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")* on topic *[Can not add coupon to product](/forum/46-discount-coupon/899662-can-not-add-coupon-to-product#346908 "-- HikaShop version -- : 4,2,3 -- PHP version -- : 7,2 We use coupon for product (free shipping)and when I want to add product to coupon wont save. We have some 50 product listed on that coupon. Now I can not add any new product. I can select, but when I save, product is missing.")* OK, thank you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2Rpc2NvdW50LWNvdXBvbi84OTk2NjItY2FuLW5vdC1hZGQtY291cG9uLXRvLXByb2R1Y3Q/dG1wbD1tYXJrZG93bg==) 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.291 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)