Orders listing which was created with using coupon

  • Posts: 174
  • Thank you received: 2
  • Hikashop Business
11 years 1 month ago #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.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
11 years 1 month ago #126066

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

  • Posts: 174
  • Thank you received: 2
  • Hikashop Business
11 years 1 month ago #126127

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
11 years 1 month ago #126131

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

Time to create page: 0.056 seconds
Powered by Kunena Forum