10 replies to this topic

[thefragranceroom]

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

[Coopco]

thefragranceroom, on Jan 18 2008, 03:13 PM, said:

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.

[thefragranceroom]

Coopco, on Jan 17 2008, 08:24 PM, said:

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.

[thefragranceroom]

thefragranceroom, on Jan 17 2008, 09:33 PM, said:

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.

[Coopco]

thefragranceroom, on Jan 18 2008, 04:33 PM, said:

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

In the orders table.

[thefragranceroom]

Coopco, on Jan 17 2008, 10:08 PM, said:

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.

[Coopco]

thefragranceroom, on Jan 18 2008, 06:04 PM, said:

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?

[itsjust]

find it here
http://www.oscommerce.info/kb/31

[ron123]

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, 13 December 2011, 11:57.

[oscexp]

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!

[geoffreywalton]

The official solution

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

alter table orders auto_increment = 1000;

HTH

G

Edited by geoffreywalton, 04 January 2012, 23:20.