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

             continue
         cc = computeCourierCost(it.weight)
         amazonItemInfo = __AmazonItemInfo(None, wanlc,cc, sku, it.product_group, it.brand, it.model_name, it.model_number, it.color, it.weight, category.parent_category_id, it.risky, None, runType, parent_category.display_name,sourcePercentage,fbaInventoryItem.availability,state_id,d_amazon_listed.otherCost)
         itemInfo.append(amazonItemInfo)
+    #amPromotions = AmazonPromotion.query.filter(AmazonPromotion.startDate<=time).filter(AmazonPromotion.endDate>=time).filter(AmazonPromotion.promotionType==AmazonPromotionType.LONGTERM).filter(AmazonPromotion.promotionActive==True) \
+    #.group_by(AmazonPromotion.sku).order_by(desc(AmazonPromotion.addedOn)).all()
     amPromotions = AmazonPromotion.query.filter(AmazonPromotion.startDate<=time).filter(AmazonPromotion.endDate>=time).filter(AmazonPromotion.promotionType==AmazonPromotionType.LONGTERM).filter(AmazonPromotion.promotionActive==True) \
-    .group_by(AmazonPromotion.sku).order_by(desc(AmazonPromotion.addedOn)).all()
+    .order_by(desc(AmazonPromotion.addedOn)).all()
     for amPromotion in amPromotions:
         amazonLongTermActivePromotions[amPromotion.sku] = __Promotion(amPromotion.salePrice,amPromotion.subsidy,amPromotion.promotionType,amPromotion.endDate)
+    #amPromotions = AmazonPromotion.query.filter(AmazonPromotion.startDate<=time).filter(AmazonPromotion.endDate>=time).filter(AmazonPromotion.promotionType==AmazonPromotionType.SHORTTERM).filter(AmazonPromotion.promotionActive==True) \
+    #.group_by(AmazonPromotion.sku).order_by(desc(AmazonPromotion.addedOn)).all()
     amPromotions = AmazonPromotion.query.filter(AmazonPromotion.startDate<=time).filter(AmazonPromotion.endDate>=time).filter(AmazonPromotion.promotionType==AmazonPromotionType.SHORTTERM).filter(AmazonPromotion.promotionActive==True) \
-    .group_by(AmazonPromotion.sku).order_by(desc(AmazonPromotion.addedOn)).all()
+    .order_by(desc(AmazonPromotion.addedOn)).all()
     for amPromotion in amPromotions:
         amazonShortTermActivePromotions[amPromotion.sku] = __Promotion(amPromotion.salePrice,amPromotion.subsidy,amPromotion.promotionType,amPromotion.endDate)
     session.close()
     print "No of items populated ",len(itemInfo)
     sleep(5)
         cantCompete.append(temp)
     print "Created category..."
     return exceptionList, negativeMargin, cheapest, amongCheapestAndCanCompete, canCompete, almostCompete, cantCompete
+def getBreakevenPrice(item,val,spm):
+    breakEvenPrice = (val.nlc+(val.courierCost)*(1+(spm.serviceTax/100))*(1+(val.vatRate/100))+(15.0+val.otherCost)*(1+(val.vatRate)/100))/(1-(spm.commission/100+spm.emiFee/100)*(1+(spm.serviceTax/100))*(1+(val.vatRate)/100)-(spm.returnProvision/100)*(1+(val.vatRate)/100));
+    return round(breakEvenPrice,2)
 def getLowestPossibleSp(amazonDetails,val,spm):
     lowestPossibleSp = (val.nlc+(val.courierCost)*(1+(spm.serviceTax/100))*(1+(val.vatRate/100))+(15.0+val.otherCost)*(1+(val.vatRate)/100))/(1-(spm.commission/100+spm.emiFee/100)*(1+(spm.serviceTax/100))*(1+(val.vatRate)/100)-(spm.returnProvision/100)*(1+(val.vatRate)/100));
     if val.isPromo:
         if amazonLongTermActivePromotions.has_key(val.sku):
             subsidy = (amazonLongTermActivePromotions.get(val.sku)).subsidy
         else:
             subsidy = (amazonShortTermActivePromotions.get(val.sku)).subsidy
