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

需求背景

目前清库促销调价查询的数据源存在不全的问题，需要重新调整数据源的查询。

需求内容

1、查询清库SKUSQL调整：本地仓，且符合亚马逊清库补贴计划的SKU；

SELECT
*
FROM (
SELECT
*,
CASE WHEN a.SubsidyPlanName LIKE '%730%' THEN '730'
WHEN a.SubsidyPlanName LIKE '%365%' THEN '365'
WHEN a.SubsidyPlanName LIKE '%270%' THEN '270'
WHEN a.SubsidyPlanName LIKE '%180%' THEN '180'
WHEN a.SubsidyPlanName LIKE '%90%' THEN '90'
WHEN a.SubsidyPlanName LIKE '%60%' THEN '60'
ELSE '0' END AS 'StorageAge',
ROW_NUMBER()OVER(PARTITION BY a.SKU ORDER BY a.AddTime DESC) AS 'rowid'
FROM
dbo.RB_SellerSKU_SubsidyPlan (NOLOCK) AS a
WHERE
a.PlanStatus = 1
AND a.SubsidyStatus = 2
AND (a.WareHouseIDList = '333' OR a.WareHouseIDList = '5312')
) AS a WHERE a.rowid = 1 AND a.SubsidyPlanNum > PlaceNum

2、执行的清库库龄调整：不限制库龄

3、库龄区间的底线利润率调整：其他库龄区间的底线利润率不变

b、90<X<=180天——底线利润率为：15%； 销量预测值：1.1

改为