For importing replenishment data, you require an import format that is configured with the database table Import Replenishment.
The example below compares the data content of a file from a spreadsheet software (here, e.g., an Excel file prior to its conversion to a CSV or TXT file) with the import format for replenishment data:
Note: metasfresh does not expect any column names in the import file. Simply the position of the column must correspond to the start number.
|Mandatory Field||Field Name||Example||Note|
|X||Product Search Key||P002737||Search Key of the product for replenishment (alphanumeric string)|
|X||Warehouse Search Key||Warehouse_01||Search Key of the warehouse (alphanumeric string)|
|X||ReplenishType||Reorder below minimum level||Method for re-ordering a product|
|X||Minimum Level||100||Minimum inventory level for the product|
|X||Maximum Level||500||Maximum inventory level for the product|
|Source Warehouse Value||MainWH||Search Key of the source warehouse|
|metasfresh AG||Search Key of the organization.
Attention: Not the name!
(You can look up the search key under “Organization” in the menu.)