-        lowestPossibleSp = lowestPossibleSp - subsidy
         print "subsidy ",subsidy
-    print (val.nlc+(val.courierCost)*(1+(spm.serviceTax/100))*(1+(val.vatRate/100))+(15+val.otherCost)*(1+(val.vatRate)/100))
+	lowestPossibleSp = (val.nlc-subsidy+(val.courierCost)*(1+(spm.serviceTax/100))*(1+(val.vatRate/100))+(15.0+val.otherCost)*(1+(val.vatRate)/100))/(1-(spm.commission/100+spm.emiFee/100)*(1+(spm.serviceTax/100))*(1+(val.vatRate)/100)-(spm.returnProvision/100)*(1+(val.vatRate)/100));
+    #print (val.nlc-subsidy+(val.courierCost)*(1+(spm.serviceTax/100))*(1+(val.vatRate/100))+(15+val.otherCost)*(1+(val.vatRate)/100))
-    print (1-(spm.commission/100+spm.emiFee/100)*(1+(spm.serviceTax/100))*(1+(val.vatRate)/100)-(spm.returnProvision/100)*(1+(val.vatRate)/100))
+    #print (1-(spm.commission/100+spm.emiFee/100)*(1+(spm.serviceTax/100))*(1+(val.vatRate)/100)-(spm.returnProvision/100)*(1+(val.vatRate)/100))
     return round(lowestPossibleSp,2)
 def getNewLowestPossibleSp(item,serviceTax,newVatRate):
     lowestPossibleSp = (item.wanlc+(item.courierCost)*(1+(serviceTax/100))*(1+(newVatRate/100))+(15+item.otherCost)*(1+(newVatRate)/100))/(1-(item.commission/100)*(1+(serviceTax/100))*(1+(newVatRate)/100)-(item.returnProvision/100)*(1+(newVatRate)/100));
     if item.isPromotion:
             sku='FBB'+str(item.item_id)
         if amazonLongTermActivePromotions.has_key(sku):
             subsidy = (amazonLongTermActivePromotions.get(sku)).subsidy
         else:
             subsidy = (amazonShortTermActivePromotions.get(sku)).subsidy
+        print "subsidy ",subsidy
-        lowestPossibleSp = lowestPossibleSp - subsidy
+        lowestPossibleSp = (item.wanlc-subsidy+(item.courierCost)*(1+(serviceTax/100))*(1+(newVatRate/100))+(15+item.otherCost)*(1+(newVatRate)/100))/(1-(item.commission/100)*(1+(serviceTax/100))*(1+(newVatRate)/100)-(item.returnProvision/100)*(1+(newVatRate)/100));
     return round(lowestPossibleSp,2)
 def getTargetTp(targetSp,spm,val):
     targetTp = targetSp- targetSp*(spm.commission/100+spm.emiFee/100)*(1+(spm.serviceTax/100))-(val.courierCost)*(1+(spm.serviceTax/100))
     return round(targetTp,2)
 def commitExceptionList(exceptionList,timestamp,runType):
     #TODO : Get service tax from marketplaceitems table
     return 12.36
 def getClosingFee(data):
     myClosingFee = 0
-    return round(myClosingFee*(1+getServiceTax(data)/100))
+    return myClosingFee*(1+getServiceTax(data)/100)
 def getCommission(data):
-    return round((data.commission * data.promoPrice/100)*(1+getServiceTax(data)/100))
+    return (data.commission * data.promoPrice/100)*(1+getServiceTax(data)/100)
 def getCourierCost(data):
