| Line 1920... |
Line 1920... |
| 1920 |
<th>TP</th>
|
1920 |
<th>TP</th>
|
| 1921 |
<th>Lowest Possible SP</th>
|
1921 |
<th>Lowest Possible SP</th>
|
| 1922 |
<th>Lowest Possible TP</th>
|
1922 |
<th>Lowest Possible TP</th>
|
| 1923 |
<th>Margin</th>
|
1923 |
<th>Margin</th>
|
| 1924 |
<th>Margin %</th>
|
1924 |
<th>Margin %</th>
|
| - |
|
1925 |
<th>Commission %</th>
|
| - |
|
1926 |
<th>Return Provision %</th>
|
| 1925 |
<th>Snapdeal Inventory</th>
|
1927 |
<th>Snapdeal Inventory</th>
|
| 1926 |
<th>Total Inventory</th>
|
1928 |
<th>Total Inventory</th>
|
| 1927 |
<th>Sales History</th>
|
1929 |
<th>Sales History</th>
|
| 1928 |
</tr></thead>
|
1930 |
</tr></thead>
|
| 1929 |
<tbody>"""
|
1931 |
<tbody>"""
|
| Line 1933... |
Line 1935... |
| 1933 |
netInventory=''
|
1935 |
netInventory=''
|
| 1934 |
if not inventoryMap.has_key(mpHistory.item_id):
|
1936 |
if not inventoryMap.has_key(mpHistory.item_id):
|
| 1935 |
netInventory='Info Not Available'
|
1937 |
netInventory='Info Not Available'
|
| 1936 |
else:
|
1938 |
else:
|
| 1937 |
netInventory = str(getNetAvailability(inventoryMap.get(mpHistory.item_id)))
|
1939 |
netInventory = str(getNetAvailability(inventoryMap.get(mpHistory.item_id)))
|
| - |
|
1940 |
mpItem = MarketplaceItems.get_by(itemId=mpHistory.item_id,source=OrderSource.SNAPDEAL)
|
| 1938 |
message+="""<tr>
|
1941 |
message+="""<tr>
|
| 1939 |
<td style="text-align:center">"""+str(mpHistory.item_id)+"""</td>
|
1942 |
<td style="text-align:center">"""+str(mpHistory.item_id)+"""</td>
|
| 1940 |
<td style="text-align:center">"""+xstr(catItem.brand)+" "+xstr(catItem.model_name)+" "+xstr(catItem.model_number)+" "+xstr(catItem.color)+"""</td>
|
1943 |
<td style="text-align:center">"""+xstr(catItem.brand)+" "+xstr(catItem.model_name)+" "+xstr(catItem.model_number)+" "+xstr(catItem.color)+"""</td>
|
| 1941 |
<td style="text-align:center">"""+str(mpHistory.ourSellingPrice)+"""</td>
|
1944 |
<td style="text-align:center">"""+str(mpHistory.ourSellingPrice)+"""</td>
|
| 1942 |
<td style="text-align:center">"""+str(mpHistory.ourTp)+"""</td>
|
1945 |
<td style="text-align:center">"""+str(mpHistory.ourTp)+"""</td>
|
| 1943 |
<td style="text-align:center">"""+str(mpHistory.lowestPossibleSp)+"""</td>
|
1946 |
<td style="text-align:center">"""+str(mpHistory.lowestPossibleSp)+"""</td>
|
| 1944 |
<td style="text-align:center">"""+str(mpHistory.lowestPossibleTp)+"""</td>
|
1947 |
<td style="text-align:center">"""+str(mpHistory.lowestPossibleTp)+"""</td>
|
| 1945 |
<td style="text-align:center">"""+str(mpHistory.margin)+"""</td>
|
1948 |
<td style="text-align:center">"""+str(mpHistory.margin)+"""</td>
|
| 1946 |
<td style="text-align:center">"""+str(round(mpHistory.margin/mpHistory.ourSellingPrice,2))+"""</td>
|
1949 |
<td style="text-align:center">"""+str(round(mpHistory.margin/mpHistory.ourSellingPrice,2))+"""</td>
|
| - |
|
1950 |
<td style="text-align:center">"""+str(mpItem.commission)+"""</td>
|
| - |
|
1951 |
<td style="text-align:center">"""+str(mpItem.returnProvision)+" %"+"""</td>
|
| 1947 |
<td style="text-align:center">"""+str(mpHistory.ourInventory)+"""</td>
|
1952 |
<td style="text-align:center">"""+str(mpHistory.ourInventory)+"""</td>
|
| 1948 |
<td style="text-align:center">"""+netInventory+"""</td>
|
1953 |
<td style="text-align:center">"""+netInventory+"""</td>
|
| 1949 |
<td style="text-align:center">"""+getOosString((itemSaleMap.get(mpHistory.item_id))[1])+"""</td>
|
1954 |
<td style="text-align:center">"""+getOosString((itemSaleMap.get(mpHistory.item_id))[1])+"""</td>
|
| 1950 |
</tr>"""
|
1955 |
</tr>"""
|
| 1951 |
message+="""</tbody></table></body></html>"""
|
1956 |
message+="""</tbody></table></body></html>"""
|