> 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/api-en/back-office-api-reference/goods-bo-api/product-bulk-registration.md).

# Product Bulk Registration

## Register Products via Bulk Excel Upload

> \## Function Description\
> \* Saves product data from the Excel file uploaded via bulk product registration.\
> \---\
> \## Detailed Description\
> \* Receives and saves the list of valid products that have passed data validation.\
> \* Products are saved using the default language code, ko.\
> \* The available payment methods are initially set to all.\
> \* The display category list mapped to the standard classification is saved as the initial value.\
> \---\
> \## Revision History\
> \* Release v1.05\_231204 : Newly created bulk product registration via Excel<br>

```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":"Excel Product Request","properties":{"successYn":{"type":"string"},"goodsDuplicationYn":{"type":"string","description":"Product Duplication Status"},"errorMessage":{"type":"string","description":"Error Message"},"entrNm":{"type":"string","description":"Vendor Name"},"stdCtgNm":{"type":"string","description":"Standard Category Name"},"goodsNotiLisartNm":{"type":"string","description":"Notice Item Name"},"goodsDuplication":{"type":"string","description":"Product Duplicate Check"},"rowIndex":{"type":"integer","format":"int32","description":"Excel Row No."},"goodsNo":{"type":"string","description":"Product No."},"goodsCompCd":{"type":"string","description":"Product Composition Code"},"goodsTypCd":{"type":"string","description":"Product Type Code"},"saleStatCd":{"type":"string","description":"Sales Status Code"},"regInfPathCd":{"type":"string","description":"Registration Inflow Path Code"},"deliGoodsGbCd":{"type":"string","description":"Delivery Product Type Code"},"deliWayCd":{"type":"string","description":"Delivery Method Code"},"deliPolcNo":{"type":"string","description":"Delivery Policy No."},"ordCnclPsbYn":{"type":"string","description":"Cancellation Availability Status"},"wthdYn":{"type":"string","description":"Collection Required Status"},"goodsNm":{"type":"string","description":"Product Name"},"entrNo":{"type":"string","description":"Vendor No."},"stdCtgNo":{"type":"string","description":"Standard Category No."},"lgcGoodsNo":{"type":"string","description":"Internal Product No."},"saleMethCd":{"type":"string","description":"Sales Method Code"},"rsvStrDtm":{"type":"string","description":"Reservation Order Available Start Date/Time"},"rsvEndDtm":{"type":"string","description":"Reservation Order Available End Date/Time"},"rsvEndSaleMeth":{"type":"string","description":"Sales Method After Reservation Ends"},"fwdidcPrarDy":{"type":"string","description":"Reserved Product Shipment Instruction Date"},"modlNm":{"type":"string","description":"Model Name"},"brandNo":{"type":"string","description":"Brand No."},"mfcoNm":{"type":"string","description":"Manufacturer"},"homeNm":{"type":"string","description":"Country of Origin"},"salemnNm":{"type":"string","description":"Seller"},"incomNm":{"type":"string","description":"Importer"},"frgnDirPurGoodsYn":{"type":"string","description":"Direct Purchase Product Status"},"saleStrDtmStr":{"type":"string","description":"Sales Start Date/Time (Excel)"},"saleStrDtm":{"type":"string","format":"date-time","description":"Sales Start Date/Time"},"saleEndDtmStr":{"type":"string","description":"Sales End Date/Time"},"saleEndDtm":{"type":"string","format":"date-time","description":"Sales End Date/Time"},"buyrAgeLmtCd":{"type":"string","description":"Buyer Age Restriction Code"},"dispYn":{"type":"string","description":"Display Status"},"prcCompaExpYn":{"type":"string","description":"Price Comparison Exposure Status"},"schPsbYn":{"type":"string","description":"Search Keyword Usage Status"},"schKwdNm":{"type":"string","description":"Search Keywords"},"milgRsrvPsbYn":{"type":"string","description":"Mileage Accrual Availability Status"},"gvgfPsbYn":{"type":"string","description":"Gift Option Availability Status"},"szGdeUseYn":{"type":"string","description":"Size Guide Usage Status"},"szGdeRegMethodCd":{"type":"string","description":"Size Guide Registration Method Code"},"szGdeCd":{"type":"string","description":"Size Guide Code"},"szGdeConts":{"type":"string","description":"Size Guide Content"},"buyTypCd":{"type":"string","description":"Purchase Type Code"},"taxGbCd":{"type":"string","description":"Taxable/Tax-Exempt Type"},"supPcost":{"type":"number","description":"Supply Cost"},"norPrc":{"type":"number","description":"Regular Price"},"salePrc":{"type":"number","description":"Selling Price"},"mrgnRate":{"type":"number","description":"Margin Rate"},"deliProcTypCd":{"type":"string","description":"Delivery Processing Type Code"},"deliPsbRgnCd":{"type":"string","description":"Deliverable Area"},"deliDday":{"type":"integer","format":"int32","description":"Delivery Lead Time"},"hsCd":{"type":"string","description":"HS Code"},"bpckPsbYn":{"type":"string","description":"Combined Delivery Availability"},"rtnPsbYn":{"type":"string","description":"Return Availability Status"},"exchPsbYn":{"type":"string","description":"Exchange Availability Status"},"rglrDeliGoodsYn":{"type":"string","description":"Subscription Delivery Product Status"},"stkMgrYn":{"type":"string","description":"Inventory Management Status"},"buyQtyLmtYn":{"type":"string","description":"Purchase Quantity Limit Status"},"minLmtQty":{"type":"integer","format":"int32","description":"Minimum Purchase Quantity"},"maxLmtQty":{"type":"integer","format":"int32","description":"Maximum Purchase Quantity"},"safeStkNotiYn":{"type":"string","description":"Safety Stock Alert Status"},"dtlDesc":{"type":"string","description":"Detailed Description"},"prGoodsContInfo":{"$ref":"#/components/schemas/PrGoodsContInfo","description":"Product Content Information"},"goodsNotiLisartCd":{"type":"string","description":"Notice Item Code"},"goodsNotiItemCd1":{"type":"string","description":"Notice Item 1"},"notiItemCmt1":{"type":"string","description":"Notice Item Content 1"},"goodsNotiItemCd2":{"type":"string","description":"Notice Item 2"},"notiItemCmt2":{"type":"string","description":"Notice Item Content 2"},"goodsNotiItemCd3":{"type":"string","description":"Notice Item 3"},"notiItemCmt3":{"type":"string","description":"Notice Item Content 3"},"goodsNotiItemCd4":{"type":"string","description":"Notice Item 4"},"notiItemCmt4":{"type":"string","description":"Notice Item Content 4"},"goodsNotiItemCd5":{"type":"string","description":"Notice Item 5"},"notiItemCmt5":{"type":"string","description":"Notice Item Content 5"},"goodsNotiItemCd6":{"type":"string","description":"Notice Item 6"},"notiItemCmt6":{"type":"string","description":"Notice Item Content 6"},"goodsNotiItemCd7":{"type":"string","description":"Notice Item 7"},"notiItemCmt7":{"type":"string","description":"Notice Item Content 7"},"goodsNotiItemCd8":{"type":"string","description":"Notice Item 8"},"notiItemCmt8":{"type":"string","description":"Notice Item Content 8"},"goodsNotiItemCd9":{"type":"string","description":"Notice Item 9"},"notiItemCmt9":{"type":"string","description":"Notice Item Content 9"},"goodsNotiItemCd10":{"type":"string","description":"Notice Item 10"},"notiItemCmt10":{"type":"string","description":"Notice Item Content 10"},"goodsNotiItemCd11":{"type":"string","description":"Notice Item 11"},"notiItemCmt11":{"type":"string","description":"Notice Item Content 11"},"goodsNotiItemCd12":{"type":"string","description":"Notice Item 12"},"notiItemCmt12":{"type":"string","description":"Notice Item Content 12"},"goodsNotiItemCd13":{"type":"string","description":"Notice Item 13"},"notiItemCmt13":{"type":"string","description":"Notice Item Content 13"},"goodsNotiItemCd14":{"type":"string","description":"Notice Item 14"},"notiItemCmt14":{"type":"string","description":"Notice Item Content 14"},"safeCertiTgtYn":{"type":"string","description":"Safety Certification Target Status"},"safeCertiGbCd1":{"type":"string","description":"Safety Certification Type Code 1"},"safeCertiOrnNm1":{"type":"string","description":"Safety Certification Agency Name 1"},"safeCertiNo1":{"type":"string","description":"Safety Certification No. 1"},"aplyStrDt1":{"type":"string","description":"Safety Certification Application Start Date 1"},"aplyEndDt1":{"type":"string","description":"Safety Certification Application End Date 1"},"safeCertiGbCd2":{"type":"string","description":"Safety Certification Type Code 2"},"safeCertiOrnNm2":{"type":"string","description":"Safety Certification Agency Name 2"},"safeCertiNo2":{"type":"string","description":"Safety Certification No. 2"},"aplyStrDt2":{"type":"string","description":"Safety Certification Application Start Date 2"},"aplyEndDt2":{"type":"string","description":"Safety Certification Application End Date 2"},"safeCertiGbCd3":{"type":"string","description":"Safety Certification Type Code 3"},"safeCertiOrnNm3":{"type":"string","description":"Safety Certification Agency Name 3"},"safeCertiNo3":{"type":"string","description":"Safety Certification No. 3"},"aplyStrDt3":{"type":"string","description":"Safety Certification Application Start Date 3"},"aplyEndDt3":{"type":"string","description":"Safety Certification Application End Date 3"},"safeCertiGbCd4":{"type":"string","description":"Safety Certification Type Code 4"},"safeCertiOrnNm4":{"type":"string","description":"Safety Certification Agency Name 4"},"safeCertiNo4":{"type":"string","description":"Safety Certification No. 4"},"aplyStrDt4":{"type":"string","description":"Safety Certification Application Start Date 4"},"aplyEndDt4":{"type":"string","description":"Safety Certification Application End Date 4"},"safeCertiGbCd5":{"type":"string","description":"Safety Certification Type Code 5"},"safeCertiOrnNm5":{"type":"string","description":"Safety Certification Agency Name 5"},"safeCertiNo5":{"type":"string","description":"Safety Certification No. 5"},"aplyStrDt5":{"type":"string","description":"Safety Certification Application Start Date 5"},"aplyEndDt5":{"type":"string","description":"Safety Certification Application End Date 5"},"prAssocGoodsInfoList":{"$ref":"#/components/schemas/RealGridCUDRequestPrAssocGoodsInfo","description":"Linked Product Information"},"prAdveWrdHistList":{"type":"array","description":"Product Promotional Copy History","items":{"$ref":"#/components/schemas/PrAdveWrdHist"}},"prGoodsIconInfoList":{"$ref":"#/components/schemas/RealGridCUDRequestPrGoodsIconInfo","description":"Product Icon Information"},"prGoodsAttInfoList":{"type":"array","description":"Product Category Attribute Information","items":{"$ref":"#/components/schemas/PrGoodsAttInfo"}},"prRsvSaleHist":{"$ref":"#/components/schemas/PrRsvSaleHist","description":"Reserved Sale History"},"prGoodsItemInfoList":{"type":"array","description":"Product Notice Item Information","items":{"$ref":"#/components/schemas/PrGoodsItemInfo"}},"prGoodsSafeCertiHistList":{"type":"array","description":"Product Safety Certification Information","items":{"$ref":"#/components/schemas/PrGoodsSafeCertiHist"}},"prGoodsPayMeanInfoList":{"type":"array","description":"Product Payment Method Information","items":{"$ref":"#/components/schemas/PrGoodsPayMeanInfo"}},"prDispGoodsInfoList":{"$ref":"#/components/schemas/RealGridCUDRequestPrDispGoodsInfo","description":"Display Category"},"prGoodsPrceHist":{"$ref":"#/components/schemas/PrGoodsPrceHist","description":"Product Price History"},"optnYn":{"type":"string","description":"Option Management Status"},"prItmBase":{"$ref":"#/components/schemas/PrItmBase","description":"Item Information"}}},"PrGoodsContInfo":{"type":"object","description":"Product Content Information","properties":{"goodsNo":{"type":"string","description":"Product No."},"contTypCd":{"type":"string","description":"Content Type Code (PR017) 01: Detailed Description, 02: Video, 03: Product Image"},"contSn":{"type":"string","description":"Content Serial No."},"goodsDtlDesc":{"type":"string","description":"Product Detailed Description"},"imgGbCd":{"type":"string","description":"Image Type Code (PR031) P10: Basic Image, P20: Additional Image, M10: Video"},"dispSeq":{"type":"integer","format":"int32","description":"Display Order"},"contFilePathNm":{"type":"string","description":"Content File Path"},"contFileNm":{"type":"string","description":"Content File Name"},"trnfTextCont":{"type":"string","description":"Alt Text Content"},"useYn":{"type":"string","description":"Usage Status"},"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":"Related Product Information","properties":{"goodsNo":{"type":"string","description":"Product No."},"asctGoodsNo":{"type":"string","description":"Related Product No."},"asctGbCd":{"type":"string","description":"Related Type Code"},"sortSeq":{"type":"integer","format":"int32","description":"Sort Order"}}},"PrAdveWrdHist":{"type":"object","description":"Product Promotional Copy History","properties":{"goodsNo":{"type":"string","description":"Product No."},"aplyStrDtm":{"type":"string","format":"date-time","description":"Application Start Date"},"aplyEndDtm":{"type":"string","format":"date-time","description":"Application End Date"},"adveWrd":{"type":"string","description":"Promotional Text"},"useYn":{"type":"string","description":"Usage Status"}}},"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":"Product Icon Information","properties":{"siteNo":{"type":"string","description":"Site No."},"goodsNo":{"type":"string","description":"Product No."},"dispIconNo":{"type":"string","description":"Display Icon No."},"siteNm":{"type":"string","description":"Site Name"},"iconNm":{"type":"string","description":"Icon Name"},"dispMediaCdNm":{"type":"string","description":"Display Media"},"iconTypCdNm":{"type":"string","description":"Icon Type"},"aplyStrDtm":{"type":"string","format":"date-time","description":"Application Start Date/Time"},"aplyEndDtm":{"type":"string","format":"date-time","description":"Application End Date/Time"},"iconPathNm":{"type":"string","description":"Icon Image Path"},"delYn":{"type":"string","description":"Deletion Status"}}},"PrGoodsAttInfo":{"type":"object","properties":{"langCd":{"type":"string","description":"Language Code (CM009)"},"goodsNo":{"type":"string","description":"Product No."},"attCd":{"type":"string","description":"Attribute Code"},"attVal":{"type":"string","description":"Attribute Value"},"stdCtgNo":{"type":"string","description":"Standard Category No."}}},"PrRsvSaleHist":{"type":"object","description":"Reserved Sale History","properties":{"goodsNo":{"type":"string","description":"Product No."},"rsvStrtDtm":{"type":"string","format":"date-time","description":"Reservation Start Date/Time"},"rsvEndDtm":{"type":"string","format":"date-time","description":"Reservation End Date/Time"},"rsvEndAfProcMethCd":{"type":"string","description":"Sales Method After Reservation Ends (PR011)"},"rsvStopYn":{"type":"string","description":"Reservation Suspended Status"},"rsvStopCausCd":{"type":"string","description":"Reservation Stop Reason Code (PR034)"},"rsvStopDtm":{"type":"string","format":"date-time","description":"Reservation Suspension Date/Time"},"fwdidcPrarDy":{"type":"string","description":"Scheduled Shipment Instruction Date"}}},"PrGoodsItemInfo":{"type":"object","description":"Product Item Information","properties":{"goodsNo":{"type":"string","description":"Product No."},"goodsNotiLisartCd":{"type":"string","description":"Product Disclosure Item Code"},"goodsNotiItemCd":{"type":"string","description":"Product Notification Item Code"},"notiItemCmt":{"type":"string","description":"Notice Item Content"}}},"PrGoodsSafeCertiHist":{"type":"object","description":"Product Safety Certification History","properties":{"goodsNo":{"type":"string","description":"Product No."},"safeCertiGbCd":{"type":"string","description":"Safety Certification Type Code"},"safeCertiNo":{"type":"string","description":"Safety Certification No."},"aplyStrDt":{"type":"string","description":"Application Start Date"},"aplyEndDt":{"type":"string","description":"Application End Date"},"safeCertiOrnNm":{"type":"string","description":"Safety Certification Agency Name"}}},"PrGoodsPayMeanInfo":{"type":"object","description":"Product Payment Method Information","properties":{"goodsNo":{"type":"string","description":"Product No."},"payWayCd":{"type":"string","description":"Payment Method Code"},"useYn":{"type":"string","description":"Usage Status"}}},"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":"Display Category Basic_Product Information","properties":{"goodsNo":{"type":"string","description":"Product No."},"dispCtgNo":{"type":"string","description":"Display Category No."},"dispYn":{"type":"string","description":"Display Status"},"errorMessage":{"type":"string","description":"Error Message","readOnly":true},"goodsList":{"type":"array","description":"Product No. List","items":{"type":"string"}},"goodsArray":{"type":"array","description":"Product No. Array","items":{"type":"string"}},"itemList":{"type":"array","description":"SKU No. List","items":{"type":"string"}},"itemArray":{"type":"array","description":"SKU No. Array","items":{"type":"string"}},"goodsNm":{"type":"string","description":"Product Name","readOnly":true},"goodsTypCd":{"type":"string","description":"Product Type","readOnly":true},"norPrc":{"type":"number","description":"Regular Price","readOnly":true},"salePrc":{"type":"number","description":"Selling Price","readOnly":true},"saleStatCd":{"type":"string","description":"Sales Status","readOnly":true},"entrNm":{"type":"string","description":"Vendor Name","readOnly":true},"goodsImg":{"type":"string","description":"Product Image","readOnly":true},"moodTagVal":{"type":"string","description":"Mood","readOnly":true},"wght":{"type":"string","description":"Weight","readOnly":true}}},"PrGoodsPrceHist":{"type":"object","description":"Product Price History","properties":{"goodsNo":{"type":"string","description":"Product No."},"histStrDtm":{"type":"string","format":"date-time","description":"History Start Date/Time"},"histEndDtm":{"type":"string","format":"date-time","description":"History End Date/Time"},"supPcost":{"type":"number","description":"Supply Cost"},"norPrc":{"type":"number","description":"Regular Price"},"salePrc":{"type":"number","description":"Selling Price"},"eventPrc":{"type":"number","description":"Promotional Price"},"mrgnRate":{"type":"number","description":"Margin Rate"},"goodsPrceTypCd":{"type":"string","description":"Product Price Type Code"},"prcChgCausCd":{"type":"string","description":"Price Change Reason Code (PR033)"},"prcChgCausCdNm":{"type":"string","description":"Reason for Price Change"},"timeDealYn":{"type":"string","description":"Time Deal Status"},"supPcostByMrgn":{"type":"number","writeOnly":true}}},"PrItmBase":{"type":"object","description":"SKU Basic","properties":{"goodsNo":{"type":"string","description":"Product No."},"itmNo":{"type":"string","description":"Item No."},"optnCatNm1":{"type":"string","description":"Option Category Name_1"},"optnNm1":{"type":"string","description":"Option Name 1"},"optnCatNm2":{"type":"string","description":"Option Category Name_2"},"optnNm2":{"type":"string","description":"Option Name 2"},"optnCatNm3":{"type":"string","description":"Option Category Name_3"},"optnNm3":{"type":"string","description":"Option Name 3"},"optnCatNm4":{"type":"string","description":"Option Category Name_4"},"optnNm4":{"type":"string","description":"Option Name 4"},"optnCatNm5":{"type":"string","description":"Option Category Name_5"},"optnNm5":{"type":"string","description":"Option Name 5"},"lgcItmNo":{"type":"string","description":"Internal Item No."},"itmSaleStatCd":{"type":"string","description":"Item Sales Status Code (PR005) 01: Temporary Save, 02: Pending Approval, 03: Rejected, 10: On Sale, 20: Sold Out, 40: Discontinued"},"itmSaleStatCdNm":{"type":"string","description":"Unit Sales Status Code Name"},"saleStatChgCausCd":{"type":"string","description":"Sales Status Change Reason Code (PR058) 41: Sales Ended (Normal) 42: Sales Ended (Deleted)"},"repItmYn":{"type":"string","description":"Representative Item Status"},"dispSeq":{"type":"integer","format":"int32","description":"Display Order"},"addSupPcost":{"type":"number","description":"Additional Supply Cost"},"addSalePrc":{"type":"number","description":"Additional Sales Price"},"soutCausCd":{"type":"string","description":"Out-of-Stock Reason Code (PR032) 10: Automatic out-of-stock processing due to shipment unavailable, 11: Out-of-stock processing due to 0 stock quantity, 12: Manual out-of-stock processing by administrator, 13: Automatic out-of-stock processing due to next-day delivery delay, 14: Product out-of-stock processing due to all units out of stock, 15: Reserved product out-of-stock processing, 16: Out of stock due to bundle product out of stock"},"limtQty":{"type":"integer","format":"int32","description":"Reserved Limited Quantity"},"stkQty":{"type":"integer","format":"int32","description":"Stock Quantity"},"safeStkNotiYn":{"type":"string","description":"Safety Stock Alert Status"},"safeStkQty":{"type":"integer","format":"int32","description":"Safety Stock Quantity"},"optnCatNo1":{"type":"string","description":"Option Category No._1"},"optnNo1":{"type":"string","description":"Option No._1"},"optnCatNo2":{"type":"string","description":"Option Category No._2"},"optnNo2":{"type":"string","description":"Option No._2"},"optnCatNo3":{"type":"string","description":"Option Category No._3"},"optnNo3":{"type":"string","description":"Option No._3"},"optnCatNo4":{"type":"string","description":"Option Category No._4"},"optnNo4":{"type":"string","description":"Option No._4"},"optnCatNo5":{"type":"string","description":"Option Category No._5"},"optnNo5":{"type":"string","description":"Option No._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":["Product Bulk Registration"],"summary":"Register Products via Bulk Excel Upload","description":"## Function Description\n* Saves product data from the Excel file uploaded via bulk product registration.\n---\n## Detailed Description\n* Receives and saves the list of valid products that have passed data validation.\n* Products are saved using the default language code, ko.\n* The available payment methods are initially set to all.\n* The display category list mapped to the standard classification is saved as the initial value.\n---\n## Revision History\n* Release v1.05_231204 : Newly created bulk product registration via Excel\n","operationId":"saveExcelGoodsList","requestBody":{"content":{"application/json":{"schema":{"type":"array","items":{"$ref":"#/components/schemas/ExcelUploadGoodsRequestV2"}}}},"required":true},"responses":{"200":{"description":"Bulk Excel product registration successful","content":{"*/*":{"schema":{"$ref":"#/components/schemas/ResponseString"}}}},"900":{"description":"Failed bulk Excel product registration","content":{"*/*":{"schema":{"$ref":"#/components/schemas/ErrorCode"}}}}}}}}}
```

