WebSVN – SmartDukaan – Diff – /trunk/PyProj/src/shop2020/model/v1/catalog/script/AmazonHistoryPopulator.py



        else:
            sku = 'FBB'+str(autoDecrementItem.item_id)
        if amazonShortTermActivePromotions.has_key(sku):
            markReasonForItem(autoDecrementItem,'Item in short term promotion',Decision.AUTO_DECREMENT_FAILED)
            continue
        if math.ceil(autoDecrementItem.proposedSp) >= autoDecrementItem.promoPrice:
            markReasonForItem(autoDecrementItem,'Proposed SP greater than or equal to current SP',Decision.AUTO_DECREMENT_FAILED)
            continue
        if autoDecrementItem.proposedSp < autoDecrementItem.lowestPossibleSp:
            markReasonForItem(autoDecrementItem,'Proposed SP less than lowest possible SP',Decision.AUTO_DECREMENT_FAILED)
            continue

            markReasonForItem(autoIncrementItem,'Item in short term promotion',Decision.AUTO_INCREMENT_FAILED)
            continue
        if autoIncrementItem.totalSeller==1 and autoIncrementItem.ourRank==1:
            markReasonForItem(autoIncrementItem,'We are the only seller',Decision.AUTO_INCREMENT_FAILED)
            continue 
        if autoIncrementItem.proposedSp <= autoIncrementItem.promoPrice:
            markReasonForItem(autoIncrementItem,'Proposed SP less than current SP',Decision.AUTO_INCREMENT_FAILED)
            continue
        if autoIncrementItem.proposedSp >=10000 and autoIncrementItem.promoPrice<10000:
            markReasonForItem(autoIncrementItem,'Proposed SP is greater than 10,000 and current sp is less than 10,000',Decision.AUTO_INCREMENT_FAILED)
            continue
        
        if autoIncrementItem.isPromotion and (math.ceil(autoIncrementItem.promoPrice+max(10,.01*autoIncrementItem.promoPrice)) > (amazonLongTermActivePromotions.get(sku)).promoPrice):
            markReasonForItem(autoIncrementItem,'Proposed SP cant be greater than promo price',Decision.AUTO_INCREMENT_FAILED)

        
        daysOfStock = (float(autoIncrementItem.ourInventory))/autoIncrementItem.avgSale
        if daysOfStock > 5:
            markReasonForItem(autoIncrementItem,'Days of stock greater than 5',Decision.AUTO_INCREMENT_FAILED)
            continue
        if autoIncrementItem.isPromotion:
            antecedentPrice = session.query(AmazonScrapingHistory.promoPrice).filter(AmazonScrapingHistory.item_id==autoIncrementItem.item_id).filter(AmazonScrapingHistory.timestamp>time-timedelta(days=1)).order_by(asc(AmazonScrapingHistory.timestamp)).first()
            if antecedentPrice is not None:
                if float(math.ceil(autoIncrementItem.promoPrice+max(10,.01*autoIncrementItem.promoPrice))-math.ceil(antecedentPrice[0]+max(10,.01*antecedentPrice[0])))/math.ceil(antecedentPrice[0]+max(10,.01*antecedentPrice[0]))>.02:
                    markReasonForItem(autoIncrementItem,'Maximum price increase in last 24 hours should be 2%',Decision.AUTO_INCREMENT_FAILED)
                    continue
        else:
            antecedentPrice = session.query(AmazonScrapingHistory.ourSellingPrice).filter(AmazonScrapingHistory.item_id==autoIncrementItem.item_id).filter(AmazonScrapingHistory.timestamp>time-timedelta(days=1)).order_by(asc(AmazonScrapingHistory.timestamp)).first()
            if antecedentPrice is not None:
                if float(math.ceil(autoIncrementItem.ourSellingPrice+max(10,.01*autoIncrementItem.ourSellingPrice))-math.ceil(antecedentPrice[0]+max(10,.01*antecedentPrice[0])))/math.ceil(antecedentPrice[0]+max(10,.01*antecedentPrice[0]))>.02:
                    markReasonForItem(autoIncrementItem,'Maximum price increase in last 24 hours should be 2%',Decision.AUTO_INCREMENT_FAILED)
                    continue
        fbaSaleSnapshot = transaction_client.getAmazonFbaSalesLatestSnapshotForItemLocationWise(autoIncrementItem.item_id,autoIncrementItem.warehouseLocation)
        if getLastDaySale(fbaSaleSnapshot)<=2:
            markReasonForItem(autoIncrementItem,'Last day sale is less than 3',Decision.AUTO_INCREMENT_FAILED)
            continue
        

        sheet.write(sheet_iterator, 23, amScraping.otherCost)
        sheet.write(sheet_iterator, 24, amScraping.wanlc)
        sheet.write(sheet_iterator, 25, amScraping.commission)
        sheet.write(sheet_iterator, 26, amScraping.competitorCommission)
        sheet.write(sheet_iterator, 27, amScraping.returnProvision)
        sheet.write(sheet_iterator, 28, round(amScraping.promoPrice - amScraping.lowestPossibleSp))
        sheet.write(sheet_iterator, 29, item.risky)
        sheet.write(sheet_iterator, 30, amScraping.proposedSp)
        sheet.write(sheet_iterator, 31, amScraping.avgSale)
        sheet.write(sheet_iterator, 32, getOosString(saleMap.get(sku)))
        sheet_iterator+=1

        sheet.write(sheet_iterator, 23, amScraping.otherCost)
        sheet.write(sheet_iterator, 24, amScraping.wanlc)
        sheet.write(sheet_iterator, 25, amScraping.commission)
        sheet.write(sheet_iterator, 26, amScraping.competitorCommission)
        sheet.write(sheet_iterator, 27, amScraping.returnProvision)
        sheet.write(sheet_iterator, 28, round(amScraping.promoPrice - amScraping.lowestPossibleSp))
        sheet.write(sheet_iterator, 29, item.risky)
        sheet.write(sheet_iterator, 30, amScraping.proposedSp)
        sheet.write(sheet_iterator, 31, amScraping.avgSale)
        sheet.write(sheet_iterator, 32, getOosString(saleMap.get(sku)))
        if amScraping.decision is None:

        sheet.write(sheet_iterator, 33, Decision._VALUES_TO_NAMES.get(amScraping.decision))
        sheet.write(sheet_iterator, 34, amScraping.reason)
        if Decision._VALUES_TO_NAMES.get(amScraping.decision) == "AUTO_DECREMENT_SUCCESS":
            sheet.write(sheet_iterator, 35, math.ceil(amScraping.proposedSp))
        if Decision._VALUES_TO_NAMES.get(amScraping.decision) == "AUTO_INCREMENT_SUCCESS":
            sheet.write(sheet_iterator, 35, math.ceil(amScraping.promoPrice+max(10,.01*amScraping.promoPrice)))
        sheet_iterator+=1
    
    sheet = wbk.add_sheet('Almost Competitive')
    xstr = lambda s: s or ""
    heading_xf = xlwt.easyxf('font: bold on; align: wrap off, vert centre, horiz center')

        sheet.write(sheet_iterator, 23, amScraping.otherCost)
        sheet.write(sheet_iterator, 24, amScraping.wanlc)
        sheet.write(sheet_iterator, 25, amScraping.commission)
        sheet.write(sheet_iterator, 26, amScraping.competitorCommission)
        sheet.write(sheet_iterator, 27, amScraping.returnProvision)
        sheet.write(sheet_iterator, 28, round(amScraping.promoPrice - amScraping.lowestPossibleSp))
        sheet.write(sheet_iterator, 29, item.risky)
        sheet.write(sheet_iterator, 30, amScraping.proposedSp)
        sheet.write(sheet_iterator, 31, amScraping.avgSale)
        sheet.write(sheet_iterator, 32, getOosString(saleMap.get(sku)))
        if amScraping.decision is None:

        sheet.write(sheet_iterator, 33, Decision._VALUES_TO_NAMES.get(amScraping.decision))
        sheet.write(sheet_iterator, 34, amScraping.reason)
        if Decision._VALUES_TO_NAMES.get(amScraping.decision) == "AUTO_DECREMENT_SUCCESS":
            sheet.write(sheet_iterator, 35, math.ceil(amScraping.proposedSp))
        if Decision._VALUES_TO_NAMES.get(amScraping.decision) == "AUTO_INCREMENT_SUCCESS":
            sheet.write(sheet_iterator, 35, math.ceil(amScraping.promoPrice+max(10,.01*amScraping.promoPrice)))
        sheet_iterator+=1
    
    sheet = wbk.add_sheet('Among Cheapest')
    xstr = lambda s: s or ""
    heading_xf = xlwt.easyxf('font: bold on; align: wrap off, vert centre, horiz center')

        sheet.write(sheet_iterator, 23, amScraping.otherCost)
        sheet.write(sheet_iterator, 24, amScraping.wanlc)
        sheet.write(sheet_iterator, 25, amScraping.commission)
        sheet.write(sheet_iterator, 26, amScraping.competitorCommission)
        sheet.write(sheet_iterator, 27, amScraping.returnProvision)
        sheet.write(sheet_iterator, 28, round(amScraping.promoPrice - amScraping.lowestPossibleSp))
        sheet.write(sheet_iterator, 29, item.risky)
        sheet.write(sheet_iterator, 30, amScraping.proposedSp)
        sheet.write(sheet_iterator, 31, amScraping.avgSale)
        sheet.write(sheet_iterator, 32, getOosString(saleMap.get(sku)))
        if amScraping.decision is None:

        sheet.write(sheet_iterator, 33, Decision._VALUES_TO_NAMES.get(amScraping.decision))
        sheet.write(sheet_iterator, 34, amScraping.reason)
        if Decision._VALUES_TO_NAMES.get(amScraping.decision) == "AUTO_DECREMENT_SUCCESS":
            sheet.write(sheet_iterator, 35, math.ceil(amScraping.proposedSp))
        if Decision._VALUES_TO_NAMES.get(amScraping.decision) == "AUTO_INCREMENT_SUCCESS":
            sheet.write(sheet_iterator, 35, math.ceil(amScraping.promoPrice+max(10,.01*amScraping.promoPrice)))
        sheet_iterator+=1
    
    sheet = wbk.add_sheet('Cheapest')
    xstr = lambda s: s or ""
    heading_xf = xlwt.easyxf('font: bold on; align: wrap off, vert centre, horiz center')

        sheet.write(sheet_iterator, 23, amScraping.otherCost)
        sheet.write(sheet_iterator, 24, amScraping.wanlc)
        sheet.write(sheet_iterator, 25, amScraping.commission)
        sheet.write(sheet_iterator, 26, amScraping.competitorCommission)
        sheet.write(sheet_iterator, 27, amScraping.returnProvision)
        sheet.write(sheet_iterator, 28, round(amScraping.promoPrice - amScraping.lowestPossibleSp))
        sheet.write(sheet_iterator, 29, item.risky)
        sheet.write(sheet_iterator, 30, amScraping.proposedSp)
        sheet.write(sheet_iterator, 31, amScraping.avgSale)
        sheet.write(sheet_iterator, 32, getOosString(saleMap.get(sku)))
        if amScraping.decision is None:

        sheet.write(sheet_iterator, 33, Decision._VALUES_TO_NAMES.get(amScraping.decision))
        sheet.write(sheet_iterator, 34, amScraping.reason)
        if Decision._VALUES_TO_NAMES.get(amScraping.decision) == "AUTO_DECREMENT_SUCCESS":
            sheet.write(sheet_iterator, 35, math.ceil(amScraping.proposedSp))
        if Decision._VALUES_TO_NAMES.get(amScraping.decision) == "AUTO_INCREMENT_SUCCESS":
            sheet.write(sheet_iterator, 35, math.ceil(amScraping.promoPrice+max(10,.01*amScraping.promoPrice)))
        sheet_iterator+=1
    
    sheet = wbk.add_sheet('Negative Margin')
    xstr = lambda s: s or ""
    heading_xf = xlwt.easyxf('font: bold on; align: wrap off, vert centre, horiz center')

        sheet.write(sheet_iterator, 23, amScraping.otherCost)
        sheet.write(sheet_iterator, 24, amScraping.wanlc)
        sheet.write(sheet_iterator, 25, amScraping.commission)
        sheet.write(sheet_iterator, 26, amScraping.competitorCommission)
        sheet.write(sheet_iterator, 27, amScraping.returnProvision)
        sheet.write(sheet_iterator, 28, round(amScraping.promoPrice - amScraping.lowestPossibleSp))
        sheet.write(sheet_iterator, 29, amScraping.avgSale)
        sheet.write(sheet_iterator, 30, getOosString(saleMap.get(sku)))
        sheet_iterator+=1
    
    sheet = wbk.add_sheet('Exception List')

