Lingxing
切换旧版

查询订单管理订单列表

POST/pb/mp/order/v2/list

数据对应多平台管理系统中【订单】>【订单管理】的订单数据，涵盖所有平台自发货订单数据

该接口查询到的订单可修改，可能会与原始销售订单数据有差异，对于亚马逊原始销售订单数据可查询亚马逊订单列表接口（含 FBM、FBA ）

API Path请求协议请求方式令牌桶容量
/pb/mp/order/v2/list HTTPSPOST10

请求参数

offsetinteger必填
分页偏移量
lengthinteger必填
分页长度，上限500
date_typestring
时间类型：
更新时间 update_time
订购时间 global_purchase_time
发货时间 global_delivery_time
付款时间 global_payment_time
平台发货时间 delivery_time（附加说明.4）
当且仅当传入平台单号或平台单名称查询时可不必传
start_timeinteger
开始时间，时间戳格式【单位：秒】，双开区间
当且仅当传入平台单号或平台单名称查询时可不必传，查询时间跨度不能超过31天
end_timeinteger
结束时间，时间戳格式【单位：秒】，双开区间
当且仅当传入平台单号或平台单名称查询时可不必传，查询时间跨度不能超过31天
store_idarray<any>
店铺id，取值等同于查询多平台店铺信息返回结果的store_id
platform_codearray<any>
平台code：
10001 AMAZON
10002 Shopify
10003 eBay
10004 Wish
10005 AliExpress
10006 Shopee
10007 Lazada
10008 Walmart
10009 自定义平台
10010 Wayfair
10011 TikTok
10012 MERCADO
10013 CDISCOUNT
10014 NEWEGG
10015 RAKUTEN
10016 SHOPLINE
10017 TEAPPLIX
10018 SHOPLAZZA
10019 UEESHOP
10020 COUPANG
10021 SHEIN
10022 temu全托管
10024 temu半托管
10025 OTTO
10026 OZON
10027 SHEIN全托管
10028 SHEIN半托管
10029 AliExpress半托管
10030 AliExpress全托管
10031 AliExpress海外托管
10033 Qoo10
10034 Mirakl
10025 OTTO
10026 OZON
10027 SHEIN全托管
10028 SHEIN半托管
10029 AliExpress半托管
10030 AliExpress全托管
10033 Qoo10
10034 Mirakl
10035 AMAZON VC
10036 Kaufland
10037 Allegro
10038 Line Shopping
10039 SPS Commerce
platform_order_nosarray<any>
平台单号列表 ，元素不超过200个
以下平台不可用，需要用platform_order_names查询：
10003-ebay
10014-newegg
10020-coupang
10002-shopify
10012-美客多
10016-shopline
platform_order_namesarray<any>
特定平台单号列表 ，元素不超过200个
10003-ebay
10014-newegg
10020-coupang
10002-shopify
10012-美客多
10016-shopline，使用该字段查询
tracking_nosarray<any>
跟踪号列表，元素不超过200个
global_order_nosarray<any>
系统单号
order_statusinteger
订单状态：
1 同步中
2 已同步
3 待付款
4 待审核
5 待发货
6 已发货
7 已取消/不发货
8 不显示
9 平台发货
platform_shipping_statusarray<any>
平台单发货状态
Shopify状态枚举值:
fulfilled：已发货，并且全部发货
null：未发货
partial：部分发货
restocked：已退货
platform_payment_statusarray<any>
平台单支付状态
Shopify状态枚举值:
pending：待支付
authorized：买家信用卡支付，并且已经确认授权，但是卖家并未收款
partially_paid：已完成部分款项支付
paid：已全部支付完成
partially_refunded：已部分退款
refunded：已全部退款
voided：支付被取消，或支付无效，或支付被撤销，通常出现在订单取消之后
include_deleteboolean
是否包含已删除订单
true 包含
false 不包含

请求示例

