Changing order number

Hi, after reading some threads about this I went to admin/store manager and reset my order number id. Problem is that it did not actually change. Does anyone know how do reset the order number manually?

I went to admin/store manager and reset my order number id. Problem is that it did not actually change.
For what??
An order already placed???
If so, not an easy task as the info is written to the DB in many places and you would have to manually edit each of these to prevent actions associated with this order from breaking

not for existing orders, just for future ones. I have upgraded my site from an old one and need the order numbers to start from 1776.

Did you follow what it says on the Store Mgr Page?

NOTE: Before updating the Current Order ID ...

Create a test order first. Then, using this Test Order ID complete the information below.
The New Order ID for the next Real Order should be entered as 1 less than the Order ID you wish to use.
Example: If you want your next Real Order ID to be 1225, enter the number 1224

WARNING: You can only reset the Order ID forward, and not backwards.
So if you set the Orders ID to 25, then change it again to 20, the next Orders ID will still be 26.

i created an order, which was number 2, and entered a much higher number to be applied to next order. The next order i processed came out as order number 3

I think I must be missing the point here somewhere lol

I have just tried again, Changing order number 3 to 1515 the next order came out as order number 4

Not sure how it sorted, but got it to work now. Many thanks for your earlier replies.

If you are wondering how to test if your order_id change worked :

Rather than having to do a test order to find out if your change worked, you can run the following SQL :

SHOW TABLE STATUS LIKE 'my_orders';

(Change "my_orders" to the name of your table - it will most likely be "orders" unless you set up your database with a table prefix configured in which case it would be '[prefix]_orders'

Running this sql query (in phpMyAdmin or similar database tool) will return you some data about your table - one of which is an "Auto Increment" value. This Auto Increment value that is returned is the number that your next order will be allocated.