Resetting the order id value in sql

[baggers]

Hi,

 

In the instructions downloading OS Commerce it tells you how to change the order id value in the database (shown below). However, it doesn't work.

 

AllI want to do is change the order numbers that the cart gives out (Ie. instead of starting with 1, then 2, 3, 4 etc. I want to start with a high number such as 1625 or something like that.

 

Anyone know the correct query to run in sql?

 

alter table osc_orders auto_increment = 1000;

 

Thanks,

 

Paul

[Guest]

Hi,

 

In the instructions downloading OS Commerce it tells you how to change the order id value in the database (shown below). However, it doesn't work.

 

AllI want to do is change the order numbers that the cart gives out (Ie. instead of starting with 1, then 2, 3, 4 etc. I want to start with a high number such as 1625 or something like that.

 

Anyone know the correct query to run in sql?

 

alter table osc_orders auto_increment = 1000;

 

Thanks,

 

Paul

<{POST_SNAPBACK}>

 

I did it by manually editing the order id for a dummy order. Once you place the order, go in a edit the order_id column in the following tables:

 

orders, orders_products, orders_products_attributes, orders_products_downloads, orders_status_history, orders_total.

 

Then make sure orders_id column in the orders tables is set to auto_increment. Once a real order is placed, then you can delete the dummy order.

 

Hope this helps.

[baggers]

I did it by manually editing the order id for a dummy order.  Once you place the order, go in a edit the order_id column in the following tables:

 

orders, orders_products,  orders_products_attributes, orders_products_downloads, orders_status_history, orders_total.

 

Then make sure orders_id column in the orders tables is set to auto_increment.  Once a real order is placed, then you can delete the dummy order.

 

Hope this helps.

<{POST_SNAPBACK}>

 

Just had a quick look at the database but there doesn't seem to be an easy way to manually change any of the fields through my host's control panel. Any other way of doing it?

 

Paul

[baggers]

Worked how to do it exactly as you said now and it works!

 

Thanks,

 

Paul