一、背景
协助科学定价项目采集是否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下的外部竞品详情数据导出给王柳

将1w个sku下的外部竞品详情数据导出给王柳。