Structure of the Excel file

The Excel file contains all the data associated with the article, such as article numbers, descriptions, as well as categories and subcategories in which the article is to be stored in the catalog.

To assign an article to a catalogue category, the categories must be entered in the column “ArticleCategories_en-DE”. These must be separated by the pipe character “|” (“ALT Gr” and “<“) without spaces.

Example:

Articles that are to be assigned to the subcategory “self-aligning ball bearings” in the category “Rolling bearings, plain bearings and accessories” must be saved in the Excel file as follows (Rolling bearings, plain bearings and accessories|Self-aligning ball bearings):

In the catalog, the items are displayed as follows after import: