1.凤凰计划自动审核手动执行,并验证结果





相关sql:
-- 查询审核的主表
select * from apx_basicplan_log where CustomerId=1 and PlanID=28 and IsDeleteCheck=1
and CreationTime>='2023/9/18 18:27:50' and CreationTime<='2023/9/21 09:27:50'
and `Status` in (1,3)
order by id desc LIMIT 20000
-- 审核明细
select * from apx_basicplan_logdetail where CustomerId=1 and PlanID=28 and PlanType=1
and LastModifier='系统自动审核' limit 1000;
2.凤凰计划停产下架策略28某个渠道SKU,该产品7月份已设置停产,但是今天试运行还是显示产品状态正常,




相关Sql:
-- 冷库:
select SKU,OrderSourceSKU, ProductStatus,StopProduct from aml_amazon_product_base_dep88
where OrderSourceSKU='20EW210L62DFJ06O45Q36X'