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

     sheet.write(0, 20, "Last Five Day Sale", heading_xf)
     sheet.write(0, 21, "Average Sale", heading_xf)
     sheet.write(0, 22, "Our NLC", heading_xf)
     sheet.write(0, 23, "Lowest Possible TP", heading_xf)
     sheet.write(0, 24, "Lowest Possible SP", heading_xf)
-    sheet.write(0, 25, "Competition Basis ", heading_xf)
+    sheet.write(0, 25, "Subsidy Difference", heading_xf)
     sheet.write(0, 26, "Target TP", heading_xf)
     sheet.write(0, 27, "Target SP", heading_xf)
     sheet.write(0, 28, "Target NLC", heading_xf)
     sheet.write(0, 29, "Sales Potential", heading_xf)
     sheet_iterator = 1
         sheet.write(sheet_iterator, 20, getOosString((itemSaleMap.get(snapdealItemInfo.item_id))[1]))
         sheet.write(sheet_iterator, 21, (itemSaleMap.get(snapdealItemInfo.item_id))[3])
         sheet.write(sheet_iterator, 22, snapdealItemInfo.nlc)
         sheet.write(sheet_iterator, 23, snapdealPricing.lowestPossibleTp)
         sheet.write(sheet_iterator, 24, snapdealPricing.lowestPossibleSp)
-        sheet.write(sheet_iterator, 25, snapdealPricing.competitionBasis)
+        sheet.write(sheet_iterator, 25, getSubsidyDiff(snapdealDetails))
         if (snapdealPricing.competitionBasis=='SP'):
             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_tp  = snapdealPricing.lowestTp - max(10, snapdealPricing.lowestTp*0.001)
-            proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
+            #proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
+            proposed_sp = snapdealDetails.lowestSp - max(10, snapdealDetails.lowestSp*0.001) - getSubsidyDiff(snapdealDetails)
+            proposed_tp = getTargetTp(proposed_sp,mpItem)
             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.write(0, 19, "Our Net Availability",heading_xf)
     sheet.write(0, 20, "Last Five Day Sale", heading_xf)
     sheet.write(0, 21, "Average Sale", heading_xf)
     sheet.write(0, 22, "Second Lowest Seller Inventory", heading_xf)
     sheet.write(0, 23, "Our NLC", heading_xf)
-    sheet.write(0, 24, "Competition Basis", heading_xf)
+    sheet.write(0, 24, "Subsidy Difference", heading_xf)
     sheet.write(0, 25, "Target TP", heading_xf)
     sheet.write(0, 26, "Target SP", heading_xf)
     sheet.write(0, 27, "MARGIN INCREASED POTENTIAL", heading_xf)
     sheet_iterator = 1
             sheet.write(sheet_iterator, 19, getNetAvailability(inventoryMap.get(snapdealItemInfo.item_id)))
         sheet.write(sheet_iterator, 20, getOosString((itemSaleMap.get(snapdealItemInfo.item_id))[1]))
         sheet.write(sheet_iterator, 21, (itemSaleMap.get(snapdealItemInfo.item_id))[3])
         sheet.write(sheet_iterator, 22, snapdealDetails.secondLowestSellerInventory)
         sheet.write(sheet_iterator, 23, snapdealItemInfo.nlc)
-        sheet.write(sheet_iterator, 24, snapdealPricing.competitionBasis)
+        sheet.write(sheet_iterator, 24, getSubsidyDiff(snapdealDetails))
         if (snapdealPricing.competitionBasis=='SP'):
             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_tp  = max(snapdealPricing.secondLowestSellerTp - max((20, snapdealPricing.secondLowestSellerTp*0.002)), snapdealPricing.lowestPossibleTp)
-            proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
+            #proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
+            proposed_sp = max(snapdealDetails.secondLowestSellerSp - max((20, snapdealDetails.secondLowestSellerSp*0.002)) -getSubsidyDiff(snapdealDetails), snapdealPricing.lowestPossibleSp)
+            proposed_tp = getTargetTp(proposed_sp,mpItem)
             #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
     sheet.write(0, 20, "Last Five Day Sale", heading_xf)
     sheet.write(0, 21, "Average Sale", heading_xf)
     sheet.write(0, 22, "Our NLC", heading_xf)
     sheet.write(0, 23, "Lowest Possible TP", heading_xf)
     sheet.write(0, 24, "Lowest Possible SP", heading_xf)
