问题描述:
【灰度】Listing匹配SKU维度企业价格层级信息,刊登、自定义调价、通用场景调价 使用的是部门维度企业价格层级信息
自动刊登
db.EnterPrisePriceConfig.find({
DeliveryType:1,
DeptId:84
})
db.SkuEnterPrisePriceConfig.find({
sku:{$in:[
'17300471'
]}
})
db.AutoPublishUploadProductQueueNew.find({
_id:{$gt:ObjectId("6801b928d025865fd4a434b8")},
OrderSourceID:{$in:[24426,24427,24429,24430,24431,24432,24433,24439]},
SKU:'17300471'
})
.projection({})
.sort({_id:-1})
.limit(0)

自定义调价
db.EnterPrisePriceConfig.find({
DeliveryType:1,
DeptId:84
})
db.SkuEnterPrisePriceConfig.find({
deptIds:84,
deliveryType:1,
sku:{$in:[
'16649797'
]}
})
db.AdjustPriceQueueNew.find({
_id:{$gt:ObjectId("6801b928d025865fd4a434b8")},
OrderSourceID:{$in:[24426,24427,24429,24430,24431,24432,24433,24439]},
CommonStrategyId:0,
IsFBA:false,
SKU:'16649797'
})
.sort({_id:-1})
.limit(0)

通用场景
db.SkuEnterPrisePriceConfig.find({
deptIds:84,
deliveryType:1,
sku:{$in:[
'13502105'
]}
})
db.EnterPrisePriceConfig.find({
DeliveryType:1,
DeptId:84
})
db.AdjustPriceQueueNew.find({
_id:{$gt:ObjectId("6801b928d025865fd4a434b8")},
OrderSourceID:{$in:[24426,24427,24429,24430,24431,24432,24433,24439]},
CommonStrategyId:{$nin:[null,0]},
IsFBA:false,
SKU:'13502105'
})
.sort({_id:-1})
.limit(0)
