New Function #57
closed[ADMIN] 상품 등록 관리/철도역관리 > 엑셀 업로드 (excel upload)
Description
1.Target menu
- 온라인몰 관리 > 상품 등록 관리 (product management
- 스마트 오더 관리 > 상품 등록 관리 (product management)
- 철도역 관리 > 철도역 관리 (station management)
2.Spec
- refer to attached ppt
Files
Updated by Deca Park over 1 year ago
- File Station_ExcelUpload_20230607.pptx Station_ExcelUpload_20230607.pptx added
- File 철도역등록_양식.xlsx 철도역등록_양식.xlsx added
- Description updated (diff)
Updated by Deca Park over 1 year ago
- Subject changed from [ADMIN] 상품 등록 관리 > 엑셀 업로드 (excel upload) to [ADMIN] 상품 등록 관리/철도역관리 > 엑셀 업로드 (excel upload)
Updated by Toby Pham over 1 year ago
- Status changed from New to Resolved
- Assignee changed from Toby Pham to Deca Park
Updated by Deca Park over 1 year ago
- File 철도역등록_양식_20230610-1.xlsx 철도역등록_양식_20230610-1.xlsx added
[Test Issues]
1.온라인몰 관리 > 상품 등록 관리 (product management)
스마트 오더 관리 > 상품 등록 관리 (product management)
1) 상품 엑셀 업로드 modal
a) append guide text like spec
- 많은 양의 상품을 한꺼번에 수정/등록할 때, 엑셀을 업로드하여 일괄 등록할 수 있습니다.
- 엑셀 양식은 '양식 다운' 버튼을 통해 다운로드할 수 있습니다.
2.철도역 관리 > 철도역 관리 (station management)
1) 철도역 엑셀 업로드 modal
a) append guide text like spec
- 많은 양의 철도역을 한꺼번에 수정/등록할 때, 엑셀을 업로드하여 일괄 등록할 수 있습니다.
- 엑셀 양식은 '양식 다운' 버튼을 통해 다운로드할 수 있습니다.
2) excel file upload (attach file: 철도역등록_양식_20230610-1.xlsx)
a) upload result
- excel row count: 1060
- real upload count: 888 (all data isn't created)
b) check why all row is not uploaded and lets fix
- station_lines: if can't find code value, set by NULL
Updated by Deca Park over 1 year ago
- Status changed from Resolved to Feedback
- Assignee changed from Deca Park to Toby Pham
Updated by Toby Pham over 1 year ago
- Status changed from Feedback to Resolved
- Assignee changed from Toby Pham to Deca Park
Updated by Deca Park over 1 year ago
- Status changed from Resolved to Feedback
- Assignee changed from Deca Park to Toby Pham
[Station excel upload]
1.logic
1) station_code (DB: st_station)
- 'S1000' was inserted mutlple times (no can't be over S1000)
Updated by Toby Pham over 1 year ago
- Status changed from Feedback to Resolved
- Assignee changed from Toby Pham to Deca Park
Updated by Deca Park over 1 year ago
[ADMIN] 철도역 관리 (station management)
1.철도역 엑셀 업로드 (excel upload)
1) logic
- when INSERT st_station, set smart_order_yn = 'N' (NEW)