cancel
Showing results for 
Search instead for 
Did you mean: 

How to Reset Order Number in Magento 2.2.2

How to Reset Order Number in Magento 2.2.2

 

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

4 REPLIES

Re: How to Reset Order Number in Magento 2.2.2

You have to lookup below links for your customization,

https://www.classyllama.com/blog/m2-incrementid

 

One of the paid extension is also available from below link,

https://amasty.com/custom-order-number-for-magento-2.html

If Issue Solved, Click Kudos/Accept As solutions.

Re: How to Reset Order Number in Magento 2.2.2

Hello @Dhanaa

 

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;
Found something useful, please give "Kudos" or "Accept as Solution" for Token of Appreciation.
Free Magento Extensions : https://magecomp.com/free-magento-extensions.html

Re: How to Reset Order Number in Magento 2.2.2

It is Already 1 in that table

Re: How to Reset Order Number in Magento 2.2.2

Hello,

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.