• Welcome to KonaKart Community Forum. Please login or sign up.
 

OrderStatus ids

Started by ryanlynch, October 03, 2008, 11:10:06 pm

Previous topic - Next topic

ryanlynch

Hi there -

Is there documentation anywhere that states what the different orderstatus id's represent??

For example.. I see this in my console:

The order with id = 123 has just changed state from stateId = 4 to stateId = 5

What I would like to know is what is the orderstatus id that represents a new payment received order

Thanks!

Brian

These can be defined by KonaKart Administrators so you should look in the Admin App or in your database:

SELECT * FROM orders_status;

--Brian

ryanlynch

Thank you, I found them.

Also, if I could inquire about AdminOrderSearch in the API -- there is a orderBy field (int), and I am wondering if you can tell me how the int relates to the data... in another words, how do I know what int relates to the possible orderBy values

ryanlynch

Nevermind -- I misread it -- my mistake

Brian

I think it's a good question Ryan!, and since I've looked it up, here is the answer:

You can use these constants:

AdminDataDescriptor.ORDER_BY_CUSTOMERS_NAME_ASCENDING
AdminDataDescriptor.ORDER_BY_CUSTOMERS_NAME_DESCENDING
AdminDataDescriptor.ORDER_BY_ORDER_ID_ASCENDING
AdminDataDescriptor.ORDER_BY_ORDER_ID_DESCENDING
AdminDataDescriptor.ORDER_BY_DATE_PURCHASED_ASCENDING
AdminDataDescriptor.ORDER_BY_DATE_PURCHASED_DESCENDING
AdminDataDescriptor.ORDER_BY_ORDER_TOTAL_ASCENDING
AdminDataDescriptor.ORDER_BY_ORDER_TOTAL_DESCENDING
AdminDataDescriptor.ORDER_BY_ORDER_STATUS_ASCENDING
AdminDataDescriptor.ORDER_BY_ORDER_STATUS_DESCENDING

Default is:

AdminDataDescriptor.ORDER_BY_CUSTOMERS_NAME_ASCENDING and then
AdminDataDescriptor.ORDER_BY_ORDER_ID_ASCENDING

--Brian

ryanlynch

Thank you! This will save me some time :)