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

流程 转fba或跟卖fba产生表RB_Amazon_FeedWithSellQueue数据，若需加入购物车AddedCartNum字段会产生值
同站点：new Biz.Irobotbox.AmazonUploadClass().FeedWithSellQueue()此服务产生表RB_Amazon_FeedResult数据
获取批量跟卖上传结果Task_Amazon_GetFeedResultQueue new RB.Utility.TaskSmartManager<RB.Model.RB_OrderSource_EbayAmazonAPI>(list).TaskExecute(this.GetFeedResultChild);
成功后加入产品到购物车，AddedCartNum字段变负区分

//fba状态还原sql
UPDATE vtb 
SET vtb.WaitToFbaType = 0,
vtb.NotToFbaReasonId = 0,
vtb.NotToFbaExplain = '' 
FROM
RB_Amazon_Product_Base vtb
WHERE
vtb.OrderSourceSKUID > 0
  AND vtb.ID = 161804863
//重复刊登判断>=2
SELECT
ID 
FROM
RB_Product_OrderSourceSKU ( nolock ) 
WHERE
CustomerID = 1 
AND isDelete = 0 
AND SellerType = 0 
AND ASINorItemID = 'B0C99P17FM' 

AND OrderSourceID = 14471

可添加购物车sql

SELECT TOP
200 fsq.ID ID,pb.CustomerID,pb.OrderSourceSKUID,fsq.AdminID AddAdminID,FirstLegShippingType,AddedCartNum ProductNum
FROM
RB_Amazon_FeedWithSellQueue fsq ( nolock )
INNER JOIN RB_Amazon_FeedResult fr ( nolock ) ON fsq.CustomerID = fr.CustomerID 
AND fsq.FeedSubmissionId  = fr.FeedSubmissionId
INNER JOIN RB_Amazon_Product_Base pb ( nolock ) ON fsq.OrderSourceID = pb.OrderSourceID 
AND fsq.OrderSourceSKU = pb.OrderSourceSKU 
AND fsq.CustomerID = pb.CustomerID 
WHERE
fsq.CustomerID = 1 
AND fsq.Status = 2 
AND AddedCartNum > 0 
AND fsq.ID > 0 
AND pb.OrderSourceSKUID > 0 
ORDER BY
fsq.ID ASC

服务触发按钮test3.aspx

脚本