metafresh logo and link to homepage

Format example for importing replenishment data


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:

Explanatory Notes to the Example

Some useful notes

Mandatory Field Field Name Example Note
X Product Value P002737 Search Key of the product for replenishment (alphanumeric string)
X Warehouse Value Warehouse_01 Search Key of the warehouse (alphanumeric string)
X ReplenishType Reorder below minimum level Method for re-ordering a product
X Level_Min 100 Minimum inventory level for the product
X Level_Max 500 Maximum inventory level for the product
  Source Warehouse Value MainWH Search Key of the source warehouse
  Organisation Key
metasfresh AG Search Key of the organization.
Attention: Not the name!
(You can look up the search key under “Organization” in the menu.)

Next Steps

Zur Quelldatei auf