php - wc_get_orders isn't getting all of the db records

I'm having an issue, I think it might be site/server related than code related as the db for this site is massive and this code worked perfectly before and i've never changed it. But what I am doing is grabbing all of the orders from a woocommerce store that have an "affiliate" associated with it. I do that with this code:

$order = wc_get_orders( array( 
        'status'=> 'wc-completed',
        'meta_key'  => '_coupon_codes_CCAFF_Aff_Affiliate_ID',
        )
    );
Copy code

I then have a user form where the user enters a start date and end date and some other info for their query. (I can add the code in here for that if needed but trying to keep it short)

I then run a foreach loop though the orders where I echo out a table with all the entries.

foreach ($order as $ordercommout) {
    $orderID = $ordercommout->ID;
    $orderDateComp = strtotime($ordercommout->get_date_completed());
   // echo $orderDateComp;
    if($starttimeSTR < $orderDateComp && $endtimeSTR > $orderDateComp){
    $affID = get_post_meta($orderID, "_coupon_codes_CCAFF_Aff_Affiliate_ID");
    $affInfo = get_userdata($affID[0]);
    $affName = $affInfo->user_login;  
    $order_subtotal = $ordercommout->total - $ordercommout->shipping_total - $ordercommout->total_tax;
    $affcompctind = get_user_meta($affID[0], '_CCAFF_vendor_comm_pct');
    $commissionamt = $order_subtotal*$affcompctind[0]*0.01;
    $commpaidstatus1 = get_post_meta($orderID, "_coupon_codes_CCAFF_Comm_Status");
    
    
        echo "<tr>";
        echo "<td>" . esc_html($affName) . "</td>";
        echo "<td>" . esc_html($orderID) . "</td>";
        echo "<td>" . wc_price($commissionamt) . "</td>";
        echo "<td>" . esc_html(date('m/d/Y', $orderDateComp)) . "</td>";
        echo "<td>" . esc_html($commpaidstatus1[0]) . "</td>";
        echo '<td><form class="ccformaff" method="post" action="" onsubmit="return confirm(' . "'" . 'Do you really want to delete Entry?' . "'" . ');">
        
        <input type="hidden" id="delstart" name="delstart" value="' . esc_html($testdatestart) . '">
        <input type="hidden" id="delend" name="delend" value="' . esc_html($testdateend) . '">
        <input type="hidden" id="delcommtype" name="delcommtype" value="' . esc_html($testcommtype) . '">
        <input type="hidden" id="delcommstatus" name="delcommstatus" value="' . esc_html($testcommstatus) . '">
        
        
        <button type="submit" class="button button-primary" name="deleteItemCOMM" value="' . esc_html($orderID) . '"/>Delete</button></form></td>';
        echo "</tr>";
        
    }  
} 
Copy code

So the thing is this code works. My issue is I'm not getting any orders before early September, I can run it multiple times and sometimes I get data to September 12th. If I run it again I might get up to September 8th, etc. It seems like my query is timing out but I'm not waiting long at all for it to run, the output is almost instant. Is there a way to fix this?

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.