Overview
Instead of adding capacities one location at a time, you can fill in an Excel template and upload it. Logiwa IO has four capacity templates:
Option | Use it to |
Bulk Import Product Capacity | Create new product capacities |
Bulk Update Product Capacity | Change existing product capacities |
Bulk Import LP Capacity | Create new LP capacities |
Bulk Update LP Capacity | Change existing LP capacities |
What the capacities do once imported is explained in Add Product Capacity to a Location and Add LP Capacity to a Location.
When to use it
You're setting up Static Replenishment for a new pick area with hundreds of slots.
You're re-slotting and need to change Max Qty on many locations.
Prerequisites
The warehouse, locations, clients, products, pack types and LP types already exist. The import doesn't create them.
You can edit Locations.
Step-by-step
Go to Settings > Master Data > Locations.
Click Assign Capacity on the right and choose the option you need, for example Bulk Import Product Capacity.
Click Download to get the Excel template.
Fill in the template (see the column tables below). Delete the sample row before uploading.
Save the file, then drag it into the upload area or click Browse to select it.
Click Upload.
On the matching screen, check each row:
Matched shows a green check when the file's column header matches a Logiwa IO field, and a red X when it doesn't.
Preview Data shows the first three rows from your file.
For a red X, click Choose Field and select the Logiwa IO field the column belongs to. A field already used by another column can't be chosen again.
When every column is matched, click Import.
Wait a few seconds and click Refresh List to see the result in the import history.
Template tips:
Green columns are required. Gray columns are optional.
Don't rename the column headers. They're used to match your data to Logiwa IO fields.
A file can hold up to 20,000 rows. A larger file isn't imported; split it into several files.
Product capacity columns
Column | Required | Notes |
Warehouse Code | Yes | Must exist |
Location Code | Yes | Must exist in that warehouse |
Client | Yes | Must exist |
Product | Yes | Must belong to the client |
Pack Type | Yes | Must belong to the product. Min Qty and Max Qty are counted in this pack type |
Min Qty | No | Static Replenishment trigger |
Max Qty | No | Static Replenishment top-up level |
Rules:
Bulk Import fails a row if that location already has a capacity for the same client, product and pack type. Use Bulk Update for existing capacities.
The same product can go on many locations in one file, and the same product can have rows for different pack types on one location.
Example — Bulk Import Product Capacity:
Warehouse Code | Location Code | Client | Product | Pack Type | Min Qty | Max Qty |
NJ01 | A-01-01 | Acme | TSHIRT-M | Each | 20 | 120 |
NJ01 | A-01-02 | Acme | TSHIRT-L | Each | 20 | 120 |
NJ01 | B-05-01 | Acme | TSHIRT-M | Case | 2 | 6 |
Row 3 sets up a case-picking slot for the same SKU as row 1. Both import.
LP capacity columns
Column | Required | Notes |
Warehouse Code | Yes | Must exist |
Location Code | Yes | Must exist in that warehouse |
LP Type | Yes | Must exist |
Min Qty | No | Number of LPs |
Max Qty | No | Number of LPs |
Client | See note | Fill in together with Product |
Product | See note | The product assigned to these LPs |
If you fill in Client, fill in Product, and the other way round. The product must belong to the client.
The product is required when you add an LP capacity on the location screen. Fill it in on every row so Static Replenishment knows which LPs to count.
A row fails if that location already has the same LP type and product combination.
Example — Bulk Import LP Capacity:
Warehouse Code | Location Code | LP Type | Min Qty | Max Qty | Client | Product |
NJ01 | P-10 | Standard Pallet | 2 | 4 | Acme | WATER-24PK |
NJ01 | P-11 | Standard Pallet | 1 | 2 | Acme | SODA-12PK |
Updating and removing capacities
To change Min Qty or Max Qty on existing capacities, use Bulk Update Product Capacity or Bulk Update LP Capacity. Each row must identify an existing capacity (warehouse, location and the same product/pack type or LP type/product).
You can't delete capacities with Excel. Remove them on the location: open it, go to Product Capacity or LP Capacity, and use the capacity's 3-dot menu > Delete.
Checking the results
The import history at the bottom of the screen shows each upload:
Column | Meaning |
Status | Successful or Failed |
Row Count | Rows in the file |
Success Count | Rows imported |
Error Count | Rows rejected |
Uploaded By | Who uploaded the file |
Creation Date | When it was uploaded |
Click the row's Actions (3-dot) menu:
Details opens a sidebar with a summary and, for failed rows, the reason.
Download Original File downloads what you uploaded.
A rejected row doesn't stop the other rows from importing. Fix the failed rows and upload just those again.
Common questions
Can I use Bulk Import Product Capacity to change an existing capacity? No. The import creates capacities only; a row for an existing location, client, product and pack type fails. Use Bulk Update Product Capacity.
Does the import set the location up for Static Replenishment? No. It only adds capacities. The location also needs Replenishment Location Type set to Target. See Setting Up Static Replenishment.
Can I delete capacities in bulk? Not currently. Delete them on each location.