Magento constants for invoice shipment order state and statuses
1/ Invoice statuses:
/**#@+
* Invoice states
*/
const STATE_OPEN = 1;
const STATE_PAID = 2;
const STATE_CANCELED = 3;
2/ Shipment statuses:
CASE
WHEN shipment_status = 1 THEN 'New'
WHEN shipment_status = 2 THEN 'Ready To Print'
WHEN shipment_status = 3 THEN 'Printed'
WHEN shipment_status = 4 THEN 'Shipped'
WHEN shipment_status = 5 THEN 'Invoiced'
WHEN shipment_status = 6 THEN 'Complete'
WHEN shipment_status = 7 THEN 'Canceled'
WHEN shipment_status = 8 THEN 'Holded'
WHEN shipment_status = 9 THEN 'Checked'
WHEN shipment_status = 10 THEN 'Ready For Pickup'
WHEN shipment_status = 11 THEN 'Picked Up'
ELSE 'N/A'
END AS shipment_status_text