Order number - change start point

[Ajeh]

To change the orders_id you would go to the Tools ... Store Manager ... and read the instructions there on how to create an Order and then change that Order's orders_id to a new orders_id ...

[sksaree]

Thanks. original instructions worked for me as well.

[MatchManhattan]

I followed your and the instruction on that section and tried 25 times. It still does NOT work. What is going on?? I made an order and got the order ID as 21 and want to start the new ID as 8229 so I put 8228. I then made another order again, the number still the old number +1=22.
Pl. help!!!

the site is : www.ftabonus.com
Thank you very much.

To change the orders_id you would go to the Tools ... Store Manager ... and read the instructions there on how to create an Order and then change that Order's orders_id to a new orders_id ...

[Ajeh]

Could you look at the structure of your orders table via phpMyAdmin and list the settings for the orders_id that you see when looking at its structure?

[MatchManhattan]

I coulsdnt find order table as you mentioned, so i tried order total, hope that can help, as below:

Order Total Modules

Modules Sort Order Action
COD Fee ot_cod_fee 950
Discount Coupon ot_coupon 280
Group Discount ot_group_pricing 290
Gift Certificates ot_gv 840
Low Order Fee ot_loworderfee 400
Quantity Discount ot_quantity_discount 295
Shipping ot_shipping 200
Sub-Total ot_subtotal 100
Tax ot_tax 300
Total ot_total 999

Thank you very much.

Could you look at the structure of your orders table via phpMyAdmin and list the settings for the orders_id that you see when looking at its structure?

[Ajeh]

You have a database that holds all of the data tables for your shop that you can see via your Control Panel for your domain with phpMyAdmin ... this is not part of Zen Cart ...

By looking at the structure of your orders table in your database you can see how the orders_id is setup and check to see if, for some reason, it is not setup for the proper settings ...

If you don't know where phpMyAdmin is in your domain's control panel, you should contact your hosting site for some help on how to use phpMyAdmin so that you can check the structure of the orders table in your database ...

[MatchManhattan]

Hope below are the things you are talking about, I am really ignorant in this. NEWBEE..

I did a check table:
Table Op Msg_type Msg_text
pansat_zc1.zen_orders_total check status OK

then is this:

zen_orders_total 38 MyISAM 6.3 KiB Creation: Jul 02, 2008 at 11:39 PM
Last update: Oct 05, 2008 at 08:50 PM
Last check: Oct 06, 2008 at 04:42 PM

I hope this helps.

Look foward to hearin gfrom you.
Thanks again.

You have a database that holds all of the data tables for your shop that you can see via your Control Panel for your domain with phpMyAdmin ... this is not part of Zen Cart ...

By looking at the structure of your orders table in your database you can see how the orders_id is setup and check to see if, for some reason, it is not setup for the proper settings ...

If you don't know where phpMyAdmin is in your domain's control panel, you should contact your hosting site for some help on how to use phpMyAdmin so that you can check the structure of the orders table in your database ...

[Ajeh]

Not really ...

You need to look at the table structure of the orders table in your database ...

It will list the fields such as:

Field  	Type  	Collation  	Attributes  	Null  	Default  	Extra  	Action
orders_id 	int(11) 			No 		auto_increment 	
customers_id 	int(11) 			No 	0 		
customers_name 	varchar(64) 	latin1_swedish_ci 		No 			
customers_company 	varchar(64) 	latin1_swedish_ci 		Yes 	NULL

What you want to see is if your orders_id field is marked as auto_increment or not ...

[cchan]

Would I be able to add letters to the New Order ID?

[Ajeh]

Not to the database, the orders_id is a numeric field ...