Question
Answer and Explanation
To retrieve completed WooCommerce orders for the current year, you can use several methods. Here’s a breakdown of the most effective approaches, catering to different technical skill levels:
1. Using the WooCommerce Admin Panel (GUI)
- The simplest method for non-developers is to use the WooCommerce admin interface:
- Go to WooCommerce > Orders in your WordPress dashboard.
- Use the built-in filters to select “Completed” as the order status.
- Apply date filters to specify the current year. The default date options may cover specific time periods, or you can use custom date ranges to specify January 1st to December 31st.
- You can then export the results as CSV for further analysis, if needed.
- Please Note: This is perfect for quick lookups but lacks the automation capabilities of the other methods.
2. Using WP-CLI (Command Line Interface)
- If you are comfortable with command-line tools, WP-CLI is efficient for querying orders.
- You'll need WP-CLI installed on your server. Use this command:
wp wc order list --status=completed --date_min=$(date +%Y-01-01) --date_max=$(date +%Y-12-31) --fields=id,order_number,date_created,total
- This command fetches a list of completed orders for the current year and outputs relevant information (id, order_number, creation date, and total cost) which you can customize further.
3. Programmatic Approach (PHP)
- For developers or those who want to integrate order retrieval into custom code, you can use WordPress's WP_Query class and WooCommerce functions directly.
- Here's a basic PHP snippet you can adapt, add this to your themes functions.php or custom plugin:
<?php
function get_completed_orders_this_year() {
$start_of_year = date('Y-01-01 00:00:00');
$end_of_year = date('Y-12-31 23:59:59');
$args = array(
'post_type' => 'shop_order',
'post_status' => 'wc-completed',
'date_query' => array(
array(
'after' => $start_of_year,
'before' => $end_of_year,
'inclusive' => true,
),
),
'posts_per_page' => -1,
);
$orders = new WP_Query($args);
if ($orders->have_posts()) {
while ($orders->have_posts()) {
$orders->the_post();
$order = wc_get_order(get_the_ID());
echo 'Order ID: ' . $order->get_id() . ' Total: ' . $order->get_total() . '<br>';
}
wp_reset_postdata();
} else {
echo 'No completed orders found for this year.';
}
}
get_completed_orders_this_year();
?>
- This code will output the Order ID and Total of all completed orders this year, you can modify the output as needed.
Choose the method that best suits your technical skills and your requirements. The admin panel is sufficient for simple tasks, while WP-CLI and PHP provide more flexibility and automation options.