问题描述:
临时调价,折扣价为空,上传最高价最低价错误
数据:
SELECT id,source_id,msku,minimum_price,maximum_price
FROM `t_amazon_listing_amount_9` where source_id = 5288 and msku in (
'000548FU984','0001MTEWJTZP00CO2P88'
)
db.AdjustPriceQueueNew.find({
StrategyId:{$in:[2025051905]},
// IsRepairListingPrice:false,
// IsFBA:true
OrderSourceSKU:{$in:['2KI112927714RT5098','000548FU984','0001MTEWJTZP00CO2P88']}
}
,{_id:0,OrderSourceID:1,OrderSourceSKU:1,IsFBA:1,ListingPrice:1,DiscountSalesPrice:1,ListingPriceAft:1,
ProfitPrice:1,FinalProfitPrice:1,MinProfit:1,CaclListingPrice:1,IsRepairListingPrice:1,StrategyId:1,
"PriceRangeInfo.Min":1,"PriceRangeInfo.Max":1,SiteCode:1,"HandleInfo.DiscountFormula":1,Remark:1}
)
.projection({})
.sort({_id:-1})
.limit(0)
