Import Orders
Path · Orders > Orders > Import Orders
A screen for registering multiple orders at once with an Excel template. Used for bulk manual order registration.
💡 Key Features
✅ Download template → fill in Excel → upload → validation → save is the flow.
✅ Only rows that pass validation are saved; failed rows can be fixed and re-uploaded after checking the errors.
✅ Only .xls / .xlsx formats are supported.
💡 Excel Guide : check the Excel Guide button at the top right for the master lists of registrable channels and SKUs.
📌User Flow
Download the Excel template
Fill in the Excel file (see the Excel Guide)
Upload the file → automatic validation
Check the validation results, then save
View saved orders in the Orders screen
🛒 Import Orders
Step 1. Download the Template
Click the Download Template button in the center of the screen.
Never modify the header row — it is the key for data changes.
Step 2. Fill in the Excel File
Enter order information in the downloaded form. Required fields are marked with *.
Required Columns
Column | Description |
|---|---|
*Channel Order No. | Order number issued by the channel |
*Channel | Channel code (see the Excel Guide) |
*Channel Order Date or Channel Payment Date | One of the two is required (YYYY-MM-DD) |
*SKU | A SKU registered in the system |
*Order Qty | Order quantity (integer) |
*Order Amount | Unit price per SKU (0 or more) |
*Currency | Currency of the order amount (e.g. KRW) |
*Orderer Name | Billing Name |
*Recipient Name | Shipping Name |
*Country | Shipping country code |
*Address | Shipping address |
*Phone | Recipient phone number |
Optional Columns
Column | Description |
|---|---|
Product Name | Channel product name |
Channel Product Code | Channel product identifier |
Channel Option Code | Channel option identifier |
Address 2 / City / State / Zip Code | Additional address info by country |
Recipient email | |
Delivery Memo | Delivery instructions |
Remarks | Order notes |
Step 3. Upload and Save
Drag & drop the completed file into the upload area or use the Upload Excel button.
Validation → check results in the Result area → click Save at the top right.
⚠️ Only .xls / .xlsx formats are supported. CSV cannot be uploaded.
🔍 Validation Results (Result)
Step 1. Validation Stages
Stage | What is checked | Possible outcomes |
|---|---|---|
1. Integrity check | File-level problems (missing required values, duplicate data, etc.) | File failure |
2. Validity check | Value errors (invalid channel codes, format errors, etc.) | Success / Partial failure / Failure |
Step 2. Result Display
Upload history (Area A)
2026-05-15 14:30 | Orders_bulk.xlsx | Success (50 succeeded)
2026-05-14 09:15 | Orders_bulk.xlsx | Partial failure (5 failed / 45 succeeded)
2026-05-13 11:00 | Orders_bulk.xlsx | Failure (30 failed / 0 succeeded)
2026-05-12 09:00 | Orders_bulk.xlsx | File failure (check the file)Row-level error example (Area B)
Row Channel Order No. Error
2 CH-ORDER-0002 No matching product code
5 CH-ORDER-0005 Order amount missing (required)
15 CH-ORDER-0015 Invalid channel
45 CH-ORDER-0045 "City" validation error
50 CH-ORDER-0050 "Zip Code" validation errorStep 3. What Each Result Means
Label | Meaning | Action |
|---|---|---|
🟢 Success | All rows valid |
|
🟡 Partial failure | Some rows failed |
|
🔴 Failure | All rows failed | Fix the Excel file and re-upload |
⚫ File failure | File-level problem | Check for missing required values and duplicates, then redo |
❗ Common Errors
Error message | Cause | Fix |
|---|---|---|
No matching product code | SKU not registered in the system | Register the SKU first in Product |
Invalid channel | Wrong channel code | Check the channel codes in the Excel Guide |
Duplicate channel order number | Order number already registered | Remove duplicate rows |
Required field missing | A required column is empty | Fill in the column |
Address validation error | Address format doesn't match the country | Check the address format for the country code |
💾 Save
Saveregisters only the successful rows as orders.Saved orders start in Draft status.
After saving, check the new orders in the Orders screen.
Frequently asked questions for this doc
Some orders failed after a bulk upload. What should I do?
Check the failure reasons on the upload result screen. Download the failed records, make the necessary corrections, and re-upload only the affected rows.