-    return round((data.courierCost)*(1+getServiceTax(data)/100))
+    return data.courierCost*(1+getServiceTax(data)/100)
+def getCostToAmazon(data):
+    myCostToAmazon = round(data.promoPrice*data.commission/100*(1+getServiceTax(data)/100)+getCourierCost(data)*(1+getServiceTax(data)/100))
+    return myCostToAmazon
 def getMargin(amScraping):
     #sheet.write(sheet_iterator, 30, round(amScraping.promoPrice - amScraping.lowestPossibleSp))
     #Promo Price minus costs plus subsidy
     #costs = WANLC (actual or overrrde whichever is applicable) + Courier cost + Closing fee + Commission + Packaging + VAT + Returns Cost + other cost.
+    '''
     if(amScraping.ourSellingPrice >= amScraping.promoPrice):
 	mySubsidy = amScraping.subsidy
     else:
 	mySubsidy = 0
+    '''
     print 'promo price ',amScraping.promoPrice
-    print 'mySubsidy ',mySubsidy
+    #print 'mySubsidy ',mySubsidy
     print 'wanlc ',amScraping.wanlc
     print 'courier cost ',getCourierCost(amScraping)
     print 'closing fee ',getClosingFee(amScraping)
     print 'commission ',getCommission(amScraping)
     print 'packaging ',getPackagingCost(amScraping)
     print 'vat ',getVat(amScraping)
     print 'return cost ',getReturnCost(amScraping)
     print 'other cost ',amScraping.otherCost
+    print 'cost to amazon ',getCostToAmazon(amScraping)
     myCosts = amScraping.wanlc + getCourierCost(amScraping) + getClosingFee(amScraping) + getCommission(amScraping) + getPackagingCost(amScraping) + getVat(amScraping) + getReturnCost(amScraping) + amScraping.otherCost
-    margin = amScraping.promoPrice - myCosts + mySubsidy
+    margin = amScraping.promoPrice - myCosts + amScraping.subsidy
+    print 'margin for ',amScraping.item_id,' is ',margin
     return round(margin)
 def getVat(data):
     #VAT amount = Promo Price/(1+Vat Rate)*VAT Rate minus NLC/(1+VAT Rate)*VAT Rate
     myVatPercentage = data.vatRate/100
     sheet_iterator = 1
     cantCompeteItems = session.query(AmazonScrapingHistory,Item).join((Item,AmazonScrapingHistory.item_id==Item.id)).filter(AmazonScrapingHistory.competitiveCategory==CompetitionCategory.CANT_COMPETE).filter(AmazonScrapingHistory.timestamp==timestamp).all()
     for cantCompeteItem in cantCompeteItems:
         amScraping =  cantCompeteItem[0]
         item = cantCompeteItem[1]
-        print item
+        print "Item = ",item
         sheet.write(sheet_iterator, 0, amScraping.item_id)
         if amScraping.warehouseLocation == 1:
             sku = 'FBA'+str(amScraping.item_id)
             loc = 'MUMBAI'
         else:
     excel_integer_format = '0'
     integer_style = xlwt.XFStyle()
     integer_style.num_format_str = excel_integer_format
     writeheaders(sheet,heading_xf)
