| Line 1723... |
Line 1723... |
| 1723 |
amazon_listed.isFba=amazonlisted.isFba
|
1723 |
amazon_listed.isFba=amazonlisted.isFba
|
| 1724 |
amazon_listed.isNonFba=amazonlisted.isNonFba
|
1724 |
amazon_listed.isNonFba=amazonlisted.isNonFba
|
| 1725 |
amazon_listed.isInventoryOverride=amazonlisted.isInventoryOverride
|
1725 |
amazon_listed.isInventoryOverride=amazonlisted.isInventoryOverride
|
| 1726 |
amazon_listed.handlingTime=amazonlisted.handlingTime
|
1726 |
amazon_listed.handlingTime=amazonlisted.handlingTime
|
| 1727 |
amazon_listed.isCustomTime=amazonlisted.isCustomTime
|
1727 |
amazon_listed.isCustomTime=amazonlisted.isCustomTime
|
| - |
|
1728 |
amazon_listed.taxCode=amazonlisted.taxCode
|
| 1728 |
if amazon_listed.sellingPrice != amazonlisted.sellingPrice:
|
1729 |
if (amazon_listed.sellingPrice != amazonlisted.sellingPrice) and amazonlisted.sellingPrice > 0:
|
| 1729 |
amazon_listed.mfnPriceLastUpdatedOn = datetime.datetime.now()
|
1730 |
amazon_listed.mfnPriceLastUpdatedOn = datetime.datetime.now()
|
| 1730 |
amazon_listed.sellingPrice=amazonlisted.sellingPrice
|
1731 |
amazon_listed.sellingPrice=amazonlisted.sellingPrice
|
| 1731 |
if amazon_listed.fbaPrice != amazonlisted.fbaPrice:
|
1732 |
if (amazon_listed.fbaPrice != amazonlisted.fbaPrice) and amazonlisted.fbaPrice > 0:
|
| 1732 |
amazon_listed.fbaPriceLastUpdatedOn = datetime.datetime.now()
|
1733 |
amazon_listed.fbaPriceLastUpdatedOn = datetime.datetime.now()
|
| 1733 |
amazon_listed.fbaPrice=amazonlisted.fbaPrice
|
1734 |
amazon_listed.fbaPrice=amazonlisted.fbaPrice
|
| 1734 |
amazon_listed.suppressMfnPriceUpdate=amazonlisted.suppressMfnPriceUpdate
|
1735 |
amazon_listed.suppressMfnPriceUpdate=amazonlisted.suppressMfnPriceUpdate
|
| 1735 |
amazon_listed.suppressFbaPriceUpdate=amazonlisted.suppressFbaPriceUpdate
|
1736 |
amazon_listed.suppressFbaPriceUpdate=amazonlisted.suppressFbaPriceUpdate
|
| 1736 |
session.commit()
|
1737 |
session.commit()
|
| Line 1937... |
Line 1938... |
| 1937 |
amazon_item.mfnPriceLastUpdatedOn = datetime.datetime.now()
|
1938 |
amazon_item.mfnPriceLastUpdatedOn = datetime.datetime.now()
|
| 1938 |
amazon_item.sellingPrice = amazonlisted.sellingPrice
|
1939 |
amazon_item.sellingPrice = amazonlisted.sellingPrice
|
| 1939 |
if amazon_item.fbaPrice != amazonlisted.fbaPrice:
|
1940 |
if amazon_item.fbaPrice != amazonlisted.fbaPrice:
|
| 1940 |
amazon_item.fbaPriceLastUpdatedOn = datetime.datetime.now()
|
1941 |
amazon_item.fbaPriceLastUpdatedOn = datetime.datetime.now()
|
| 1941 |
amazon_item.fbaPrice = amazonlisted.fbaPrice
|
1942 |
amazon_item.fbaPrice = amazonlisted.fbaPrice
|
| - |
|
1943 |
amazon_item.taxCode = amazonlisted.taxCode
|
| 1942 |
amazon_item.isFba = amazonlisted.isFba
|
1944 |
amazon_item.isFba = amazonlisted.isFba
|
| 1943 |
amazon_item.isNonFba = amazonlisted.isNonFba
|
1945 |
amazon_item.isNonFba = amazonlisted.isNonFba
|
| 1944 |
amazon_item.isInventoryOverride = amazonlisted.isInventoryOverride
|
1946 |
amazon_item.isInventoryOverride = amazonlisted.isInventoryOverride
|
| 1945 |
amazon_item.suppressMfnPriceUpdate = amazonlisted.suppressMfnPriceUpdate
|
1947 |
amazon_item.suppressMfnPriceUpdate = amazonlisted.suppressMfnPriceUpdate
|
| 1946 |
amazon_item.suppressFbaPriceUpdate = amazonlisted.suppressFbaPriceUpdate
|
1948 |
amazon_item.suppressFbaPriceUpdate = amazonlisted.suppressFbaPriceUpdate
|
| Line 1980... |
Line 1982... |
| 1980 |
def get_all_items_to_list_on_fba():
|
1982 |
def get_all_items_to_list_on_fba():
|
| 1981 |
return Amazonlisted.query.filter(Amazonlisted.isFba==False).all()
|
1983 |
return Amazonlisted.query.filter(Amazonlisted.isFba==False).all()
|
| 1982 |
|
1984 |
|
| 1983 |
def get_all_items_to_list_on_nonfba():
|
1985 |
def get_all_items_to_list_on_nonfba():
|
| 1984 |
return Amazonlisted.query.filter(Amazonlisted.isNonFba==False).all()
|
1986 |
return Amazonlisted.query.filter(Amazonlisted.isNonFba==False).all()
|
| 1985 |
#else:
|
- |
|
| 1986 |
# raise CatalogServiceException(1,"Can't update item once listing is expired")
|
- |
|
| 1987 |
|
1987 |
|
| - |
|
1988 |
def get_amazon_listed_items(offset,limit):
|
| - |
|
1989 |
return session.query(Amazonlisted).offset(offset).limit(limit).all()
|
| - |
|
1990 |
|
| - |
|
1991 |
def search_amazon_items(search_terms, offset, limit):
|
| - |
|
1992 |
query = Amazonlisted.query
|
| - |
|
1993 |
|
| - |
|
1994 |
search_terms = ['%' + search_term + '%' for search_term in search_terms]
|
| - |
|
1995 |
|
| - |
|
1996 |
for search_term in search_terms:
|
| - |
|
1997 |
query_clause = []
|
| - |
|
1998 |
query_clause.append(Amazonlisted.itemId.like(search_term))
|
| - |
|
1999 |
query_clause.append(Amazonlisted.brand.like(search_term))
|
| - |
|
2000 |
query_clause.append(Amazonlisted.model.like(search_term))
|
| - |
|
2001 |
query_clause.append(Amazonlisted.name.like(search_term))
|
| - |
|
2002 |
query_clause.append(Amazonlisted.asin.like(search_term))
|
| - |
|
2003 |
query = query.filter(or_(*query_clause))
|
| - |
|
2004 |
|
| - |
|
2005 |
query = query.offset(offset)
|
| - |
|
2006 |
if limit:
|
| - |
|
2007 |
query = query.limit(limit)
|
| - |
|
2008 |
amazon_items = query.all()
|
| - |
|
2009 |
return amazon_items
|
| - |
|
2010 |
|
| - |
|
2011 |
def get_amazon_search_result_count(search_terms):
|
| - |
|
2012 |
query = Amazonlisted.query
|
| - |
|
2013 |
|
| - |
|
2014 |
search_terms = ['%' + search_term + '%' for search_term in search_terms]
|
| - |
|
2015 |
|
| - |
|
2016 |
for search_term in search_terms:
|
| - |
|
2017 |
query_clause = []
|
| - |
|
2018 |
query_clause.append(Amazonlisted.itemId.like(search_term))
|
| - |
|
2019 |
query_clause.append(Amazonlisted.brand.like(search_term))
|
| - |
|
2020 |
query_clause.append(Amazonlisted.model.like(search_term))
|
| - |
|
2021 |
query_clause.append(Amazonlisted.name.like(search_term))
|
| - |
|
2022 |
query_clause.append(Amazonlisted.asin.like(search_term))
|
| - |
|
2023 |
query = query.filter(or_(*query_clause))
|
| - |
|
2024 |
|
| - |
|
2025 |
return query.count()
|
| - |
|
2026 |
|
| - |
|
2027 |
def get_count_for_amazonlisted_items():
|
| - |
|
2028 |
return session.query(func.count(Amazonlisted.itemId)).scalar()
|
| - |
|
2029 |
|
| - |
|
2030 |
def update_asin(amazonAsinMap):
|
| - |
|
2031 |
for item_id,t_item in amazonAsinMap.iteritems():
|
| - |
|
2032 |
item = get_item(item_id)
|
| - |
|
2033 |
item.asin=t_item.asin
|
| - |
|
2034 |
item.defaultInventory = t_item.defaultInventory
|
| - |
|
2035 |
item.holdInventory = t_item.holdInventory
|
| - |
|
2036 |
item.updatedOn = datetime.datetime.now()
|
| - |
|
2037 |
session.commit()
|
| - |
|
2038 |
|
| - |
|
2039 |
|
| - |
|
2040 |
|
| - |
|
2041 |
|
| - |
|
2042 |
|
| - |
|
2043 |
|
| - |
|
2044 |
|
| - |
|
2045 |
|
| - |
|
2046 |
|
| - |
|
2047 |
|
| - |
|
2048 |
|