m openmage

OpenMage LTS Developer Documentation

Order Info

Edit this page on GitHub

Module: Mage_Sales

Resource: sales_order

Aliases:

Method:

Allows you to retrieve the required order information.

Aliases:

Arguments:

Type Name Description
string sessionId Session ID
string orderIncrementId
Order increment ID

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
array shipping_address
Array of salesOrderAddressEntity
array billing_address
Array of salesOrderAddressEntity
array items
Array of salesOrderItemEntity
array payment
Array of salesOrderPaymentEntity
array status_history
Array of salesOrderStatusHistoryEntity

The salesOrderAddressEntity content is as follows:

Type Name Description
string increment_id
Increment ID
string
parent_id
Parent ID
string
created_at
Date of creation
string
updated_at
Date of updating
string
is_active
Defines whether the address is active
string
address_type
Address type
string
firstname
First name
string
lastname
Last name
string
company
Company name
string
street
Street name
string
city
City
string
region
Region
string
postcode
Post code
string
country_id
Country ID
string
telephone
Telephone number
string
fax
Fax number
string
region_id
Region ID
string
address_id
Address ID

The salesOrderItemEntity content is as follows:

Type Name Description
string item_id
Item ID
string
order_id
Order ID
string
quote_item_id
Shopping cart item ID
string
created_at
Date of creation
string
updated_at
Date of updating
string
product_id
Product ID
string
product_type
Product type
string
product_options
Product options
string
weight
Weight
string
is_virtual
Defines whether the product is a virtual one
string
sku
Product SKU
string
name
Product name
string
applied_rule_ids
Applied rule IDs
string
free_shipping
Defines whether free shipping is applied
string
is_qty_decimal
Defines whether the items quantity is decimal
string
no_discount
Defines whether no discount is applied
string
qty_canceled
Items quantity canceled
string
qty_invoiced
Items quantity invoiced
string
qty_ordered
Items quantity ordered
string
qty_refunded
Items quantity refunded
string
qty_shipped
Items quantity shipped
string
cost
Cost
string
price
Price
string
base_price
Base price
string
original_price
Original price
string
base_original_price
Base original price
string
tax_percent
Tax percent
string
tax_amount
Tax amount
string
base_tax_amount
Base tax amount
string
tax_invoiced
Tax invoiced
string
base_tax_invoiced
Base tax invoiced
string
discount_percent
Discount percent
string
discount_amount
Discount amount
string
base_discount_amount
Base discount amount
string
discount_invoiced
Discount invoiced
string
base_discount_invoiced
Base discount invoiced
string
amount_refunded
Amount refunded
string
base_amount_refunded
Base amount refunded
string
row_total
Row total
string
base_row_total
Base row total
string
row_invoiced
Row invoiced
string
base_row_invoiced
Base row invoiced
string
row_weight
Row weight
string
gift_message_id
Gift message ID
string
gift_message
Gift message
string
gift_message_available
Defines whether the gift message is available
string
base_tax_before_discount
Base tax before discount
string
tax_before_discount
Tax before discount
string
weee_tax_applied
Applied fixed product tax
string
weee_tax_applied_amount
Applied fixed product tax amount
string
weee_tax_applied_row_amount
Applied fixed product tax row amount
string
base_weee_tax_applied_amount
Applied fixed product tax amount (in base currency)
string
base_weee_tax_applied_row_amount
Applied fixed product tax row amount (in base currency)
string
weee_tax_disposition
Fixed product tax disposition
string
weee_tax_row_disposition
Fixed product tax row disposition
string
base_weee_tax_disposition
Fixed product tax disposition (in base currency)
string
base_weee_tax_row_disposition
Fixed product tax row disposition (in base currency)

The salesOrderPaymentEntity content is as follows:

Type Name Description
string increment_id
Increment ID
string
parent_id
Parent ID
string
created_at
Date of creation
string
updated_at
Date of updating
string
is_active
Active flag
string
amount_ordered
Amount ordered
string
shipping_amount
Shipping amount
string
base_amount_ordered
Base amount ordered
string
base_shipping_amount
Base shipping amount
string
method
Payment method
string
po_number
Purchase order number
string
cc_type
Credit card type
string
cc_number_enc
Credit card number
string
cc_last4
Credit card last 4 digits
string
cc_owner
Credit card owner
string
cc_exp_month
Credit card expiration month
string
cc_exp_year
Credit card expiration year
string
cc_ss_start_month
Credit card start month (Switch/Solo)
string
cc_ss_start_year
Credit card start year (Switch/Solo)
string
payment_id
Payment ID

The salesOrderStatusHistoryEntity content is as follows:

Type Name Description
string increment_id
Increment ID
string
parent_id
Parent ID
string
created_at
Date of creation
string
updated_at
Date of updating
string
is_active
Active flag
string
is_customer_notified
Defines whether the customer is notified
string
status
Order status
string
comment
Order comment

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, 'sales_order.info', 'orderIncrementId');
var_dump($result);

// If you don't need the session anymore
//$client->endSession($session);
Request Example SOAP V2
$proxy = new SoapClient('http://magentohost/api/v2_soap/?wsdl'); // TODO : change url
$sessionId = $proxy->login('apiUser', 'apiKey'); // TODO : change login and pwd if necessary