-    '''
-    sheet.write(0, 0, "Item Id", heading_xf)
-    sheet.write(0, 1, "Amazon Sku", heading_xf)
-    sheet.write(0, 2, "Asin", heading_xf)
-    sheet.write(0, 3, "Location", heading_xf)
-    sheet.write(0, 4, "Brand", heading_xf)
-    sheet.write(0, 5, "Product Name", heading_xf)
-    sheet.write(0, 6, "Weight", heading_xf)
-    sheet.write(0, 7, "Courier Cost", heading_xf)
-    sheet.write(0, 8, "Our SP", heading_xf)
-    sheet.write(0, 9, "Promo Price", heading_xf)
-    sheet.write(0, 10, "Is Promotion", heading_xf)
-    sheet.write(0, 11, "Lowest Possible SP", heading_xf)
-    sheet.write(0, 12, "Rank", heading_xf)
-    sheet.write(0, 13, "Our Inventory", heading_xf)
-    sheet.write(0, 14, "Lowest Seller SP", heading_xf)
-    sheet.write(0, 15, "Lowest Seller Rating", heading_xf)
-    sheet.write(0, 16, "Lowest Seller Shipping Time", heading_xf)
-    sheet.write(0, 17, "Second Lowest Seller SP", heading_xf)
-    sheet.write(0, 18, "Second Lowest Seller Rating", heading_xf)
-    sheet.write(0, 19, "Second Lowest Seller Shipping Time", heading_xf)
-    sheet.write(0, 20, "Third Lowest Seller SP", heading_xf)
-    sheet.write(0, 21, "Third Lowest Seller Rating", heading_xf)
-    sheet.write(0, 22, "Third Lowest Seller Shipping Time", heading_xf)
-    sheet.write(0, 23, "Other Cost", heading_xf)
-    sheet.write(0, 24, "WANLC", heading_xf)
-    sheet.write(0, 25, "Commission", heading_xf)
-    sheet.write(0, 26, "Competitor Commission", heading_xf)
-    sheet.write(0, 27, "Return Provision", heading_xf)
-    sheet.write(0, 28, "Vat Rate", heading_xf)
-    sheet.write(0, 29, "Margin", heading_xf)
-    sheet.write(0, 30, "Risky", heading_xf)
-    sheet.write(0, 31, "Proposed Sp", heading_xf)
-    sheet.write(0, 32, "Avg Sale", heading_xf)
-    sheet.write(0, 33, "Sales History", heading_xf)
-    '''
     sheet.write(0, 36, "Decision", heading_xf)
     sheet.write(0, 37, "Reason", heading_xf)
     sheet.write(0, 38, "Updated Price", heading_xf)
     sheet_iterator = 1
     excel_integer_format = '0'
     integer_style = xlwt.XFStyle()
     integer_style.num_format_str = excel_integer_format
     writeheaders(sheet,heading_xf)
-    '''
-    sheet.write(0, 0, "Item Id", heading_xf)
-    sheet.write(0, 1, "Amazon Sku", heading_xf)
-    sheet.write(0, 2, "Asin", heading_xf)
-    sheet.write(0, 3, "Location", heading_xf)
-    sheet.write(0, 4, "Brand", heading_xf)
-    sheet.write(0, 5, "Product Name", heading_xf)
-    sheet.write(0, 6, "Weight", heading_xf)
-    sheet.write(0, 7, "Courier Cost", heading_xf)
-    sheet.write(0, 8, "Our SP", heading_xf)
-    sheet.write(0, 9, "Promo Price", heading_xf)
-    sheet.write(0, 10, "Is Promotion", heading_xf)
-    sheet.write(0, 11, "Lowest Possible SP", heading_xf)
-    sheet.write(0, 12, "Rank", heading_xf)
-    sheet.write(0, 13, "Our Inventory", heading_xf)
-    sheet.write(0, 14, "Lowest Seller SP", heading_xf)
-    sheet.write(0, 15, "Lowest Seller Rating", heading_xf)
-    sheet.write(0, 16, "Lowest Seller Shipping Time", heading_xf)
-    sheet.write(0, 17, "Second Lowest Seller SP", heading_xf)
-    sheet.write(0, 18, "Second Lowest Seller Rating", heading_xf)
-    sheet.write(0, 19, "Second Lowest Seller Shipping Time", heading_xf)
-    sheet.write(0, 20, "Third Lowest Seller SP", heading_xf)
-    sheet.write(0, 21, "Third Lowest Seller Rating", heading_xf)
-    sheet.write(0, 22, "Third Lowest Seller Shipping Time", heading_xf)
-    sheet.write(0, 23, "Other Cost", heading_xf)
-    sheet.write(0, 24, "WANLC", heading_xf)
-    sheet.write(0, 25, "Commission", heading_xf)
-    sheet.write(0, 26, "Competitor Commission", heading_xf)
-    sheet.write(0, 27, "Return Provision", heading_xf)
-    sheet.write(0, 28, "Vat Rate", heading_xf)
-    sheet.write(0, 29, "Margin", heading_xf)
-    sheet.write(0, 30, "Risky", heading_xf)
-    sheet.write(0, 31, "Proposed Sp", heading_xf)
-    sheet.write(0, 32, "Avg Sale", heading_xf)
-    sheet.write(0, 33, "Sales History", heading_xf)
-    '''
     sheet.write(0, 36, "Decision", heading_xf)
     sheet.write(0, 37, "Reason", heading_xf)
     sheet.write(0, 38, "Updated Price", heading_xf)
     sheet_iterator = 1
     almostCompetitiveItems = session.query(AmazonScrapingHistory,Item).join((Item,AmazonScrapingHistory.item_id==Item.id)).filter(AmazonScrapingHistory.competitiveCategory==CompetitionCategory.ALMOST_COMPETE).filter(AmazonScrapingHistory.timestamp==timestamp).all()
             sku = 'FBA'+str(amScraping.item_id)
             loc = 'MUMBAI'
         else:
             sku = 'FBB'+str(amScraping.item_id)
             loc = 'BANGLORE'
