暂无
任务描述
需求描述
需求地址：https://alidocs.dingtalk.com/i/nodes/Gl6Pm2Db8D3kB579t7qDZ0rGJxLq0Ee4?utm_scene=team_space
文档链接：https://alidocs.dingtalk.com/i/nodes/YndMj49yWjPBKdL0crdnwnlbJ3pmz5aA
参考：标签匹配智能策略（定稿） sheet 字段维度，做成可配置的，支持业务自行调整值来更改标签定义
给每个产品打上标签，确保全部的产品都有标签
具体的字段及取值逻辑，可对接智能团队杨宁海或陈楚如，目前线下已经在导表跟进
验收标准
158Create
在途查询SQL
SELECT
1 AS id,
t1.asin AS asin,
t1.country_code AS countryCode,
sum( IFNULL( t2.transit_quantity, 0 ) ) AS transitQuantity
FROM
(
SELECT
tafvic.source_id,
tafvic.fnsku,
tafvic.msku,
tafvic.asin,
tafvic.country_code
FROM
t_amz_fba_virtual_inventory_country tafvic
WHERE
( tafvic.asin, tafvic.country_code ) IN ( ( 'B08JCJ1KDN', 'US' ) )
AND EXISTS (
SELECT
1
FROM
t_amz_fba_virtual_inventory_country t2
WHERE
tafvic.id = t2.id
AND ( t2.msku, t2.source_id ) IN (( 'WQ913NG2458S2YN7YZ58', 5247 ) )
)
AND tafvic.is_deleted = 0
GROUP BY
tafvic.source_id,
tafvic.fnsku,
tafvic.msku,
tafvic.asin,
tafvic.country_code
) t1
LEFT JOIN t_amz_fba_transit_inventory t2 ON t1.source_id = t2.source_id
AND t1.msku = t2.msku
AND t1.fnsku = t2.fnsku
GROUP BY
t1.asin,
t1.country_code