You can quickly import externally stored data (such as Excel spreadsheets with data on business partners or products) into metasfresh through the use of the import feature and thus also bring existing entries up to date. To do so, you first have to format the data appropriately, upload them as a CSV or TXT file and then simply import them via the actions menu.
|Import Data||Corresponding DB Table|
|Bank Statement Data||Import Bank Statement|
|Business Partner Data||Import Business Partner|
|Chart of Accounts Data||Import Account|
|Discount Schema Data||Discount Schema Import|
|Postal Data||Import Postal Code Data|
|Product Data||Import Product|
|Replenishment Data||Import Replenishment|
|1) Make sure that the separator from the import file coincides with the one defined in the import format (comma, semicolon, tab, etc.).
2) Please also make sure that both the decimal and the thousands separators from the import file conform with your respective language-specific system preferences (e.g., Eng.: $ 1,999.95 vs. Ger.: € 1.999,95).