## Bulk Product Registration Screen \_ Save Excel File and Check Excel Data

> Saves the Excel file and checks the Excel data on the bulk product registration screen.

```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":"Product Excel Batch Upload Request","properties":{"loginEntrNo":{"type":"string","description":"Logged-in User's Vendor"},"searchType":{"type":"string","description":"Actual Data Search Type"},"errorMessage":{"type":"string","description":"Error Message"},"excelSuccessYn":{"type":"string","description":"Upload File Success Status Check"},"excelFileInfo":{"$ref":"#/components/schemas/GoodsUploadHistoryRequest","description":"Excel Upload History"},"excelFileErrorInfo":{"type":"array","description":"Excel Upload Error Information","items":{"$ref":"#/components/schemas/GoodsUploadErrorRequest"}},"goodsList":{"type":"array","description":"Product List","items":{"$ref":"#/components/schemas/ExcelUploadGoodsRequestV2"}},"versionList":{"type":"array","description":"Version Check","items":{"$ref":"#/components/schemas/ExcelUploadVersionRequestV2"}},"duplicationGoodsList":{"type":"array","description":"Product List for Duplicate Check in Excel","items":{"$ref":"#/components/schemas/ExcelUploadGoodsResponse"}},"codeList":{"type":"array","description":"Common Code List","items":{"$ref":"#/components/schemas/ExcelUploadCodeRequestV2"}},"entrList":{"type":"array","description":"Vendor List","items":{"$ref":"#/components/schemas/ExcelUploadEntrRequestV2"}},"brandList":{"type":"array","description":"Brand List","items":{"$ref":"#/components/schemas/ExcelUploadBrandRequestV2"}},"stdCtgList":{"type":"array","description":"Leaf Standard Category List","items":{"$ref":"#/components/schemas/ExcelUploadStdCtgRequestV2"}},"goodsNotiLisartCdList":{"type":"array","description":"Product Notice Item List","items":{"$ref":"#/components/schemas/ExcelUploadGoodsNotiLisartRequestV2"}},"excelVersionYn":{"type":"boolean","description":"Upload File Version Check"}}},"GoodsUploadHistoryRequest":{"type":"object","description":"Product Excel Upload History Request","properties":{"goodsExlUpldSeq":{"type":"string","description":"Product Excel Upload Sequence No."},"entrNo":{"type":"string","description":"Vendor No."},"exlFilePathNm":{"type":"string","description":"Excel File Path Name"},"exlFileNm":{"type":"string","description":"Excel File Name"},"totCnt":{"type":"integer","format":"int32","description":"Total Count"},"sucsCnt":{"type":"integer","format":"int32","description":"Success Count"},"failCnt":{"type":"integer","format":"int32","description":"Failure Count"}}},"GoodsUploadErrorRequest":{"type":"object","description":"Excel Upload Error Information Request","properties":{"goodsExlUpldSeq":{"type":"string","description":"Product Excel Upload Sequence No."},"exlRowNo":{"type":"integer","format":"int32","description":"Excel Row No."},"exlColNo":{"type":"integer","format":"int32","description":"Excel Column No."},"errorMsg":{"type":"string","description":"Error Message"}}},"ExcelUploadGoodsRequestV2":{"type":"object","description":"Excel Product Request","properties":{"successYn":{"type":"string"},"goodsDuplicationYn":{"type":"string","description":"Product Duplication Status"},"errorMessage":{"type":"string","description":"Error Message"},"entrNm":{"type":"string","description":"Vendor Name"},"stdCtgNm":{"type":"string","description":"Standard Category Name"},"goodsNotiLisartNm":{"type":"string","description":"Notice Item Name"},"goodsDuplication":{"type":"string","description":"Product Duplicate Check"},"rowIndex":{"type":"integer","format":"int32","description":"Excel Row No."},"goodsNo":{"type":"string","description":"Product No."},"goodsCompCd":{"type":"string","description":"Product Composition Code"},"goodsTypCd":{"type":"string","description":"Product Type Code"},"saleStatCd":{"type":"string","description":"Sales Status Code"},"regInfPathCd":{"type":"string","description":"Registration Inflow Path Code"},"deliGoodsGbCd":{"type":"string","description":"Delivery Product Type Code"},"deliWayCd":{"type":"string","description":"Delivery Method Code"},"deliPolcNo":{"type":"string","description":"Delivery Policy No."},"ordCnclPsbYn":{"type":"string","description":"Cancellation Availability Status"},"wthdYn":{"type":"string","description":"Collection Required Status"},"goodsNm":{"type":"string","description":"Product Name"},"entrNo":{"type":"string","description":"Vendor No."},"stdCtgNo":{"type":"string","description":"Standard Category No."},"lgcGoodsNo":{"type":"string","description":"Internal Product No."},"saleMethCd":{"type":"string","description":"Sales Method Code"},"rsvStrDtm":{"type":"string","description":"Reservation Order Available Start Date/Time"},"rsvEndDtm":{"type":"string","description":"Reservation Order Available End Date/Time"},"rsvEndSaleMeth":{"type":"string","description":"Sales Method After Reservation Ends"},"fwdidcPrarDy":{"type":"string","description":"Reserved Product Shipment Instruction Date"},"modlNm":{"type":"string","description":"Model Name"},"brandNo":{"type":"string","description":"Brand No."},"mfcoNm":{"type":"string","description":"Manufacturer"},"homeNm":{"type":"string","description":"Country of Origin"},"salemnNm":{"type":"string","description":"Seller"},"incomNm":{"type":"string","description":"Importer"},"frgnDirPurGoodsYn":{"type":"string","description":"Direct Purchase Product Status"},"saleStrDtmStr":{"type":"string","description":"Sales Start Date/Time (Excel)"},"saleStrDtm":{"type":"string","format":"date-time","description":"Sales Start Date/Time"},"saleEndDtmStr":{"type":"string","description":"Sales End Date/Time"},"saleEndDtm":{"type":"string","format":"date-time","description":"Sales End Date/Time"},"buyrAgeLmtCd":{"type":"string","description":"Buyer Age Restriction Code"},"dispYn":{"type":"string","description":"Display Status"},"prcCompaExpYn":{"type":"string","description":"Price Comparison Exposure Status"},"schPsbYn":{"type":"string","description":"Search Keyword Usage Status"},"schKwdNm":{"type":"string","description":"Search Keywords"},"milgRsrvPsbYn":{"type":"string","description":"Mileage Accrual Availability Status"},"gvgfPsbYn":{"type":"string","description":"Gift Option Availability Status"},"szGdeUseYn":{"type":"string","description":"Size Guide Usage Status"},"szGdeRegMethodCd":{"type":"string","description":"Size Guide Registration Method Code"},"szGdeCd":{"type":"string","description":"Size Guide Code"},"szGdeConts":{"type":"string","description":"Size Guide Content"},"buyTypCd":{"type":"string","description":"Purchase Type Code"},"taxGbCd":{"type":"string","description":"Taxable/Tax-Exempt Type"},"supPcost":{"type":"number","description":"Supply Cost"},"norPrc":{"type":"number","description":"Regular Price"},"salePrc":{"type":"number","description":"Selling Price"},"mrgnRate":{"type":"number","description":"Margin Rate"},"deliProcTypCd":{"type":"string","description":"Delivery Processing Type Code"},"deliPsbRgnCd":{"type":"string","description":"Deliverable Area"},"deliDday":{"type":"integer","format":"int32","description":"Delivery Lead Time"},"hsCd":{"type":"string","description":"HS Code"},"bpckPsbYn":{"type":"string","description":"Combined Delivery Availability"},"rtnPsbYn":{"type":"string","description":"Return Availability Status"},"exchPsbYn":{"type":"string","description":"Exchange Availability Status"},"rglrDeliGoodsYn":{"type":"string","description":"Subscription Delivery Product Status"},"stkMgrYn":{"type":"string","description":"Inventory Management Status"},"buyQtyLmtYn":{"type":"string","description":"Purchase Quantity Limit Status"},"minLmtQty":{"type":"integer","format":"int32","description":"Minimum Purchase Quantity"},"maxLmtQty":{"type":"integer","format":"int32","description":"Maximum Purchase Quantity"},"safeStkNotiYn":{"type":"string","description":"Safety Stock Alert Status"},"dtlDesc":{"type":"string","description":"Detailed Description"},"prGoodsContInfo":{"$ref":"#/components/schemas/PrGoodsContInfo","description":"Product Content Information"},"goodsNotiLisartCd":{"type":"string","description":"Notice Item Code"},"goodsNotiItemCd1":{"type":"string","description":"Notice Item 1"},"notiItemCmt1":{"type":"string","description":"Notice Item Content 1"},"goodsNotiItemCd2":{"type":"string","description":"Notice Item 2"},"notiItemCmt2":{"type":"string","description":"Notice Item Content 2"},"goodsNotiItemCd3":{"type":"string","description":"Notice Item 3"},"notiItemCmt3":{"type":"string","description":"Notice Item Content 3"},"goodsNotiItemCd4":{"type":"string","description":"Notice Item 4"},"notiItemCmt4":{"type":"string","description":"Notice Item Content 4"},"goodsNotiItemCd5":{"type":"string","description":"Notice Item 5"},"notiItemCmt5":{"type":"string","description":"Notice Item Content 5"},"goodsNotiItemCd6":{"type":"string","description":"Notice Item 6"},"notiItemCmt6":{"type":"string","description":"Notice Item Content 6"},"goodsNotiItemCd7":{"type":"string","description":"Notice Item 7"},"notiItemCmt7":{"type":"string","description":"Notice Item Content 7"},"goodsNotiItemCd8":{"type":"string","description":"Notice Item 8"},"notiItemCmt8":{"type":"string","description":"Notice Item Content 8"},"goodsNotiItemCd9":{"type":"string","description":"Notice Item 9"},"notiItemCmt9":{"type":"string","description":"Notice Item Content 9"},"goodsNotiItemCd10":{"type":"string","description":"Notice Item 10"},"notiItemCmt10":{"type":"string","description":"Notice Item Content 10"},"goodsNotiItemCd11":{"type":"string","description":"Notice Item 11"},"notiItemCmt11":{"type":"string","description":"Notice Item Content 11"},"goodsNotiItemCd12":{"type":"string","description":"Notice Item 12"},"notiItemCmt12":{"type":"string","description":"Notice Item Content 12"},"goodsNotiItemCd13":{"type":"string","description":"Notice Item 13"},"notiItemCmt13":{"type":"string","description":"Notice Item Content 13"},"goodsNotiItemCd14":{"type":"string","description":"Notice Item 14"},"notiItemCmt14":{"type":"string","description":"Notice Item Content 14"},"safeCertiTgtYn":{"type":"string","description":"Safety Certification Target Status"},"safeCertiGbCd1":{"type":"string","description":"Safety Certification Type Code 1"},"safeCertiOrnNm1":{"type":"string","description":"Safety Certification Agency Name 1"},"safeCertiNo1":{"type":"string","description":"Safety Certification No. 1"},"aplyStrDt1":{"type":"string","description":"Safety Certification Application Start Date 1"},"aplyEndDt1":{"type":"string","description":"Safety Certification Application End Date 1"},"safeCertiGbCd2":{"type":"string","description":"Safety Certification Type Code 2"},"safeCertiOrnNm2":{"type":"string","description":"Safety Certification Agency Name 2"},"safeCertiNo2":{"type":"string","description":"Safety Certification No. 2"},"aplyStrDt2":{"type":"string","description":"Safety Certification Application Start Date 2"},"aplyEndDt2":{"type":"string","description":"Safety Certification Application End Date 2"},"safeCertiGbCd3":{"type":"string","description":"Safety Certification Type Code 3"},"safeCertiOrnNm3":{"type":"string","description":"Safety Certification Agency Name 3"},"safeCertiNo3":{"type":"string","description":"Safety Certification No. 3"},"aplyStrDt3":{"type":"string","description":"Safety Certification Application Start Date 3"},"aplyEndDt3":{"type":"string","description":"Safety Certification Application End Date 3"},"safeCertiGbCd4":{"type":"string","description":"Safety Certification Type Code 4"},"safeCertiOrnNm4":{"type":"string","description":"Safety Certification Agency Name 4"},"safeCertiNo4":{"type":"string","description":"Safety Certification No. 4"},"aplyStrDt4":{"type":"string","description":"Safety Certification Application Start Date 4"},"aplyEndDt4":{"type":"string","description":"Safety Certification Application End Date 4"},"safeCertiGbCd5":{"type":"string","description":"Safety Certification Type Code 5"},"safeCertiOrnNm5":{"type":"string","description":"Safety Certification Agency Name 5"},"safeCertiNo5":{"type":"string","description":"Safety Certification No. 5"},"aplyStrDt5":{"type":"string","description":"Safety Certification Application Start Date 5"},"aplyEndDt5":{"type":"string","description":"Safety Certification Application End Date 5"},"prAssocGoodsInfoList":{"$ref":"#/components/schemas/RealGridCUDRequestPrAssocGoodsInfo","description":"Linked Product Information"},"prAdveWrdHistList":{"type":"array","description":"Product Promotional Copy History","items":{"$ref":"#/components/schemas/PrAdveWrdHist"}},"prGoodsIconInfoList":{"$ref":"#/components/schemas/RealGridCUDRequestPrGoodsIconInfo","description":"Product Icon Information"},"prGoodsAttInfoList":{"type":"array","description":"Product Category Attribute Information","items":{"$ref":"#/components/schemas/PrGoodsAttInfo"}},"prRsvSaleHist":{"$ref":"#/components/schemas/PrRsvSaleHist","description":"Reserved Sale History"},"prGoodsItemInfoList":{"type":"array","description":"Product Notice Item Information","items":{"$ref":"#/components/schemas/PrGoodsItemInfo"}},"prGoodsSafeCertiHistList":{"type":"array","description":"Product Safety Certification Information","items":{"$ref":"#/components/schemas/PrGoodsSafeCertiHist"}},"prGoodsPayMeanInfoList":{"type":"array","description":"Product Payment Method Information","items":{"$ref":"#/components/schemas/PrGoodsPayMeanInfo"}},"prDispGoodsInfoList":{"$ref":"#/components/schemas/RealGridCUDRequestPrDispGoodsInfo","description":"Display Category"},"prGoodsPrceHist":{"$ref":"#/components/schemas/PrGoodsPrceHist","description":"Product Price History"},"optnYn":{"type":"string","description":"Option Management Status"},"prItmBase":{"$ref":"#/components/schemas/PrItmBase","description":"Item Information"}}},"PrGoodsContInfo":{"type":"object","description":"Product Content Information","properties":{"goodsNo":{"type":"string","description":"Product No."},"contTypCd":{"type":"string","description":"Content Type Code (PR017) 01: Detailed Description, 02: Video, 03: Product Image"},"contSn":{"type":"string","description":"Content Serial No."},"goodsDtlDesc":{"type":"string","description":"Product Detailed Description"},"imgGbCd":{"type":"string","description":"Image Type Code (PR031) P10: Basic Image, P20: Additional Image, M10: Video"},"dispSeq":{"type":"integer","format":"int32","description":"Display Order"},"contFilePathNm":{"type":"string","description":"Content File Path"},"contFileNm":{"type":"string","description":"Content File Name"},"trnfTextCont":{"type":"string","description":"Alt Text Content"},"useYn":{"type":"string","description":"Usage Status"},"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":"Related Product Information","properties":{"goodsNo":{"type":"string","description":"Product No."},"asctGoodsNo":{"type":"string","description":"Related Product No."},"asctGbCd":{"type":"string","description":"Related Type Code"},"sortSeq":{"type":"integer","format":"int32","description":"Sort Order"}}},"PrAdveWrdHist":{"type":"object","description":"Product Promotional Copy History","properties":{"goodsNo":{"type":"string","description":"Product No."},"aplyStrDtm":{"type":"string","format":"date-time","description":"Application Start Date"},"aplyEndDtm":{"type":"string","format":"date-time","description":"Application End Date"},"adveWrd":{"type":"string","description":"Promotional Text"},"useYn":{"type":"string","description":"Usage Status"}}},"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":"Product Icon Information","properties":{"siteNo":{"type":"string","description":"Site No."},"goodsNo":{"type":"string","description":"Product No."},"dispIconNo":{"type":"string","description":"Display Icon No."},"siteNm":{"type":"string","description":"Site Name"},"iconNm":{"type":"string","description":"Icon Name"},"dispMediaCdNm":{"type":"string","description":"Display Media"},"iconTypCdNm":{"type":"string","description":"Icon Type"},"aplyStrDtm":{"type":"string","format":"date-time","description":"Application Start Date/Time"},"aplyEndDtm":{"type":"string","format":"date-time","description":"Application End Date/Time"},"iconPathNm":{"type":"string","description":"Icon Image Path"},"delYn":{"type":"string","description":"Deletion Status"}}},"PrGoodsAttInfo":{"type":"object","properties":{"langCd":{"type":"string","description":"Language Code (CM009)"},"goodsNo":{"type":"string","description":"Product No."},"attCd":{"type":"string","description":"Attribute Code"},"attVal":{"type":"string","description":"Attribute Value"},"stdCtgNo":{"type":"string","description":"Standard Category No."}}},"PrRsvSaleHist":{"type":"object","description":"Reserved Sale History","properties":{"goodsNo":{"type":"string","description":"Product No."},"rsvStrtDtm":{"type":"string","format":"date-time","description":"Reservation Start Date/Time"},"rsvEndDtm":{"type":"string","format":"date-time","description":"Reservation End Date/Time"},"rsvEndAfProcMethCd":{"type":"string","description":"Sales Method After Reservation Ends (PR011)"},"rsvStopYn":{"type":"string","description":"Reservation Suspended Status"},"rsvStopCausCd":{"type":"string","description":"Reservation Stop Reason Code (PR034)"},"rsvStopDtm":{"type":"string","format":"date-time","description":"Reservation Suspension Date/Time"},"fwdidcPrarDy":{"type":"string","description":"Scheduled Shipment Instruction Date"}}},"PrGoodsItemInfo":{"type":"object","description":"Product Item Information","properties":{"goodsNo":{"type":"string","description":"Product No."},"goodsNotiLisartCd":{"type":"string","description":"Product Disclosure Item Code"},"goodsNotiItemCd":{"type":"string","description":"Product Notification Item Code"},"notiItemCmt":{"type":"string","description":"Notice Item Content"}}},"PrGoodsSafeCertiHist":{"type":"object","description":"Product Safety Certification History","properties":{"goodsNo":{"type":"string","description":"Product No."},"safeCertiGbCd":{"type":"string","description":"Safety Certification Type Code"},"safeCertiNo":{"type":"string","description":"Safety Certification No."},"aplyStrDt":{"type":"string","description":"Application Start Date"},"aplyEndDt":{"type":"string","description":"Application End Date"},"safeCertiOrnNm":{"type":"string","description":"Safety Certification Agency Name"}}},"PrGoodsPayMeanInfo":{"type":"object","description":"Product Payment Method Information","properties":{"goodsNo":{"type":"string","description":"Product No."},"payWayCd":{"type":"string","description":"Payment Method Code"},"useYn":{"type":"string","description":"Usage Status"}}},"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":"Display Category Basic_Product Information","properties":{"goodsNo":{"type":"string","description":"Product No."},"dispCtgNo":{"type":"string","description":"Display Category No."},"dispYn":{"type":"string","description":"Display Status"},"errorMessage":{"type":"string","description":"Error Message","readOnly":true},"goodsList":{"type":"array","description":"Product No. List","items":{"type":"string"}},"goodsArray":{"type":"array","description":"Product No. Array","items":{"type":"string"}},"itemList":{"type":"array","description":"SKU No. List","items":{"type":"string"}},"itemArray":{"type":"array","description":"SKU No. Array","items":{"type":"string"}},"goodsNm":{"type":"string","description":"Product Name","readOnly":true},"goodsTypCd":{"type":"string","description":"Product Type","readOnly":true},"norPrc":{"type":"number","description":"Regular Price","readOnly":true},"salePrc":{"type":"number","description":"Selling Price","readOnly":true},"saleStatCd":{"type":"string","description":"Sales Status","readOnly":true},"entrNm":{"type":"string","description":"Vendor Name","readOnly":true},"goodsImg":{"type":"string","description":"Product Image","readOnly":true},"moodTagVal":{"type":"string","description":"Mood","readOnly":true},"wght":{"type":"string","description":"Weight","readOnly":true}}},"PrGoodsPrceHist":{"type":"object","description":"Product Price History","properties":{"goodsNo":{"type":"string","description":"Product No."},"histStrDtm":{"type":"string","format":"date-time","description":"History Start Date/Time"},"histEndDtm":{"type":"string","format":"date-time","description":"History End Date/Time"},"supPcost":{"type":"number","description":"Supply Cost"},"norPrc":{"type":"number","description":"Regular Price"},"salePrc":{"type":"number","description":"Selling Price"},"eventPrc":{"type":"number","description":"Promotional Price"},"mrgnRate":{"type":"number","description":"Margin Rate"},"goodsPrceTypCd":{"type":"string","description":"Product Price Type Code"},"prcChgCausCd":{"type":"string","description":"Price Change Reason Code (PR033)"},"prcChgCausCdNm":{"type":"string","description":"Reason for Price Change"},"timeDealYn":{"type":"string","description":"Time Deal Status"},"supPcostByMrgn":{"type":"number","writeOnly":true}}},"PrItmBase":{"type":"object","description":"SKU Basic","properties":{"goodsNo":{"type":"string","description":"Product No."},"itmNo":{"type":"string","description":"Item No."},"optnCatNm1":{"type":"string","description":"Option Category Name_1"},"optnNm1":{"type":"string","description":"Option Name 1"},"optnCatNm2":{"type":"string","description":"Option Category Name_2"},"optnNm2":{"type":"string","description":"Option Name 2"},"optnCatNm3":{"type":"string","description":"Option Category Name_3"},"optnNm3":{"type":"string","description":"Option Name 3"},"optnCatNm4":{"type":"string","description":"Option Category Name_4"},"optnNm4":{"type":"string","description":"Option Name 4"},"optnCatNm5":{"type":"string","description":"Option Category Name_5"},"optnNm5":{"type":"string","description":"Option Name 5"},"lgcItmNo":{"type":"string","description":"Internal Item No."},"itmSaleStatCd":{"type":"string","description":"Item Sales Status Code (PR005) 01: Temporary Save, 02: Pending Approval, 03: Rejected, 10: On Sale, 20: Sold Out, 40: Discontinued"},"itmSaleStatCdNm":{"type":"string","description":"Unit Sales Status Code Name"},"saleStatChgCausCd":{"type":"string","description":"Sales Status Change Reason Code (PR058) 41: Sales Ended (Normal) 42: Sales Ended (Deleted)"},"repItmYn":{"type":"string","description":"Representative Item Status"},"dispSeq":{"type":"integer","format":"int32","description":"Display Order"},"addSupPcost":{"type":"number","description":"Additional Supply Cost"},"addSalePrc":{"type":"number","description":"Additional Sales Price"},"soutCausCd":{"type":"string","description":"Out-of-Stock Reason Code (PR032) 10: Automatic out-of-stock processing due to shipment unavailable, 11: Out-of-stock processing due to 0 stock quantity, 12: Manual out-of-stock processing by administrator, 13: Automatic out-of-stock processing due to next-day delivery delay, 14: Product out-of-stock processing due to all units out of stock, 15: Reserved product out-of-stock processing, 16: Out of stock due to bundle product out of stock"},"limtQty":{"type":"integer","format":"int32","description":"Reserved Limited Quantity"},"stkQty":{"type":"integer","format":"int32","description":"Stock Quantity"},"safeStkNotiYn":{"type":"string","description":"Safety Stock Alert Status"},"safeStkQty":{"type":"integer","format":"int32","description":"Safety Stock Quantity"},"optnCatNo1":{"type":"string","description":"Option Category No._1"},"optnNo1":{"type":"string","description":"Option No._1"},"optnCatNo2":{"type":"string","description":"Option Category No._2"},"optnNo2":{"type":"string","description":"Option No._2"},"optnCatNo3":{"type":"string","description":"Option Category No._3"},"optnNo3":{"type":"string","description":"Option No._3"},"optnCatNo4":{"type":"string","description":"Option Category No._4"},"optnNo4":{"type":"string","description":"Option No._4"},"optnCatNo5":{"type":"string","description":"Option Category No._5"},"optnNo5":{"type":"string","description":"Option No._5"},"giftRegistDefaultValue":{"type":"string","writeOnly":true},"addSupPcostByMargn":{"type":"number","writeOnly":true}}},"ExcelUploadVersionRequestV2":{"type":"object","description":"Excel Version Request","properties":{"rowIndex":{"type":"integer","format":"int32","description":"Excel Row No."},"version":{"type":"string","description":"Version"}}},"ExcelUploadGoodsResponse":{"type":"object","description":"Excel Product Response","properties":{"rowIndex":{"type":"integer","format":"int32","description":"Excel Row No."},"goodsNm":{"type":"string","description":"Product Name"},"entrNo":{"type":"string","description":"Vendor No."},"stdCtgNo":{"type":"string","description":"Standard Category No."},"lgcGoodsNo":{"type":"string","description":"Internal Product No."},"goodsDuplicationYn":{"type":"string","description":"Product Duplication Status"}}},"ExcelUploadCodeRequestV2":{"type":"object","description":"Excel Common Code Request","properties":{"key":{"type":"string","description":"Group Code No."},"cd":{"type":"string","description":"Code No."},"cdNm":{"type":"string","description":"Code Name"}}},"ExcelUploadEntrRequestV2":{"type":"object","description":"Excel Vendor Request","properties":{"entrNo":{"type":"string","description":"Vendor No."},"entrNm":{"type":"string","description":"Vendor Name"},"buyTypCd":{"type":"string","description":"Purchase Type Code"},"buyTypCdNm":{"type":"string","description":"Purchase Type Name"},"deliProcTypCd":{"type":"string","description":"Delivery Processing Type Code"},"deliProcTypCdNm":{"type":"string","description":"Delivery Processing Type Name"},"mrgnRateGbCd":{"type":"string","description":"Margin Rate Type Code"},"mrgnRateGbCdNm":{"type":"string","description":"Margin Rate Type Name"},"mrgnRate1":{"type":"number","description":"Margin Rate 1"},"mrgnRate2":{"type":"number","description":"Margin Rate 2"},"bmanKindCd":{"type":"string","description":"Business Type Code"},"bmanKindCdNm":{"type":"string","description":"Business Type Code Name"}}},"ExcelUploadBrandRequestV2":{"type":"object","description":"Excel Brand Request","properties":{"brandNo":{"type":"string","description":"Brand No."},"brandNm":{"type":"string","description":"Brand Name"}}},"ExcelUploadStdCtgRequestV2":{"type":"object","description":"Excel Leaf Standard Category Request","properties":{"stdCtgNo":{"type":"string","description":"Standard Category No."},"stdCtgNm":{"type":"string","description":"Standard Category Name"},"safeCertiNeedYn":{"type":"string","description":"Safety Certification Target Status"},"goodsNotiLisartCd":{"type":"string","description":"Notice Item Code"},"mrgnRate":{"type":"number","format":"double","description":"Category Margin Rate"}}},"ExcelUploadGoodsNotiLisartRequestV2":{"type":"object","description":"Excel Product Notice Item Request","properties":{"goodsNotiLisartCd":{"type":"string","description":"Product Notification Item Code"},"goodsNotiLisartNm":{"type":"string","description":"Product Notice Item Name"},"goodsNotiItemCd1":{"type":"string","description":"Notice Item 1"},"goodsNotiItemNm1":{"type":"string","description":"Notice Item Name 1"},"goodsNotiItemCd2":{"type":"string","description":"Notice Item 2"},"goodsNotiItemNm2":{"type":"string","description":"Notice Item Name 2"},"goodsNotiItemCd3":{"type":"string","description":"Notice Item 3"},"goodsNotiItemNm3":{"type":"string","description":"Notice Item Name 3"},"goodsNotiItemCd4":{"type":"string","description":"Notice Item 4"},"goodsNotiItemNm4":{"type":"string","description":"Notice Item Name 4"},"goodsNotiItemCd5":{"type":"string","description":"Notice Item 5"},"goodsNotiItemNm5":{"type":"string","description":"Notice Item Name 5"},"goodsNotiItemCd6":{"type":"string","description":"Notice Item 6"},"goodsNotiItemNm6":{"type":"string","description":"Notice Item Name 6"},"goodsNotiItemCd7":{"type":"string","description":"Notice Item 7"},"goodsNotiItemNm7":{"type":"string","description":"Notice Item Name 7"},"goodsNotiItemCd8":{"type":"string","description":"Notice Item 8"},"goodsNotiItemNm8":{"type":"string","description":"Notice Item Name 8"},"goodsNotiItemCd9":{"type":"string","description":"Notice Item 9"},"goodsNotiItemNm9":{"type":"string","description":"Notice Item Name 9"},"goodsNotiItemCd10":{"type":"string","description":"Notice Item 10"},"goodsNotiItemNm10":{"type":"string","description":"Notice Item Name 10"},"goodsNotiItemCd11":{"type":"string","description":"Notice Item 11"},"goodsNotiItemNm11":{"type":"string","description":"Notice Item Name 11"},"goodsNotiItemCd12":{"type":"string","description":"Notice Item 12"},"goodsNotiItemNm12":{"type":"string","description":"Notice Item Name 12"},"goodsNotiItemCd13":{"type":"string","description":"Notice Item 13"},"goodsNotiItemNm13":{"type":"string","description":"Notice Item Name 13"},"goodsNotiItemCd14":{"type":"string","description":"Notice Item 14"},"goodsNotiItemNm14":{"type":"string","description":"Notice Item Name 14"}}},"ValidationError":{"type":"object","properties":{"field":{"type":"string","description":"field"},"message":{"type":"string","description":"field message"}}}}},"paths":{"/v2/goods/goodsBatchRegistApi/goodsBatchRegist.excelUpload":{"post":{"tags":["Product Bulk Registration"],"summary":"Bulk Product Registration Screen _ Save Excel File and Check Excel Data","description":"Saves the Excel file and checks the Excel data on the bulk product registration screen.","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"}}}}}}}}}
```

