thefragranceroom Posted January 18, 2008 Share Posted January 18, 2008 does someone know how i can change the starting order number, so that it will be a four digit number? please help. thanks. Quote Link to comment Share on other sites More sharing options...
Guest Posted January 18, 2008 Share Posted January 18, 2008 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. Quote Link to comment Share on other sites More sharing options...
thefragranceroom Posted January 18, 2008 Author Share Posted January 18, 2008 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. Quote Link to comment Share on other sites More sharing options...
thefragranceroom Posted January 18, 2008 Author Share Posted January 18, 2008 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. Quote Link to comment Share on other sites More sharing options...
Guest Posted January 18, 2008 Share Posted January 18, 2008 I'm not too familiar with phpmyadmin... where would i find the dummy order? Sorry. I appreciate the help. In the orders table. Quote Link to comment Share on other sites More sharing options...
thefragranceroom Posted January 18, 2008 Author Share Posted January 18, 2008 In the orders table. 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. Quote Link to comment Share on other sites More sharing options...
Guest Posted January 18, 2008 Share Posted January 18, 2008 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? Quote Link to comment Share on other sites More sharing options...
itsjust Posted August 10, 2008 Share Posted August 10, 2008 find it here http://www.oscommerce.info/kb/31 Quote Link to comment Share on other sites More sharing options...
ron123 Posted December 13, 2011 Share Posted December 13, 2011 (edited) 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 December 13, 2011 by ron123 Quote Link to comment Share on other sites More sharing options...
Guest Posted January 4, 2012 Share Posted January 4, 2012 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! Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 4, 2012 Share Posted January 4, 2012 (edited) The official solution http://www.oscommerc...et+the+Order+ID alter table orders auto_increment = 1000; HTH G Edited January 4, 2012 by geoffreywalton Quote 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 More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.