chrometweaks.org

iPage Vs. Hostmonster Vs. Hostgator Vs. Networksolution?

Click Here To View All Answers...


Quick question: iPage Vs. Hostmonster Vs. Hostgator Vs. Networksolution? Looking forward for any comment. Second question of mine... I have done this befor but I cant rember what I did. I need to create a new order status and I need to change the display order of the curent order status's that I have now thanks for the help..

Comments (138)

Hmm... I need to find out myself. I don't know what is the answer to your question. I'll do some research and get back to you if I bump into an answer. You should email the people at iPage as they probably could give you an answer..

Comment #1

Is there a way to change the order the status is displayed?..

Comment #2

In the database. Table orders_status can be switched around in column orders_status_id...

Comment #3

Yea thats what I thought but it's not being ordered by the ID # it's being orderd like this, the numbers in teh () are the ID #.

Pending (#1).

Processing (#2).

Delivered to Coustomer (#4).

Shipped (#3).

I want it to order via the Item #, like this.

Pending (#1).

Processing (#2).

Shipped (#3).

Delivered to Coustomer (#4)..

Comment #4

Sorry, that post was wrong - hence the edit! Vger.

This post has been edited by.

Vger.

: 21 April 2004, 16:35..

Comment #5

:-) anybody it would be nice to get the status ordered in the orger I use them..

Comment #6

In admin/orders.php around line 20.

From what I can tell there is no sort order, if it does return in a particular order, it's just by chance, no guarentee from mysql it will return in order added or order_id..

Sooooooo..

You could change it to the following to have it sort by orders_status_id.

Back you copy of code up first, then try it out and hope it works for you..

Tom..

Comment #7

Virtually same as Tom:.

$orders_status_query = tep_db_query("select orders_status_id, orders_status_name from "TABLE_ORDERS_STATUS" where language_id = '"(int)$languages_id"' order by orders_status_id desc");.

Tom was quicker - just thought I'd post anyways..

This post has been edited by.

Yesudo.

: 24 April 2004, 17:47..

Comment #8

Great minds "almost" always think alike.....

Your (yesudo) version sorts in descending order with the "desc" at the end..

He can pick which way he likes to go.........

This post has been edited by.

OceanRanch.

: 24 April 2004, 17:54..

Comment #9

I always get mixed up with that one meant "asc"..

This post has been edited by.

Yesudo.

: 24 April 2004, 17:58..

Comment #10

Thx, i'll get on that and see if it werks...

Comment #11

Ok it worked where would I also edit to get the admin dir index to also display in this order? thanks again for the help...

Comment #12

Without touching the PHP, there is an easy way .....

In your database ... orders_status.orders_id.

(1) Delete the 3 entries for Delivery..

(2) Optimize your database (or even just that table). This will get rid of the empty rows you just made.

(3) Re-enter the deleted entries. They will now display in the last position in the Admin CP..

If your Delievry status is 4, here's the SQL to re-create them:.

INSERT INTO `orders_status` ( `orders_status_id` , `language_id` , `orders_status_name` ).

VALUES (.

'4', '1', 'Delivered'.

);.

INSERT INTO `orders_status` ( `orders_status_id` , `language_id` , `orders_status_name` ).

VALUES (.

'4', '2', 'Geliefert'.

);.

INSERT INTO `orders_status` ( `orders_status_id` , `language_id` , `orders_status_name` ).

VALUES (.

'4', '3', 'Entregado'.

);..

Comment #13

I have done this befor but I cant rember what I did. I need to create a new order status and I need to change the display order of the curent order status's that I have now thanks for the help..

Comment #14

In admin under Localization/Order Status select and edit Processing, click on update...

Comment #15


This question was taken from a support group/message board and re-posted here so others can learn from it.