-'''
-        amScraping =  competitiveItem[0]
-        item = competitiveItem[1]
-        if amScraping.warehouseLocation == 1:
-            sku = 'FBA'+str(amScraping.item_id)
-            loc = 'MUMBAI'
-        else:
-            sku = 'FBB'+str(amScraping.item_id)
-            loc = 'BANGLORE'
-'''
         sheet.write(sheet_iterator, 1, sku)
         sheet.write(sheet_iterator, 2, amScraping.asin)
         sheet.write(sheet_iterator, 3, loc)
         sheet.write(sheet_iterator, 4, item.brand)
         sheet.write(sheet_iterator, 5, getCategory(item))
     excel_integer_format = '0'
     integer_style = xlwt.XFStyle()
     integer_style.num_format_str = excel_integer_format
     writeheaders(sheet,heading_xf)
-    '''
-    sheet.write(0, 0, "Item Id", heading_xf)
-    sheet.write(0, 1, "Amazon Sku", heading_xf)
-    sheet.write(0, 2, "Asin", heading_xf)
-    sheet.write(0, 3, "Location", heading_xf)
-    sheet.write(0, 4, "Brand", heading_xf)
-    sheet.write(0, 5, "Product Name", heading_xf)
-    sheet.write(0, 6, "Weight", heading_xf)
-    sheet.write(0, 7, "Courier Cost", heading_xf)
-    sheet.write(0, 8, "Our SP", heading_xf)
-    sheet.write(0, 9, "Promo Price", heading_xf)
-    sheet.write(0, 10, "Is Promotion", heading_xf)
-    sheet.write(0, 11, "Lowest Possible SP", heading_xf)
-    sheet.write(0, 12, "Rank", heading_xf)
-    sheet.write(0, 13, "Our Inventory", heading_xf)
-    sheet.write(0, 14, "Lowest Seller SP", heading_xf)
-    sheet.write(0, 15, "Lowest Seller Rating", heading_xf)
-    sheet.write(0, 16, "Lowest Seller Shipping Time", heading_xf)
-    sheet.write(0, 17, "Second Lowest Seller SP", heading_xf)
-    sheet.write(0, 18, "Second Lowest Seller Rating", heading_xf)
-    sheet.write(0, 19, "Second Lowest Seller Shipping Time", heading_xf)
-    sheet.write(0, 20, "Third Lowest Seller SP", heading_xf)
-    sheet.write(0, 21, "Third Lowest Seller Rating", heading_xf)
-    sheet.write(0, 22, "Third Lowest Seller Shipping Time", heading_xf)
-    sheet.write(0, 23, "Other Cost", heading_xf)
-    sheet.write(0, 24, "WANLC", heading_xf)
-    sheet.write(0, 25, "Commission", heading_xf)
-    sheet.write(0, 26, "Competitor Commission", heading_xf)
-    sheet.write(0, 27, "Return Provision", heading_xf)
-    sheet.write(0, 28, "Vat Rate", heading_xf)
-    sheet.write(0, 29, "Margin", heading_xf)
-    sheet.write(0, 30, "Risky", heading_xf)
-    sheet.write(0, 31, "Proposed Sp", heading_xf)
-    sheet.write(0, 32, "Avg Sale", heading_xf)
-    sheet.write(0, 33, "Sales History", heading_xf)
-    '''
     sheet.write(0, 36, "Decision", heading_xf)
     sheet.write(0, 37, "Reason", heading_xf)
     sheet.write(0, 38, "Updated Price", heading_xf)
     sheet_iterator = 1
     amongCheapestItems = session.query(AmazonScrapingHistory,Item).join((Item,AmazonScrapingHistory.item_id==Item.id)).filter(AmazonScrapingHistory.competitiveCategory==CompetitionCategory.AMONG_CHEAPEST_CAN_COMPETE).filter(AmazonScrapingHistory.timestamp==timestamp).all()
     excel_integer_format = '0'
     integer_style = xlwt.XFStyle()
     integer_style.num_format_str = excel_integer_format
     writeheaders(sheet,heading_xf)
