Reputation: 715
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.
Upvotes: 1
Views: 413
Reputation: 253814
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:
Note: You can get the WC_Order object from $order_id
variable (order ID) with:
$order = wc_get_order( $order_id );
Upvotes: 2