Subversion Repositories SmartDukaan

(root)/trunk/PyProj/src/shop2020/model/v1/catalog/script/AmazonHistoryPopulator.py – Rev 12483 → 12484

Rev 12483		Rev 12484
Line 112...		Line 112...
112	`else:`	112	`else:`
113	`sku = 'FBB'+str(autoDecrementItem.item_id)`	113	`sku = 'FBB'+str(autoDecrementItem.item_id)`
114	`if amazonShortTermActivePromotions.has_key(sku):`	114	`if amazonShortTermActivePromotions.has_key(sku):`
115	`markReasonForItem(autoDecrementItem,'Item in short term promotion',Decision.AUTO_DECREMENT_FAILED)`	115	`markReasonForItem(autoDecrementItem,'Item in short term promotion',Decision.AUTO_DECREMENT_FAILED)`
116	`continue`	116	`continue`
117	`if math.ceil(autoDecrementItem.proposedSp) >= autoDecrementItem.ourSellingPrice:`	117	`if math.ceil(autoDecrementItem.proposedSp) >= autoDecrementItem.promoPrice:`
118	`markReasonForItem(autoDecrementItem,'Proposed SP greater than or equal to current SP',Decision.AUTO_DECREMENT_FAILED)`	118	`markReasonForItem(autoDecrementItem,'Proposed SP greater than or equal to current SP',Decision.AUTO_DECREMENT_FAILED)`
119	`continue`	119	`continue`
120	`if autoDecrementItem.proposedSp < autoDecrementItem.lowestPossibleSp:`	120	`if autoDecrementItem.proposedSp < autoDecrementItem.lowestPossibleSp:`
121	`markReasonForItem(autoDecrementItem,'Proposed SP less than lowest possible SP',Decision.AUTO_DECREMENT_FAILED)`	121	`markReasonForItem(autoDecrementItem,'Proposed SP less than lowest possible SP',Decision.AUTO_DECREMENT_FAILED)`
122	`continue`	122	`continue`
Line 175...		Line 175...
175	`markReasonForItem(autoIncrementItem,'Item in short term promotion',Decision.AUTO_INCREMENT_FAILED)`	175	`markReasonForItem(autoIncrementItem,'Item in short term promotion',Decision.AUTO_INCREMENT_FAILED)`
176	`continue`	176	`continue`
177	`if autoIncrementItem.totalSeller==1 and autoIncrementItem.ourRank==1:`	177	`if autoIncrementItem.totalSeller==1 and autoIncrementItem.ourRank==1:`
178	`markReasonForItem(autoIncrementItem,'We are the only seller',Decision.AUTO_INCREMENT_FAILED)`	178	`markReasonForItem(autoIncrementItem,'We are the only seller',Decision.AUTO_INCREMENT_FAILED)`
179	`continue`	179	`continue`
180	`if autoIncrementItem.proposedSp <= autoIncrementItem.ourSellingPrice:`	180	`if autoIncrementItem.proposedSp <= autoIncrementItem.promoPrice:`
181	`markReasonForItem(autoIncrementItem,'Proposed SP less than current SP',Decision.AUTO_INCREMENT_FAILED)`	181	`markReasonForItem(autoIncrementItem,'Proposed SP less than current SP',Decision.AUTO_INCREMENT_FAILED)`
182	`continue`	182	`continue`
183	`if autoIncrementItem.proposedSp >=10000 and autoIncrementItem.ourSellingPrice<10000:`	183	`if autoIncrementItem.proposedSp >=10000 and autoIncrementItem.promoPrice<10000:`
184	`markReasonForItem(autoIncrementItem,'Proposed SP is greater than 10,000 and current sp is less than 10,000',Decision.AUTO_INCREMENT_FAILED)`	184	`markReasonForItem(autoIncrementItem,'Proposed SP is greater than 10,000 and current sp is less than 10,000',Decision.AUTO_INCREMENT_FAILED)`
185	`continue`	185	`continue`
186		186
187	`if autoIncrementItem.isPromotion and (math.ceil(autoIncrementItem.promoPrice+max(10,.01*autoIncrementItem.promoPrice)) > (amazonLongTermActivePromotions.get(sku)).promoPrice):`	187	`if autoIncrementItem.isPromotion and (math.ceil(autoIncrementItem.promoPrice+max(10,.01*autoIncrementItem.promoPrice)) > (amazonLongTermActivePromotions.get(sku)).promoPrice):`
188	`markReasonForItem(autoIncrementItem,'Proposed SP cant be greater than promo price',Decision.AUTO_INCREMENT_FAILED)`	188	`markReasonForItem(autoIncrementItem,'Proposed SP cant be greater than promo price',Decision.AUTO_INCREMENT_FAILED)`
Line 195...		Line 195...
195		195
196	`daysOfStock = (float(autoIncrementItem.ourInventory))/autoIncrementItem.avgSale`	196	`daysOfStock = (float(autoIncrementItem.ourInventory))/autoIncrementItem.avgSale`
197	`if daysOfStock > 5:`	197	`if daysOfStock > 5:`
198	`markReasonForItem(autoIncrementItem,'Days of stock greater than 5',Decision.AUTO_INCREMENT_FAILED)`	198	`markReasonForItem(autoIncrementItem,'Days of stock greater than 5',Decision.AUTO_INCREMENT_FAILED)`
199	`continue`	199	`continue`
200	`antecedentPrice = session.query(AmazonScrapingHistory.ourSellingPrice).filter(AmazonScrapingHistory.item_id==autoIncrementItem.item_id).filter(AmazonScrapingHistory.timestamp>time-timedelta(days=1)).order_by(asc(AmazonScrapingHistory.timestamp)).first()`	200	`if autoIncrementItem.isPromotion:`
201	`if antecedentPrice is not None:`	201	`antecedentPrice = session.query(AmazonScrapingHistory.promoPrice).filter(AmazonScrapingHistory.item_id==autoIncrementItem.item_id).filter(AmazonScrapingHistory.timestamp>time-timedelta(days=1)).order_by(asc(AmazonScrapingHistory.timestamp)).first()`
-		202	`if antecedentPrice is not None:`
202	`if float(math.ceil(autoIncrementItem.ourSellingPrice+max(10,.01autoIncrementItem.ourSellingPrice))-math.ceil(antecedentPrice[0]+max(10,.01antecedentPrice[0])))/math.ceil(antecedentPrice[0]+max(10,.01*antecedentPrice[0]))>.02:`	203	`if float(math.ceil(autoIncrementItem.promoPrice+max(10,.01autoIncrementItem.promoPrice))-math.ceil(antecedentPrice[0]+max(10,.01antecedentPrice[0])))/math.ceil(antecedentPrice[0]+max(10,.01*antecedentPrice[0]))>.02:`
203	`markReasonForItem(autoIncrementItem,'Maximum price increase in last 24 hours should be 2%',Decision.AUTO_INCREMENT_FAILED)`	204	`markReasonForItem(autoIncrementItem,'Maximum price increase in last 24 hours should be 2%',Decision.AUTO_INCREMENT_FAILED)`
-		205	`continue`
-		206	`else:`