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

 from elixir import *
 from sqlalchemy.sql import or_ ,func, asc
 from shop2020.config.client.ConfigClient import ConfigClient
 from shop2020.model.v1.catalog.impl import DataService
 from shop2020.model.v1.catalog.impl.DataService import SnapdealItem, MarketplaceItems, Item, \
-Category, SourcePercentageMaster, MarketPlaceHistory, MarketPlaceUpdateHistory, MarketPlaceItemPrice
+Category, SourcePercentageMaster, MarketPlaceHistory, MarketPlaceUpdateHistory, MarketPlaceItemPrice, \
+SourceCategoryPercentage, SourceItemPercentage
 from shop2020.thriftpy.model.v1.order.ttypes import OrderSource
 from shop2020.thriftpy.model.v1.catalog.ttypes import CompetitionCategory, CompetitionBasis, SalesPotential,\
 Decision, RunType
 from shop2020.clients.CatalogClient import CatalogClient
 from shop2020.clients.InventoryClient import InventoryClient
 import smtplib
 from email.mime.text import MIMEText
 import email
 from email.mime.multipart import MIMEMultipart
 import email.encoders
-import urllib2
 import mechanize
 import cookielib
 config_client = ConfigClient()
         self.secondLowestSellerInventory = secondLowestSellerInventory
         self.totalSeller = totalSeller
 class __SnapdealItemInfo:
-    def __init__(self, supc, nlc, courierCost, item_id, product_group, brand, model_name, model_number, color, weight, parent_category, risky, warehouseId, vatRate, runType, parent_category_name):
+    def __init__(self, supc, nlc, courierCost, item_id, product_group, brand, model_name, model_number, color, weight, parent_category, risky, warehouseId, vatRate, runType, parent_category_name, sourcePercentage):
         self.supc = supc
         self.nlc = nlc
         self.courierCost = courierCost
         self.item_id = item_id
         self.product_group = product_group
         self.risky = risky
         self.warehouseId = warehouseId
         self.vatRate = vatRate
         self.runType = runType
         self.parent_category_name = parent_category_name
+        self.sourcePercentage = sourcePercentage
 class __SnapdealPricing:
     def __init__(self, ourSp, ourTp, lowestTp, lowestPossibleTp, competitionBasis, secondLowestSellerTp, lowestPossibleSp):
         self.ourTp = ourTp
         iterator+=1
     snapdealDetails = __SnapdealDetails(ourSp,ourInventory,otherInventory,rank,lowestSellerName, lowestSellerCode,lowestSp,secondLowestSellerName,secondLowestSellerCode,secondLowestSellerSp,secondLowestSellerInventory,lowestOfferPrice,secondLowestSellerOfferPrice,ourOfferPrice,len(vendorInfo))
     return snapdealDetails
-def populateStuff(runType):
+def populateStuff(runType,time):
     itemInfo = []
     if runType=='FAVOURITE':
         items = session.query(SnapdealItem).join((MarketplaceItems,SnapdealItem.item_id==MarketplaceItems.itemId)).filter(MarketplaceItems.source==OrderSource.SNAPDEAL).\
         filter(or_(MarketplaceItems.autoFavourite==True, MarketplaceItems.manualFavourite==True)).all()
     else:
         items = session.query(SnapdealItem).all()
-    spm = SourcePercentageMaster.get_by(source=OrderSource.SNAPDEAL)
+    #spm = SourcePercentageMaster.get_by(source=OrderSource.SNAPDEAL)
     for snapdeal_item in items:
         it = Item.query.filter_by(id=snapdeal_item.item_id).one()
         category = Category.query.filter_by(id=it.category).one()
         parent_category = Category.query.filter_by(id=category.parent_category_id).first()
