Conversation
supportHello, I did a few test orders on my store and then I wanted to delete them and tried resetting the numbering to the number right after the last live order. However it was not working. So I went in the database to find what options are stored there. In the wp_options table the wp_sequence_order_number_start was set to 5617 which is what I wanted. The wp_last_order_number option though it had a value of 5621 which included the 5 test orders I placed 5617-5621. I tried resetting the wp_last_order_number to 5617 as well but the next order came in with number 5622. So I achieved nothing. Can you please help on how I should reset the numbering after placing and deleting test orders?
I noticed that the meta keys _order_number associated with the deleted orders they were still present in the postmeta table. I don’t if this is the problem?
Hi @barnabas1 , Thanks for reaching out. The plugin works on an incremental counter, meaning that deleting orders from the front end will not delete the corresponding order numbers generated. The plugin uses the meta key _order_number to store the sequential order number in the post-meta table. To reset the order numbers: Delete the test order numbers present in the _order_number metakey in the post meta table from your database. Update the wt_last_order_number meta value in the database to your desired next order number. Please ensure you enter only the numeric value without any suffix, prefix, or padding. After updating the database, set the next order number value in the plugin’s start number field from the front end by navigating to: WooCommerce > Settings > Sequential Order Number . Once done, the new sequential order numbers will continue from the updated value.
Thank you for the detailed response. Much appreciated. Kind regards, Barnabas
Hi @barnabas1 , Glad to have helped with your query. If you like the plugin and support, please leave us a review here . It would really help us spread the word. Thanks in advance!
You have my best review already, thanks you!
Hello, After trying this it didn’t really work. Did you miss any step by any chance in what you wrote above?
Hi @barnabas1 , You may follow the same steps as mentioned earlier; however, we missed informing you that you would need to delete the _order_number meta key present in the wp_wc_orders_meta and the wp_postmeta table.
I noticed that the meta keys _order_number associated with the deleted orders they were still present in the postmeta table. I don’t if this is the problem?
Hi @barnabas1 , Thanks for reaching out. The plugin works on an incremental counter, meaning that deleting orders from the front end will not delete the corresponding order numbers generated. The plugin uses the meta key _order_number to store the sequential order number in the post-meta table. To reset the order numbers: Delete the test order numbers present in the _order_number metakey in the post meta table from your database. Update the wt_last_order_number meta value in the database to your desired next order number. Please ensure you enter only the numeric value without any suffix, prefix, or padding. After updating the database, set the next order number value in the plugin’s start number field from the front end by navigating to: WooCommerce > Settings > Sequential Order Number . Once done, the new sequential order numbers will continue from the updated value.
Thank you for the detailed response. Much appreciated. Kind regards, Barnabas
Hi @barnabas1 , Glad to have helped with your query. If you like the plugin and support, please leave us a review here . It would really help us spread the word. Thanks in advance!
You have my best review already, thanks you!
Hello, After trying this it didn’t really work. Did you miss any step by any chance in what you wrote above?
Hi @barnabas1 , You may follow the same steps as mentioned earlier; however, we missed informing you that you would need to delete the _order_number meta key present in the wp_wc_orders_meta and the wp_postmeta table.