| Line 119... |
Line 119... |
| 119 |
num_rows = sheet.nrows
|
119 |
num_rows = sheet.nrows
|
| 120 |
for rownum in range(1, num_rows):
|
120 |
for rownum in range(1, num_rows):
|
| 121 |
print sheet.row_values(rownum)
|
121 |
print sheet.row_values(rownum)
|
| 122 |
try:
|
122 |
try:
|
| 123 |
item_id = int(sheet.row_values(rownum)[0])
|
123 |
item_id = int(sheet.row_values(rownum)[0])
|
| - |
|
124 |
print "sku is",item_id
|
| 124 |
supc = sheet.row_values(rownum)[1]
|
125 |
supc = sheet.row_values(rownum)[1]
|
| - |
|
126 |
print "supc is",supc
|
| 125 |
item = Item.query.filter_by(id=item_id).one()
|
127 |
item = Item.query.filter_by(id=item_id).one()
|
| 126 |
except Exception as e:
|
128 |
except Exception as e:
|
| 127 |
print "No item found.Maybe due to snapdeal item code in place of our sku id.Lets try again."
|
129 |
print "No item found.Maybe due to snapdeal item code in place of our sku id.Lets try again."
|
| 128 |
print e
|
130 |
print e
|
| 129 |
try:
|
131 |
try:
|
| 130 |
item_id = sheet.row_values(rownum)[0]
|
132 |
item_id = sheet.row_values(rownum)[0]
|
| - |
|
133 |
print "sku is",item_id
|
| 131 |
snapdeal_item = SnapdealItem.query.filter_by(skuAtSnapdeal=item_id).one()
|
134 |
snapdeal_item = SnapdealItem.query.filter_by(skuAtSnapdeal=item_id).one()
|
| 132 |
item = Item.query.filter_by(id=snapdeal_item.item_id).one()
|
135 |
item = Item.query.filter_by(id=snapdeal_item.item_id).one()
|
| - |
|
136 |
print "item is",item.id
|
| 133 |
except Exception as ex:
|
137 |
except Exception as ex:
|
| 134 |
print "Ahh...Still unable to find"
|
138 |
print "Ahh...Still unable to find"
|
| 135 |
print ex
|
139 |
print ex
|
| 136 |
one_line = _SnapdealItemInfo(sheet.row_values(rownum)[0], '', '', 0, '', '','', '', 0, '', False,"item_related")
|
140 |
one_line = _SnapdealItemInfo(sheet.row_values(rownum)[0], '', '', 0, '', '','', '', 0, '', False,"item_related")
|
| - |
|
141 |
print "appending supc",supc
|
| 137 |
all_supc.append(supc)
|
142 |
all_supc.append(supc)
|
| 138 |
all_lines.append(one_line)
|
143 |
all_lines.append(one_line)
|
| 139 |
continue
|
144 |
continue
|
| 140 |
|
145 |
|
| 141 |
category = Category.query.filter_by(id=item.category).one()
|
146 |
category = Category.query.filter_by(id=item.category).one()
|
| Line 152... |
Line 157... |
| 152 |
|
157 |
|
| 153 |
#TO BE USED LATER
|
158 |
#TO BE USED LATER
|
| 154 |
#inventory_snapshot = iclient.getInventorySnapshot(0)
|
159 |
#inventory_snapshot = iclient.getInventorySnapshot(0)
|
| 155 |
#warehouses_ours = iclient.getWarehouses(WarehouseType._NAMES_TO_VALUES.get("OURS"), InventoryType._NAMES_TO_VALUES.get("GOOD"), 0,0,0)
|
160 |
#warehouses_ours = iclient.getWarehouses(WarehouseType._NAMES_TO_VALUES.get("OURS"), InventoryType._NAMES_TO_VALUES.get("GOOD"), 0,0,0)
|
| 156 |
#warehouses_third_party = iclient.getWarehouses(WarehouseType._NAMES_TO_VALUES.get("THIRD_PARTY "), InventoryType._NAMES_TO_VALUES.get("GOOD"), 0,0,0)
|
161 |
#warehouses_third_party = iclient.getWarehouses(WarehouseType._NAMES_TO_VALUES.get("THIRD_PARTY "), InventoryType._NAMES_TO_VALUES.get("GOOD"), 0,0,0)
|
| - |
|
162 |
print "supc is final append",supc
|
| - |
|
163 |
print "item id",one_line.item_id
|
| 157 |
all_supc.append(supc)
|
164 |
all_supc.append(supc)
|
| 158 |
all_lines.append(one_line)
|
165 |
all_lines.append(one_line)
|
| 159 |
write_report("/tmp/snapdeal_running.xls", all_lines, all_supc)
|
166 |
write_report("/tmp/snapdeal_running.xls", all_lines, all_supc)
|
| 160 |
|
167 |
|
| 161 |
|
168 |
|