Query order

Requires read_orders access scope.

For more info , refer to:

[]

access permission

GET https://{handle}.myshopline.com/admin/openapi/v20230901/orders.json

[]

handle : The store's unique identifier, which is the prefix of the store's domain name. For example, if a store's domain name is open001.myshopline.com , the store handle is open001 .

[]

Query order details in batches based on request conditions

Query Parameters

buyer_id string
[]
Order user id
[]
Example: 4201057495
contract_ids string
[]
Subscription contract id, multiples separated by commas, up to 50
[]
Example: 3005619945158043247856
created_at_max string
[]
Order creation time (end) (see IOS8601 for the format)
[]
Example: 2021-08-18T23:59:59+08:00
created_at_min string
[]
Order creation time (start) (see IOS8601 for the format)
[]
Example: 2021-08-04T23:59:59+08:00
email string
[]
The email of the user who placed the order
[]
Example: Washingtontest@gmail.com
fields string
[]
The fields to be queried, separated by commas, do not pass all field information, currently all fields are returned
[]
Example: id
financial_status string
[]
Payment status: unpaid-unpaid; pending-pending; partially_paid-partially paid; paid-paid; partially_refunded-partially refunded; refunded-refunded;
[]
Example: unpaid
fulfillment_status string
[]
Shipping status, unshipped-unshipped; partial-partially shipped; shipped-shipped;
[]
Example: unshipped
hidden_order boolean
[]
Whether it is an archived order, true=archived order, false=unarchived order
ids string
[]
Order numbers, separated by commas, up to 100
[]
Example: "21050224312121887324667162, 21050224312121887324667164"
limit integer
[]
The number of queries is limited, the default is 50, and it cannot exceed 100
[]
Example: 10
name string
[]
custom order number
[]
Example: D2034
page_info string
[]
The encrypted request parameters are used for the previous page and the next page, and the field is directly parsed and accessed.
[]
Example: 7AFD7393C6E7CF18672C038477E2EF6A463464BDBAF766DD8F8CB8E0085F82419A94B80084BCDA0B838B3F13C302A2C9044E
search_content string
[]
Search content, involving order number, payment serial number, courier order number, product name, product sku number, order amount
[]
Example: D203
since_id string
[]
The starting position of the order number ID of the data to be queried
[]
Example: 21056199447626881527947685
sort_condition string
[]
Sorting: Format such as: orderTime
, orderSeq
Multiple sorts are separated by commas; Sorting rules: such as orderTime
, orderSeq
, first sort by orderTime in reverse order, then orderSeq in positive order
[]
Example: orderTime: desc
status string
[]
Order status, open-processing, canceled-cancelled, any-including any status, including archived;
[]
Example: open
updated_at_max string
[]
Order update time (end) (see IOS8601 for the format)
[]
Example: 2021-08-18T23:59:59+08:00
updated_at_min string
[]
Order update time (start) (see IOS8601 for the format)
[]
Example: 2021-08-04T23:59:59+08:00

Request Headers

Content-Type required
[]
The value of this field is fixed to application/json; charset=utf-8
Authorization string required
[]
The access token for the API. Please refer to App authorization to obtain the access token, and then put the obtained access token into the API request header in Bearer Token.
Example:
[]
Bearer eyJhbGciOiJIUzUxMiJ9.eyJhcHBLZXkiOiJmMjM3OWQyMTYyOGMzM2QxMWRiMWZkYjY5N2EzZjdjMjZlNGMwYTA5Iiwic2VsbGVySWQiOiIyMDAwMjM0ODgwIiwic3RvcmVJZCI6IjE2NzIzNjk3Mjk2MDYiLCJ2ZXJzaW9uIjoiVjIiLCJkb21haW4iOiJodHRwczovL3NsLW9wZW4tc2cubXlzaG9wbGluZS5jb20iLCJ0aW1lc3RhbXAiOjE2NzUzMTk0OTI0MzksImlzcyI6Inlzb3VsIiwiZXhwIjoxNzY5OTI3NDkyfQ.UwQzomM2veGCUaOZ0paUxq5dpc7DXuhHYFvsQ_uIAKduzWcb_j2E4q_36El83sp145D4cKbpcE5KCeeIz-JNQw

Response

[]

For more information about status codes, see Http status code.

Response Headers

link
[]
Contain the request parameters of the previous page and the next page
traceId
[]
traceId

Response Body

