Lingxing
切换旧版

查询采购报表列表 - 产品

POST/basicOpen/report/purchase/product/list

接口信息

API Path请求协议请求方式令牌桶容量
/basicOpen/report/purchase/product/listHTTPSPOST1

请求参数

offsetinteger
分页偏移量,默认0
lengthinteger
分页长度,默认20,上限200
start_datestring
开始日期【时间间隔最长不得超过90天】,闭区间,格式:Y-m-d
end_datestring
结束日期【时间间隔最长不得超过90天】,闭区间,格式:Y-m-d
time_typeinteger
时间类型:1 下单时间,2 到货时间
sidsstring
店铺id,多个使用英文逗号分隔 ,对应查询亚马逊店铺列表接口对应字段【sid】
search_fieldstring
搜索字段名:
product_name 品名
sku SKU
msku MSKU
fnsku FNSKU
spu_name 款名
spu SPU
search_valuestring
搜索值

请求示例

{
    "offset": 0,
    "length": 20,
    "start_date": "2024-05-05",
    "end_date": "2024-08-01",
    "time_type": 1,
    "sids": "109,136",
    "search_field": "sku",
    "search_value": "01"
}

返回结果

Json Object

codeinteger必填
状态码,0 成功
示例 0
messagestring必填
消息提示
示例 success
error_detailsarray<any>必填
错误信息
request_idstring必填
请求链路id
示例 C3D9F541-8083-E376-EB5C-606A872F5C89
response_timestring必填
响应时间
示例 2022-12-08 18:27:13
totalinteger必填
总数
示例 20
dataarray<object>必填
响应数据
隐藏子属性
pic_urlstring必填
图片URL
示例 https://image/xxx/A8.jpg
spustring必填
SPU
spu_namestring必填
款名
skustring必填
本地SKU
示例 jobor000002
product_namestring必填
品名
示例 jobor测试单品002
attributearray<object>必填
属性
隐藏子属性
attr_namestring必填
属性名称
attr_valuestring必填
属性值
fnskustring必填
FNSKU
示例 FN477C98E
mskustring必填
MSKU
purchase_quantitystring必填
采购量
示例 2
receive_quantitystring必填
到货量
示例 2
wait_quantitystring必填
待到货量
示例 0
good_quantitystring必填
良品量
示例 11
bad_quantitystring必填
次品量
示例 1
return_quantitystring必填
退货量
示例 0
price_avgstring必填
平均单价
示例 0.00
purchase_amountstring必填
订单金额
示例 0.00
receive_amountstring必填
到货金额
示例 0.00
wait_amountstring必填
待到货金额
示例 0.00
return_amountstring必填
退货金额
示例 0.00
bad_ratestring必填
次品率
示例 50.0000
return_ratestring必填
退货率
示例 0.0000
category_namestring必填
分类名
示例 商品分类c2
brand_namestring必填
品牌名
示例 品牌b1
warehouse_namestring必填
仓库名称
示例 拉美仓
account_namestring必填
店铺名称
示例 店铺2
buyer_namestring必填
采购员名称
countrystring必填
国家
示例 美国
supplier_namearray<any>必填
供应商
示例 ["美国供应商s1"]
director_namearray<any>必填
负责人
示例 ["0超级管理员01"]
overdue_quantityinteger必填
逾期数量
示例 0
overdue_timestring必填
逾期时长
示例 0
overdue_quantity_ratestring必填
逾期率
示例 0.00%
overdue_time_avgstring必填
平均逾期时长
示例 2
exchange_quantityinteger必填
换货量
示例 0

返回示例

{
    "code": 0,
    "message": "success",
    "error_details": [],
    "request_id": "08df995517c04bfa82fe65c2d79d7306.1723171585845",
    "response_time": "2024-08-09 10:46:26",
    "data": [
        {
            "pic_url": "https://image.distributetop.com/lingxing-erp/90128554873982976/20240523/d937bd94d48d4177ba7c1601e8ec8b54.jpg",
            "spu": "23131",
            "spu_name": "1112",
            "sku": "01",
            "product_name": "烤红薯",
            "attribute": [
                {
                    "attr_name": "测试属性",
                    "attr_value": "1"
                }
            ],
            "fnsku": "X0040T7HJP",
            "msku": "CN0001",
            "purchase_quantity": "10000",
            "receive_quantity": "100",
            "wait_quantity": "9900",
            "good_quantity": "0",
            "bad_quantity": "1",
            "return_quantity": "0",
            "price_avg": "10.0000",
            "purchase_amount": "100000.00",
            "receive_amount": "1000.00",
            "wait_amount": "99000.00",
            "return_amount": "0.00",
            "bad_rate": "1.00%",
            "return_rate": "0.00%",
            "category_name": "王",
            "brand_name": "蛋",
            "warehouse_name": "自发货仓库呀",
            "account_name": "renxiao-US",
            "buyer_name": "夏旺",
            "country": "美国",
            "supplier_name": [
                "揭阳市揭东区新亨镇婉佳服装店"
            ],
            "director_name": [],
            "overdue_quantity": 0,
            "overdue_time": "-",
            "overdue_quantity_rate": "0.00%",
            "overdue_time_avg": "-",
            "exchange_quantity": 0
        },
        {
            "pic_url": "https://image.distributetop.com/lingxing-erp/90128554873982976/20240523/d937bd94d48d4177ba7c1601e8ec8b54.jpg",
            "spu": "23131",
            "spu_name": "1112",
            "sku": "01",
            "product_name": "烤红薯",
            "attribute": [
                {
                    "attr_name": "测试属性",
                    "attr_value": "1"
                }
            ],
            "fnsku": "X0040T7HJP",
            "msku": "CN0001",
            "purchase_quantity": "1549",
            "receive_quantity": "1049",
            "wait_quantity": "500",
            "good_quantity": "599",
            "bad_quantity": "0",
            "return_quantity": "0",
            "price_avg": "10.0000",
            "purchase_amount": "15490.00",
            "receive_amount": "10490.00",
            "wait_amount": "5000.00",
            "return_amount": "0.00",
            "bad_rate": "0.00%",
            "return_rate": "0.00%",
            "category_name": "王",
            "brand_name": "蛋",
            "warehouse_name": "旺仔仓库测试",
            "account_name": "renxiao-US",
            "buyer_name": "夏旺",
            "country": "美国",
            "supplier_name": [
                "lx供应商",
                "ABC的"
            ],
            "director_name": [],
            "overdue_quantity": 0,
            "overdue_time": "-",
            "overdue_quantity_rate": "0.00%",
            "overdue_time_avg": "-",
            "exchange_quantity": 0
        }
    ],
    "total": 4
}