Upload PO Dashboard (Bulk Order Upload)
Overview
We’re excited to introduce the Upload PO Dashboard, a new feature that allows users to upload multiple Purchase Orders (POs) for a selected size group directly through an Excel file.
This enhancement simplifies the process of adding large numbers of production orders for upcoming seasons — reducing manual entry time, minimizing human error, and ensuring consistent data formatting across all factories.
🎯 Purpose
The Upload PO Dashboard enables users to:
Upload a Purchase Order file linked to a specific size group.
Automatically validate, normalize, and convert Excel data into structured order payloads ready for system insertion.
Handle bulk seasonal orders quickly and safely.
🧭 User Workflow
1. Go to Data Upload in the side menu
From the side menu, select the Data Upload page
2. Select Size Group
From the dropdown list, choose the relevant size group for your uploaded POs.
3. Download Template
Click “Download Template” to get the Excel file with predefined headers.
This ensures your data matches the system format and passes all validations.
4. Fill the Excel File
Please follow these rules carefully:
Do not rename, delete, or add new headers.
Do not add new sheets to the file.
Avoid saving the file in a different format (e.g.,
.csv → .csv.xlsx).
🧠 Important Tip:
Columns such as PO, STYLECODE, and CONTRACTCODE may contain long numeric values.
To prevent Excel from converting them to scientific notation:
Select the column → Data → Text to Columns → Next → Next → Text → Finish
5. Upload File
Once the file is ready:
Upload it to the dashboard.
The system will automatically validate and transform your data into structured order payloads.
✅ Handled Cases and Validations
| Category | Handled Case | Behavior / Validation |
|---|---|---|
| Empty Fields | Missing PO, Client, or Style | ❌ Error: “PO/Client/Style can’t be empty.” |
| Client, Style, Color Validation | Client/style/color not found | Compares normalized text with existing database records |
| Inconsistent Data | Same PO but different Client, ContractCode, or StyleCode | ❌ Error: all rows in same PO must match these values |
| Duplicate/Grouped PO Handling | Multiple rows for same PO | Groups them and ensures consistency per PO |
| Quantity Validation | Quantities defined but color empty | ❌ Error: “Color can't be empty when quantities exist.” |
| Size Validation | Quantities entered for size not defined in style | ❌ Error: “Invalid size — size not defined for this style.” |
🧹 Text Normalization
Before comparison, all text values go through normalization to ensure consistency.
| Input | Database Value | Match? |
|---|---|---|
reD | Red | ✅ Yes |
red 2 | red2 | ✅ Yes |
red-2 | red2 | ✅ Yes |
redd | red | ❌ No |
Led | red2 | ❌ No |
Normalization includes:
Removing extra spaces
Removing special characters
Converting to lowercase
Sorting words alphabetically
📤 Submitting Orders
After successful validation, proceed to Submit Orders.
Each PO is submitted individually.
The system automatically uploads each valid order to the database.
The dashboard then separates successful and failed orders.
✅ Successful Orders
Orders that pass all validations will be saved successfully to the database.
❌ Failed Orders
If any order fails to upload, it will appear in a separate Failed Orders Table below.
Common Failure Reason:
Duplicate PO numbers found in the system.
🔧 Fixing Failed Orders
If your file contains failed orders:
Download the failed records.
Correct the issues (e.g., duplicate PO).
Re-upload the corrected Excel file.
The system will re-validate and process the fixed orders automatically.
💡 Summary
The Upload PO Dashboard provides an efficient way to:
Bulk upload orders with consistent formatting
Validate data automatically before submission
Save time for planning, merchandising, and production teams
This feature is especially helpful for factories planning next-season orders or handling large PO batches from clients.
Related Articles
Create bulk batches
To create bulk batches automatically, you can follow any of the following methods: Select "Confirm and Add Batches" during the cutting order addition phase. From the Cutting Orders page, right-click on the cutting order for which you want to create ...PO Costing Report
The Production Order Costing Report provides users with a comprehensive overview of all costs associated with a single production order. This report offers insights into the status of the order, its associated production sections, and various cost ...Kanban Dashboard
This guide is structured to help users understand the key concepts of the new feature which is Kanban Dashboard. By the end of this guide, you'll have a clear understanding of the Kanban and how to use it effectively. Step 1: Permission Control To be ...Production Order Report
The PO Report provides comprehensive data and insights for a specific production order. It offers a detailed overview of the order's progress and timeline, highlighting key events throughout its lifecycle. The report focuses on six main events that ...How to long term plan order?
In the Garment IO system, planning the production order plays a crucial role in optimizing resources, maximizing efficiency, and ensuring a smooth production process. This chapter will guide you through the steps involved in planning a production ...