| Line 136... |
Line 136... |
| 136 |
one_line = _SnapdealItemInfo(sheet.row_values(rownum)[0], '', '', 0, '', '','', '', 0, '', False,"item_related")
|
136 |
one_line = _SnapdealItemInfo(sheet.row_values(rownum)[0], '', '', 0, '', '','', '', 0, '', False,"item_related")
|
| 137 |
all_supc.append(supc)
|
137 |
all_supc.append(supc)
|
| 138 |
all_lines.append(one_line)
|
138 |
all_lines.append(one_line)
|
| 139 |
continue
|
139 |
continue
|
| 140 |
|
140 |
|
| 141 |
category = Category.query.filter_by(id=item.id).one()
|
141 |
category = Category.query.filter_by(id=item.category).one()
|
| 142 |
parent_category = Category.query.filter_by(parent_category_id=category.parent_category_id).first()
|
142 |
parent_category = Category.query.filter_by(parent_category_id=category.parent_category_id).first()
|
| 143 |
try:
|
143 |
try:
|
| 144 |
snapdeal_item = SnapdealItem.query.filter_by(item_id=item.id).one()item_id
|
144 |
snapdeal_item = SnapdealItem.query.filter_by(item_id=item.id).one()
|
| 145 |
warehouse = iclient.getWarehouse(snapdeal_item.warehouseId)
|
145 |
warehouse = iclient.getWarehouse(snapdeal_item.warehouseId)
|
| 146 |
item_pricing = iclient.getItemPricing(item.id, warehouse.vendor.id)
|
146 |
item_pricing = iclient.getItemPricing(item.id, warehouse.vendor.id)
|
| 147 |
one_line = _SnapdealItemInfo(item.id, item.product_group, parent_category.display_name, item_pricing.nlc, item.brand, item.model_name, item.model_number, item.color, item.weight, category.parent_category_id, item.risky,"")
|
147 |
one_line = _SnapdealItemInfo(item.id, item.product_group, parent_category.display_name, item_pricing.nlc, item.brand, item.model_name, item.model_number, item.color, item.weight, category.parent_category_id, item.risky,"")
|
| 148 |
except Exception as e:
|
148 |
except Exception as e:
|
| 149 |
print "Problem with item id ",item.id
|
149 |
print "Problem with item id ",item.id
|