# 상품 일괄 등록
## 상품일괄등록 엑셀 상품등록
> \## 기능설명\
> \* 상품일괄등록에서 업로드한 엑셀 파일의 상품 데이터를 저장합니다.\
> \---\
> \## 상세설명\
> \* 데이터 검증이 완료된 정상상품목록을 받아서 저장합니다.\
> \* 저장 언어는 디폴트 언어코드인 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"}}}}}}}}}
```
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://tech.x2bee.com/api/back-office-api/goods-bo-api/undefined-5.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.