Jump to content
Sign in to follow this  
thefragranceroom

Change the starting order number

Recommended Posts

does someone know how i can change the starting order number, so that it will be a four digit number? please help. thanks.

Make a dummy order in your shop. Then go to phpmyadmin and change the dummy order number to 1000. The next order will be 1001.

 

This has been discussed in the forums before.


The Coopco Underwear Shop

 

If you live to be 100 years of age, that means you have lived for 36,525 days. Don't waste another, there aren't many left.

Share this post


Link to post
Share on other sites
Make a dummy order in your shop. Then go to phpmyadmin and change the dummy order number to 1000. The next order will be 1001.

 

This has been discussed in the forums before.

 

I'm not too familiar with phpmyadmin... where would i find the dummy order? Sorry. I appreciate the help.

Share this post


Link to post
Share on other sites
I'm not too familiar with phpmyadmin... where would i find the dummy order? Sorry. I appreciate the help.

 

i've tried looking through the old forums, but i'm a little confused. i know how to get to myphpadmin, but i don't know where to find the order_id. please help. thanks.

Share this post


Link to post
Share on other sites
I'm not too familiar with phpmyadmin... where would i find the dummy order? Sorry. I appreciate the help.

In the orders table.


The Coopco Underwear Shop

 

If you live to be 100 years of age, that means you have lived for 36,525 days. Don't waste another, there aren't many left.

Share this post


Link to post
Share on other sites
i changed the dummy order number; however, i tried placing another dummy order after that to test it and it went back to the original sequence.

Did you delete the first dummy order before making the second?


The Coopco Underwear Shop

 

If you live to be 100 years of age, that means you have lived for 36,525 days. Don't waste another, there aren't many left.

Share this post


Link to post
Share on other sites

Okay, that didn't work for me (osC 2.3.1). But I found a solution from elv1s and it works!!

 

elv1s, op 02 August 2005 - 01:40, zei:

 

Hallo,

in je PHPMYADMIN

volgende beveel ingeven.

alter table customers auto_increment=501

en voor faktuurtjes...

alter table orders auto_increment=501

waarbij 501 voor het getal staat vanaf waar je verder wilt gaan.

ps. altijd ff een backup maken!

gr.

kasper

 

In English:

Please backup!

when you want to start your customers at 501, paste in your database\sql: alter table customers auto_increment=501

when you want to start your ordernumbers at 501, paste in your database\sql: alter table orders auto_increment=501

Edited by ron123

Share this post


Link to post
Share on other sites

using the code below to do it

insert into orders set orders_id = 1001;

delete from orders where orders_id = 1001;

run it in phpmyadmin

Then, place a new order and check the latest orders id, I guess it's 1002 now.

Good luck, budddy!


Have a problems in osCommerce shipping, payment, addons installation, customization or SEO?

 

Ready to give a hand at once... check my profile for help

Share this post


Link to post
Share on other sites

The official solution

 

http://www.oscommerc...et+the+Order+ID

 

alter table orders auto_increment = 1000;

 

HTH

 

G

Edited by geoffreywalton

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

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
Sign in to follow this  

×