Orders get overwritten

Hello @dragoscristache,

Thank you for reaching out!

The version you’re using is outdated at this point, please try updating to version 7.9.0 per the steps in this guide.

Could you also attach a copy of your site’s System Status report? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support” (after you scroll down a bit)”. Once done, please paste it here in your reply or via a text-sharing service like https://gist.github.com/.

Look forward to hearing back from you.

Hello @babylon1999,

I managed to find out the culprit for my issue. I was using the function below to store some additional info that we need for accounting reasons. After a bit of digging around I found that the item->save() part was causing a lot of issues under high traffic.

add_action('woocommerce_checkout_create_order', 'save_regular_price_in_order', 10, 2 );
function save_regular_price_in_order( $order, $data ) {
    foreach( $order->get_items() as $item_id => $item ){
        $product = $item->get_product();
        $regular_price = $product->get_regular_price();
        $sale_price = $product->get_sale_price();
        $item->update_meta_data( '_regular_price', $regular_price );
        $item->update_meta_data( '_sale_price', $sale_price );
        $item->save();
    }
}

I managed to fix it by saving once at order level instead of every line item – like this.

add_action('woocommerce_checkout_create_order', 'save_regular_price_in_order', 10, 2 );
function save_regular_price_in_order( $order, $data ) {
    foreach( $order->get_items() as $item_id => $item ){
        $product = $item->get_product();
        $regular_price = $product->get_regular_price();
        $sale_price = $product->get_sale_price();
        $item->update_meta_data( '_regular_price', $regular_price );
        $item->update_meta_data( '_sale_price', $sale_price );
        // $item->save();
    }

    $order->save();
}

I hope this helps anyone that encounters this issue in the future. I found some extra information on Github, in issues 17660 and 25623.

I managed to fix it by saving once at order level instead of every line item – like this.

Nice work! :?)

I’ll be marking the thread as solved, feel free to create a new one if you have any other questions.

Cheers!