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

     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'
+        sender = 'build@shop2020.in'
         #recipients = ['kshitij.sood@saholic.com']
         msg = MIMEMultipart()
         msg['Subject'] = "Snapdeal Auto Pricing " +runType+" " + str(timestamp)
         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']
     except Exception as e:
         print e
         print "Unable to send pricing mail.Lets try with local SMTP."
         smtpServer = smtplib.SMTP('localhost')
         smtpServer.set_debuglevel(1)
-        sender = 'support@shop2020.in'
+        sender = 'build@shop2020.in'
         try:
             smtpServer.sendmail(sender, recipients, msg.as_string())
             print "Successfully sent email"
         except:
             print "Error: unable to send email."
     except Exception as e:
         print e
         print "Unable to send lost buy box mail.Lets try local SMTP"
         smtpServer = smtplib.SMTP('localhost')
         smtpServer.set_debuglevel(1)
-        sender = 'support@shop2020.in'
+        sender = 'build@shop2020.in'
         try:
             smtpServer.sendmail(sender, recipients, msg.as_string())
             print "Successfully sent email"
         except:
             print "Error: unable to send email."
                 latestItemData.toGroup=True
                 data.toGroup=False
         else:
             latestItemData=None
     session.commit()
+def sendAlertForNegativeMargins(timestamp):
+    xstr = lambda s: s or ""
+    negativeMargins = session.query(MarketPlaceHistory,Item).join((Item,MarketPlaceHistory.item_id==Item.id)).filter(MarketPlaceHistory.timestamp==timestamp).filter(MarketPlaceHistory.source==OrderSource.SNAPDEAL).filter(MarketPlaceHistory.competitiveCategory==CompetitionCategory.NEGATIVE_MARGIN).all()
+    if len(negativeMargins) == 0:
+        return
+    message="""<html>
+            <body>
+            <h3 style="color:red;font-weight:bold;">Snapdeal Negative Margins</h3>
+            <table border="1" style="width:100%;">
+            <thead>
+            <tr><th>Item Id</th>
+            <th>Product Name</th>
+            <th>SP</th>
+            <th>TP</th>
+            <th>Lowest Possible SP</th>
+            <th>Lowest Possible TP</th>
+            <th>Margin</th>
+            <th>Margin %</th>
+            <th>Flipkart Inventory</th>
+            <th>Total Inventory</th>
+            <th>Sales History</th>
+            </tr></thead>
+            <tbody>"""
+    for item in negativeMargins:
+        mpHistory = item[0]
+        catItem = item[1]
+        netInventory=''
+        if not inventoryMap.has_key(mpHistory.item_id):
+            netInventory='Info Not Available'
+        else:
+            netInventory = str(getNetAvailability(inventoryMap.get(mpHistory.item_id)))
+        message+="""<tr>
+            <td style="text-align:center">"""+str(mpHistory.item_id)+"""</td>
+            <td style="text-align:center">"""+xstr(catItem.brand)+" "+xstr(catItem.model_name)+" "+xstr(catItem.model_number)+" "+xstr(catItem.color)+"""</td>
+            <td style="text-align:center">"""+str(mpHistory.ourSellingPrice)+"""</td>
+            <td style="text-align:center">"""+str(mpHistory.ourTp)+"""</td>
+            <td style="text-align:center">"""+str(mpHistory.lowestPossibleSp)+"""</td>
+            <td style="text-align:center">"""+str(mpHistory.lowestPossibleTp)+"""</td>
+            <td style="text-align:center">"""+str(mpHistory.margin)+"""</td>
+            <td style="text-align:center">"""+str(round(mpHistory.margin/mpHistory.ourSellingPrice,2))+"""</td>
+            <td style="text-align:center">"""+str(mpHistory.ourInventory)+"""</td>
+            <td style="text-align:center">"""+netInventory+"""</td>
+            <td style="text-align:center">"""+getOosString((itemSaleMap.get(mpHistory.item_id))[1])+"""</td>
+            </tr>"""
+    message+="""</tbody></table></body></html>"""
+    print message
+    mailServer = smtplib.SMTP("smtp.gmail.com", 587)
+    mailServer.ehlo()
+    mailServer.starttls()
+    mailServer.ehlo()
+    #recipients = ['kshitij.sood@saholic.com']
+    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']
+    msg = MIMEMultipart()
+    msg['Subject'] = "Snapdeal Negative Margin" + ' - ' + str(datetime.now())
+    msg['From'] = ""
+    msg['To'] = ",".join(recipients)
+    msg.preamble = "Snapdeal Negative Margin" + ' - ' + str(datetime.now())
+    html_msg = MIMEText(message, 'html')
+    msg.attach(html_msg)
+    try:
+        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 Snapdeal Negative margin mail.Lets try local SMTP"
+        smtpServer = smtplib.SMTP('localhost')
+        smtpServer.set_debuglevel(1)
+        sender = 'build@shop2020.in'
+        try:
+            smtpServer.sendmail(sender, recipients, msg.as_string())
+            print "Successfully sent email"
+        except:
+            print "Error: unable to send email."
 def main():
     parser = optparse.OptionParser()
     parser.add_option("-t", "--type", dest="runType",
     successfulAutoIncrease = fetchItemsForAutoIncrease(timestamp)
     if options.runType=='FULL':
         previousAutoFav, nowAutoFav = markAutoFavourite()
     if options.runType=='FULL':
         writeReport(cantCompete, buyBoxItems, competitive, competitiveNoInventory, exceptionList, negativeMargin, previousAutoFav, nowAutoFav,timestamp, options.runType)
+        sendAlertForNegativeMargins(timestamp)
     else:
         writeReport(cantCompete, buyBoxItems, competitive, competitiveNoInventory, exceptionList, negativeMargin, None, None, timestamp, options.runType)
     commitPricing(successfulAutoDecrease,successfulAutoIncrease,timestamp)
     sendAutoPricingMail(successfulAutoDecrease,successfulAutoIncrease)
     processLostBuyBoxItems(previousProcessingTimestamp[0],timestamp)

Subversion Repositories SmartDukaan

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