| Line 2210... |
Line 2210... |
| 2210 |
item = negativeMarginItems[1]
|
2210 |
item = negativeMarginItems[1]
|
| 2211 |
if amScraping.warehouseLocation==1:
|
2211 |
if amScraping.warehouseLocation==1:
|
| 2212 |
sku='FBA'+str(amScraping.item_id)
|
2212 |
sku='FBA'+str(amScraping.item_id)
|
| 2213 |
else:
|
2213 |
else:
|
| 2214 |
sku='FBB'+str(amScraping.item_id)
|
2214 |
sku='FBB'+str(amScraping.item_id)
|
| 2215 |
if amazonLongTermActivePromotions.has_key(amScraping.sku):
|
2215 |
if amazonLongTermActivePromotions.has_key(sku):
|
| 2216 |
subsidy = (amazonLongTermActivePromotions.get(amScraping.sku)).subsidy
|
2216 |
subsidy = (amazonLongTermActivePromotions.get(sku)).subsidy
|
| 2217 |
elif amazonShortTermActivePromotions.has_key(amScraping.sku):
|
2217 |
elif amazonShortTermActivePromotions.has_key(sku):
|
| 2218 |
subsidy = (amazonShortTermActivePromotions.get(sku)).subsidy
|
2218 |
subsidy = (amazonShortTermActivePromotions.get(sku)).subsidy
|
| 2219 |
else:
|
2219 |
else:
|
| 2220 |
subsidy = 0
|
2220 |
subsidy = 0
|
| 2221 |
message+="""<tr>
|
2221 |
message+="""<tr>
|
| 2222 |
<td style="text-align:center">"""+str(amScraping.item_id)+"""</td>
|
2222 |
<td style="text-align:center">"""+str(amScraping.item_id)+"""</td>
|
| 2223 |
<td style="text-align:center">"""+amScraping.sku+"""</td>
|
2223 |
<td style="text-align:center">"""+sku+"""</td>
|
| 2224 |
<td style="text-align:center">"""+xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color)+"""</td>
|
2224 |
<td style="text-align:center">"""+xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color)+"""</td>
|
| 2225 |
<td style="text-align:center">"""+str(amScraping.ourSellingPrice)+"""</td>
|
2225 |
<td style="text-align:center">"""+str(amScraping.ourSellingPrice)+"""</td>
|
| 2226 |
<td style="text-align:center">"""+str(amScraping.promoPrice)+"""</td>
|
2226 |
<td style="text-align:center">"""+str(amScraping.promoPrice)+"""</td>
|
| 2227 |
<td style="text-align:center">"""+str(subsidy)+"""</td>
|
2227 |
<td style="text-align:center">"""+str(subsidy)+"""</td>
|
| 2228 |
<td style="text-align:center">"""+str(amScraping.lowestPossibleSp)+"""</td>
|
2228 |
<td style="text-align:center">"""+str(amScraping.lowestPossibleSp)+"""</td>
|
| Line 2297... |
Line 2297... |
| 2297 |
item = Item.query.filter_by(id=amScraping.item_id).one()
|
2297 |
item = Item.query.filter_by(id=amScraping.item_id).one()
|
| 2298 |
if amScraping.warehouseLocation==1:
|
2298 |
if amScraping.warehouseLocation==1:
|
| 2299 |
sku='FBA'+str(amScraping.item_id)
|
2299 |
sku='FBA'+str(amScraping.item_id)
|
| 2300 |
else:
|
2300 |
else:
|
| 2301 |
sku='FBB'+str(amScraping.item_id)
|
2301 |
sku='FBB'+str(amScraping.item_id)
|
| 2302 |
if amazonLongTermActivePromotions.has_key(amScraping.sku):
|
2302 |
if amazonLongTermActivePromotions.has_key(sku):
|
| 2303 |
subsidy = (amazonLongTermActivePromotions.get(amScraping.sku)).subsidy
|
2303 |
subsidy = (amazonLongTermActivePromotions.get(sku)).subsidy
|
| 2304 |
elif amazonShortTermActivePromotions.has_key(amScraping.sku):
|
2304 |
elif amazonShortTermActivePromotions.has_key(sku):
|
| 2305 |
subsidy = (amazonShortTermActivePromotions.get(sku)).subsidy
|
2305 |
subsidy = (amazonShortTermActivePromotions.get(sku)).subsidy
|
| 2306 |
else:
|
2306 |
else:
|
| 2307 |
subsidy = 0
|
2307 |
subsidy = 0
|
| 2308 |
message+="""<tr>
|
2308 |
message+="""<tr>
|
| 2309 |
<td style="text-align:center">"""+str(amScraping.item_id)+"""</td>
|
2309 |
<td style="text-align:center">"""+str(amScraping.item_id)+"""</td>
|
| 2310 |
<td style="text-align:center">"""+amScraping.sku+"""</td>
|
2310 |
<td style="text-align:center">"""+sku+"""</td>
|
| 2311 |
<td style="text-align:center">"""+xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color)+"""</td>
|
2311 |
<td style="text-align:center">"""+xstr(item.brand)+" "+xstr(item.model_name)+" "+xstr(item.model_number)+" "+xstr(item.color)+"""</td>
|
| 2312 |
<td style="text-align:center">"""+str(amScraping.ourSellingPrice)+"""</td>
|
2312 |
<td style="text-align:center">"""+str(amScraping.ourSellingPrice)+"""</td>
|
| 2313 |
<td style="text-align:center">"""+str(amScraping.promoPrice)+"""</td>
|
2313 |
<td style="text-align:center">"""+str(amScraping.promoPrice)+"""</td>
|
| 2314 |
<td style="text-align:center">"""+str(subsidy)+"""</td>
|
2314 |
<td style="text-align:center">"""+str(subsidy)+"""</td>
|
| 2315 |
<td style="text-align:center">"""+str(amScraping.lowestPossibleSp)+"""</td>
|
2315 |
<td style="text-align:center">"""+str(amScraping.lowestPossibleSp)+"""</td>
|