Coupan report Excel file not proper

  • Posts: 44
  • Thank you received: 0
3 years 9 months ago #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.

Please Log in or Create an account to join the conversation.

  • Posts: 81504
  • Thank you received: 13064
  • MODERATOR
3 years 9 months ago #321160

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 or Create an account to join the conversation.

Time to create page: 0.054 seconds
Powered by Kunena Forum