问题描述:
直发店铺本地仓库Listing,符合自动补货条件,未自动补货
数据:
自动补货:
SELECT l.OrderSourceId,productId,Quantity,QuantitySold,country,SiteCode,warehouseIds,OrderSourceName FROM m_ebay_listing l LEFT JOIN sys_ordersource o ON
l.OrderSourceId = o.OrderSourceId where l.OrderSourceId =24318 and sku = '6699721' ;
SELECT * FROM p_product_inventory_change where Sku in ('6699721');
SELECT * FROM p_product_inventory where Sku in ('6699721');



同步Listing:
SELECT l.OrderSourceId,productId,Quantity,QuantitySold,country,SiteCode,warehouseIds,OrderSourceName FROM m_ebay_listing l LEFT JOIN sys_ordersource o ON
l.OrderSourceId = o.OrderSourceId where l.OnlineStatus and l.OrderSourceId =5080 and sku = '7845937' ;
SELECT * FROM p_product_inventory_change where Sku in ('7845937');
SELECT * FROM p_product_inventory where Sku in ('7845937');



补货队列无数据:


1 .加拿大站点去获取了仓库站点配置为空导致被过滤了
2. 本地仓库存变更限制了只执行平衡库存,把自动补货忽略了