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

接口变更：

通用场景保存/更新/查询接口结构变更

/Configs/UniversalStrategy/save

req:{

   Filter: {
       ItemFilter: {
            PublishTime: {} //渠道sku刊登时间, 结构同OrderSkuFirstArrivalDate
       },
       ShopFilter: {

           OrderProfitType: 0, //0-全店铺，1-fba, 2-fbm
           OrderProfits: [{}], //店铺利润率, 结构同BuyCarWins，最大3层

           QueryLimitWithAutoPublish: 1, //店铺刊登受限，0-否，1-是
       }
    }

}
查询接口结构同上

1.项目: autochoose, erpAmazonWorker- cron, rebuild, fba, 调价，层级，优惠券，日本积分

2.新增服务： 店铺利润率统计服务

UpdateSkuAndShopSalesInfoJob 增加action: SummaryOrderProfit

3. 涉及功能

通用场景及相关服务

4.测试

5.相关统计表

--销售额，利润额
SELECT
ord.OrderSourceID,
SUM(ord.Incomes) AS '销售额',
SUM(ord.Profits) AS '毛利润'
FROM rb_report_ordersettlement AS ord
WHERE 1=1
AND ord.CustomerID = 1
AND ord.OrderSourceType = 1
AND ord.ShipTime >= '2025-05-01' and ord.ShipTime < '2025-05-30'
and ord.OrderSourceID = 20158
GROUP BY
ord.OrderSourceID
--自动刊登8571

db.AutoPublishErrorCodeDetect.find({})
   .projection({})
   .sort({_id:-1})
   .limit(100)

--人工刊登8571

SELECT *FROM dbo.RB_AmazonUploadProduct_V2 (NOLOCK) 
WHERE CustomerID=1 and MessageCode LIKE '%8571%' and AddTime >= '2025-05-27'