深圳智汇创想科技有限公司

一、需求背景

美客多目前智能刊登系统均刊登标准产品，多变体产品自动补货时未做好兼容，会调价失败，需要统一优化

二、需求价值

控制风险：减少因为无法平衡库存或自动补货导致的，账号指标受限，影响出单

三、需求内容

http://product-doc-wan.zhcxkj.com:9000/%E4%BA%A7%E5%93%81%E4%BA%8C%E7%BB%84/%E6%99%BA%E6%B1%87%E5%88%9B%E6%83%B32022%E8%BF%AD%E4%BB%A3%E9%9C%80%E6%B1%82Axure9%E7%89%88%E6%9C%AC/#g=1&p=%E7%BE%8E%E5%AE%A2%E5%A4%9A%E8%87%AA%E5%8A%A8%E8%A1%A5%E8%B4%A7%E5%85%BC%E5%AE%B9%E5%A4%9A%E5%8F%98%E4%BD%93%E4%BA%A7%E5%93%81&id=anvb81

验证美客多自动补货成功率，验证补货队列是否还有该类错，占比是否明显降低

-- 美客多自动补货策略执行明细
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 补货日志,
a.Type 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 = 70
AND a.StrategyId=180 /*加上策略ID走索引*/
-- AND a.Time >= date_add(curdate(),interval -1 day)
-- AND a.Time < CURDATE()
and a.Time>'2022-11-01 00:00:00'
and a.Time<'2022-11-08 00:00:00 '
AND `Status`='failure'
AND FailureReason LIKE'%available_quantity is not modifiable%'