order id starting at 10000

[luispnovis]

Hello

 

This might seem a strange request but here it goes...

 

I want to start a shop where the order id´s start at 10000 and go increasing.

 

So first order is order 10000.

 

This is because I have a first shop and have a payment option that uses order id to communicate to the shop.

 

So if my second store starts at order id=0, I would never know where the payment comes from.

 

Can anyone help me here.

 

All I want is:

 

orders with id to 10000 come from shop 1

 

orders with id > 10000 come from shop 2

 

 

Thank you

[Logical IT]

Hello,

 

Can you please clarify if you are using PrestaShop multi-shop configuration or are your stores on two separate installations of PrestaShop?

[Knowband Plugins]

You can achieve that by running the following query after installation of your new PrestaShop store.

 

 

ALTER TABLE (YOUR_DB_PREFIX)_orders AUTO_INCREMENT = 10000;

[LuisMP]

Thank you!

 

It´s really two independent installations of Prestashop

[Logical IT]

Hello Luis,

 

I have created a module for you that allows you to easily change the order start number from the back office.

 

You can download the module for free from here:

https://www.logicalit.com/prestashop-modules/en/20-change-order-id-start-number-prestashop-module.html