Plug in Stopped Working

I suspect your issue is the same one I’ve had, though I just installed the plugin today.

I have ~8000 orders in my store, and the query in wevop_get_orders() uses around 800MB to complete, so hits the PHP limit for memory usage.

But, there is a solution, to modify the first query, I can reduce the memory usage of the function to 30MB… 🙂

The “my_query” result only uses the post->ids, so doesn’t need the whole post data returned, so you need to use the ‘fields’ parameter to WP_Query.

Here is the new code:

        function wevop_get_orders() {                                                                                                                                                                           
            global $woocommerce, $product;                                                                                                                                                                      
            $args = array(                                                                                                                                                                                      
                'post_type'     => 'shop_order',                                                                                                                                                                
                'post_status'   => array_keys( wc_get_order_statuses() ),                                                                                                                                       
                'posts_per_page'=> '-1',                                                                                                                                                                        
                'date_query'    => array(                                                                                                                                                                       
                    array(                                                                                                                                                                                      
                        'after'     => $this->product_filter_date_from,                                                                                                                                         
                        'before'    => $this->product_filter_date_to,                                                                                                                                           
                        'inclusive' => true,                                                                                                                                                                    
                    )                                                                                                                                                                                           
                                         ),                                                                                                                                                                     
                'fields' => 'ids'                                                                                                                                                                               
            );                                                                                                                                                                                                  
                                                                                                                                                                                                                
            $my_query = new WP_Query( $args );                                                                                                                                                                  
            $order_pro_arr = array();                                                                                                                                                                           
            foreach($my_query->posts as $order_id){                                                                                                                                                             
                $order      = new WC_Order( $order_id );                                                                                                                                                        
                $items      = $order->get_items();                                                                                                                                                              
                foreach ( $items as $ordered_item_id => $item ) {                                                                                                                                               

The main change is the ‘fields’ => ‘ids’, and then the while changes to a foreach because my_query is no longer a set of posts with the have_posts() stuff, but just a plainer query with the posts parameter being a list of order ids.

I’m not sure if the plugin is going to do what my customer wants, but at least it runs now, and you’ll probably want to use my code to make it work quicker for everyone.