+        sip = SourceItemPercentage.query.filter(SourceItemPercentage.item_id==itemId).filter(SourceItemPercentage.source==OrderSource.SNAPDEAL).filter(SourceItemPercentage.startDate<=time).filter(SourceItemPercentage.expiryDate>=time).first()
+        sourcePercentage = None
+        if sip is not None:
+            sourcePercentage = sip
+        else:
+            scp = SourceCategoryPercentage.query.filter(SourceCategoryPercentage.category_id==it.category).filter(SourceCategoryPercentage.source==OrderSource.SNAPDEAL).filter(SourceCategoryPercentage.startDate<=time).filter(SourceCategoryPercentage.expiryDate>=time).first()
+            if scp is not None:
+                sourcePercentage = scp
+            else:
+                spm = SourcePercentageMaster.get_by(source=OrderSource.SNAPDEAL)
+                sourcePercentage = spm
-        snapdealItemInfo = __SnapdealItemInfo(snapdeal_item.supc, snapdeal_item.maxNlc,snapdeal_item.courierCost, it.id, it.product_group, it.brand, it.model_name, it.model_number, it.color, it.weight, category.parent_category_id, it.risky, snapdeal_item.warehouseId, None, runType, parent_category.display_name)
+        snapdealItemInfo = __SnapdealItemInfo(snapdeal_item.supc, snapdeal_item.maxNlc,snapdeal_item.courierCost, it.id, it.product_group, it.brand, it.model_name, it.model_number, it.color, it.weight, category.parent_category_id, it.risky, snapdeal_item.warehouseId, None, runType, parent_category.display_name,sourcePercentage)
         itemInfo.append(snapdealItemInfo)
-    return itemInfo, spm
+    return itemInfo
-def decideCategory(itemInfo,spm):
+def decideCategory(itemInfo):
     global itemSaleMap
     cantCompete, buyBoxItems, competitive, competitiveNoInventory, exceptionItems, negativeMargin = [],[],[],[],[],[]
     catalog_client = CatalogClient().get_client()
     inventory_client = InventoryClient().get_client()
     for val in itemInfo:
+        spm = itemInfo.sourcePercentage
         try:
             snapdealDetails = fetchDetails(val.supc)
         except:
             exceptionItems.append(val)
             continue
             proposed_sp = snapdealDetails.lowestSp - max(10, snapdealDetails.lowestSp*0.001)
             proposed_tp = getTargetTp(proposed_sp,mpItem)
             target_nlc = proposed_tp - snapdealPricing.lowestPossibleTp + snapdealItemInfo.nlc
         else:
             proposed_tp  = snapdealPricing.lowestTp - max(10, snapdealPricing.lowestTp*0.001)
-            proposed_sp = getTargetSp(proposed_tp,mpItem)
+            proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
             target_nlc = proposed_tp - snapdealPricing.lowestPossibleTp + snapdealItemInfo.nlc
         sheet.write(sheet_iterator, 26, round(proposed_tp,2))
         sheet.write(sheet_iterator, 27, round(proposed_sp,2))
         sheet.write(sheet_iterator, 28, round(target_nlc,2))
         sheet.write(sheet_iterator, 29, getSalesPotential(snapdealDetails.lowestOfferPrice,snapdealItemInfo.nlc))
             proposed_sp = max(snapdealDetails.secondLowestSellerSp - max((20, snapdealDetails.secondLowestSellerSp*0.002)), snapdealPricing.lowestPossibleSp)
             proposed_tp = getTargetTp(proposed_sp,mpItem)
             #target_nlc = proposed_tp - snapdealPricing.lowestPossibleTp + snapdealItemInfo.nlc
         else:
             proposed_tp  = max(snapdealPricing.secondLowestSellerTp - max((20, snapdealPricing.secondLowestSellerTp*0.002)), snapdealPricing.lowestPossibleTp)
-            proposed_sp = getTargetSp(proposed_tp,mpItem)
+            proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
             #target_nlc = proposed_tp - snapdealPricing.lowestPossibleTp + snapdealItemInfo.nlc
         sheet.write(sheet_iterator, 25, round(proposed_tp,2))
         sheet.write(sheet_iterator, 26, round(proposed_sp,2))
         sheet.write(sheet_iterator, 27, round((proposed_tp - snapdealPricing.ourTp),2))
         sheet_iterator+=1
         if (snapdealPricing.competitionBasis=='SP'):
             proposed_sp = max(snapdealDetails.lowestSp - max((10, snapdealDetails.lowestSp*0.001)), snapdealPricing.lowestPossibleSp)
             proposed_tp = getTargetTp(proposed_sp,mpItem)
         else:
             proposed_tp  = max(snapdealPricing.lowestTp - max((10, snapdealPricing.lowestTp*0.001)), snapdealPricing.lowestPossibleTp)
