Try the Demo

Magento Forum

   
Order State and Order Status
 
Prad
Member
 
Total Posts:  70
Joined:  2008-11-12
 

Hi,

Have been looking through “sales_flat_order” table lately and found two different terms “order state” and “order status”.
Can anyone explain what is the difference between “order state” and “order status”?

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
Finn
Member
 
Total Posts:  75
Joined:  2008-12-03
Finland & The Netherlands
 

Hi Pradino,

Easiest way to illustrate this difference is by having a look at the config that defines this. You can find it in: app/code/code/Mage/Sales/etc/config.xml and looks like this (payment_review in the bottom is the best example since this state has 2 statuses):

<order>
                <
statuses>
                    <
pending translate="label"><label>Pending</label></pending>
                    <
pending_payment translate="label"><label>Pending Payment</label></pending_payment>
                    <
processing translate="label"><label>Processing</label></processing>
                    <
holded translate="label"><label>On Hold</label></holded>
                    <
complete translate="label"><label>Complete</label></complete>
                    <
closed translate="label"><label>Closed</label></closed>
                    <
canceled translate="label"><label>Canceled</label></canceled>
                    <
fraud translate="label"><label>Suspected Fraud</label></fraud>
                    <
payment_review translate="label"><label>Payment Review</label></payment_review>
                </
statuses>
                <
states>
                    <new 
translate="label">
                        <
label>New</label>
                        <
statuses>
                            <
pending default="1"/>
                        </
statuses>
                        <
visible_on_front/>
                    </new>
                    <
pending_payment translate="label">
                        <
label>Pending Payment</label>
                        <
statuses>
                            <
pending_payment default="1"/>
                        </
statuses>
                    </
pending_payment>
                    <
processing translate="label">
                        <
label>Processing</label>
                        <
statuses>
                            <
processing default="1"/>
                        </
statuses>
                        <
visible_on_front/>
                    </
processing>
                    <
complete translate="label">
                        <
label>Complete</label>
                        <
statuses>
                            <
complete default="1"/>
                        </
statuses>
                        <
visible_on_front/>
                    </
complete>
                    <
closed translate="label">
                        <
label>Closed</label>
                        <
statuses>
                            <
closed default="1"/>
                        </
statuses>
                        <
visible_on_front/>
                    </
closed>
                    <
canceled translate="label">
                        <
label>Canceled</label>
                        <
statuses>
                            <
canceled default="1"/>
                        </
statuses>
                        <
visible_on_front/>
                    </
canceled>
                    <
holded translate="label">
                        <
label>On Hold</label>
                        <
statuses>
                            <
holded default="1"/>
                        </
statuses>
                        <
visible_on_front/>
                    </
holded>
                    <
payment_review translate="label">
                        <
label>Payment Review</label>
                        <
statuses>
                            <
payment_review default="1"/>
                            <
fraud/>
                        </
statuses>
                        <
visible_on_front/>
                    </
payment_review>
                </
states>
            </
order>

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top