How to Change Order Starting Number in Magento

How to Change Order Starting Number in Magento

July 21, 2026 · Illustrated author avatarBy Stefan Bogdanescu
How to Change Order Starting Number in Magento

Changing Magento Order Starting Numbers Without Affecting Existing Orders

If you’re looking to change the starting number for new orders in your Magento store without affecting the numbers of existing orders, you’ve come to the right place. In this guide, we’ll walk through a step-by-step process that allows you to set your desired start number while keeping your historical order numbering intact.

Understanding Magento Order Numbering

Magento uses a sequential numbering system for its orders by default. This means every new order is assigned an incremented number based on the last used number in the system. The starting point for this sequence is defined during the initial setup of your store and usually begins at “00001”.

Changing the Starting Number

While Magento doesn’t provide a built-in interface to change the starting number directly, it’s still possible to achieve this without disrupting your existing order numbers. This involves manipulating the core database tables responsible for order generation.

Step 1: Backup Your Database

Before making any changes, ensure you have a complete backup of your Magento database. You can use tools like phpMyAdmin or MySQL Workbench for this purpose.

Step 2: Locate the Sequence Table

The sequence table is where Magento stores information about the last used number for each order prefix. In most cases, this table will be named core_resource. Look for an entry with a “code” value of 'order_seq' and note down the current “increment_id” value.

Step 3: Update the Sequence Table

To change the starting number without affecting existing orders, you need to update the increment_id in the core_resource table. The new value should be the last used order number plus one.

For example, if your current increment_id is 170000 and you want your next order to start at 170100, set the new increment_id as 170001.

Here’s a sample SQL query using MySQL:

UPDATE core_resource
SET increment_id = 170001
WHERE code = 'order_seq';

Step 4: Flush Magento Cache

After updating the table, flush your Magento cache to ensure the changes take effect. You can do this by running the following command in your terminal:

php bin/magento cache:flush

Conclusion

Changing the starting order number in Magento requires a careful approach to avoid disrupting your existing orders. By understanding how the core_resource table works and updating it accordingly, you can set new starting points for your order numbering system without causing any issues with historical data.

Remember, always backup your database before making such changes and thoroughly test the process on a staging environment first. If you need further assistance or find yourself facing other Magento development challenges, don’t hesitate to reach out to our team at Laravel Company.

Happy coding!

Database Admin Orders Errors

Our network