How to change the Order No.?

[NewBudda]

I would like to tweak my order Numbers so that they continue from a higher value than at the moment. To clarify: at the moment my order numbers go: 98, 99, 100, 101, etc. I would like them to be: 1598, 1599, 1600, 1601 thus suggesting that I had more order than I actually had. Not everybody needs to know how young my shop is...

how do I do that safely?

[FIMBLE]

You can do this through phpmyadmin, look under the orders table

Nic

[NewBudda]

Could you be more specific? I have found what seems a list of previous order under orders_total. funnily every order is represented triplefold.

I think its the value orders_id or order_status_history_id that need to be manipulated but I am not sure how. I hoped there was a counter I could just "adjust".

Has anyone done this before?

[FIMBLE]

Back up your database,

 

 

ALTER TABLE `orders` AUTO_INCREMENT =1000

 

Run this in your phpmyadmin, change the 1000 for a number of your choice

 

 

Regards

Nic

[NewBudda]

Could you be more specific? I have found what seems a list of previous order under orders_total. funnily every order is reprensented triplefold.

I think its the value orders_id or order_status_history_id that need to be manipulated but I am not sure how. I hoped there was a counter I could just "adjust".

Has anyone done this before?