[步骤]

[结果]

-- 查询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.time > '2023-09-10 00:00:00' 
  AND a.StrategyId IN(411,328)
AND SellerSku IN(
'93115400JZ89813992', 
'CZ192955ZA6WD52X',  
'4P1228065X188FVB')

有库存的产品，没有及时改可售数

[期望]

自动补货及时