API
库存流水查询
更新时间: 2021-01-27 17:26:18 访问次数:3185
Document
接口说明

本接口支持卖家查询库存流水,通过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"
}

                            
返回出参
名称 类型 必填 说明 示例
名称类型说明示例
skuCodeString(120)商品编码
merchandiseSernoString(100)商品条码
specificationString(255)规格
warehouseCodevarchar(50)仓库编码
customerNamevarchar(20)客户名称
docTypevarchar(30) 订单类型
docNovarchar(100)订单号
cnNameString(255)中文名称
nameString(255)英文名称
startQtyINT期初数量
endQtyINT期末数量
changeQtyINT变动数量
changeDateDATE变动日期
remarkvarchar(200)备注
provideChannelString(255)供应渠道
salesChannelString(255)销售渠道
merchandiseGradeString(255)商品等级
serviceTypeString(255)库存类型
unitString(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
            }
        ]
    }
}

                            
关键词