| 511 |
rajveer |
1 |
from shop2020.thriftpy.model.v1.catalog.ttypes import Item, status, Warehouse
|
|
|
2 |
import datetime
|
| 3133 |
rajveer |
3 |
from shop2020.clients.CatalogClient import CatalogClient
|
| 511 |
rajveer |
4 |
from shop2020.utils.Utils import to_java_date
|
|
|
5 |
import xlrd
|
|
|
6 |
|
| 3133 |
rajveer |
7 |
inventory_client = CatalogClient()
|
| 511 |
rajveer |
8 |
|
| 596 |
rajveer |
9 |
#inventory_client.__start__()
|
| 511 |
rajveer |
10 |
|
|
|
11 |
client = inventory_client.get_client()
|
|
|
12 |
|
|
|
13 |
|
| 515 |
rajveer |
14 |
#For accessories
|
| 596 |
rajveer |
15 |
"""
|
|
|
16 |
wb = xlrd.open_workbook('/home/rajveer/Desktop/test1.xls')
|
| 515 |
rajveer |
17 |
sheet = wb.sheet_by_index(0)
|
|
|
18 |
|
|
|
19 |
count = 1
|
|
|
20 |
for rownum in range(sheet.nrows):
|
|
|
21 |
|
|
|
22 |
if count < 16:
|
|
|
23 |
count = count + 1
|
|
|
24 |
continue
|
|
|
25 |
print sheet.row_values(count)
|
|
|
26 |
item = Item()
|
|
|
27 |
item.catalogItemId = sheet.row_values(count)[0]
|
|
|
28 |
item.category = sheet.row_values(count)[1]
|
| 963 |
chandransh |
29 |
item.brand = sheet.row_values(count)[2]
|
| 515 |
rajveer |
30 |
item.modelNumber = sheet.row_values(count)[3]
|
|
|
31 |
item.modelName = sheet.row_values(count)[4]
|
|
|
32 |
item.mrp = sheet.row_values(count)[5]
|
|
|
33 |
item.sellingPrice = sheet.row_values(count)[6]
|
|
|
34 |
item.vendorItemId = str(long(sheet.row_values(count)[8]))
|
|
|
35 |
|
|
|
36 |
item.itemStatus = status.ACTIVE
|
|
|
37 |
client.addItem(item)
|
|
|
38 |
count = count + 1
|
|
|
39 |
|
|
|
40 |
"""
|
| 596 |
rajveer |
41 |
|
| 515 |
rajveer |
42 |
#For phones
|
| 511 |
rajveer |
43 |
wb = xlrd.open_workbook('/home/rajveer/Desktop/phone-models.xls')
|
|
|
44 |
sheet = wb.sheet_by_index(0)
|
|
|
45 |
|
|
|
46 |
count = 0
|
|
|
47 |
for rownum in range(sheet.nrows):
|
|
|
48 |
#print sheet.row_values(rownum)
|
| 596 |
rajveer |
49 |
|
|
|
50 |
item = Item()
|
|
|
51 |
|
|
|
52 |
item.catalogItemId = long(sheet.row_values(count)[0])
|
|
|
53 |
#item.category = sheet.row_values(count)[1]
|
| 963 |
chandransh |
54 |
#item.brand = sheet.row_values(count)[2]
|
| 596 |
rajveer |
55 |
#item.modelNumber = sheet.row_values(count)[3]
|
|
|
56 |
#item.modelName = sheet.row_values(count)[4]
|
|
|
57 |
#item.mrp = long(sheet.row_values(count)[5])
|
|
|
58 |
#item.sellingPrice = long(sheet.row_values(count)[6])
|
|
|
59 |
|
|
|
60 |
item.mrp = 981*(count+1)
|
|
|
61 |
item.sellingPrice = 819*(count+1)
|
|
|
62 |
item.vendorItemId = "CBHCC"+str(count)
|
| 511 |
rajveer |
63 |
item.itemStatus = status.ACTIVE
|
| 2035 |
rajveer |
64 |
item.status_description = "This item is active"
|
| 596 |
rajveer |
65 |
client.addItem(item)
|