ordersobject[]
[]
Datasheets
adjust_price string
[]
Adjust the amount, the balance amount caused by the rounding of the amount in the pos scenario
[]
Example: 8.00
adjust_price_setobject
[]
Adjustment amount information denominated in store currency and transaction currency
presentment_moneyobject
[]
Buyer side amount information
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
shop_moneyobject
[]
Sell side amount information
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
billing_addressobject
[]
Billing address information
address1 string
[]
Detailed address 1
[]
Example: Address 1
address2 string
[]
Detailed address 2, optional
[]
Example: Address 2
city string
[]
City
[]
Example: New York
company string
[]
Company Name
[]
Example: new company name
country string
[]
Country
[]
Example: U.S.
country_code string
[]
Country code
[]
Example: US
first_name string
[]
Last name
[]
Example: tom
last_name string
[]
First name
[]
Example: Washington
name string
[]
Full name
[]
Example: test1001
phone string
[]
Phone
[]
Example: 13100000000
province string
[]
Province
[]
Example: California
province_code string
[]
Province code
[]
Example: 4200006
zip string
[]
Postal code
[]
Example: 92503
browser_ip string
[]
Client IP
[]
Example: 157.119.232.35
buyer_note string
[]
Buyer message
[]
Example: message
cancel_reason string
[]
Seller's reason for cancellation
[]
Example: I don't want to buy it.
cancelled_at string
[]
Order cancellation time (end) (see IOS8601 for the format), 2012-05-01T14:22:25-04:00
[]
Example: 2012-05-01T14:22:25-04:00
cart_token string
[]
shopping cart token
[]
Example: c2c4a58186b9d96395d7e6b5c2969577
checkout_id string
[]
Abandonment id
[]
Example: 2404785166526352972864
checkout_token string
[]
Settlement page token
[]
Example: c2c4a58186b9d96395d7e6b5c2969577
client_detailsobject
[]
Client Details
browser_ip string
[]
browser address
[]
Example: 157.119.232.35
session_hash string
[]
Member session encryption information
[]
Example: c2c4a58186b9d96395d7e6b5c2969577
user_agent string
[]
Client Proxy
[]
Example: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Sa
contract_seq string
[]
Subscription contract number
[]
Example: 3005619945158043247856
created_at string
[]
Order creation time, system record (see IOS8601 for format)
[]
Example: 2021-08-16T08:27:57+00:00
currency string
[]
Transaction currency
[]
Example: "USD"
current_subtotal_price string
[]
Sum of current products, total price of products * quantity
[]
Example: "78.0"
current_subtotal_price_setobject
[]
Multi-currency information of the current commodity sum, the buyer's and seller's currency and the amount are the same
presentment_moneyobject
[]
Buy side currency
amount string
[]
Amount
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
shop_moneyobject
[]
Sell side currency
amount string
[]
Amount
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
current_total_discounts string
[]
Sum of discounts, precision 2, marketing offers + artificial discounts
[]
Example: "0.0"
current_total_discounts_setobject
presentment_moneyobject
[]
Currency information
amount string
[]
Amount
[]
Example: 8.00
currency_code string
[]
Currency information
[]
Example: USD
shop_moneyobject
[]
Sell side amount
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency code
[]
Example: USD
current_total_duties_setobject
[]
the duty amount info of current duty
presentment_moneyobject
[]
presentment amount info
amount string
[]
presentment amount
[]
Example: 8.88
currency_code string
[]
presentment currency
[]
Example: USD
shop_moneyobject
[]
shop amount info
amount string
[]
shop amount
[]
Example: 8.88
currency_code string
[]
shop currency
[]
Example: USD
current_total_price string
[]
Current order total, value logic: total product - total discount + shipping + tax
[]
Example: “60.0”
current_total_price_setobject
[]
Multi-currency information of the current order total, the buyer's and seller‘s currency and the amount are the same
presentment_moneyobject
[]
Currency information
amount string
[]
Amount
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
shop_moneyobject
[]
Sell side amount
amount string
[]
Amount
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
current_total_tax string
[]
Total tax, product tax + shipping tax
[]
Example: "0.0"
current_total_tax_setobject
[]
Multi-currency information of the sum of taxes, the currency and amount of buyers and sellers are the same
presentment_moneyobject
[]
Buy side currency
amount string
[]
Amount
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
shop_moneyobject
[]
Sell side currency
amount string
[]
Amount
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
customerobject
[]
Buyer information
addressesobject
[]
Buyer address information
address1 string
[]
Detailed address 1
[]
Example: Wanda
address2 string
[]
Detailed address 2, optional
[]
Example: 65788
city string
[]
City
[]
Example: Yangquan City
country string
[]
Country
[]
Example: China
country_code string
[]
Country code
[]
Example: CN
first_name string
[]
Last name
[]
Example: tom
last_name string
[]
First name
[]
Example: Washington
name string
[]
Full name
[]
Example: D203
phone string
[]
Phone
[]
Example: 13100000000
province string
[]
Province
[]
Example: Shanxi Province
province_code string
[]
Province code
[]
Example: asd
zip string
[]
Postal code
[]
Example: 521000
area_code string
[]
Phone area code
[]
Example: +86
created_at string
[]
Buyer creation time (see IOS8601 for the format)
[]
Example: 2022-11-04T10:18:46+00:00
currency string
[]
Currency
[]
Example: USD
email string
[]
User mailbox
[]
Example: Washingtontest@gmail.com
first_name string
[]
First name
[]
Example: tom
id string
[]
User ID
[]
Example: 4201057495
last_name string
[]
Last name
[]
Example: Washington
phone string
[]
User mobile phone number
[]
Example: 13100000000
updated_at string
[]
Buyer update time
[]
Example: 2022-11-04T10:18:46+00:00
customer_locale string
[]
Buyer country, language code + country name abbreviation
[]
Example: "enCN"
deduct_member_point_amount string
[]
Current order membership credit
[]
Example: 8.00
deduct_member_point_amount_setobject
[]
Current order membership credit to the amount , multi-currency amount information
presentment_moneyobject
[]
Current order membership credit to the amount , market amount information
amount string
[]
Current order membership credit to the marketplace amount
[]
Example: 8.00
currency_code string
[]
Market currency
[]
Example: CNY
shop_moneyobject
[]
Current order membership credit amount , store amount information
amount string
[]
Current order membership credit to the store amount
[]
Example: 1.00
currency_code string
[]
Store currency
[]
Example: USD
discount_applicationsobject[]
[]
discount information
allocation_method string
[]
The scope of distributed authorization 1) across (the value is distributed in all authorization lines) 2) each (the value is applied to each authorization line) allocation_method
[]
Example: across
code string
[]
discount code
[]
Example: 82UD6BTPX9L2
description string
[]
Description of custom discount
[]
Example: Description of custom discount
target_selection string
[]