{
    "start_time": 1710925191,
    "end_time": 1713430791,
    "date_type": "update_time",
    "offset": 0,
    "length": 20,
    "order_status": 3,
    "store_id": ["110418202566107648"],
    "platform_code": [10001,10002],
    "platform_order_nos": ["119834203044003","120073601764065"]
}

返回结果

Json Object

参数名说明必填类型示例
code状态码，0 成功是[int]0
message提示信息是[string]操作成功
request_id请求链路id是[string]ad9c1a8625c74f3ea0525e216374e31a1676514819613
response_time响应时间是[string]2023-02-16 10:33:40
data响应数据是[object]
data>>total总数是[int]1
data>>list详细列表是[array]
data>>list>>store_id店铺id是[string]
data>>list>>site_code站点否[string]10001-UK
data>>list>>wid仓库id是[string]1
data>>list>>reference_no平台参考号是[string]1
data>>list>>global_order_no系统单号
系统本地唯一订单号		是[string]
data>>list>>original_global_order_no补发订单原系统单号是[string]
data>>list>>customer_shipping_list客选物流列表否[array][""]
data>>list>>amount_currency币种是[string]
data>>list>>remark客服备注是[string]
data>>list>>order_from_name订单来源是[string]
data>>list>>status系统订单状态：
1 同步中
2 已同步
3 未付款
4 待审核
5 待发货
6 已发货
7 已取消/不发货
8 不显示
9 平台发货		是[int]
data>>list>>flow_node系统流转节点（仅用于细粒度状态判断）
平台发货订单（且已发货）：status=9 && flow_node=11		是[int]
data>>list>>status_sub二级状态（仅用于细粒度状态判断）
冻结订单：status=4 && status_sub=5		是[int]
data>>list>>split_type拆分单类型：
1 原始单
2 合并单
3 拆分单		是[string]
data>>list>>delivery_type发货方式：
1 混合方式【中转值，最终会转为2或3】
2 自发货
3 平台发货【指由平台仓库自动完成履约的订单，如Walmart的WFS订单】		是[int]2
data>>list>>supplier_idWayfair平台对订单指定的发货仓库 ID，店铺后台称为 Supplier ID是[string]
data>>list>>vc_warehouse_codeAmazon VC 仓库代码否[string]GYTN
data>>list>>vc_ship_methodAmazon VC 运输方式否[string]UPS_GR_RES
data>>list>>update_time订单更新时间是[string]
data>>list>>global_purchase_time订购时间是[int]
data>>list>>global_review_time审核时间是[int]
data>>list>>global_cancel_time取消时间是[int]
data>>list>>global_delivery_time发货时间是[int]
data>>list>>global_distribution_time配货时间是[int]
data>>list>>global_latest_ship_time发货时限是[string]
data>>list>>global_payment_time付款时间是[int]
data>>list>>global_print_time打单时间是[int]
data>>list>>global_mark_time标发时间是[int]
data>>list>>order_custom_fields订单自定义字段否[object]
data>>list>>item_info商品信息是[array]
data>>list>>item_info>>id系统商品唯一id是[string]
data>>list>>item_info>>global_item_no商品行系统唯一键是[string]
data>>list>>item_info>>item_from_name商品来源
1 线上
2 本地
3 本地(自定义平台导入带MSKU商品，可换货)		是[string]
data>>list>>item_info>>customer_shipping_amount客付运费，币种取amount_currency是[string]
data>>list>>item_info>>customer_tip_amountShopify小费，币种取amount_currency是[string]
data>>list>>item_info>>discount_amount折扣，币种取amount_currency是[string]
data>>list>>item_info>>item_price_amount商品金额，币种取amount_currency是[string]
data>>list>>item_info>>local_skuSKU是[string]
data>>list>>item_info>>mskuMSKU是[string]
data>>list>>item_info>>local_product_name品名是[string]
data>>list>>item_info>>product_no亚马逊返回asin，多平台返回平台商品id是[string]
data>>list>>item_info>>order_item_no订单明细单号是[string]
data>>list>>item_info>>platform_order_no平台单号是[string]
data>>list>>item_info>>platform_status平台订单商品状态是[string]
data>>list>>item_info>>quantity数量是[int]
data>>list>>item_info>>remark商品备注是[string]
data>>list>>item_info>>customized_url亚马逊定制商品文件下载链接是[string]
data>>list>>item_info>>sales_revenue_amount销售收益是[string]
data>>list>>item_info>>stockCost商品出库成本是[string]
data>>list>>item_info>>tax_amount商品税费，币种取amount_currency是[string]
data>>list>>item_info>>transaction_fee_amount商品交易费，币种取amount_currency是[string]
data>>list>>item_info>>type商品类型否[string]
data>>list>>item_info>>unit_price_amount单价，币种取amount_currency是[string]
data>>list>>item_info>>variant_attr变体属性是[string]
data>>list>>item_info>>wms_outbound_cost_amount实际出库成本，币种CNY，取自销售出库单出库成本是[string]67.56
data>>list>>item_info>>stock_cost_amount库存明细成本，币种CNY，取自订单创建时库存明细计算成本是[string]67.56
data>>list>>item_info>>cg_price_amount采购成本，币种CNY，取自产品管理固定值是[string]65.00
data>>list>>item_info>>shipping_amount预估运费，币种CNY是[string]2984.42
data>>list>>item_info>>wms_shipping_price_amount实际运费，取自销售出库单运费，币种取自data>>list>>logistics_info>>cost_currency_code是[string]￥9.17
data>>list>>item_info>>is_bundled是否为捆绑产品：
1 是
0 否		是[int]0
data>>list>>item_info>>sub_products子产品是[object]
data>>list>>item_info>>sub_products>>sku子产品SKU是[String]
data>>list>>item_info>>sub_products>>qty子产品发货数量是[int]
data>>list>>item_info>>title商品标题是[string]
data>>list>>item_info>>other_amount平台其他费用，币种取amount_currency是[string]0.00
data>>list>>item_info>>cod_amountCOD费用，币种取amount_currency是[string]14.00
data>>list>>item_info>>gift_wrap_amount礼品包装费，币种取amount_currency是[string]300.00
data>>list>>item_info>>platform_tax_amount销售税，币种取amount_currency是[string]0.00
data>>list>>item_info>>points_granted_amount积分成本，币种取amount_currency是[string]0.00
data>>list>>item_info>>other_fee其他费用，用户手动按系统订单导入，有正有负是[string]4.00
data>>list>>item_info>>delivery_time平台发货时间，当前仅支持Shopify平台，查询条件满足"platform_code":["10002"] && "date_type":"delivery_time"才返回此字段否[string]
data>>list>>item_info>>platform_subsidy_amount平台补贴(目前仅TikTok、Shopee支持返回）)否[string]
data>>list>>item_info>>location_idShopify发货仓库ID否[string]
data>>list>>item_info>>source_nameShopify销售渠道否[string]
data>>list>>item_info>>data_json扩展字段(json)否[string]
data>>list>>item_info>>stock_deduct_id备货店铺ID否[string]
data>>list>>item_info>>stock_deduct_name备货店铺名称否[string]
data>>list>>item_info>>item_custom_fields订单产品自定义字段否[object]
data>>list>>item_info>>item_custom_fields自定义字段，键为自定义字段标识id，值为对象否[object]
data>>list>>item_info>>item_custom_fields>>id字段Id否[string]
data>>list>>item_info>>item_custom_fields>>name字段名称否[string]
data>>list>>item_info>>item_custom_fields>>val字段值否[array] [string]
data>>list>>item_info>>item_custom_fields>>val_text字段值文本描述否[string]
data>>list>>item_info>>item_custom_fields>>character字段属性否
data>>list>>logistics_info物流信息是[object]
data>>list>>logistics_info>>actual_carrier实际承运人是[string]
data>>list>>logistics_info>>cost_amount物流实际运费是[string]
data>>list>>logistics_info>>cost_currency_code物流实际运费币种code是[string]
data>>list>>logistics_info>>logistics_provider_id物流商id是[int]
data>>list>>logistics_info>>logistics_provider_name物流商名称是[string]
data>>list>>logistics_info>>logistics_time物流下单成功时间是[int]
data>>list>>logistics_info>>logistics_type_id物流方式id是[string]
data>>list>>logistics_info>>logistics_type_name物流方式名称是[string]
data>>list>>logistics_info>>pkg_fee_weight实际计费重量是[number]
data>>list>>logistics_info>>pkg_fee_weight_unit实际计费重单位是[string]
data>>list>>logistics_info>>pkg_height实际包裹高是[number]
data>>list>>logistics_info>>pkg_length实际包裹长是[number]
data>>list>>logistics_info>>pkg_size_unit包裹尺寸单位是[string]
data>>list>>logistics_info>>pkg_width实际包裹宽是[number]
data>>list>>logistics_info>>pre_cost_amount预估运费 负是[string]
data>>list>>logistics_info>>pre_fee_weight预估计费重量是[number]
data>>list>>logistics_info>>pre_fee_weight_unit预估计费重单位是[string]
data>>list>>logistics_info>>pre_pkg_height预估包裹高(cm)是[number]
data>>list>>logistics_info>>pre_pkg_length预估包裹长(cm)是[number]
data>>list>>logistics_info>>pre_pkg_width预估包裹宽(cm)是[number]
data>>list>>logistics_info>>pre_weight预估重量(g)是[number]
data>>list>>logistics_info>>status状态：
0 待物流下单
1 物流下单中
2 成功
3 失败
4 已取消		是[int]
data>>list>>logistics_info>>tracking_no跟踪号是[string]
data>>list>>logistics_info>>waybill_no物流商返回的物流单号是[string]
data>>list>>logistics_info>>owms_waybill_no仓配分离场景下的海外仓运单号是[string]
data>>list>>logistics_info>>weight实际重量(g)是[number]
data>>list>>logistics_info>>weight_unit包裹实际重量单位是[string]
data>>list>>order_tag标签+处理类型是[array]
data>>list>>order_tag>>tag_name标签名称是[string]
data>>list>>order_tag>>tag_no标签编号是[string]
data>>list>>order_tag>>tag_type标签类型：
1 自定义处理类型
2 自定义订单标签
3 系统处理类型
4 系统订单标签		是[string]
data>>list>>exception_order_tag异常类型标签是[array]
data>>list>>pending_order_tag待办类型标签是[array]
data>>list>>platform_info平台单信息是[array]
data>>list>>platform_info>>cancel_time取消单时间是[int]
data>>list>>platform_info>>delivery_time平台发货时间是[int]
data>>list>>platform_info>>latest_ship_time最后发货时间是[int]
data>>list>>platform_info>>order_from订单来源是[string]
data>>list>>platform_info>>payment_status平台单支付状态是[string]
data>>list>>platform_info>>payment_time支付时间是[int]
data>>list>>platform_info>>platform_code平台CODE是[int]
data>>list>>platform_info>>platform_order_name平台订单编号
【具体见附加说明】		是[string]
data>>list>>platform_info>>platform_order_no平台订单号是[string]
data>>list>>platform_info>>purchase_time订购时间是[int]
data>>list>>platform_info>>shipping_status状态是[string]
data>>list>>platform_info>>status平台单状态是[string]
data>>list>>platform_info>>store_Country_code订单国家(二位iso_3166_1)是[string]
data>>list>>transaction_info交易信息是[array]
data>>list>>transaction_info>>customer_shipping_amount客付运费，币种取amount_currency是[string]
data>>list>>transaction_info>>customer_tax_amount_show客付税费，币种取amount_currency是[string]
data>>list>>transaction_info>>customer_tip_amount小费，币种取amount_currency是[string]
data>>list>>transaction_info>>discount_amount折扣，币种取amount_currency是[string]
data>>list>>transaction_info>>order_item_amount商品金额，币种取amount_currency是[string]
data>>list>>transaction_info>>order_total_amount订单总额，币种取amount_currency是[string]
data>>list>>transaction_info>>outbound_cost_amount预估出库成本
币种默认CNY		是[string]
data>>list>>transaction_info>>pre_cost_amount预估运费
币种默认CNY		是[string]
data>>list>>transaction_info>>transaction_fee_amount交易费，币种取amount_currency是[string]
data>>list>>transaction_info>>profit_amount预估毛利润，币种取amount_currency是[string]
data>>list>>transaction_info>>other_amount平台其他费是[string]￥0.00
data>>list>>transaction_info>>cg_price_amount采购成本，币种CNY，取自产品管理固定值是[string]-￥77.00
data>>list>>transaction_info>>stock_cost_amount库存明细成本，币种CNY，取自订单创建时库存明细计算成本是[string]-￥80.07
data>>list>>transaction_info>>wms_outbound_cost_amount实际出库成本，币种CNY，取自销售出库单出库成本是[string]-￥80.07
data>>list>>transaction_info>>wms_shipping_price_amount实际运费，币种CNY，取自销售出库单出库运费是[string]-￥11.00
data>>list>>transaction_info>>cod_amountCOD费用，币种取amount_currency是[string]JP¥14.00
data>>list>>transaction_info>>gift_wrap_amount礼品包装费，币种取amount_currency是[string]JP¥601.00
data>>list>>transaction_info>>platform_tax_amount销售税，币种取amount_currency是[string]JP¥0.00
data>>list>>transaction_info>>points_granted_amount积分成本，币种取amount_currency是[string]-JP¥31.00
data>>list>>transaction_info>>other_fee其他费用 用户手动按系统订单导入，有正有负是[string]JP¥10.00
data>>list>>transaction_info>>platform_subsidy_amount平台补贴(目前仅TikTok、Shopee支持返回）)否[string]

