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.
|Product Search Key
|Search Key of the product for replenishment (alphanumeric string)
|Warehouse Search Key
|Search Key of the warehouse (alphanumeric string)
|Reorder below minimum level
|Method for re-ordering a product
|Minimum inventory level for the product
|Maximum inventory level for the product
|Source Warehouse Value
|Search Key of the source warehouse
|Search Key of the organization.
Attention: Not the name!
(You can look up the search key under “Organization” in the menu.)