explicit (discount is assigned to explicitly selected rows) 2) all (discount is assigned to all rows) 3) ENTITLED (discount is assigned only to the rows it is entitled to use)

[]
Example: explicit
target_type string
[]

line_item, shipping_line

[]
Example: line_item
title string
[]
automatic discount title
[]
Example: automatic discount title
type string
[]
Discount type, 1) manual 2) automatic 3) discount_code
[]
Example: manual
value string
[]
The specific value of the discount (it can be N discount or a specific amount)
[]
Example: 2.01
value_type string
[]
Explain the type of value
[]
Example: fixed_amount
discount_codesobject[]
[]
Promo code information
amount string
[]
Discount amount, precision 2
[]
Example: 8.00
amount_setobject
[]
Discount marketplace amount information
presentment_moneyobject
[]
Marketplace amount information
amount string
[]
Discount amount , market amount
[]
Example: 70.00
currency_code string
[]
Market currency
[]
Example: CNY
shop_moneyobject
[]
Store amount information
amount string
[]
Discount amount
[]
Example: 10.00
currency_code string
[]
Store currency
[]
Example: USD
code string
[]
Promo code
[]
Example: KIN4GNAB2FRH
type string
[]
Type of discount, reduced amount; discount; free shipping; fixed price; the lowest price item is free; package price; the Nth item is discounted;
[]
Example: deduction amount
email string
[]
Buyer's mailbox, there must be one of the two
[]
Example: hok@shoplineapp.com
financial_status string
[]
Payment status, unpaid, authorized, pending, partially_paid, paid, partially_refunded, refunded
[]
Example: "paid"
fulfillment_status string
[]
Shipping status, fulfilled-shipped; partial-partially shipped; null-unshipped; Note: the returned enum value is different from the query enumeration value of the input parameter
[]
Example: "fulfilled"
fulfillmentsobject[]
[]
Package information
created_at string
[]
Creation time (see IOS8601 for the format)
[]
Example: 2022-11-04T10:18:46+00:00
id string
[]
Package number
[]
Example: 22046737798141702810214336
line_itemsobject[]
[]
Product list
attribute string
[]
Commodity attribute: name - attribute value multiple separated by comma ", " such as: color - red, size - X
[]
Example: red
fulfillable_quantity integer
[]
Available quantity
[]
Example: 1
fulfillment_quantity integer
[]
Shipping quantity
[]
Example: 1
fulfillment_service string
[]
Logistics company name
[]
Example: SF Express
fulfillment_status string
[]
The shipping status of the product, shipping status, fulfilled-shipped; partial-partially shipped; null-unshipped;
[]
Example: not shipped
grams double
[]
Weight ( grams )
[]
Example: 100
id string
[]
The ID of the product snapshot table, generated by the system, uniquely confirms a product with the order number
[]
Example: 100
image_url string
[]
product picture
[]
Example: https://d2n979dmt31clo.cloudfront.net/image/store/4211449909/1667384795847/63928f08a7174ab2958c6a969
location_id string
[]
Unique code of pickup location
[]
Example: 5445886274929439997
name string
[]
SKU title, same as title
[]
Example: Product name
price string
[]
Commodity price, precision 2
[]
Example: 10.00
price_setobject
[]
Product selling price , multi-currency amount information
presentment_moneyobject
[]
Marketplace amount information
amount string
[]
Product selling price , market currency price
[]
Example: 70.0
currency_code string
[]
Market currency
[]
Example: CNY
shop_moneyobject
[]
Store amount information
amount string
[]
Product selling price , store currency price
[]
Example: 10.00
currency_code string
[]
Currency
[]
Example: USD
product_id string
[]
SPU serial number
[]
Example: 16056761559984840457934011
quantity integer
[]
Quantity of items in the order
[]
Example: 1
requires_shipping boolean
[]
Shipping or not
[]
Example: true
sku string
[]
Product code, barCode
[]
Example: test-002
tax_linesobject[]
[]
Tax information
price string
[]
Tax, precision 2
[]
Example: 8.00
price_setobject
[]
Multi-currency information of tax
presentment_moneyobject
[]
Currency information
amount string
[]
Description amount
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
shop_moneyobject
[]
Sell side amount information
amount string
[]
Amount
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
rate double
[]
Tax rate
[]
Example: 1
title string
[]
Tax name
[]
Example: tax
taxable boolean
[]
Tax or not？
title string
[]
Product title
[]
Example: useful product
variant_id string
[]
Product SKU serial number
[]
Example: 18056761559987524812644011
variant_title string
[]
Commodity attribute value, multiple divided by " / ", such as: "155 / red / large"
[]
Example: big
vendor string
[]
Supplier
[]
Example: Supplier
name string
[]
invoice short number
[]
Example: 1032-F2
order_id string
[]
Order number
[]
Example: 21056577640603870897253153
shipment_status string
[]
Package tracking
[]
Example: fulfilled
status string
[]
Logistics delivery status, success-shipped; cancelled-cancelled;
[]
Example: cancelled
tracking_company string
[]
Logistics company name
[]
Example: SF International
tracking_number string
[]
Third party tracking number
[]
Example: yun0001
tracking_url string
[]
Logistics company URL
[]
Example: https://www.sf-international.com/
updated_at string
[]
Update time (see IOS8601 for the format)
[]
Example: 2022-11-04T10:18:46+00:00
hidden_order boolean
[]
Whether it is an archived order, true=archived order, false=unarchived order
id string
[]
Order number, system custom number
[]
Example: 21050224312121887324667162
landing_site string
[]
Link to record complete suffix information
[]
Example: https://www.url.com
line_itemsobject[]
[]
Order product snapshot information
attribute string
[]
Commodity attribute: name - attribute value multiple separated by comma ", " such as: color - red, size - X
[]
Example: red
country_code_of_origin string
[]
Country of origin
[]
Example: Country of origin
customized_attributesobject[]
[]
Item Custom Attributes
key string
[]
Custom attribute name key
[]
Example: "businessType"
value string
[]
Product custom attribute value, such as: when the key is businessType, the value is 3 (representing a gift)
[]
Example: "3"
discount_allocationsobject[]
[]
Marketing discount detail amount multi-currency
amount string
[]
Discount detail amount
[]
Example: 8.00
amount_setobject
[]
Discount Details Amount Multi-Currency
presentment_moneyobject
[]
payment currency
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
shop_moneyobject
[]
Store currency
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
discount_application_index integer
[]
Indicate the location in the discount details
[]
Example: 1
dutiesobject[]
[]
Duty information
country_code_of_origin string
[]
Country code from country of origin / shipping place
[]
Example: USD
harmonized_system_code string
[]
Customs code
[]
Example: A0023
id string
[]
Duty code
[]
Example: H2325
priceobject
[]
Duty multi-currency information
presentment_moneyobject
[]
Buyer side amount information
amount string
[]
Amount
[]
Example: 8.88
currency_code string
[]
Currency
[]
Example: USD
shop_moneyobject
[]
Sell side amount information
amount string
[]
Amount
[]
Example: 8.88
currency_code string
[]
Currency
[]
Example: USD
tax_linesobject[]
[]
Tax details list
price_setobject
[]
Multi-currency information of tax
presentment_moneyobject
[]
Buyer side amount information
amount string
[]
Amount
[]
Example: 8.88
currency_code string
[]
Currency
[]
Example: USD
shop_moneyobject
[]
Sell side amount information
amount string
[]
Amount
[]
Example: 8.88
currency_code string
[]
Currency
[]
Example: USD
rate double
[]
Tax rate
rate_percentage double
[]
Tax rates ( values of 100 percent ratio , rate * 100 )
title string
[]
Tax title
fulfillable_quantity integer
[]
Available quantity
[]
Example: 1
fulfillment_service string
[]
Logistics company name
[]
Example: SF International
fulfillment_status string
[]
The shipping status of the product, shipping status, fulfilled-shipped; partial-partially shipped; null-unshipped;
[]
Example: fulfilled
gift_card boolean
[]
Is it a gift card product
[]
Example: true
grams double
[]
Weight ( grams )
[]
Example: 100
harmonized_system_code string
[]
Harmonized system code
[]
Example: Harmonized system code
id string
[]
The ID of the product snapshot table, generated by the system, uniquely confirms a product with the order number
[]
Example: 417
image_url string
[]
product picture
[]
Example: https://d2n979dmt31clo.cloudfront.net/image/store/4211449909/1667384795847/63928f08a7174ab2958c6a969
location_id string
[]
Unique code of pickup location
[]
Example: 5327026538935748524
name string
[]
SKU title, same as title
[]
Example: Product title
price string
[]
Commodity price, precision 2
[]
Example: 8.00
price_setobject
[]
Commodity price, precision 2
presentment_moneyobject
[]
Product selling price , market currency
amount string
[]
Product selling price , market currency amount
[]
Example: 80.00
currency_code string
[]
Market currency
[]
Example: CNY
shop_moneyobject
[]
Product selling price , store currency
amount string
[]
Product selling price , store currency
[]
Example: 10
currency_code string
[]
Market currency
[]
Example: USD
product_id string
[]
SPU serial number
[]
Example: 16056761559984840457934011
propertiesobject[]
[]
Product customization information
additional string
[]
Additional Fields for Custom Items
[]
Example: additional fields
name string
[]
Custom attribute name
[]
Example: Attribute name
type string
[]
Attribute type, text-character, the display format is name: value; picture-picture, the display type is name: get the rendered thumbnail through URLs; link-hyperlink, the display type is name: value, supports clicking on the link to jump to urls First
[]
Example: text
urls array
[]
URL resource list
[]
Example: https://www.url.com
value string
[]
Custom attribute values
[]
Example: Attribute value
quantity integer
[]
Quantity of items in the order
[]
Example: 1
requires_shipping boolean
[]
Shipping or not
[]
Example: true
sku string
[]
Product code, barCode
[]
Example: 18056761559987524812644011
tags string
[]
Commodity tags (separated by multiple commas)
[]
Example: watch
tax_linesobject[]
[]
Tax information
price string
[]
Tax, precision 2
[]
Example: 8.00
price_setobject
[]
Multi-currency information of tax
presentment_moneyobject
[]
Buy side currency
amount string
[]
Amount
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
shop_moneyobject
[]
Sell side currency
amount string
[]
Amount
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
rate double
[]
Tax rate
[]
Example: 1
title string
[]
Tax name
[]
Example: tax
type string
[]
Tax fee type, used to distinguish whether it is commodity tax or freight tax, the enumerated values are as follows product_tax: commodity tax shipping_tax: freight tax
[]
Example: shipping_tax
taxable boolean
[]
Tax or not？
[]
Example: true
title string
[]
Product title
[]
Example: beautiful dress
variant_id string
[]
Product SKU serial number
[]
Example: 18056761559987524812644011
variant_title string
[]
Commodity attribute value, multiple divided by " / ", such as: "155 / red / large"
[]
Example: big
vendor string
[]
Supplier
[]
Example: Supplier
locationsobject[]
[]
Pick-up location address
address string
[]
Detailed address 1
[]
Example: Address 1
address_add string
[]
Detailed address 2
[]
Example: address 22
city string
[]
City
[]
Example: Guangzhou
country string
[]
Country
[]
Example: China
country_code string
[]
Country code
[]
Example: CN
district string
[]
District/County
[]
Example: Panyu District
location_id string
[]
Unique code of pickup location
[]
Example: 5327026538935748524
name string
[]
Address name
[]
Example: Wanda square
phone string
[]
Phone number such as (555) 555-5555
[]
Example: 13100000000
province string
[]
Province
[]
Example: Guangdong Province
town string
[]
Township/town
[]
Example: town
zip string
[]
Postal code
[]
Example: 521000
name string
[]
Store custom order number, starting from 1001, you can set a prefix
[]
Example: test1001
note string
[]
Merchant notes
[]
Example: Remark
note_attributesobject[]
[]
Merchant note log, date content
create_time string
[]
Remark creation time (see IOS8601 for the format)
[]
Example: 2022-11-04T10:18:46+00:00
name string
[]
Remark source (seller ID)
[]
Example: Note source
value string
[]
Notes
[]
Example: Notes
order_at string
[]
Order completion time (see IOS8601 for the format)
[]
Example: 2021-08-16T08:27:57+00:00
order_source string
[]
The order source channel, currently only the pos channel has a value for this field, and the value for other channels is empty
[]
Example: pos
order_status_url string
[]
Order status page URL
[]
Example: https://shoptest.myshoplinestg.com/trade/thank_you?mainOrderMark=xxx&mainOrderSeq=200565776406008509
payment_detailsobject[]
[]
Payment slip information
create_time string
[]
Payment slip creation time
[]
Example: 2021-08-16T08:27:57+00:00
gateway string
[]
Payment method name
[]
Example: mypay
pay_amount double
[]
Payment amount
[]
Example: 8
pay_channel string
[]
Payment channels
[]
Example: Paypal
pay_channel_deal_id string
[]
External channel payment serial number
[]
Example: pi_3MI897Hezv8FxjBO1uGxMPhX
pay_merchant_email string
[]
Pay Merchant Email Account
[]
Example: Washingtontest@gmail.com
pay_merchant_id string
[]
Payment merchants ID
[]
Example: 4201057379
pay_merchant_order_id string
[]
Payment merchant order number
[]
Example: 233445354566
pay_seq string
[]
Payment slip number
[]
Example: 23057287797738260472676128
pay_status string
[]
Payment order status, unpaid-unpaid; pending-paying; risking-risk control; paid-paid; paid_overtime-payment failed; paid_failed-payment failed;
[]
Example: unpaid
processed_at string
status_code string
[]
payment status code
[]
Example: RISK_PENDING
status_msg string
[]
Payment status code description
[]
Example: PENDING_REVIEW
payment_gateway_names array
[]
List of payment methods, the list of payment methods used in this order, SLpayments
[]
Example: Paypal
phone string
[]
Buyer contact information, there must be one of the two
[]
Example: 18978789878
presentment_currency string
[]
Buy side currency, same as sell side currency
[]
Example: USD
processed_at string
processed_user_id string
[]
order creator
[]
Example: 4201057495
referring_site string
[]
External link
[]
Example: https://www.referringSite.com
refundsobject[]
[]
Refund list
created_at string
[]
Refund form creation time (see IOS8601 for the format)
[]
Example: 2021-08-16T08:27:57+00:00
id string
[]
Refund ID
[]
Example: 2605659027312156877634
note string
[]
Refund Notes
[]
Example: Refund Notes
order_adjustmentsobject[]
[]
Adjustment order information, used to record two types of information: 1) Refund information related to freight (type type is shipping_refund) 2) The difference between the automatically calculated refund amount and the actual refund amount (type type is refund_discrepancy)
amount string
[]
Adjustment order amount
[]
Example: 8.00
amount_setobject
[]
Adjustment order amount
presentment_moneyobject
[]
Store adjustment list display amount
amount double
[]
Shop adjustment display amount
[]
Example: 8
currency_code string
[]
The store adjusts the display amount currency
[]
Example: USD
shop_moneyobject
[]
Store Adjustment Amount
amount double
[]
Store Adjustment Amount
[]
Example: 8
currency_code string
[]
Store Adjustment Amount Currency
[]
Example: USD
id string
[]
refund adjustment order id
[]
Example: RAP5570565996182771228
kind string
[]
Adjustment order type: refund_discrepancy, shipping_refund
[]
Example: refund_discrepancy
order_id string
[]
Order number
[]
Example: 21056577640603870897253153
reason string
[]
Reason for adjustment: Refund discrepancy, shipping_refund
[]
Example: Refund discrepancy
refund_id string
[]
refund order id
[]
Example: 2605659027312156877634
tax_amount string
[]
Adjust single tax amount
[]
Example: 8.00
tax_amount_setobject
[]
Adjust single tax amount
presentment_moneyobject
[]
Display the tax amount on the store adjustment sheet
amount double
[]
Display the tax amount on the store adjustment sheet
[]
Example: 8
currency_code string
[]
Tax currency displayed on store adjustment sheet
[]
Example: USD
shop_moneyobject
[]
Shop adjustment tax amount
amount double
[]
Shop adjustment tax amount
[]
Example: 8
currency_code string
[]
Shop adjustment tax currency
[]
Example: USD
order_id string
[]
Order number
[]
Example: 21056577640603870897253153
processed_at string
[]
Update time (see IOS8601 for the format)
[]
Example: 2021-08-16T08:27:57+00:00
refund_line_itemsobject[]
[]
Refund Details
id string
[]
Refund order number
[]
Example: 2605659027312156877634
line_itemobject
[]
Description
attribute string
[]
Commodity attribute: name - attribute value multiple separated by comma ", " such as: color - red, size - X
[]
Example: red
fulfillable_quantity integer
[]
Available quantity
[]
Example: 1
fulfillment_service string
[]
Logistics company name
[]
Example: SF International
fulfillment_status string
[]
The shipping status of the product, shipping status, fulfilled-shipped; partial-partially shipped; null-unshipped;
[]
Example: fulfilled
grams double
[]
Weight ( grams )
[]
Example: 1
id string
[]
The ID of the product snapshot table, generated by the system, uniquely confirms a product with the order number
[]
Example: 403
name string
[]
SKU title, same as title
[]
Example: 18056761559987524812644011
price string
[]
Product selling price , value string of accuracy 2
[]
Example: 8.00
price_setobject
[]
Product selling price , market currency information
presentment_moneyobject
[]
Product selling price , market currency information
amount string
[]
Product selling price , market currency amount
[]
Example: 10.00
currency_code string
[]
Market currency
[]
Example: USD
shop_moneyobject
[]
Current order membership points to deduct the amount , store currency information
amount string
[]
Example: 70.00
currency_code string
[]
Example: CNY
product_id string
[]
SPU serial number
[]
Example: 16056761559984840457934011
quantity integer
[]
Quantity of items in the order
[]
Example: 1
requires_shipping boolean
[]
Shipping or not
[]
Example: true
sku string
[]
Product code, barCode
[]
Example: sku name
tax_linesobject[]
[]
Tax information
price string
[]
Tax, precision 2
[]
Example: 8.00
price_setobject
[]
Multi-currency information of tax
presentment_moneyobject
[]
Buy side currency
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
shop_moneyobject
[]
Sell side amount information
amount string
[]
Amount
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
rate double
[]
Tax rate
[]
Example: 1
title string
[]
Headline
[]
Example: Headline
taxable boolean
[]
Tax or not？
[]
Example: true
title string
[]
Product title
[]
Example: Product title
variant_id string
[]
Product SKU serial number
[]
Example: 18056761559987524812644011
variant_title string
[]
Commodity attribute value, multiple divided by " / ", such as: "155 / red / large"
[]
Example: big
vendor string
[]
Supplier
[]
Example: Supplier
line_item_id string
[]
The ID of the product snapshot table, generated by the system, uniquely confirms a product with the order number
[]
Example: 406
quantity integer
[]
Quantity, quantity of goods
[]
Example: 1
restock_type string
[]
Inventory return type, no_restock-not returned, cancel-cancelled, return-returned only not returned
[]
Example: cancel
subtotal double
[]
Total refund amount, precision 2
[]
Example: 8
subtotal_setobject
[]
Total refund amount, multi-currency information, same on seller and buyer side
presentment_moneyobject
[]
Buy side currency
amount string
[]
Amount
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
shop_moneyobject
[]
Sell side amount information
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
total_tax double
[]
Tax amount of refunded goods, precision 2
[]
Example: 8
total_tax_setobject
[]
Total tax amount, multi-currency information
presentment_moneyobject
[]
Buy side currency
amount string
[]
Amount
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
shop_moneyobject
[]
Sell side currency
amount string
[]
Amount
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
transactionsobject[]
[]
Refund transaction information
amount string
[]
refund amount, precision 2
[]
Example: 8.00
created_at string
[]
Creation time
[]
Example: 2021-08-16T08:27:57+00:00
currency string
[]
Currency
[]
Example: USD
id string
[]
Refund ID
[]
Example: 2605659027312156877634
kind string
[]
Transaction type (authorization, capture, sale, void, refund)
[]
Example: void
order_id string
[]
Order number
[]
Example: 21056577640603870897253153
processed_at string
[]
Refund form update time
[]
Example: 2021-08-16T08:27:57+00:00
status string
[]
Handling status, pending, failure, success, and error
[]
Example: success
user_id string
[]
Buyer ID
[]
Example: 4201057495
user_id string
[]
User ID
[]
Example: 4201057495
service string
[]
Shipping method type, pickUp means pick up in store.
[]
Example: pickUp
shipping_addressobject
[]
Shipping address
address1 string
[]
address1
[]
Example: Address 1
address2 string
[]
Detailed address 2, optional
[]
Example: Address 2
city string
[]
City
[]
Example: City
company string
[]
Company Name
[]
Example: Company Name
country string
[]
Country
[]
Example: China
country_code string
[]
Country code
[]
Example: CN
delivery_store_code string
[]
Store ID
[]
Example: 1001
delivery_store_name string
[]
Store name
[]
Example: Store name
district string
[]
District
[]
Example: Panyu District
district_code string
[]
District code
[]
Example: 521000
first_name string
[]
Last name
[]
Example: tom
last_name string
[]
First name
[]
Example: Washington
latitude string
[]
latitude
[]
Example: 15
longitude string
[]
longitude
[]
Example: 41
name string
[]
Full name
[]
Example: Tom. Washington
phone string
[]
Phone
[]
Example: 13100000000
province string
[]
Province
[]
Example: Guangdong Province
province_code string
[]
Province code
[]
Example: 510000
zip string
[]
Postal code
[]
Example: 521000
shipping_linesobject[]
[]
Logistics information
code string
[]
Logistics number
[]
Example: SF
discount_allocationsobject[]
[]
Discount Details
amount string
[]
Discount amount, precision 2
[]
Example: 8.00
amount_setobject
[]
Discount Multi-Currency Amount
presentment_moneyobject
[]
Buyer side amount information
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
shop_moneyobject
[]
Amount information on the store side
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
discount_application_index integer
[]
Position in discount details
[]
Example: 1
discounted_price string
[]
Discount amount, precision 2
[]
Example: 8.00
discounted_price_setobject
[]
Discount Multi-Currency Amount
presentment_moneyobject
[]
Buyer side amount information
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
shop_moneyobject
[]
Amount information on the store side
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
phone string
[]
Phone
[]
Example: 13100000000
price string
[]
Logistics freight, precision 2
[]
Example: 8.00
price_setobject
[]
Logistics freight multi-resource information
presentment_moneyobject
[]
Buyer side amount information
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
shop_moneyobject
[]
Amount information on the store side
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
requested_fulfillment_service_id string
[]
Transportation service code
[]
Example: -
shipping_price string
[]
The value of the original shipping fee (not the amount after the discount)
[]
Example: 8.00
shipping_price_setobject
[]
Original shipping value ( non-discounted amount ) , multi-currency amount information
presentment_moneyobject
[]
Buyer side amount information
amount string
[]
Amount , accuracy 2
[]
Example: 8.00
currency_code string
[]
Market currency
[]
Example: CNY
shop_moneyobject
[]
Store side amount information
amount string
[]
Amount , accuracy 2
[]
Example: 1.00
currency_code string
[]
Store currency
[]
Example: USD
source string
[]
Shipping source
[]
Example: source
tax_linesobject[]
[]
Logistics tax list
price string
[]
tax
[]
Example: 8.00
price_setobject
[]
Multi-currency information of tax
presentment_moneyobject
[]
Buyer side amount information
amount string
[]
Amount
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
shop_moneyobject
[]
Sell side amount information
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
rate double
[]
Tax rate
[]
Example: 1
title string
[]
Tax name
[]
Example: Tax name
title string
[]
Logistics name
[]
Example: SF International
source_identifier string
[]
ID used to identify business processing
[]
Example: -
source_name string
[]
Type filtering to identify business processes
[]
Example: -
source_url string
[]
The HTML format information of the link to jump to the store
[]
Example: -
status string
[]
Order status open=processing, canceled-cancelled
[]
Example: open
store_id string
[]
store ID
[]
Example: 1644828244663
subtotal_price string
[]
Total product price after discount, total product price - marketing discount - artificial discount
[]
Example: 8.00
subtotal_price_setobject
[]
Multi-currency information of total product price after discount
presentment_moneyobject
[]
Buyer side amount information
amount string
[]
Amount, Precision 2
[]
Example: 1.00
currency_code string
[]
Currency
[]
Example: USD
shop_moneyobject
[]
Sell side amount information
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
tags string
[]
order label
[]
Example: Label
tax_linesobject[]
[]
Tax information
name string
[]
Tax name
[]
Example: Tax name
price string
[]
Tax, precision 2
[]
Example: 8.00
price_setobject
[]
Multi-currency information of tax
presentment_moneyobject
[]
Buyer side amount information
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
shop_moneyobject
[]
Sell side amount information
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
rate double
[]
Tax rate
[]
Example: 1
title string
[]
Tax name
[]
Example: Tax name
tax_number string
[]
TIN
[]
Example: -
tax_type string
[]
Types of tax ID
[]
Example: -
taxes_included boolean
[]
Does the total include tax?
[]
Example: true
total_discounts string
[]
Total discount, marketing discount + artificial discount
[]
Example: 8.00
total_discounts_setobject
[]
Multi-currency information of discount total
presentment_moneyobject
[]
Buyer side amount information
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
shop_moneyobject
[]
Sell side amount information
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
total_line_items_price string
[]
Sum of original prices of goods, precision 2
[]
Example: 8.00
total_line_items_price_setobject
[]
Sum of original price of goods, multi-currency information
presentment_moneyobject
[]
Buyer side amount information
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
shop_moneyobject
[]
Sell side amount information
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
total_outstanding string
[]
Sum of unpaid amount, precision 2
[]
Example: 8.00
total_shipping_price_setobject
[]
Order shipping sum, multi-currency information
presentment_moneyobject
[]
Buyer side amount information
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
shop_moneyobject
[]
Sell side amount information
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
total_tax string
[]
Sum of taxes, precision 2, commodity tax + shipping tax
[]
Example: 8.00
total_tax_setobject
[]
Tax summation, multi-currency information
presentment_moneyobject
[]
Buyer side amount information
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
shop_moneyobject
[]
Sell side amount information
amount string
[]
Amount, Precision 2
[]
Example: 8.00
currency_code string
[]
Currency
[]
Example: USD
total_tip_received string
[]
Tip, precision 2
[]
Example: 8.00
total_tip_received_setobject
[]
Current order membership credit to the amount , multi-currency amount information
presentment_moneyobject
[]
Current order membership points to deduct the amount , market currency information
amount string
[]
Current order membership points to deduct the amount , market currency
[]
Example: 10.00
currency_code string
[]
Market currency
[]
Example: USD
shop_moneyobject
[]
Current order membership points to deduct the amount , store currency information
amount string
[]
Example: 70.00
currency_code string
[]
Store currency
[]
Example: CNY
total_weight double
[]
Total product weight ( g )
[]
Example: 1
updated_at string
[]
Order update time, (see IOS8601 for the format)
[]
Example: 2021-08-16T08:27:57+00:00
user_id string
[]
Buyer ID
[]
Example: 4201057495
utm_parameters string
[]
Ad business-specific parameters used for ad attribution calculation
[]
Example: -