-    '''
-    sheet.write(0, 0, "Item Id", heading_xf)
-    sheet.write(0, 1, "Amazon Sku", heading_xf)
-    sheet.write(0, 2, "Asin", heading_xf)
-    sheet.write(0, 3, "Location", heading_xf)
-    sheet.write(0, 4, "Brand", heading_xf)
-    sheet.write(0, 5, "Product Name", heading_xf)
-    sheet.write(0, 6, "Weight", heading_xf)
-    sheet.write(0, 7, "Courier Cost", heading_xf)
-    sheet.write(0, 8, "Our SP", heading_xf)
-    sheet.write(0, 9, "Promo Price", heading_xf)
-    sheet.write(0, 10, "Is Promotion", heading_xf)
-    sheet.write(0, 11, "Lowest Possible SP", heading_xf)
-    sheet.write(0, 12, "Rank", heading_xf)
-    sheet.write(0, 13, "Our Inventory", heading_xf)
-    sheet.write(0, 14, "Lowest Seller SP", heading_xf)
-    sheet.write(0, 15, "Lowest Seller Rating", heading_xf)
-    sheet.write(0, 16, "Lowest Seller Shipping Time", heading_xf)
-    sheet.write(0, 17, "Second Lowest Seller SP", heading_xf)
-    sheet.write(0, 18, "Second Lowest Seller Rating", heading_xf)
-    sheet.write(0, 19, "Second Lowest Seller Shipping Time", heading_xf)
-    sheet.write(0, 20, "Third Lowest Seller SP", heading_xf)
-    sheet.write(0, 21, "Third Lowest Seller Rating", heading_xf)
-    sheet.write(0, 22, "Third Lowest Seller Shipping Time", heading_xf)
-    sheet.write(0, 23, "Other Cost", heading_xf)
-    sheet.write(0, 24, "WANLC", heading_xf)
-    sheet.write(0, 25, "Commission", heading_xf)
-    sheet.write(0, 26, "Competitor Commission", heading_xf)
-    sheet.write(0, 27, "Return Provision", heading_xf)
-    sheet.write(0, 28, "Vat Rate", heading_xf)
-    sheet.write(0, 29, "Margin", heading_xf)
-    sheet.write(0, 30, "Risky", heading_xf)
-    sheet.write(0, 31, "Proposed Sp", heading_xf)
-    sheet.write(0, 32, "Avg Sale", heading_xf)
-    sheet.write(0, 33, "Sales History", heading_xf)
-    '''
     sheet.write(0, 36, "Decision", heading_xf)
     sheet.write(0, 37, "Reason", heading_xf)
     sheet.write(0, 38, "Updated Price", heading_xf)
     sheet_iterator = 1
     cheapestItems = session.query(AmazonScrapingHistory,Item).join((Item,AmazonScrapingHistory.item_id==Item.id)).filter(AmazonScrapingHistory.competitiveCategory==CompetitionCategory.BUY_BOX).filter(AmazonScrapingHistory.timestamp==timestamp).all()
         sheet.write(sheet_iterator, 24, amScraping.otherCost)
         sheet.write(sheet_iterator, 25, amScraping.wanlc)
         sheet.write(sheet_iterator, 26, amScraping.subsidy)
         sheet.write(sheet_iterator, 27, amScraping.commission)
         sheet.write(sheet_iterator, 28, amScraping.competitorCommission)
