| Line 1679... |
Line 1679... |
| 1679 |
amazon_item.upc=amazonlisted.upc
|
1679 |
amazon_item.upc=amazonlisted.upc
|
| 1680 |
else:
|
1680 |
else:
|
| 1681 |
amazon_item.upc=''
|
1681 |
amazon_item.upc=''
|
| 1682 |
if amazonlisted.fbaPrice:
|
1682 |
if amazonlisted.fbaPrice:
|
| 1683 |
amazon_item.fbaPrice=amazonlisted.fbaPrice
|
1683 |
amazon_item.fbaPrice=amazonlisted.fbaPrice
|
| - |
|
1684 |
amazon_item.fbaPriceLastUpdatedOnSc = datetime.datetime.now()
|
| 1684 |
amazon_item.fbaPriceLastUpdatedOn = datetime.datetime.now()
|
1685 |
amazon_item.fbaPriceLastUpdatedOn = datetime.datetime.now()
|
| 1685 |
if amazonlisted.sellingPrice:
|
1686 |
if amazonlisted.sellingPrice:
|
| 1686 |
amazon_item.sellingPrice=amazonlisted.sellingPrice
|
1687 |
amazon_item.sellingPrice=amazonlisted.sellingPrice
|
| - |
|
1688 |
amazon_item.mfnPriceLastUpdatedOnSc = datetime.datetime.now()
|
| 1687 |
amazon_item.mfnPriceLastUpdatedOn = datetime.datetime.now()
|
1689 |
amazon_item.mfnPriceLastUpdatedOn = datetime.datetime.now()
|
| 1688 |
if amazonlisted.isFba:
|
1690 |
if amazonlisted.isFba:
|
| 1689 |
amazon_item.isFba=amazonlisted.isFba
|
1691 |
amazon_item.isFba=amazonlisted.isFba
|
| 1690 |
if amazonlisted.isNonFba:
|
1692 |
if amazonlisted.isNonFba:
|
| 1691 |
amazon_item.isNonFba=amazonlisted.isNonFba
|
1693 |
amazon_item.isNonFba=amazonlisted.isNonFba
|
| Line 1730... |
Line 1732... |
| 1730 |
amazonItem.upc=amazonlisted.upc
|
1732 |
amazonItem.upc=amazonlisted.upc
|
| 1731 |
else:
|
1733 |
else:
|
| 1732 |
amazonItem.upc=''
|
1734 |
amazonItem.upc=''
|
| 1733 |
if amazonlisted.sellingPrice:
|
1735 |
if amazonlisted.sellingPrice:
|
| 1734 |
amazon_item.sellingPrice=amazonlisted.sellingPrice
|
1736 |
amazon_item.sellingPrice=amazonlisted.sellingPrice
|
| 1735 |
amazonlisted.mfnPriceLastUpdatedOnSc = datetime.datetime.now()
|
- |
|
| 1736 |
amazonlisted.mfnPriceLastUpdatedOn = datetime.datetime.now()
|
- |
|
| 1737 |
if amazonlisted.fbaPrice:
|
1737 |
if amazonlisted.fbaPrice:
|
| 1738 |
amazon_item.fbaPrice=amazonlisted.fbaPrice
|
1738 |
amazon_item.fbaPrice=amazonlisted.fbaPrice
|
| 1739 |
amazonlisted.fbaPriceLastUpdatedOnSc = datetime.datetime.now()
|
- |
|
| 1740 |
amazonlisted.fbaPriceLastUpdatedOn = datetime.datetime.now()
|
- |
|
| 1741 |
if amazonlisted.isFba:
|
1739 |
if amazonlisted.isFba:
|
| 1742 |
amazonItem.isFba=amazonlisted.isFba
|
1740 |
amazonItem.isFba=amazonlisted.isFba
|
| 1743 |
if amazonlisted.isNonFba:
|
1741 |
if amazonlisted.isNonFba:
|
| 1744 |
amazonItem.isNonFba=amazonlisted.isNonFba
|
1742 |
amazonItem.isNonFba=amazonlisted.isNonFba
|
| 1745 |
if amazonlisted.isInventoryOverride:
|
1743 |
if amazonlisted.isInventoryOverride:
|
| Line 1772... |
Line 1770... |
| 1772 |
item.defaultInventory = defaultInventory
|
1770 |
item.defaultInventory = defaultInventory
|
| 1773 |
session.commit()
|
1771 |
session.commit()
|
| 1774 |
|
1772 |
|
| 1775 |
def update_timestamp_for_amazon_feeds(feedType,skuList,timestamp):
|
1773 |
def update_timestamp_for_amazon_feeds(feedType,skuList,timestamp):
|
| 1776 |
#amazonListed = get_all_amazon_listed_items()
|
1774 |
#amazonListed = get_all_amazon_listed_items()
|
| 1777 |
fbaItems = []
|
1775 |
#fbaItems = []
|
| 1778 |
mfnItems = []
|
1776 |
#mfnItems = []
|
| 1779 |
if feedType == 'NonFbaPricing':
|
1777 |
if feedType == 'NonFbaPricing':
|
| 1780 |
items = Amazonlisted.query.filter(Amazonlisted.isNonFba==True).filter(Amazonlisted.mfnPriceLastUpdatedOn > Amazonlisted.mfnPriceLastUpdatedOnSc).all()
|
- |
|
| 1781 |
for item in items:
|
- |
|
| 1782 |
mfnItems.append(item.itemId)
|
- |
|
| 1783 |
listToUpdate = list(set(mfnItems)-set(skuList))
|
- |
|
| 1784 |
for sku in listToUpdate:
|
1778 |
for sku in skuList:
|
| 1785 |
amazonItem = Amazonlisted.get_by(itemId=sku)
|
1779 |
amazonItem = Amazonlisted.get_by(itemId=sku)
|
| 1786 |
amazonItem.mfnPriceLastUpdatedOnSc = to_py_date(timestamp)
|
1780 |
amazonItem.mfnPriceLastUpdatedOnSc = to_py_date(timestamp)
|
| 1787 |
session.commit()
|
1781 |
session.commit()
|
| 1788 |
return True
|
1782 |
return True
|
| 1789 |
elif feedType == 'FbaPricing':
|
1783 |
elif feedType == 'FbaPricing':
|
| 1790 |
items = Amazonlisted.query.filter(Amazonlisted.isFba==True).filter(Amazonlisted.fbaPriceLastUpdatedOn > Amazonlisted.fbaPriceLastUpdatedOnSc).all()
|
- |
|
| 1791 |
for item in items:
|
- |
|
| 1792 |
fbaItems.append(item.itemId)
|
- |
|
| 1793 |
listToUpdate = list(set(fbaItems)-set(skuList))
|
- |
|
| 1794 |
for sku in listToUpdate:
|
1784 |
for sku in skuList:
|
| 1795 |
amazonItem = Amazonlisted.get_by(itemId=sku)
|
1785 |
amazonItem = Amazonlisted.get_by(itemId=sku)
|
| 1796 |
amazonItem.fbaPriceLastUpdatedOnSc = to_py_date(timestamp)
|
1786 |
amazonItem.fbaPriceLastUpdatedOnSc = to_py_date(timestamp)
|
| 1797 |
session.commit()
|
1787 |
session.commit()
|
| 1798 |
return True
|
1788 |
return True
|
| 1799 |
elif feedType== 'FullFbaPricing':
|
1789 |
elif feedType== 'FullFbaPricing':
|
| 1800 |
items = Amazonlisted.query.filter(Amazonlisted.isFba==True).all()
|
- |
|
| 1801 |
for item in items:
|
- |
|
| 1802 |
fbaItems.append(item.itemId)
|
- |
|
| 1803 |
listToUpdate = list(set(fbaItems)-set(skuList))
|
- |
|
| 1804 |
for sku in listToUpdate:
|
1790 |
for sku in skuList:
|
| 1805 |
amazonItem = Amazonlisted.get_by(itemId=sku)
|
1791 |
amazonItem = Amazonlisted.get_by(itemId=sku)
|
| 1806 |
amazonItem.fbaPriceLastUpdatedOnSc = to_py_date(timestamp)
|
1792 |
amazonItem.fbaPriceLastUpdatedOnSc = to_py_date(timestamp)
|
| 1807 |
session.commit()
|
1793 |
session.commit()
|
| 1808 |
return True
|
1794 |
return True
|
| 1809 |
elif feedType== 'FullNonFbaPricing':
|
1795 |
elif feedType== 'FullNonFbaPricing':
|
| 1810 |
items = Amazonlisted.query.filter(Amazonlisted.isNonFba==True).all()
|
- |
|
| 1811 |
for item in items:
|
- |
|
| 1812 |
mfnItems.append(item.itemId)
|
- |
|
| 1813 |
listToUpdate = list(set(mfnItems)-set(skuList))
|
- |
|
| 1814 |
for sku in listToUpdate:
|
1796 |
for sku in skuList:
|
| 1815 |
amazonItem = Amazonlisted.get_by(itemId=sku)
|
1797 |
amazonItem = Amazonlisted.get_by(itemId=sku)
|
| 1816 |
amazonItem.mfnPriceLastUpdatedOnSc = to_py_date(timestamp)
|
1798 |
amazonItem.mfnPriceLastUpdatedOnSc = to_py_date(timestamp)
|
| 1817 |
session.commit()
|
1799 |
session.commit()
|
| 1818 |
else:
|
1800 |
else:
|
| 1819 |
return False
|
1801 |
return False
|