How To Info: Change Starting Order Numbers

[Tara]

I am migrating a site from another shopping cart and needed to change my starting order number sequence a) to keep my records straight and to not give shoppers the feel they are a guinea pig when they see they are order #2.

To do this: (goes without saying to backup your database first)

Log into your CPanel
Click on MYSQL Databases
Click on PhpMyAdmin

Click on the correct database in the left hand column, this will display the DB information in the left column (might already show if you only have one DB installed)

From the left side column click 'ps_orders' (or simply 'orders') if you don't have a DB prefix, or if you have a different prefix it would be 'prefix_orders'

at the top menu click 'operations'

Under 'Table Operations'
change the auto_increment to the number you want (this will be your next order number)

Click GO

[gloriouswebmasters]

Dear Sir,

 

Thanks for your valuable and detailed topic.

 

I am using Prestashop 1.6 and did the same but it's not working for me. I even have the same option in back office and tried many times from there as well. Now I changed from back office and then check my phpmyadmin is also having same value which I entered in back office. But invoice number is generating as earlier not following my numbers. Please help if you can sir.

[vekia]

 

Try:

 

ALTER TABLE `database_name`.`ps_orders` AUTO_INCREMENT = 2092

Change database_name to the name of your database.