Revisions to Magento 2 How to change the Order number sequence

deleted 131 characters in body

Source Link

edited Sep 24, 2018 at 12:05

Click on the table called:ALTER TABLE sequence_order_1.

In the AUTO_INCREMENT pass the desired order number

For Example : AUTO_INCREMENT=300005464;

ALTER TABLE sequence_order_1 AUTO_INCREMENT=300005464;

Click on the table called: sequence_order_1.

In the AUTO_INCREMENT pass the desired order number

For Example :

ALTER TABLE sequence_order_1 AUTO_INCREMENT=300005464;

ALTER TABLE sequence_order_1 AUTO_INCREMENT=300005464;

added 8 characters in body

Source Link

edited Sep 24, 2018 at 12:00

Click on the table called: sequence_order_1.

In the AUTO_INCREMENT pass the desired order number

In the AUTO_INCREMENT pass the desired order number

For Example :

ALTER TABLE sequence_order_1 AUTO_INCREMENT=300005464;

ALTER TABLE sequence_order_1 AUTO_INCREMENT=300005464;

Click on the table called: sequence_order_1.

In the AUTO_INCREMENT pass the desired order number

For Example :

ALTER TABLE sequence_order_1 AUTO_INCREMENT=300005464;

Click on the table called: sequence_order_1.

In the AUTO_INCREMENT pass the desired order number

For Example :

ALTER TABLE sequence_order_1 AUTO_INCREMENT=300005464;

Source Link

created Sep 24, 2018 at 11:55

Click on the table called: sequence_order_1.

In the AUTO_INCREMENT pass the desired order number

For Example :

ALTER TABLE sequence_order_1 AUTO_INCREMENT=300005464;

Return to Answer