Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Change the starting order number


thefragranceroom

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.

Link to comment
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.

Link to comment
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.

Link to comment
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?

Link to comment
Share on other sites

  • 6 months later...
  • 3 years later...

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
Link to comment
Share on other sites

  • 4 weeks later...

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!

Link to comment
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 ======>>>>>.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...