-            proposed_sp = getTargetSp(proposed_tp,mpItem)
+            proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
         sheet.write(sheet_iterator, 26, round(proposed_tp,2))
         sheet.write(sheet_iterator, 27, round(proposed_sp,2))
         sheet.write(sheet_iterator, 28, getSalesPotential(snapdealDetails.lowestOfferPrice,snapdealItemInfo.nlc))
         sheet_iterator+=1
                 proposed_sp = snapdealDetails.lowestSp - max(10, snapdealDetails.lowestSp*0.001)
                 proposed_tp = getTargetTp(proposed_sp,mpItem)
                 target_nlc = proposed_tp - snapdealPricing.lowestPossibleTp + snapdealItemInfo.nlc
             else:
                 proposed_tp  = snapdealPricing.lowestTp - max(10, snapdealPricing.lowestTp*0.001)
-                proposed_sp = getTargetSp(proposed_tp,mpItem)
+                proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
                 target_nlc = proposed_tp - snapdealPricing.lowestPossibleTp + snapdealItemInfo.nlc
             sheet.write(sheet_iterator, 26, round(proposed_tp,2))
             sheet.write(sheet_iterator, 27, round(proposed_sp,2))
             sheet.write(sheet_iterator, 28, round(target_nlc,2))
             sheet.write(sheet_iterator, 29, getSalesPotential(snapdealDetails.lowestOfferPrice,snapdealItemInfo.nlc))
                 proposed_sp = snapdealDetails.lowestSp - max(10, snapdealDetails.lowestSp*0.001)
                 proposed_tp = getTargetTp(proposed_sp,mpItem)
                 target_nlc = proposed_tp - snapdealPricing.lowestPossibleTp + snapdealItemInfo.nlc
             else:
                 proposed_tp  = snapdealPricing.lowestTp - max(10, snapdealPricing.lowestTp*0.001)
-                proposed_sp = getTargetSp(proposed_tp,mpItem)
+                proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
                 target_nlc = proposed_tp - snapdealPricing.lowestPossibleTp + snapdealItemInfo.nlc
             sheet.write(sheet_iterator, 26, round(proposed_tp,2))
             sheet.write(sheet_iterator, 27, round(proposed_sp,2))
             sheet.write(sheet_iterator, 28, round(target_nlc,2))
             sheet.write(sheet_iterator, 29, getSalesPotential(snapdealDetails.lowestOfferPrice,snapdealItemInfo.nlc))
         sheet_iterator+=1
     filename = "/tmp/snapdeal-report-"+runType+" " + str(timestamp) + ".xls"
     wbk.save(filename)
     try:
