【测试环境】eBay海外仓配置 - 海外仓listing转换,可用库存,为对应的来源渠道海外仓库存总和(即获取海外仓站点库存配置的站点仓库之和),开发获取仓库的情况为不分站点全部获取,与预期获取的不一致,与产品沟通后即要采用该逻辑获取仓库之和:获取海外仓站点库存配置的站点仓库之和
(1)开发获取仓库情况为部分站点全部获取:
SQL参考:
select sku ,sum(GoodNum) from p_product_overseaswarehouse_dynamicinventory where sku in
('7398144',
'8848471',
'11186530',
'11247136',
'13211761',
'8209818',
'16201837',
'14323381',
'10999529',
'9563304') GROUP BY sku;
(2)业务逻辑获取的仓库情况:海外仓站点库存配置的站点仓库之和(与产品确认过):
SQL参考:
select sku ,sum(GoodNum)
from p_product_overseaswarehouse_dynamicinventory
where sku in
('7398144',
'8848471',
'11186530',
'11247136',
'13211761',
'8209818',
'16201837',
'14323381',
'10999529',
'9563304') and WarehouseId in ('212','6748','14579','15939') GROUP BY sku;
[步骤]
[结果]
[期望]
