[Skip to main content](#vessel-content) # Discount amount in the PDF Invoice Plugin ## - **[idh-webdesign](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile")** - [![idh-webdesign's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33345.jpg)](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile") Topic Author - [ Offline](/forum/user/33345-idh-webdesign) Less More - Posts: 8 - Thank you received: 0 - - - - 12 years 2 months ago [\#166561](#166561) by [idh-webdesign](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile") *[Discount amount in the PDF Invoice Plugin](/forum/35-orders-management/870205-discount-amount-in-the-pdf-invoice-plugin#166561 "-- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.1 Hi all, I am searching the forum for little help. I want to print the % amount of a discount product in my invoice. But i saw that the discount is not in the database (jos_hikashop_order->order_discount_code) and is just calculated in hikashop frontend. Is it possible to get it there with the code like the coupons? Or do you have another idea how this whould work for me? Additional some Screenshots. (The ammount of "30%" is now just hardcoded) THX")* was created by *[idh-webdesign](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile")* -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.1 Hi all, I am searching the forum for little help. I want to print the % amount of a discount product in my invoice. But i saw that the discount is not in the database (jos_hikashop_order->order_discount_code) and is just calculated in hikashop frontend. Is it possible to get it there with the code like the coupons? Or do you have another idea how this whould work for me? Additional some Screenshots. (The ammount of "30%" is now just hardcoded) THX - [ ![Bildschirmfoto_2014-08-06_um_10_39_25.jpg](/forum/attachment/18865) ](/forum/attachment/18865 "...m_10_39_25.jpg") [ ](/forum/attachment/18865?download=1 "...m_10_39_25.jpg") - [ ![Bildschirmfoto_2014-08-06_um_10_39_58.jpg](/forum/attachment/18866) ](/forum/attachment/18866 "...m_10_39_58.jpg") [ ](/forum/attachment/18866?download=1 "...m_10_39_58.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3MDIwNS1kaXNjb3VudC1hbW91bnQtaW4tdGhlLXBkZi1pbnZvaWNlLXBsdWdpbj90bXBsPW1hcmtkb3du) 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: 86290 - Thank you received: 14268 - - 12 years 2 months ago [\#166575](#166575) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Discount amount in the PDF Invoice Plugin](/forum/35-orders-management/870205-discount-amount-in-the-pdf-invoice-plugin#166575 "-- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.1 Hi all, I am searching the forum for little help. I want to print the % amount of a discount product in my invoice. But i saw that the discount is not in the database (jos_hikashop_order->order_discount_code) and is just calculated in hikashop frontend. Is it possible to get it there with the code like the coupons? Or do you have another idea how this whould work for me? Additional some Screenshots. (The ammount of "30%" is now just hardcoded) THX")* Hi, It's quite complex to do if you're not a developer. You first need to load the discount of the product from the jos_hikashop_discount table based on the categories of the products of the order (so it's not a simple query as it will require a few left joins) and then you can display it. That code can be added in the file "invoice" of the view "order" via the menu Display>Views. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3MDIwNS1kaXNjb3VudC1hbW91bnQtaW4tdGhlLXBkZi1pbnZvaWNlLXBsdWdpbj90bXBsPW1hcmtkb3du) 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.130 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)