Creating a Validation Set from CSV

Step 1 — Create a Validation Set

1. Navigate to Processing → Validations in the Qmica main menu.
2. Click + Create a validation set.
3. Enter a descriptive name for your validation set.
4. Select Import from CSV.

Qmica opens the CSV import screen.

Step 2 — Prepare Your CSV File

Prepare a CSV file containing the unique identifiers of the products you want to validate.

The file must contain a column with product IDs that correspond to the identifiers used when those products were originally uploaded to Qmica.

For example:

Important: The product ID must match the unique identifier used in your Qmica product source. This is often a GTIN or EAN, but it can also be another unique product identifier.

Make sure the file:

• Contains the product IDs you want to validate.
• Uses the same identifiers as your existing Qmica product data.
• Is saved in CSV format.
• Does not exceed the maximum file size of 50 MB.

Step 3 — Upload the CSV File

1. Drag and drop your CSV file into the upload area, or click to select a file from your computer.
2. Check the file settings.
3. Select the correct Charset, for example UTF-8.
4. Select the correct Field terminator, such as a semicolon (;) or comma (,), depending on your CSV file.
5. Click Continue.

Qmica proceeds to the import configuration screen.

Step 4 — Configure the Import

After uploading your file, configure the following fields.

ID Column

Select the CSV column containing the unique product identifiers.

Qmica uses these values to identify the corresponding products in your existing product data.

The identifiers must match those used when uploading the products into Qmica.

Version

Enter the applicable GS1 data model version.

For example:

3136 — GS1 data model version 3.1.36.

Use the version that applies to the product data you want to validate.

Target Market

Enter the relevant GS1 target market code.

For example:

528 — Netherlands.

The target market determines which market-specific validation requirements apply.

Step 5 — Create the Validation Set

Once you have configured the import:

1. Check the selected ID column.
2. Verify the data model version.
3. Confirm the target market.
4. Click the button to create the validation set.

Qmica creates the validation set and starts validating the selected products.

The new validation set appears in the Validations overview with a Processing status while the validation is running.

Note: Depending on the Qmica interface version, the final button label may differ slightly.

Step 6 — Review the Validation Results

Once processing has finished, you can review the validation results.

Open the three-dot menu next to your validation set.

Select:

• Show items — View the products included in the validation set and their individual validation status.
• Show issues — Review validation issues and identify which products are affected.
• Revalidate — Run the validation again after correcting source data or mappings.

A green checkmark in the Build column indicates that processing has completed successfully. It does not mean that all products have passed validation.