-        sheet.write(sheet_iterator, 29, amScraping.vatRate)
+        sheet.write(sheet_iterator, 29, amScraping.returnProvision)
-        sheet.write(sheet_iterator, 30, amScraping.returnProvision)
+        sheet.write(sheet_iterator, 30, amScraping.vatRate)
         sheet.write(sheet_iterator, 31, getMargin(amScraping))
         sheet.write(sheet_iterator, 32, item.risky)
         sheet.write(sheet_iterator, 33, amScraping.proposedSp)
         sheet.write(sheet_iterator, 34, amScraping.avgSale)
         sheet.write(sheet_iterator, 35, getOosString(saleMap.get(sku)))
     filename = "/tmp/amazon-report-"+runType+" " + str(timestamp) + ".xls"
     wbk.save(filename)
     try:
         #EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["anikendra.das@saholic.com"], " Amazon Auto Pricing "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], [""], [])
-        EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["chandan.kumar@saholic.com","manoj.kumar@saholic.com","yukti.jain@saholic.com","ankush.dhingra@saholic.com","manoj.pal@saholic.com"], " Amazon Auto Pricing "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], ["rajneesh.arora@saholic.com","anikendra.das@saholic.com","vikram.raghav@saholic.com","kshitij.sood@saholic.com","chaitnaya.vats@saholic.com","khushal.bhatia@saholic.com"], [])
+        EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["chandan.kumar@saholic.com","manoj.kumar@saholic.com","yukti.jain@saholic.com","ankush.dhingra@saholic.com","manoj.pal@saholic.com"], " Amazon Auto Pricing "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], ["rajneesh.arora@saholic.com","anikendra.das@saholic.com","amit.gupta@saholic.com","kshitij.sood@saholic.com","chaitnaya.vats@saholic.com","khushal.bhatia@saholic.com"], [])
     except Exception as e:
         print e
         print "Unable to send report.Trying with local SMTP"
         smtpServer = smtplib.SMTP('localhost')
         smtpServer.set_debuglevel(1)
         sender = 'build@shop2020.in'
         #recipients = ["anikendra.das@saholic.com"]
         msg = MIMEMultipart()
         msg['Subject'] = "Amazon Auto Pricing" + ' '+runType+' - ' + str(datetime.now())
         msg['From'] = sender
