| Line 6515... |
Line 6515... |
| 6515 |
order.statusDescription = "Order delivered"
|
6515 |
order.statusDescription = "Order delivered"
|
| 6516 |
order.delivery_timestamp = datetime.datetime.strptime(delivered_orders.get(orderId), "%Y-%m-%d %H:%M:%S")
|
6516 |
order.delivery_timestamp = datetime.datetime.strptime(delivered_orders.get(orderId), "%Y-%m-%d %H:%M:%S")
|
| 6517 |
session.commit()
|
6517 |
session.commit()
|
| 6518 |
'''
|
6518 |
'''
|
| 6519 |
|
6519 |
|
| - |
|
6520 |
def bulk_add_or_update_amazon_fba_sales_snapshot(amazonfbasalessnapshotlist):
|
| - |
|
6521 |
for amazonfbasalessnapshot in amazonfbasalessnapshotlist:
|
| - |
|
6522 |
salesnapshotfordate = AmazonFbaSalesSnapshot.get_by(item_id = amazonfbasalessnapshot.item_id,dateOfSale=to_py_date(amazonfbasalessnapshot.dateOfSale).date())
|
| - |
|
6523 |
if salesnapshotfordate is None:
|
| - |
|
6524 |
amazon_fba_sales_snapshot = AmazonFbaSalesSnapshot()
|
| - |
|
6525 |
amazon_fba_sales_snapshot.dateOfSale = to_py_date(amazonfbasalessnapshot.dateOfSale).date()
|
| - |
|
6526 |
amazon_fba_sales_snapshot.item_id = amazonfbasalessnapshot.item_id
|
| - |
|
6527 |
amazon_fba_sales_snapshot.totalOrderCount = amazonfbasalessnapshot.totalOrderCount
|
| - |
|
6528 |
amazon_fba_sales_snapshot.amazonFbaInventory = amazonfbasalessnapshot.amazonFbaInventory
|
| - |
|
6529 |
amazon_fba_sales_snapshot.isOutOfStock = amazonfbasalessnapshot.isOutOfStock
|
| - |
|
6530 |
amazon_fba_sales_snapshot.promotionOrderCount = amazonfbasalessnapshot.promotionOrderCount
|
| - |
|
6531 |
amazon_fba_sales_snapshot.totalSale = amazonfbasalessnapshot.totalSale
|
| - |
|
6532 |
amazon_fba_sales_snapshot.promotionSale = amazonfbasalessnapshot.promotionSale
|
| - |
|
6533 |
#if amazonfbasalessnapshot.ourPrice is not None:
|
| - |
|
6534 |
amazon_fba_sales_snapshot.ourPriceSnapshotDate = to_py_date(amazonfbasalessnapshot.ourPriceSnapshotDate)
|
| - |
|
6535 |
amazon_fba_sales_snapshot.ourPrice = amazonfbasalessnapshot.ourPrice
|
| - |
|
6536 |
#if amazonfbasalessnapshot.salePrice is not None:
|
| - |
|
6537 |
amazon_fba_sales_snapshot.salePriceSnapshotDate = to_py_date(amazonfbasalessnapshot.salePriceSnapshotDate)
|
| - |
|
6538 |
amazon_fba_sales_snapshot.salePrice = amazonfbasalessnapshot.salePrice
|
| - |
|
6539 |
#if amazonfbasalessnapshot.minFbaPrice is not None:
|
| - |
|
6540 |
amazon_fba_sales_snapshot.minFbaPriceSnapshotDate = to_py_date(amazonfbasalessnapshot.minFbaPriceSnapshotDate)
|
| - |
|
6541 |
amazon_fba_sales_snapshot.minFbaPrice = amazonfbasalessnapshot.minFbaPrice
|
| - |
|
6542 |
#if amazonfbasalessnapshot.minMfnPrice is not None:
|
| - |
|
6543 |
amazon_fba_sales_snapshot.minMfnPriceSnapshotDate = to_py_date(amazonfbasalessnapshot.minMfnPriceSnapshotDate)
|
| - |
|
6544 |
amazon_fba_sales_snapshot.minMfnPrice = amazonfbasalessnapshot.minMfnPrice
|
| - |
|
6545 |
|
| - |
|
6546 |
else:
|
| - |
|
6547 |
if(amazonfbasalessnapshot.totalOrderCount > 0):
|
| - |
|
6548 |
salesnapshotfordate.isOutOfStock = 0
|
| - |
|
6549 |
salesnapshotfordate.promotionOrderCount = amazonfbasalessnapshot.promotionOrderCount
|
| - |
|
6550 |
salesnapshotfordate.totalSale = amazonfbasalessnapshot.totalSale
|
| - |
|
6551 |
salesnapshotfordate.promotionSale = amazonfbasalessnapshot.promotionSale
|
| - |
|
6552 |
salesnapshotfordate.totalOrderCount = amazonfbasalessnapshot.totalOrderCount
|
| - |
|
6553 |
session.commit()
|
| - |
|
6554 |
|
| 6520 |
if __name__ == '__main__':
|
6555 |
if __name__ == '__main__':
|
| 6521 |
print get_orders_by_mobile_number("9650889334")
|
6556 |
print get_orders_by_mobile_number("9650889334")
|