[步骤]
-- 查询shopeeV2自动补货的执行情况
SELECT
d.OrderSourceName AS 来源渠道,
a.sku AS 系统SKU,
a.ProductId AS 平台ID,
a.SellerSku AS 渠道SKU,
a.StrategyId AS 执行策略ID,
b.NAME AS 执行策略名称,
a.`Status` AS 执行状态,
a.FailureReason AS 失败原因,
a.Time AS 操作时间,
a.Inventory AS 修改后库存,
a.OriginalInventory AS 原库存,
a.Remark AS 补货日志
FROM
pp_replenishment AS a
LEFT JOIN pp_replenishment_strategy AS b ON a.StrategyId = b.id
INNER JOIN sys_ordersource AS d ON a.OrderSourceId = d.OrderSourceId
WHERE
a.CustomerId = 1
AND a.MarketId = 97
AND a.StrategyId IN(320,328)
AND a.time > '2022-11-21 00:00:00'
AND a.SellerSku in(
'DBE235012QAWWN9SV',
'8WTT1546455GOOPRCG',
'68103181925D7UVOQ',
'D3011219CJ0ZGH92',
'091854EHC0UHGF',
'SD195124I46CKB19',
'1430502C2NASSI',
'JB060011I84KRAFT',
'MHZ041506D6C4WH7H',
'175626GOIKF8X2',
'34B0851216E23AZAA'
)
[结果]
计算结果为0 ，调整可售数不对[期望]
结果为0 调整为0