Get orders total purchases amount for the day in Woocommerce

by

The best and effective way to get that is to use the following very light SQL query, that will get the sum of all order totals in the last 24 hours for “processing” and “completed” orders statuses:

function get_daily_purchases_total(){
    global $wpdb;

    return $wpdb->get_var( "
        SELECT SUM(pm.meta_value)
        FROM {$wpdb->prefix}posts as p
        INNER JOIN {$wpdb->prefix}postmeta as pm ON p.ID = pm.post_id
        WHERE p.post_type="shop_order"
        AND p.post_status IN ('wc-processing','wc-completed')
        AND UNIX_TIMESTAMP(p.post_date) >= (UNIX_TIMESTAMP(NOW()) - (86400))
        AND pm.meta_key = '_order_total'
    " );
}

Code goes in function.php file of your active child theme (or active theme). Tested and works.

USAGE Example – Display the daily total purchased formatted amount:

<?php echo '<p>Total purchased of the day: ' . strip_tags( wc_price(get_daily_purchases_total() ) ) . '</p>'; ?>

If you want to get instead the total based on the “today” date, you will replace in the code this line:

AND UNIX_TIMESTAMP(p.post_date) >= (UNIX_TIMESTAMP(NOW()) - (86400))

by this line:

AND DATE(p.post_date) >= CURDATE()

More Related Contents:

  1. How to get WooCommerce order details
  2. Get Order items and WC_Order_Item_Product in WooCommerce 3
  3. WooCommerce: Auto complete paid orders
  4. Checking if customer has already bought something in WooCommerce
  5. Woocommerce: Which hook to replace deprecated “woocommerce_add_order_item_meta”
  6. Check if a user/guest has purchased specific products in WooCommerce
  7. Add extra meta for orders in Woocommerce
  8. Add columns to admin orders list in WooCommerce
  9. WooCommerce : Add custom Metabox to admin order page
  10. Change COD default order status to “On Hold” instead of “Processing” in Woocommerce
  11. Create an order programmatically with line items in Woocommerce 3+
  12. Get coupon data from WooCommerce orders
  13. Get all Orders IDs from a product ID in Woocommerce
  14. Send an Email notification to the admin for pending order status in WooCommerce
  15. Change sender name and email address for specific WooCommerce email notifications
  16. Custom order status background button color in Woocommerce 3.3 admin order list
  17. Get refunded orders and refunded order items details in Woocommerce 3
  18. Add a custom column with meta data to My Account Orders table in Woocommerce 3+
  19. Get the metadata of an order item in woocommerce 3
  20. Accessing Order Items protected data in Woocommerce 3
  21. Add a fee to an order programmatically in Woocommerce 3
  22. Replace woocommerce_add_order_item_meta hook in Woocommerce 3.4
  23. Replace the Variable Price range by the chosen variation price in WooCommerce 3
  24. Change product prices via a hook in WooCommerce 3+
  25. Apply a coupon programmatically in Woocommerce
  26. WooCommerce – get category for product page
  27. WooCommerce – Hide other shipping methods when FREE SHIPPING is available
  28. Get orders shipping items details in WooCommerce 3
  29. Ajaxify header cart items count in Woocommerce
  30. Add a quantity field to Ajax add to cart button on WooCommerce shop page

Leave a Comment