Products


<< Click to show table of contents >>

Navigation:  Parameterizing value stream objects > Object and product related settings >

Products


Contents

1. General

2. Create import template

3. Import Excel data

 

 

1. General

To assign a new product to an object, the Edit data button must be pressed (see Figure 1).

20230202_products_1

Figure 1 - Edit data

 

Subsequently, a new window opens in which existing products can be assigned to the respective object or new products can be created.

The following example illustrates the creation and subsequent addition of a new product to the Customer object.

Figure 2 shows the still empty product list of the Customer object. The column headings show the product-specific settings. These can be parameterized as soon as a product has been selected.

 

Button

Description

20230202_products_2

Via the search bar existing entries can be searched

20240902_export_button

A click on the Excel button opens a drop down that can be used to either export product entries to an Excel spreadsheet or import them from Excel.

A template for importing data can also be created. See here for details.

20250120_excel_import_dropdown_EN

20240902_copy_products_button

A click on the Copy button opens a drop down, where products of successors and predecessors can be copied to the current object.

If a product already exists it will not be overwritten.

20240902_copy_products_dialog

20230124_produkte_bearbeiten_hinzufuegen

A click on the + button adds a new entry to the list

20250904_button_delete_products

A click on the Delete button deletes the currently selected products

 

 

20240902_products_customer_overview

Figure 2 - Edit products

 

A click on the + button

20230124_produkte_bearbeiten_hinzufuegen

adds a new entry to the list. Now either an existing product must be selected in the column Product, or a new product must be created.

20240902_products_customer_overview_new_product

Figure 3 - Select/Create Product

 

 

If no product has been created yet, this can be done via the drop down entry Create new product.

Alternatively, new products can also be created via the Product Names tab in the local project settings.

20230202_products_5

Figure 4 - Create New Product

 

 

2. Create import template

Import templates can be created for every object that contains products. An Excel file is automatically generated and saved with the respective name of the object.

The template contains all the columns that are available in the object. Figures 5 and 6 show this using the Supplier object as an example.

20250120_importvorlage_erstellen_1_EN

Figure 5 - Create import template

 

20250120_importvorlage_erstellen_2_EN

Figure 6 - Creating an import template

 

 

3. Import Excel data

The import template can be filled in Excel after export and then imported back into SimVSM.

When importing, you can also specify the Excel spreadsheet from which the data is to be imported (see Figure 7).

When importing, it must be ensured that the corresponding products (names) have already been created in SimVSM, otherwise a corresponding message will be displayed (see Figure 8).

If data already exists, the user can decide whether it should be overwritten or retained (see Figure 9).

20250120_excel_daten_importieren_EN

Figure 7 - Import Excel data

 

20250120_excel_daten_importieren_fehler_EN

Figure 8 - Product name error message

 

20250120_excel_daten_importieren_hinweis_EN

Figure 9 - Existing data message

 

 


© SimPlan AG - Hanau District Court, Commercial Register (Part B) 6845 - info@simplan.de - www.simplan.de/en