重现步骤

[前置条件]

系统正常

[重现步骤]

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 = 57
AND a.time > '2024-01-16 14:00:00' 
  AND a.StrategyId =470


[重现规律]  
必现
[实际结果]

店铺ID:6230,同步到100多条数据,执行出989条队列

[期望结果]

只执行半托listing的自动补货策略

历史记录  
  1. 2024-01-17 11:23:50, 由 李乐同 创建。
  2. 2024-01-17 11:24:02, 由 李乐同 编辑。
    修改了 影响环境,旧值为 "755,",新值为 "756"。
    修改了 重现步骤,区别为:
    004- 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.OrderSourceIdWHERE a.CustomerId = 1 AND a.MarketId = 57 AND a.time > '2024-01-16 14:00:00' AND a.StrategyId =470
    004+ 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.OrderSourceIdWHERE a.CustomerId = 1 AND a.MarketId = 57 AND a.time > '2024-01-16 14:00:00' AND a.StrategyId =470
    004- <p>SELECT<br /> d.OrderSourceName AS 来源渠道,<br /> a.sku AS 系统SKU,<br /> a.ProductId AS 平台ID,<br /> a.SellerSku AS 渠道SKU,<br /> a.StrategyId AS 执行策略ID,<br /> b.NAME AS 执行策略名称,<br /> a.`Status` AS 执行状态,<br /> a.FailureReason AS 失败原因,<br /> a.Time AS 操作时间,<br /> a.Inventory AS 修改后库存,<br /> a.OriginalInventory AS 原库存,<br /> a.Remark AS 补货日志<br />FROM<br /> pp_replenishment AS a<br /> LEFT JOIN pp_replenishment_strategy AS b ON a.StrategyId = b.id<br /> INNER JOIN sys_ordersource AS d ON a.OrderSourceId = d.OrderSourceId<br />WHERE<br /> a.CustomerId = 1<br /> AND a.MarketId = 57<br /><span> </span>AND a.time &gt; '2024-01-16 14:00:00'<br /> AND a.StrategyId =470<br /></p>
    004+ <p>SELECT<br /> d.OrderSourceName AS 来源渠道,<br /> a.sku AS 系统SKU,<br /> a.ProductId AS 平台ID,<br /> a.SellerSku AS 渠道SKU,<br /> a.StrategyId AS 执行策略ID,<br /> b.NAME AS 执行策略名称,<br /> a.`Status` AS 执行状态,<br /> a.FailureReason AS 失败原因,<br /> a.Time AS 操作时间,<br /> a.Inventory AS 修改后库存,<br /> a.OriginalInventory AS 原库存,<br /> a.Remark AS 补货日志<br />FROM<br /> pp_replenishment AS a<br /> LEFT JOIN pp_replenishment_strategy AS b ON a.StrategyId = b.id<br /> INNER JOIN sys_ordersource AS d ON a.OrderSourceId = d.OrderSourceId<br />WHERE<br /> a.CustomerId = 1<br /> AND a.MarketId = 57<br /><span> </span>AND a.time &gt; '2024-01-16 14:00:00'<br /> AND a.StrategyId =470</p>
  3. 2024-01-17 14:04:53, 由 朱思文 确认Bug。
    修改了 Bug类型 ,旧值为 "",新值为 "code"。
    修改了 是否确认,旧值为 "0",新值为 "1"。
    1.已经添加逻辑,普通补货过滤掉半托补货策略,已发布
  4. 2024-01-17 14:04:59, 由 朱思文 解决,方案为 程序BUG 。
    修改了 解决方案,旧值为 "",新值为 "code"。
    修改了 解决日期,旧值为 "",新值为 "2024-01-17 14:04:55"。
    修改了 指派给 ,旧值为 "zhusiwen",新值为 "liletong"。
    修改了 Bug状态 ,旧值为 "active",新值为 "resolved"。
    修改了 解决者 ,旧值为 "",新值为 "zhusiwen"。
  5. 2024-01-17 20:37:27, 由 李乐同 指派给 朱思文。
    修改了 指派给,旧值为 "liletong",新值为 "zhusiwen"。
    还会进普通listing,需要查明原因
  6. 2024-01-18 17:53:52, 由 朱思文 指派给 李乐同。
    修改了 指派给,旧值为 "zhusiwen",新值为 "liletong"。
  7. 2024-01-22 09:50:21, 由 李乐同 关闭。
    修改了 Bug状态 ,旧值为 "resolved",新值为 "closed"。
    修改了 指派给 ,旧值为 "liletong",新值为 "closed"。
    修改了 由谁关闭,旧值为 "",新值为 "liletong"。
    修改了 关闭日期,旧值为 "",新值为 "2024-01-22 09:50:21"。
所属项目 技术中心-需求池
所属模块 多平台   Aliexpress
所属计划
所属迭代
Bug类型 程序BUG
严重程度 一般
优先级 P1
Bug状态 已关闭
业务部门
影响功能
开发责任人
测试责任人
解决时效 0
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2024-01-22 09:50:21
截止日期 0000-00-00
上线时间
上线时效
操作系统 Windows
浏览器 firefox系列
关键词
抄送给
由谁创建 李乐同 于 2024-01-17 11:23:49
影响环境 756
由谁解决 朱思文 于 2024-01-17 14:04:55
解决版本
解决方案 程序BUG
由谁关闭 李乐同 于 2024-01-22 09:50:21
最后修改 李乐同 于 2024-01-22 09:50:21
相关Bug