{"flag":true,"single":true,"pageTitle":"Wordpress Get Orders List in single file using woocommerce","post":{"id":238,"user_id":"1","slug":"wordpress-get-orders-list-in-single-file-using-woocommerce-2hda","title":"Wordpress Get Orders List in single file using woocommerce","body":"
<?php\r\n\r\nrequire_once('wp-load.php');\r\n\r\n\r\n\/\/ Check if WooCommerce is active\r\nif ( class_exists( 'WooCommerce' ) ) {\r\n    \/\/ Get selected status from the dropdown\r\n    $status = isset( $_GET['status'] ) ? sanitize_text_field( $_GET['status'] ) : '';\r\n\r\n    \/\/ Fetch orders based on the selected status\r\n    $args = array(\r\n        'post_type'   => 'shop_order',\r\n        'post_status' => $status,\r\n        'posts_per_page' => -1,\r\n    );\r\n    $orders_query = new WP_Query( $args );\r\n\r\n    \/\/ Display page header\r\n    echo '<h1>Orders<\/h1>';\r\n\r\n    \/\/ Display filter dropdown\r\n    echo '<form method=\"get\">';\r\n    echo '<label for=\"status\">Filter by status:<\/label>';\r\n    echo '<select id=\"status\" name=\"status\">';\r\n    echo '<option value=\"\">All<\/option>';\r\n    echo '<option value=\"wc-processing\" ' . selected( $status, 'wc-processing', false ) . '>Processing<\/option>';\r\n    echo '<option value=\"wc-completed\" ' . selected( $status, 'wc-completed', false ) . '>Completed<\/option>';\r\n    echo '<option value=\"wc-cancelled\" ' . selected( $status, 'wc-cancelled', false ) . '>Cancelled<\/option>';\r\n    echo '<option value=\"wc-pending\" ' . selected( $status, 'wc-pending', false ) . '>Pending Payment<\/option>';\r\n    echo '<option value=\"wc-refunded\" ' . selected( $status, 'wc-refunded', false ) . '>Refunded<\/option>';\r\n    echo '<\/select>';\r\n    echo '<input type=\"submit\" value=\"Filter\">';\r\n    echo '<\/form>';\r\n    $unique_emails = array();\r\n    \/\/ Display orders table\r\n    if ( $orders_query->have_posts() ) {\r\n       \r\n\r\n        while ( $orders_query->have_posts() ) {\r\n            $orders_query->the_post();\r\n            $order = wc_get_order( get_the_ID() );\r\n            \/\/echo '<td>' . $order->get_order_number() . '<\/td>';\r\n            $name =  $order->get_billing_first_name() . ' ' . $order->get_billing_last_name();\r\n            $emailis = $order->get_billing_email();\r\n            $unique_emails[$emailis] = $name;\r\n\r\n            \/\/echo '<td>' . $order->get_date_created()->date( 'Y-m-d H:i:s' ) . '<\/td>';\r\n            \/\/echo '<td>' . wc_get_order_status_name( $order->get_status() ) . '<\/td>';\r\n            \/\/echo '<td>' . $order->get_total() . '<\/td>';\r\n        }\r\n\r\n        \/\/ Reset post data\r\n        wp_reset_postdata();\r\n    } else {\r\n        echo 'No orders found.';\r\n    }\r\n} else {\r\n    echo 'WooCommerce is not active.';\r\n}\r\nforeach ($unique_emails as $email => $name) {\r\n    echo $name.\",\".$email.\"<br\/>\";\r\n}\r\n\r\ndie;\r\n\r\n?><\/code><\/pre>\r\n
 <\/p>","category_id":"29","is_private":"0","created_at":"2024-02-21T23:59:36.000000Z","updated_at":"2025-02-22T02:12:46.000000Z","category":{"id":29,"user_id":"1","name":"Wordpress","slug":"wordpress-uzoa","parent_id":"1","created_at":"2023-11-10T02:49:29.000000Z","updated_at":"2023-11-10T02:49:29.000000Z"},"user":{"id":1,"name":"R GONDAL","email":"rizikmw@gmail.com","email_verified_at":null,"two_factor_confirmed_at":null,"current_team_id":"1","profile_photo_path":null,"created_at":"2023-03-12T10:49:33.000000Z","updated_at":"2025-01-10T12:59:00.000000Z","profile_photo_url":"https:\/\/ui-avatars.com\/api\/?name=R+G&color=7F9CF5&background=EBF4FF"}},"pageDesc":"<?php  require_once('wp-load.php');   \/\/ Check if WooCommerce is active if ( class_exists( 'WooCommerce' ) ) {     \/\/ Get selected status - Wordpress Get Orders List in single file using woocommerce (Updated: February 22, 2025) - Read more about Wordpress Get Orders List in single file using woocommerce at my programming site [SITE]","categories":[]}