[Skip to main content](#vessel-content) # How to apply a discount on product variants? ## - **[Jabatec](/forum/user/5180-jabatec "View Jabatec's Profile")** - [![Jabatec's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar5180.png)](/forum/user/5180-jabatec "View Jabatec's Profile") Topic Author - [ Offline](/forum/user/5180-jabatec) Less More - Posts: 90 - Thank you received: 15 - - [](https://jabatec.com) - 9 years 7 months ago [\#263890](#263890) by [Jabatec](/forum/user/5180-jabatec "View Jabatec's Profile") *[How to apply a discount on product variants?](/forum/46-discount-coupon/889144-how-to-apply-a-discount-on-product-variants#263890 "Hi, Is it not possible to apply a different discount on product variants? Is it not possible to assign a product variant to a category? and on this category a discount. Also, via custom fields it is not possible to work discounts on product variants I'm looking for some solution without having to go through phpmyadmin but I can not find anything. Best regards, Javier")* was created by *[Jabatec](/forum/user/5180-jabatec "View Jabatec's Profile")* Hi, Is it not possible to apply a different discount on product variants? Is it not possible to assign a product variant to a category? and on this category a discount. Also, via custom fields it is not possible to work discounts on product variants I'm looking for some solution without having to go through phpmyadmin but I can not find anything. Best regards, Javier --- Javier Ballester The following user(s) said Thank You: [MrsIE](/forum/user/58568-mrsie "View MrsIE's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2Rpc2NvdW50LWNvdXBvbi84ODkxNDQtaG93LXRvLWFwcGx5LWEtZGlzY291bnQtb24tcHJvZHVjdC12YXJpYW50cz90bXBsPW1hcmtkb3du) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 9 years 7 months ago [\#263895](#263895) 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 apply a discount on product variants?](/forum/46-discount-coupon/889144-how-to-apply-a-discount-on-product-variants#263895 "Hi, Is it not possible to apply a different discount on product variants? Is it not possible to assign a product variant to a category? and on this category a discount. Also, via custom fields it is not possible to work discounts on product variants I'm looking for some solution without having to go through phpmyadmin but I can not find anything. Best regards, Javier")* Hi, 1. There is no option for now to assign a discount to variants, only to main products. 2. Variants are not displayed on products listings, so they are not linked to any category. They are linked to categories through their products. PHPMyadmin won't help you. Even if you set the id of a variant in a discount products field, it won't be used by the system. The only viable solution I see for now is to set the price you want in the variant itself when you edit it under the "variants" tab of the main product. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2Rpc2NvdW50LWNvdXBvbi84ODkxNDQtaG93LXRvLWFwcGx5LWEtZGlzY291bnQtb24tcHJvZHVjdC12YXJpYW50cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jabatec](/forum/user/5180-jabatec "View Jabatec's Profile")** - [![Jabatec's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar5180.png)](/forum/user/5180-jabatec "View Jabatec's Profile") Topic Author - [ Offline](/forum/user/5180-jabatec) Less More - Posts: 90 - Thank you received: 15 - - [](https://jabatec.com) - 9 years 7 months ago - 9 years 7 months ago [\#264015](#264015) by [Jabatec](/forum/user/5180-jabatec "View Jabatec's Profile") Replied by *[Jabatec](/forum/user/5180-jabatec "View Jabatec's Profile")* on topic *[How to apply a discount on product variants?](/forum/46-discount-coupon/889144-how-to-apply-a-discount-on-product-variants#264015 "Hi, Is it not possible to apply a different discount on product variants? Is it not possible to assign a product variant to a category? and on this category a discount. Also, via custom fields it is not possible to work discounts on product variants I'm looking for some solution without having to go through phpmyadmin but I can not find anything. Best regards, Javier")* Hi Nicolas, I think the way is that, work with price in product variant, but I am looking for a solution as if it were a discount. When the retail price exists in a variation of product, this price shown next to the official price, ok, fantastic, but could it be show in Crossed out format and with as a percentage of discount on the official price? Is there any example code to integrate it? I think this would be a good solution on how to show a discount on a product variation Attached example image Thank you Javier --- Javier Ballester - [ ![hikashopretailprice1_2017-03-04.jpg](/forum/attachment/36797) ](/forum/attachment/36797 "...2017-03-04.jpg") [ ](/forum/attachment/36797?download=1 "...2017-03-04.jpg") - [ ![hikashopretailprice2_2017-03-04.jpg](/forum/attachment/36798) ](/forum/attachment/36798 "...2017-03-04.jpg") [ ](/forum/attachment/36798?download=1 "...2017-03-04.jpg") - [ ![hikashopretailprice3_2017-03-04.jpg](/forum/attachment/36799) ](/forum/attachment/36799 "...2017-03-04.jpg") [ ](/forum/attachment/36799?download=1 "...2017-03-04.jpg") - [ ![hikashopretailprice4a.jpg](/forum/attachment/36800) ](/forum/attachment/36800 "...ailprice4a.jpg") [ ](/forum/attachment/36800?download=1 "...ailprice4a.jpg") Last edit: 9 years 7 months ago by [Jabatec](/forum/user/5180-jabatec "View Jabatec's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2Rpc2NvdW50LWNvdXBvbi84ODkxNDQtaG93LXRvLWFwcGx5LWEtZGlzY291bnQtb24tcHJvZHVjdC12YXJpYW50cz90bXBsPW1hcmtkb3du) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 9 years 7 months ago [\#264018](#264018) 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 apply a discount on product variants?](/forum/46-discount-coupon/889144-how-to-apply-a-discount-on-product-variants#264018 "Hi, Is it not possible to apply a different discount on product variants? Is it not possible to assign a product variant to a category? and on this category a discount. Also, via custom fields it is not possible to work discounts on product variants I'm looking for some solution without having to go through phpmyadmin but I can not find anything. Best regards, Javier")* Hi, Well, you can cross the retail price with simple CSS code. For example: .hikashop_product_msrp_price .hikashop_product_price{ decoration: line-through; } You can also use translation overrides to change the text before the prices. And you can use some more CSS to put both prices on the same line. If you want to go further, then you would have to edit the file "listing_price" of the view "product" and change that block of code which handles the display of the retail price: Code: <span class="hikashop_product_msrp_price hikashop_product_price_full"> <span class="hikashop_product_msrp_price_title"><?php echo JText::_('PRODUCT_MSRP_BEFORE'); ?></span> <span class="hikashop_product_price"><?php $mainCurr = $this->currencyHelper->mainCurrency(); $app = JFactory::getApplication(); $currCurrency = $app->getUserState( HIKASHOP_COMPONENT.'.currency_id', $mainCurr ); $msrpCurrencied = $this->currencyHelper->convertUniquePrice($this->row->product_msrp,$mainCurr,$currCurrency); if($msrpCurrencied == $this->row->product_msrp) echo $this->currencyHelper->format($this->row->product_msrp,$mainCurr); else echo $this->currencyHelper->format($msrpCurrencied,$currCurrency).' ('.$this->currencyHelper->format($this->row->product_msrp,$mainCurr).')'; ?></span> </span> Having discounts on variants is something we want in the future. The following user(s) said Thank You: [Jabatec](/forum/user/5180-jabatec "View Jabatec's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2Rpc2NvdW50LWNvdXBvbi84ODkxNDQtaG93LXRvLWFwcGx5LWEtZGlzY291bnQtb24tcHJvZHVjdC12YXJpYW50cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jabatec](/forum/user/5180-jabatec "View Jabatec's Profile")** - [![Jabatec's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar5180.png)](/forum/user/5180-jabatec "View Jabatec's Profile") Topic Author - [ Offline](/forum/user/5180-jabatec) Less More - Posts: 90 - Thank you received: 15 - - [](https://jabatec.com) - 9 years 7 months ago [\#264106](#264106) by [Jabatec](/forum/user/5180-jabatec "View Jabatec's Profile") Replied by *[Jabatec](/forum/user/5180-jabatec "View Jabatec's Profile")* on topic *[How to apply a discount on product variants?](/forum/46-discount-coupon/889144-how-to-apply-a-discount-on-product-variants#264106 "Hi, Is it not possible to apply a different discount on product variants? Is it not possible to assign a product variant to a category? and on this category a discount. Also, via custom fields it is not possible to work discounts on product variants I'm looking for some solution without having to go through phpmyadmin but I can not find anything. Best regards, Javier")* Hi Nicolas, thank you for your reply I am not programmer, (developer) I searched but did not find any example code to calculate the % discount result of the product price on the retail price Can you help me please? Thank you Javier --- Javier Ballester Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2Rpc2NvdW50LWNvdXBvbi84ODkxNDQtaG93LXRvLWFwcGx5LWEtZGlzY291bnQtb24tcHJvZHVjdC12YXJpYW50cz90bXBsPW1hcmtkb3du) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 9 years 7 months ago [\#264109](#264109) 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 apply a discount on product variants?](/forum/46-discount-coupon/889144-how-to-apply-a-discount-on-product-variants#264109 "Hi, Is it not possible to apply a different discount on product variants? Is it not possible to assign a product variant to a category? and on this category a discount. Also, via custom fields it is not possible to work discounts on product variants I'm looking for some solution without having to go through phpmyadmin but I can not find anything. Best regards, Javier")* Hi, This is the retail price: Code: $this->row->product_msrp This is the price of the product: Code: $this->row->prices[0]->price_value_with_tax This is to get the discount percentage: Code: $discount_amount = ($this->row->prices[0]->price_value_with_tax-$this->row->product_msrp)*100/$this->row->prices[0]->price_value_with_tax; This is to get the display it: Code: echo $this->currencyHelper->format($discount_amount,$this->row->prices[0]->price_currency_id); Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2Rpc2NvdW50LWNvdXBvbi84ODkxNDQtaG93LXRvLWFwcGx5LWEtZGlzY291bnQtb24tcHJvZHVjdC12YXJpYW50cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jabatec](/forum/user/5180-jabatec "View Jabatec's Profile")** - [![Jabatec's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar5180.png)](/forum/user/5180-jabatec "View Jabatec's Profile") Topic Author - [ Offline](/forum/user/5180-jabatec) Less More - Posts: 90 - Thank you received: 15 - - [](https://jabatec.com) - 9 years 7 months ago [\#264186](#264186) by [Jabatec](/forum/user/5180-jabatec "View Jabatec's Profile") Replied by *[Jabatec](/forum/user/5180-jabatec "View Jabatec's Profile")* on topic *[How to apply a discount on product variants?](/forum/46-discount-coupon/889144-how-to-apply-a-discount-on-product-variants#264186 "Hi, Is it not possible to apply a different discount on product variants? Is it not possible to assign a product variant to a category? and on this category a discount. Also, via custom fields it is not possible to work discounts on product variants I'm looking for some solution without having to go through phpmyadmin but I can not find anything. Best regards, Javier")* Hi, I have updated the formula to correctly calculate the value of discount, I changed; $discount_amount = ($this->row->prices[0]->price_value_with_tax-$this->row->product_msrp)*100/$this->row->prices[0]->price_value_with_tax; by; $discount_amount = ($this->row->prices[0]-> price_value_with_tax/$this->row->product_msrp )*100-100; But the problem I find is how to round the percentage to 2 decimals and change the "€" symbol by "%" Attached image Code: <span class="hikashop_product_msrp_price hikashop_product_price_full"> <span class="hikashop_product_msrp_price_title"> <?php echo JText::_('PRODUCT_MSRP_BEFORE'); ?> </span> <span class="hikashop_product_price"> <?php $mainCurr = $this->currencyHelper->mainCurrency(); $app = JFactory::getApplication(); $currCurrency = $app->getUserState( HIKASHOP_COMPONENT.'.currency_id', $mainCurr ); $msrpCurrencied = $this->currencyHelper->convertUniquePrice($this->row->product_msrp,$mainCurr,$currCurrency); if($msrpCurrencied == $this->row->product_msrp) echo $this->currencyHelper->format($this->row->product_msrp,$mainCurr); else echo $this->currencyHelper->format($msrpCurrencied,$currCurrency).' ('.$this->currencyHelper->format($this->row->product_msrp,$mainCurr).')'; ?> </span> <span class="hikashop_product_price_percentaje"> <?php $discount_amount = ($this->row->prices[0]-> price_value_with_tax/$this->row->product_msrp )*100-100; if($msrpCurrencied == $this->row->product_msrp) echo $this->currencyHelper->format($discount_amount,$this->row->prices[0]->price_currency_id); else echo $this->currencyHelper->format($msrpCurrencied,$currCurrency).' ('.$this->currencyHelper->format($this->row->product_msrp,$mainCurr).')'; ?> </span> </span> Thank you very much Javier --- Javier Ballester - [ ![hikashopretailprice.jpg](/forum/attachment/36825) ](/forum/attachment/36825 "...etailprice.jpg") [ ](/forum/attachment/36825?download=1 "...etailprice.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2Rpc2NvdW50LWNvdXBvbi84ODkxNDQtaG93LXRvLWFwcGx5LWEtZGlzY291bnQtb24tcHJvZHVjdC12YXJpYW50cz90bXBsPW1hcmtkb3du) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 9 years 7 months ago [\#264188](#264188) 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 apply a discount on product variants?](/forum/46-discount-coupon/889144-how-to-apply-a-discount-on-product-variants#264188 "Hi, Is it not possible to apply a different discount on product variants? Is it not possible to assign a product variant to a category? and on this category a discount. Also, via custom fields it is not possible to work discounts on product variants I'm looking for some solution without having to go through phpmyadmin but I can not find anything. Best regards, Javier")* Ah yes, I made a mistake. The code: Code: echo $this->currencyHelper->format($discount_amount,$this->row->prices[0]->price_currency_id); is to display a price. To display a percentage, it's much more easy: Code: echo round($discount_amount,2). ' %'; Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2Rpc2NvdW50LWNvdXBvbi84ODkxNDQtaG93LXRvLWFwcGx5LWEtZGlzY291bnQtb24tcHJvZHVjdC12YXJpYW50cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[MrsIE](/forum/user/58568-mrsie "View MrsIE's Profile")** - [![MrsIE's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/58568-mrsie "View MrsIE's Profile") - [ Offline](/forum/user/58568-mrsie) Less More - Posts: 20 - Thank you received: 0 - - 7 years 1 month ago - 7 years 1 month ago [\#310956](#310956) by [MrsIE](/forum/user/58568-mrsie "View MrsIE's Profile") Replied by *[MrsIE](/forum/user/58568-mrsie "View MrsIE's Profile")* on topic *[How to apply a discount on product variants?](/forum/46-discount-coupon/889144-how-to-apply-a-discount-on-product-variants#310956 "Hi, Is it not possible to apply a different discount on product variants? Is it not possible to assign a product variant to a category? and on this category a discount. Also, via custom fields it is not possible to work discounts on product variants I'm looking for some solution without having to go through phpmyadmin but I can not find anything. Best regards, Javier")* Hi Nicolas, do you have a development plan to solve this problem? I mean placing the variant of the product in various categories (e.g. discounts, new product or again in stock etc)? Best regards Irene. Last edit: 7 years 1 month ago by [MrsIE](/forum/user/58568-mrsie "View MrsIE's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2Rpc2NvdW50LWNvdXBvbi84ODkxNDQtaG93LXRvLWFwcGx5LWEtZGlzY291bnQtb24tcHJvZHVjdC12YXJpYW50cz90bXBsPW1hcmtkb3du) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 7 years 1 month ago [\#310975](#310975) 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 apply a discount on product variants?](/forum/46-discount-coupon/889144-how-to-apply-a-discount-on-product-variants#310975 "Hi, Is it not possible to apply a different discount on product variants? Is it not possible to assign a product variant to a category? and on this category a discount. Also, via custom fields it is not possible to work discounts on product variants I'm looking for some solution without having to go through phpmyadmin but I can not find anything. Best regards, Javier")* Hi, We don't plan on changing this any time soon. Variants were never meant to be linked to categories. Changing that would require a lot of work and testing as there are many many things coded so that the system automatically use the categories of the main product when filtering of categories (for custom fields, for reports, statistics, mass actions, badges, discounts, etc). Now, if you could tell us what you're trying to do, maybe we could provide an alternative solution ? Note also that the possibility to select variants for discounts has been added since the creation of this thread ( and this was the main point of this thread ). The following user(s) said Thank You: [MrsIE](/forum/user/58568-mrsie "View MrsIE's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2Rpc2NvdW50LWNvdXBvbi84ODkxNDQtaG93LXRvLWFwcGx5LWEtZGlzY291bnQtb24tcHJvZHVjdC12YXJpYW50cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[MrsIE](/forum/user/58568-mrsie "View MrsIE's Profile")** - [![MrsIE's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/58568-mrsie "View MrsIE's Profile") - [ Offline](/forum/user/58568-mrsie) Less More - Posts: 20 - Thank you received: 0 - - 7 years 1 month ago [\#311014](#311014) by [MrsIE](/forum/user/58568-mrsie "View MrsIE's Profile") Replied by *[MrsIE](/forum/user/58568-mrsie "View MrsIE's Profile")* on topic *[How to apply a discount on product variants?](/forum/46-discount-coupon/889144-how-to-apply-a-discount-on-product-variants#311014 "Hi, Is it not possible to apply a different discount on product variants? Is it not possible to assign a product variant to a category? and on this category a discount. Also, via custom fields it is not possible to work discounts on product variants I'm looking for some solution without having to go through phpmyadmin but I can not find anything. Best regards, Javier")* Hi Nicolas, thank you for reply. Sure I'll try this way a bit later. I just wanted to know: should i puzzle or just wait a bit )) Sometimes I need to display in the listing some variants separately from their main products (eg in categories "Action", "New product" or "Again in stock" etc). This is not urgent, and I'll return to this item later. Best regards Irene. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2Rpc2NvdW50LWNvdXBvbi84ODkxNDQtaG93LXRvLWFwcGx5LWEtZGlzY291bnQtb24tcHJvZHVjdC12YXJpYW50cz90bXBsPW1hcmtkb3du) 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.332 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)