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

     sys.path.insert(0, os.getcwd())
 class _SnapdealItemInfo:
-    def __init__(self, item_id, product_group, category_name, our_nlc, brand, model_name, model_number, color, weight, parent_category, risky):
+    def __init__(self, item_id, product_group, category_name, our_nlc, brand, model_name, model_number, color, weight, parent_category, risky, issue):
         self.item_id = item_id
         self.product_group = product_group
         self.category_name = category_name
         self.our_nlc = our_nlc
         self.brand = brand
         self.model_number = model_number
         self.color = color
         self.weight = weight
         self.parent_category = parent_category
         self.risky = risky
+        self.issue = issue
 class SnapdealDetails:
     def __init__(self, supc, ourSp, offerPrice, ourInventory, otherInventory, rank, lowestSellerName,lowestSp,secondLowestSellerName,secondLowestSellerSp,secondLowestSellerInventory,lowestOfferPrice,secondLowestSellerOfferPrice,ourOfferPrice):
         self.supc = supc
         print sheet.row_values(rownum)
         item_id = int(sheet.row_values(rownum)[0])
         supc = sheet.row_values(rownum)[1]
         item = Item.query.filter_by(id=item_id).one()
         category = Category.query.filter_by(id=item.category).one()
-        parent_category = Category.query.filter_by(parent_category_id=category.parent_category_id).one()
+        parent_category = Category.query.filter_by(parent_category_id=category.parent_category_id).first()
+        try:
-        snapdeal_item = SnapdealItem.query.filter_by(item_id=item_id).one()
+            snapdeal_item = SnapdealItem.query.filter_by(item_id=item_id).one()
-        warehouse = iclient.getWarehouse(snapdeal_item.warehouseId)
+            warehouse = iclient.getWarehouse(snapdeal_item.warehouseId)
-        item_pricing = iclient.getItemPricing(item_id, warehouse.vendor.id)
+            item_pricing = iclient.getItemPricing(item_id, warehouse.vendor.id)
+            one_line = _SnapdealItemInfo(item.id, item.product_group, parent_category.display_name, item_pricing.nlc, item.brand, item.model_name, item.model_number, item.color, item.weight, category.parent_category_id, item.risky,"")
+        except Exception as e:
+            print "Problem with item id ",item_id
+            print e
+            one_line = _SnapdealItemInfo(item.id, item.product_group, parent_category.display_name, item_pricing.nlc, item.brand, item.model_name, item.model_number, item.color, item.weight, category.parent_category_id, item.risky,"our_side")
         #TO BE USED LATER
         #inventory_snapshot = iclient.getInventorySnapshot(0)
         #warehouses_ours = iclient.getWarehouses(WarehouseType._NAMES_TO_VALUES.get("OURS"), InventoryType._NAMES_TO_VALUES.get("GOOD"), 0,0,0)
         #warehouses_third_party = iclient.getWarehouses(WarehouseType._NAMES_TO_VALUES.get("THIRD_PARTY "), InventoryType._NAMES_TO_VALUES.get("GOOD"), 0,0,0)
-        one_line = _SnapdealItemInfo(item.id, item.product_group, parent_category.displayName, item_pricing.nlc, item.brand, item.model_name, item.model_number, item.color, item.weight, category.parent_category_id, item.risky)
         all_supc.append(supc)
         all_lines.append(one_line)
     write_report("/tmp/snapdeal_running.xls", all_lines, all_supc)
+def exception_sheet(items,wbk):
+    sheet = wbk.add_sheet('Exception Item List')
+    heading_xf = xlwt.easyxf('font: bold on; align: wrap off, vert centre, horiz center')
+    excel_integer_format = '0'
+    integer_style = xlwt.XFStyle()
+    integer_style.num_format_str = excel_integer_format
+    sheet.write(0, 0, "Item ID", heading_xf)
+    sheet.write(0, 1, "Problem Type", heading_xf)
+    i=1
+    for item in items:
+        sheet.write(i, 0, item.item_id)
+        if len(item.issue)!=0:
+            sheet.write(i, 0, "Either Snapdeal item is not present on our end or wrong warehouse Id")
+        else:
+            sheet.write(i, 1, "Unable to fetch info from snapdeal server")
+        i+=1
 def write_report(filename, all_lines, all_supc):
     buyBoxItems = []
     competitive = []
     competitiveNoInventory = []
+    exceptionItems = []
     wbk = xlwt.Workbook()
     sheet = wbk.add_sheet('Can\'t Compete')
     heading_xf = xlwt.easyxf('font: bold on; align: wrap off, vert centre, horiz center')
     sheet.write(0, 28, "Target NLC", heading_xf)
     sheet.write(0, 29, "Sales Potential", heading_xf)
     i, sheet_iterator=1,1
     for one_line in all_lines:
+        if len(one_line.issue)!=0:
+            exceptionItems.append(one_line)
+            i+=1
+            continue
         supc = all_supc[i-1]
+        try:
-        supc_data = fetchDetails(supc)
+            supc_data = fetchDetails(supc)
+        except Exception as e:
+            print "Unable to get information about SUPC Code: ",supc
+            exceptionItems.append(one_line)
+            i+=1
+            continue
         courierCost = 45
         if one_line.weight:
             slab = int(((one_line.weight+0.05) - .001)/.5)
         sheet_iterator+=1
     createSheetForBuyBoxItems(buyBoxItems,wbk)
     createSheetForCometitiveItems(competitive,wbk)
     createSheetForCometitiveItemsNoInventory(competitiveNoInventory,wbk)
+    exception_sheet(exceptionItems,wbk)
     wbk.save(filename)
     EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["kshitij.sood@shop2020.in"], " " , "", [get_attachment_part(filename)], ["kshitij.sood@shop2020.in"], [])

Subversion Repositories SmartDukaan

(root)/trunk/PyProj/src/shop2020/model/v1/catalog/script/Snapdeal.py – Rev 9411 → 9426