001- 一、背景协助科学定价项目采集是否FBA发货字段。业务价值：协助采集竞品发货字段用于定价，预估50000.验收人：王柳二、需求说明2.1、指定4000个SKU下的竞品采集亚马逊发货方式操作位置：外部竞品详情采集范围：随机4000个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 4000三、验收标准将4000个sku下的外部竞品详情数据导出给王柳
001+ 一、背景协助科学定价项目采集是否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下的外部竞品详情数据导出给王柳

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

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

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