$result = $proxy->salesOrderInfo($sessionId, '200000006');
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->salesOrderInfo((object)array('sessionId' => $sessionId->result, 'orderIncrementId' => '200000006'));   
var_dump($result->result);
Response Example SOAP V1
array
  'state' => string 'new' (length=3)
  'status' => string 'pending' (length=7)
  'coupon_code' => null
  'protect_code' => string 'defe18' (length=6)
  'shipping_description' => string 'Flat Rate - Fixed' (length=17)
  'is_virtual' => string '0' (length=1)
  'store_id' => string '2' (length=1)
  'customer_id' => string '2' (length=1)
  'base_discount_amount' => string '0.0000' (length=6)
  'base_discount_canceled' => null
  'base_discount_invoiced' => null
  'base_discount_refunded' => null
  'base_grand_total' => string '619.9700' (length=8)
  'base_shipping_amount' => string '10.0000' (length=7)
  'base_shipping_canceled' => null
  'base_shipping_invoiced' => null
  'base_shipping_refunded' => null
  'base_shipping_tax_amount' => string '0.0000' (length=6)
  'base_shipping_tax_refunded' => null
  'base_subtotal' => string '609.9700' (length=8)
  'base_subtotal_canceled' => null
  'base_subtotal_invoiced' => null
  'base_subtotal_refunded' => null
  'base_tax_amount' => string '0.0000' (length=6)
  'base_tax_canceled' => null
  'base_tax_invoiced' => null
  'base_tax_refunded' => null
  'base_to_global_rate' => string '1.0000' (length=6)
  'base_to_order_rate' => string '1.0000' (length=6)
  'base_total_canceled' => null
  'base_total_invoiced' => null
  'base_total_invoiced_cost' => null
  'base_total_offline_refunded' => null
  'base_total_online_refunded' => null
  'base_total_paid' => null
  'base_total_qty_ordered' => null
  'base_total_refunded' => null
  'discount_amount' => string '0.0000' (length=6)
  'discount_canceled' => null
  'discount_invoiced' => null
  'discount_refunded' => null
  'grand_total' => string '619.9700' (length=8)
  'shipping_amount' => string '10.0000' (length=7)
  'shipping_canceled' => null
  'shipping_invoiced' => null
  'shipping_refunded' => null
  'shipping_tax_amount' => string '0.0000' (length=6)
  'shipping_tax_refunded' => null
  'store_to_base_rate' => string '1.0000' (length=6)
  'store_to_order_rate' => string '1.0000' (length=6)
  'subtotal' => string '609.9700' (length=8)
  'subtotal_canceled' => null
  'subtotal_invoiced' => null
  'subtotal_refunded' => null
  'tax_amount' => string '0.0000' (length=6)
  'tax_canceled' => null
  'tax_invoiced' => null
  'tax_refunded' => null
  'total_canceled' => null
  'total_invoiced' => null
  'total_offline_refunded' => null
  'total_online_refunded' => null
  'total_paid' => null
  'total_qty_ordered' => string '2.0000' (length=6)
  'total_refunded' => null
  'can_ship_partially' => null
  'can_ship_partially_item' => null
  'customer_is_guest' => string '0' (length=1)
  'customer_note_notify' => string '1' (length=1)
  'billing_address_id' => string '1' (length=1)
  'customer_group_id' => string '1' (length=1)
  'edit_increment' => null
  'email_sent' => string '1' (length=1)
  'forced_shipment_with_invoice' => null
  'payment_auth_expiration' => null
  'quote_address_id' => null
  'quote_id' => string '1' (length=1)
  'shipping_address_id' => string '2' (length=1)
  'adjustment_negative' => null
  'adjustment_positive' => null
  'base_adjustment_negative' => null
  'base_adjustment_positive' => null
  'base_shipping_discount_amount' => string '0.0000' (length=6)
  'base_subtotal_incl_tax' => string '609.9700' (length=8)
  'base_total_due' => null
  'payment_authorization_amount' => null
  'shipping_discount_amount' => string '0.0000' (length=6)
  'subtotal_incl_tax' => string '609.9700' (length=8)
  'total_due' => null
  'weight' => string '1.2000' (length=6)
  'customer_dob' => null
  'increment_id' => string '200000001' (length=9)
  'applied_rule_ids' => null
  'base_currency_code' => string 'USD' (length=3)
  'customer_email' => string '[email protected]' (length=16)
  'customer_firstname' => string 'johny' (length=5)
  'customer_lastname' => string 'doe' (length=3)
  'customer_middlename' => null
  'customer_prefix' => null
  'customer_suffix' => null
  'customer_taxvat' => null
  'discount_description' => null
  'ext_customer_id' => null
  'ext_order_id' => null
  'global_currency_code' => string 'USD' (length=3)
  'hold_before_state' => null
  'hold_before_status' => null
  'order_currency_code' => string 'USD' (length=3)
  'original_increment_id' => null
  'relation_child_id' => null
  'relation_child_real_id' => null
  'relation_parent_id' => null
  'relation_parent_real_id' => null
  'remote_ip' => string '127.0.0.1' (length=9)
  'shipping_method' => string 'flatrate_flatrate' (length=17)
  'store_currency_code' => string 'USD' (length=3)
  'store_name' => string 'website
English store
English' (length=29)
  'x_forwarded_for' => null
  'customer_note' => null
  'created_at' => string '2012-03-30 11:40:30' (length=19)
  'updated_at' => string '2012-03-30 11:40:32' (length=19)
  'total_item_count' => string '2' (length=1)
  'customer_gender' => null
  'hidden_tax_amount' => string '0.0000' (length=6)
  'base_hidden_tax_amount' => string '0.0000' (length=6)
  'shipping_hidden_tax_amount' => string '0.0000' (length=6)
  'base_shipping_hidden_tax_amnt' => string '0.0000' (length=6)
  'hidden_tax_invoiced' => null
  more elements...