php - WooCommerce Access orders that had discounts

Question

I would like to List all orders that contain products that had discounts on them, so I can generate a report based on only the orders that have discounts on them and get the [ order number, order date, order status, order total, user name, email and phone ]

of every order that have product with discount

something like

if (order_had_product_with_discount) {
    get the [ order number, order date, order status, order total, user name, email and phone ] of this order
}  

It's not valid code but I need to know where to start.

Answer 1

You will use the WC_Order method get_used_coupons() on the $order variable (the WC_Order Object) like:

if ( sizeof($order->get_used_coupons()) > 0 ) {
    // Your code goes here
}

Now to get the order number, the order date, the order status, the order total, the user name, the email and phone, you will find everything on the following threads:

• How to get WooCommerce order details
• Get Order items and WC_Order_Item_Product in Woocommerce 3

---

Note: You can get the WC_Order object from $order_id variable (order ID) with:

$order = wc_get_order( $order_id );