Order number - change start point

Hi,

I want to change the starting order number to something bigger.

I understand that I go to admin, store manager but where do I add the new number. I placed a bigger number into Older order ID and nothing happend when I placed a fake order and I added a number to the New order ID but again nothing. WHat am I doing wrong? Do I need to add two numbers:dontgetit

Reset Current Order ID

Old Order ID
New Order ID

Hi there
You need to enter both numbers Old ID (being the last order number) and New Id being the new start number which needs to be bigger the the Old ID

Thanks for that :bigups:

Sorted now :smile:

pb4:

Hi,

I want to change the starting order number to something bigger.

I understand that I go to admin, store manager but where do I add the new number. I placed a bigger number into Older order ID and nothing happend when I placed a fake order and I added a number to the New order ID but again nothing. WHat am I doing wrong? Do I need to add two numbers:dontgetit

Reset Current Order ID

Old Order ID
New Order ID

Ok. I'm reviving this post, because I don't understand how to do this. Where exactly in the admin do I change the order number permanently to a higher number and it goes incrementally forward from there? I can't imagine anyone wanting to reorder from someone who's order number is in single, double or triple digits (1,10 or 100). I'd like to change it to start at about 1000 or more.

I've done some test orders, but still only in the single digit order numbers here.

Any help is greatly appreciated.

Never Mind! I finally figured it out! :D

What was the secret to your success? :smile:

Ajeh:

What was the secret to your success? :smile:

The secret, was that I went back and "RE-read" the info, logged into my admin>store manager followed the destructions...er I mean the instructions. ;-) Worked perfectly. I'm better at the destruction than the instruction. LOL

Every now and then ... I have to read the instructions too, or I end in disaster myself ... :cool:

worked like a charm. thx!

Can somebody help? Where are the original instructions on where to edit the starting order number? I don't see any option to edit anything on the order info page. Thanks.

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 ... :smile:

Thanks. original instructions worked for me as well.

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 : https://www.ftabonus.com
Thank you very much.

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 ... :smile:

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?

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.

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?

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 ...

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.

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 ...

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 ...

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

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