当前位置: API文档

stock_production_order_query.php(查询生产加工单接口)

¥标准

1.接口说明

1.1 接口描述获取旺店通ERP生产加工单数据
1.2 适用版本:网页版
1.3增量获取:按照单据最后修改时间增量获取数据,请求时输入start_time和end_time作为时间跨度的筛选条件
1.4 时间跨度:start_time和end_time最大跨度为30天,开始时间和结束时间取值范围为闭区间取值,例如2018-11-01 00:00:00至2018-11-30 23:59:59,建议根据获取数据量的多少适当减小时间跨度。

2.调用场景

2.1 财务系统、SAP、数据分析等系统的对接

3.请求参数说明

   3.1 请求地址

环境HTTP地址
测试环境https://openapi.ali.huice.cc/openapi/stock_production_order_query.php
正式环境https://openapi.huice.com/openapi/stock_production_order_query.php

   3.2 公共请求参数

名称字段类型长度
必须描述
卖家账号sidString
购买ERP时由旺店通分配给ERP购买方,请从ERP购买方获取。
接口账号appkeyString
本开放平台“自助对接”功能模块内自助申请,获取方式点击这里
时间戳timestampint
北京时间1970-01-01 08:00:00起至现在的总秒数,10位int值,旺店通企业版API服务端允许请求最大时间误差为5min,date.timezone = Asia/Shanghai。
签名signString
API输入参数签名结果,签名算法介绍单击这里

  3.3 业务请求参数


名称字段类型长度
必须描述

生产加工单号

production_no

String40

生产加工单号,传该字段可以不传时间范围

状态

status

int11

状态

5:已作废

10:已取消

20:待审核

32:出库待推送

34:出库推送失败

38:委外待领料"

40:待领料"

45:领料中"

50:生产中"

52:入库单待推送"

54:入库单推送失败"

57:委外待入库"

60:部分入库"

100:已生产"

开始时间start_timedatetime

按最后修改时间增量获取数据,start_time作为开始时间,格式:yyyy-MM-dd HH:mm:ss
结束时间end_timedatetime
按最后修改时间增量获取数据,end_time作为结束时间,格式:yyyy-MM-dd HH:mm:ss
分页大小
page_size
int


每页返回的数据条数,输入值范围1~100,不传本参数,输入值默认为40,使用举例单击这里
页号
page_no
int


页号默认从0开始

4.响应参数

4.1 公共响应参数

名称字段类型长度必须描述
错误码codeint
错误码,0成功
错误描述messagevarchar
错误描述
数据总条数total_countint
符合条件的数据总条数,当page_no=0时返回,用来分页

生产加工单列表

data

data[]

响应参数的1级数据节点,包含生产加工单列表

   4.2 业务响应参数

   data

名称字段类型长度必须描述

生产加工单号

production_no

string


生产加工单号

生产入库仓id

stockin_warehouse_id

bigint

20

生产入库仓id

入库仓库名称

stockin_warehouse_name

string


入库仓库名称

生产出库仓id

stockout_warehouse_id

bigint20
生产出库仓id

出库仓库名称

stockout_warehouse_name

string
出库仓库名称

生产方式

production_type

int
生产方式

生产类型

production_mode

bigint20

生产类型

状态

status

int
状态

加工费用

processing_fee

decimal
加工费用

状态文案

status_text

string40状态文案

消耗品数

children_num

decimal
消耗品数

消耗品已出库数量

children_already_num

decimal
消耗品已出库数量

消耗品未出库数量

children_not_num

decimal

消耗品未出库数量

生产品已入库数量

parent_already_num

decimal
生产品已入库数量

生产品未入库数量

parent_not_num

decimal
生产品未入库数量

生产员

produceman_name

string
生产员

领料人

material_by_name

string
领料人

备注

remark

string
备注

打印状态

print_status_text

string
打印状态

推送出库单号

outer_out_no

string
推送出库单号

推送入库单号

outer_in_no

string
推送入库单号

推送失败信息

error_info

string
推送失败信息

制单时间

create_date

datetime
制单时间

生产次数

production_times

int
生产次数

最后修改时间

modify_date

datetime
最后修改时间

生产品数量

parent_num

decimal


生产品数量

生产品列表

