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

 DataService.initialize(db_hostname=host)
 class __SnapdealInfo:
     def __init__(self, sellingPrice, weight, transferPrice, commission, commissionPercentage, courierCost, sellingPriceSnapdeal, transferPriceSnapdeal, fixedMargin, \
                  fixedMarginPercentage, collectionCharges, logisticCostSnapdeal, weightSnapdeal, supc, itemId, parentCategory, productGroup ,brand, modelName, modelNumber, \
-                 color):
+                 color,reason):
         self.sellingPrice = sellingPrice
         self.weight = weight
         self.transferPrice = transferPrice
         self.commission = commission
         self.parentCategory = parentCategory
         self.productGroup = productGroup
         self.brand = brand
         self.modelName = modelName
         self.modelNumber = modelNumber
         self.color = color
+        self.reason = reason
 def getBrowserObject():
     br = mechanize.Browser(factory=mechanize.RobustFactory())
     cj = cookielib.LWPCookieJar()
     dataform = str(response.read()).strip("'<>() ").replace('\'', '\"')
     struct = json.loads(dataform)
     sdObj = struct['rows'][0]
     print sdObj
     snapdealInfo = __SnapdealInfo(None,None,None,None,None,None,sdObj['sellingPrice'],sdObj['netSellerPayable'],sdObj['fixedMarginAmount'],sdObj['fixedMarginPercent'],sdObj['collectionCharges'],sdObj['logisticCost'],sdObj['deadWeight'],supc,None, \
-                    None, None, None, None, None, None)
+                    None, None, None, None, None, None, None)
     return snapdealInfo
 def filterData(fetchedItems):
     filterList = []
     for data in fetchedItems:
             <th>Snapdeal Commission %</th>
             <th>Our System Weight</th>
             <th>Snapdeal Weight</th>
             <th>Our Courier Cost</th>
             <th>Snapdeal Courier Charges</th>
+            <th>Reason</th>
             </tr></thead>
             <tbody>"""
     for data in filteredData:
         if data.transferPriceSnapdeal < data.transferPrice:
             message+="""<tr>
             <td style="text-align:center">"""+str(round(float(data.fixedMarginPercentage)/1.1236,2))+"%"+"""</td>
             <td style="text-align:center">"""+str(data.weight*1000)+" gms"+"""</td>
             <td style="text-align:center">"""+str(data.weightSnapdeal)+" gms"+"""</td>
             <td style="text-align:center">"""+str(round(data.courierCost*1.1236,2))+"""</td>
             <td style="text-align:center">"""+str(round(data.logisticCostSnapdeal,2))+"""</td>
+            <td style="text-align:center">"""+getReason(data)+"""</td>
             </tr>"""
     message+="""</tbody></table>"""
     message+="""
             <h3>High TP On Snapdeal</h3>
             <table border="1" style="width:100%;">
             <th>Snapdeal Commission %</th>
             <th>Our System Weight</th>
             <th>Snapdeal Weight</th>
             <th>Our Courier Cost</th>
             <th>Snapdeal Courier Charges</th>
+            <th>Reason</th>
             </tr></thead>
             <tbody>"""
     for data in filteredData:
         if data.transferPriceSnapdeal >= data.transferPrice:
             message+="""<tr>
             <td style="text-align:center">"""+str(round(float(data.fixedMarginPercentage)/1.1236,2))+"%"+"""</td>
             <td style="text-align:center">"""+str(data.weight*1000)+" gms"+"""</td>
             <td style="text-align:center">"""+str(data.weightSnapdeal)+" gms"+"""</td>
             <td style="text-align:center">"""+str(round(data.courierCost*1.1236,2))+"""</td>
             <td style="text-align:center">"""+str(round(data.logisticCostSnapdeal,2))+"""</td>
+            <td style="text-align:center">"""+getReason(data)+"""</td>
             </tr>"""
     message+="""</tbody></table>"""
     message+="""
             <h3>Unable To Fetch Items</h3>
             <table border="1" style="width:100%;">
     sheet.write(0, 13, "Snapdeal Commission %", heading_xf)
     sheet.write(0, 14, "Our System Weight (gms)", heading_xf)
     sheet.write(0, 15, "Snapdeal Weight", heading_xf)
     sheet.write(0, 16, "Our Courier Cost", heading_xf)
     sheet.write(0, 17, "Snapdeal Courier Cost", heading_xf)
+    sheet.write(0, 18, "Reason", heading_xf)
     sheet_iterator=1
     for data in filteredData:
         if data.transferPriceSnapdeal < data.transferPrice:
             sheet.write(sheet_iterator, 0, data.itemId)
             sheet.write(sheet_iterator, 13, round(float(data.fixedMarginPercentage)/1.1236,2))
             sheet.write(sheet_iterator, 14, data.weight*1000)
             sheet.write(sheet_iterator, 15, data.weightSnapdeal)
             sheet.write(sheet_iterator, 16, round(data.courierCost*1.1236,2))
             sheet.write(sheet_iterator, 17, round(data.logisticCostSnapdeal,2))
+            sheet.write(sheet_iterator, 18, getReason(data))
             sheet_iterator+=1
     sheet = wbk.add_sheet('High TP SD')
     heading_xf = xlwt.easyxf('font: bold on; align: wrap off, vert centre, horiz center')
     sheet.write(0, 13, "Snapdeal Commission %", heading_xf)
     sheet.write(0, 14, "Our System Weight (gms)", heading_xf)
     sheet.write(0, 15, "Snapdeal Weight", heading_xf)
     sheet.write(0, 16, "Our Courier Cost", heading_xf)
     sheet.write(0, 17, "Snapdeal Courier Cost", heading_xf)
+    sheet.write(0, 18, "Reason", heading_xf)
     sheet_iterator=1
     for data in filteredData:
         if data.transferPriceSnapdeal > data.transferPrice:
             sheet.write(sheet_iterator, 0, data.itemId)
             sheet.write(sheet_iterator, 13, round(float(data.fixedMarginPercentage)/1.1236,2))
             sheet.write(sheet_iterator, 14, data.weight*1000)
             sheet.write(sheet_iterator, 15, data.weightSnapdeal)
             sheet.write(sheet_iterator, 16, round(data.courierCost*1.1236,2))
             sheet.write(sheet_iterator, 17, round(data.logisticCostSnapdeal,2))
+            sheet.write(sheet_iterator, 18, getReason(data))
             sheet_iterator+=1
     sheet = wbk.add_sheet('Exceptions')
     heading_xf = xlwt.easyxf('font: bold on; align: wrap off, vert centre, horiz center')
         try:
             smtpServer.sendmail(sender, recipients, msg.as_string())
             print "Successfully sent email"
         except:
             print "Error: unable to send email."
+def getReason(data):
+    reason=""
+    if data.sellingPrice!=data.sellingPriceSnapdeal:
+        reason+="Selling Price is different."
+    if data.commission!= round(data.fixedMargin*1.1236,2):
+        reason+="Commission is different"
+    if round(data.courierCost)!=round(data.logisticCostSnapdeal):
+        reason+="Courier Cost is different-Check Weight."
+    return reason
 def main():
     print "Opening snapdeal seller login page"
     br = login("http://selleraccounts.snapdeal.com/")
     exceptionList, fetchedItems = populateStuff(br)

Subversion Repositories SmartDukaan

(root)/trunk/PyProj/src/shop2020/model/v1/catalog/script/SnapdealReconciliation.py – Rev 10420 → 10428