SKU Master
The SKU Master page allows you to view, create, edit, import, and delete articles (also called SKU = Stock Keeping Unit). Each article is linked to exactly one Package Type, which defines its physical dimensions and packaging format.
The core parameters of an article are:
| Parameter | Description |
|---|---|
| ID | Unique id of an article |
| Article Name | Corresponding article name |
| Package ID | Unique assignment of an article to a Package Type |
| Package Name | Corresponding package type name |
SKU Master Table
| Field | Description |
|---|---|
| ID | Unique Article ID |
| Article Name | Article name |
| Package ID | Package type ID this article belongs to |
| Package Name | Corresponding package name |
| Show 10 entries | With changing this value you can display more or less records in the table |
| Search | You can search any element by typing any string into this field |
| Buttons 1,2, ... Next | You can scroll through the list of articles |
Context Sensitive Menu of SKU Master Table
With a right-click on any line in the SKU Master Table the following context sensitive menu will pop up:
| Menu Item | Description |
|---|---|
| Show Package Type | Opens the corresponding Package Type page for the selected article |
| Edit | Opens the Edit SKU dialog to change the values of the selected article |
| Delete | Deletes the selected article |
Add SKU
A new article can be added via the Add SKU button in the sidebar Actions section.
| Field | Description |
|---|---|
| Article ID | Unique article id |
| Article Name | Article name |
| Package ID | Package type id to which this article belongs |
With the button "Save" you can save all changes. With the button "Cancel" you can abort all changes.
Edit SKU
An existing article can be modified via right-click → "Edit" in the SKU Master Table.
| Field | Description |
|---|---|
| Article ID | Unique article id (should not be changed) |
| Article Name | Article name |
| Package ID | Package type id to which this article belongs |
With the button "Save" you can save all changes. With the button "Cancel" you can abort all changes.
Actions
The sidebar Actions section contains the following controls:
| Control | Description |
|---|---|
| File input | Select an Excel file (.xlsx) to be imported |
| Import SKU Master | Imports articles from the selected Excel file |
| Export SKU Master | Creates an Excel file with all stored articles and provides it as download |
| Add SKU | Opens the Add SKU dialog to create a new article |
Note: The Import, Add SKU, Edit, and Delete functions are only available to users with the Editor or Administrator role. Users with read-only access see these controls greyed out and cannot interact with them.
The import Excel file must contain the following fields as column headers in the first row:
| Column | Notes |
|---|---|
| article_id | Unique article identifier (integer) |
| article_name | Article name (text) |
| package_id | Must match an existing Package Type |