target_sku_list

data[]

生产品明细节点,字段详细见target_sku_list

消耗品列表

source_sku_list

data[]
消耗品明细节点,字段详细见source_sku_list

target_sku_list

名称字段类型长度必须描述

商家编码(新)

sku_no

varchar

商家编码(新)

规格名称

sku_name

varchar

规格名称

货品名称

spu_name

varchar

货品名称

批次

batch_no

varchar

批次

生产日期

production_date

datetime

生产日期

保质期

validity_days

int11

保质期

有效期

expire_date

datetime

有效期

数量

num

decimal


数量

总数量

total_num

decimal


总数量

已入库数量

real_num

decimal


出入库时间

匹配数量

match_num

decimal


匹配数量

成本比例

cost_rate

decimal


成本比例

备注

remark

varchar
备注

source_sku_list

名称字段类型长度必须描述

商家编码(新)

sku_no

varchar

商家编码(新)

规格名称

sku_name

varchar

规格名称

货品名称

spu_name

varchar

货品名称

批次

batch_no

varchar

批次

生产日期

production_date

datetime

生产日期

保质期

validity_days

int11

保质期

有效期

expire_date

datetime

有效期

数量

num

decimal


数量

总数量

total_num

decimal


总数量

已出库数量

real_num

decimal


已出库数量

备注

remark

varchar
备注


5.响应示例

   5.1 正常响应示例 

