How do I import products?

1. Get the product import template
2. Fill in the template

3. Save the file

4. Upload the file

5. Common errors

Before you start

1. Each column in the import file represents a field in the database.

2. The template must be used as provided.

3. Special characters are not allowed in certain fields.

4. You must have administrator access.

5. When adding a new product, you must also add an OEE rate for the product.
6. Imported files can be reused to update existing products by uploading them again.

Step 1: Get the product import template

Option 1: Download from the system

1.Open "Manager".

2. Go to "Configuration I/O".
3. Click "Download".
4. Select "Products".

5. Click "Download".

Option 2: Contact support

Contact support and request the product import template.

Step 2: Fill in the template

Open the exported file and enter the required information:

1. Column A – Product

   1. Product name (must be unique)

2. Column B – ProductDesc

   1. Product description

3. Column C – Category

   1. Product category

All other columns must remain in the file but can be left blank.

Step 3: Save the file

Excel format (from version 2026.01)

1. Go to File → Save As.

2. Select Excel Workbook (*.xlsx).

Step 4: Upload the file

1. Open "Manager".

2. Go to "Configuration I/O".
3. Select "Upload".
4. Choose "Products".

5. Click "Choose File" and select your file.
6. Click "Upload" to complete the import.

Common errors and checks

If an error occurs, verify the following:

1. Product name, description, or category does not contain special characters: " , ' : ; % @ ~ * #

2. The CSV file uses a comma ( , ) as the separator.

3. The product name is no longer than 50 characters.