-    sheet.write(0, 25, "Competition Basis ", heading_xf)
+    sheet.write(0, 25, "Subsidy Difference", heading_xf)
     sheet.write(0, 26, "Target TP", heading_xf)
     sheet.write(0, 27, "Target SP", heading_xf)
     sheet.write(0, 28, "Sales Potential", heading_xf)
     sheet_iterator = 1
         sheet.write(sheet_iterator, 20, getOosString((itemSaleMap.get(snapdealItemInfo.item_id))[1]))
         sheet.write(sheet_iterator, 21, (itemSaleMap.get(snapdealItemInfo.item_id))[3])
         sheet.write(sheet_iterator, 22, snapdealItemInfo.nlc)
         sheet.write(sheet_iterator, 23, snapdealPricing.lowestPossibleTp)
         sheet.write(sheet_iterator, 24, snapdealPricing.lowestPossibleSp)
-        sheet.write(sheet_iterator, 25, snapdealPricing.competitionBasis)
+        sheet.write(sheet_iterator, 25, getSubsidyDiff(snapdealDetails))
         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_tp  = max(snapdealPricing.lowestTp - max((10, snapdealPricing.lowestTp*0.001)), snapdealPricing.lowestPossibleTp)
-            proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
+            #proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
+            proposed_sp = max(snapdealDetails.lowestSp - max((10, snapdealDetails.lowestSp*0.001)) -getSubsidyDiff(snapdealDetails), snapdealPricing.lowestPossibleSp)
+            proposed_tp = getTargetTp(proposed_sp,mpItem)
         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
     sheet.write(0, 20, "Last Five Day Sale", heading_xf)
     sheet.write(0, 21, "Average Sale", heading_xf)
     sheet.write(0, 22, "Our NLC", heading_xf)
     sheet.write(0, 23, "Lowest Possible TP", heading_xf)
     sheet.write(0, 24, "Lowest Possible SP", heading_xf)
-    sheet.write(0, 25, "Competition Basis ", heading_xf)
+    sheet.write(0, 25, "Subsidy Difference", heading_xf)
     sheet.write(0, 26, "Target TP", heading_xf)
     sheet.write(0, 27, "Target SP", heading_xf)
     sheet.write(0, 28, "Target NLC", heading_xf)
     sheet.write(0, 29, "Sales Potential", heading_xf)
             sheet.write(sheet_iterator, 20, getOosString((itemSaleMap.get(snapdealItemInfo.item_id))[1]))
             sheet.write(sheet_iterator, 21, (itemSaleMap.get(snapdealItemInfo.item_id))[3])
             sheet.write(sheet_iterator, 22, snapdealItemInfo.nlc)
             sheet.write(sheet_iterator, 23, snapdealPricing.lowestPossibleTp)
             sheet.write(sheet_iterator, 24, snapdealPricing.lowestPossibleSp)
-            sheet.write(sheet_iterator, 25, snapdealPricing.competitionBasis)
+            sheet.write(sheet_iterator, 25, getSubsidyDiff(snapdealDetails))
             if (snapdealPricing.competitionBasis=='SP'):
                 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_tp  = snapdealPricing.lowestTp - max(10, snapdealPricing.lowestTp*0.001)
-                proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
+                #proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
+                proposed_sp = snapdealDetails.lowestSp - max(10, snapdealDetails.lowestSp*0.001) -getSubsidyDiff(snapdealDetails)
+                proposed_tp = getTargetTp(proposed_sp,mpItem)
                 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.write(0, 20, "Last Five Day Sale", heading_xf)
     sheet.write(0, 21, "Average Sale", heading_xf)
     sheet.write(0, 22, "Our NLC", heading_xf)
     sheet.write(0, 23, "Lowest Possible TP", heading_xf)
     sheet.write(0, 24, "Lowest Possible SP", heading_xf)
-    sheet.write(0, 25, "Competition Basis ", heading_xf)
+    sheet.write(0, 25, "Subsidy Difference", heading_xf)
     sheet.write(0, 26, "Target TP", heading_xf)
     sheet.write(0, 27, "Target SP", heading_xf)
     sheet.write(0, 28, "Target NLC", heading_xf)
     sheet.write(0, 29, "Sales Potential", heading_xf)
             sheet.write(sheet_iterator, 20, getOosString((itemSaleMap.get(snapdealItemInfo.item_id))[1]))
             sheet.write(sheet_iterator, 21, (itemSaleMap.get(snapdealItemInfo.item_id))[3])
             sheet.write(sheet_iterator, 22, snapdealItemInfo.nlc)
             sheet.write(sheet_iterator, 23, snapdealPricing.lowestPossibleTp)
             sheet.write(sheet_iterator, 24, snapdealPricing.lowestPossibleSp)
