| Line 1896... |
Line 1896... |
| 1896 |
sheet.write(sheet_iterator, 50, str(inStockStats[2]))
|
1896 |
sheet.write(sheet_iterator, 50, str(inStockStats[2]))
|
| 1897 |
sheet.write(sheet_iterator, 51, getAvgSale(inStockStats[2], inStockStats[1]))
|
1897 |
sheet.write(sheet_iterator, 51, getAvgSale(inStockStats[2], inStockStats[1]))
|
| 1898 |
toDaysSale = getTodaysSale(sku)
|
1898 |
toDaysSale = getTodaysSale(sku)
|
| 1899 |
sheet.write(sheet_iterator, 52, toDaysSale[0])
|
1899 |
sheet.write(sheet_iterator, 52, toDaysSale[0])
|
| 1900 |
sheet.write(sheet_iterator, 53, str(toDaysSale[1]))
|
1900 |
sheet.write(sheet_iterator, 53, str(toDaysSale[1]))
|
| - |
|
1901 |
sheet.write(sheet_iterator, 59, amScraping.packagingLength)
|
| - |
|
1902 |
sheet.write(sheet_iterator, 60, amScraping.packagingWidth)
|
| - |
|
1903 |
sheet.write(sheet_iterator, 61, amScraping.packagingHeight)
|
| - |
|
1904 |
sheet.write(sheet_iterator, 62, amScraping.packagingWeight)
|
| - |
|
1905 |
sheet.write(sheet_iterator, 63, amScraping.isOversized)
|
| 1901 |
if amScraping.decision is None:
|
1906 |
if amScraping.decision is None:
|
| 1902 |
sheet.write(sheet_iterator, 54, 'Auto Pricing Inactive')
|
1907 |
sheet.write(sheet_iterator, 54, 'Auto Pricing Inactive')
|
| 1903 |
sheet.write(sheet_iterator, 55, getNewMargin(amScraping,amScraping.proposedSp))
|
1908 |
sheet.write(sheet_iterator, 57, getNewMargin(amScraping,amScraping.proposedSp))
|
| 1904 |
sheet.write(sheet_iterator, 58, getInventoryMovementStatus(amScraping))
|
1909 |
sheet.write(sheet_iterator, 58, getInventoryMovementStatus(amScraping))
|
| 1905 |
sheet_iterator+=1
|
1910 |
sheet_iterator+=1
|
| 1906 |
continue
|
1911 |
continue
|
| 1907 |
sheet.write(sheet_iterator, 54, Decision._VALUES_TO_NAMES.get(amScraping.decision))
|
1912 |
sheet.write(sheet_iterator, 54, Decision._VALUES_TO_NAMES.get(amScraping.decision))
|
| 1908 |
sheet.write(sheet_iterator, 55, amScraping.reason)
|
1913 |
sheet.write(sheet_iterator, 55, amScraping.reason)
|
| Line 1910... |
Line 1915... |
| 1910 |
sheet.write(sheet_iterator, 56, math.ceil(amScraping.proposedSp))
|
1915 |
sheet.write(sheet_iterator, 56, math.ceil(amScraping.proposedSp))
|
| 1911 |
if Decision._VALUES_TO_NAMES.get(amScraping.decision) == "AUTO_INCREMENT_SUCCESS":
|
1916 |
if Decision._VALUES_TO_NAMES.get(amScraping.decision) == "AUTO_INCREMENT_SUCCESS":
|
| 1912 |
sheet.write(sheet_iterator, 56, min(math.ceil(amScraping.promoPrice+max(10,.01*amScraping.promoPrice)),amScraping.proposedSp))
|
1917 |
sheet.write(sheet_iterator, 56, min(math.ceil(amScraping.promoPrice+max(10,.01*amScraping.promoPrice)),amScraping.proposedSp))
|
| 1913 |
sheet.write(sheet_iterator, 57, getNewMargin(amScraping,amScraping.proposedSp))
|
1918 |
sheet.write(sheet_iterator, 57, getNewMargin(amScraping,amScraping.proposedSp))
|
| 1914 |
sheet.write(sheet_iterator, 58, getInventoryMovementStatus(amScraping))
|
1919 |
sheet.write(sheet_iterator, 58, getInventoryMovementStatus(amScraping))
|
| 1915 |
sheet.write(sheet_iterator, 59, amScraping.packagingLength)
|
- |
|
| 1916 |
sheet.write(sheet_iterator, 60, amScraping.packagingWidth)
|
- |
|
| 1917 |
sheet.write(sheet_iterator, 61, amScraping.packagingHeight)
|
- |
|
| 1918 |
sheet.write(sheet_iterator, 62, amScraping.packagingWeight)
|
- |
|
| 1919 |
sheet.write(sheet_iterator, 63, amScraping.isOversized)
|
- |
|
| 1920 |
sheet_iterator+=1
|
1920 |
sheet_iterator+=1
|
| 1921 |
|
1921 |
|
| 1922 |
almostCompetitiveItems = session.query(AmazonScrapingHistory,Item).join((Item,AmazonScrapingHistory.item_id==Item.id)).filter(AmazonScrapingHistory.competitiveCategory==CompetitionCategory.ALMOST_COMPETE).filter(AmazonScrapingHistory.timestamp==timestamp).all()
|
1922 |
almostCompetitiveItems = session.query(AmazonScrapingHistory,Item).join((Item,AmazonScrapingHistory.item_id==Item.id)).filter(AmazonScrapingHistory.competitiveCategory==CompetitionCategory.ALMOST_COMPETE).filter(AmazonScrapingHistory.timestamp==timestamp).all()
|
| 1923 |
for almostCompetitiveItem in almostCompetitiveItems:
|
1923 |
for almostCompetitiveItem in almostCompetitiveItems:
|
| 1924 |
amScraping = almostCompetitiveItem[0]
|
1924 |
amScraping = almostCompetitiveItem[0]
|
| Line 2007... |
Line 2007... |
| 2007 |
sheet.write(sheet_iterator, 50, str(inStockStats[2]))
|
2007 |
sheet.write(sheet_iterator, 50, str(inStockStats[2]))
|
| 2008 |
sheet.write(sheet_iterator, 51, getAvgSale(inStockStats[2], inStockStats[1]))
|
2008 |
sheet.write(sheet_iterator, 51, getAvgSale(inStockStats[2], inStockStats[1]))
|
| 2009 |
toDaysSale = getTodaysSale(sku)
|
2009 |
toDaysSale = getTodaysSale(sku)
|
| 2010 |
sheet.write(sheet_iterator, 52, toDaysSale[0])
|
2010 |
sheet.write(sheet_iterator, 52, toDaysSale[0])
|
| 2011 |
sheet.write(sheet_iterator, 53, str(toDaysSale[1]))
|
2011 |
sheet.write(sheet_iterator, 53, str(toDaysSale[1]))
|
| - |
|
2012 |
sheet.write(sheet_iterator, 59, amScraping.packagingLength)
|
| - |
|
2013 |
sheet.write(sheet_iterator, 60, amScraping.packagingWidth)
|
| - |
|
2014 |
sheet.write(sheet_iterator, 61, amScraping.packagingHeight)
|
| - |
|
2015 |
sheet.write(sheet_iterator, 62, amScraping.packagingWeight)
|
| - |
|
2016 |
sheet.write(sheet_iterator, 63, amScraping.isOversized)
|
| 2012 |
if amScraping.decision is None:
|
2017 |
if amScraping.decision is None:
|
| 2013 |
sheet.write(sheet_iterator, 54, 'Auto Pricing Inactive')
|
2018 |
sheet.write(sheet_iterator, 54, 'Auto Pricing Inactive')
|
| 2014 |
sheet.write(sheet_iterator, 57, getNewMargin(amScraping,amScraping.proposedSp))
|
2019 |
sheet.write(sheet_iterator, 57, getNewMargin(amScraping,amScraping.proposedSp))
|
| 2015 |
sheet.write(sheet_iterator, 58, getInventoryMovementStatus(amScraping))
|
2020 |
sheet.write(sheet_iterator, 58, getInventoryMovementStatus(amScraping))
|
| 2016 |
sheet_iterator+=1
|
2021 |
sheet_iterator+=1
|
| Line 2021... |
Line 2026... |
| 2021 |
sheet.write(sheet_iterator, 56, math.ceil(amScraping.proposedSp))
|
2026 |
sheet.write(sheet_iterator, 56, math.ceil(amScraping.proposedSp))
|
| 2022 |
if Decision._VALUES_TO_NAMES.get(amScraping.decision) == "AUTO_INCREMENT_SUCCESS":
|
2027 |
if Decision._VALUES_TO_NAMES.get(amScraping.decision) == "AUTO_INCREMENT_SUCCESS":
|
| 2023 |
sheet.write(sheet_iterator, 56, min(math.ceil(amScraping.promoPrice+max(10,.01*amScraping.promoPrice)),amScraping.proposedSp))
|
2028 |
sheet.write(sheet_iterator, 56, min(math.ceil(amScraping.promoPrice+max(10,.01*amScraping.promoPrice)),amScraping.proposedSp))
|
| 2024 |
sheet.write(sheet_iterator, 57, getNewMargin(amScraping,amScraping.proposedSp))
|
2029 |
sheet.write(sheet_iterator, 57, getNewMargin(amScraping,amScraping.proposedSp))
|
| 2025 |
sheet.write(sheet_iterator, 58, getInventoryMovementStatus(amScraping))
|
2030 |
sheet.write(sheet_iterator, 58, getInventoryMovementStatus(amScraping))
|
| 2026 |
sheet.write(sheet_iterator, 59, amScraping.packagingLength)
|
- |
|
| 2027 |
sheet.write(sheet_iterator, 60, amScraping.packagingWidth)
|
- |
|
| 2028 |
sheet.write(sheet_iterator, 61, amScraping.packagingHeight)
|
- |
|
| 2029 |
sheet.write(sheet_iterator, 62, amScraping.packagingWeight)
|
- |
|
| 2030 |
sheet.write(sheet_iterator, 63, amScraping.isOversized)
|
- |
|
| 2031 |
sheet_iterator+=1
|
2031 |
sheet_iterator+=1
|
| 2032 |
|
2032 |
|
| 2033 |
amongCheapestItems = session.query(AmazonScrapingHistory,Item).join((Item,AmazonScrapingHistory.item_id==Item.id)).filter(AmazonScrapingHistory.competitiveCategory==CompetitionCategory.AMONG_CHEAPEST_CAN_COMPETE).filter(AmazonScrapingHistory.timestamp==timestamp).all()
|
2033 |
amongCheapestItems = session.query(AmazonScrapingHistory,Item).join((Item,AmazonScrapingHistory.item_id==Item.id)).filter(AmazonScrapingHistory.competitiveCategory==CompetitionCategory.AMONG_CHEAPEST_CAN_COMPETE).filter(AmazonScrapingHistory.timestamp==timestamp).all()
|
| 2034 |
for amongCheapestItem in amongCheapestItems:
|
2034 |
for amongCheapestItem in amongCheapestItems:
|
| 2035 |
amScraping = amongCheapestItem[0]
|
2035 |
amScraping = amongCheapestItem[0]
|
| Line 2118... |
Line 2118... |
| 2118 |
sheet.write(sheet_iterator, 50, str(inStockStats[2]))
|
2118 |
sheet.write(sheet_iterator, 50, str(inStockStats[2]))
|
| 2119 |
sheet.write(sheet_iterator, 51, getAvgSale(inStockStats[2], inStockStats[1]))
|
2119 |
sheet.write(sheet_iterator, 51, getAvgSale(inStockStats[2], inStockStats[1]))
|
| 2120 |
toDaysSale = getTodaysSale(sku)
|
2120 |
toDaysSale = getTodaysSale(sku)
|
| 2121 |
sheet.write(sheet_iterator, 52, toDaysSale[0])
|
2121 |
sheet.write(sheet_iterator, 52, toDaysSale[0])
|
| 2122 |
sheet.write(sheet_iterator, 53, str(toDaysSale[1]))
|
2122 |
sheet.write(sheet_iterator, 53, str(toDaysSale[1]))
|
| - |
|
2123 |
sheet.write(sheet_iterator, 59, amScraping.packagingLength)
|
| - |
|
2124 |
sheet.write(sheet_iterator, 60, amScraping.packagingWidth)
|
| - |
|
2125 |
sheet.write(sheet_iterator, 61, amScraping.packagingHeight)
|
| - |
|
2126 |
sheet.write(sheet_iterator, 62, amScraping.packagingWeight)
|
| - |
|
2127 |
sheet.write(sheet_iterator, 63, amScraping.isOversized)
|
| 2123 |
if amScraping.decision is None:
|
2128 |
if amScraping.decision is None:
|
| 2124 |
sheet.write(sheet_iterator, 54, 'Auto Pricing Inactive')
|
2129 |
sheet.write(sheet_iterator, 54, 'Auto Pricing Inactive')
|
| 2125 |
sheet.write(sheet_iterator, 57, getNewMargin(amScraping,amScraping.proposedSp))
|
2130 |
sheet.write(sheet_iterator, 57, getNewMargin(amScraping,amScraping.proposedSp))
|
| 2126 |
sheet.write(sheet_iterator, 58, getInventoryMovementStatus(amScraping))
|
2131 |
sheet.write(sheet_iterator, 58, getInventoryMovementStatus(amScraping))
|
| 2127 |
sheet_iterator+=1
|
2132 |
sheet_iterator+=1
|
| Line 2132... |
Line 2137... |
| 2132 |
sheet.write(sheet_iterator, 56, math.ceil(amScraping.proposedSp))
|
2137 |
sheet.write(sheet_iterator, 56, math.ceil(amScraping.proposedSp))
|
| 2133 |
if Decision._VALUES_TO_NAMES.get(amScraping.decision) == "AUTO_INCREMENT_SUCCESS":
|
2138 |
if Decision._VALUES_TO_NAMES.get(amScraping.decision) == "AUTO_INCREMENT_SUCCESS":
|
| 2134 |
sheet.write(sheet_iterator, 56, min(math.ceil(amScraping.promoPrice+max(10,.01*amScraping.promoPrice)),amScraping.proposedSp))
|
2139 |
sheet.write(sheet_iterator, 56, min(math.ceil(amScraping.promoPrice+max(10,.01*amScraping.promoPrice)),amScraping.proposedSp))
|
| 2135 |
sheet.write(sheet_iterator, 57, getNewMargin(amScraping,amScraping.proposedSp))
|
2140 |
sheet.write(sheet_iterator, 57, getNewMargin(amScraping,amScraping.proposedSp))
|
| 2136 |
sheet.write(sheet_iterator, 58, getInventoryMovementStatus(amScraping))
|
2141 |
sheet.write(sheet_iterator, 58, getInventoryMovementStatus(amScraping))
|
| 2137 |
sheet.write(sheet_iterator, 59, amScraping.packagingLength)
|
- |
|
| 2138 |
sheet.write(sheet_iterator, 60, amScraping.packagingWidth)
|
- |
|
| 2139 |
sheet.write(sheet_iterator, 61, amScraping.packagingHeight)
|
- |
|
| 2140 |
sheet.write(sheet_iterator, 62, amScraping.packagingWeight)
|
- |
|
| 2141 |
sheet.write(sheet_iterator, 63, amScraping.isOversized)
|
- |
|
| 2142 |
sheet_iterator+=1
|
2142 |
sheet_iterator+=1
|
| 2143 |
|
2143 |
|
| 2144 |
|
2144 |
|
| 2145 |
# sheet = wbk.add_sheet('Cheapest')
|
2145 |
# sheet = wbk.add_sheet('Cheapest')
|
| 2146 |
# xstr = lambda s: s or ""
|
2146 |
# xstr = lambda s: s or ""
|
| Line 2276... |
Line 2276... |
| 2276 |
sheet.write(sheet_iterator, 50, str(inStockStats[2]))
|
2276 |
sheet.write(sheet_iterator, 50, str(inStockStats[2]))
|
| 2277 |
sheet.write(sheet_iterator, 51, getAvgSale(inStockStats[2], inStockStats[1]))
|
2277 |
sheet.write(sheet_iterator, 51, getAvgSale(inStockStats[2], inStockStats[1]))
|
| 2278 |
toDaysSale = getTodaysSale(sku)
|
2278 |
toDaysSale = getTodaysSale(sku)
|
| 2279 |
sheet.write(sheet_iterator, 52, toDaysSale[0])
|
2279 |
sheet.write(sheet_iterator, 52, toDaysSale[0])
|
| 2280 |
sheet.write(sheet_iterator, 53, str(toDaysSale[1]))
|
2280 |
sheet.write(sheet_iterator, 53, str(toDaysSale[1]))
|
| - |
|
2281 |
sheet.write(sheet_iterator, 59, amScraping.packagingLength)
|
| - |
|
2282 |
sheet.write(sheet_iterator, 60, amScraping.packagingWidth)
|
| - |
|
2283 |
sheet.write(sheet_iterator, 61, amScraping.packagingHeight)
|
| - |
|
2284 |
sheet.write(sheet_iterator, 62, amScraping.packagingWeight)
|
| - |
|
2285 |
sheet.write(sheet_iterator, 63, amScraping.isOversized)
|
| 2281 |
if amScraping.decision is None:
|
2286 |
if amScraping.decision is None:
|
| 2282 |
sheet.write(sheet_iterator, 54, 'Auto Pricing Inactive')
|
2287 |
sheet.write(sheet_iterator, 54, 'Auto Pricing Inactive')
|
| 2283 |
sheet.write(sheet_iterator, 57, getNewMargin(amScraping,amScraping.proposedSp))
|
2288 |
sheet.write(sheet_iterator, 57, getNewMargin(amScraping,amScraping.proposedSp))
|
| 2284 |
sheet.write(sheet_iterator, 58, getInventoryMovementStatus(amScraping))
|
2289 |
sheet.write(sheet_iterator, 58, getInventoryMovementStatus(amScraping))
|
| 2285 |
sheet_iterator+=1
|
2290 |
sheet_iterator+=1
|
| Line 2290... |
Line 2295... |
| 2290 |
sheet.write(sheet_iterator, 56, math.ceil(amScraping.proposedSp))
|
2295 |
sheet.write(sheet_iterator, 56, math.ceil(amScraping.proposedSp))
|
| 2291 |
if Decision._VALUES_TO_NAMES.get(amScraping.decision) == "AUTO_INCREMENT_SUCCESS":
|
2296 |
if Decision._VALUES_TO_NAMES.get(amScraping.decision) == "AUTO_INCREMENT_SUCCESS":
|
| 2292 |
sheet.write(sheet_iterator, 56, min(math.ceil(amScraping.promoPrice+max(10,.01*amScraping.promoPrice)),amScraping.proposedSp))
|
2297 |
sheet.write(sheet_iterator, 56, min(math.ceil(amScraping.promoPrice+max(10,.01*amScraping.promoPrice)),amScraping.proposedSp))
|
| 2293 |
sheet.write(sheet_iterator, 57, getNewMargin(amScraping,math.ceil(amScraping.promoPrice+max(10,.01*amScraping.promoPrice))))
|
2298 |
sheet.write(sheet_iterator, 57, getNewMargin(amScraping,math.ceil(amScraping.promoPrice+max(10,.01*amScraping.promoPrice))))
|
| 2294 |
sheet.write(sheet_iterator, 58, getInventoryMovementStatus(amScraping))
|
2299 |
sheet.write(sheet_iterator, 58, getInventoryMovementStatus(amScraping))
|
| 2295 |
sheet.write(sheet_iterator, 59, amScraping.packagingLength)
|
- |
|
| 2296 |
sheet.write(sheet_iterator, 60, amScraping.packagingWidth)
|
- |
|
| 2297 |
sheet.write(sheet_iterator, 61, amScraping.packagingHeight)
|
- |
|
| 2298 |
sheet.write(sheet_iterator, 62, amScraping.packagingWeight)
|
- |
|
| 2299 |
sheet.write(sheet_iterator, 63, amScraping.isOversized)
|
- |
|
| 2300 |
sheet_iterator+=1
|
2300 |
sheet_iterator+=1
|
| 2301 |
|
2301 |
|
| 2302 |
exceptionCheapItems = session.query(AmazonScrapingHistory,Item).join((Item,AmazonScrapingHistory.item_id==Item.id)).filter(AmazonScrapingHistory.competitiveCategory==CompetitionCategory.EXCEPTION).filter(AmazonScrapingHistory.timestamp==timestamp)\
|
2302 |
exceptionCheapItems = session.query(AmazonScrapingHistory,Item).join((Item,AmazonScrapingHistory.item_id==Item.id)).filter(AmazonScrapingHistory.competitiveCategory==CompetitionCategory.EXCEPTION).filter(AmazonScrapingHistory.timestamp==timestamp)\
|
| 2303 |
.filter(or_(AmazonScrapingHistory.exceptionType==3,AmazonScrapingHistory.exceptionType==5)).all()
|
2303 |
.filter(or_(AmazonScrapingHistory.exceptionType==3,AmazonScrapingHistory.exceptionType==5)).all()
|
| 2304 |
|
2304 |
|