hi we have installed magento 2.2.2 in our store,,,,,,
We have lot of test orders and we deleted that orders using mage comp Delete Orders Extension,,,,,,
Now we need to reset order Number to 1 (Starting from First)....Because we have so many test orders,,,,previously,,,,,,
How to reset order number to 1 ,,,,,,Is it possible by admin side???????
or Any other possible solutions,,kindly help us
You have to lookup below links for your customization,
One of the paid extension is also available from below link,
First of all, Thanks for using MageComp delete order extension for your store.
As per your need to reset order sequence, you need to change order autoincrement value from your database.
You can either do it manually by navigating to sales_order table and from operations, simply change the autoincrement value as Shown in this screenshot.
Or you can change autoincrement value by firing SQL query to your database as shown below.
ALTER TABLE SALES_ORDER AUTO_INCREMENT=1;
You can take a look at https://bsscommerce.com/magento-2-custom-order-number-extension.html.
This tool helps you change the order number flexibly and of course, the order number can be reset whenever you want.