## Product Batch Registration Screen\_Download Excel Upload Template

> Downloads the Excel upload template from the Product Batch Registration tab on the Product Batch Registration screen.

```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":["Product Bulk Registration"],"summary":"Product Batch Registration Screen_Download Excel Upload Template","description":"Downloads the Excel upload template from the Product Batch Registration tab on the Product Batch Registration screen.","operationId":"saveExcelGoodsList_1","responses":{"200":{"description":"OK","content":{"*/*":{"schema":{"type":"string","format":"byte"}}}}}}}}}
```

## Search Product Excel Upload History List for Product Batch Registration

> \## Function Description\
> \* Searches the product Excel upload history list on the Product Batch Registration page.\
> \---\
> \## Detailed Description\
> \* For PO users, only Excel files matching the vendor of the logged-in user can be viewed.\
> \---\
> \## Revision History\
> \* Release v1.05\_231204 : Newly created product Excel batch registration<br>

```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":"Product Excel Upload History Request","properties":{"goodsExlUpldSeq":{"type":"string","description":"Product Excel Upload Sequence No."},"entrNo":{"type":"string","description":"Vendor No."},"exlFilePathNm":{"type":"string","description":"Excel File Path Name"},"exlFileNm":{"type":"string","description":"Excel File Name"},"totCnt":{"type":"integer","format":"int32","description":"Total Count"},"sucsCnt":{"type":"integer","format":"int32","description":"Success Count"},"failCnt":{"type":"integer","format":"int32","description":"Failure Count"}}},"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":"Product Excel Upload History Response","properties":{"sysRegDtm":{"type":"string","format":"date-time","description":"Registration Date"},"goodsExlUpldSeq":{"type":"string","description":"Product Excel Upload Sequence No."},"entrNo":{"type":"string","description":"Vendor No."},"entrNm":{"type":"string","description":"Vendor Name"},"exlFilePathNm":{"type":"string","description":"Excel File Path Name"},"exlFileNm":{"type":"string","description":"Excel File Name"},"totCnt":{"type":"integer","format":"int32","description":"Total Count"},"sucsCnt":{"type":"integer","format":"int32","description":"Success Count"},"failCnt":{"type":"integer","format":"int32","description":"Failure Count"},"sucsFailYn":{"type":"string","description":"Success/Failure Status"},"totalCount":{"type":"integer","format":"int32","description":"Excel List Total Count"}}},"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":["Product Bulk Registration"],"summary":"Search Product Excel Upload History List for Product Batch Registration","description":"## Function Description\n* Searches the product Excel upload history list on the Product Batch Registration page.\n---\n## Detailed Description\n* For PO users, only Excel files matching the vendor of the logged-in user can be viewed.\n---\n## Revision History\n* Release v1.05_231204 : Newly created product Excel batch registration\n","operationId":"getGoodsUploadHistoryList","parameters":[{"name":"request","in":"query","required":true,"schema":{"$ref":"#/components/schemas/GoodsUploadHistoryRequest"}}],"responses":{"200":{"description":"Search Product Excel Upload History List for Product Batch Registration Success","content":{"*/*":{"schema":{"$ref":"#/components/schemas/ResponseRealGridListResponseGoodsUploadHistoryResponse"}}}},"900":{"description":"Search Product Excel Upload History List for Product Batch Registration Failure","content":{"*/*":{"schema":{"$ref":"#/components/schemas/ErrorCode"}}}}}}}}}
```