Zen Cart Logo
Forums / General Questions / Orders Status display order

Orders Status display order

Views: 1,196

Results 1 to 12 of 12
7 Mar 2014, 10:18 PM
#1
attroll avatar

attroll

Zen Follower

Join Date:
Dec 2007
Posts:
103
Plugin Contributions:
0

Orders Status display order

I have added a few steps in my Order Status menu in the Admin->Localization->Orders Status menu

I would like to change the order in which they display but I don't see how I can do that. Is there a way to change the order?

Here is how it displays now;
Processing
Shipped
Update
Packing Items

Here is how I would like it to display;
Processing
Packing Items
Shipped
Update

7 Mar 2014, 10:36 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Orders Status display order

Do you already have Orders in your store?

If so, what are the current order_status_id on these order statuses:
Processing
Shipped
Update
Packing Items

7 Mar 2014, 10:43 PM
#3
attroll avatar

attroll

Zen Follower

Join Date:
Dec 2007
Posts:
103
Plugin Contributions:
0

Re: Orders Status display order

Ajeh:

Do you already have Orders in your store?

If so, what are the current order_status_id on these order statuses:
Processing
Shipped
Update
Packing Items

Yes, I have orders in my store right now.

The store is still new but currently I have the following in each status.
Processing = 0
Shipped = 2
Update = 0
Packing Items = 1

7 Mar 2014, 10:50 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Orders Status display order

Where did you come up with those orders_status_id numbers? They cannot be 0, unless something is wrong on your site ... :lookaroun

7 Mar 2014, 10:52 PM
#5
gilby avatar

gilby

Totally Zenned

Join Date:
Aug 2005
Location:
Vic, Oz
Posts:
1,816
Plugin Contributions:
0

Re: Orders Status display order

Ajeh:

Where did you come up with those orders_status_id numbers? They cannot be 0, unless something is wrong on your site ... :lookarounI believe the op is refering to the number of orders in his store that currently have this status.

ps: Don't forget the status history when orders_status_id have previously been used and then changed

7 Mar 2014, 11:13 PM
#6
attroll avatar

attroll

Zen Follower

Join Date:
Dec 2007
Posts:
103
Plugin Contributions:
0

Re: Orders Status display order

Yes I was referring to numbers in the store, sorry.

Where do I find the order_status_id that you are referring to?

8 Mar 2014, 12:00 AM
#7
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Orders Status display order

Since it appears that you have only 3 orders, you could change the text on the Order Status and then edit the orders and reset them to the right Order Status by marking them:

Notify Customer: [-No Email or -Hide]

And maybe on the comments just say:
Updating Order Status

If you had more than 3 Orders then we would have to go through a slow, careful rest processes ...

9 Mar 2014, 10:13 PM
#8
attroll avatar

attroll

Zen Follower

Join Date:
Dec 2007
Posts:
103
Plugin Contributions:
0

Re: Orders Status display order

Ajeh:

Do you already have Orders in your store?

If so, what are the current order_status_id on these order statuses:
Processing
Shipped
Update
Packing Items

I figure out what you meant by this and I went into the database and change the order_status_id to the order I want it to display in. The order did change in the drop down menu when editing a customers order status within the order. But the order dose not change on the front page when you log into the store Admin. Is there something I have to do to change the order status on the Admin home page?

9 Mar 2014, 10:23 PM
#9
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Orders Status display order

I do not know what you changed the orders_status_id and their text to ...

If you go to your Zen Cart Admin, what do you see on the Localization ... Orders Status ...

What are the orders_status_id settings on each one?

9 Mar 2014, 10:59 PM
#10
attroll avatar

attroll

Zen Follower

Join Date:
Dec 2007
Posts:
103
Plugin Contributions:
0

Re: Orders Status display order

If I go to Admin > Localization > Order Status here is what I see for the order.
Processing
Packing Items
Shipped
Delivered
-No Email or -Hide

But is I look on the front page when I log into my admin I see this order;
Pending: 0
Processing: 6
Packing Items: 0
Shipped: 9
-No Email or -Hide: 0
Delivered: 0

All I did was go into the database and change the orders_status_id numbers

9 Mar 2014, 11:08 PM
#11
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Orders Status display order

In your Zen Cart Admin, you are going to:
/your_secret_admin/orders_status.php

I am not understanding from the text you are posting where you are as not all of that information shows when looking at the Orders Status list ...

Did you actually make an Orders Status called:
-No Email or -Hide

When you changed those few Orders, did you use your Zen Cart Admin to make the changes or dd you go into phpMyAdmin or something and touch the database tables?

9 Mar 2014, 11:13 PM
#12
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Orders Status display order

> attroll:

All I did was go into the database and change the orders_status_id numbersThat was probably the worst thing you could do, since now the order-status names no longer match the ACTUAL order statuses assigned to each of your orders.
There are several other tables which use those IDs, and when you mangle them in only one table but not all the others, then your data is all mixed up and meaningless.

  1. Go and put back the original values, lest your database become corrupted and your order data get damaged.

  2. Zen Cart presently sorts on the number.
    I suspect you'll need to do two things:
    a) Go to Admin->Localization->Orders Status and put a sort number at the beginning of the name of each status, for the order in which you want them to display
    b) Then rewrite the PHP code to set a different sort order in the database queries that are used to display the sort orders in the pulldown menu.
    I believe I've posted the code for that elsewhere on the forum a few times.