Order Status

[wgeppert]

Hi folks,

 

the order process uses order status, in DB order table it is named as current_state. This state is used as enum and stored as integer but I can't find any documentation about the numbering of state 

• Awaiting bank wire payment.
• Awaiting Cash on Delivery validation.
• Awaiting cheque payment.
• Awaiting PayPal payment.
• Canceled.
• Delivered.
• On backorder.
• Payment accepted.
• Payment error.
• Payment remotely accepted.
• Preparation in progress.
• Refunded.
• Shipped.

1. Does anybody know the enum values (no guess please)?

 

2. And what is the WHERE clause from  ps_order for a fresh, new order?

 

3. Is it not harmfull to extend it with other states like

 

• Picking
• Packing
• WaitingPickup
• InTransit

 

[rocky]

1. They are stored in the ps_configuration table of your database. Search for the names starting with PS_OS_

 

2. It's the id_last_order field in the ps_employee table that determines which orders are considered new for the current employee. Gets all orders from the ps_orders table with an id_order greater than the id_last_order to get new orders only.

 

3. You can rename existing order statuses and add new ones on the Orders > Statuses tab in the Back Office.

[K@s]

HI.

and the status ids are stored in this table "ps_order_state" .