JSON
{
    "code": 0,
    "message": "",
    "total_count": 13,
    "data": [
        {
            "id": "2772145811436339220",
            "production_no": "SC2512110004",
            "stockout_warehouse_id": "5",
            "stockout_warehouse_name": "hazs01",
            "stockin_warehouse_id": "19",
            "stockin_warehouse_name": "xx的仓库",
            "production_type": 2,
            "production_mode": 1,
            "status": 50,
            "status_text": "生产中",
            "production_amount": "10.0000",
            "parent_num": "9.0000",
            "parent_already_num": "0.0000",
            "parent_not_num": "9.0000",
            "children_num": "9.0000",
            "children_already_num": "9.0000",
            "children_not_num": "0.0000",
            "produceman_id": 3621,
            "produceman_name": "guijun",
            "material_by": "",
            "material_by_name": "",
            "remark": "大备注",
            "print_status": 1,
            "print_status_text": "未打印",
            "outer_out_no": "",
            "outer_in_no": "",
            "error_info": "",
            "create_date": "2025-12-11T15:57:45",
            "production_times": 3,
            "modify_date": "2025-12-11T15:58:00",
            "target_sku_list": [
                {
                    "prop1": null,
                    "prop2": null,
                    "prop3": null,
                    "prop4": null,
                    "prop5": null,
                    "prop6": null,
                    "prop7": null,
                    "prop8": null,
                    "prop9": null,
                    "prop10": null,
                    "sku_id": "2768547700164001813",
                    "warehouse_id": null,
                    "sku_sort_name": null,
                    "sku_no": "9011",
                    "sku_name": "Large",
                    "sku_short_name": "",
                    "barcode": "251201203",
                    "spu_id": "2768547700138835989",
                    "spu_name": "家用杂物收纳盒大容量带盖透明桌面整理盒家居维修工具五金工具储物箱",
                    "spu_short_name": "",
                    "spu_no": "9011",
                    "spu_modify_date": "2025-12-11T10:22:24",
                    "plat_spu_no": "9011",
                    "plat_sku_no": "9011",
                    "image_url": "https://img.kwcdn.com/product/fancy/bc7c2a66-dad9-4532-809a-ade3ce8f9616.jpg",
                    "spu_img_url": "https://img.kwcdn.com/product/fancy/bc7c2a66-dad9-4532-809a-ade3ce8f9616.jpg",
                    "outer_sku_no": null,
                    "ref_cost_price": "0.0000",
                    "price": "0.0000",
                    "retail_price": "0.0000",
                    "wholesale_price": "0.0000",
                    "validity_days": null,
                    "unit_id": "0",
                    "unit_name": "",
                    "weight": "0.7240",
                    "box_sku_num": 0,
                    "sku_remark": null,
                    "sku_delete_flag": false,
                    "brand_id": "2713730725894423568",
                    "brand_name": "娃哈哈",
                    "goods_category_id": "0",
                    "approval_number": null,
                    "stock_num": null,
                    "quality_num": null,
                    "defect_num": null,
                    "default_position_name": null,
                    "location_name": null,
                    "location_id": null,
                    "stock_type": 0,
                    "stock_type_text": null,
                    "batch_id": null,
                    "batch_no": "",
                    "production_date": null,
                    "expire_date": null,
                    "id": "2772145811444729876",
                    "stock_production_id": "2772145811436339220",
                    "source_type": 2,
                    "num": "2.0000",
                    "total_num": "6.0000",
                    "real_num": "0.0000",
                    "match_num": "0.0000",
                    "cost_rate": "30.0000",
                    "remark": ""
                },
                {
                    "prop1": null,
                    "prop2": null,
                    "prop3": null,
                    "prop4": null,
                    "prop5": null,
                    "prop6": null,
                    "prop7": null,
                    "prop8": null,
                    "prop9": null,
                    "prop10": null,
                    "sku_id": "2769594574882996228",
                    "warehouse_id": null,
                    "sku_sort_name": null,
                    "sku_no": "源单号",
                    "sku_name": "",
                    "sku_short_name": "",
                    "barcode": "251204101",
                    "spu_id": "2769594574576812036",
                    "spu_name": "源单号",
                    "spu_short_name": "源单号",
                    "spu_no": "源单号",
                    "spu_modify_date": "2025-12-11T10:21:32",
                    "plat_spu_no": "",
                    "plat_sku_no": "",
                    "image_url": "https://img0.baidu.com/it/u=1119010193,3065907151&fm=253&fmt=auto&app=138&f=JPEG?w=171&h=190",
                    "spu_img_url": "https://img0.baidu.com/it/u=1119010193,3065907151&fm=253&fmt=auto&app=138&f=JPEG?w=171&h=190",
                    "outer_sku_no": null,
                    "ref_cost_price": "23.0000",
                    "price": "0.0000",
                    "retail_price": "0.0000",
                    "wholesale_price": "0.0000",
                    "validity_days": null,
                    "unit_id": "0",
                    "unit_name": "",
                    "weight": "0.0000",
                    "box_sku_num": 0,
                    "sku_remark": null,
                    "sku_delete_flag": false,
                    "brand_id": "2771698899490964486",
                    "brand_name": "42311234",
                    "goods_category_id": "0",
                    "approval_number": null,
                    "stock_num": null,
                    "quality_num": null,
                    "defect_num": null,
                    "default_position_name": null,
                    "location_name": null,
                    "location_id": null,
                    "stock_type": 0,
                    "stock_type_text": null,
                    "batch_id": null,
                    "batch_no": "",
                    "production_date": null,
                    "expire_date": null,
                    "id": "2772145811444730900",
                    "stock_production_id": "2772145811436339220",
                    "source_type": 2,
                    "num": "1.0000",
                    "total_num": "3.0000",
                    "real_num": "0.0000",
                    "match_num": "0.0000",
                    "cost_rate": "70.0000",
                    "remark": ""
                }
            ],
            "source_sku_list": [
                {
                    "prop1": null,
                    "prop2": null,
                    "prop3": null,
                    "prop4": null,
                    "prop5": null,
                    "prop6": null,
                    "prop7": null,
                    "prop8": null,
                    "prop9": null,
                    "prop10": null,
                    "sku_id": "2705127425343225892",
                    "warehouse_id": null,
                    "sku_sort_name": null,
                    "sku_no": "看看移位",
                    "sku_name": "看看移位",
                    "sku_short_name": "看看移位",
                    "barcode": "kk1",
                    "spu_id": "2705127425078984740",
                    "spu_name": "看看移位",
                    "spu_short_name": "看看移位",
                    "spu_no": "看看移位",
                    "spu_modify_date": "2025-10-23T16:58:23",
                    "plat_spu_no": "",
                    "plat_sku_no": "",
                    "image_url": "https://erpx-prod.oss-cn-zhangjiakou.aliyuncs.com/goods/2e03034d-2f73-4823-b219-5f6cfc506cb2/chen_176bebec5dea42feb81d2a7d457870da.jpeg",
                    "spu_img_url": "https://erpx-prod.oss-cn-zhangjiakou.aliyuncs.com/goods/2e03034d-2f73-4823-b219-5f6cfc506cb2/chen_176bebec5dea42feb81d2a7d457870da.jpeg",
                    "outer_sku_no": null,
                    "ref_cost_price": "30.0000",
                    "price": "0.0000",
                    "retail_price": "0.0000",
                    "wholesale_price": "0.0000",
                    "validity_days": null,
                    "unit_id": "2503594148196515843",
                    "unit_name": "个",
                    "weight": "10.0000",
                    "box_sku_num": 3,
                    "sku_remark": null,
                    "sku_delete_flag": false,
                    "brand_id": "0",
                    "brand_name": "",
                    "goods_category_id": "0",
                    "approval_number": null,
                    "stock_num": null,
                    "quality_num": null,
                    "defect_num": null,
                    "default_position_name": null,
                    "location_name": null,
                    "location_id": null,
                    "stock_type": 0,
                    "stock_type_text": null,
                    "batch_id": null,
                    "batch_no": "",
                    "production_date": null,
                    "expire_date": null,
                    "id": "2772145811444727828",
                    "stock_production_id": "2772145811436339220",
                    "source_type": 1,
                    "num": "2.0000",
                    "total_num": "6.0000",
                    "real_num": "6.0000",
                    "match_num": "0.0000",
                    "cost_rate": "0.0000",
                    "remark": ""
                },
                {
                    "prop1": null,
                    "prop2": null,
                    "prop3": null,
                    "prop4": null,
                    "prop5": null,
                    "prop6": null,
                    "prop7": null,
                    "prop8": null,
                    "prop9": null,
                    "prop10": null,
                    "sku_id": "2698966609925505031",
                    "warehouse_id": null,
                    "sku_sort_name": null,
                    "sku_no": "看看占用",
                    "sku_name": "看看占用",
                    "sku_short_name": "看看占用",
                    "barcode": "kk2",
                    "spu_id": "2698966609833230343",
                    "spu_name": "看看占用",
                    "spu_short_name": "看看占用",
                    "spu_no": "看看占用",
                    "spu_modify_date": "2025-08-13T15:29:10",
                    "plat_spu_no": "",
                    "plat_sku_no": "",
                    "image_url": "https://erpx-prod.oss-cn-zhangjiakou.aliyuncs.com/goods/8aacc900-04c6-4ee9-b013-0788eac782cd/chen_ff488239ea8a43119e8f0ed6eb3e427f.jpeg",
                    "spu_img_url": "https://erpx-prod.oss-cn-zhangjiakou.aliyuncs.com/goods/8aacc900-04c6-4ee9-b013-0788eac782cd/chen_ff488239ea8a43119e8f0ed6eb3e427f.jpeg",
                    "outer_sku_no": null,
                    "ref_cost_price": "20.0000",
                    "price": "0.0000",
                    "retail_price": "0.0000",
                    "wholesale_price": "0.0000",
                    "validity_days": null,
                    "unit_id": "2503594148225875971",
                    "unit_name": "瓶",
                    "weight": "1.6999",
                    "box_sku_num": 5,
                    "sku_remark": null,
                    "sku_delete_flag": false,
                    "brand_id": "0",
                    "brand_name": "",
                    "goods_category_id": "0",
                    "approval_number": null,
                    "stock_num": null,
                    "quality_num": null,
                    "defect_num": null,
                    "default_position_name": null,
                    "location_name": null,
                    "location_id": null,
                    "stock_type": 0,
                    "stock_type_text": null,
                    "batch_id": null,
                    "batch_no": "",
                    "production_date": null,
                    "expire_date": null,
                    "id": "2772145811444728852",
                    "stock_production_id": "2772145811436339220",
                    "source_type": 1,
                    "num": "1.0000",
                    "total_num": "3.0000",
                    "real_num": "3.0000",
                    "match_num": "0.0000",
                    "cost_rate": "0.0000",
                    "remark": ""
                }
            ]
        }
    ]
}

   5.2 异常响应示例

JSON
{
	"code": 2180,
	"message": "start_time与end_time时间跨度不能超过最大范围30天"
}






常用工具