查询FBA库存列表 - v2

支持查询FBA库存，对应系统【仓库】>【FBA库存明细】数据,数量维度展示

接口信息

请求参数

请求cURL示例

curl --location 'https://openapi.lingxing.com/basicOpen/openapi/storage/fbaWarehouseDetail?access_token=value&timestamp=value&sign=value&app_key=value' \
--header 'Content-Type: application/json' \
--data '{
    "cid": "value",
    "bid": "value",
    "sid": "value",
    "attribute": "value",
    "asin_principal": "value",
    "search_field": "value",
    "search_value": "value",
    "is_cost_page": value,
    "status": "value",
    "senior_search_list": "value",
    "offset": value,
    "length": value,
    "fulfillment_channel_type": "value",
    "is_hide_zero_stock": "value",
    "is_parant_asin_merge": "value",
    "is_contain_del_ls": "value"
}'

返回结果

Json Object

返回成功示例

{
    "code": 0,
    "message": "success",
    "error_details": [],
    "request_id": "4683c92968ca47ccbff50f1ea8e4fb7a.165.17299260210002027",
    "response_time": "2024-10-26 15:00:21",
    "data": [
        {
            "name": "韧啸-US美国仓",
            "sid": 136,
            "asin": "B0D6XVLTJL",
            "parent_asin": "B0ABC73590",
            "product_name": "无线鼠标",
            "small_image_url": "https://image.distributetop.com/erp-vue/90128554873982976/20240802/027e8b7698414d899f7f0a2e77f97268.jpeg",
            "seller_sku": "20240613-1",
            "fnsku": "X004A0PW6J",
            "sku": "shubiao_1",
            "category_text": "电子设备\\鼠标",
            "cid": 3318,
            "product_brand_text": "罗技",
            "bid": 1173,
            "share_type": 0,
            "total": 2,
            "total_price": 40.00,
            "available_total": 42,
            "available_total_price": "840.00",
            "afn_fulfillable_quantity": 0,
            "afn_fulfillable_quantity_price": "0.00",
            "reserved_fc_transfers": 0,
            "reserved_fc_transfers_price": "0.00",
            "reserved_fc_processing": 0,
            "reserved_fc_processing_price": "0.00",
            "reserved_customerorders": 0,
            "reserved_customerorders_price": "0.00",
            "quantity": 0,
            "quantity_price": "0.00",
            "afn_unsellable_quantity": 0,
            "afn_unsellable_quantity_price": "0.00",
            "afn_inbound_working_quantity": 47,
            "afn_inbound_working_quantity_price": "940.00",
            "afn_inbound_shipped_quantity": 2,
            "afn_inbound_shipped_quantity_price": "40.00",
            "afn_inbound_receiving_quantity": 0,
            "afn_inbound_receiving_quantity_price": "0.00",
            "stock_up_num": 42,
            "stock_up_num_price": "840.00",
            "afn_researching_quantity": 0,
            "afn_researching_quantity_price": "0.00",
            "total_fulfillable_quantity": 0,
            "inv_age_0_to_90_days": 0,
            "inv_age_0_to_90_price": "0.00",
            "inv_age_271_to_365_days": 0,
            "inv_age_271_to_365_price": "0.00",
            "inv_age_0_to_30_days": 0,
            "inv_age_0_to_30_price": "0.00",
            "inv_age_31_to_60_days": 0,
            "inv_age_31_to_60_price": "0.00",
            "inv_age_61_to_90_days": 0,
            "inv_age_61_to_90_price": "0.00",
            "inv_age_91_to_180_days": 0,
            "inv_age_91_to_180_price": "0.00",
            "inv_age_181_to_270_days": 0,
            "inv_age_181_to_270_price": "0.00",
            "inv_age_271_to_330_days": 0,
            "inv_age_271_to_330_price": "0.00",
            "inv_age_331_to_365_days": 0,
            "inv_age_331_to_365_price": "0.00",
            "inv_age_365_plus_days": 0,
            "inv_age_365_plus_price": "0.00",
            "recommended_action": "",
            "sell_through": 0.0,
            "estimated_excess_quantity": 0.0,
            "estimated_storage_cost_next_month": 0.0,
            "fba_minimum_inventory_level": 0.0,
            "fba_inventory_level_health_status": "",
            "historical_days_of_supply": 0.00,
            "historical_days_of_supply_price": "0.00",
            "low_inventory_level_fee_applied": "",
            "fulfillment_channel": "AMAZON_NA",
            "cg_price": "",
            "cg_transport_costs": "AMAZON_NA",
            "warehouse_damaged_quantity": 0,
            "customer_damaged_quantity": 0,
            "carrier_damaged_quantity": 0,
            "distributor_damaged_quantity": 0,
            "defective_quantity": 0,
            "expired_quantity": 0,
            "fba_storage_quantity_list": [
                {
                    "sid": 39,
                    "name": "ouzhou001-MX",
                    "quantity_for_local_fulfillment": 10
                },
                {
                    "sid": 38,
                    "name": "ouzhou001-IT",
                    "quantity_for_local_fulfillment": 10
                }
            ]
        }
    ],
    "total": 1
}

附加说明

senior_search_list 高级搜索列表字段说明如下：

senior_search_list 是一个 json 字符串，用于多条件组合搜索，每个元素表示一个搜索条件（字段+值列表）。 需严格符合 JSON 格式，字段名和值需用双引号包裹。

| 字段名 | 类型 | 必填| 说明 | |:----- |:-------|:--|:----------------------------------------------| | name | string |是 | 搜索条件的显示名称（如“SKU”“品名”等），与 search_field 为固定枚举映射 | | search_field | string |是 | 搜索条件的显示名称（如“SKU”“品名”等），与 search_field 为固定枚举映射 | | search_value | array |是 | 搜索值列表，支持多值（逻辑“OR”关系）。 |

使用示例：

    "senior_search_list": "[{ \"name\":         \"SKU\", 
                              \"search_field\": \"sku\", 
                              \"search_value\": [\"sku1\", \"sku2\", \"sku3\"]},
                            { \"name\":         \"品名\", 
                              \"search_field\": \"product_name\", 
                              \"search_value\": [\"衣服\", \"裤子\", \"鞋子\"]},
                            { \"name\":         \"MSKU\", 
                              \"search_field\": \"seller_sku\", 
                              \"search_value\": [\"msku1\", \"msku2\", \"msku3\"]},
                            { \"name\":         \"FNSKU\", 
                              \"search_field\": \"fnsku\", 
                              \"search_value\": [\"fnsku1\", \"fnsku2\", \"fnsku3\"]},
                            { \"name\":         \"ASIN\", 
                              \"search_field\": \"asin\", 
                              \"search_value\": [\"asin1\", \"asin2\", \"asin3\"]},
                            { \"name\":         \"父ASIN\", 
                              \"search_field\": \"parent_asin\", 
                              \"search_value\": [\"fuAsin1\", \"fuAsin2\", \"fuAsin3\"]},
                            { \"name\":         \"SPU\", 
                              \"search_field\": \"spu\", 
                              \"search_value\": [\"spu1\", \"spu2\", \"spu3\"]},
                            { \"name\":         \"款名\", 
                              \"search_field\": \"spu_name\", 
                              \"search_value\": [\"kuan1\", \"kuan2\", \"kuan3\"]}]"

name, search_field 字段说明如下： name 和 search_field 是一一对应的枚举值。