| Line 1779... |
Line 1779... |
| 1779 |
return amazonlisted
|
1779 |
return amazonlisted
|
| 1780 |
|
1780 |
|
| 1781 |
def update_amazon_item_details(amazonlisted):
|
1781 |
def update_amazon_item_details(amazonlisted):
|
| 1782 |
amazon_listed = Amazonlisted.get_by(itemId = amazonlisted.itemid)
|
1782 |
amazon_listed = Amazonlisted.get_by(itemId = amazonlisted.itemid)
|
| 1783 |
amazon_listed.isFba=amazonlisted.isFba
|
1783 |
amazon_listed.isFba=amazonlisted.isFba
|
| - |
|
1784 |
amazon_listed.isFbb=amazonlisted.isFbb
|
| 1784 |
amazon_listed.isNonFba=amazonlisted.isNonFba
|
1785 |
amazon_listed.isNonFba=amazonlisted.isNonFba
|
| 1785 |
amazon_listed.isInventoryOverride=amazonlisted.isInventoryOverride
|
1786 |
amazon_listed.isInventoryOverride=amazonlisted.isInventoryOverride
|
| 1786 |
amazon_listed.handlingTime=amazonlisted.handlingTime
|
1787 |
amazon_listed.handlingTime=amazonlisted.handlingTime
|
| 1787 |
amazon_listed.isCustomTime=amazonlisted.isCustomTime
|
1788 |
amazon_listed.isCustomTime=amazonlisted.isCustomTime
|
| 1788 |
amazon_listed.taxCode=amazonlisted.taxCode
|
1789 |
amazon_listed.taxCode=amazonlisted.taxCode
|
| - |
|
1790 |
amazon_listed.fbbtaxCode=amazonlisted.fbbtaxCode
|
| 1789 |
if (amazon_listed.sellingPrice != amazonlisted.sellingPrice) and amazonlisted.sellingPrice > 0:
|
1791 |
if (amazon_listed.sellingPrice != amazonlisted.sellingPrice) and amazonlisted.sellingPrice > 0:
|
| 1790 |
amazon_listed.mfnPriceLastUpdatedOn = datetime.datetime.now()
|
1792 |
amazon_listed.mfnPriceLastUpdatedOn = datetime.datetime.now()
|
| 1791 |
amazon_listed.sellingPrice=amazonlisted.sellingPrice
|
1793 |
amazon_listed.sellingPrice=amazonlisted.sellingPrice
|
| 1792 |
if (amazon_listed.fbaPrice != amazonlisted.fbaPrice) and amazonlisted.fbaPrice > 0:
|
1794 |
if (amazon_listed.fbaPrice != amazonlisted.fbaPrice) and amazonlisted.fbaPrice > 0:
|
| 1793 |
amazon_listed.fbaPriceLastUpdatedOn = datetime.datetime.now()
|
1795 |
amazon_listed.fbaPriceLastUpdatedOn = datetime.datetime.now()
|
| 1794 |
amazon_listed.fbaPrice=amazonlisted.fbaPrice
|
1796 |
amazon_listed.fbaPrice=amazonlisted.fbaPrice
|
| - |
|
1797 |
if (amazon_listed.fbbPrice != amazonlisted.fbbPrice) and amazonlisted.fbbPrice > 0:
|
| - |
|
1798 |
amazon_listed.fbbPriceLastUpdatedOn = datetime.datetime.now()
|
| - |
|
1799 |
amazon_listed.fbbPrice=amazonlisted.fbbPrice
|
| 1795 |
amazon_listed.suppressMfnPriceUpdate=amazonlisted.suppressMfnPriceUpdate
|
1800 |
amazon_listed.suppressMfnPriceUpdate=amazonlisted.suppressMfnPriceUpdate
|
| 1796 |
amazon_listed.suppressFbaPriceUpdate=amazonlisted.suppressFbaPriceUpdate
|
1801 |
amazon_listed.suppressFbaPriceUpdate=amazonlisted.suppressFbaPriceUpdate
|
| - |
|
1802 |
amazon_listed.suppressFbbPriceUpdate=amazonlisted.suppressFbbPriceUpdate
|
| 1797 |
session.commit()
|
1803 |
session.commit()
|
| 1798 |
|
1804 |
|
| 1799 |
def add_amazon_item(amazonlisted):
|
1805 |
def add_amazon_item(amazonlisted):
|
| 1800 |
if (not amazonlisted) or (not amazonlisted.itemid) or (not amazonlisted.asin):
|
1806 |
if (not amazonlisted) or (not amazonlisted.itemid) or (not amazonlisted.asin):
|
| 1801 |
return
|
1807 |
return
|
| Line 1853... |
Line 1859... |
| 1853 |
amazon_item.suppressMfnPriceUpdate=False
|
1859 |
amazon_item.suppressMfnPriceUpdate=False
|
| 1854 |
amazon_item.suppressFbaPriceUpdate=False
|
1860 |
amazon_item.suppressFbaPriceUpdate=False
|
| 1855 |
amazon_item.isFba = False
|
1861 |
amazon_item.isFba = False
|
| 1856 |
amazon_item.isNonFba = False
|
1862 |
amazon_item.isNonFba = False
|
| 1857 |
amazon_item.isInventoryOverride = False
|
1863 |
amazon_item.isInventoryOverride = False
|
| - |
|
1864 |
amazon_item.fbbPrice = amazonlisted.fbbPrice,
|
| - |
|
1865 |
amazon_item.fbbPriceLastUpdatedOnSc = datetime.datetime.now(),
|
| - |
|
1866 |
amazon_item.fbbPriceLastUpdatedOn = datetime.datetime.now(),
|
| - |
|
1867 |
amazon_item.isFbb = False,
|
| - |
|
1868 |
amazon_item.suppressFbbPriceUpdate = False
|
| - |
|
1869 |
|
| 1858 |
elif (amazonItem.asin!=amazonlisted.asin):
|
1870 |
elif (amazonItem.asin!=amazonlisted.asin):
|
| 1859 |
if amazonlisted.asin:
|
1871 |
if amazonlisted.asin:
|
| 1860 |
amazonItem.asin=amazonlisted.asin
|
1872 |
amazonItem.asin=amazonlisted.asin
|
| 1861 |
if amazonlisted.brand:
|
1873 |
if amazonlisted.brand:
|
| 1862 |
amazonItem.brand=amazonlisted.brand
|
1874 |
amazonItem.brand=amazonlisted.brand
|
| Line 1998... |
Line 2010... |
| 1998 |
amazon_item.mfnPriceLastUpdatedOn = datetime.datetime.now()
|
2010 |
amazon_item.mfnPriceLastUpdatedOn = datetime.datetime.now()
|
| 1999 |
amazon_item.sellingPrice = amazonlisted.sellingPrice
|
2011 |
amazon_item.sellingPrice = amazonlisted.sellingPrice
|
| 2000 |
if amazon_item.fbaPrice != amazonlisted.fbaPrice:
|
2012 |
if amazon_item.fbaPrice != amazonlisted.fbaPrice:
|
| 2001 |
amazon_item.fbaPriceLastUpdatedOn = datetime.datetime.now()
|
2013 |
amazon_item.fbaPriceLastUpdatedOn = datetime.datetime.now()
|
| 2002 |
amazon_item.fbaPrice = amazonlisted.fbaPrice
|
2014 |
amazon_item.fbaPrice = amazonlisted.fbaPrice
|
| - |
|
2015 |
if amazon_item.fbbPrice != amazonlisted.fbbPrice:
|
| - |
|
2016 |
amazon_item.fbbPriceLastUpdatedOn = datetime.datetime.now()
|
| - |
|
2017 |
amazon_item.fbbPrice = amazonlisted.fbbPrice
|
| - |
|
2018 |
amazon_item.fbbTaxCode = amazonlisted.fbbTaxCode
|
| 2003 |
amazon_item.taxCode = amazonlisted.taxCode
|
2019 |
amazon_item.taxCode = amazonlisted.taxCode
|
| - |
|
2020 |
amazon_item.isFbb = amazonlisted.isFbb
|
| 2004 |
amazon_item.isFba = amazonlisted.isFba
|
2021 |
amazon_item.isFba = amazonlisted.isFba
|
| 2005 |
amazon_item.isNonFba = amazonlisted.isNonFba
|
2022 |
amazon_item.isNonFba = amazonlisted.isNonFba
|
| 2006 |
amazon_item.isInventoryOverride = amazonlisted.isInventoryOverride
|
2023 |
amazon_item.isInventoryOverride = amazonlisted.isInventoryOverride
|
| 2007 |
amazon_item.suppressMfnPriceUpdate = amazonlisted.suppressMfnPriceUpdate
|
2024 |
amazon_item.suppressMfnPriceUpdate = amazonlisted.suppressMfnPriceUpdate
|
| 2008 |
amazon_item.suppressFbaPriceUpdate = amazonlisted.suppressFbaPriceUpdate
|
2025 |
amazon_item.suppressFbaPriceUpdate = amazonlisted.suppressFbaPriceUpdate
|
| - |
|
2026 |
amazon_item.suppressFbbPriceUpdate = amazonlisted.suppressFbbPriceUpdate
|
| 2009 |
session.commit()
|
2027 |
session.commit()
|
| 2010 |
return True
|
2028 |
return True
|
| 2011 |
|
2029 |
|
| 2012 |
|
2030 |
|
| 2013 |
def insert_ebay_item(ebayItem):
|
2031 |
def insert_ebay_item(ebayItem):
|
| Line 2589... |
Line 2607... |
| 2589 |
def get_all_fk_items():
|
2607 |
def get_all_fk_items():
|
| 2590 |
return session.query(FlipkartItem,Item).join((Item,FlipkartItem.item_id==Item.id)).all()
|
2608 |
return session.query(FlipkartItem,Item).join((Item,FlipkartItem.item_id==Item.id)).all()
|
| 2591 |
|
2609 |
|
| 2592 |
def get_flipkart_item_by_sku_at_flipkart(sku):
|
2610 |
def get_flipkart_item_by_sku_at_flipkart(sku):
|
| 2593 |
return session.query(FlipkartItem,Item).join((Item,FlipkartItem.item_id==Item.id)).filter(FlipkartItem.skuAtFlipkart==sku).first()
|
2611 |
return session.query(FlipkartItem,Item).join((Item,FlipkartItem.item_id==Item.id)).filter(FlipkartItem.skuAtFlipkart==sku).first()
|
| - |
|
2612 |
|
| - |
|
2613 |
def get_all_fbb_listed_items():
|
| - |
|
2614 |
return Amazonlisted.query.filter(Amazonlisted.isFbb==True).all()
|
| - |
|
2615 |
|