返回成功示例

{
    "code": 0,
    "message": "操作成功",
    "response_time": "2023-09-18 10:37:12",
    "request_id": "532e9175-a6d5-42ab-8744-b5d0d8eaea04.1695004631603",
    "data": {
        "total": "1",
        "list": [
            {
                "global_order_no": "103351413752115712",
                "store_id": "110268822038528000",
                "order_from_name": "线上订单",
                "delivery_type": 2,
                "split_type": "1",
                "status": 4,
                "global_purchase_time": 1693467680,
                "global_payment_time": 1693467680,
                "global_review_time": null,
                "global_distribution_time": null,
                "global_print_time": null,
                "global_delivery_time": 0,
                "amount_currency": "USD",
                "remark": "",
                "global_latest_ship_time": "1693497600",
                "global_cancel_time": 0,
                "update_time": "1693496773",
                "order_tag": [
                    {
                        "tag_type": "系统处理类型",
                        "tag_no": "3-8",
                        "tag_name": "商品未配对"
                    }
                ],
                "wid": "0",
                "item_info": [
                    {
                        "id": "8745387",
                        "platform_order_no": "CS483128864",
                        "order_item_no": "NBRC003BLKOS-MVQ",
                        "item_from_name": "线上",
                        "msku": "NBRC003BLKOS-MVQ",
                        "local_sku": "",
                        "product_no": "",
                        "local_product_name": "",
                        "variant_attr": "",
                        "unit_price_amount": "60.00",
                        "item_price_amount": "120.00",
                        "quantity": 2,
                        "remark": "",
                        "platform_status": "",
                        "type": "产品",
                        "stockCost": null,
                        "wms_outbound_cost_amount": "0.00",
                        "stock_cost_amount": "0.00",
                        "cg_price_amount": "0.00",
                        "shipping_amount": "0.00",
                        "wms_shipping_price_amount": "0.00",
                        "customer_shipping_amount": "0.00",
                        "discount_amount": "0.00",
                        "customer_tip_amount": "0.00",
                        "tax_amount": "0.00",
                        "sales_revenue_amount": "24.58",
                        "transaction_fee_amount": "0.49",
                        "other_amount": "0.00",
                        "customized_url": null,
                        "cod_amount": "0.00",
                        "gift_wrap_amount": "0.00",
                        "platform_tax_amount": "0.00",
                        "points_granted_amount": "0.00",
                        "other_fee": "0.00",
                        "platform_subsidy_amount":""
                    }
                ],
                "platform_info": [
                    {
                        "order_from": "线上订单",
                        "platform_order_no": "5501270851822",
                        "platform_order_name": "#1064",
                        "platform_code": "10002",
                        "store_Country_code": "US",
                        "status": "closed",
                        "payment_status": "paid",
                        "shipping_status": "fulfilled",
                        "purchase_time": 1696929350,
                        "payment_time": 1696929349,
                        "latest_ship_time": 0,
                        "cancel_time": 0,
                        "delivery_time": 0
                    }
                ],
                "logistics_info": {
                    "status": 0,
                    "logistics_type_id": "0",
                    "logistics_type_name": null,
                    "logistics_provider_id": "0",
                    "logistics_provider_name": null,
                    "actual_carrier": "",
                    "waybill_no": "",
                    "pre_weight": 0.00,
                    "pre_fee_weight": 0.00,
                    "pre_fee_weight_unit": "g",
                    "pre_pkg_length": 0.00,
                    "pre_pkg_height": 0.00,
                    "pre_pkg_width": 0.00,
                    "weight": 0.00,
                    "pkg_fee_weight": 0.00,
                    "pkg_fee_weight_unit": "",
                    "pkg_length": 0.00,
                    "pkg_width": 0.00,
                    "pkg_height": 0.00,
                    "weight_unit": "",
                    "pkg_size_unit": "",
                    "cost_currency_code": "",
                    "pre_cost_amount": "-￥0.00",
                    "cost_amount": "0",
                    "logistics_time": null,
                    "tracking_no": "",
                    "mark_no": ""
                },
                "transaction_info": [
                    {
                        "order_item_amount": "￥49.16",
                        "customer_tax_amount_show": "￥0.00",
                        "discount_amount": "￥0.00",
                        "customer_shipping_amount": "￥0.00",
                        "customer_tip_amount": "￥0.00",
                        "order_total_amount": "￥49.16",
                        "cg_price_amount": "￥0.00",
                        "stock_cost_amount": "￥0.00",
                        "outbound_cost_amount": "￥0.00",
                        "wms_outbound_cost_amount": "￥0.00",
                        "pre_cost_amount": "-￥0.00",
                        "wms_shipping_price_amount": "￥0.00",
                        "transaction_fee_amount": "￥-0.98",
                        "profit_amount": "￥48.18",
                        "other_amount": "￥0.00",
                        "cod_amount": "￥0.00",
                        "gift_wrap_amount": "￥0.00",
                        "platform_tax_amount": "￥0.00",
                        "points_granted_amount": "￥0.00",
                        "other_fee": "￥0.00",
                        "platform_subsidy_amount":""
                    }
                ],
                "original_global_order_no": null,
                "customer_shipping_list": null,
                "exception_order_tag": [],
                "pending_order_tag_order_tag": []
            }
        ]
    }
}

附加说明

  1. data>>list>>platform_info下 platform_order_name、platform_order_no区别：

Shopify平台下，二者返回值不同，核对平台单号使用 platform_order_name，platform_order_no为平台返回订单唯一标识 2. 合并单下可能会存在一个系统单号对应多个平台单号 3. 开始时间和结束时间的最大差距范围不超过30天 4. 当date_type=delivery_time且platform_code=10002（Shopify平台）时，查询将筛选商品层级的data>>list>>item_info>>delivery_time字段，即订单中每个商品（Order Line）在Shopify店铺后台标记的实际发货时间1。 5. data>>list>>item_info>>delivery_time：表示商品维度的平台发货时间（当前仅支持Shopify平台）。当同一订单包含多个商品时，不同商品可能具有不同的发货时间（即“部分发货”场景），该字段反映对应商品的实际发货时间戳1。