Magento Order Number
By default, in Magento the order number starts from 100000001. But if you need to:
- mask the real order data from your customers and competitors,
- reduce the increment_id tricks for multiple store views,
- customize order numbers for inner purposes, etc.
2. Use an extension that can do this job for you.
Here is how to change the order number manually.
To avoid confusion, Magento offers 2 different values of sales orders: entity_id & increment_id.
- Entity_id (aka order_id) is used for internal purpose only. It is the sales_flat_order table primary key value, which connects all the eav tables together. Generally it starts from the value 1.
- Increment_id (aka order_increment_id) is displayed to customers. This is the only id you need to use and change.
Note! In the increment_id the number of zeros is variable. So you can customize the order number length as you need.
How to modify the Increment_id?
Once an order is complete, jump to the sales_flat_order table, choose the necessary order and hit the edit link.
You can also change the prefix value of the future orders, invoices, shipments or credit memos in the eav_entity_store table.
*Increment_prefix defines which prefix will be added the order number (by default it’s 1).
Just select the necessary entity_type_id (5, 6, 7 or 8) and hit the edit button.
5 - Orders;6 - Invoices;
7 - Credit Memos;
8 - Shipments.
Note! The entity_type_id number can vary in different database systems.
How to change the order starting number.
In the Insert tab change the increment_prefix value to the one you need. In our case, we have changed it from 1 to 17.
Magento Custom Order Number
Create a new Magento file, for example change.php and insert the following code there:
Replace $orderId = 237 with the real entity_id from your store that you need to change. When done, place this file into your Magento root folder, save it and open with [base_url]/change.php.
Please take a look at plugin that allows to manage orders easily
Order Management
Extend the standard Magento Orders grid, manage (edit/ delete/ archive) any number of orders with ease.
Order Editor
Easily edit Magento orders, as well as modify the details of any included product. Log all changes in order comments.
Advanced Order Grid
Extend the capabilities of the default Magento Orders grid. Add new columns, personalize Orders View.
TMTherion
posted on Nov 26, 2019