-        #EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["kshitij.sood@saholic.com"], " Snapdeal Auto Pricing "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], [""], [])
+        EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["kshitij.sood@saholic.com"], " Snapdeal 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"], " Snapdeal Auto Pricing "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], ["rajneesh.arora@saholic.com","rajveer.singh@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"], " Snapdeal Auto Pricing "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], ["rajneesh.arora@saholic.com","rajveer.singh@saholic.com","vikram.raghav@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 = 'support@shop2020.in'
-        #recipients = ['kshitij.sood@saholic.com']
+        recipients = ['kshitij.sood@saholic.com']
         msg = MIMEMultipart()
         msg['Subject'] = "Snapdeal Auto Pricing" + ' - ' + str(datetime.now())
         msg['From'] = sender
-        recipients = ['rajneesh.arora@saholic.com','rajveer.singh@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','rajveer.singh@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']
         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=snapdeal.xls')
             proposed_tp = getTargetTp(proposed_sp,mpItem)
             mpHistory.proposedSellingPrice = round(proposed_sp,2)
             mpHistory.proposedTp = round(proposed_tp,2)
         else:
             proposed_tp  = max(snapdealPricing.lowestTp - max((10, snapdealPricing.lowestTp*0.001)), snapdealPricing.lowestPossibleTp)
-            proposed_sp = getTargetSp(proposed_tp,mpItem)
+            proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
             mpHistory.proposedSellingPrice = round(proposed_sp,2)
             mpHistory.proposedTp = round(proposed_tp,2)
         mpHistory.margin = mpHistory.ourTp - mpHistory.lowestPossibleTp
         mpHistory.totalSeller = snapdealDetails.totalSeller
         mpHistory.avgSales = (itemSaleMap.get(snapdealItemInfo.item_id))[2]
             proposed_tp = getTargetTp(proposed_sp,mpItem)
             mpHistory.proposedSellingPrice = round(proposed_sp,2)
             mpHistory.proposedTp = round(proposed_tp,2)
         else:
             proposed_tp  = max(snapdealPricing.lowestTp - max((10, snapdealPricing.lowestTp*0.001)), snapdealPricing.lowestPossibleTp)
-            proposed_sp = getTargetSp(proposed_tp,mpItem)
+            proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
             mpHistory.proposedSellingPrice = round(proposed_sp,2)
             mpHistory.proposedTp = round(proposed_tp,2)
         mpHistory.margin = mpHistory.ourTp - mpHistory.lowestPossibleTp
         mpHistory.totalSeller = snapdealDetails.totalSeller
         mpHistory.avgSales = (itemSaleMap.get(snapdealItemInfo.item_id))[2]
             mpHistory.proposedSellingPrice = round(proposed_sp,2)
             mpHistory.proposedTp = round(proposed_tp,2)
             mpHistory.targetNlc = round(target_nlc,2)
         else:
             proposed_tp  = snapdealPricing.lowestTp - max(10, snapdealPricing.lowestTp*0.001)
-            proposed_sp = getTargetSp(proposed_tp,mpItem)
+            proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
             target_nlc = proposed_tp - snapdealPricing.lowestPossibleTp + snapdealItemInfo.nlc
             mpHistory.proposedSellingPrice = round(proposed_sp,2)
             mpHistory.proposedTp = round(proposed_tp,2)
             mpHistory.targetNlc = round(target_nlc,2)
         mpHistory.margin = mpHistory.ourTp - mpHistory.lowestPossibleTp
             mpHistory.proposedSellingPrice = round(proposed_sp,2)
             mpHistory.proposedTp = round(proposed_tp,2)
             #mpHistory.targetNlc = target_nlc
         else:
             proposed_tp  = max(snapdealPricing.secondLowestSellerTp - max((20, snapdealPricing.secondLowestSellerTp*0.002)), snapdealPricing.lowestPossibleTp)
-            proposed_sp = getTargetSp(proposed_tp,mpItem)
+            proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
             #target_nlc = proposed_tp - snapdealPricing.lowestPossibleTp + snapdealItemInfo.nlc
             mpHistory.proposedSellingPrice = round(proposed_sp,2)
             mpHistory.proposedTp = round(proposed_tp,2)
             #mpHistory.targetNlc = target_nlc
         mpHistory.margin = mpHistory.ourTp - mpHistory.lowestPossibleTp
     mailServer = smtplib.SMTP("smtp.gmail.com", 587)
     mailServer.ehlo()
     mailServer.starttls()
     mailServer.ehlo()
-    #recipients = ['kshitij.sood@saholic.com']
+    recipients = ['kshitij.sood@saholic.com']
-    recipients = ['rajneesh.arora@saholic.com','rajveer.singh@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','rajveer.singh@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']
     msg = MIMEMultipart()
     msg['Subject'] = "Snapdeal Auto Pricing" + ' - ' + str(datetime.now())
     msg['From'] = ""
     msg['To'] = ",".join(recipients)
     msg.preamble = "Snapdeal Auto Pricing" + ' - ' + str(datetime.now())
     if val.parent_category==10011:
         commissionPercentage = spm.competitorCommissionAccessory
     else:
         commissionPercentage = spm.competitorCommissionOther
     if snapdealDetails.rank==1:
-        otherTp = snapdealDetails.secondLowestSellerSp- snapdealDetails.secondLowestSellerSp*(commissionPercentage/100+spm.emiFee/100)*(1+(spm.serviceTax/100))-(val.courierCost+spm.closingFee)*(1+(spm.serviceTax/100));
+        otherTp = snapdealDetails.secondLowestSellerSp- snapdealDetails.secondLowestSellerSp*(commissionPercentage/100+spm.emiFee/100)*(1+(spm.serviceTax/100))-(val.courierCost+spm.closingFee)*(1+(spm.serviceTax/100))-(max(20,(spm.pgFee/100)*snapdealDetails.secondLowestSellerSp)*(1+(spm.serviceTax/100)));
         return round(otherTp,2)
-    otherTp = snapdealDetails.lowestSp- snapdealDetails.lowestSp*(commissionPercentage/100+spm.emiFee/100)*(1+(spm.serviceTax/100))-(val.courierCost+spm.closingFee)*(1+(spm.serviceTax/100));
+    otherTp = snapdealDetails.lowestSp- snapdealDetails.lowestSp*(commissionPercentage/100+spm.emiFee/100)*(1+(spm.serviceTax/100))-(val.courierCost+spm.closingFee)*(1+(spm.serviceTax/100))-(max(20,(spm.pgFee/100)*snapdealDetails.lowestSp)*(1+(spm.serviceTax/100)));
     return round(otherTp,2)
 def getLowestPossibleTp(snapdealDetails,val,spm,mpItem):
     if snapdealDetails.rank==0:
         return mpItem.minimumPossibleTp
     return round(lowest_possible_tp,2)
 def getOurTp(snapdealDetails,val,spm,mpItem):
     if snapdealDetails.rank==0:
         return mpItem.currentTp
-    ourTp = snapdealDetails.ourSp- snapdealDetails.ourSp*(mpItem.commission/100+mpItem.emiFee/100)*(1+(mpItem.serviceTax/100))-(val.courierCost+mpItem.closingFee)*(1+(mpItem.serviceTax/100));
+    ourTp = snapdealDetails.ourSp- snapdealDetails.ourSp*(mpItem.commission/100+mpItem.emiFee/100)*(1+(mpItem.serviceTax/100))-(val.courierCost+mpItem.closingFee)*(1+(mpItem.serviceTax/100))-(max(20,(spm.pgFee/100)*snapdealDetails.ourSp)*(1+(spm.serviceTax/100)));
     return round(ourTp,2)
 def getNewLowestPossibleTp(mpItem,nlc,vatRate,proposedSellingPrice):
     vat = (proposedSellingPrice/(1+(vatRate/100))-(nlc/(1+(vatRate/100))))*(vatRate/100);
     inHouseCost = 15+vat+(mpItem.returnProvision/100)*proposedSellingPrice+mpItem.otherCost;
     lowest_possible_tp = nlc+inHouseCost;
     return round(lowest_possible_tp,2)
 def getNewOurTp(mpItem,proposedSellingPrice):
-    ourTp = proposedSellingPrice- proposedSellingPrice*(mpItem.commission/100+mpItem.emiFee/100)*(1+(mpItem.serviceTax/100))-(mpItem.courierCost+mpItem.closingFee)*(1+(mpItem.serviceTax/100));
+    ourTp = proposedSellingPrice- proposedSellingPrice*(mpItem.commission/100+mpItem.emiFee/100)*(1+(mpItem.serviceTax/100))-(mpItem.courierCost+mpItem.closingFee)*(1+(mpItem.serviceTax/100))-(max(20,(mpItem.pgFee/100)*proposedSellingPrice)*(1+(mpItem.serviceTax/100)));
     return round(ourTp,2)
 def getNewLowestPossibleSp(mpItem,nlc,vatRate):
+    if (mpItem.pgFee/100)*mpItem.ourSp>=20:
-    lowestPossibleSp = (nlc+(mpItem.courierCost+mpItem.closingFee)*(1+(mpItem.serviceTax/100))*(1+(vatRate/100))+(15+mpItem.otherCost)*(1+(vatRate)/100))/(1-(mpItem.commission/100+mpItem.emiFee/100)*(1+(mpItem.serviceTax/100))*(1+(vatRate)/100)-(mpItem.returnProvision/100)*(1+(vatRate)/100));
+        lowestPossibleSp = (nlc+(mpItem.courierCost+mpItem.closingFee)*(1+(mpItem.serviceTax/100))*(1+(vatRate/100))+(15+mpItem.otherCost)*(1+(vatRate)/100))/(1-(mpItem.commission/100+mpItem.emiFee/100+mpItem.pgFee/100)*(1+(mpItem.serviceTax/100))*(1+(vatRate)/100)-(mpItem.returnProvision/100)*(1+(vatRate)/100));
+    else:
+        lowestPossibleSp = (nlc+(mpItem.courierCost+mpItem.closingFee+20)*(1+(mpItem.serviceTax/100))*(1+(vatRate/100))+(15+mpItem.otherCost)*(1+(vatRate)/100))/(1-(mpItem.commission/100+mpItem.emiFee/100)*(1+(mpItem.serviceTax/100))*(1+(vatRate)/100)-(mpItem.returnProvision/100)*(1+(vatRate)/100));
     return round(lowestPossibleSp,2)
 def getLowestPossibleSp(snapdealDetails,val,spm,mpItem):
     if snapdealDetails.rank==0:
         return mpItem.minimumPossibleSp
-    lowestPossibleSp = (val.nlc+(val.courierCost+mpItem.closingFee)*(1+(mpItem.serviceTax/100))*(1+(val.vatRate/100))+(15+mpItem.otherCost)*(1+(val.vatRate)/100))/(1-(mpItem.commission/100+mpItem.emiFee/100)*(1+(mpItem.serviceTax/100))*(1+(val.vatRate)/100)-(mpItem.returnProvision/100)*(1+(val.vatRate)/100));
+    #lowestPossibleSp = (val.nlc+(val.courierCost+mpItem.closingFee)*(1+(mpItem.serviceTax/100))*(1+(val.vatRate/100))+(15+mpItem.otherCost)*(1+(val.vatRate)/100))/(1-(mpItem.commission/100+mpItem.emiFee/100)*(1+(mpItem.serviceTax/100))*(1+(val.vatRate)/100)-(mpItem.returnProvision/100)*(1+(val.vatRate)/100));
+    if (mpItem.pgFee/100)*snapdealDetails.ourSp>=20:
+        lowestPossibleSp = (val.nlc+(val.courierCost+mpItem.closingFee)*(1+(mpItem.serviceTax/100))*(1+(mpItem.vat/100))+(15+mpItem.otherCost)*(1+(mpItem.vat)/100))/(1-(mpItem.commission/100+mpItem.emiFee/100+mpItem.pgFee/100)*(1+(mpItem.serviceTax/100))*(1+(mpItem.vat)/100)-(mpItem.returnProvision/100)*(1+(mpItem.vat)/100))
+    else:
+        lowestPossibleSp = (val.nlc+(val.courierCost+mpItem.closingFee+20)*(1+(mpItem.serviceTax/100))*(1+(mpItem.vat/100))+(15+mpItem.otherCost)*(1+(mpItem.vat)/100))/(1-(mpItem.commission/100+mpItem.emiFee/100)*(1+(mpItem.serviceTax/100))*(1+(mpItem.vat)/100)-(mpItem.returnProvision/100)*(1+(mpItem.vat)/100))
     return round(lowestPossibleSp,2)
 def getTargetTp(targetSp,mpItem):
-    targetTp = targetSp- targetSp*(mpItem.commission/100+mpItem.emiFee/100)*(1+(mpItem.serviceTax/100))-(mpItem.courierCost+mpItem.closingFee)*(1+(mpItem.serviceTax/100));
+    targetTp = targetSp- targetSp*(mpItem.commission/100+mpItem.emiFee/100)*(1+(mpItem.serviceTax/100))-(mpItem.courierCost+mpItem.closingFee)*(1+(mpItem.serviceTax/100))-(max(20,(mpItem.pgFee/100)*targetSp)*(1+(mpItem.serviceTax/100)))
     return round(targetTp,2)
-def getTargetSp(targetTp,mpItem):
+def getTargetSp(targetTp,mpItem,ourSp):
+    if ourSp.pgFee/100 < 20:
-    targetSp = float(targetTp+(mpItem.courierCost+mpItem.closingFee)*(1+(mpItem.serviceTax/100)))/(1-((mpItem.commission/100+mpItem.emiFee/100)*(1+(mpItem.serviceTax/100))))
+        targetSp = float(targetTp+(mpItem.courierCost+mpItem.closingFee+20)*(1+(mpItem.serviceTax/100)))/(1-((mpItem.commission/100+mpItem.emiFee/100)*(1+(mpItem.serviceTax/100))))
+    else:
+        targetSp = float(targetTp+(mpItem.courierCost+mpItem.closingFee)*(1+(mpItem.serviceTax/100)))/(1-((mpItem.commission/100+mpItem.emiFee/100+mpItem.pgFee/100)*(1+(mpItem.serviceTax/100))))
     return round(targetSp,2)
 def getSalesPotential(lowestOfferPrice,ourNlc):
     if lowestOfferPrice - ourNlc < 0:
         return 'HIGH'
                    help="Run type FULL or FAVOURITE")
     (options, args) = parser.parse_args()
     if options.runType not in ('FULL','FAVOURITE'):
         print "Run type argument illegal."
         sys.exit(1)
