/erp/sc/data/mws/orderDetail{
"operation": {
"method": "POST",
"path": "/erp/sc/data/mws/orderDetail"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"responseExample": "{\n \"code\": 0,\n \"message\": \"success\",\n \"error_details\": [],\n \"request_id\": \"22A65D65-F133-3402-DED6-700E58FC4AE2\",\n \"response_time\": \"2023-04-14 14:20:57\",\n \"data\": [\n {\n \"amazon_order_id\": \"114-1821948-7841000\",\n \"fulfillment_channel\": \"MFN\",\n \"sid\": 101,\n \"order_status\": \"Shipped\",\n \"is_assessed\": 0,\n \"order_total_amount\": \"145.00\",\n \"currency\": \"USD\",\n \"icon\": \"$\",\n \"is_mcf_order\": 0,\n \"is_return_order\": 0,\n \"is_replaced_order\": 0,\n \"is_replacement_order\": 0,\n \"earliest_ship_date\":\"2020-11-06 11:25:38\",\n \"earliest_ship_date_utc\":\"2020-11-06 19:25:38\",\n \"purchase_date_local\":\"2020-11-06 11:25:38\",\n \"purchase_date_local_utc\":\"2020-11-06 19:25:38\",\n \"last_update_date\": \"2023-02-03 02:27:25\",\n \"last_update_date_utc\":\"2023-02-03 10:27:25\",\n \"posted_date\": \"\",\n \"hide_time\": 0,\n \"shipment_date\": \"\",\n \"is_business_order\": 0,\n \"is_prime\": 0,\n \"is_premium_order\": 0,\n \"is_promotion\": 0\n \"is_return\": 0,\n \"taxes_included\": 2,\n \"ship_service_level\": \"Std US D2D Dom\",\n \"shipment_service_level_category\": \"Standard\",\n \"purchase_order_number\": \"\",\n \"payment_method\": \"Other\",\n \"cba_displayable_shipping_label\": \"\",\n \"order_type\": \"StandardOrder\",\n \"latest_ship_date\": \"2020-11-11T07:59:59Z\",\n \"earliest_delivery_date\": \"2020-12-01T08:00:00Z\",\n \"latest_delivery_date\": \"2020-12-23T07:59:59Z\",\n \"number_of_items_shipped\": 1,\n \"number_of_items_unshipped\": 0,\n \"sales_channel\": \"Amazon.com\",\n \"item_list\": [\n {\n \"id\": 481,\n \"title\": \"Fit for Mercedes-Benz\",\n \"seller_sku\": \"sku-355\",\n \"asin\": \"xxxxxx\",\n \"order_item_id\": \"6004266666460\",\n \"points_monetary_value_amount\": \"0.00\",\n \"quantity_ordered\": 1,\n \"quantity_shipped\": 1,\n \"item_price_amount\": \"135.99\",\n \"item_tax_amount\": \"9.01\",\n \"shipping_price_amount\": \"0.00\",\n \"shipping_tax_amount\": \"0.00\",\n \"gift_wrap_price_amount\": \"0.00\",\n \"gift_wrap_tax_amount\": \"0.00\",\n \"shipping_discount_amount\": \"0.00\",\n \"cod_fee_amount\": \"0.00\",\n \"promotion_ids\": [],\n \"shipping_discount_tax_amount\": \"0.00\",\n \"promotion_discount_amount\": \"0.00\",\n \"promotion_discount_tax_amount\": \"0\",\n \"cod_fee_discount_amount\": \"0.00\",\n \"gift_message_text\": \"\",\n \"gift_wrap_level\": \"\",\n \"condition_note\": \"\",\n \"condition_id\": \"New\",\n \"condition_subtype_id\": \"New\",\n \"scheduled_delivery_start_date\": \"\",\n \"scheduled_delivery_end_date\": \"\",\n \"price_designation\": \"\",\n \"sid\": 101,\n \"sku\": \"\",\n \"product_name\": \"\",\n \"cg_price\": 0,\n \"product_id\": 0,\n \"pic_url\": \"/\",\n \"fee_name\": \"推广费\",\n \"cg_transport_costs\": 0,\n \"fba_shipment_amount\": 0,\n \"commission_amount\": 0,\n \"commission_cost\": 0,\n \"other_amount\": 0,\n \"asin_url\": \"https://www.amazon.com/dp/xxxxxx\",\n \"fee_currency\": \"CNY\",\n \"fee_icon\": \"¥\",\n \"fee_cost_amount\": 0,\n \"fee_cost\": 0,\n \"sales_price_amount\": 145,\n \"unit_price_amount\": 135.99,\n \"tax_amount\": -9.01,\n \"promotion_amount\": 0,\n \"profit\": 135.99,\n \"item_discount\": 0,\n \"customized_json\":\"\"\n }\n ]\n }\n ],\n \"total\": 1\n}"
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | order_id | 亚马逊订单号 | string | — | Required | 亚马逊订单号,多个使用英文逗号分隔,上限200 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | Required | 状态码,0 成功 |
| 2 | message | 消息提示 | string | success | Required | 消息提示 |
| 3 | error_details | 错误信息 | array<any> | — | Required | 错误信息 |
| 4 | request_id | 请求链路id | string | 502B9DD9-1BA0-03C5-6C61-D77C830440A6 | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2020-05-18 11:23:47 | Required | 响应时间 |
| 6 | total | 总数 | integer | 1 | Required | 总数 |
| 7 | data | 响应数据 | array<object> | — | Required | 响应数据 |
| 7.1 | sid | 店铺id | integer | 8 | Required | 店铺id |
| 7.2 | amazon_order_id | 亚马逊订单号 | string | 209-3501178-3501387 | Required | 亚马逊订单号 |
| 7.3 | fulfillment_channel | 发货渠道 | string | AFN | Required | 发货渠道 |
| 7.4 | order_status | 订单状态 | string | Shipped | Required | 订单状态 |
| 7.5 | order_total_amount | 订单总金额 | number | 5.49 | Required | 订单总金额 |
| 7.6 | currency | 订单金额币种 | string | GBP | Required | 订单金额币种 |
| 7.7 | icon | 订单金额币种符号 | string | £ | Required | 订单金额币种符号 |
| 7.8 | is_assessed | 是否为推广订单 | integer | — | Required | 是否为推广订单: 0 否,1 是 |
| 7.9 | is_mcf_order | 是否多渠道订单 | integer | — | Required | 是否多渠道订单:0 普通订单,1 多渠道订单 |
| 7.10 | is_return_order | 是否为退货订单 | integer | — | Required | 是否为退货订单:0 否,1 是 |
| 7.11 | is_replaced_order | 是否已换货 | integer | — | Required | 是否已换货:0 否,1 是 |
| 7.12 | is_replacement_order | 是否为换货订单 | integer | — | Required | 是否为换货订单:0 否,1 是 |
| 7.13 | purchase_date_local | 订购时间(站点时间) | string | 2021-01-01 00:08:26 | Required | 订购时间(站点时间) |
| 7.14 | purchase_date_local_utc | 订购时间(utc时间) | string | 2021-01-01 08:08:26 | Required | 订购时间(utc时间) |
| 7.15 | last_update_date | 订单更新(站点时间) | string | 2021-01-06 08:03:01 | Required | 订单更新(站点时间) |
| 7.16 | last_update_date_utc | 订单更新时间(utc时间) | string | 2021-01-06 00:03:01 | Required | 订单更新时间(utc时间) |
| 7.17 | posted_date | 结算时间(站点时间) | string | 2021-01-06 00:03:01 | Required | 结算时间(站点时间) |
| 7.18 | shipment_date | 发货时间(站点时间) | string | 2021-01-06 00:03:01 | Required | 发货时间(站点时间) |
| 7.19 | estimated_arrival_date | 收货预计时间 | string | — | Required | 收货预计时间 |
| 7.20 | earliest_ship_date | 发货时限(站点时间) | string | 2021-01-06 08:03:01 | Required | 发货时限(站点时间) |
| 7.21 | earliest_ship_date_utc | 发货时限(utc时间) | string | 2021-01-06 00:03:01 | Required | 发货时限(utc时间) |
| 7.22 | is_business_order | 是否为B2B订单 | integer | 0 | Required | 是否为B2B订单:0 否,1 是 |
| 7.23 | is_prime | 是否prime订单 | integer | 0 | Required | 是否prime订单:0 否,1 是 |
| 7.24 | is_premium_order | 是否优先配送订单 | integer | 0 | Required | 是否优先配送订单:0 否,1 是 |
| 7.25 | is_promotion | 是否促销订单 | integer | 0 | Required | 是否促销订单:0 否,1 是 |
| 7.26 | taxes_included | 费用是否含税 | integer | 1 | Required | 费用是否含税:1 含税,2 不含税 仅针对欧洲市场订单使用,对应字段如下:item_price_amount、shipping_price_amount、gift_wrap_price_amount、shipping_discount_amount、promotion_discount_amount、cod_fee_amount |
| 7.27 | ship_service_level | 配送服务 | string | Expedited | Required | 配送服务 |
| 7.28 | shipment_service_level_category | 装运服务级别 | string | Expedited | Required | 装运服务级别 |
| 7.29 | purchase_order_number | 采购订单编号(买家结账时输入) | string | — | Required | 采购订单编号(买家结账时输入) |
| 7.30 | payment_method | 付款方式 | string | Other | Required | 付款方式: COD (Cash on delivery) CVS(Convenience store) Other(A payment method other than COD and CVS) |
| 7.31 | cba_displayable_shipping_label | 亚马逊结账(CBA)的自定义发货标签 | string | — | Required | 亚马逊结账(CBA)的自定义发货标签 |
| 7.32 | order_type | 订单类型 | string | StandardOrder | Required | 订单类型 |
| 7.33 | latest_ship_date | 最晚发货时间(承诺配送订单的最晚发货时间) | string | 2021-01-02T23:59:59Z | Required | 最晚发货时间(承诺配送订单的最晚发货时间) |
| 7.34 | earliest_delivery_date | 最早送达时间(承诺送达订单的最早送达时间) | string | — | Required | 最早送达时间(承诺送达订单的最早送达时间) 备注:UTC时间 |
| 7.35 | latest_delivery_date | 最晚送达时间(承诺送达订单的最晚送达时间) | string | — | Required | 最晚送达时间(承诺送达订单的最晚送达时间) 备注:UTC时间 |
| 7.36 | number_of_items_shipped | 已发货的商品数 | integer | 1 | Required | 已发货的商品数 |
| 7.37 | number_of_items_unshipped | 未发货的商品数 | integer | — | Required | 未发货的商品数 |
| 7.38 | sales_channel | 销售渠道 | string | Amazon.co.uk | Required | 销售渠道 |
| 7.39 | item_list | 订单明细 | array<object> | — | Required | 订单明细 |
| 7.39.1 | id | 订单商品自增id | integer | 3319575 | Required | 订单商品自增id |
| 7.39.2 | title | 商品标题 | string | lingxing amazon product title 1444CA2EDB | Required | 商品标题 |
| 7.39.3 | seller_sku | seller_sku | string | MSKUD33BAE7 | Required | MSKU |
| 7.39.4 | asin | asin | string | B0ABC49975 | Required | ASIN |
| 7.39.5 | asin_url | asin链接 | string | https://www.amazon.co.uk/dp/xxxx | Required | asin链接 |
| 7.39.6 | sid | 店铺id | integer | 8 | Required | 店铺id |
| 7.39.7 | sku | 本地SKU | string | SKU7A67306 | Required | 本地SKU |
| 7.39.8 | product_id | 本地产品id | integer | 1312 | Required | 本地产品id |
| 7.39.9 | product_name | 品名 | string | [演示数据]带2件装相机镜头保护膜 | Required | 品名 |
| 7.39.10 | pic_url | 图片链接 | string | https://image-125421xxx.com/8A%A4%E8%86%9C.jpg | Required | 图片链接 |
| 7.39.11 | order_item_id | 订单商品编码【订单下唯一 | string | 04022905984851 | Required | 订单商品编码【订单下唯一,但亚马逊返回值可能会发生变更,以最新数据为准】 |
| 7.39.12 | points_monetary_value_amount | 积分成本(日本站会有此数据) | string | 0.00 | Required | 积分成本(日本站会有此数据) |
| 7.39.13 | quantity_ordered | 下单量 | integer | 1 | Required | 下单量 |
| 7.39.14 | quantity_shipped | 已配送 | integer | 1 | Required | 已配送 |
| 7.39.15 | item_price_amount | 商品支付金额 | string | 5.49 | Required | 商品支付金额 |
| 7.39.16 | item_tax_amount | 商品税 | string | 0.92 | Required | 商品税 |
| 7.39.17 | shipping_price_amount | 买家运费 | string | 0.00 | Required | 买家运费 |
| 7.39.18 | shipping_tax_amount | 商品运费税 | string | 0.00 | Required | 商品运费税 |
| 7.39.19 | gift_wrap_price_amount | 礼品包装费 | string | 0.00 | Required | 礼品包装费 |
| 7.39.20 | gift_wrap_tax_amount | 礼品包装税 | string | 0.00 | Required | 礼品包装税 |
| 7.39.21 | shipping_discount_amount | 配送折扣 | string | 0.00 | Required | 配送折扣 |
| 7.39.22 | cod_fee_amount | COD服务费用(货到付款服务费) | string | 0.00 | Required | COD服务费用(货到付款服务费) |
| 7.39.23 | promotion_ids | 商品促销id | array<any> | — | Required | 商品促销id |
| 7.39.24 | shipping_discount_tax_amount | 配送折扣税 | string | 0.00 | Required | 配送折扣税 |
| 7.39.25 | promotion_discount_amount | 商品促销折扣 | string | 0.00 | Required | 商品促销折扣 |
| 7.39.26 | promotion_discount_tax_amount | 商品促销折扣税 | string | 0 | Required | 商品促销折扣税 |
| 7.39.27 | cod_fee_discount_amount | COD服务费用折扣 | string | 0.00 | Required | COD服务费用折扣 |
| 7.39.28 | gift_message_text | 礼品信息(买家提供) | string | — | Required | 礼品信息(买家提供) |
| 7.39.29 | gift_wrap_level | 礼品包装级别(买家提供) | string | — | Required | 礼品包装级别(买家提供) |
| 7.39.30 | condition_note | 商品状况说明(卖家提供) | string | — | Required | 商品状况说明(卖家提供) |
| 7.39.31 | condition_id | 商品状况(卖家提供) | string | — | Required | 商品状况(卖家提供) |
| 7.39.32 | condition_subtype_id | 商品子状况(卖家提供) | string | — | Required | 商品子状况(卖家提供) |
| 7.39.33 | scheduled_delivery_start_date | 计划交货开始日期 | string | — | Required | 计划交货开始日期 |
| 7.39.34 | scheduled_delivery_end_date | 计划交货结束日期 | string | — | Required | 计划交货结束日期 |
| 7.39.35 | price_designation | B2B价格 | string | — | Required | B2B价格 |
| 7.39.36 | cg_price | 采购成本 | number | -147.36 | Required | 采购成本 |
| 7.39.37 | fee_name | 其他费名称 | string | 推广费 | Required | 其他费名称,比如推广费 |
| 7.39.38 | cg_transport_costs | 头程费用 | number | -9 | Required | 头程费用 |
| 7.39.39 | fba_shipment_amount | FBA发货费 | number | -2.18 | Required | FBA发货费 |
| 7.39.40 | commission_amount | 平台费 | number | -0.45 | Required | 平台费 |
| 7.39.41 | commission_cost | commission_cost | number | — | Required | 自定义费用本金(fee_currency对应的币种,例:站外推广费本金) |
| 7.39.42 | other_amount | 亚马逊收取的其他费用 | number | — | Required | 亚马逊收取的其他费用,比如参与“Amazon Exlusives Program”产生的费用 |
| 7.39.43 | fee_currency | 其他费币种 | string | CNY | Required | 其他费币种,比如推广费 |
| 7.39.44 | fee_icon | 其他费币种符号 | string | ¥ | Required | 其他费币种符号,比如推广费 |
| 7.39.45 | fee_cost_amount | 自定义费用本金(店铺对应的币种 | number | — | Required | 自定义费用本金(店铺对应的币种,例:站外推广费本金) |
| 7.39.46 | fee_cost | fee_cost | number | — | Required | 自定义费用本金(fee_currency对应的币种,例:站外推广费本金) |
| 7.39.47 | sales_price_amount | 销售收益 | number | 5.49 | Required | 销售收益 |
| 7.39.48 | unit_price_amount | 单价 | number | 4.57 | Required | 单价 |
| 7.39.49 | tax_amount | 税费 | number | -0.92 | Required | 税费 |
| 7.39.50 | promotion_amount | 促销费 | number | — | Required | 促销费 |
| 7.39.51 | profit | 毛利润 | number | -154.42 | Required | 毛利润 |
| 7.39.52 | item_discount | 商品折扣 | number | 0 | Required | 商品折扣 |
| 7.39.53 | customized_json | 订单定制化信息json | string | — | Required | 订单定制化信息json |
| 7.39.54 | is_settled | 商品已结算标识 | integer | — | Required | 商品已结算标识:0 未结算,1 已结算 |
The 查询亚马逊订单详情 API (/erp/sc/data/mws/orderDetail) of 领星ERP is curated by the API asset management module of the Qeasy Cloud data integration platform and kept in sync with 领星ERP version updates.
Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.