Magento 2 Order Number

Each order in your Magento 2 eCommerce store gets a unique number. It is used for internal needs and couldn’t be modified from the administrative panel. Also, you are unable to modify the order number length or change order prefixes and postfixes.

In Magento 2 each new order or customer gets a personal record in the database, called increment_id. This record should be edited to get the effect. If you need to change the default order number, you have two possible ways to do this.

First, you can use an extension with such functionality.

Second, you can manually edit certain database tables to get a result. So, this is a step-by-step instruction:

1. Open MySQL database of your Magento 2 store with the help of phpMyAdmin.
2. Find the table «sequence_order_1». Note, that this table is located in the database itself, not in the «information_schema».
3. Hit the «Operations» tab and edit the desired «increment_id» number under it.

Also, you can modify the very fist order number for your new Magento 2 store. To do this, follow the instruction below:

1. Open MySQL database of your Magento 2 store with the help of phpMyAdmin.
2. Find and open the table «sequence_order_1». Note, that this table is located in the database itself, not in the «information_schema».
3. Hit the «Operations» tab and edit «Auto_Increment» to the desired order number.

Of course, it is much more convenient to find the extension, that suits your needs, and quickly edit order numbers.

One second, please. Take a look at extension for Magento 2 that allows to manage orders easily

Order Management

Streamline the process of Magento 2 order processing. Easily add/delete/remove any order details, order customers' billing and shipping info and more.

$149

Post Comments

Submit Comment




* Required Fields