| Line 2379... |
Line 2379... |
| 2379 |
<th>Preffered Seller</th>
|
2379 |
<th>Preffered Seller</th>
|
| 2380 |
<th>Preffered Seller SP</th>
|
2380 |
<th>Preffered Seller SP</th>
|
| 2381 |
<th>Preffered Seller Rating</th>
|
2381 |
<th>Preffered Seller Rating</th>
|
| 2382 |
<th>Preffered Seller Shipping Time</th>
|
2382 |
<th>Preffered Seller Shipping Time</th>
|
| 2383 |
<th>Price Variance %</th>
|
2383 |
<th>Price Variance %</th>
|
| - |
|
2384 |
<th>Commission %</th>
|
| - |
|
2385 |
<th>Return Provision %</th>
|
| 2384 |
<th>Flipkart Inventory</th>
|
2386 |
<th>Flipkart Inventory</th>
|
| 2385 |
<th>Total Inventory</th>
|
2387 |
<th>Total Inventory</th>
|
| 2386 |
<th>Sales History</th>
|
2388 |
<th>Sales History</th>
|
| 2387 |
</tr></thead>
|
2389 |
</tr></thead>
|
| 2388 |
<tbody>"""
|
2390 |
<tbody>"""
|
| Line 2394... |
Line 2396... |
| 2394 |
netInventory='Info Not Available'
|
2396 |
netInventory='Info Not Available'
|
| 2395 |
else:
|
2397 |
else:
|
| 2396 |
netInventory = str(getNetAvailability(inventoryMap.get(mpHistory.item_id)))
|
2398 |
netInventory = str(getNetAvailability(inventoryMap.get(mpHistory.item_id)))
|
| 2397 |
ourSt = mpHistory.ourShippingTime.split('-')
|
2399 |
ourSt = mpHistory.ourShippingTime.split('-')
|
| 2398 |
pfSt = mpHistory.prefferedSellerShippingTime.split('-')
|
2400 |
pfSt = mpHistory.prefferedSellerShippingTime.split('-')
|
| - |
|
2401 |
mpItem = MarketplaceItems.get_by(itemId=mpHistory.item_id,source=OrderSource.FLIPKART)
|
| 2399 |
if mpHistory.prefferedSellerName=='WS Retail' and mpHistory.ourRating > mpHistory.prefferedSellerRating and int(ourSt[0])<=int(pfSt[0]):
|
2402 |
if mpHistory.prefferedSellerName=='WS Retail' and mpHistory.ourRating > mpHistory.prefferedSellerRating and int(ourSt[0])<=int(pfSt[0]):
|
| 2400 |
style="""background-color:red;\""""
|
2403 |
style="""background-color:red;\""""
|
| 2401 |
else:
|
2404 |
else:
|
| 2402 |
style="\""
|
2405 |
style="\""
|
| 2403 |
message+="""<tr>
|
2406 |
message+="""<tr>
|
| Line 2409... |
Line 2412... |
| 2409 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.prefferedSellerName)+"""</td>
|
2412 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.prefferedSellerName)+"""</td>
|
| 2410 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.prefferedSellerSellingPrice)+"""</td>
|
2413 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.prefferedSellerSellingPrice)+"""</td>
|
| 2411 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.prefferedSellerRating)+"""</td>
|
2414 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.prefferedSellerRating)+"""</td>
|
| 2412 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.prefferedSellerShippingTime)+"""</td>
|
2415 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.prefferedSellerShippingTime)+"""</td>
|
| 2413 |
<td style="text-align:center;"""+str(style)+""">"""+str(round(((mpHistory.prefferedSellerSellingPrice-mpHistory.ourSellingPrice)/mpHistory.ourSellingPrice)*100))+"%"+"""</td>
|
2416 |
<td style="text-align:center;"""+str(style)+""">"""+str(round(((mpHistory.prefferedSellerSellingPrice-mpHistory.ourSellingPrice)/mpHistory.ourSellingPrice)*100))+"%"+"""</td>
|
| - |
|
2417 |
<td style="text-align:center">"""+str(mpItem.commission)+"""</td>
|
| - |
|
2418 |
<td style="text-align:center">"""+str(mpItem.returnProvision)+" %"+"""</td>
|
| 2414 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.ourInventory)+"""</td>
|
2419 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.ourInventory)+"""</td>
|
| 2415 |
<td style="text-align:center;"""+str(style)+""">"""+netInventory+"""</td>
|
2420 |
<td style="text-align:center;"""+str(style)+""">"""+netInventory+"""</td>
|
| 2416 |
<td style="text-align:center;"""+str(style)+""">"""+getOosString((itemSaleMap.get(mpHistory.item_id))[1])+"""</td>
|
2421 |
<td style="text-align:center;"""+str(style)+""">"""+getOosString((itemSaleMap.get(mpHistory.item_id))[1])+"""</td>
|
| 2417 |
</tr>"""
|
2422 |
</tr>"""
|
| 2418 |
message+="""</tbody></table></body></html>"""
|
2423 |
message+="""</tbody></table></body></html>"""
|