CSV interface

Description

Material data from a catalog or a product group can be exported and imported via the CSV interface.

  • Price update: Pass on the CSV file with the exported material data to your supplier so that he can enter his list price or a price scale with up to five levels for all or individual material items. By importing the CSV file, you update the material prices in the catalog.
    The supplier can also add new material items to the CSV file. When importing, new material groups and material articles are created in the material catalog.
  • Catalog import: Create a new material catalog and import the CSV file with the material data of a supplier. New product groups and material articles are automatically created in the new catalog.

Export material data

In the directory tree, select the catalog or the product group whose articles you want to export and click in the menu material management on Export....


The Windows file selection dialog opens. Select the storage location of the CSV file, enter a file name and confirm with [To save].


In dialogue Export material catalog all exported articles are listed. Close the dialog with [OK].


Pass the CSV file on to your supplier so that he can enter his list price or a price scale with up to five levels for all or individual material items and, if necessary, add new material items.

Import price update

In the directory tree, mark the catalog or the product group for which you have exported the CSV file and click in the menu material management on CSV.


The Windows file selection dialog opens. Select the CSV file and confirm with [To open].


In dialogue Import material catalog the material items contained in the CSV file are listed.

  • Material articles that cannot be imported due to missing data are included in the group Error listed.
  • Material items added by the supplier are included in the group Import listed.
  • Confirm the dialog with [OK] and perform the update of the material items that are in the group Update are listed or cancel the entire import process [Abort] .



The list prices and price scales of the material articles are updated and new material groups and material articles are created accordingly.

  • The net sales price of the material items is recalculated based on the new list price and the discount and sales surcharge entered.
  • If a purchase price has been entered for the material item, it is retained and is still used to calculate the net sales price.

Import data for new catalog

Create a new material catalog and click in the menu material management on CSV.


The Windows file selection dialog opens. Select the CSV file and confirm with [To open].


In dialogue Import material catalog the material items contained in the CSV file are listed. With [OK] start the import process.


Corresponding product groups and material articles are created in the new catalog.

Structure of the CSV file

The following data is exported and imported:

  • The CSV file must contain all columns.
  • The columns in the CSV file must have exactly these names.
  • The order of the column can be chosen arbitrarily.
Column labelNote
Main product group no.
Material articles newly imported via the CSV file can be divided into a maximum of two hierarchies in the catalog (main product group and product group).
Main product group
Main product group long text *
Department no.
group
Material group long text *
ID materialIs filled during export. Is not necessary for the import. The assignment is always made via the material no.
Material no.Mandatory field, max. 80 characters
Designation IMax. 255 characters
Designation IIMax. 255 characters
unitMax. 80 characters
Price scale A numberMandatory field, is the price unit of the material article
Price scale A priceMandatory field, is the list price of the material item
Price scale B number



Max. five price scales can be exported or imported.
Price scale B price
Price scale C number
Price scale C price
Price scale D number
Price scale D price
Price scale E number
Price scale E price
matchcodeMax. 255 characters
EANMax. 13 characters
Order no.Max. 80 characters
G / L accountUse only the numbers of G / L accounts that you have in the financial management of DATAflor BUSINESS in the chart of accounts in order to use the pre-allocation of the corresponding account when entering the supplier invoice in the invoice receipt.
Long text* The texts are exported or imported into the CSV file without formatting (font, size, color, etc.).

Instructions for CSV import

CSV import template

When exporting, numerical values ​​are entered in the CSV file Apostrophe so that when opening and editing the CSV file in Microsoft Excel, the values ​​are completely displayed. Numbers with more than nine digits (e.g. material no.) Would otherwise be displayed as an exponential number. When the Excel table is then saved, it is transferred to the CSV file as an exponential number and after importing into BUSINESS incompletely displayed.
To import the CSV file into BUSINESS the quotation marks are not required.

Further steps