Change Next Order Number Starting

[xearoth]

Ok in my orders table and under orders_id i have

3016

3097

3098

 

Now when a new order is placed it defaults to 3017 instead of going to 3099 what would be causing this problem?

[Guest]

you should check the orders sql table. The orders_id must be set to auto-increment. Also use the phpmyadmin tool and check under the operations tab when you select the orders table what's the auto_increment value.

[xearoth]

enigma thanks for the email back, ok so now on the operations what do i change now?

 

Alter table order by:

orders_id customers_id customers_name customers_company customers_street_address customers_suburb customers_city customers_postcode customers_state customers_country customers_telephone customers_email_address customers_address_format_id delivery_name delivery_company delivery_street_address delivery_suburb delivery_city delivery_postcode delivery_state delivery_country delivery_address_format_id billing_name billing_company billing_street_address billing_suburb billing_city billing_postcode billing_state billing_country billing_address_format_id payment_method cc_type cc_owner cc_number cc_expires cvvnumber last_modified date_purchased orders_status extracted_status orders_date_finished currency currency_value ups_track_num customers_referer_url tracking_no ship_date delivery_date carrier_id (singly) Ascending Descending

 

Rename table to:

 

 

Move table to (database.table):

information_schema mysql test .

 

Copy table to (database.table):

information_schema mysql test .

Structure only

Structure and data

Data only

Add DROP TABLE

Add AUTO_INCREMENT value

Switch to copied table

 

Table comments

 

 

Table type:

MyISAM MEMORY InnoDB ARCHIVE MRG_MYISAM

 

Collation:

big5_bin big5_chinese_ci binary cp1250_czech_cs cp932_bin cp932_japanese_ci eucjpms_bin eucjpms_japanese_ci euckr_bin euckr_korean_ci gb2312_bin gb2312_chinese_ci gbk_bin gbk_chinese_ci latin1_bin latin1_german2_ci latin1_swedish_ci latin2_czech_cs sjis_bin sjis_japanese_ci tis620_bin tis620_thai_ci ucs2_bin ucs2_czech_ci ucs2_danish_ci ucs2_esperanto_ci ucs2_estonian_ci ucs2_general_ci ucs2_icelandic_ci ucs2_latvian_ci ucs2_lithuanian_ci ucs2_persian_ci ucs2_polish_ci ucs2_roman_ci ucs2_romanian_ci ucs2_slovak_ci ucs2_slovenian_ci ucs2_spanish2_ci ucs2_spanish_ci ucs2_swedish_ci ucs2_turkish_ci ucs2_unicode_ci ujis_bin ujis_japanese_ci utf8_bin utf8_czech_ci utf8_danish_ci utf8_esperanto_ci utf8_estonian_ci utf8_general_ci utf8_icelandic_ci utf8_latvian_ci utf8_lithuanian_ci utf8_persian_ci utf8_polish_ci utf8_roman_ci utf8_romanian_ci utf8_slovak_ci utf8_slovenian_ci utf8_spanish2_ci utf8_spanish_ci utf8_swedish_ci utf8_turkish_ci utf8_unicode_ci

[Guest]

so what's the auto-increment value? If you don't have it go to structure select the orders_id column edit it and change the Extra field to be auto-increment

[xearoth]

Field Type Collation Attributes Null Default Extra Action

orders_id int(15) Yes NULL auto_increment

 

That is what the structure looks like it, it is set to auto_increment but how do I update it to start at 3098 now so the next order will be 3099?

[Guest]

you execute an sql query

 

ALTER TABLE `orders` AUTO_INCREMENT =3099

[xearoth]

engima i really apreciate your patience. you helped me tons!!! thanks alot!!!!!!!!!!!!!111