def gmarket(order_ws):
print('-------지마켓,옥션 파일 분석중---------')
file_order = {}
row_index = 0
for r in order_ws.rows:
if r[0].value == None: continue
elif r[0].value == '아이디': continue
cate = change_category(r[8].value)
file_order['category' + str(row_index)] = cate
if r[0].value == '지마켓(4seasonst)':
file_order['path' + str(row_index)] = 'g마켓'
elif r[0].value == '옥션(4seasonst)':
file_order['path' + str(row_index)] = '옥션'
file_order['product' + str(row_index)] = r[8].value
file_order['option' + str(row_index)] = r[10].value
file_order['count' + str(row_index)] = r[9].value
file_order['price' + str(row_index)] = r[4].value
file_order['delivery' + str(row_index)] = r[20].value
file_order['orderer' + str(row_index)] = r[6].value
file_order['payee' + str(row_index)] = r[12].value
file_order['call' + str(row_index)] = r[13].value
file_order['address' + str(row_index)] = r[16].value
file_order['postal_code' + str(row_index)] = r[15].value
file_order['message' + str(row_index)] = r[17].value
row_index += 1
return file_order, row_index
def naverpay(order_ws):
print('-------네이버페이 파일 분석중---------')
file_order = {}
row_index = 0
for r in order_ws.rows:
if r[0].value == None: continue
elif r[0].value == '상품주문번호': continue
cate = change_category(r[15].value)
file_order['category' + str(row_index)] = cate
file_order['path' + str(row_index)] = '네이버페이'
file_order['product' + str(row_index)] = r[15].value
file_order['option' + str(row_index)] = r[17].value
file_order['count' + str(row_index)] = r[19].value
file_order['price' + str(row_index)] = r[24].value
file_order['delivery' + str(row_index)] = r[31].value
file_order['orderer' + str(row_index)] = r[2].value
file_order['payee' + str(row_index)] = r[9].value
file_order['call' + str(row_index)] = r[33].value
file_order['address' + str(row_index)] = r[35].value
file_order['postal_code' + str(row_index)] = r[37].value
file_order['message' + str(row_index)] = r[38].value
row_index += 1
return file_order, row_index
def eleven(order_ws):
print('-------11번가 파일 분석중---------')
file_order = {}
row_index = 0
for r in order_ws.rows:
if r[0].value == None: continue
elif r[0].value == '번호': continue
cate = change_category(r[1].value)
file_order['category' + str(row_index)] = cate
file_order['path' + str(row_index)] = '11번가'
file_order['product' + str(row_index)] = r[1].value
file_order['option' + str(row_index)] = r[2].value
file_order['count' + str(row_index)] = r[3].value
file_order['price' + str(row_index)] = r[4].value
file_order['delivery' + str(row_index)] = r[6].value
file_order['orderer' + str(row_index)] = r[12].value
file_order['payee' + str(row_index)] = r[7].value
file_order['call' + str(row_index)] = r[8].value
file_order['address' + str(row_index)] = r[10].value
file_order['postal_code' + str(row_index)] = r[9].value
file_order['message' + str(row_index)] = r[11].value
row_index += 1
return file_order, row_index
def kim(order_ws):
print('-------김약사몰 파일 분석중---------')
file_order = {}
row_index = 0
for r in order_ws.rows:
if r[0].value == None: continue
elif r[0].value == '주문번호': continue
cate = change_category(r[8].value)
file_order['category' + str(row_index)] = cate
file_order['path' + str(row_index)] = '위메프'
file_order['product' + str(row_index)] = r[8].value
file_order['option' + str(row_index)] = r[10].value
file_order['count' + str(row_index)] = r[11].value
file_order['price' + str(row_index)] = r[12].value
file_order['delivery' + str(row_index)] = r[17].value
file_order['orderer' + str(row_index)] = r[6].value
file_order['payee' + str(row_index)] = r[13].value
file_order['call' + str(row_index)] = r[14].value
file_order['address' + str(row_index)] = r[16].value
file_order['postal_code' + str(row_index)] = r[15].value
file_order['message' + str(row_index)] = r[18].value
row_index += 1
return file_order, row_index
def coupang(order_ws):
print('-------쿠팡 파일 분석중---------')
file_order = {}
row_index = 0
for r in order_ws.rows:
if r[0].value == None: continue
elif r[0].value == '번호': continue
cate = change_category(r[10].value)
file_order['category' + str(row_index)] = cate
file_order['path' + str(row_index)] = '쿠팡'
file_order['product' + str(row_index)] = r[10].value
file_order['option' + str(row_index)] = r[12].value
file_order['count' + str(row_index)] = r[22].value
file_order['price' + str(row_index)] = r[18].value
file_order['delivery' + str(row_index)] = r[20].value
file_order['orderer' + str(row_index)] = r[24].value
file_order['payee' + str(row_index)] = r[27].value
file_order['call' + str(row_index)] = r[28].value
file_order['address' + str(row_index)] = r[30].value
file_order['postal_code' + str(row_index)] = r[29].value
file_order['message' + str(row_index)] = r[31].value
row_index += 1
return file_order, row_index