-    itemInfo,spm= populateStuff(options.runType)
-    cantCompete, buyBoxItems, competitive, \
-    competitiveNoInventory, exceptionList, negativeMargin = decideCategory(itemInfo,spm)
     timestamp = datetime.now()
+    itemInfo= populateStuff(options.runType,timestamp)
+    cantCompete, buyBoxItems, competitive, \
+    competitiveNoInventory, exceptionList, negativeMargin = decideCategory(itemInfo)
     previousProcessingTimestamp = session.query(func.max(MarketPlaceHistory.timestamp)).filter(MarketPlaceHistory.source==7).one()
     exceptionItems = commitExceptionList(exceptionList,timestamp)
     cantComepeteItems = commitCantCompete(cantCompete,timestamp)
     buyBoxList = commitBuyBox(buyBoxItems,timestamp)
     competitiveItems = commitCompetitive(competitive,timestamp)
         previousAutoFav, nowAutoFav = markAutoFavourite()
     if options.runType=='FULL':
         writeReport(cantCompete, buyBoxItems, competitive, competitiveNoInventory, exceptionList, negativeMargin, previousAutoFav, nowAutoFav,timestamp, options.runType)
     else:
         writeReport(cantCompete, buyBoxItems, competitive, competitiveNoInventory, exceptionList, negativeMargin, None, None, timestamp, options.runType)
-    commitPricing(successfulAutoDecrease,successfulAutoIncrease,timestamp)
+    #commitPricing(successfulAutoDecrease,successfulAutoIncrease,timestamp)
     sendAutoPricingMail(successfulAutoDecrease,successfulAutoIncrease)
     processLostBuyBoxItems(previousProcessingTimestamp[0],timestamp)
-    updatePricesOnSnapdeal(successfulAutoDecrease,successfulAutoIncrease)
+    #updatePricesOnSnapdeal(successfulAutoDecrease,successfulAutoIncrease)
 if __name__ == '__main__':
     main()

Subversion Repositories SmartDukaan

(root)/trunk/PyProj/src/shop2020/model/v1/catalog/script/SnapdealHistoryPopulator.py – Rev 10286 → 10289