Change starting Order ID number

[mousepad]

This has been asked 100 times but seems to change in every version of Magento.

I just need to adjust the starting order number. So not 000000001 but 50000

I have changed the number in sequence_order_1 

Compiled, deployed, cache flushed etc.

It still starts from the next number. 

[Tarandeep Singh]

@mousepadPlease go through the below URL. It has solution for different version of Magento. One of them must work for you. Once you make the changes you need to make sure they are reflected.

Problem solved? Please give 'Kudos' and accept 'Answer as Solution'.

[Manish Mittal]

Hello @mousepad

Please follow below links:

https://bsscommerce.com/blog/complete-tutorial-guide-change-order-number-magento-2/

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

Once you will be done with shared links just refresh cache and reindex. It will work perfectly as your need. 

[vikasi95dev]

Hi @mousepad,

This is a limitation from Magento and you can change the Order number sequence from Backend Configuration, whereas you can change sequence within Database Tables by following the steps provided in the reference url shared by Manish.

Regards,

Vikas Sankla