| Line 20... |
Line 20... |
| 20 |
sheet = workbook.sheet_by_index(0)
|
20 |
sheet = workbook.sheet_by_index(0)
|
| 21 |
num_rows = sheet.nrows
|
21 |
num_rows = sheet.nrows
|
| 22 |
updatedOn = datetime.datetime.now()
|
22 |
updatedOn = datetime.datetime.now()
|
| 23 |
for rownum in range(1, num_rows):
|
23 |
for rownum in range(1, num_rows):
|
| 24 |
print sheet.row_values(rownum)
|
24 |
print sheet.row_values(rownum)
|
| 25 |
brand, model_number, color, model_name, mrp, mop, dp, weight, start_date, deal_text, deal_value, comments, entity_id, category_id = sheet.row_values(rownum)[0:14]
|
25 |
brand, model_number, color, model_name, mrp, mop, dp, weight, start_date, deal_text, deal_value, comments, catalog_item_id, category_id = sheet.row_values(rownum)[0:14]
|
| 26 |
if isinstance(model_number, float):
|
26 |
if isinstance(model_number, float):
|
| 27 |
model_number = str(int(model_number))
|
27 |
model_number = str(int(model_number))
|
| 28 |
item = Item.get_by(manufacturer_name=brand, model_number=model_number, color=color)
|
28 |
item = Item.get_by(manufacturer_name=brand, model_number=model_number, color=color)
|
| 29 |
if item is None:
|
29 |
if item is None:
|
| 30 |
print "[ADDING:]{0} {1} {2} to our catalogue.".format(brand, model_number, color)
|
30 |
print "[ADDING:]{0} {1} {2} to our catalogue.".format(brand, model_number, color)
|
| Line 48... |
Line 48... |
| 48 |
#If it already exists for a brand and model_number, set it as same.
|
48 |
#If it already exists for a brand and model_number, set it as same.
|
| 49 |
item.catalog_item_id = similar_item.catalog_item_id
|
49 |
item.catalog_item_id = similar_item.catalog_item_id
|
| 50 |
|
50 |
|
| 51 |
#added category and entity id
|
51 |
#added category and entity id
|
| 52 |
'''
|
52 |
'''
|
| 53 |
item.catalog_item_id = int(entity_id)
|
53 |
item.catalog_item_id = int(catalog_item_id)
|
| 54 |
item.category = int(category_id)
|
54 |
item.category = int(category_id)
|
| 55 |
item.status = status.ACTIVE
|
55 |
item.status = status.ACTIVE
|
| 56 |
'''
|
56 |
'''
|
| 57 |
|
57 |
|
| 58 |
item.model_name = model_name
|
58 |
item.model_name = model_name
|