Jump to content
dculley

Reset the order ID in Pheonix 1.0.4.1

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

 

Share this post


Link to post
Share on other sites

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

 

image.thumb.png.a13948324023055d04653e1ea9fbf2b1.png

 

Share this post


Link to post
Share on other sites

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.

 

Share this post


Link to post
Share on other sites

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. 


Always back up before making changes.

Share this post


Link to post
Share on other sites

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

Edited by Moxamint

Share this post


Link to post
Share on other sites

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

Edited by kgtee

Share this post


Link to post
Share on other sites

Moxanint

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

Thank you

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×