深圳智汇创想科技有限公司

验证如下：

创建两个策略，埋词对象分别选择：所有直发来源渠道 、所有海外仓来源渠道，创建如下策略：

（1）策略ID：10011   对接：所有直发来源渠道

设置策略条件如下：

SQL过滤脚本：

SELECT l.StartTime,l.EndTime,l.OnlineStatus,l.PublishTime,l.price,l.IsAutoPublish,l.QuantitySold,l.sku,l.ProductId,l.SellerSku,l.*  FROM `M_Ebay_Listing` l  
WHERE 
(
(
(
  (
(
(
(( `OnlineStatus` = 1 ) AND ( `OrderSourceId` in (5080) ) ) 
AND (EXISTS ( SELECT * FROM `M_Ebay_Listing_Sub` `sub` INNER JOIN `sys_ebay_traffic_report_nday` `dis` 
ON ( `sub`.`ProductId` = `dis`.`ProductId` ) 
WHERE (( `sub`.`OrderSourceId` = `l`.`OrderSourceId` ) AND ( `sub`.`ProductId` = `l`.`ProductId` ))  
AND ( `dis`.`type` =( 7 ))   
AND ( `dis`.`ListingImpressionTotal` >=(1))  
AND ( `dis`.`ListingImpressionTotal` <=(16)) 
)
)
) 
AND ( `IsAutoPublish` in (1) )
) 
AND ( `PublishTime` <= (DATE_ADD('2024-07-12 09:07:38.547' , INTERVAL -1 Day)) )
) 
AND ( `PublishTime` >= '2022-09-01 09:07:32.084' )
) AND ( `QuantitySold` >=2 )
) AND ( `QuantitySold` <=3)
) order by id desc;

-----------------------------------------------------------------------------------------


SELECT   l.StartTime,l.EndTime,l.OnlineStatus,l.PublishTime,l.price,l.IsAutoPublish,l.QuantitySold,l.sku,l.ProductId,l.SellerSku,l.* 
FROM M_Ebay_Listing l
force index(idx_id_OrderSourceId_EndTime)  
WHERE ((((
(( `OnlineStatus` = 1 ) AND ( `OrderSourceId` in (5080))) 
 -- AND  (`ProductId` in ('145872454681','135131501715','145854627333'))
-- AND (( `EndTime` >= '2024-07-15 00:00:00.000' ) AND ( `EndTime` <= '2024-07-16 00:00:00.000' ))
) 
AND ( `IsAutoPublish` in (1) )) 
AND ( `PublishTime` <= (DATE_ADD('2024-07-12 06:54:11.685' , INTERVAL -1 Day)) )) AND ( `PublishTime` >= '2022-12-30 06:54:11.671' ))ORDER BY Id; 

（2）策略ID：10012  对接：所以海外仓来源渠道

设置策略条件如下：

SQL过滤脚本：

SELECT  l.OnlineStatus,l.PublishTime,l.price,l.IsAutoPublish,l.QuantitySold,l.sku,l.ProductId,l.SellerSku,l.*  FROM `M_Ebay_Listing` l  
WHERE 
(
(
(
  (
(
(
(( `OnlineStatus` = 1 ) AND ( `OrderSourceId` in (9802) ) ) 
AND (EXISTS ( SELECT * FROM `M_Ebay_Listing_Sub` `sub` INNER JOIN `sys_ebay_traffic_report_nday` `dis` 
ON ( `sub`.`ProductId` = `dis`.`ProductId` ) 
WHERE (( `sub`.`OrderSourceId` = `l`.`OrderSourceId` ) AND ( `sub`.`ProductId` = `l`.`ProductId` ))  
AND ( `dis`.`type` =( 7 ))   
AND ( `dis`.`ListingImpressionTotal` >=( 1 ))  
AND ( `dis`.`ListingImpressionTotal` <=( 13 )) 
)
)
) 
AND ( `IsAutoPublish` = 0 )
) 
AND ( `PublishTime` <= (DATE_ADD('2024-07-11 09:07:38.547' , INTERVAL -1 Day)) )
) 
AND ( `PublishTime` >= '2022-09-01 09:07:32.084' )
) AND ( `QuantitySold` >=1 )
) AND ( `QuantitySold` <=5)
)  order by id desc;

通过埋词调度服务：
GetMarketBuriedwordsStrategyJobService__Producer-dev    Ebay-SKU修改通用生产者
GetEbayNQueue-dev-ebay   Ebay-变更队列通用生产者    关键词：Buriedwords

预期结果：通过对接埋词对象：所有直发来源渠道、所有海外仓来源渠道，能够将对应店铺下的在线listing进行成功埋词

实际结果1：查看策略ID：10011 队列情况：直发来源渠道对应的在线listing也成功埋词（在线listing应同步mgdb_listing对应店铺表）

实际结果2：查看策略ID：10012 队列情况：直发来源渠道对应的在线listing也成功埋词（在线listing应同步mgdb_listing对应店铺表）