> For the complete documentation index, see [llms.txt](https://tech.x2bee.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://tech.x2bee.com/api/back-office-api/goods-bo-api/undefined-5.md).
# 상품 일괄 등록
## 상품일괄등록 엑셀 상품등록
> \## 기능설명\
> \* 상품일괄등록에서 업로드한 엑셀 파일의 상품 데이터를 저장합니다.\
> \---\
> \## 상세설명\
> \* 데이터 검증이 완료된 정상상품목록을 받아서 저장합니다.\
> \* 저장 언어는 디폴트 언어코드인 ko 기준으로 저장합니다.\
> \* 결제가능수단은 전체로 초기값 셋팅됩니다.\
> \* 표준분류에 매핑된 전시카테고리 리스트가 초기값으로 저장됩니다.\
> \---\
> \## 수정번호\
> \* Release v1.05\_231204 : 상품 엑셀 일괄등록 신규생성
```json
{"openapi":"3.1.0","info":{"title":"X2BEE BO API","version":"v1"},"servers":[{"url":"https://api-bo.x2bee.com/api/bo/","description":"prd"}],"security":[{"accessToken":[]}],"components":{"securitySchemes":{"accessToken":{"type":"http","name":"accessToken","scheme":"bearer","bearerFormat":"JWT"}},"schemas":{"ExcelUploadGoodsRequestV2":{"type":"object","description":"엑셀 상품 Request","properties":{"successYn":{"type":"string"},"goodsDuplicationYn":{"type":"string","description":"상품중복여부"},"errorMessage":{"type":"string","description":"에러메시지"},"entrNm":{"type":"string","description":"협력사명"},"stdCtgNm":{"type":"string","description":"표준카테고리명"},"goodsNotiLisartNm":{"type":"string","description":"고시품목명"},"goodsDuplication":{"type":"string","description":"상품중복확인"},"rowIndex":{"type":"integer","format":"int32","description":"엑셀행번호"},"goodsNo":{"type":"string","description":"상품번호"},"goodsCompCd":{"type":"string","description":"상품구성코드"},"goodsTypCd":{"type":"string","description":"상품유형코드"},"saleStatCd":{"type":"string","description":"판매상태코드"},"regInfPathCd":{"type":"string","description":"등록유입경로코드"},"deliGoodsGbCd":{"type":"string","description":"배송상품구분코드"},"deliWayCd":{"type":"string","description":"배송수단코드"},"deliPolcNo":{"type":"string","description":"배송정책번호"},"ordCnclPsbYn":{"type":"string","description":"취소가능여부"},"wthdYn":{"type":"string","description":"회수필요여부"},"goodsNm":{"type":"string","description":"상품명"},"entrNo":{"type":"string","description":"협력사번호"},"stdCtgNo":{"type":"string","description":"표준카테고리번호"},"lgcGoodsNo":{"type":"string","description":"자체상품번호"},"saleMethCd":{"type":"string","description":"판매방식코드"},"rsvStrDtm":{"type":"string","description":"예약주문가능시작일시"},"rsvEndDtm":{"type":"string","description":"예약주문가능종료일시"},"rsvEndSaleMeth":{"type":"string","description":"예약종료후판매방식"},"fwdidcPrarDy":{"type":"string","description":"예약상품출고지시일"},"modlNm":{"type":"string","description":"모델명"},"brandNo":{"type":"string","description":"브랜드번호"},"mfcoNm":{"type":"string","description":"제조사"},"homeNm":{"type":"string","description":"원산지"},"salemnNm":{"type":"string","description":"판매자"},"incomNm":{"type":"string","description":"수입자"},"frgnDirPurGoodsYn":{"type":"string","description":"직구상품 여부"},"saleStrDtmStr":{"type":"string","description":"판매시작일시(Excel)"},"saleStrDtm":{"type":"string","format":"date-time","description":"판매시작일시"},"saleEndDtmStr":{"type":"string","description":"판매종료일시"},"saleEndDtm":{"type":"string","format":"date-time","description":"판매종료일시"},"buyrAgeLmtCd":{"type":"string","description":"구입자나이제한코드"},"dispYn":{"type":"string","description":"전시여부"},"prcCompaExpYn":{"type":"string","description":"가격비교노출여부"},"schPsbYn":{"type":"string","description":"검색키워드 사용여부"},"schKwdNm":{"type":"string","description":"검색키워드"},"milgRsrvPsbYn":{"type":"string","description":"마일리지적립가능여부"},"gvgfPsbYn":{"type":"string","description":"선물하기가능여부"},"szGdeUseYn":{"type":"string","description":"사이즈가이드사용여부"},"szGdeRegMethodCd":{"type":"string","description":"사이즈가이드등록방법코드"},"szGdeCd":{"type":"string","description":"사이즈가이드코드"},"szGdeConts":{"type":"string","description":"사이즈가이드내용"},"buyTypCd":{"type":"string","description":"매입형태코드"},"taxGbCd":{"type":"string","description":"과/면세구분"},"supPcost":{"type":"number","description":"공급원가"},"norPrc":{"type":"number","description":"정상가"},"salePrc":{"type":"number","description":"판매가"},"mrgnRate":{"type":"number","description":"마진율"},"deliProcTypCd":{"type":"string","description":"배송처리유형코드"},"deliPsbRgnCd":{"type":"string","description":"배송가능지역"},"deliDday":{"type":"integer","format":"int32","description":"배송기일"},"hsCd":{"type":"string","description":"HS코드"},"bpckPsbYn":{"type":"string","description":"합배송가능여부"},"rtnPsbYn":{"type":"string","description":"반품가능여부"},"exchPsbYn":{"type":"string","description":"교환가능여부"},"rglrDeliGoodsYn":{"type":"string","description":"정기배송상품여부"},"stkMgrYn":{"type":"string","description":"재고관리여부"},"buyQtyLmtYn":{"type":"string","description":"구매수량제한여부"},"minLmtQty":{"type":"integer","format":"int32","description":"최소구매수량"},"maxLmtQty":{"type":"integer","format":"int32","description":"최대구매수량"},"safeStkNotiYn":{"type":"string","description":"안전재고알림여부"},"dtlDesc":{"type":"string","description":"상세설명"},"prGoodsContInfo":{"$ref":"#/components/schemas/PrGoodsContInfo","description":"상품컨텐츠정보"},"goodsNotiLisartCd":{"type":"string","description":"고시품목코드"},"goodsNotiItemCd1":{"type":"string","description":"고시항목1"},"notiItemCmt1":{"type":"string","description":"고시항목내용1"},"goodsNotiItemCd2":{"type":"string","description":"고시항목2"},"notiItemCmt2":{"type":"string","description":"고시항목내용2"},"goodsNotiItemCd3":{"type":"string","description":"고시항목3"},"notiItemCmt3":{"type":"string","description":"고시항목내용3"},"goodsNotiItemCd4":{"type":"string","description":"고시항목4"},"notiItemCmt4":{"type":"string","description":"고시항목내용4"},"goodsNotiItemCd5":{"type":"string","description":"고시항목5"},"notiItemCmt5":{"type":"string","description":"고시항목내용5"},"goodsNotiItemCd6":{"type":"string","description":"고시항목6"},"notiItemCmt6":{"type":"string","description":"고시항목내용6"},"goodsNotiItemCd7":{"type":"string","description":"고시항목7"},"notiItemCmt7":{"type":"string","description":"고시항목내용7"},"goodsNotiItemCd8":{"type":"string","description":"고시항목8"},"notiItemCmt8":{"type":"string","description":"고시항목내용8"},"goodsNotiItemCd9":{"type":"string","description":"고시항목9"},"notiItemCmt9":{"type":"string","description":"고시항목내용9"},"goodsNotiItemCd10":{"type":"string","description":"고시항목10"},"notiItemCmt10":{"type":"string","description":"고시항목내용10"},"goodsNotiItemCd11":{"type":"string","description":"고시항목11"},"notiItemCmt11":{"type":"string","description":"고시항목내용11"},"goodsNotiItemCd12":{"type":"string","description":"고시항목12"},"notiItemCmt12":{"type":"string","description":"고시항목내용12"},"goodsNotiItemCd13":{"type":"string","description":"고시항목13"},"notiItemCmt13":{"type":"string","description":"고시항목내용13"},"goodsNotiItemCd14":{"type":"string","description":"고시항목14"},"notiItemCmt14":{"type":"string","description":"고시항목내용14"},"safeCertiTgtYn":{"type":"string","description":"안전인증대상여부"},"safeCertiGbCd1":{"type":"string","description":"안전인증구분코드1"},"safeCertiOrnNm1":{"type":"string","description":"안전인증기관명1"},"safeCertiNo1":{"type":"string","description":"안전인증번호1"},"aplyStrDt1":{"type":"string","description":"안전인증적용시작일자1"},"aplyEndDt1":{"type":"string","description":"안전인증적용종료일자1"},"safeCertiGbCd2":{"type":"string","description":"안전인증구분코드2"},"safeCertiOrnNm2":{"type":"string","description":"안전인증기관명2"},"safeCertiNo2":{"type":"string","description":"안전인증번호2"},"aplyStrDt2":{"type":"string","description":"안전인증적용시작일자2"},"aplyEndDt2":{"type":"string","description":"안전인증적용종료일자2"},"safeCertiGbCd3":{"type":"string","description":"안전인증구분코드3"},"safeCertiOrnNm3":{"type":"string","description":"안전인증기관명3"},"safeCertiNo3":{"type":"string","description":"안전인증번호3"},"aplyStrDt3":{"type":"string","description":"안전인증적용시작일자3"},"aplyEndDt3":{"type":"string","description":"안전인증적용종료일자3"},"safeCertiGbCd4":{"type":"string","description":"안전인증구분코드4"},"safeCertiOrnNm4":{"type":"string","description":"안전인증기관명4"},"safeCertiNo4":{"type":"string","description":"안전인증번호4"},"aplyStrDt4":{"type":"string","description":"안전인증적용시작일자4"},"aplyEndDt4":{"type":"string","description":"안전인증적용종료일자4"},"safeCertiGbCd5":{"type":"string","description":"안전인증구분코드5"},"safeCertiOrnNm5":{"type":"string","description":"안전인증기관명5"},"safeCertiNo5":{"type":"string","description":"안전인증번호5"},"aplyStrDt5":{"type":"string","description":"안전인증적용시작일자5"},"aplyEndDt5":{"type":"string","description":"안전인증적용종료일자5"},"prAssocGoodsInfoList":{"$ref":"#/components/schemas/RealGridCUDRequestPrAssocGoodsInfo","description":"연계상품정보"},"prAdveWrdHistList":{"type":"array","description":"상품홍보문구이력","items":{"$ref":"#/components/schemas/PrAdveWrdHist"}},"prGoodsIconInfoList":{"$ref":"#/components/schemas/RealGridCUDRequestPrGoodsIconInfo","description":"상품 아이콘 정보"},"prGoodsAttInfoList":{"type":"array","description":"상품 카테고리 속성 정보","items":{"$ref":"#/components/schemas/PrGoodsAttInfo"}},"prRsvSaleHist":{"$ref":"#/components/schemas/PrRsvSaleHist","description":"예약판매이력"},"prGoodsItemInfoList":{"type":"array","description":"상품고시항목정보","items":{"$ref":"#/components/schemas/PrGoodsItemInfo"}},"prGoodsSafeCertiHistList":{"type":"array","description":"상품안전인증정보","items":{"$ref":"#/components/schemas/PrGoodsSafeCertiHist"}},"prGoodsPayMeanInfoList":{"type":"array","description":"상품결제수단정보","items":{"$ref":"#/components/schemas/PrGoodsPayMeanInfo"}},"prDispGoodsInfoList":{"$ref":"#/components/schemas/RealGridCUDRequestPrDispGoodsInfo","description":"전시카테고리"},"prGoodsPrceHist":{"$ref":"#/components/schemas/PrGoodsPrceHist","description":"상품가격이력"},"optnYn":{"type":"string","description":"옵션관리여부"},"prItmBase":{"$ref":"#/components/schemas/PrItmBase","description":"단품정보"}}},"PrGoodsContInfo":{"type":"object","description":"상품컨텐츠정보","properties":{"goodsNo":{"type":"string","description":"상품번호"},"contTypCd":{"type":"string","description":"컨텐츠유형코드(PR017) 01:상세설명, 02:동영상, 03:상품이미지"},"contSn":{"type":"string","description":"컨텐츠일련번호"},"goodsDtlDesc":{"type":"string","description":"상품상세설명"},"imgGbCd":{"type":"string","description":"이미지구분코드(PR031) P10:기본이미지, P20:추가이미지, M10:동영상"},"dispSeq":{"type":"integer","format":"int32","description":"전시순서"},"contFilePathNm":{"type":"string","description":"컨텐츠파일경로명"},"contFileNm":{"type":"string","description":"컨텐츠파일명"},"trnfTextCont":{"type":"string","description":"대체텍스트내용"},"useYn":{"type":"string","description":"사용여부"},"packageSubImageRegistDefaultValue":{"type":"integer","format":"int32","writeOnly":true}}},"RealGridCUDRequestPrAssocGoodsInfo":{"type":"object","properties":{"all":{"type":"array","items":{"$ref":"#/components/schemas/PrAssocGoodsInfo"}},"create":{"type":"array","items":{"$ref":"#/components/schemas/PrAssocGoodsInfo"}},"update":{"type":"array","items":{"$ref":"#/components/schemas/PrAssocGoodsInfo"}},"delete":{"type":"array","items":{"$ref":"#/components/schemas/PrAssocGoodsInfo"}}}},"PrAssocGoodsInfo":{"type":"object","description":"연관상품정보","properties":{"goodsNo":{"type":"string","description":"상품번호"},"asctGoodsNo":{"type":"string","description":"연관상품번호"},"asctGbCd":{"type":"string","description":"연관구분코드"},"sortSeq":{"type":"integer","format":"int32","description":"정렬순서"}}},"PrAdveWrdHist":{"type":"object","description":"상품홍보문구이력","properties":{"goodsNo":{"type":"string","description":"상품번호"},"aplyStrDtm":{"type":"string","format":"date-time","description":"적용시작일자"},"aplyEndDtm":{"type":"string","format":"date-time","description":"적용종료일자"},"adveWrd":{"type":"string","description":"홍보문구"},"useYn":{"type":"string","description":"사용여부"}}},"RealGridCUDRequestPrGoodsIconInfo":{"type":"object","properties":{"all":{"type":"array","items":{"$ref":"#/components/schemas/PrGoodsIconInfo"}},"create":{"type":"array","items":{"$ref":"#/components/schemas/PrGoodsIconInfo"}},"update":{"type":"array","items":{"$ref":"#/components/schemas/PrGoodsIconInfo"}},"delete":{"type":"array","items":{"$ref":"#/components/schemas/PrGoodsIconInfo"}}}},"PrGoodsIconInfo":{"type":"object","description":"상품아이콘정보","properties":{"siteNo":{"type":"string","description":"사이트번호"},"goodsNo":{"type":"string","description":"상품번호"},"dispIconNo":{"type":"string","description":"전시아이콘번호"},"siteNm":{"type":"string","description":"사이트명"},"iconNm":{"type":"string","description":"아이콘명"},"dispMediaCdNm":{"type":"string","description":"전시매체"},"iconTypCdNm":{"type":"string","description":"아이콘 유형"},"aplyStrDtm":{"type":"string","format":"date-time","description":"적용시작일시"},"aplyEndDtm":{"type":"string","format":"date-time","description":"적용종료일시"},"iconPathNm":{"type":"string","description":"아이콘 이미지 경로"},"delYn":{"type":"string","description":"삭제여부"}}},"PrGoodsAttInfo":{"type":"object","properties":{"langCd":{"type":"string","description":"언어코드(CM009)"},"goodsNo":{"type":"string","description":"상품번호"},"attCd":{"type":"string","description":"속성코드"},"attVal":{"type":"string","description":"속성값"},"stdCtgNo":{"type":"string","description":"표준카테고리번호"}}},"PrRsvSaleHist":{"type":"object","description":"예약판매이력","properties":{"goodsNo":{"type":"string","description":"상품번호"},"rsvStrtDtm":{"type":"string","format":"date-time","description":"예약시작일시"},"rsvEndDtm":{"type":"string","format":"date-time","description":"예약종료일시"},"rsvEndAfProcMethCd":{"type":"string","description":"예약종료후판매방식(PR011)"},"rsvStopYn":{"type":"string","description":"예약중단여부"},"rsvStopCausCd":{"type":"string","description":"예약중단사유코드(PR034)"},"rsvStopDtm":{"type":"string","format":"date-time","description":"예약중단일시"},"fwdidcPrarDy":{"type":"string","description":"출고지시예정일자"}}},"PrGoodsItemInfo":{"type":"object","description":"상품항목정보","properties":{"goodsNo":{"type":"string","description":"상품번호"},"goodsNotiLisartCd":{"type":"string","description":"상품고시항목코드"},"goodsNotiItemCd":{"type":"string","description":"상품고시품목코드"},"notiItemCmt":{"type":"string","description":"고시항목내용"}}},"PrGoodsSafeCertiHist":{"type":"object","description":"상품안전인증이력","properties":{"goodsNo":{"type":"string","description":"상품번호"},"safeCertiGbCd":{"type":"string","description":"안전인증구분코드"},"safeCertiNo":{"type":"string","description":"안전인증번호"},"aplyStrDt":{"type":"string","description":"적용시작일자"},"aplyEndDt":{"type":"string","description":"적용종료일자"},"safeCertiOrnNm":{"type":"string","description":"안전인증기관명"}}},"PrGoodsPayMeanInfo":{"type":"object","description":"상품겿제수단정보","properties":{"goodsNo":{"type":"string","description":"상품번호"},"payWayCd":{"type":"string","description":"결제수단코드"},"useYn":{"type":"string","description":"사용여부"}}},"RealGridCUDRequestPrDispGoodsInfo":{"type":"object","properties":{"all":{"type":"array","items":{"$ref":"#/components/schemas/PrDispGoodsInfo"}},"create":{"type":"array","items":{"$ref":"#/components/schemas/PrDispGoodsInfo"}},"update":{"type":"array","items":{"$ref":"#/components/schemas/PrDispGoodsInfo"}},"delete":{"type":"array","items":{"$ref":"#/components/schemas/PrDispGoodsInfo"}}}},"PrDispGoodsInfo":{"type":"object","description":"전시카테고리기본_상품정보","properties":{"goodsNo":{"type":"string","description":"상품번호"},"dispCtgNo":{"type":"string","description":"전시카테고리번호"},"dispYn":{"type":"string","description":"전시여부"},"errorMessage":{"type":"string","description":"오류메시지","readOnly":true},"goodsList":{"type":"array","description":"상품번호 리스트","items":{"type":"string"}},"goodsArray":{"type":"array","description":"상품번호 배열","items":{"type":"string"}},"itemList":{"type":"array","description":"단품번호 리스트","items":{"type":"string"}},"itemArray":{"type":"array","description":"단품번호 배열","items":{"type":"string"}},"goodsNm":{"type":"string","description":"상품명","readOnly":true},"goodsTypCd":{"type":"string","description":"상품유형","readOnly":true},"norPrc":{"type":"number","description":"정상가","readOnly":true},"salePrc":{"type":"number","description":"판매가","readOnly":true},"saleStatCd":{"type":"string","description":"판매상태","readOnly":true},"entrNm":{"type":"string","description":"협력사명","readOnly":true},"goodsImg":{"type":"string","description":"상품이미지","readOnly":true},"moodTagVal":{"type":"string","description":"무드","readOnly":true},"wght":{"type":"string","description":"가중치","readOnly":true}}},"PrGoodsPrceHist":{"type":"object","description":"상품가격이력","properties":{"goodsNo":{"type":"string","description":"상품번호"},"histStrDtm":{"type":"string","format":"date-time","description":"이력시작일시"},"histEndDtm":{"type":"string","format":"date-time","description":"이력종료일시"},"supPcost":{"type":"number","description":"공급원가"},"norPrc":{"type":"number","description":"정상가"},"salePrc":{"type":"number","description":"판매가"},"eventPrc":{"type":"number","description":"행사가"},"mrgnRate":{"type":"number","description":"마진율"},"goodsPrceTypCd":{"type":"string","description":"상품가격유형코드"},"prcChgCausCd":{"type":"string","description":"가격변경사유코드(PR033)"},"prcChgCausCdNm":{"type":"string","description":"가격변경사유"},"timeDealYn":{"type":"string","description":"타임딜 여부"},"supPcostByMrgn":{"type":"number","writeOnly":true}}},"PrItmBase":{"type":"object","description":"단품기본","properties":{"goodsNo":{"type":"string","description":"상품번호"},"itmNo":{"type":"string","description":"단품번호"},"optnCatNm1":{"type":"string","description":"옵션분류명_1"},"optnNm1":{"type":"string","description":"옵션명_1"},"optnCatNm2":{"type":"string","description":"옵션분류명_2"},"optnNm2":{"type":"string","description":"옵션명_2"},"optnCatNm3":{"type":"string","description":"옵션분류명_3"},"optnNm3":{"type":"string","description":"옵션명_3"},"optnCatNm4":{"type":"string","description":"옵션분류명_4"},"optnNm4":{"type":"string","description":"옵션명_4"},"optnCatNm5":{"type":"string","description":"옵션분류명_5"},"optnNm5":{"type":"string","description":"옵션명_5"},"lgcItmNo":{"type":"string","description":"자체단품번호"},"itmSaleStatCd":{"type":"string","description":"단품판매상태코드(PR005) 01:임시저장, 02:승인대기, 03:반려, 10:판매중, 20:품절, 40:판매종료"},"itmSaleStatCdNm":{"type":"string","description":"단품판매상태코드명"},"saleStatChgCausCd":{"type":"string","description":"판매상태변경사유코드(PR058) 41:판매종료(정상) 42:판매종료(삭제)"},"repItmYn":{"type":"string","description":"대표단품여부"},"dispSeq":{"type":"integer","format":"int32","description":"전시순서"},"addSupPcost":{"type":"number","description":"추가공급원가"},"addSalePrc":{"type":"number","description":"추가판매가"},"soutCausCd":{"type":"string","description":"품절사유코드(PR032) 10:발송불가 자동품절처리, 11:재고수량 0 품절처리, 12:관리자 수동품절처리, 13:익일배송지연 자동품절처리, 14:모든단품품절로 상품 품절처리, 15:예약상품 품절처리, 16:묶음상품 품절로 인한 품절"},"limtQty":{"type":"integer","format":"int32","description":"예약한정수량"},"stkQty":{"type":"integer","format":"int32","description":"재고수량"},"safeStkNotiYn":{"type":"string","description":"안전재고 알림여부"},"safeStkQty":{"type":"integer","format":"int32","description":"안전재고수량"},"optnCatNo1":{"type":"string","description":"옵션분류번호_1"},"optnNo1":{"type":"string","description":"옵션번호_1"},"optnCatNo2":{"type":"string","description":"옵션분류번호_2"},"optnNo2":{"type":"string","description":"옵션번호_2"},"optnCatNo3":{"type":"string","description":"옵션분류번호_3"},"optnNo3":{"type":"string","description":"옵션번호_3"},"optnCatNo4":{"type":"string","description":"옵션분류번호_4"},"optnNo4":{"type":"string","description":"옵션번호_4"},"optnCatNo5":{"type":"string","description":"옵션분류번호_5"},"optnNo5":{"type":"string","description":"옵션번호_5"},"giftRegistDefaultValue":{"type":"string","writeOnly":true},"addSupPcostByMargn":{"type":"number","writeOnly":true}}},"ResponseString":{"type":"object","properties":{"timestamp":{"type":"string","format":"date-time","description":"result time"},"code":{"type":"string","description":"result code"},"message":{"type":"string","description":"result message"},"isProcess":{"type":"boolean","description":"process check"},"payload":{"type":"string","description":"payload"},"error":{"type":"boolean","description":"is error"},"errors":{"type":"array","description":"validation error list","items":{"$ref":"#/components/schemas/ValidationError"}}}},"ValidationError":{"type":"object","properties":{"field":{"type":"string","description":"field"},"message":{"type":"string","description":"field message"}}},"ErrorCode":{"type":"object","properties":{"code":{"type":"string"},"message":{"type":"string"},"httpStatus":{"type":"integer","format":"int32"},"isProcess":{"type":"boolean"}}}}},"paths":{"/v2/goods/goodsBatchRegistApi/saveExcelGoodsList":{"post":{"tags":["상품 일괄 등록"],"summary":"상품일괄등록 엑셀 상품등록","description":"## 기능설명\n* 상품일괄등록에서 업로드한 엑셀 파일의 상품 데이터를 저장합니다.\n---\n## 상세설명\n* 데이터 검증이 완료된 정상상품목록을 받아서 저장합니다.\n* 저장 언어는 디폴트 언어코드인 ko 기준으로 저장합니다.\n* 결제가능수단은 전체로 초기값 셋팅됩니다.\n* 표준분류에 매핑된 전시카테고리 리스트가 초기값으로 저장됩니다.\n---\n## 수정번호\n* Release v1.05_231204 : 상품 엑셀 일괄등록 신규생성\n","operationId":"saveExcelGoodsList","requestBody":{"content":{"application/json":{"schema":{"type":"array","items":{"$ref":"#/components/schemas/ExcelUploadGoodsRequestV2"}}}},"required":true},"responses":{"200":{"description":"상품일괄등록 엑셀 상품등록 성공","content":{"*/*":{"schema":{"$ref":"#/components/schemas/ResponseString"}}}},"900":{"description":"상품일괄등록 엑셀 상품등록 실패","content":{"*/*":{"schema":{"$ref":"#/components/schemas/ErrorCode"}}}}}}}}}
```
## 상품일괄등록 화면 \_ 엑셀파일 저장 및 엑셀 데이터 확인
> 상품일괄등록 화면에서 엑셀파일 저장 및 엑셀 데이터 확인을 합니다.
```json
{"openapi":"3.1.0","info":{"title":"X2BEE BO API","version":"v1"},"servers":[{"url":"https://api-bo.x2bee.com/api/bo/","description":"prd"}],"security":[{"accessToken":[]}],"components":{"securitySchemes":{"accessToken":{"type":"http","name":"accessToken","scheme":"bearer","bearerFormat":"JWT"}},"schemas":{"ResponseBatchRegistRequestV2":{"type":"object","properties":{"timestamp":{"type":"string","format":"date-time","description":"result time"},"code":{"type":"string","description":"result code"},"message":{"type":"string","description":"result message"},"isProcess":{"type":"boolean","description":"process check"},"payload":{"$ref":"#/components/schemas/BatchRegistRequestV2","description":"payload"},"error":{"type":"boolean","description":"is error"},"errors":{"type":"array","description":"validation error list","items":{"$ref":"#/components/schemas/ValidationError"}}}},"BatchRegistRequestV2":{"type":"object","description":"상품 엑셀 일괄업로드 Request","properties":{"loginEntrNo":{"type":"string","description":"로그인사용자 협력사"},"searchType":{"type":"string","description":"실데이터 조회 타입"},"errorMessage":{"type":"string","description":"에러메시지"},"excelSuccessYn":{"type":"string","description":"업로드파일 성공여부 체크"},"excelFileInfo":{"$ref":"#/components/schemas/GoodsUploadHistoryRequest","description":"엑셀업로드이력"},"excelFileErrorInfo":{"type":"array","description":"엑셀업로드에러정보","items":{"$ref":"#/components/schemas/GoodsUploadErrorRequest"}},"goodsList":{"type":"array","description":"상품리스트","items":{"$ref":"#/components/schemas/ExcelUploadGoodsRequestV2"}},"versionList":{"type":"array","description":"버전확인","items":{"$ref":"#/components/schemas/ExcelUploadVersionRequestV2"}},"duplicationGoodsList":{"type":"array","description":"엑셀 내 중복확인용 상품리스트","items":{"$ref":"#/components/schemas/ExcelUploadGoodsResponse"}},"codeList":{"type":"array","description":"공통코드리스트","items":{"$ref":"#/components/schemas/ExcelUploadCodeRequestV2"}},"entrList":{"type":"array","description":"협력사리스트","items":{"$ref":"#/components/schemas/ExcelUploadEntrRequestV2"}},"brandList":{"type":"array","description":"브랜드리스트","items":{"$ref":"#/components/schemas/ExcelUploadBrandRequestV2"}},"stdCtgList":{"type":"array","description":"리프표준카테고리리스트","items":{"$ref":"#/components/schemas/ExcelUploadStdCtgRequestV2"}},"goodsNotiLisartCdList":{"type":"array","description":"상품고시항목리스트","items":{"$ref":"#/components/schemas/ExcelUploadGoodsNotiLisartRequestV2"}},"excelVersionYn":{"type":"boolean","description":"업로드파일 버전 체크"}}},"GoodsUploadHistoryRequest":{"type":"object","description":"상품엑셀업로드이력 Request","properties":{"goodsExlUpldSeq":{"type":"string","description":"상품엑셀업로드순번"},"entrNo":{"type":"string","description":"협력사 번호"},"exlFilePathNm":{"type":"string","description":"엑셀파일경로명"},"exlFileNm":{"type":"string","description":"엑셀파일명"},"totCnt":{"type":"integer","format":"int32","description":"총건수"},"sucsCnt":{"type":"integer","format":"int32","description":"성공건수"},"failCnt":{"type":"integer","format":"int32","description":"실패건수"}}},"GoodsUploadErrorRequest":{"type":"object","description":"엑셀업로드에러정보 Request","properties":{"goodsExlUpldSeq":{"type":"string","description":"상품엑셀업로드순번"},"exlRowNo":{"type":"integer","format":"int32","description":"엑셀행번호"},"exlColNo":{"type":"integer","format":"int32","description":"엑셀열번호"},"errorMsg":{"type":"string","description":"에러메시지"}}},"ExcelUploadGoodsRequestV2":{"type":"object","description":"엑셀 상품 Request","properties":{"successYn":{"type":"string"},"goodsDuplicationYn":{"type":"string","description":"상품중복여부"},"errorMessage":{"type":"string","description":"에러메시지"},"entrNm":{"type":"string","description":"협력사명"},"stdCtgNm":{"type":"string","description":"표준카테고리명"},"goodsNotiLisartNm":{"type":"string","description":"고시품목명"},"goodsDuplication":{"type":"string","description":"상품중복확인"},"rowIndex":{"type":"integer","format":"int32","description":"엑셀행번호"},"goodsNo":{"type":"string","description":"상품번호"},"goodsCompCd":{"type":"string","description":"상품구성코드"},"goodsTypCd":{"type":"string","description":"상품유형코드"},"saleStatCd":{"type":"string","description":"판매상태코드"},"regInfPathCd":{"type":"string","description":"등록유입경로코드"},"deliGoodsGbCd":{"type":"string","description":"배송상품구분코드"},"deliWayCd":{"type":"string","description":"배송수단코드"},"deliPolcNo":{"type":"string","description":"배송정책번호"},"ordCnclPsbYn":{"type":"string","description":"취소가능여부"},"wthdYn":{"type":"string","description":"회수필요여부"},"goodsNm":{"type":"string","description":"상품명"},"entrNo":{"type":"string","description":"협력사번호"},"stdCtgNo":{"type":"string","description":"표준카테고리번호"},"lgcGoodsNo":{"type":"string","description":"자체상품번호"},"saleMethCd":{"type":"string","description":"판매방식코드"},"rsvStrDtm":{"type":"string","description":"예약주문가능시작일시"},"rsvEndDtm":{"type":"string","description":"예약주문가능종료일시"},"rsvEndSaleMeth":{"type":"string","description":"예약종료후판매방식"},"fwdidcPrarDy":{"type":"string","description":"예약상품출고지시일"},"modlNm":{"type":"string","description":"모델명"},"brandNo":{"type":"string","description":"브랜드번호"},"mfcoNm":{"type":"string","description":"제조사"},"homeNm":{"type":"string","description":"원산지"},"salemnNm":{"type":"string","description":"판매자"},"incomNm":{"type":"string","description":"수입자"},"frgnDirPurGoodsYn":{"type":"string","description":"직구상품 여부"},"saleStrDtmStr":{"type":"string","description":"판매시작일시(Excel)"},"saleStrDtm":{"type":"string","format":"date-time","description":"판매시작일시"},"saleEndDtmStr":{"type":"string","description":"판매종료일시"},"saleEndDtm":{"type":"string","format":"date-time","description":"판매종료일시"},"buyrAgeLmtCd":{"type":"string","description":"구입자나이제한코드"},"dispYn":{"type":"string","description":"전시여부"},"prcCompaExpYn":{"type":"string","description":"가격비교노출여부"},"schPsbYn":{"type":"string","description":"검색키워드 사용여부"},"schKwdNm":{"type":"string","description":"검색키워드"},"milgRsrvPsbYn":{"type":"string","description":"마일리지적립가능여부"},"gvgfPsbYn":{"type":"string","description":"선물하기가능여부"},"szGdeUseYn":{"type":"string","description":"사이즈가이드사용여부"},"szGdeRegMethodCd":{"type":"string","description":"사이즈가이드등록방법코드"},"szGdeCd":{"type":"string","description":"사이즈가이드코드"},"szGdeConts":{"type":"string","description":"사이즈가이드내용"},"buyTypCd":{"type":"string","description":"매입형태코드"},"taxGbCd":{"type":"string","description":"과/면세구분"},"supPcost":{"type":"number","description":"공급원가"},"norPrc":{"type":"number","description":"정상가"},"salePrc":{"type":"number","description":"판매가"},"mrgnRate":{"type":"number","description":"마진율"},"deliProcTypCd":{"type":"string","description":"배송처리유형코드"},"deliPsbRgnCd":{"type":"string","description":"배송가능지역"},"deliDday":{"type":"integer","format":"int32","description":"배송기일"},"hsCd":{"type":"string","description":"HS코드"},"bpckPsbYn":{"type":"string","description":"합배송가능여부"},"rtnPsbYn":{"type":"string","description":"반품가능여부"},"exchPsbYn":{"type":"string","description":"교환가능여부"},"rglrDeliGoodsYn":{"type":"string","description":"정기배송상품여부"},"stkMgrYn":{"type":"string","description":"재고관리여부"},"buyQtyLmtYn":{"type":"string","description":"구매수량제한여부"},"minLmtQty":{"type":"integer","format":"int32","description":"최소구매수량"},"maxLmtQty":{"type":"integer","format":"int32","description":"최대구매수량"},"safeStkNotiYn":{"type":"string","description":"안전재고알림여부"},"dtlDesc":{"type":"string","description":"상세설명"},"prGoodsContInfo":{"$ref":"#/components/schemas/PrGoodsContInfo","description":"상품컨텐츠정보"},"goodsNotiLisartCd":{"type":"string","description":"고시품목코드"},"goodsNotiItemCd1":{"type":"string","description":"고시항목1"},"notiItemCmt1":{"type":"string","description":"고시항목내용1"},"goodsNotiItemCd2":{"type":"string","description":"고시항목2"},"notiItemCmt2":{"type":"string","description":"고시항목내용2"},"goodsNotiItemCd3":{"type":"string","description":"고시항목3"},"notiItemCmt3":{"type":"string","description":"고시항목내용3"},"goodsNotiItemCd4":{"type":"string","description":"고시항목4"},"notiItemCmt4":{"type":"string","description":"고시항목내용4"},"goodsNotiItemCd5":{"type":"string","description":"고시항목5"},"notiItemCmt5":{"type":"string","description":"고시항목내용5"},"goodsNotiItemCd6":{"type":"string","description":"고시항목6"},"notiItemCmt6":{"type":"string","description":"고시항목내용6"},"goodsNotiItemCd7":{"type":"string","description":"고시항목7"},"notiItemCmt7":{"type":"string","description":"고시항목내용7"},"goodsNotiItemCd8":{"type":"string","description":"고시항목8"},"notiItemCmt8":{"type":"string","description":"고시항목내용8"},"goodsNotiItemCd9":{"type":"string","description":"고시항목9"},"notiItemCmt9":{"type":"string","description":"고시항목내용9"},"goodsNotiItemCd10":{"type":"string","description":"고시항목10"},"notiItemCmt10":{"type":"string","description":"고시항목내용10"},"goodsNotiItemCd11":{"type":"string","description":"고시항목11"},"notiItemCmt11":{"type":"string","description":"고시항목내용11"},"goodsNotiItemCd12":{"type":"string","description":"고시항목12"},"notiItemCmt12":{"type":"string","description":"고시항목내용12"},"goodsNotiItemCd13":{"type":"string","description":"고시항목13"},"notiItemCmt13":{"type":"string","description":"고시항목내용13"},"goodsNotiItemCd14":{"type":"string","description":"고시항목14"},"notiItemCmt14":{"type":"string","description":"고시항목내용14"},"safeCertiTgtYn":{"type":"string","description":"안전인증대상여부"},"safeCertiGbCd1":{"type":"string","description":"안전인증구분코드1"},"safeCertiOrnNm1":{"type":"string","description":"안전인증기관명1"},"safeCertiNo1":{"type":"string","description":"안전인증번호1"},"aplyStrDt1":{"type":"string","description":"안전인증적용시작일자1"},"aplyEndDt1":{"type":"string","description":"안전인증적용종료일자1"},"safeCertiGbCd2":{"type":"string","description":"안전인증구분코드2"},"safeCertiOrnNm2":{"type":"string","description":"안전인증기관명2"},"safeCertiNo2":{"type":"string","description":"안전인증번호2"},"aplyStrDt2":{"type":"string","description":"안전인증적용시작일자2"},"aplyEndDt2":{"type":"string","description":"안전인증적용종료일자2"},"safeCertiGbCd3":{"type":"string","description":"안전인증구분코드3"},"safeCertiOrnNm3":{"type":"string","description":"안전인증기관명3"},"safeCertiNo3":{"type":"string","description":"안전인증번호3"},"aplyStrDt3":{"type":"string","description":"안전인증적용시작일자3"},"aplyEndDt3":{"type":"string","description":"안전인증적용종료일자3"},"safeCertiGbCd4":{"type":"string","description":"안전인증구분코드4"},"safeCertiOrnNm4":{"type":"string","description":"안전인증기관명4"},"safeCertiNo4":{"type":"string","description":"안전인증번호4"},"aplyStrDt4":{"type":"string","description":"안전인증적용시작일자4"},"aplyEndDt4":{"type":"string","description":"안전인증적용종료일자4"},"safeCertiGbCd5":{"type":"string","description":"안전인증구분코드5"},"safeCertiOrnNm5":{"type":"string","description":"안전인증기관명5"},"safeCertiNo5":{"type":"string","description":"안전인증번호5"},"aplyStrDt5":{"type":"string","description":"안전인증적용시작일자5"},"aplyEndDt5":{"type":"string","description":"안전인증적용종료일자5"},"prAssocGoodsInfoList":{"$ref":"#/components/schemas/RealGridCUDRequestPrAssocGoodsInfo","description":"연계상품정보"},"prAdveWrdHistList":{"type":"array","description":"상품홍보문구이력","items":{"$ref":"#/components/schemas/PrAdveWrdHist"}},"prGoodsIconInfoList":{"$ref":"#/components/schemas/RealGridCUDRequestPrGoodsIconInfo","description":"상품 아이콘 정보"},"prGoodsAttInfoList":{"type":"array","description":"상품 카테고리 속성 정보","items":{"$ref":"#/components/schemas/PrGoodsAttInfo"}},"prRsvSaleHist":{"$ref":"#/components/schemas/PrRsvSaleHist","description":"예약판매이력"},"prGoodsItemInfoList":{"type":"array","description":"상품고시항목정보","items":{"$ref":"#/components/schemas/PrGoodsItemInfo"}},"prGoodsSafeCertiHistList":{"type":"array","description":"상품안전인증정보","items":{"$ref":"#/components/schemas/PrGoodsSafeCertiHist"}},"prGoodsPayMeanInfoList":{"type":"array","description":"상품결제수단정보","items":{"$ref":"#/components/schemas/PrGoodsPayMeanInfo"}},"prDispGoodsInfoList":{"$ref":"#/components/schemas/RealGridCUDRequestPrDispGoodsInfo","description":"전시카테고리"},"prGoodsPrceHist":{"$ref":"#/components/schemas/PrGoodsPrceHist","description":"상품가격이력"},"optnYn":{"type":"string","description":"옵션관리여부"},"prItmBase":{"$ref":"#/components/schemas/PrItmBase","description":"단품정보"}}},"PrGoodsContInfo":{"type":"object","description":"상품컨텐츠정보","properties":{"goodsNo":{"type":"string","description":"상품번호"},"contTypCd":{"type":"string","description":"컨텐츠유형코드(PR017) 01:상세설명, 02:동영상, 03:상품이미지"},"contSn":{"type":"string","description":"컨텐츠일련번호"},"goodsDtlDesc":{"type":"string","description":"상품상세설명"},"imgGbCd":{"type":"string","description":"이미지구분코드(PR031) P10:기본이미지, P20:추가이미지, M10:동영상"},"dispSeq":{"type":"integer","format":"int32","description":"전시순서"},"contFilePathNm":{"type":"string","description":"컨텐츠파일경로명"},"contFileNm":{"type":"string","description":"컨텐츠파일명"},"trnfTextCont":{"type":"string","description":"대체텍스트내용"},"useYn":{"type":"string","description":"사용여부"},"packageSubImageRegistDefaultValue":{"type":"integer","format":"int32","writeOnly":true}}},"RealGridCUDRequestPrAssocGoodsInfo":{"type":"object","properties":{"all":{"type":"array","items":{"$ref":"#/components/schemas/PrAssocGoodsInfo"}},"create":{"type":"array","items":{"$ref":"#/components/schemas/PrAssocGoodsInfo"}},"update":{"type":"array","items":{"$ref":"#/components/schemas/PrAssocGoodsInfo"}},"delete":{"type":"array","items":{"$ref":"#/components/schemas/PrAssocGoodsInfo"}}}},"PrAssocGoodsInfo":{"type":"object","description":"연관상품정보","properties":{"goodsNo":{"type":"string","description":"상품번호"},"asctGoodsNo":{"type":"string","description":"연관상품번호"},"asctGbCd":{"type":"string","description":"연관구분코드"},"sortSeq":{"type":"integer","format":"int32","description":"정렬순서"}}},"PrAdveWrdHist":{"type":"object","description":"상품홍보문구이력","properties":{"goodsNo":{"type":"string","description":"상품번호"},"aplyStrDtm":{"type":"string","format":"date-time","description":"적용시작일자"},"aplyEndDtm":{"type":"string","format":"date-time","description":"적용종료일자"},"adveWrd":{"type":"string","description":"홍보문구"},"useYn":{"type":"string","description":"사용여부"}}},"RealGridCUDRequestPrGoodsIconInfo":{"type":"object","properties":{"all":{"type":"array","items":{"$ref":"#/components/schemas/PrGoodsIconInfo"}},"create":{"type":"array","items":{"$ref":"#/components/schemas/PrGoodsIconInfo"}},"update":{"type":"array","items":{"$ref":"#/components/schemas/PrGoodsIconInfo"}},"delete":{"type":"array","items":{"$ref":"#/components/schemas/PrGoodsIconInfo"}}}},"PrGoodsIconInfo":{"type":"object","description":"상품아이콘정보","properties":{"siteNo":{"type":"string","description":"사이트번호"},"goodsNo":{"type":"string","description":"상품번호"},"dispIconNo":{"type":"string","description":"전시아이콘번호"},"siteNm":{"type":"string","description":"사이트명"},"iconNm":{"type":"string","description":"아이콘명"},"dispMediaCdNm":{"type":"string","description":"전시매체"},"iconTypCdNm":{"type":"string","description":"아이콘 유형"},"aplyStrDtm":{"type":"string","format":"date-time","description":"적용시작일시"},"aplyEndDtm":{"type":"string","format":"date-time","description":"적용종료일시"},"iconPathNm":{"type":"string","description":"아이콘 이미지 경로"},"delYn":{"type":"string","description":"삭제여부"}}},"PrGoodsAttInfo":{"type":"object","properties":{"langCd":{"type":"string","description":"언어코드(CM009)"},"goodsNo":{"type":"string","description":"상품번호"},"attCd":{"type":"string","description":"속성코드"},"attVal":{"type":"string","description":"속성값"},"stdCtgNo":{"type":"string","description":"표준카테고리번호"}}},"PrRsvSaleHist":{"type":"object","description":"예약판매이력","properties":{"goodsNo":{"type":"string","description":"상품번호"},"rsvStrtDtm":{"type":"string","format":"date-time","description":"예약시작일시"},"rsvEndDtm":{"type":"string","format":"date-time","description":"예약종료일시"},"rsvEndAfProcMethCd":{"type":"string","description":"예약종료후판매방식(PR011)"},"rsvStopYn":{"type":"string","description":"예약중단여부"},"rsvStopCausCd":{"type":"string","description":"예약중단사유코드(PR034)"},"rsvStopDtm":{"type":"string","format":"date-time","description":"예약중단일시"},"fwdidcPrarDy":{"type":"string","description":"출고지시예정일자"}}},"PrGoodsItemInfo":{"type":"object","description":"상품항목정보","properties":{"goodsNo":{"type":"string","description":"상품번호"},"goodsNotiLisartCd":{"type":"string","description":"상품고시항목코드"},"goodsNotiItemCd":{"type":"string","description":"상품고시품목코드"},"notiItemCmt":{"type":"string","description":"고시항목내용"}}},"PrGoodsSafeCertiHist":{"type":"object","description":"상품안전인증이력","properties":{"goodsNo":{"type":"string","description":"상품번호"},"safeCertiGbCd":{"type":"string","description":"안전인증구분코드"},"safeCertiNo":{"type":"string","description":"안전인증번호"},"aplyStrDt":{"type":"string","description":"적용시작일자"},"aplyEndDt":{"type":"string","description":"적용종료일자"},"safeCertiOrnNm":{"type":"string","description":"안전인증기관명"}}},"PrGoodsPayMeanInfo":{"type":"object","description":"상품겿제수단정보","properties":{"goodsNo":{"type":"string","description":"상품번호"},"payWayCd":{"type":"string","description":"결제수단코드"},"useYn":{"type":"string","description":"사용여부"}}},"RealGridCUDRequestPrDispGoodsInfo":{"type":"object","properties":{"all":{"type":"array","items":{"$ref":"#/components/schemas/PrDispGoodsInfo"}},"create":{"type":"array","items":{"$ref":"#/components/schemas/PrDispGoodsInfo"}},"update":{"type":"array","items":{"$ref":"#/components/schemas/PrDispGoodsInfo"}},"delete":{"type":"array","items":{"$ref":"#/components/schemas/PrDispGoodsInfo"}}}},"PrDispGoodsInfo":{"type":"object","description":"전시카테고리기본_상품정보","properties":{"goodsNo":{"type":"string","description":"상품번호"},"dispCtgNo":{"type":"string","description":"전시카테고리번호"},"dispYn":{"type":"string","description":"전시여부"},"errorMessage":{"type":"string","description":"오류메시지","readOnly":true},"goodsList":{"type":"array","description":"상품번호 리스트","items":{"type":"string"}},"goodsArray":{"type":"array","description":"상품번호 배열","items":{"type":"string"}},"itemList":{"type":"array","description":"단품번호 리스트","items":{"type":"string"}},"itemArray":{"type":"array","description":"단품번호 배열","items":{"type":"string"}},"goodsNm":{"type":"string","description":"상품명","readOnly":true},"goodsTypCd":{"type":"string","description":"상품유형","readOnly":true},"norPrc":{"type":"number","description":"정상가","readOnly":true},"salePrc":{"type":"number","description":"판매가","readOnly":true},"saleStatCd":{"type":"string","description":"판매상태","readOnly":true},"entrNm":{"type":"string","description":"협력사명","readOnly":true},"goodsImg":{"type":"string","description":"상품이미지","readOnly":true},"moodTagVal":{"type":"string","description":"무드","readOnly":true},"wght":{"type":"string","description":"가중치","readOnly":true}}},"PrGoodsPrceHist":{"type":"object","description":"상품가격이력","properties":{"goodsNo":{"type":"string","description":"상품번호"},"histStrDtm":{"type":"string","format":"date-time","description":"이력시작일시"},"histEndDtm":{"type":"string","format":"date-time","description":"이력종료일시"},"supPcost":{"type":"number","description":"공급원가"},"norPrc":{"type":"number","description":"정상가"},"salePrc":{"type":"number","description":"판매가"},"eventPrc":{"type":"number","description":"행사가"},"mrgnRate":{"type":"number","description":"마진율"},"goodsPrceTypCd":{"type":"string","description":"상품가격유형코드"},"prcChgCausCd":{"type":"string","description":"가격변경사유코드(PR033)"},"prcChgCausCdNm":{"type":"string","description":"가격변경사유"},"timeDealYn":{"type":"string","description":"타임딜 여부"},"supPcostByMrgn":{"type":"number","writeOnly":true}}},"PrItmBase":{"type":"object","description":"단품기본","properties":{"goodsNo":{"type":"string","description":"상품번호"},"itmNo":{"type":"string","description":"단품번호"},"optnCatNm1":{"type":"string","description":"옵션분류명_1"},"optnNm1":{"type":"string","description":"옵션명_1"},"optnCatNm2":{"type":"string","description":"옵션분류명_2"},"optnNm2":{"type":"string","description":"옵션명_2"},"optnCatNm3":{"type":"string","description":"옵션분류명_3"},"optnNm3":{"type":"string","description":"옵션명_3"},"optnCatNm4":{"type":"string","description":"옵션분류명_4"},"optnNm4":{"type":"string","description":"옵션명_4"},"optnCatNm5":{"type":"string","description":"옵션분류명_5"},"optnNm5":{"type":"string","description":"옵션명_5"},"lgcItmNo":{"type":"string","description":"자체단품번호"},"itmSaleStatCd":{"type":"string","description":"단품판매상태코드(PR005) 01:임시저장, 02:승인대기, 03:반려, 10:판매중, 20:품절, 40:판매종료"},"itmSaleStatCdNm":{"type":"string","description":"단품판매상태코드명"},"saleStatChgCausCd":{"type":"string","description":"판매상태변경사유코드(PR058) 41:판매종료(정상) 42:판매종료(삭제)"},"repItmYn":{"type":"string","description":"대표단품여부"},"dispSeq":{"type":"integer","format":"int32","description":"전시순서"},"addSupPcost":{"type":"number","description":"추가공급원가"},"addSalePrc":{"type":"number","description":"추가판매가"},"soutCausCd":{"type":"string","description":"품절사유코드(PR032) 10:발송불가 자동품절처리, 11:재고수량 0 품절처리, 12:관리자 수동품절처리, 13:익일배송지연 자동품절처리, 14:모든단품품절로 상품 품절처리, 15:예약상품 품절처리, 16:묶음상품 품절로 인한 품절"},"limtQty":{"type":"integer","format":"int32","description":"예약한정수량"},"stkQty":{"type":"integer","format":"int32","description":"재고수량"},"safeStkNotiYn":{"type":"string","description":"안전재고 알림여부"},"safeStkQty":{"type":"integer","format":"int32","description":"안전재고수량"},"optnCatNo1":{"type":"string","description":"옵션분류번호_1"},"optnNo1":{"type":"string","description":"옵션번호_1"},"optnCatNo2":{"type":"string","description":"옵션분류번호_2"},"optnNo2":{"type":"string","description":"옵션번호_2"},"optnCatNo3":{"type":"string","description":"옵션분류번호_3"},"optnNo3":{"type":"string","description":"옵션번호_3"},"optnCatNo4":{"type":"string","description":"옵션분류번호_4"},"optnNo4":{"type":"string","description":"옵션번호_4"},"optnCatNo5":{"type":"string","description":"옵션분류번호_5"},"optnNo5":{"type":"string","description":"옵션번호_5"},"giftRegistDefaultValue":{"type":"string","writeOnly":true},"addSupPcostByMargn":{"type":"number","writeOnly":true}}},"ExcelUploadVersionRequestV2":{"type":"object","description":"엑셀 버전 Request","properties":{"rowIndex":{"type":"integer","format":"int32","description":"엑셀행번호"},"version":{"type":"string","description":"버전"}}},"ExcelUploadGoodsResponse":{"type":"object","description":"엑셀 상품 Response","properties":{"rowIndex":{"type":"integer","format":"int32","description":"엑셀행번호"},"goodsNm":{"type":"string","description":"상품명"},"entrNo":{"type":"string","description":"협력사번호"},"stdCtgNo":{"type":"string","description":"표준카테고리번호"},"lgcGoodsNo":{"type":"string","description":"자체상품번호"},"goodsDuplicationYn":{"type":"string","description":"상품중복여부"}}},"ExcelUploadCodeRequestV2":{"type":"object","description":"엑셀 공통코드 Request","properties":{"key":{"type":"string","description":"그룹코드번호"},"cd":{"type":"string","description":"크드번호"},"cdNm":{"type":"string","description":"코드명"}}},"ExcelUploadEntrRequestV2":{"type":"object","description":"엑셀 협력사 Request","properties":{"entrNo":{"type":"string","description":"협력사번호"},"entrNm":{"type":"string","description":"협력사명"},"buyTypCd":{"type":"string","description":"매입형태코드"},"buyTypCdNm":{"type":"string","description":"매입형태명"},"deliProcTypCd":{"type":"string","description":"배송처리유형코드"},"deliProcTypCdNm":{"type":"string","description":"배송처리유형명"},"mrgnRateGbCd":{"type":"string","description":"마진율구분코드"},"mrgnRateGbCdNm":{"type":"string","description":"마진울구분명"},"mrgnRate1":{"type":"number","description":"마진율1"},"mrgnRate2":{"type":"number","description":"마진율2"},"bmanKindCd":{"type":"string","description":"사업자종류코드"},"bmanKindCdNm":{"type":"string","description":"사업자종류코드명"}}},"ExcelUploadBrandRequestV2":{"type":"object","description":"엑셀 브랜드 Request","properties":{"brandNo":{"type":"string","description":"브랜드번호"},"brandNm":{"type":"string","description":"브랜드명"}}},"ExcelUploadStdCtgRequestV2":{"type":"object","description":"엑셀 리프표준카테고리 Request","properties":{"stdCtgNo":{"type":"string","description":"표준카테고리번호"},"stdCtgNm":{"type":"string","description":"표준카테고리명"},"safeCertiNeedYn":{"type":"string","description":"안전인증대상여부"},"goodsNotiLisartCd":{"type":"string","description":"고시품목코드"},"mrgnRate":{"type":"number","format":"double","description":"카테고리 마진율"}}},"ExcelUploadGoodsNotiLisartRequestV2":{"type":"object","description":"엑셀 상품고시항목 Request","properties":{"goodsNotiLisartCd":{"type":"string","description":"상품고시품목코드"},"goodsNotiLisartNm":{"type":"string","description":"상품고시품목명"},"goodsNotiItemCd1":{"type":"string","description":"고시항목1"},"goodsNotiItemNm1":{"type":"string","description":"고시항목명1"},"goodsNotiItemCd2":{"type":"string","description":"고시항목2"},"goodsNotiItemNm2":{"type":"string","description":"고시항목명2"},"goodsNotiItemCd3":{"type":"string","description":"고시항목3"},"goodsNotiItemNm3":{"type":"string","description":"고시항목명3"},"goodsNotiItemCd4":{"type":"string","description":"고시항목4"},"goodsNotiItemNm4":{"type":"string","description":"고시항목명4"},"goodsNotiItemCd5":{"type":"string","description":"고시항목5"},"goodsNotiItemNm5":{"type":"string","description":"고시항목명5"},"goodsNotiItemCd6":{"type":"string","description":"고시항목6"},"goodsNotiItemNm6":{"type":"string","description":"고시항목명6"},"goodsNotiItemCd7":{"type":"string","description":"고시항목7"},"goodsNotiItemNm7":{"type":"string","description":"고시항목명7"},"goodsNotiItemCd8":{"type":"string","description":"고시항목8"},"goodsNotiItemNm8":{"type":"string","description":"고시항목명8"},"goodsNotiItemCd9":{"type":"string","description":"고시항목9"},"goodsNotiItemNm9":{"type":"string","description":"고시항목명9"},"goodsNotiItemCd10":{"type":"string","description":"고시항목10"},"goodsNotiItemNm10":{"type":"string","description":"고시항목명10"},"goodsNotiItemCd11":{"type":"string","description":"고시항목11"},"goodsNotiItemNm11":{"type":"string","description":"고시항목명11"},"goodsNotiItemCd12":{"type":"string","description":"고시항목12"},"goodsNotiItemNm12":{"type":"string","description":"고시항목명12"},"goodsNotiItemCd13":{"type":"string","description":"고시항목13"},"goodsNotiItemNm13":{"type":"string","description":"고시항목명13"},"goodsNotiItemCd14":{"type":"string","description":"고시항목14"},"goodsNotiItemNm14":{"type":"string","description":"고시항목명14"}}},"ValidationError":{"type":"object","properties":{"field":{"type":"string","description":"field"},"message":{"type":"string","description":"field message"}}}}},"paths":{"/v2/goods/goodsBatchRegistApi/goodsBatchRegist.excelUpload":{"post":{"tags":["상품 일괄 등록"],"summary":"상품일괄등록 화면 _ 엑셀파일 저장 및 엑셀 데이터 확인","description":"상품일괄등록 화면에서 엑셀파일 저장 및 엑셀 데이터 확인을 합니다.","operationId":"goodsExcelUpload","requestBody":{"content":{"application/json":{"schema":{"type":"object","properties":{"uploadFile":{"type":"string","format":"binary"}},"required":["uploadFile"]}}}},"responses":{"200":{"description":"OK","content":{"*/*":{"schema":{"$ref":"#/components/schemas/ResponseBatchRegistRequestV2"}}}}}}}}}
```
## 상품일괄등록 화면\_엑셀 업로드 양식 다운로드
> 상품일괄등록 화면의 상품 일괄등록 탭에서 엑셀 업로드 양식을 다운로드한다.
```json
{"openapi":"3.1.0","info":{"title":"X2BEE BO API","version":"v1"},"servers":[{"url":"https://api-bo.x2bee.com/api/bo/","description":"prd"}],"security":[{"accessToken":[]}],"components":{"securitySchemes":{"accessToken":{"type":"http","name":"accessToken","scheme":"bearer","bearerFormat":"JWT"}}},"paths":{"/v2/goods/goodsBatchRegistApi/goodsBatchRegist.excelDownload":{"get":{"tags":["상품 일괄 등록"],"summary":"상품일괄등록 화면_엑셀 업로드 양식 다운로드","description":"상품일괄등록 화면의 상품 일괄등록 탭에서 엑셀 업로드 양식을 다운로드한다.","operationId":"saveExcelGoodsList_1","responses":{"200":{"description":"OK","content":{"*/*":{"schema":{"type":"string","format":"byte"}}}}}}}}}
```
## 상품일괄등록 상품엑셀업로드이력 목록 조회
> \## 기능설명\
> \* 상품일괄등록 페이지에서 상품엑셀업로드이력 목록을 조회합니다.\
> \---\
> \## 상세설명\
> \* PO인 경우, 로그인한 사용자의 협력사와 일치하는 엑셀파일만 조회 가능합니다.\
> \---\
> \## 수정번호\
> \* Release v1.05\_231204 : 상품 엑셀 일괄등록 신규생성
```json
{"openapi":"3.1.0","info":{"title":"X2BEE BO API","version":"v1"},"servers":[{"url":"https://api-bo.x2bee.com/api/bo/","description":"prd"}],"security":[{"accessToken":[]}],"components":{"securitySchemes":{"accessToken":{"type":"http","name":"accessToken","scheme":"bearer","bearerFormat":"JWT"}},"schemas":{"GoodsUploadHistoryRequest":{"type":"object","description":"상품엑셀업로드이력 Request","properties":{"goodsExlUpldSeq":{"type":"string","description":"상품엑셀업로드순번"},"entrNo":{"type":"string","description":"협력사 번호"},"exlFilePathNm":{"type":"string","description":"엑셀파일경로명"},"exlFileNm":{"type":"string","description":"엑셀파일명"},"totCnt":{"type":"integer","format":"int32","description":"총건수"},"sucsCnt":{"type":"integer","format":"int32","description":"성공건수"},"failCnt":{"type":"integer","format":"int32","description":"실패건수"}}},"ResponseRealGridListResponseGoodsUploadHistoryResponse":{"type":"object","properties":{"timestamp":{"type":"string","format":"date-time","description":"result time"},"code":{"type":"string","description":"result code"},"message":{"type":"string","description":"result message"},"isProcess":{"type":"boolean","description":"process check"},"payload":{"$ref":"#/components/schemas/RealGridListResponseGoodsUploadHistoryResponse","description":"payload"},"error":{"type":"boolean","description":"is error"},"errors":{"type":"array","description":"validation error list","items":{"$ref":"#/components/schemas/ValidationError"}}}},"RealGridListResponseGoodsUploadHistoryResponse":{"type":"object","properties":{"totalCount":{"type":"integer","format":"int32"},"payloads":{"type":"array","items":{"$ref":"#/components/schemas/GoodsUploadHistoryResponse"}}}},"GoodsUploadHistoryResponse":{"type":"object","description":"상품엑셀업로드이력 Response","properties":{"sysRegDtm":{"type":"string","format":"date-time","description":"등록일"},"goodsExlUpldSeq":{"type":"string","description":"상품엑셀업로드순번"},"entrNo":{"type":"string","description":"협력사 번호"},"entrNm":{"type":"string","description":"협력사명"},"exlFilePathNm":{"type":"string","description":"엑셀파일경로명"},"exlFileNm":{"type":"string","description":"엑셀파일명"},"totCnt":{"type":"integer","format":"int32","description":"총건수"},"sucsCnt":{"type":"integer","format":"int32","description":"성공건수"},"failCnt":{"type":"integer","format":"int32","description":"실패건수"},"sucsFailYn":{"type":"string","description":"성공실패여부"},"totalCount":{"type":"integer","format":"int32","description":"엑셀목록 총건수"}}},"ValidationError":{"type":"object","properties":{"field":{"type":"string","description":"field"},"message":{"type":"string","description":"field message"}}},"ErrorCode":{"type":"object","properties":{"code":{"type":"string"},"message":{"type":"string"},"httpStatus":{"type":"integer","format":"int32"},"isProcess":{"type":"boolean"}}}}},"paths":{"/v2/goods/goodsBatchRegistApi/getGoodsUploadHistoryList":{"get":{"tags":["상품 일괄 등록"],"summary":"상품일괄등록 상품엑셀업로드이력 목록 조회","description":"## 기능설명\n* 상품일괄등록 페이지에서 상품엑셀업로드이력 목록을 조회합니다.\n---\n## 상세설명\n* PO인 경우, 로그인한 사용자의 협력사와 일치하는 엑셀파일만 조회 가능합니다.\n---\n## 수정번호\n* Release v1.05_231204 : 상품 엑셀 일괄등록 신규생성\n","operationId":"getGoodsUploadHistoryList","parameters":[{"name":"request","in":"query","required":true,"schema":{"$ref":"#/components/schemas/GoodsUploadHistoryRequest"}}],"responses":{"200":{"description":"상품일괄등록 상품엑셀업로드이력 목록 조회 성공","content":{"*/*":{"schema":{"$ref":"#/components/schemas/ResponseRealGridListResponseGoodsUploadHistoryResponse"}}}},"900":{"description":"상품일괄등록 상품엑셀업로드이력 목록 조회 실패","content":{"*/*":{"schema":{"$ref":"#/components/schemas/ErrorCode"}}}}}}}}}
```