Adding a new "Order Status"

From the Admin go to - Customers - Orders then choosing the "Edit" option, I need to add in a new "Order Status" in the dropdown menu. By default I have 4 options including Pending 1, Processing 2, Delivered 3 and Update 4.
I wanted to have "Shipped" included in that menu and would mind setting it as 3 and "Delivered" as 4 and Update as 5.

One other thing, I am having problems with the "Flyout Menu" on the catalog. The Flyout boxes are overlapping, I know there is a value in the stylesheet that controls this but can't remember what it is.

Any help is appreciated, Thanks!

I would set it by go to the Localization ... Orders Status ... and changing Delivered (orders_status 3) to Shipped ...

Then Add a new one, Delivered (orders_status 5) and leave Updated at 4 as this is coded for Downloads ...

Then, go to the Configuration ... Attribute Settings ... and change the setting for Downloads highest from 4 to 5 in the:

Downloads Controller Order Status Value <= upper value
Downloads Controller Order Status Value - Default <= 4

Downloads are available for checkout based on the orders status. Orders with orders status less than this value will be available for download. The orders status is set for an order by the Payment Modules. Set the upper range for this range.

This allows, should you use Downloads, that the Download is available from orders_status >= 2 (Processing) to <= 5 (new Delivered) ...

Hi there

This thread is pretty old... but maybe someone can still help.

I want to insert a new order status. This is pretty easy as described above.

But to make it complicated, I want the new order status to be between the first and the second of my existing order status:

Old situation:

status_a [1]
status_b [2]

New target situation:

status_a [1]
status_c [2]
status_b [3]

=> So how could I insert the new status BETWEEN two existing status? There is no such option in admin, is there?

I have seen that the table orders_status has attributes orders_status_id, language_id and orders_status_name.
I could now brutally change the orders_status_id by hand... but I think this would probably then set the status of all my existing order to a new incorrect status, would it not?

Thanks for any advice!

Payment Modules are using the orders_status_id ...

Several tables are using the orders_status_id ...
orders
orders_status_history

Then, there are the settings on the Attribute Settings for Download, if you are using them, to set the range for orders_status_id that are allowed Downloads and the Update orders_status_id for updating Orders with Downloads to allow an extension of settings on Downloads ...

Taking this in steps might help ...

To alter a Live site, you would want to first determine the Old orders_status_id

Example:
Pending orders_status_id 1
Processing orders_status_id 2
Delivered orders_status_id 3
Updated orders_status_id 4

Next, what are you using in your Payment Modules?

Once you know the current state of everything ... you can work out what the new state would be ...

Knowing what you want to use the "New orders_status_id" for, would make it easier to work this out ...

What is the purpose or meaning of the "New orders_status_id" that you want to add?

The new order status would be something in the sense of the following:

"Payment received, article packaged and ready to be sent but not yet sent"

So the order would be the following:

Pending orders_status_id 1
Processing orders_status_id 2
Packaged orders_status_id 3
Delivered orders_status_id 4
Updated orders_status_id 5

Business reason: I bring my packages at 12 am to the post office. If I receive a new order 30min later, I just package it and want to know the client that his order is immediately processed (i.e. packaged and ready to be sent), but status 'delivered' would be wrong because I want with the delivery until next 12 am.

I hope you get the idea....

In theory ... this should work for you ...

Backup your database ...

Did you backup your database?

Create a New Orders Status in the Localization ... Order Status ... for:
Packaged

... this should become orders_status_id 6 ...

Go to the Configuration ... Attributes Settings and change the:
High Value <= 5
Updated = 5

In the Tools ... Install SQL Packages ...

Run the following SQL commands:

UPDATE orders_status SET orders_status_id = 5 WHERE orders_status_id = 4;
UPDATE orders SET orders_status = 5 WHERE orders_status = 4;
UPDATE orders_status_history SET orders_status_id = 5 WHERE orders_status_id = 4;


UPDATE orders_status SET orders_status_id = 4 WHERE orders_status_id = 3;
UPDATE orders SET orders_status = 4 WHERE orders_status = 3;
UPDATE orders_status_history SET orders_status_id = 4 WHERE orders_status_id = 3;


UPDATE orders_status SET orders_status_id = 3 WHERE orders_status_id = 6;

The result in all of this is all Old and Future Orders will use:
Pending orders_status_id 1
Processing orders_status_id 2
Packaged orders_status_id 3
Delivered orders_status_id 4
Updated orders_status_id 5

Next, go to your Modules ... Payment ... and adjust all Payment Modules to use the proper Orders Status based on your changes ...

Hi Linda,

I'm always happy to see a forum post from you, as they are usually spot on.

First YES I did make a database back-up.

What I am trying to do is somewhat similar. I just want to create an order status of Layby, that means we've accepted partial payment, but are not ready to ship (lay-away in the USA).

In any event, when I ran the sequel statement bit, I got:

1062 Duplicate entry '5-1' for key 'PRIMARY'
in:
[UPDATE zen_orders_status SET orders_status_id = 5 WHERE orders_status_id = 4;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Not sure what that first item meant - is 1062 an order number? An error code number? Not sure where to go from here.

By the way, I couldn't quite get my head around the "orders_status_id = 6" because my new "lay-by" is only "5" - as I think was this shop's "Packaged."

Brain is fuzzy today, can you help un-fuzzy it?

Why are you running a SQL for this?

smcelligott:

In any event, when I ran the sequel statement bit, I got:

1062 Duplicate entry '5-1' for key 'PRIMARY'
in:
[UPDATE zen_orders_status SET orders_status_id = 5 WHERE orders_status_id = 4;]

Go to your Zen Cart Admin and in the Localization ... Orders Status ... and Add/edit the Order Status(es) that you need ...

did I misunderstand your last post? wanted to add a new #3 layby status that is less than "delivered."

Go to the Localization ... Order Statuses ...

What do you have right now and what are their values?

Backup your database before running these ...

If a Live Site, set it Down for Maintenance while making these changes ...

Let's say you have:

Pending orders_status_id 1
Processing orders_status_id 2
Delivered orders_status_id 3
Updated orders_status_id 4

and you want a new one:
Packaging orders_status_id 3

Add a New Order Status:
Packaging

and it will be orders_status_id 5

Pending orders_status_id 1
Processing orders_status_id 2
Delivered orders_status_id 3
Updated orders_status_id 4
Packaging orders_status_id 5

Now to adjust everything to make the new Packaging orders_status_id 3 you can run the following SQL statements in phpMyAdmin:

UPDATE orders_status SET orders_status_id = 6 WHERE orders_status_id = 5;

UPDATE orders_status SET orders_status_id = 5 WHERE orders_status_id = 4;
UPDATE orders SET orders_status = 5 WHERE orders_status = 4;
UPDATE orders_status_history SET orders_status_id = 5 WHERE orders_status_id = 4;

UPDATE orders_status SET orders_status_id = 4 WHERE orders_status_id = 3;
UPDATE orders SET orders_status = 4 WHERE orders_status = 3;
UPDATE orders_status_history SET orders_status_id = 4 WHERE orders_status_id = 3;

UPDATE orders_status SET orders_status_id = 3 WHERE orders_status_id = 6;

Now fix the Attribute settings for Downloads ...

Go to the Configuration ... Attribute Settings ... and change the following:
Downloads Controller Update Status Value 5
Downloads Controller Order Status Value >= lower value 3
Downloads Controller Order Status Value <= upper value 5

And, after checking all is correct, take your site off of Down for Maintenance ...