Import Purchase Orders

Path · Inventory > Purchase Order > Import Purchase Orders

A screen for registering multiple POs at once with an Excel template. Used for bulk PO 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.
✅ .xls / .xlsx formats only.
💡 Excel Guide : check the Excel Guide button at the top right for the master lists of registrable
WMS, warehouses, stores, and suppliers.

📌User Flow

Download the Excel template
Fill in the Excel file (see the Excel Guide)
Upload → validation → save
View in the Purchase Order screen
WMS Sync button — be sure to send to the logistics system
Once the logistics center starts receiving, track progress in the PO receiving status

📑 Import Purchase Orders

Step 1. Download the Template

Click the Download Template link in the center of the screen.

💡 To register POs for a different customer, switch the Client at the top left first, then download the template.

Step 2. Fill in the Excel File

Enter PO information in the downloaded form. Required fields are marked with *.

Required Columns

Column	Description
*PO Name	Name to identify the PO. No duplicates
*Currency	Currency of the PO amount (e.g. KRW)
*Location	WMS/warehouse or store code (see the Excel Guide)
*SKU	A SKU registered in the system
*PO Quantity	Requested quantity (integer)
*PO Cost	Unit cost (0 or more)
*Stock Condition	`Normal` or `Damaged`

Optional Columns

Column	Description
Supplier	Supplier code (see the Excel Guide)
Shipping Type	Shipping method
Shipping Info	Tracking numbers, etc.
Expected Arrival Date	Expected warehouse arrival date (YYYY-MM-DD)
Remarks	PO-related notes

💡 WMS, warehouse, store, and supplier codes : check the Excel Guide at the top right.

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.
⚠️ .xls / .xlsx formats only.

🔍 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 codes, format errors, etc.)	Success / Partial failure / Failure

Step 2. Result Display

Upload history (Area A)

2026-05-15 14:30 | PO_bulk.xlsx | Success (50 succeeded)
2026-05-14 09:15 | PO_bulk.xlsx | Partial failure (5 failed / 45 succeeded)
2026-05-13 11:00 | PO_bulk.xlsx | Failure (30 failed / 0 succeeded)
2026-05-12 09:00 | PO_bulk.xlsx | File failure (check the file)

Row-level error example (Area B)

Row  SKU              Error
2    TT-CANVAS-BE     PO name missing (required)
5    BP-LAPTOP-BK     SKU does not exist in the system
15   DF-TRAVEL-NV     Invalid stock condition value (Normal or Damaged)

Step 3. What Each Result Means

Label	Meaning	Action
🟢 Success	All rows valid	`Save` to save all at once
🟡 Partial failure	Some rows failed	`Save` — only successful rows saved / fix failed rows and re-upload
🔴 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
SKU does not exist in the system	Unregistered SKU	Register the SKU first in Product
Duplicate PO name	A PO name that already exists	Use a different PO name
Location code error	Invalid WMS, warehouse, or store code	Check the master codes in the Excel Guide
Stock condition value error	`Normal` / `Damaged` — any other value	Enter the exact value

💾 Save

Saving registers only the successful rows as POs.
After saving, you're taken to the Purchase Order screen, with the new POs shown at the top.
After saving, you must run WMS Sync — warehouse receiving is only possible after that.