暂无
任务描述
需求描述
验收标准
暂无
| 所属迭代 | 有品-星级预警 |
|---|---|
| 所属模块 | 技术中心-需求池 亚马逊 |
| 相关需求 | 销量分析、FBA库存性能优化 |
| 指派给 | Closed 于 2024-11-06 09:34:48 |
| 任务类型 | 后端 |
| 任务标签 | 初始 |
| 开发组 | 百货开发组 |
| 任务状态 | 已关闭 |
| 进度 | 100% |
| 优先级 | P2 |
| 关键词 | |
| 抄送给 |
| 由谁创建 | 覃光贤 于 2024-10-11 14:16:39 |
|---|---|
| 由谁完成 | 覃光贤 于 2024-10-11 14:36:04 |
| 由谁取消 | 暂无 |
| 由谁关闭 | 周杰 于 2024-11-06 09:34:48 |
| 关闭原因 | 已完成 |
| 最后编辑 | 周杰 于 2024-11-06 09:34:48 |
| 团队 | 最初预计 | 总计消耗 | 预计剩余 |
|---|
| 最初预计 | 10工时 |
|---|---|
| 总计消耗 | 9工时 |
| 预计剩余 | 0工时 |
| 预计开始 | 2024-10-10 |
| 实际开始 | 2024-10-11 |
| 截止日期 | 2024-10-16 |
完成效果,切换时间库存不再变化
实现效果,以父asin维度为例:
用查询出来的父asin取starrocks listing表查询该父asin下的msku,再用这些msku查询这些msku的FBA可用、预留库存;
如果区分了店铺,则查询父asin下的msku时增加店铺条件,查询库存是也增加店铺条件
区分店铺查询库存
SELECT
t1.msku AS msku,
t1.source_id AS sourceId,
tafvi.fulfillable_quantity fulfillableQuantity,
tafvi.pending_transshipment_quantity pendingTransshipmentQuantity,
tafvi.fc_processing_quantity fcProcessingQuantity
FROM
(
SELECT
tafvic.msku,
tafvic.source_id,
tafvic.virtual_id
FROM t_amz_fba_virtual_inventory_country tafvic
WHERE tafvic.msku IN()
AND tafvic.source_id IN()
AND tafvic.is_deleted = 0
and tafvic.exist_child = 0
) t1
LEFT JOIN t_amz_fba_virtual_inventory tafvi ON t1.virtual_id = tafvi.id
WHERE tafvi.warehouse_type IN ( 3, 4 )
AND tafvi.is_deleted = 0
不区分店铺查询库存
SELECT
t1.msku AS msku,
sum( tafvi.fulfillable_quantity ) AS fulfillableQuantity,
sum( tafvi.pending_transshipment_quantity ) AS pendingTransshipmentQuantity,
sum( tafvi.fc_processing_quantity ) AS fcProcessingQuantity
FROM
(
SELECT
tafvic.msku,
tafvic.virtual_id
FROM
t_amz_fba_virtual_inventory_country tafvic
WHERE tafvic.msku IN()
AND tafvic.is_deleted = 0
AND tafvic.exist_child = 0
GROUP BY tafvic.msku, tafvic.virtual_id
) t1
LEFT JOIN t_amz_fba_virtual_inventory tafvi ON t1.virtual_id = tafvi.id
WHERE tafvi.warehouse_type IN ( 3, 4 )
AND tafvi.is_deleted = 0
GROUP BY t1.msku