[Skip to main content](#vessel-content) # Coupan report Excel file not proper ## - **[Harrier](/forum/user/59673-harrier "View Harrier's Profile")** - [![Harrier's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/59673-harrier "View Harrier's Profile") Topic Author - [ Offline](/forum/user/59673-harrier) Less More - Posts: 44 - Thank you received: 0 - - 6 years 4 months ago [\#321159](#321159) by [Harrier](/forum/user/59673-harrier "View Harrier's Profile") *[Coupan report Excel file not proper](/forum/46-discount-coupon/900250-coupan-report-excel-file-not-proper#321159 "Hi I have created a Report to see the utilization of the coupon codes we have generated and used by the customers while purchasing the products. I have exported the Excel file but the information in it is not in proper format. File attached for your review. We need to generate the Excel report by showing following columns: Date Coupan code utilized(Code) Order no Value of code(discount given) Coupan applied on Product(name) Please help with this. Thanks.")* was created by *[Harrier](/forum/user/59673-harrier "View Harrier's Profile")* Hi I have created a Report to see the utilization of the coupon codes we have generated and used by the customers while purchasing the products. I have exported the Excel file but the information in it is not in proper format. File attached for your review. We need to generate the Excel report by showing following columns: Date Coupan code utilized(Code) Order no Value of code(discount given) Coupan applied on Product(name) Please help with this. Thanks. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi85MDAyNTAtY291cGFuLXJlcG9ydC1leGNlbC1maWxlLW5vdC1wcm9wZXI/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: 86556 - Thank you received: 14304 - - 6 years 4 months ago [\#321160](#321160) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Coupan report Excel file not proper](/forum/46-discount-coupon/900250-coupan-report-excel-file-not-proper#321160 "Hi I have created a Report to see the utilization of the coupon codes we have generated and used by the customers while purchasing the products. I have exported the Excel file but the information in it is not in proper format. File attached for your review. We need to generate the Excel report by showing following columns: Date Coupan code utilized(Code) Order no Value of code(discount given) Coupan applied on Product(name) Please help with this. Thanks.")* Hi, Besides the "coupan applied on product(name)" column, the rest is possible by creating a mass action of the type "order" via the menu System>Mass actions with an action "export CSV file" with the columns order_created order_discount_code order_number and order_discount_price Having the product name on which the coupon was based (supposing that you only have one product with a coupon in each order) would require some custom coding by a developer. Best regards, Nicolas Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ2LWRpc2NvdW50LWNvdXBvbi85MDAyNTAtY291cGFuLXJlcG9ydC1leGNlbC1maWxlLW5vdC1wcm9wZXI/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.051 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)