m openmage

OpenMage LTS Developer Documentation

Order List

Edit this page on GitHub

Module: Mage_Sales

Resource: sales_order

Aliases:

Method:

Allows you to retrieve the list of orders. Additional filters can be applied.

Aliases:

Arguments:

Type Name Description
string sessionId Session ID
array filters Array of filters for the list of sales orders (optional)

Returns:

Type name Description
array result Array of salesOrderEntity

The salesOrderEntity content is as follows:

Type Name Description
string increment_id
Increment ID
string
parent_id
Parent ID
string
store_id
Store ID
string
created_at
Date of creation
string
updated_at
Date of updating
string
is_active
Defines whether the order is active
string
customer_id
Customer ID
string
tax_amount
Tax amount
string
shipping_amount
Shipping amount
string
discount_amount
Discount amount
string
subtotal
Subtotal sum
string
grand_total
Grand total sum
string
total_paid
Total paid
string
total_refunded
Total refunded
string
total_qty_ordered
Total quantity ordered
string
total_canceled
Total canceled
string
total_invoiced
Total invoiced
string
total_online_refunded
Total online refunded
string
total_offline_refunded
Total offline refunded
string
base_tax_amount
Base tax amount
string
base_shipping_amount
Base shipping amount
string
base_discount_amount
Base discount amount
string
base_subtotal
Base subtotal
string
base_grand_total
Base grand total
string
base_total_paid
Base total paid
string
base_total_refunded
Base total refunded
string
base_total_qty_ordered
Base total quantity ordered
string
base_total_canceled
Base total canceled
string
base_total_invoiced
Base total invoiced
string
base_total_online_refunded
Base total online refunded
string
base_total_offline_refunded
Base total offline refunded
string
billing_address_id
Billing address ID
string
billing_firstname
First name in the billing address
string
billing_lastname
Last name in the billing address
string
shipping_address_id
Shipping address ID
string
shipping_firstname
First name in the shipping address
string
shipping_lastname
Last name in the shipping address
string
billing_name
Billing name
string
shipping_name
Shipping name
string
store_to_base_rate
Store to base rate
string
store_to_order_rate
Store to order rate
string
base_to_global_rate
Base to global rate
string
base_to_order_rate
Base to order rate
string
weight
Weight
string
store_name
Store name
string
remote_ip
Remote IP
string
status
Order status
string
state
Order state
string
applied_rule_ids
Applied rule IDs
string
global_currency_code
Global currency code
string
base_currency_code
Base currency code
string
store_currency_code
Store currency code
string
order_currency_code
Order currency code
string
shipping_method
Shipping method
string
shipping_description
Shipping description
string
customer_email
Email address of the customer
string
customer_firstname
Customer first name
string
customer_lastname
Customer last name
string
quote_id
Shopping cart ID
string
is_virtual
Defines whether the product is a virtual one
string
customer_group_id
Customer group ID
string
customer_note_notify
Customer notification
string
customer_is_guest
Defines whether the customer is a guest
string
email_sent
Defines whether the email notification is sent
string
order_id
Order ID
string
gift_message_id
Gift message ID
string
gift_message
Gift message

Examples

Request Example SOAP V1
$client = new SoapClient('http://magentohost/api/soap/?wsdl');

// If somestuff requires API authentication,
// then get a session token
$session = $client->login('apiUser', 'apiKey');

$result = $client->call($session, 'order.list');
var_dump ($result);
Request Example SOAP V2
$params = array(array(
            'filter' => array(
                array(
                    'key' => 'status',
                    'value' => 'pending'
                ),
                array(
                    'key' => 'created_at',
                    'value' => '2001-11-25 12:12:07',
                )
            ),
            'complex_filter' => array(
                array(
                    'key' => 'order_id',
                    'value' => array(
                        'key' => 'in',
                        'value' => '12,23'
                    ),
                ),
                array(
                    'key' => 'protect_code',
                    'value' => array(
                        'key' => 'eq',
                        'value' => 'ebb2a0'
                    ),
                ),
            )
        ));

$result = $client->__call('salesOrderList', $params);
Request Example SOAP V2 (Simple Filter)
$client = new SoapClient('http://magentohost/api/v2_soap/?wsdl');

// If some stuff requires API authentication,
// then get a session token
$session = $client->login('apiUser', 'apiKey');
$filter = array('filter' => array(array('key' => 'status', 'value' => 'closed')));
$result = $client->salesOrderList($session, $filter);

var_dump ($result);
Request Example SOAP V2 (WS-I Compliance Mode)
$proxy = new SoapClient('http://magentohost/api/v2_soap/?wsdl'); 

$sessionId = $proxy->login((object)array('username' => 'apiUser', 'apiKey' => 'apiKey')); 
 
$result = $proxy->salesOrderList((object)array('sessionId' => $sessionId->result, 'filters' => null));   
var_dump($result->result);
XML SOAP V2 Example
SOAP "v2" XML Request
<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="urn:Magento"
                   xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                   xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
                   SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
    <SOAP-ENV:Body>
        <ns1:salesOrderList>
            <sessionId xsi:type="xsd:string">abbc417256a3ffb93d130a77a2fd3665</sessionId>
            <filters xsi:type="ns1:filters">
                <filter SOAP-ENC:arrayType="ns1:associativeEntity[2]" xsi:type="ns1:associativeArray">
                    <item xsi:type="ns1:associativeEntity">
                        <key xsi:type="xsd:string">status</key>
                        <value xsi:type="xsd:string">pending</value>
                    </item>
                    <item xsi:type="ns1:associativeEntity">
                        <key xsi:type="xsd:string">created_at</key>
                        <value xsi:type="xsd:string">2011-11-29 15:41:11</value>
                    </item>
                </filter>
                <complex_filter SOAP-ENC:arrayType="ns1:complexFilter[2]" xsi:type="ns1:complexFilterArray">
                    <item xsi:type="ns1:complexFilter">
                        <key xsi:type="xsd:string">order_id</key>
                        <value xsi:type="ns1:associativeEntity">
                            <key xsi:type="xsd:string">in</key>
                            <value xsi:type="xsd:string">Array</value>
                        </value>
                    </item>
                    <item xsi:type="ns1:complexFilter">
                        <key xsi:type="xsd:string">protect_code</key>
                        <value xsi:type="ns1:associativeEntity">
                            <key xsi:type="xsd:string">in</key>
                            <value xsi:type="xsd:string">a4ffa8</value>
                        </value>
                    </item>
                </complex_filter>
            </filters>
        </ns1:salesOrderList>
    </SOAP-ENV:Body>
</SOAP-ENV:Envelope>