[Skip to main content](#vessel-content) # how to create report with total discount prices? ## - **[sadaf3d](/forum/user/46256-sadaf3d "View sadaf3d's Profile")** - [![sadaf3d's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/46256-sadaf3d "View sadaf3d's Profile") Topic Author - [ Offline](/forum/user/46256-sadaf3d) Less More - Posts: 221 - Thank you received: 8 - 4 years 9 months ago [\#338761](#338761) by [sadaf3d](/forum/user/46256-sadaf3d "View sadaf3d's Profile") *[how to create report with total discount prices?](/forum/36-reports-statistics/903844-how-to-create-report-with-total-discount-prices#338761 "hi i want create a report with total prices that get to all users via each Copoun or Discount.(i can create a report with number of discount uses by users but i need sum of price for each discount code) is it possible with report system? i can use query in PHPmyAdmin but i want to implement in joomla back-end. if you want say not possible please advise me to how to write php code to do it. is it need create massaction ar need write a custom plugin. thank you (tip: i can not set avatar for my profile. every time i upload my avatar in kunena profile it is not any action after upload)")* was created by *[sadaf3d](/forum/user/46256-sadaf3d "View sadaf3d's Profile")* hi i want create a report with total prices that get to all users via each Copoun or Discount.(i can create a report with number of discount uses by users but i need sum of price for each discount code) is it possible with report system? i can use query in PHPmyAdmin but i want to implement in joomla back-end. if you want say not possible please advise me to how to write php code to do it. is it need create massaction ar need write a custom plugin. thank you (tip: i can not set avatar for my profile. every time i upload my avatar in kunena profile it is not any action after upload) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDM4NDQtaG93LXRvLWNyZWF0ZS1yZXBvcnQtd2l0aC10b3RhbC1kaXNjb3VudC1wcmljZXM/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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 4 years 9 months ago [\#338763](#338763) 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 create report with total discount prices?](/forum/36-reports-statistics/903844-how-to-create-report-with-total-discount-prices#338763 "hi i want create a report with total prices that get to all users via each Copoun or Discount.(i can create a report with number of discount uses by users but i need sum of price for each discount code) is it possible with report system? i can use query in PHPmyAdmin but i want to implement in joomla back-end. if you want say not possible please advise me to how to write php code to do it. is it need create massaction ar need write a custom plugin. thank you (tip: i can not set avatar for my profile. every time i upload my avatar in kunena profile it is not any action after upload)")* Hi, I don't see a way to do these in the backend. A custom plugin would be needed. If you can write the MySQL query to get the data in PHPMyAdmin, then it's just a matter of implementing a plugin similar to the email history plugin, which adds the menu Customers>Emails history to HikaShop's backend, but instead of displaying a listing of the entries in the email_log table which it fills automatically when an email is sent, it would run your MySQL query to get the data, and then in the view file, you would just have to display the data in an HTML table. You can check the code of the email history plugin in the folder plugins/hikashop/email_history on your website. The following user(s) said Thank You: [sadaf3d](/forum/user/46256-sadaf3d "View sadaf3d's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDM4NDQtaG93LXRvLWNyZWF0ZS1yZXBvcnQtd2l0aC10b3RhbC1kaXNjb3VudC1wcmljZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[sadaf3d](/forum/user/46256-sadaf3d "View sadaf3d's Profile")** - [![sadaf3d's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/46256-sadaf3d "View sadaf3d's Profile") Topic Author - [ Offline](/forum/user/46256-sadaf3d) Less More - Posts: 221 - Thank you received: 8 - 4 years 9 months ago - 4 years 9 months ago [\#338900](#338900) by [sadaf3d](/forum/user/46256-sadaf3d "View sadaf3d's Profile") Replied by *[sadaf3d](/forum/user/46256-sadaf3d "View sadaf3d's Profile")* on topic *[how to create report with total discount prices?](/forum/36-reports-statistics/903844-how-to-create-report-with-total-discount-prices#338900 "hi i want create a report with total prices that get to all users via each Copoun or Discount.(i can create a report with number of discount uses by users but i need sum of price for each discount code) is it possible with report system? i can use query in PHPmyAdmin but i want to implement in joomla back-end. if you want say not possible please advise me to how to write php code to do it. is it need create massaction ar need write a custom plugin. thank you (tip: i can not set avatar for my profile. every time i upload my avatar in kunena profile it is not any action after upload)")* thank you nicolas how can i see what query generated by your report system? (because my query result is different with report result and i want understand am i in right way or not) Last edit: 4 years 9 months ago by [sadaf3d](/forum/user/46256-sadaf3d "View sadaf3d's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDM4NDQtaG93LXRvLWNyZWF0ZS1yZXBvcnQtd2l0aC10b3RhbC1kaXNjb3VudC1wcmljZXM/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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 4 years 9 months ago [\#338915](#338915) 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 create report with total discount prices?](/forum/36-reports-statistics/903844-how-to-create-report-with-total-discount-prices#338915 "hi i want create a report with total prices that get to all users via each Copoun or Discount.(i can create a report with number of discount uses by users but i need sum of price for each discount code) is it possible with report system? i can use query in PHPmyAdmin but i want to implement in joomla back-end. if you want say not possible please advise me to how to write php code to do it. is it need create massaction ar need write a custom plugin. thank you (tip: i can not set avatar for my profile. every time i upload my avatar in kunena profile it is not any action after upload)")* Hi, If you activate the "debug system" setting in the Joomla configuration, you'll see all the MySQL queries run on the current page on each page of your backend and frontend. Just unfold the MySQL queries area and look for hikashop_order when you're looking at the page where the report is displayed and you'll get the MySQL query the report uses. The following user(s) said Thank You: [sadaf3d](/forum/user/46256-sadaf3d "View sadaf3d's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDM4NDQtaG93LXRvLWNyZWF0ZS1yZXBvcnQtd2l0aC10b3RhbC1kaXNjb3VudC1wcmljZXM/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.092 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)