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

待转FBA更新为已转FBA状态超时，优化查询方法并新增重试机制

查询数据的条件以及脚本

更新为已转FBA状态条件
相同国家，相同asin
待转的产品必须是非FBA状态和待转或者不转FBA状态
必须有另外一个产品是FBA状态，并且是在线状态才会转成已转FBA状态

SELECT ID
FROM RB_Amazon_Product_Base a (NOLOCK)
WHERE a.CustomerID = 1
AND a.IsFBA = 0
      AND a.IsDelete = 0
      AND a.IsOffShelf = 0
      AND a.WaitToFbaType IN ( 1, 2 )
      AND a.OrderSourceSKUID > 0
      AND EXISTS
(
    SELECT TOP 1
           0
    FROM RB_Amazon_Product_Base b (NOLOCK)
    WHERE a.CustomerID = b.CustomerID
          AND a.OrderSourceCountry = b.OrderSourceCountry
          AND a.ASINorItemID = b.ASINorItemID
          AND b.IsFBA = 1
          AND b.IsDelete = 0
          AND b.IsOffShelf = 0
);