| Line 1563... |
Line 1563... |
| 1563 |
sheet.write(0, 54, "Decision", heading_xf)
|
1563 |
sheet.write(0, 54, "Decision", heading_xf)
|
| 1564 |
sheet.write(0, 55, "Reason", heading_xf)
|
1564 |
sheet.write(0, 55, "Reason", heading_xf)
|
| 1565 |
sheet.write(0, 56, "Updated Price", heading_xf)
|
1565 |
sheet.write(0, 56, "Updated Price", heading_xf)
|
| 1566 |
sheet.write(0, 57, "Proposed Margin", heading_xf)
|
1566 |
sheet.write(0, 57, "Proposed Margin", heading_xf)
|
| 1567 |
sheet.write(0, 58, "Inventory Movement Status", heading_xf)
|
1567 |
sheet.write(0, 58, "Inventory Movement Status", heading_xf)
|
| 1568 |
sheet.write(0, 59, "Packaging Length", heading_xf)
|
1568 |
sheet.write(0, 59, "Packaging Length (Inch)", heading_xf)
|
| 1569 |
sheet.write(0, 60, "Packaging Width", heading_xf)
|
1569 |
sheet.write(0, 60, "Packaging Width (Inch)", heading_xf)
|
| 1570 |
sheet.write(0, 61, "Packaging Height", heading_xf)
|
1570 |
sheet.write(0, 61, "Packaging Height (Inch)", heading_xf)
|
| 1571 |
sheet.write(0, 62, "Packaging Weight", heading_xf)
|
1571 |
sheet.write(0, 62, "Packaging Weight (Kg)", heading_xf)
|
| 1572 |
sheet.write(0, 63, "Oversized Item", heading_xf)
|
1572 |
sheet.write(0, 63, "Oversized Item", heading_xf)
|
| 1573 |
|
1573 |
|
| 1574 |
|
1574 |
|
| 1575 |
def getPackagingCost(data):
|
1575 |
def getPackagingCost(data):
|
| 1576 |
#TODO : Get packagingCost from marketplaceitems table
|
1576 |
#TODO : Get packagingCost from marketplaceitems table
|
| Line 2577... |
Line 2577... |
| 2577 |
sheet.write(0, 21, "Avg Sale Since InStock (Excluding Today)", heading_xf)
|
2577 |
sheet.write(0, 21, "Avg Sale Since InStock (Excluding Today)", heading_xf)
|
| 2578 |
sheet.write(0, 22, "Todays Sale Snapshot Time", heading_xf)
|
2578 |
sheet.write(0, 22, "Todays Sale Snapshot Time", heading_xf)
|
| 2579 |
sheet.write(0, 23, "Todays Sale", heading_xf)
|
2579 |
sheet.write(0, 23, "Todays Sale", heading_xf)
|
| 2580 |
sheet.write(0, 24, "Inventory Movement Status", heading_xf)
|
2580 |
sheet.write(0, 24, "Inventory Movement Status", heading_xf)
|
| 2581 |
sheet.write(0, 25, "Reason", heading_xf)
|
2581 |
sheet.write(0, 25, "Reason", heading_xf)
|
| 2582 |
sheet.write(0, 26, "Packaging Length", heading_xf)
|
2582 |
sheet.write(0, 26, "Packaging Length (Inch)", heading_xf)
|
| 2583 |
sheet.write(0, 27, "Packaging Width", heading_xf)
|
2583 |
sheet.write(0, 27, "Packaging Width (Inch)", heading_xf)
|
| 2584 |
sheet.write(0, 28, "Packaging Height", heading_xf)
|
2584 |
sheet.write(0, 28, "Packaging Height (Inch)", heading_xf)
|
| 2585 |
sheet.write(0, 29, "Packaging Weight", heading_xf)
|
2585 |
sheet.write(0, 29, "Packaging Weight (Kg)", heading_xf)
|
| 2586 |
sheet.write(0, 30, "Oversized Item", heading_xf)
|
2586 |
sheet.write(0, 30, "Oversized Item", heading_xf)
|
| 2587 |
|
2587 |
|
| 2588 |
|
2588 |
|
| 2589 |
sheet_iterator = 1
|
2589 |
sheet_iterator = 1
|
| 2590 |
exceptionListItems = session.query(AmazonScrapingHistory,Item).join((Item,AmazonScrapingHistory.item_id==Item.id)).filter(AmazonScrapingHistory.competitiveCategory==CompetitionCategory.EXCEPTION).filter(AmazonScrapingHistory.timestamp==timestamp).all()
|
2590 |
exceptionListItems = session.query(AmazonScrapingHistory,Item).join((Item,AmazonScrapingHistory.item_id==Item.id)).filter(AmazonScrapingHistory.competitiveCategory==CompetitionCategory.EXCEPTION).filter(AmazonScrapingHistory.timestamp==timestamp).all()
|