-            sheet.write(sheet_iterator, 25, snapdealPricing.competitionBasis)
+            sheet.write(sheet_iterator, 25, getSubsidyDiff(snapdealDetails))
             if (snapdealPricing.competitionBasis=='SP'):
                 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_tp  = snapdealPricing.lowestTp - max(10, snapdealPricing.lowestTp*0.001)
-                proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
+                #proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
+                proposed_sp = snapdealDetails.lowestSp - max(10, snapdealDetails.lowestSp*0.001) -getSubsidyDiff(snapdealDetails)
+                proposed_tp = getTargetTp(proposed_sp,mpItem)
                 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.lowestSp - max((10, snapdealDetails.lowestSp*0.001)), snapdealPricing.lowestPossibleSp)
             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_tp  = max(snapdealPricing.lowestTp - max((10, snapdealPricing.lowestTp*0.001)), snapdealPricing.lowestPossibleTp)
-            proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
+            #proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
+            proposed_sp = max(snapdealDetails.lowestSp - max((10, snapdealDetails.lowestSp*0.001)) -getSubsidyDiff(snapdealDetails), snapdealPricing.lowestPossibleSp)
+            proposed_tp = getTargetTp(proposed_sp,mpItem)
             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_sp = max(snapdealDetails.lowestSp - max((10, snapdealDetails.lowestSp*0.001)), snapdealPricing.lowestPossibleSp)
             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_tp  = max(snapdealPricing.lowestTp - max((10, snapdealPricing.lowestTp*0.001)), snapdealPricing.lowestPossibleTp)
-            proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
+            #proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
+            proposed_sp = max(snapdealDetails.lowestSp - max((10, snapdealDetails.lowestSp*0.001)) -getSubsidyDiff(snapdealDetails), snapdealPricing.lowestPossibleSp)
+            proposed_tp = getTargetTp(proposed_sp,mpItem)
             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]
             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)
         else:
-            proposed_tp  = snapdealPricing.lowestTp - max(10, snapdealPricing.lowestTp*0.001)
+            #proposed_tp  = snapdealPricing.lowestTp - max(10, snapdealPricing.lowestTp*0.001)
-            proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
+            #proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
+            proposed_sp = snapdealDetails.lowestSp - max(10, snapdealDetails.lowestSp*0.001) -getSubsidyDiff(snapdealDetails)
+            proposed_tp = getTargetTp(proposed_sp,mpItem)
             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
             #target_nlc = proposed_tp - snapdealPricing.lowestPossibleTp + snapdealItemInfo.nlc
             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_tp  = max(snapdealPricing.secondLowestSellerTp - max((20, snapdealPricing.secondLowestSellerTp*0.002)), snapdealPricing.lowestPossibleTp)
-            proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
+            #proposed_sp = getTargetSp(proposed_tp,mpItem,snapdealPricing.ourSp)
+            proposed_sp = max(snapdealDetails.secondLowestSellerSp - max((20, snapdealDetails.secondLowestSellerSp*0.002)) -getSubsidyDiff(snapdealDetails), snapdealPricing.lowestPossibleSp)
+            proposed_tp = getTargetTp(proposed_sp,mpItem)
             #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.login("build@shop2020.in", "cafe@nes")
         #mailServer.sendmail("cafe@nes", ['kshitij.sood@saholic.com'], msg.as_string())
         mailServer.sendmail("cafe@nes", recipients, msg.as_string())
     except Exception as e:
         print e
-        print "Unable to send lost buy bix mail.Lets try local SMTP"
+        print "Unable to send lost buy box mail.Lets try local SMTP"
         smtpServer = smtplib.SMTP('localhost')
         smtpServer.set_debuglevel(1)
         sender = 'support@shop2020.in'
         try:
             smtpServer.sendmail(sender, recipients, msg.as_string())
             print "Successfully sent email"
         except:
             print "Error: unable to send email."
+def getSubsidyDiff(snapdealDetails):
+    ourSubsidy = snapdealDetails.ourSp - snapdealDetails.ourOfferPrice
+    if snapdealDetails.rank !=1:
+        competitionSubsidy = snapdealDetails.lowestSp - snapdealDetails.lowestOfferPrice
+    else:
+        competitionSubsidy = snapdealDetails.secondLowestSellerSp - snapdealDetails.secondLowestOfferPrice
+    return competitionSubsidy - ourSubsidy
 def getOtherTp(snapdealDetails,val,spm):
     if val.parent_category==10011:
         commissionPercentage = spm.competitorCommissionAccessory
     else:

Subversion Repositories SmartDukaan

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