| Line 91... |
Line 91... |
| 91 |
marketplaceItem = item[1]
|
91 |
marketplaceItem = item[1]
|
| 92 |
ds_item = item[2]
|
92 |
ds_item = item[2]
|
| 93 |
category = Category.query.filter_by(id=ds_item.category).one()
|
93 |
category = Category.query.filter_by(id=ds_item.category).one()
|
| 94 |
parent_category = Category.query.filter_by(id=category.parent_category_id).first()
|
94 |
parent_category = Category.query.filter_by(id=category.parent_category_id).first()
|
| 95 |
try:
|
95 |
try:
|
| 96 |
print "Inside try for fetch data"
|
- |
|
| 97 |
snapdealInfo = fetchData(br,snapdealItem.supc)
|
96 |
snapdealInfo = fetchData(br,snapdealItem.supc)
|
| 98 |
except Exception as e:
|
97 |
except Exception as e:
|
| 99 |
exceptionList.append(item)
|
98 |
exceptionList.append(item)
|
| 100 |
print "Unable to fetch details ",e
|
99 |
print "Unable to fetch details ",e
|
| 101 |
continue
|
100 |
continue
|
| Line 128... |
Line 127... |
| 128 |
return snapdealInfo
|
127 |
return snapdealInfo
|
| 129 |
|
128 |
|
| 130 |
def filterData(fetchedItems):
|
129 |
def filterData(fetchedItems):
|
| 131 |
filterList = []
|
130 |
filterList = []
|
| 132 |
for data in fetchedItems:
|
131 |
for data in fetchedItems:
|
| 133 |
print data.itemId
|
- |
|
| 134 |
print data.transferPrice
|
- |
|
| 135 |
print data.transferPriceSnapdeal
|
- |
|
| 136 |
if ( data.transferPrice - data.transferPriceSnapdeal >= -3 ) and (data.transferPrice - data.transferPriceSnapdeal <= 3):
|
132 |
if ( data.transferPrice - data.transferPriceSnapdeal >= -3 ) and (data.transferPrice - data.transferPriceSnapdeal <= 3):
|
| 137 |
continue
|
133 |
continue
|
| 138 |
filterList.append(data)
|
134 |
filterList.append(data)
|
| 139 |
return filterList
|
135 |
return filterList
|
| 140 |
|
136 |
|
| Line 271... |
Line 267... |
| 271 |
print e
|
267 |
print e
|
| 272 |
print "Unable to send Snapdeal TP Reconciliation mail.Lets try with local SMTP."
|
268 |
print "Unable to send Snapdeal TP Reconciliation mail.Lets try with local SMTP."
|
| 273 |
smtpServer = smtplib.SMTP('localhost')
|
269 |
smtpServer = smtplib.SMTP('localhost')
|
| 274 |
smtpServer.set_debuglevel(1)
|
270 |
smtpServer.set_debuglevel(1)
|
| 275 |
sender = 'support@shop2020.in'
|
271 |
sender = 'support@shop2020.in'
|
| 276 |
try:
|
272 |
try:
|
| 277 |
smtpServer.sendmail(sender, recipients, msg.as_string())
|
273 |
smtpServer.sendmail(sender, recipients, msg.as_string())
|
| 278 |
print "Successfully sent email"
|
274 |
print "Successfully sent email"
|
| 279 |
except:
|
275 |
except:
|
| 280 |
print "Error: unable to send email."
|
276 |
print "Error: unable to send email."
|
| 281 |
|
277 |
|
| 282 |
def write_report(filteredData,exceptionList):
|
278 |
def write_report(filteredData,exceptionList):
|
| 283 |
wbk = xlwt.Workbook()
|
279 |
wbk = xlwt.Workbook()
|
| 284 |
sheet = wbk.add_sheet('Low TP SD')
|
280 |
sheet = wbk.add_sheet('Low TP SD')
|
| 285 |
xstr = lambda s: s or ""
|
281 |
xstr = lambda s: s or ""
|
| Line 311... |
Line 307... |
| 311 |
sheet_iterator=1
|
307 |
sheet_iterator=1
|
| 312 |
for data in filteredData:
|
308 |
for data in filteredData:
|
| 313 |
if data.transferPriceSnapdeal < data.transferPrice:
|
309 |
if data.transferPriceSnapdeal < data.transferPrice:
|
| 314 |
sheet.write(sheet_iterator, 0, data.itemId)
|
310 |
sheet.write(sheet_iterator, 0, data.itemId)
|
| 315 |
sheet.write(sheet_iterator, 1, data.parentCategory)
|
311 |
sheet.write(sheet_iterator, 1, data.parentCategory)
|
| 316 |
sheet.write(sheet_iterator, 2, data.supc)
|
312 |
sheet.write(sheet_iterator, 2, data.productGroup)
|
| 317 |
sheet.write(sheet_iterator, 3, data.brand)
|
313 |
sheet.write(sheet_iterator, 3, data.supc)
|
| 318 |
sheet.write(sheet_iterator, 4, data.brand)
|
314 |
sheet.write(sheet_iterator, 4, data.brand)
|
| 319 |
sheet.write(sheet_iterator, 5, xstr(data.brand)+" "+xstr(data.modelName)+" "+xstr(data.modelNumber)+" "+xstr(data.color))
|
315 |
sheet.write(sheet_iterator, 5, xstr(data.brand)+" "+xstr(data.modelName)+" "+xstr(data.modelNumber)+" "+xstr(data.color))
|
| 320 |
sheet.write(sheet_iterator, 6, data.sellingPrice)
|
316 |
sheet.write(sheet_iterator, 6, data.sellingPrice)
|
| 321 |
sheet.write(sheet_iterator, 7, data.sellingPriceSnapdeal)
|
317 |
sheet.write(sheet_iterator, 7, data.sellingPriceSnapdeal)
|
| 322 |
sheet.write(sheet_iterator, 8, data.transferPrice)
|
318 |
sheet.write(sheet_iterator, 8, data.transferPrice)
|
| Line 362... |
Line 358... |
| 362 |
sheet_iterator=1
|
358 |
sheet_iterator=1
|
| 363 |
for data in filteredData:
|
359 |
for data in filteredData:
|
| 364 |
if data.transferPriceSnapdeal > data.transferPrice:
|
360 |
if data.transferPriceSnapdeal > data.transferPrice:
|
| 365 |
sheet.write(sheet_iterator, 0, data.itemId)
|
361 |
sheet.write(sheet_iterator, 0, data.itemId)
|
| 366 |
sheet.write(sheet_iterator, 1, data.parentCategory)
|
362 |
sheet.write(sheet_iterator, 1, data.parentCategory)
|
| 367 |
sheet.write(sheet_iterator, 2, data.supc)
|
363 |
sheet.write(sheet_iterator, 2, data.productGroup)
|
| 368 |
sheet.write(sheet_iterator, 3, data.brand)
|
364 |
sheet.write(sheet_iterator, 3, data.supc)
|
| 369 |
sheet.write(sheet_iterator, 4, data.brand)
|
365 |
sheet.write(sheet_iterator, 4, data.brand)
|
| 370 |
sheet.write(sheet_iterator, 5, xstr(data.brand)+" "+xstr(data.modelName)+" "+xstr(data.modelNumber)+" "+xstr(data.color))
|
366 |
sheet.write(sheet_iterator, 5, xstr(data.brand)+" "+xstr(data.modelName)+" "+xstr(data.modelNumber)+" "+xstr(data.color))
|
| 371 |
sheet.write(sheet_iterator, 6, data.sellingPrice)
|
367 |
sheet.write(sheet_iterator, 6, data.sellingPrice)
|
| 372 |
sheet.write(sheet_iterator, 7, data.sellingPriceSnapdeal)
|
368 |
sheet.write(sheet_iterator, 7, data.sellingPriceSnapdeal)
|
| 373 |
sheet.write(sheet_iterator, 8, data.transferPrice)
|
369 |
sheet.write(sheet_iterator, 8, data.transferPrice)
|