http://web.internal.zhcxkj.com/amz/#/listingManagement

[步骤]

[结果]

[期望]

-- warehouse
-- msku首次到货时间
select source_id,msku,min(receiving_time) as receiving_time
from t_amz_fba_shipment_item
where receiving_time is not null
and msku = 'C6-JCJW-NONF'
and source_id = '16332'
group by source_id,msku;

-- asin首次到货时间
select t.country_code,t1.asin,min(t1.receiving_time) as receiving_time
from t_amz_fba_shipment t
inner join t_amz_fba_shipment_item t1 on t.shipment_id=t1.shipment_id
where t1.receiving_time is not null and t1.asin is not null and t1.asin != ''
and asin = 'B0BG52SJ5N'
group by t.country_code,t1.asin;