[步骤]
层级促销异常反馈
标签名称：老品-潜力款-断货风险
MSKU：M241419XZNZ3
来源渠道：Amazon-Z01904-DE
异常情况描述：前台无促销，执行明细中无记录
标签名称：平款-呆滞清库-高可售正利润
MSKU：E114957T2K2L33Y
来源渠道：Amazon-Z011166-FR
异常情况描述：前台无促销，执行明细中无记录
标签名称：独立-平款-呆滞清库-高可售正利润
MSKU：
8B8049K6F852911309C0WVPJ
H50931L701SMTAU
来源渠道：
Amazon-Z01844-DE
Amazon-Z011261-DE
异常情况描述：3.13之后无执行记录；3.6之后无执行记录
层级促销
标签名称：FBA-独立-平款-呆滞清库-高可售负利润
MSKU：P041099QLCE
来源渠道: Amazon-Z01844-ES
异常情况描述：3.11之后无执行记录
[结果]
[期望]
来源渠道：Amazon-Z01844-DE，17136
策略：FBA-独立-平款-呆滞清库-高可售正利润，842
1、日志
db.getCollection("PercentageOffGroupLog").find({ $and : [{"OrderSourceId" : 17136}, {"ConfigId" : 842}] }).sort({
_id: -1}).limit(100).skip(0)
2、策略配置的listing
SELECT * FROM `zhcxkj_autochoose`.`config_promotion_value` WHERE `ConfigId` = '842' AND `OrderSourceId` = '17136' LIMIT 0,100
3、8B8049K6F852911309C0WVPJ 被奥特莱斯过滤了
[{
"OrderSourceId": 17136,
"OutLetsId": 45239,
"OutletDiscountId": 19970,
"SellerId": "A2UOAT3N3SB48G",
"MarketplaceId": "A1PA6795UKMFR9",
"DepartmentID": 743,
"SourceSector": 1,
"ThirdPartyID": 2272,
"SourceSku": "8B8049K6F852911309C0WVPJ",
"DiscountPrice": 10.69,
"ASIN": "B0C7S34XSR",
"CreateStatus": 1,
"CrawlASIN": "B0C7S34XSR",
"CrawlSKU": "8B8049K6F852911309C0WVPJ",
"CrawlProductName": "Anneome Mini Holzbank Dekoration mit Herzdesign Miniatur Gartenmöbel für Puppenhaus Dekoration Requisiten für Fotografie Kleines Holzstuhl Accessoire",
"CrawlDealTitle": "Anneome Mini Holzbank Dekoration mit Herzdesign Miniatur Gar",
"CrawlStatus": "RUNNING",
"CrawlDateSubmitted": "2025-03-10T09:56:31Z",
"CrawlDealStartDate": "2025-03-15T08:00:00Z",
"CrawlDealEndDate": "2025-03-29T08:00:00Z",
"CrawlCurrency": "EUR",
"CrawlDealPrice": "10.69",
"CrawlCountry": "DE",
"CollectStatus": 1,
"Msg": "创建成功",
"CurrencyCode": "EUR",
"AddTime": "2025-03-11T23:19:39.109Z",
"UpdateTime": "2025-03-20T22:06:10.77Z",
"ID": "67d0c50b2c0c206a3fd8d996"
}
]
MSKU：M241419XZNZ3
来源渠道：Amazon-Z01904-DE，也是奥特莱斯过滤
db.getCollection("OutLetsCrawlMgoModel").find({ $and : [{"OrderSourceId" : 19455}, {"SourceSku" : "M241419XZNZ3"}] }).limit(100).skip(0)