Items
MVP Prototype
SEG Warehouse Fee Application
Warehouses
Rates
Fee projections
Requirement Summary
- Internal SEG users log in with Cognito email and password.
- Admins maintain warehouses, rates, projection history, and audit records.
- Users can create and edit item master records. Item changes notify all Admin users.
- Warehouse rates are unique by warehouse plus item no.
- Storage fee projections save row-level calculation details and can be downloaded as CSV.
Shared Setup
Item Setup
Upload Item CSV
Create or update multiple items. Item No is unique and duplicate item numbers inside one file are rejected.
| Item No | Description | Category | Subcategory | Code | Units / MC | MC / Pallet | Units / Pallet | Unit Wt lb | Unit L in | Unit H in | Unit D in | MC Wt lb | MC L in | MC H in | MC D in | Status |
|---|
Reference Data
Item Creation Info
Company UPC Prefix
| Company | UPC Prefix |
|---|
Philip's Item Classification(Royalty)
| Value |
|---|
Brand Values
| Company | BrandDesc | Brand Code |
|---|
Category Values
| Company | CatCode | Category |
|---|
New Item Workflow
Item Creation
Upload Item Creation CSV
Required columns: Company, BrandDesc, CATEGORY, DESCRIPTION, CUSTOMER, MODEL #, Philip's Item Classification(Royalty).
Manual Item Creation
| Item | Company | UPC Prefix | Brand Code | BrandDesc | CatCode | Category | Customer SKU | UPC CODE | GTIN-14 | Description | Customer | Model # | Newell Sku Number | Royalty | Creation Date | Input by |
|---|
Admin Only
Warehouse Setup
| Warehouse Code | Warehouse Name | Status |
|---|
Admin Only
Admin Rate Setup
Upload Rate CSV
Columns: warehouse, item no, fee type, rate. Duplicate warehouse + item no is rejected.
| Warehouse | Item No | Fee Type | Rate | Updated By | Updated At |
|---|
Admin and User
Warehouse Storage Fee Projection
Upload Inventory CSV
Projection columns: item no, no of units, warehouse, storage days, start year, start month, start day. Date columns are required for WMUC01.
Calculation Results
0 rows
$0.00
Upload inventory CSV to project warehouse storage fees.
| Row | Item No | Warehouse | Units | Storage Days | Start Date | Off-Peak Season | Peak Season | Charge Unit | Rate | Est Storage Fee | Unit Fee | Fee Type | Status | Error |
|---|
Admin Only
Upload History
| Upload ID | File Name | Uploaded By | Uploaded At | Total Rows | Error Rows | Total Fee | Status |
|---|