For importing product data, you require an import format that is configured with the database table Import Product.
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 product 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.
The mandatory fields are essential for a successful data import!
|Item Search Key
|Search Key of the product (alphanumeric string)
|I = Item
E = Expense Type
R = Resource
|Product Category Search Key
|Search Key of the product category. Attention: Not the name!
(You can look up the search key under “Product Category” in the menu.)
|PCE = Each (Piece)
(You can look up the UOM code under “Unit of Measure” in the menu.)
|Reduzierter Steuersatz 7% (Deutschland)
|You can look up the tax category under “Tax Category” in the menu.
|Price List Version
|Testpreise Kunden (Deutschland)
|You can look up the price list version under “Price List” in the menu.