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

1.根据条件批量修复渠道SKU状态，改为正常

1）查询需要修复的数据，以下是查询的脚本，分为FBA状态数据和自发货状态数据

--FBA
SELECT b.ID,
       b.CustomerID,
       b.OrderSourceID,
       b.OrderSourceSKU,
       b.OrderSourceSKUID
FROM A_Temp_DeleteInfo_20230106 (NOLOCK) d
    INNER JOIN RB_Amazon_Product_Base (NOLOCK) b
        ON d.Customerid = b.CustomerID
           AND d.ordersourceid = b.OrderSourceID
           AND d.OrderSourceSKU = b.OrderSourceSKU
           AND d.OrderSourceSKUID = b.OrderSourceSKUID
WHERE d.Customerid = 1
      AND d.OrderSourceSKUID > 0
      AND
      (
          d.ThreeMonthSaleNum > 0
          OR b.cgzNum > 0
          OR b.ystzNum > 0
          OR b.KykcNum > 0
      )
      AND b.IsFBA = 1
      AND b.ID > 0;



--自发货
SELECT b.ID,
       b.CustomerID,
       b.OrderSourceID,
       b.OrderSourceSKU,
       b.OrderSourceSKUID
FROM A_Temp_DeleteInfo_20230106 (NOLOCK) d
    INNER JOIN RB_Amazon_Product_Base (NOLOCK) b
        ON d.Customerid = b.CustomerID
           AND d.ordersourceid = b.OrderSourceID
           AND d.OrderSourceSKU = b.OrderSourceSKU
           AND d.OrderSourceSKUID = b.OrderSourceSKUID
WHERE d.Customerid = 1
      AND d.OrderSourceSKUID > 0
      AND
      (
          d.ThreeMonthSaleNum > 0
          AND d.ProductProperty = 1
          AND d.ProductState IN ( 0, 1, 3, 4, 5 )
      )
      AND b.IsFBA = 0
--AND b.ID > 196343352    
ORDER BY b.ID ASC;

2.恢复的数据插入到ERP渠道SKU表

1）编写程序，通过调用渠道SKU新增接口，新增数据到渠道SKU系统

3.恢复的渠道SKU同步到listing

1）更新渠道SKU表的删除状态（RB_Product_OrderSource）

2）更新大宽表的删除状态（RB_Amazon_Product_Base）

3）新增数据到临时表记录更新了那些数据（A_Temp_OrderSourceSkuInfo_20230112）