WebSVN – SmartDukaan – Diff – /trunk/PyProj/src/shop2020/model/v1/catalog/script/AmazonHistoryPopulator.py

             <th>Amazon SKU</th>
             <th>Product Name</th></tr></thead>
             <tbody>
             """
     for sku in notListed:
+        try:
-        it = Item.query.filter_by(id=int(sku[3:])).one()
+            it = Item.query.filter_by(id=int(sku[3:])).one()
+            productName = xstr(it.brand)+" "+xstr(it.model_name)+" "+xstr(it.model_number)+" "+xstr(it.color)
+        except:
+            it = None
+            productName = "Not found"
         message+="""<tr>
         <td style="text-align:center">"""+sku[3:]+"""</td>
         <td style="text-align:center">"""+sku+"""</td>
-        <td style="text-align:center">"""+xstr(it.brand)+" "+xstr(it.model_name)+" "+xstr(it.model_number)+" "+xstr(it.color)+"""</td>
+        <td style="text-align:center">"""+productName+"""</td>
         </tr>"""
     message+="""</tbody></table></body></html>"""
     print message
     mailServer = smtplib.SMTP("smtp.gmail.com", 587)
     mailServer.ehlo()

Subversion Repositories SmartDukaan