SELECT
source_id,
msku,
fulfillable_quantity
FROM
zhcxkj_center.t_amz_product_performance_inventory
WHERE
fulfillable_quantity > 0
AND is_deleted =0
and source_id =6397
and msku ='YK-WGPD-J5DS'
ORDER BY msku;
SELECT
source_id,
msku,
fulfillable_quantity
FROM
`zhcxkj-center-warehouse`.`t_amz_fba_virtual_inventory_country`
WHERE
source_id = 6397
AND msku = 'YK-WGPD-J5DS'
AND is_deleted = 0
ORDER BY
msku


问题:店铺从有品转为非有品店铺,产品表现维度表的数据没有处理,导致产品表现还有此店铺的数据,原来的业务需求没有做处理,后期要增加此部分的处理需求。
PS:
select * from t_amz_fba_stock
where
order_source_id =6397
and seller_sku ='YK-WGPD-J5DS'