Order sequence is not proper

Hi Robin,

Thanks for the prompt reply!

We can’t add plugin because the plugin files will affect the website speed. So, I have added the following code:

// Add sequential order number
add_filter( ‘woocommerce_order_number’, ‘prefix_add_sequential_order_number’, 1, 2 );
function prefix_add_sequential_order_number( $order_id, $order ) {
global $wpdb;

// Check if order number already exists
$existing_order_number = $wpdb->get_var( $wpdb->prepare( "
    SELECT meta_value 
    FROM {$wpdb->prefix}postmeta 
    WHERE meta_key = '_order_number' 
    AND meta_value > 0
    ORDER BY meta_value DESC
    LIMIT 1
" ) );

$sequential_order_number = $existing_order_number ? $existing_order_number + 1 : 1;

return apply_filters( 'woocommerce_order_number', $sequential_order_number, $order );

}

// Display sequential order number in admin order list
add_filter( ‘manage_edit-shop_order_columns’, ‘prefix_add_sequential_order_column’ );
function prefix_add_sequential_order_column( $columns ) {
$columns[‘sequential_order’] = ‘Sequential Order’;
return $columns;
}

add_action( ‘manage_shop_order_posts_custom_column’, ‘prefix_display_sequential_order_column’, 2 );
function prefix_display_sequential_order_column( $column ) {
global $post, $woocommerce, $the_order;

if ( 'sequential_order' === $column ) {
    $order_id = $the_order->get_id();
    $order_number = get_post_meta( $order_id, '_order_number', true );

    if ( ! empty( $order_number ) ) {
        echo $order_number;
    } else {
        echo 'N/A';
    }
}

}

Please check the above code and let me know if this is correct or not.

Thank You.