Plant structure from Excel
Start with this file: the areas, lines and stores the next two files refer to.
The steps
- Download the template from this button and open it in Excel.
- Fill in from row 5. Keep the headings as they are.
- In the Windows app open the page Plant structure, press “Upload Excel”, and choose the file.
- If a row is wrong you see its number and why, and nothing is added until it is fixed.
The columns
| Column | Required? | Example | Note |
|---|---|---|---|
| Area | No | Packing | |
| Area code | No | PKG | Capital English letters, numbers and dashes |
| Line | No | Line 1 | Needs its area |
| Line code | No | PKG-L1 | |
| Store | No | Main store | On its own row |
| Store code | No | MAIN |
Good to know
- Each row is an area (with its line, if any) or a store, not both.
- Repeating an area across rows is fine: each row adds a line inside it.
- What exists stays as it is, so uploading the same file again is safe.
- One file holds up to 2000 rows. For more, split it into two files.