API Explorer

Debugger

Base URL

https://openapiceshidianpu.myshopline.com/admin/openapi/v20230901

ParamOptions

Authorization — header required

buyer_id — query

contract_ids — query

created_at_max — query

created_at_min — query

email — query

fields — query

financial_status — query

fulfillment_status — query

hidden_order — query

ids — query

limit — query

name — query

page_info — query

search_content — query

since_id — query

sort_condition — query

status — query

updated_at_max — query

updated_at_min — query

Language

curl --request GET \
     --url https://openapiceshidianpu.myshopline.com/admin/openapi/v20230901/orders.json \
     --header 'Authorization: Bearer eyJhbGciOiJIUzUxMiJ9.eyJhcHBLZXkiOiJmMjM3OWQyMTYyOGMzM2QxMWRiMWZkYjY5N2EzZjdjMjZlNGMwYTA5Iiwic2VsbGVySWQiOiIyMDAwMjM0ODgwIiwic3RvcmVJZCI6IjE2NzIzNjk3Mjk2MDYiLCJ2ZXJzaW9uIjoiVjIiLCJkb21haW4iOiJodHRwczovL3NsLW9wZW4tc2cubXlzaG9wbGluZS5jb20iLCJ0aW1lc3RhbXAiOjE2NzUzMTk0OTI0MzksImlzcyI6Inlzb3VsIiwiZXhwIjoxNzY5OTI3NDkyfQ.UwQzomM2veGCUaOZ0paUxq5dpc7DXuhHYFvsQ_uIAKduzWcb_j2E4q_36El83sp145D4cKbpcE5KCeeIz-JNQw' \
     --header 'Content-Type: application/json; charset=utf-8' \
     --header 'accept: application/json'

Was this article helpful to you?

SHOPLINE

Legal

Error loading component.