Reset the order ID in Pheonix 1.0.4.1

[dculley]

It has been a long time since I had to do this. I'm not a programmer but can work my way around a few things. 

Can anyone show me how to reset the order ID in terms that I can understand?  I'm coming from OSC 2.3.4 to Phoenix 1.0.4.1.  I want to update the order ID number in Phoenix so that when I ready to go live with PHX I will be at the correct order number. 

Thanks

Dean

[kgtee]

I have done this using phpmyadmin. Execute this SQL command line:

 

ALTER TABLE orders AUTO_INCREMENT=19001;

 

assuming the order id will start with 19001.

 

[dculley]

I seem to not know where the command line is.  I clicked on SQL button, copied in the line and click 'go'.  Then I got the below. 

Can you point me in the right direction? 

Thanks

 

 

[kgtee]

You miss typing a semicolon at the end of the statement.

[dculley]

I copied passed your line in and changed the 19001 to 20001

I left the semicolon at the end.

I even tried typing it in.

 

[kgtee]

Check if your orders_id field is indexed?

[dculley]

it appears to be.

 

[♥ecartz]

What does

SHOW TABLE STATUS LIKE 'orders'

show?  Or just

SELECT AUTO_INCREMENT
FROM information_schema.tables
WHERE table_name = 'orders'
AND table_schema = DATABASE( ) ;

The command may have worked.  I'm not sure that it says anything when used. 

[♥Moxamint]

When you are at the "orders" table, go to the "Operations" tab, enter the desired number in the "AUTO_INCREMENT" field, and then press "Go" button

[kgtee]

As @ecartz said it has worked, the green tick confirms that. We miss reading between the lines 😆

[dculley]

Moxanint

OMG that was easier.  That should be under the notes in the start up reference manual.

Thank you