/erp/sc/routing/wms/order/wmsOrderList{
"operation": {
"method": "POST",
"path": "/erp/sc/routing/wms/order/wmsOrderList"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"requestExample": {
"page": 1,
"page_size": 20,
"sid_arr": [
26
],
"status_arr": [
1
],
"logistics_status_arr": [
2
],
"platform_order_no_arr": [
"test123465021"
],
"wo_number_arr": [
"WO103132593465409536"
],
"order_number_arr": [
"103130837064323072"
],
"time_type": "create_at",
"start_date": "2021-11-23",
"end_date": "2021-12-20"
},
"responseExample": {
"code": 0,
"message": "success",
"error_details": [],
"request_id": "42AAD00B-C91D-7E1A-7FF2-EC3169A9BCEF",
"response_time": "2023-08-03 10:47:20",
"data": [
{
"wo_id": 6879,
"wo_number": "WO103341008688546816",
"sid": 104,
"wid": 25,
"warehouse_type": 1,
"order_number": "103340669924180992",
"batch_no": "",
"order_from": "补发订单",
"reference_no": "",
"deliver_deadline": "",
"purchase_time": "2023-08-01 15:09:28",
"payment_time": "2023-08-01 15:09:28",
"surface_print_time": "0000-00-00 00:00:00",
"order_print_time": "0000-00-00 00:00:00",
"waybill_no": "",
"tracking_no": "",
"package_no": "",
"transfer_logistics_company_code": "",
"transfer_logistics_company_id": "",
"transfer_tracking_no": "",
"picker": "",
"order_type": 2,
"deliverer": "",
"status": 4,
"logistics_status": 5,
"logistics_message": "",
"order_customer_service_notes": "",
"order_buyer_notes": "",
"is_check": 0,
"is_weigh": 0,
"is_surface_print": 0,
"is_order_print": 0,
"order_origin_amount": "100.00",
"order_currency_code": "USD",
"delivered_at": "",
"stock_delivered_at": "",
"process_sn": "",
"logistics_provider_id": 6,
"logistics_type_id": 265,
"surface_file_type": "",
"is_lock_storage": 0,
"is_advance_delivery": 1,
"apportion_status": 0,
"apportion_message": "",
"remark_attachment": "[]",
"platform_payment_time": "",
"tag_names": [],
"seller_name": "uboss 1-US",
"site_text": "[Amazon].美国",
"product_info": [
{
"wod_id": 6945,
"product_id": 22162,
"sku": "tianjia",
"stock_sid": "0",
"stock_seller_name": "",
"bundle_type": 0,
"bundle_wod_id": 0,
"product_name": "添加关联辅料",
"count": 1,
"seller_sku": "",
"customization": "DDAV",
"item_unit_price": "100.00",
"item_total_price": "100.00",
"real_weight_total": "0.00",
"fee_weight_total": "0.00",
"volume_weight_total": "0.00",
"apportion_freight": "0.000000",
"apportion_freight_single": "0.000000",
"cn_name": "",
"en_name": "",
"unit_price": "",
"currency_code": "$",
"declared_currency_icon": "",
"logistics_freight_currency_code": "",
"stock_cost": "0.000000",
"third_product_name": "",
"third_product_code": ""
}
],
"status_name": "已截单",
"logistics_status_name": "已下单",
"target_country": "美国",
"surface_file": {
"cos_url": "",
"uri": "",
"ext": "",
"size": ""
},
"platform_name": "Amazon",
"platform_order_no": [
"testverppp0117"
],
"package_delivered_data": [],
"logistics_provider_name": "shipout",
"logistics_type_name": "未命名101010",
"warehouse_name": "ruec本地仓",
"pkg_volume": "0.00",
"pkg_length": "0.00",
"pkg_width": "0.00",
"pkg_height": "0.00",
"pkg_weight": "0.000",
"pkg_real_weight": "0.000",
"pkg_fee_weight": "0.000",
"pkg_weight_unit": "g",
"pkg_real_weight_unit": "g",
"pkg_fee_weight_unit": "g",
"pkg_size_unit": "cm",
"logistics_estimated_freight": "0.00",
"logistics_freight": "0.00",
"logistics_estimated_freight_currency_code": "CNY",
"logistics_freight_currency_code": "",
"recipient_tax_no": "",
"sender_tax_no": "",
"create_at": "2023-08-02 14:07:54"
}
],
"total": 1
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | page | 分页页码 | integer | — | Optional | 分页页码,默认1 |
| 2 | page_size | 分页长度 | integer | — | Optional | 分页长度,默认20,上限200 |
| 3 | sid_arr | 店铺id | array<any> | — | Optional | 店铺id |
| 4 | status_arr | 状态 | array<any> | — | Optional | 状态: 1 物流下单 2 待出库 3 已出库 4 已截单 |
| 5 | logistics_status_arr | 物流状态 | array<any> | — | Optional | 物流状态: 1 待导入 2 物流待下单 3 物流下单中 4 下单异常 5 下单完成 6 待海外仓下单 7 海外仓下单中 11 待导入国内物流 41 物流取消中 42 物流取消异常 43 物流取消完成 |
| 6 | platform_order_no_arr | 平台单号 | array<any> | — | Optional | 平台单号 |
| 7 | order_number_arr | 系统单号 | array<any> | — | Optional | 系统单号 |
| 8 | wo_number_arr | 销售出库单号 | array<any> | — | Optional | 销售出库单号 |
| 9 | time_type | 时间类型 | string | — | Optional | 时间类型: 创建时间 create_at 出库时间【单据操作】 delivered_at 流水出库时间 stock_delivered_at 变更时间 update_at |
| 10 | start_date | 开始日期 | string | — | Optional | 开始日期,格式:Y-m-d,默认为最近1个月 |
| 11 | end_date | 结束日期 | string | — | Optional | 结束日期,格式:Y-m-d,默认为最近1个月 |
| 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 | 82D9A20A-FF87-4BFF-E6D9-22D7A6D3433C | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2020-05-18 11:23:47 | Required | 响应时间 |
| 6 | total | 总数 | integer | 83 | Required | 总数 |
| 7 | data | 响应数据 | array<object> | — | Required | 响应数据 |
| 7.1 | wo_id | 出库单id | integer | 4398 | Required | 出库单id |
| 7.2 | wo_number | 销售出库单号 | string | WO103132593465409536 | Required | 销售出库单号 |
| 7.3 | sid | 店铺id | integer | 16 | Required | 店铺id |
| 7.4 | seller_name | 店铺名称 | string | 8P-SLITE-US | Required | 店铺名称 |
| 7.5 | site_text | 站点名称 | string | [Amazon].美国 | Required | 站点名称 |
| 7.6 | wid | 仓库id | integer | 26 | Required | 仓库id |
| 7.7 | warehouse_name | 仓库名 | string | 仓库1 | Required | 仓库名 |
| 7.8 | warehouse_type | 仓库类型 | integer | 1 | Required | 仓库类型: 1 本地仓库 2 FBA仓 3 第三方海外仓 |
| 7.9 | logistics_way | 下单流程 | integer | 1 | Required | 下单流程 1:物流 2:海外仓 3:仓配分离 |
| 7.10 | batch_no | 批次号 | string | — | Required | 批次号 |
| 7.11 | reference_no | 参考号 | string | — | Required | 参考号 |
| 7.12 | waybill_no | 运单号 | string | — | Required | 运单号 |
| 7.13 | tracking_no | 跟踪号 | string | — | Required | 跟踪号 |
| 7.14 | picker | 拣货人 | string | — | Required | 拣货人 |
| 7.15 | platform_name | 平台名称 | string | Amazon | Required | 平台名称 |
| 7.16 | platform_order_no | 平台单号 | array<any> | ["test123465021"] | Required | 平台单号 |
| 7.17 | order_number | 系统单号 | string | 103130837064323072 | Required | 系统单号 |
| 7.18 | order_from | 订单来源 | string | 手工订单 | Required | 订单来源 |
| 7.19 | order_type | 订单类型 | integer | 1 | Required | 订单类型: 1 一单一件 2 多品多件【原一单多件】 3 单品多件 |
| 7.20 | order_origin_amount | 订单金额 | string | 10.00 | Required | 订单金额 |
| 7.21 | order_currency_code | 订单币种 | string | USD | Required | 订单币种 |
| 7.22 | order_customer_service_notes | 客服备注 | string | — | Required | 客服备注 |
| 7.23 | order_buyer_notes | 买家留言 | string | 买家留言1 | Required | 买家留言 |
| 7.24 | status | 状态 | integer | 4 | Required | 状态: 1 物流下单 2 待出库 3 已出库 4 已截单 |
| 7.25 | status_name | 状态名称 | string | 物流下单 | Required | 状态名称 |
| 7.26 | logistics_status | 物流下单状态 | integer | 43 | Required | 物流下单状态: 1 待导入 2 物流待下单 3 物流下单中 4 下单异常 5 下单完成 6 待海外仓下单 7 海外仓下单中 11 待导入国内物流 41 物流取消中 42 物流取消异常 43 物流取消完成 |
| 7.27 | logistics_status_name | 物流下单状态名称 | string | 待导入 | Required | 物流下单状态名称 |
| 7.28 | logistics_message | 物流下单消息 | string | — | Required | 物流下单消息 |
| 7.29 | cancel_status | 第三方仓取消状态 | integer | 1 | Required | 第三方仓取消状态:0无需处理、1取消中、2取消异常、3取消成功 |
| 7.30 | cancel_message | 第三方仓取消返回消息 | string | 1 | Required | 第三方仓取消返回消息 |
| 7.31 | delivery_status | 第三方仓发货状态 | integer | 1 | Required | 第三方仓发货状态:20待发货、21发货中、22发货异常、23发货成功 |
| 7.32 | delivery_message | 第三方仓发货异常消息 | string | 1 | Required | 第三方仓发货异常消息 |
| 7.33 | logistics_provider_id | 物流服务商id | integer | 1 | Required | 物流服务商id |
| 7.34 | logistics_provider_name | 物流服务商名称 | string | 云途 | Required | 物流服务商名称 |
| 7.35 | logistics_type_id | 物流方式id | integer | 101 | Required | 物流方式id |
| 7.36 | logistics_type_name | 物流方式名称 | string | Wish邮平邮(DG) | Required | 物流方式名称 |
| 7.37 | logistics_freight | 物流运费 | string | 0.00 | Required | 物流运费 |
| 7.38 | logistics_freight_currency_code | 物流运费币种 | string | — | Required | 物流运费币种 |
| 7.39 | logistics_estimated_freight | 预估运费 | string | 0.00 | Required | 预估运费 |
| 7.40 | logistics_estimated_freight_currency_code | 预估运费币种 | string | CNY | Required | 预估运费币种 |
| 7.41 | is_check | 是否验货 | integer | — | Required | 是否验货:0 否,1 是 |
| 7.42 | is_weigh | 是否称重 | integer | — | Required | 是否称重:0 否,1 是 |
| 7.43 | is_surface_print | 面单是否打印 | integer | — | Required | 面单是否打印:0 否,1 是 |
| 7.44 | is_order_print | 订单是否打印 | integer | — | Required | 订单是否打印:0 否,1 是 |
| 7.45 | process_sn | 加工单号 | string | — | Required | 加工单号 |
| 7.46 | target_country | 收货国家 | string | 美国 | Required | 收货国家 |
| 7.47 | tag_names | 标签 | array<any> | — | Required | 标签 |
| 7.48 | pkg_volume | 包裹体积 | string | 0.00 | Required | 包裹体积 |
| 7.49 | pkg_length | 包裹尺寸长 | string | 0.00 | Required | 包裹尺寸长 |
| 7.50 | pkg_width | 包裹尺寸宽 | string | 0.00 | Required | 包裹尺寸宽 |
| 7.51 | pkg_height | 包裹尺寸高 | string | 0.00 | Required | 包裹尺寸高 |
| 7.52 | pkg_weight | 估算重量 | string | 0.000 | Required | 估算重量 |
| 7.53 | pkg_real_weight | 包裹实重 | string | 0.000 | Required | 包裹实重 |
| 7.54 | pkg_fee_weight | 包裹计费重 | string | 0.000 | Required | 包裹计费重 |
| 7.55 | pkg_weight_unit | 预估重量单位 | string | g | Required | 预估重量单位 |
| 7.56 | pkg_real_weight_unit | 包裹实重单位 | string | g | Required | 包裹实重单位 |
| 7.57 | pkg_fee_weight_unit | 包裹计费重单位 | string | g | Required | 包裹计费重单位 |
| 7.58 | pkg_size_unit | 包裹尺寸单位 | string | cm | Required | 包裹尺寸单位 |
| 7.59 | recipient_tax_no | 收件人税号 | string | — | Required | 收件人税号 |
| 7.60 | sender_tax_no | 发件人税号 | string | — | Required | 发件人税号 |
| 7.61 | deliverer | 发货人 | string | — | Required | 发货人 |
| 7.62 | deliver_deadline | 发货时限 | string | — | Required | 发货时限 |
| 7.63 | delivered_at | 出库时间 | string | — | Required | 出库时间 |
| 7.64 | stock_delivered_at | 库存流水出库时间 | string | — | Required | 库存流水出库时间 |
| 7.65 | create_at | 创建时间 | string | 2021-12-16 20:02:19 | Required | 创建时间 |
| 7.66 | update_at | 变更时间 | string | 2021-12-16 20:02:19 | Required | 变更时间 |
| 7.67 | purchase_time | 下单时间 | string | 2023-08-01 15:09:28 | Required | 下单时间 |
| 7.68 | payment_time | 付款时间 | string | 2023-08-01 15:09:28 | Required | 付款时间 |
| 7.69 | surface_print_time | 面单打印时间 | string | 0000-00-00 00:00:00 | Required | 面单打印时间 |
| 7.70 | order_print_time | 订单打印时间 | string | 0000-00-00 00:00:00 | Required | 订单打印时间 |
| 7.71 | platform_payment_time | 平台结算时间 | string | — | Required | 平台结算时间 |
| 7.72 | package_no | 小包号(用于组包) | string | — | Required | 小包号(用于组包) |
| 7.73 | package_delivered_data | 包裹出库信息 | array<any> | — | Required | 包裹出库信息 |
| 7.74 | transfer_logistics_company_code | 国内中转物流公司代码 | string | — | Required | 国内中转物流公司代码 |
| 7.75 | transfer_logistics_company_id | 国内中转物流公司id | string | — | Required | 国内中转物流公司id |
| 7.76 | transfer_tracking_no | 国内中转跟踪号 | string | — | Required | 国内中转跟踪号 |
| 7.77 | is_lock_storage | 是否已锁定库存 | integer | 0 | Required | 是否已锁定库存:0 否,1 是 |
| 7.78 | is_advance_delivery | 是否预发货 | integer | 1 | Required | 是否预发货:0 否,1 是 |
| 7.79 | apportion_status | 费用分摊状态 | integer | 0 | Required | 费用分摊状态: 1 未分摊 2 分摊失败 3 分摊成功 |
| 7.80 | apportion_message | 费用分摊消息 | string | — | Required | 费用分摊消息 |
| 7.81 | remark_attachment | 客服备注附件json | string | [] | Required | 客服备注附件json |
| 7.82 | surface_file_type | 面单文件类型 | string | — | Required | 面单文件类型 |
| 7.83 | surface_file | 面单文件 | object | — | Required | 面单文件 |
| 7.83.1 | cos_url | COS地址链接 | string | — | Required | COS地址链接,30分钟有效 |
| 7.83.2 | uri | 链接【已废弃 | string | — | Required | 链接【已废弃,建议使用cos_url】 |
| 7.83.3 | ext | 文件后缀 | string | — | Required | 文件后缀 |
| 7.83.4 | size | 文件尺寸 | string | — | Required | 文件尺寸 |
| 7.84 | product_info | 商品信息 | array<object> | — | Required | 商品信息 |
| 7.84.1 | wod_id | 出库单明细id | integer | — | Required | 出库单明细id |
| 7.84.2 | product_id | 商品id | integer | 6127 | Required | 商品id |
| 7.84.3 | sku | sku | string | zifahuo | Required | SKU |
| 7.84.4 | count | 数量 | integer | 2 | Required | 数量 |
| 7.84.5 | bundle_type | 捆绑类型 | integer | 0 | Required | 捆绑类型: 0 普通商品 - 含组合产品、子产品 1 捆绑产品 2 捆绑产品拆分子产品 |
| 7.84.6 | bundle_wod_id | 捆绑产品wod_id【只有拆分子产品才有】 | integer | — | Required | 捆绑产品wod_id【只有拆分子产品才有】 |
| 7.84.7 | product_name | 商品名 | string | 自发货接口测试 | Required | 商品名 |
| 7.84.8 | seller_sku | seller_sku | string | — | Required | MSKU |
| 7.84.9 | customization | 商品备注 | string | DDAV | Required | 商品备注 |
| 7.84.10 | cn_name | 中文申报名 | string | — | Required | 中文申报名 |
| 7.84.11 | en_name | 英文申报名 | string | — | Required | 英文申报名 |
| 7.84.12 | third_product_name | 三方仓品名 | string | — | Required | 三方仓品名 |
| 7.84.13 | third_product_code | 三方仓SKU | string | — | Required | 三方仓SKU |
| 7.84.14 | unit_price | 商品单价 | string | — | Required | 商品单价 |
| 7.84.15 | currency_code | 币种 | string | $ | Required | 币种 |
| 7.84.16 | apportion_freight | 分摊运费 (总计) | string | 0.000000 | Required | 分摊运费 (总计) |
| 7.84.17 | apportion_freight_single | 分摊运费 (单个) | string | 0.000000 | Required | 分摊运费 (单个) |
| 7.84.18 | logistics_freight_currency_code | 物流运费币种 | string | — | Required | 物流运费币种 |
| 7.84.19 | stock_cost | 库存成本 (总计) | string | 6.00 | Required | 库存成本 (总计) |
| 7.84.20 | stock_sid | 库存颗粒度店铺id | string | 0 | Required | 库存颗粒度店铺id |
| 7.84.21 | stock_seller_name | 库存颗粒度店铺名称 | string | — | Required | 库存颗粒度店铺名称 |
| 7.84.22 | item_unit_price | 销售单价 | string | 100.00 | Required | 销售单价 |
| 7.84.23 | item_total_price | 销售总价 | string | 100.00 | Required | 销售总价 |
| 7.84.24 | real_weight_total | 费用分摊-总实重 | string | 0.00 | Required | 费用分摊-总实重 |
| 7.84.25 | fee_weight_total | 费用分摊-总计费重 | string | 0.00 | Required | 费用分摊-总计费重 |
| 7.84.26 | volume_weight_total | 费用分摊-总体集中 | string | 0.00 | Required | 费用分摊-总体集中 |
| 7.84.27 | declared_currency_icon | 申报比重图标 | string | | Required | 申报比重图标 |
The 查询销售出库单列表 API (/erp/sc/routing/wms/order/wmsOrderList) 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.