/cepf/warehouse/api/openApi/queryShippingListPage{
"operation": {
"method": "POST",
"path": "/cepf/warehouse/api/openApi/queryShippingListPage"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 10,
"text": ""
},
"requestExample": {
"store_id": [
"110000000020008001"
],
"cargo_code": "test0508001-shipment-2",
"shipping_list_codes": [
"SP202307310010190"
],
"shipping_list_status": 1,
"start_time": "2023-07-08",
"end_time": "2023-08-08",
"offset": 0,
"length": 15
},
"responseExample": "{\n \"code\": 0,\n \"message\": \"success\",\n \"error_details\": [],\n \"request_id\": \"1d466c647e624c7cb6c686e332ade41f.117.16909686672353653\",\n \"response_time\": \"2023-08-02 17:31:07\"\n \"data\": {\n \"total\": \"29\",\n \"records\": [\n {\n \"shipping_code\": \"SP202302080010030\",\n \"shipping_status\": \"待发货\",\n \"delivery_time\": \"1970-01-01\",\n \"warehouse_id\": 4244,\n \"logistics_provider_id\": \"145\",\n \"logistics_channel_id\": \"3\",\n \"creator\": \"吴x\",\n \"gmt_create\": \"2023-02-08 10:37:29\",\n \"actual_delivery_time\": null,\n \"arrival_time\": \"2023-02-08\",\n \"sail_time\": null,\n \"expected_arrival_time\": null,\n \"actual_due_ime\": null,\n \"logistics_code\": \"LRY03\",\n \"principal_user_name\": null,\n \"shipping_remark\": \"\",\n \"head_fee_type\": \"按计费重\",\n \"order_logistics_status\": \"\",\n \"shipping_list_files\": [\n {\n \"shipping_list_file_url\": \"https://xxx/xxx30731.xlsx\",\n \"shipping_list_file_name\": \"已发货订单模板20230731.xlsx\"\n }\n ],\n \"shipping_logistics\": [\n {\n \"logistics_number\": \"\",\n \"tracking_number\": \"667439072605\",\n \"expected_transportation_cost\": \"0.00\",\n \"expected_transportation_currency\": \"CNY\",\n \"expected_other_cost_remark\": \"\",\n \"expected_other_cost\": \"0.00\",\n \"expected_other_currency\": \"CNY\",\n \"other_cost_remark\": \"\",\n \"transportation_currency\": \"CNY\",\n \"transportation_cost\": \"0.00\",\n \"other_cost\": \"0.00\",\n \"other_currency\": \"CNY\"\n },\n {\n \"logistics_number\": \"\",\n \"tracking_number\": \"667439072606\",\n \"expected_transportation_cost\": \"0.00\",\n \"expected_transportation_currency\": \"CNY\",\n \"expected_other_cost_remark\": \"\",\n \"expected_other_cost\": \"0.00\",\n \"expected_other_currency\": \"CNY\",\n \"other_cost_remark\": \"\",\n \"transportation_currency\": \"CNY\",\n \"transportation_cost\": \"0.00\",\n \"other_cost\": \"0.00\",\n \"other_currency\": \"CNY\"\n }\n ],\n \"shipping_goods\": [\n {\n \"whbCodeInfo\": null,\n \"platform_name\": \"Walmart\",\n \"country_name\": \"美国\",\n \"store_name\": \"test6自创walmart测试店铺3号\",\n \"cargo_code\": \"lry-shipment-47\",\n \"msku\": \"lry-sku3-47\",\n \"product_name\": \"ww-0825-01\",\n \"sku\": \"ww-0825-01\",\n \"goods_url\": \"\",\n \"quantity_in_case\": \"0\",\n \"box_num\": \"0\",\n \"cbm\": \"0.00\",\n \"cg_product_net_weight\": \"0.00\",\n \"cg_product_gross_weight\": \"0.00\",\n \"box_wet_weight\": \"0.00\",\n \"box_gross_weight\": \"0.00\",\n \"volume_weight\": \"0.00\",\n \"apply_num\": \"10\",\n \"shipments_num\": \"10\",\n \"total_nw\": \"0.00\",\n \"total_gw\": \"0.00\",\n \"tax_amount\": \"0.00\",\n \"tax_currency\": \"USD\",\n \"remark\": \"\",\n \"spec_info\": {\n \"cg_product_net_weight\": \"0.00\",\n \"spec_pack_list\": [\n {\n \"pps_id\": \"210324392619860481\",\n \"spec_title\": \"默认箱规\",\n \"is_default\": \"1\",\n \"cg_box_pcs\": \"0\",\n \"cg_box_length\": \"0.00\",\n \"cg_box_width\": \"0.00\",\n \"cg_box_height\": \"0.00\",\n \"cg_package_length\": \"0.00\",\n \"cg_package_width\": \"0.00\",\n \"cg_package_height\": \"0.00\",\n \"cg_product_gross_weight\": \"0.00\",\n \"cg_box_weight\": \"0.00\"\n }\n ]\n },\n \"box_length\": \"0.00\",\n \"box_width\": \"0.00\",\n \"box_height\": \"0.00\",\n \"package_length\": \"0.00\",\n \"package_width\": \"0.00\",\n \"package_height\": \"0.00\",\n \"box_weight\": \"0.00\",\n \"spec_id\": \"210258979648459236\",\n\t\t\t \"store_id\":\"110000000017008001\",\n }\n ],\n \"shipping_accessories\": null,\n \"shipping_first_lets\": null\n }\n ]\n }\n}"
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | store_id | 店铺id | array<any> | — | Optional | 店铺id |
| 2 | cargo_code | 货件单号 | string | — | Optional | 货件单号 |
| 3 | shipping_list_codes | 发货单编号 | array<any> | — | Optional | 发货单编号,上限100 |
| 4 | shipping_list_status | 发货单状态 | integer | — | Optional | 发货单状态: 0 待配货 1 待发货 2 已发货 3 已作废 |
| 5 | start_time | 开始时间【创建时间】 | string | — | Optional | 开始时间【创建时间】,格式:Y-m-d,双闭区间 |
| 6 | end_time | 结束时间【创建时间】 | string | — | Optional | 结束时间【创建时间】,格式:Y-m-d,双闭区间 |
| 7 | offset | 分页偏移量 | integer | — | Optional | 分页偏移量,默认0 |
| 8 | length | 分页长度 | integer | — | Optional | 分页长度,默认15,上限200 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | Required | 状态码,0 成功 |
| 2 | error_details | 错误信息 | array<any> | — | Required | 错误信息 |
| 3 | message | 消息提示 | string | success | Required | 消息提示 |
| 4 | request_id | 请求链路id | string | 110e3649dabd4f14a660de04b1755ee7.1690443265873 | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2023-07-01 08:11:11 | Required | 响应时间 |
| 6 | data | 响应数据 | object | — | Required | 响应数据 |
| 6.1 | total | 总数 | string | 200 | Required | 总数 |
| 6.2 | records | 详细信息列表 | array<object> | — | Required | 详细信息列表 |
| 6.2.1 | actual_delivery_time | 实际发货时间 | string | 2023-08-13 | Required | 实际发货时间 |
| 6.2.2 | actual_due_ime | 实际妥投时间 | string | 2023-08-13 | Required | 实际妥投时间 |
| 6.2.3 | arrival_time | 到货时间 | string | 2023-08-13 | Required | 到货时间 |
| 6.2.4 | creator | 创建人 | string | 管理员 | Required | 创建人 |
| 6.2.5 | delivery_time | 发货时间 | string | 2023-08-13 | Required | 发货时间 |
| 6.2.6 | expected_arrival_time | 预计到港时间 | string | 2023-08-13 | Required | 预计到港时间 |
| 6.2.7 | gmt_create | 发货单创建时间 | string | 2023-07-31 15:33:05 | Required | 发货单创建时间 |
| 6.2.8 | head_fee_type | 分摊方式 | string | 按SKU数量 | Required | 分摊方式 |
| 6.2.9 | logistics_code | 物流中心编码 | string | LRY03 | Required | 物流中心编码 |
| 6.2.10 | logistics_provider_id | 物流商id | string | 1 | Required | 物流商id |
| 6.2.11 | order_logistics_status | 订单物流状态 | string | 物流状态 | Required | 订单物流状态 |
| 6.2.12 | principal_user_name | 负责人名称 | string | 吴 | Required | 负责人名称 |
| 6.2.13 | sail_time | 开船时间 | string | 2023-08-13 | Required | 开船时间 |
| 6.2.14 | shipping_code | 发货单号 | string | SP202307310010190 | Required | 发货单号 |
| 6.2.15 | shipping_status | 状态 | string | 已发货 | Required | 状态: 待配货 待发货 已发货 已作废 |
| 6.2.16 | shipping_accessories | 平台发货单关联辅料信息 | array<object> | — | Required | 平台发货单关联辅料信息 |
| 6.2.16.1 | accessories_price | 单位成本 | string | 0.00 | Required | 单位成本 |
| 6.2.16.2 | accessories_total_price | 辅料总成本 | string | 0.00 | Required | 辅料总成本 |
| 6.2.16.3 | aux_name | 辅料品名 | string | lry辅料009 | Required | 辅料品名 |
| 6.2.16.4 | aux_num | 辅料发货量 | string | 2 | Required | 辅料发货量 |
| 6.2.16.5 | aux_sku | 辅料sku | string | lryfl009 | Required | 辅料sku |
| 6.2.16.6 | relation_typeName | 费用关联方式 | string | 关联商品 | Required | 费用关联方式 |
| 6.2.17 | shipping_first_lets | 平台发货单头程分摊信息 | array<object> | — | Required | 平台发货单头程分摊信息 |
| 6.2.17.1 | aux_stock_price | 单位辅料费用 | string | 0.00 | Required | 单位辅料费用 |
| 6.2.17.2 | delivery_num | 发货量 | string | 1 | Required | 发货量 |
| 6.2.17.3 | good_name | 品名 | string | test050502pm | Required | 品名 |
| 6.2.17.4 | gtin | 平台标签 | string | 006344827368521 | Required | 平台标签 |
| 6.2.17.5 | head_stock_price | 单位出库头程 | string | 0.00 | Required | 单位出库头程 |
| 6.2.17.6 | msku | msku | string | msku | Required | MSKU |
| 6.2.17.7 | per_first_let_cost | 单位头程费用 | string | 0.00 | Required | 单位头程费用 |
| 6.2.17.8 | per_tax | 单位税费 | string | 0.00 | Required | 单位税费 |
| 6.2.17.9 | price | 单位出库费用 | string | 0.00 | Required | 单位出库费用 |
| 6.2.17.10 | purchase_price | 采购单价 | string | 0.00 | Required | 采购单价 |
| 6.2.17.11 | sku | sku | string | sku | Required | sku |
| 6.2.17.12 | value_source | 头程费用计算取值类型 | string | 实际费用 | Required | 头程费用计算取值类型 |
| 6.2.17.13 | wfs_stock_price | 单位WFS库存成本 | string | 0.00 | Required | 单位WFS库存成本 |
| 6.2.18 | shipping_goods | 平台发货单商品信息 | array<object> | — | Required | 平台发货单商品信息 |
| 6.2.18.1 | apply_num | 申报量 | string | 10 | Required | 申报量 |
| 6.2.18.2 | box_gross_weight | 单箱毛重(kg) | string | 10.00 | Required | 单箱毛重(kg) |
| 6.2.18.3 | box_num | 箱数 | string | 10 | Required | 箱数 |
| 6.2.18.4 | box_wet_weight | 单箱净重(kg) | string | 10.00 | Required | 单箱净重(kg) |
| 6.2.18.5 | cargo_code | 货件单号 | string | test0508001-shipment-2 | Required | 货件单号 |
| 6.2.18.6 | cbm | CMB(m³) | string | 0.01 | Required | CMB(m³) |
| 6.2.18.7 | cg_product_gross_weight | 单品毛重(g) | string | 1.01 | Required | 单品毛重(g) |
| 6.2.18.8 | cg_product_net_weight | 单品净重(g) | string | 1.01 | Required | 单品净重(g) |
| 6.2.18.9 | country_name | 国家名称 | string | 中国 | Required | 国家名称 |
| 6.2.18.10 | goods_url | 商品图片 | string | https://image.disibxxx/03a8b.jpeg | Required | 商品图片 |
| 6.2.18.11 | msku | msku | string | msku | Required | msku |
| 6.2.18.12 | platform_name | 平台名称 | string | 沃尔玛 | Required | 平台名称 |
| 6.2.18.13 | product_name | 商品名称 | string | 商品 | Required | 商品名称 |
| 6.2.18.14 | quantity_in_case | 单箱数量 | integer | 10 | Required | 单箱数量 |
| 6.2.18.15 | remark | 备注 | string | 备注 | Required | 备注 |
| 6.2.18.16 | shipments_num | 发货量 | string | 10 | Required | 发货量 |
| 6.2.18.17 | sku | sku | string | ku | Required | sku |
| 6.2.18.18 | spec_info | 产品箱规总信息 | object | — | Required | 产品箱规总信息 |
| 6.2.18.18.1 | cg_product_net_weight | 单品净重 | string | 2.00 | Required | 单品净重 |
| 6.2.18.18.2 | spec_pack_list | 箱规信息 | array<object> | — | Required | 箱规信息 |
| 6.2.18.18.2.1 | cg_box_height | 箱子高度 | string | 1.00 | Required | 箱子高度 |
| 6.2.18.18.2.2 | cg_box_length | 箱子长度 | string | 1.00 | Required | 箱子长度 |
| 6.2.18.18.2.3 | cg_box_pcs | 单箱数量 | string | 1 | Required | 单箱数量 |
| 6.2.18.18.2.4 | cg_box_weight | 单箱重量 | string | 1.00 | Required | 单箱重量 |
| 6.2.18.18.2.5 | cg_box_width | 箱子宽度 | string | 1.00 | Required | 箱子宽度 |
| 6.2.18.18.2.6 | cg_package_height | 包装规格高度 | string | 1.00 | Required | 包装规格高度 |
| 6.2.18.18.2.7 | cg_package_length | 包装规格长度 | string | 1.00 | Required | 包装规格长度 |
| 6.2.18.18.2.8 | cg_package_width | 包装规格宽度 | string | 1.00 | Required | 包装规格宽度 |
| 6.2.18.18.2.9 | cg_product_gross_weight | 单品毛重 | string | 1.00 | Required | 单品毛重 |
| 6.2.18.18.2.10 | pps_id | 规格id | string | 210261409165525663 | Required | 规格id |
| 6.2.18.19 | store_name | 店铺名称 | string | 测试店铺 | Required | 店铺名称 |
| 6.2.18.20 | tax_amount | 税费 | string | 1.00 | Required | 税费 |
| 6.2.18.21 | tax_currency | 税费币种 | string | CNY | Required | 税费币种 |
| 6.2.18.22 | total_gw | 总毛重(kg) | string | 1.00 | Required | 总毛重(kg) |
| 6.2.18.23 | total_nw | 总净重(kg) | string | 1.00 | Required | 总净重(kg) |
| 6.2.18.24 | volume_weight | 体积重(kg) | string | .00 | Required | 体积重(kg) |
| 6.2.18.25 | whbCodeInfo | 仓位信息 | array<object> | — | Required | 仓位信息 |
| 6.2.18.25.1 | product_id | 产品编号 | integer | 5280 | Required | 产品编号 |
| 6.2.18.25.2 | stock_num | 仓位对应库存数量 | integer | 1988 | Required | 仓位对应库存数量 |
| 6.2.18.25.3 | whb_code | 仓位code | string | ts_valid | Required | 仓位code |
| 6.2.18.25.4 | whb_name | 仓位名称 | string | 可用 | Required | 仓位名称 |
| 6.2.18.25.5 | whb_num | 手动填写的仓位数量 | integer | 10 | Required | 手动填写的仓位数量 |
| 6.2.18.26 | box_length | 箱子长度(cm) | string | 1.00 | Required | 箱子长度(cm) |
| 6.2.18.27 | box_width | 箱子宽度(cm) | string | 1.00 | Required | 箱子宽度(cm) |
| 6.2.18.28 | box_height | 箱子高度(cm) | string | 1.00 | Required | 箱子高度(cm) |
| 6.2.18.29 | package_length | 包装长度(cm) | string | 1.00 | Required | 包装长度(cm) |
| 6.2.18.30 | package_width | 包装宽度(cm) | string | 1.00 | Required | 包装宽度(cm) |
| 6.2.18.31 | package_height | 包装高度(cm) | string | 1.00 | Required | 包装高度(cm) |
| 6.2.18.32 | box_weight | 单箱重量kg) | string | 1.00 | Required | 单箱重量kg) |
| 6.2.18.33 | spec_id | 规格id | string | 210261409165525663 | Required | 规格id |
| 6.2.18.34 | store_id | 店铺id | string | 110000000017008001 | Required | 店铺id |
| 6.2.19 | shipping_list_files | 附件信息 | array<object> | — | Required | 附件信息 |
| 6.2.19.1 | shipping_list_file_name | 文件名称 | string | 已发货订单模板20230729.xlsx | Required | 文件名称 |
| 6.2.19.2 | shipping_list_file_url | 附件url | string | https://xxxx/A1%E6%9D%BF20230729.xlsx | Required | 附件url |
| 6.2.20 | shipping_logistics | 平台发货单物流信息 | array<object> | — | Required | 平台发货单物流信息 |
| 6.2.20.1 | expected_other_cost | 预估其他费用 | string | 1.00 | Required | 预估其他费用 |
| 6.2.20.2 | expected_other_cost_remark | 预估其他费用备注 | string | 备注 | Required | 预估其他费用备注 |
| 6.2.20.3 | expected_other_currency | 预估其他费用币种 | string | CNY | Required | 预估其他费用币种 |
| 6.2.20.4 | expected_transportation_cost | 预估物流费用 | string | 1.00 | Required | 预估物流费用 |
| 6.2.20.5 | expected_transportation_currency | 预估物流费用币种 | string | CNY | Required | 预估物流费用币种 |
| 6.2.20.6 | logistics_number | 物流商单号 | string | 6674390726051 | Required | 物流商单号 |
| 6.2.20.7 | other_cost | 实际其他费用 | string | 1.00 | Required | 实际其他费用 |
| 6.2.20.8 | other_cost_remark | 实际其他费用备注 | string | 实际其他费用备注 | Required | 实际其他费用备注 |
| 6.2.20.9 | other_currency | 实际其他费用币种 | string | CNY | Required | 实际其他费用币种 |
| 6.2.20.10 | tracking_number | 物流商跟踪号 | string | 667439072605 | Required | 物流商跟踪号 |
| 6.2.20.11 | transportation_cost | 实际费用 | string | 1.00 | Required | 实际费用 |
| 6.2.20.12 | transportation_currency | 实际费用币种 | string | CNY | Required | 实际费用币种 |
| 6.2.21 | shipping_remark | 备注 | string | 备注 | Required | 备注 |
| 6.2.22 | warehouse_id | 发货仓库id | integer | 70 | Required | 发货仓库id |
| 6.2.23 | logistics_channel_id | 物流渠道id | string | 3 | Required | 物流渠道id |
The 查询平台仓发货单列表 API (/cepf/warehouse/api/openApi/queryShippingListPage) 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.