Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Order State and Order Status
 
Prad
Member
 
Total Posts:  72
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