[Skip to main content](#vessel-content) # Orders listing which was created with using coupon ## - **[arnask](/forum/user/6752-arnask "View arnask's Profile")** - [![arnask's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6752-arnask "View arnask's Profile") Topic Author - [ Offline](/forum/user/6752-arnask) Less More - Posts: 198 - Thank you received: 4 - - 13 years 1 month ago [\#126054](#126054) by [arnask](/forum/user/6752-arnask "View arnask's Profile") *[Orders listing which was created with using coupon](/forum/36-reports-statistics/862497-orders-listing-which-was-created-with-using-coupon#126054 "How to list all orders which was created using coupons? i need these columns: Order number, Name, surname, Coupon code, Order status, Total, username, email, Coupon discount percentage.")* was created by *[arnask](/forum/user/6752-arnask "View arnask's Profile")* How to list all orders which was created using coupons? i need these columns: Order number, Name, surname, Coupon code, Order status, Total, username, email, Coupon discount percentage. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjI0OTctb3JkZXJzLWxpc3Rpbmctd2hpY2gtd2FzLWNyZWF0ZWQtd2l0aC11c2luZy1jb3Vwb24/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 13 years 1 month ago [\#126066](#126066) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Orders listing which was created with using coupon](/forum/36-reports-statistics/862497-orders-listing-which-was-created-with-using-coupon#126066 "How to list all orders which was created using coupons? i need these columns: Order number, Name, surname, Coupon code, Order status, Total, username, email, Coupon discount percentage.")* You can create a mass action via the menu System>Mass actions for that. Set it to the data "order", add a filter on the order_discount_code equal to your coupon code, and finally add an action Display the results with the fields you want to display and voilà. Note however that the percentage is not available. Only the effective amount is. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjI0OTctb3JkZXJzLWxpc3Rpbmctd2hpY2gtd2FzLWNyZWF0ZWQtd2l0aC11c2luZy1jb3Vwb24/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[arnask](/forum/user/6752-arnask "View arnask's Profile")** - [![arnask's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6752-arnask "View arnask's Profile") Topic Author - [ Offline](/forum/user/6752-arnask) Less More - Posts: 198 - Thank you received: 4 - - 13 years 1 month ago [\#126127](#126127) by [arnask](/forum/user/6752-arnask "View arnask's Profile") Replied by *[arnask](/forum/user/6752-arnask "View arnask's Profile")* on topic *[Orders listing which was created with using coupon](/forum/36-reports-statistics/862497-orders-listing-which-was-created-with-using-coupon#126127 "How to list all orders which was created using coupons? i need these columns: Order number, Name, surname, Coupon code, Order status, Total, username, email, Coupon discount percentage.")* but it will show only one coupon code, what if i need to view all coupons. I need to view all orders which was created using any of coupons. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjI0OTctb3JkZXJzLWxpc3Rpbmctd2hpY2gtd2FzLWNyZWF0ZWQtd2l0aC11c2luZy1jb3Vwb24/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 13 years 1 month ago [\#126131](#126131) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Orders listing which was created with using coupon](/forum/36-reports-statistics/862497-orders-listing-which-was-created-with-using-coupon#126131 "How to list all orders which was created using coupons? i need these columns: Order number, Name, surname, Coupon code, Order status, Total, username, email, Coupon discount percentage.")* Then in your mass action, you set the filter on the order_discount_code being different than 0 and it will give you all the orders with a coupon code, regardless of the coupon code used. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjI0OTctb3JkZXJzLWxpc3Rpbmctd2hpY2gtd2FzLWNyZWF0ZWQtd2l0aC11c2luZy1jb3Vwb24/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.042 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)