| Line 32... |
Line 32... |
| 32 |
|
32 |
|
| 33 |
existing_vendor_item_mappings = VendorItemMapping.query.filter_by(vendor=vendor, vendor_category=category).all()
|
33 |
existing_vendor_item_mappings = VendorItemMapping.query.filter_by(vendor=vendor, vendor_category=category).all()
|
| 34 |
existing_vendor_item_mappings_set = set([mapping.item_key for mapping in existing_vendor_item_mappings])
|
34 |
existing_vendor_item_mappings_set = set([mapping.item_key for mapping in existing_vendor_item_mappings])
|
| 35 |
|
35 |
|
| 36 |
for rownum in range(1, num_rows):
|
36 |
for rownum in range(1, num_rows):
|
| 37 |
#print sheet.row_values(rownum)
|
37 |
print sheet.row_values(rownum)
|
| 38 |
catalog_item_id, category_id = [None, None]
|
38 |
catalog_item_id, category_id = [None, None]
|
| 39 |
|
39 |
|
| 40 |
if supplied_product_group != '':
|
40 |
if supplied_product_group != None and supplied_product_group != '':
|
| 41 |
our_brand, our_model_number, our_color,\
|
41 |
our_brand, our_model_number, our_color,\
|
| 42 |
brand, model_number, model_name, color,\
|
42 |
brand, model_number, model_name, color,\
|
| 43 |
dp, mrp, mop, sp,\
|
43 |
dp, mrp, mop, sp,\
|
| 44 |
comments, hotspot_category, unused_feature, xfer_price, weight, start_date, deal_text, deal_value = sheet.row_values(rownum)[0:19]
|
44 |
comments, hotspot_category, unused_feature, xfer_price, weight, start_date, deal_text, deal_value = sheet.row_values(rownum)[0:19]
|
| 45 |
product_group = supplied_product_group
|
45 |
product_group = supplied_product_group
|
| Line 47... |
Line 47... |
| 47 |
our_brand, our_model_number, our_color,\
|
47 |
our_brand, our_model_number, our_color,\
|
| 48 |
product_group, brand, model_number, model_name, color,\
|
48 |
product_group, brand, model_number, model_name, color,\
|
| 49 |
dp, mrp, mop, sp,\
|
49 |
dp, mrp, mop, sp,\
|
| 50 |
comments, hotspot_category, unused_feature, xfer_price, weight, start_date, deal_text, deal_value = sheet.row_values(rownum)[0:20]
|
50 |
comments, hotspot_category, unused_feature, xfer_price, weight, start_date, deal_text, deal_value = sheet.row_values(rownum)[0:20]
|
| 51 |
|
51 |
|
| - |
|
52 |
print product_group
|
| - |
|
53 |
|
| 52 |
if isinstance(model_number, float):
|
54 |
if isinstance(model_number, float):
|
| 53 |
model_number = str(int(model_number))
|
55 |
model_number = str(int(model_number))
|
| 54 |
|
56 |
|
| 55 |
if our_brand == '':
|
57 |
if our_brand == '':
|
| 56 |
our_brand = brand
|
58 |
our_brand = brand
|
| Line 200... |
Line 202... |
| 200 |
def write_report(filename, items, sheet, is_item):
|
202 |
def write_report(filename, items, sheet, is_item):
|
| 201 |
items_writer = csv.writer(open(filename, "wb"), delimiter=',', quoting=csv.QUOTE_ALL)
|
203 |
items_writer = csv.writer(open(filename, "wb"), delimiter=',', quoting=csv.QUOTE_ALL)
|
| 202 |
items_writer.writerow(sheet.row_values(0) + ['Old MRP', 'Old DP', 'Old TP'])
|
204 |
items_writer.writerow(sheet.row_values(0) + ['Old MRP', 'Old DP', 'Old TP'])
|
| 203 |
if is_item:
|
205 |
if is_item:
|
| 204 |
for item in items:
|
206 |
for item in items:
|
| 205 |
#print item
|
207 |
print item
|
| 206 |
items_writer.writerow([str(value) for value in item])
|
208 |
items_writer.writerow([str(value) for value in item])
|
| 207 |
else:
|
209 |
else:
|
| 208 |
for i in items:
|
210 |
for i in items:
|
| 209 |
#print sheet.row_values(i)
|
211 |
print sheet.row_values(i)
|
| 210 |
items_writer.writerow([str(value) for value in sheet.row_values(i)])
|
212 |
items_writer.writerow([str(value) for value in sheet.row_values(i)])
|
| 211 |
|
213 |
|
| 212 |
def main():
|
214 |
def main():
|
| 213 |
parser = optparse.OptionParser()
|
215 |
parser = optparse.OptionParser()
|
| 214 |
parser.add_option("-f", "--file", dest="filename",
|
216 |
parser.add_option("-f", "--file", dest="filename",
|