-        recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
+        recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','amit.gupta@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
         msg['To'] = ",".join(recipients)
         fileMsg = email.mime.base.MIMEBase('application','vnd.ms-excel')
         fileMsg.set_payload(file(filename).read())
         email.encoders.encode_base64(fileMsg)
         fileMsg.add_header('Content-Disposition','attachment;filename=amazon-auto-pricing.xls')
             </tr></thead>
             <tbody>"""
     for item in successfulAutoDecrease:
         it = Item.query.filter_by(id=item.item_id).one()
         vatRate = getNewVatRate(item.item_id,item.warehouseLocation,item.proposedSp)
-        oldMargin = item.ourSellingPrice - item.lowestPossibleSp
+        #oldMargin = item.ourSellingPrice - item.lowestPossibleSp
+        oldMargin = item.promoPrice - item.lowestPossibleSp
         newMargin = round(item.proposedSp - getNewLowestPossibleSp(item,12.36,vatRate))
         sku = ''
         if item.warehouseLocation==1:
             sku='FBA'+str(item.item_id)
         else:
             subsidy = 0
         message+="""<tr>
                 <td style="text-align:center">"""+str(item.item_id)+"""</td>
                 <td style="text-align:center">"""+sku+"""</td>
                 <td style="text-align:center">"""+xstr(it.brand)+" "+xstr(it.model_name)+" "+xstr(it.model_number)+" "+xstr(it.color)+"""</td>
-                <td style="text-align:center">"""+str(item.ourSellingPrice)+"""</td>
+                <td style="text-align:center">"""+str(item.promoPrice)+"""</td>
                 <td style="text-align:center">"""+str(math.ceil(item.proposedSp))+"""</td>
                 <td style="text-align:center">"""+str(round(subsidy))+"""</td>
                 <td style="text-align:center">"""+str(round(oldMargin))+" ("+str(round((oldMargin/item.ourSellingPrice)*100,1))+"%)"+"""</td>
                 <td style="text-align:center">"""+str(newMargin)+" ("+str(round((newMargin/item.proposedSp)*100,1))+"%)"+"""</td>
                 <td style="text-align:center">"""+str(item.commission)+" %"+"""</td>
             </tr></thead>
             <tbody>"""
     for item in successfulAutoIncrease:
         it = Item.query.filter_by(id=item.item_id).one()
         vatRate = getNewVatRate(item.item_id,item.warehouseLocation,math.ceil(item.ourSellingPrice+max(10,.01*item.ourSellingPrice)))
-        oldMargin = item.ourSellingPrice - item.lowestPossibleSp
+        #oldMargin = item.ourSellingPrice - item.lowestPossibleSp
+        oldMargin = item.promoPrice - item.lowestPossibleSp
         newMargin = round(math.ceil(item.ourSellingPrice+max(10,.01*item.ourSellingPrice)) - getNewLowestPossibleSp(item,12.36,vatRate))
         sku = ''
         if item.warehouseLocation==1:
             sku='FBA'+str(item.item_id)
         else:
             subsidy = 0
         message+="""<tr>
                 <td style="text-align:center">"""+str(item.item_id)+"""</td>
                 <td style="text-align:center">"""+sku+"""</td>
                 <td style="text-align:center">"""+xstr(it.brand)+" "+xstr(it.model_name)+" "+xstr(it.model_number)+" "+xstr(it.color)+"""</td>
-                <td style="text-align:center">"""+str(item.ourSellingPrice)+"""</td>
+                <td style="text-align:center">"""+str(item.promoPrice)+"""</td>
                 <td style="text-align:center">"""+str(math.ceil(item.ourSellingPrice+max(10,.01*item.ourSellingPrice)))+"""</td>
                 <td style="text-align:center">"""+str(round(subsidy))+"""</td>
                 <td style="text-align:center">"""+str(round((oldMargin),1))+" ("+str(round((oldMargin/item.ourSellingPrice)*100,1))+"%)"+"""</td>
                 <td style="text-align:center">"""+str(newMargin)+" ("+str(round((newMargin/(item.ourSellingPrice+max(10,.01*item.ourSellingPrice)))*100,1))+"%)"+"""</td>
                 <td style="text-align:center">"""+str(item.commission)+" %"+"""</td>

Subversion Repositories SmartDukaan

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