API
库存流水查询
更新时间: 2021-01-27 17:26:18 访问次数:3666
接口说明
本接口支持卖家查询库存流水,通过winit商品编码、仓库编码、订单类型查询具体的商品的库存流水
使用场景
用户查询指定商品或者指定仓库的库存变动流水。
接口英文名称
winit.inventory.pageInvInouts
备注
请求说明
URL | https://openapi.winit.com.cn/openapi/service |
接口测试 | https://sandboxopenapi.winit.com.cn/openapi/service |
验证方法 | Token,md5 |
格式 | json |
字符编码 | UTF-8 |
http请求方式 | http |
请求数限制 | 默认每分钟1000,有需要可申请加大。 |
请求入参
<
tr>
名称 | 类型 | 必填 | 说明 | 示例 |
---|---|---|---|---|
skuCode | String(120) | Y | 商品编码 | auto_sku22 |
specification | varchar(255) | N | 商品规格 | 1000008 |
warehouseCode | varchar(50) | Y | 仓库编码 | DE0001 |
docType | varchar(30) | N | 订单类型
入库:INBOUND 出库:OUTBOUND 调整:ADJUSTMENT 调拨出库:ALLOCATION_OUT 调拨入库:ALLOCATION_IN 退货入库:INBOUND_RETURN 直发入库:INBOUND_OVERSEAS |
INBOUND |
startDate |
Y | 起始日期 | 2020-12-01 |
|
endDate | Y | 截止日期 | 2020-01-01 | |
pageNo | Integer(10) | Y | 页码 | |
pageSize | Integer(10) | Y | 每页显示数量 |
请求示例
{ "action": "winit.inventory.pageInvInouts", "app_key": "rebecca", "client_id": "ODJKMDU1YZCTYJQ5YY00ZWZLLTK5N2QTOWY4MZI5OGMWNDG2", "data": { "skuCode": "auto_sku22", "specification": "", "warehouseCode": "US0001", "docType": "INBOUND", "startDate": "2020-05-01", "endDate": "2020-05-08", "pageVo": { "pageNo": "1", "pageSize": "10" } }, "format": "json", "language": "zh_CN", "sign": "19AFB1EDAB70909345AF736BF1B6FCDF", "sign_method": "md5", "platform": "OWNERERP", "timestamp": "2015-06-16 00:19:26", "version": "1.0", "client_sign": "603AB31C90EC9F4C02A3CD07A754AF5A" }
返回出参
名称 | 类型 | 必填 | 说明 | 示例 |
---|---|---|---|---|
名称 | 类型 | 说明 | 示例 | |
skuCode | String(120) | 商品编码 | ||
merchandiseSerno | String(100) | 商品条码 | ||
specification | String(255) | 规格 | ||
warehouseCode | varchar(50) | 仓库编码 | ||
customerName | varchar(20) | 客户名称 | ||
docType | varchar(30) | 订单类型 | ||
docNo | varchar(100) | 订单号 | ||
cnName | String(255) | 中文名称 | ||
name | String(255) | 英文名称 | ||
startQty | INT | 期初数量 | ||
endQty | INT | 期末数量 | ||
changeQty | INT | 变动数量 | ||
changeDate | DATE | 变动日期 | ||
remark | varchar(200) | 备注 | ||
provideChannel | String(255) | 供应渠道 | ||
salesChannel | String(255) | 销售渠道 | ||
merchandiseGrade | String(255) | 商品等级 | ||
serviceType | String(255) | 库存类型 | ||
unit | String(255) | 库存单位 |
错误的返回结果:错误码,错误信息
返回示例
{ "code": "0", "msg": "操作成功", "data": { "pageParams": { "pageNo": 1, "pageSize": 10, "totalCount": 2 }, "list": [ { "skuCode": "auto_sku22", "merchandiseSerno": "M010000000001674549", "specification": "", "warehouseCode": "US0001", "customerName": null, "docType": "INBOUND", "docNo": "WI9900012414", "cnName": "api自动化商品002", "name": "auto_sku22", "startQty": 768, "endQty": 770, "changeQty": 2, "changeDate": "2020-05-06 16:26:43", "remark": "标准入库", "provideChannel": null, "salesChannel": null, "merchandiseGrade": "GOOD", "serviceType": "2C", "unit": null, "batchInfoVo": null }, { "skuCode": "auto_sku22", "merchandiseSerno": "M010000000001674549", "specification": "", "warehouseCode": "US0001", "customerName": null, "docType": "INBOUND", "docNo": "WI9900012426", "cnName": "api自动化商品002", "name": "auto_sku22", "startQty": 770, "endQty": 772, "changeQty": 2, "changeDate": "2020-05-06 16:27:37", "remark": "国内直发入库", "provideChannel": null, "salesChannel": null, "merchandiseGrade": "GOOD", "serviceType": "2C", "unit": null, "batchInfoVo": null } ] } }