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

# Bulk Product Registration

Provides functionality to register a large volume of products in bulk, save the necessary information, and efficiently look up the registered products.

***

## Key Features

* **Bulk Registration, Save, and Lookup**
  * Provides functionality to register a large volume of products in bulk, save the necessary information, and efficiently look up the registered product information.
* **Excel Version Match Check**
  * Checks whether the version of the downloaded Excel file matches the actual Excel form version, to prevent user error.
* **Duplicate Key Check**
  * Uses the product name, partner, standard classification code, and internal product number as the duplicate key to check for duplicate products and prevent registration.
* **Detailed Error Message**
  * Specifies the error for each row and column, so that users can easily correct incorrect product information.

## Process Definition

<figure><img src="https://2999922013-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXTxKSWMmuxEkop1pvuwe%2Fuploads%2FYir94oaIAqQIqkIFfCxj%2F%E1%84%89%E1%85%A1%E1%86%BC%E1%84%91%E1%85%AE%E1%86%B7%20%E1%84%8B%E1%85%B5%E1%86%AF%E1%84%80%E1%85%AA%E1%86%AF%E1%84%83%E1%85%B3%E1%86%BC%E1%84%85%E1%85%A9%E1%86%A8.png?alt=media&#x26;token=e65f3391-2536-4f5b-a21e-a9d42926e1de" alt=""><figcaption></figcaption></figure>

{% stepper %}
{% step %}

### Basic Data Lookup Required for Bulk Product Registration Data Validation

When the user clicks to download the upload form, the common codes, partners, brands, leaf standard categories, and product notification item list required for the form's reference sheet are looked up from each DB.

When the user clicks to select a bulk registration file, the duplicate check products, common codes, partners, brands, leaf standard categories, and product notification item list required for validating the entered data are looked up from each DB.
{% endstep %}

{% step %}

### Save Bulk Product Registration Excel File and Excel Upload Error

When the user clicks to select a bulk registration file, the file is saved to the Product Excel Upload History DB.

Error messages identified in the file are saved to the Excel Upload Error Information DB.
{% endstep %}

{% step %}

### Bulk Product Registration Excel Product Registration

Once data validation is complete, products with no errors are saved to each product information DB.
{% endstep %}

{% step %}

### Bulk Product Registration Product Excel Upload History List Lookup

Looks up the list of previously uploaded product Excel upload files from the Product Excel Upload History DB.
{% endstep %}
{% endstepper %}

## API Function List

<table><thead><tr><th width="131.2220458984375">API</th><th width="394">Description</th><th width="93.5555419921875">Server</th><th width="89.111083984375">Method</th><th>Remarks</th></tr></thead><tbody><tr><td>Save Bulk Product Registration Excel File and Excel Upload<br>Error</td><td>•Saves the Excel file and Excel upload errors in bulk product registration.<br>•For PO, when saving the Excel file, it is saved with the logged-in user's partner data.<br>•For a product duplication error in the Excel upload error, the cell is saved as 0.</td><td>BO</td><td>POST</td><td><a href="https://apibo.x2bee.com/content?bo=goods&#x26;depth=%EC%83%81%ED%92%88%20%EC%9D%BC%EA%B4%84%20%EB%93%B1%EB%A1%9D&#x26;path=saveExcelUploadFile">🔗View API ></a></td></tr><tr><td>Bulk Product Registration Excel Product<br>Registration</td><td><p>•Saves the product data from the Excel file uploaded in bulk product registration.</p><p>•Saves the normal product list for which data validation is complete.</p><p>•The save language is based on the default language code, ko.</p><p>•The available payment method is set to All as the initial value.</p></td><td>BO</td><td>POST</td><td><a href="https://apibo.x2bee.com/content?bo=goods&#x26;depth=%EC%83%81%ED%92%88%20%EC%9D%BC%EA%B4%84%20%EB%93%B1%EB%A1%9D&#x26;path=saveExcelUploadFile">🔗View API ></a></td></tr><tr><td>Bulk Product Registration Basic Data Lookup Required for Data Validation</td><td><p>•Looks up the basic data required for validating bulk product registration data.</p><p>•For BO, the list of all partners is looked up.</p><p>•For PO, the logged-in user's partner is looked up.</p></td><td>BO</td><td>POST</td><td><a href="https://apibo.x2bee.com/content?bo=goods&#x26;depth=%EC%83%81%ED%92%88%20%EC%9D%BC%EA%B4%84%20%EB%93%B1%EB%A1%9D&#x26;path=excelUploadBasicData">🔗View API ></a></td></tr><tr><td>Bulk Product Registration Product Excel<br>Upload History<br>List Lookup</td><td>•Looks up the product Excel upload history<br>list on the Bulk Product Registration page.<br>•For PO, only Excel files matching the logged-in user's partner can be looked up.</td><td>BO</td><td>GET</td><td><a href="https://apibo.x2bee.com/content?bo=goods&#x26;depth=%EC%83%81%ED%92%88%20%EC%9D%BC%EA%B4%84%20%EB%93%B1%EB%A1%9D&#x26;path=getGoodsUploadHistoryList">🔗View API ></a></td></tr></tbody></table>

## Terminology

<table><thead><tr><th width="242.888916015625">Term</th><th>Description</th><th data-hidden></th></tr></thead><tbody><tr><td>Excel Upload Error</td><td><p>•Excel upload errors are checked in the order of required status, format, byte, and logic for each column.</p><p>•If a column has multiple errors, the error that comes first in the above order is recognized.</p></td><td></td></tr><tr><td>Basic Data Required for Data Validation</td><td>•The basic data required for data validation is the list of common codes, partners, brands, leaf standard categories, and product notification items.</td><td></td></tr></tbody></table>

## Other Notes

* Bulk Product Registration Basic Data Lookup Required for Data Validation API
  * For BO, the list of all partners is looked up.
  * For PO, the logged-in user's partner is looked up.
* Bulk Product Registration Excel File and Excel Upload Error Save API
  * For PO, when saving the Excel file, it is saved with the logged-in user's partner data.
  * For a product duplication error in the Excel upload error, the cell is saved as 0.
* Bulk Product Registration Excel Product Registration API
  * Saves the normal product list for which data validation is complete.
  * The save language is based on the default language code, ko.
  * The available payment method is set to All as the initial value.
  * The display category list mapped to the standard classification is saved as the initial value.
* Bulk Product Registration Product Excel Upload History List Lookup API
  * For PO, only Excel files matching the logged-in user's partner can be looked up.