协助科学定价项目采集是否FBA发货字段。
业务价值：协助采集竞品发货字段用于定价，预估50000.
验收人：王柳
二、需求说明
2.1、指定1w个SKU下的竞品采集亚马逊发货方式
操作位置：外部竞品详情采集
范围：随机1w个SKU
导出数据：SKU+原有竞品信息+Ships from（发货方式）
参考SQL
SELECT
DISTINCT a.sku
FROM
t_amazon_listing as a
LEFT JOIN rb_ordersource as b ON a.customer_id = b.CustomerID AND a.source_id = b.ID
LEFT JOIN rb_admin as c ON a.customer_id = c.CustomerID AND b.SaleAdminID = c.ID
WHERE a.customer_id = 1 AND a.order_source_sku_id > 0 AND a.is_deleted = 0 AND a.`status` = 1
-- AND a.quality > 0
AND a.delivery_type = 1 AND c.UserFullPathName LIKE '%亚马逊智能运营%'
limit 10000
三、验收标准
将1w个sku下的外部竞品详情数据导出给王柳
