Conditionsfile (CSV)

A CSV conditions file allows you to supplement your existing catalogue with important information without having to reupload the entire catalogue.

Requirement: You need an active catalogue with Unite (XML or CSV format). The CSV conditions file complements your existing catalogue.

When to use conditions files

The CSV conditions file is suitable for updating various data:

  • Prices and tiered prices

  • Delivery times

  • Customer-specific identifiers

  • Customs tariff numbers

  • EAN codes

  • Product descriptions

  • Manufacturer information

At the supplier's request, a standard CSV condition file can be set up during the onboarding process, which can be used to transmit various data (see table below).

Additionally, you can create a specific CSV conditions file exclusively for a particular topic, such as:

For more information, please refer to the linked support articles.

Creating and structuring the conditions file

The easiest way to create the conditions file is using Excel. The SUPPLIER_AID (your item number) is a mandatory field. You can use all other columns as needed.

You can download a sample file here:

katalogid_conditionsfile.csv csv - 139 B 2025-09-23
Note: If available, you can also export the CSV file directly from your system.

Name

Description

SUPPLIER_AID

Supplier's item number (mandatory)

ARTICLE_REFERENCE1

Reference item number

ARTICLE_REFERENCE1|type

Type of reference item (similar, accessories, others)

BUYER_AID1|type

Customer-specific identifier (e.g., core range, material number)

BUYER_AID1

Value of the customer-specific identifier

CONTENT_UNIT

Content unit

DELIVERY_TIME

Delivery time

DESCRIPTION_LONG

Long description

DESCRIPTION_SHORT

Short description

EAN

EAN

FEATURE_NAME

Feature name

FEATURE_UNIT

Unit (feature)

FEATURE_VALUE

Value (feature)

KEYWORD

Keyword

LOWER_BOUND

Tier limit in price tiers

MANUFACTURER_AID

Manufacturer number

MANUFACTURER_NAME

Manufacturer name

MIME_SOURCE

Image name

MIME_TYPE

Image type

NET_CUSTOMER

Kundenpreis

NET_LIST

Unite purchase price

NO_CU_PER_OU

Packaging quantity (number of content units per order unit)

ORDER_UNIT

Order unit

PRICE_QUANTITY

Price quantity

QUANTITY_INTERVAL

Quantity scale

QUANTITY_MIN

Minimum order quantity

REFERENCE_FEATURE_SYSTEM_NAME1

Name of the classification system e.g., ECLASS-5.1.4, ETIM-7.0

REFERENCE_FEATURE_GROUP_ID1

Associated ID of the classification system e.g., 45-36-89-74 or 21040701

TAX

Tax

WA_NR

Customs tariff number

Example of a conditions file with EAN and delivery time information:

Explanation:

Column

Example

Description

SUPPLIER_AID

122345

Item number

EAN

413020139143

EAN number

DELIVERY_TIME

2

Delivery time in days

Saving as a CSV file

After editing, save the Excel spreadsheet. Then export the data as a CSV file:

File > Save As > File Type: "CSV (Comma delimited) (*.csv)"

File naming

catalogueID_conditionsfile.csv

Note: Your CatalogueID was provided to you during the Unite onboarding process. Please adhere to the file naming convention. Without correct naming, the CSV file cannot be processed.

Technical requirements

To ensure our system processes your CSV conditions file correctly, please note these points:

  • Only the semicolon is permitted as a separator. You can verify this in a text editor.

  • The number of semicolons must be the same in each line.

  • The spelling of the headers must not be changed. Also, note the capitalisation within the headers.

A correctly generated conditions file looks like this in a text editor:

Activation in the Unite system

The initial setup of a conditions file is handled by Unite to ensure everything runs smoothly. Follow these steps:

  1. First, create a conditions file according to the above specifications. If available, you can also export it from your system.

  2. Send the CSV file to support@unite.eu for review. Specify in the email which catalogue you want to activate the file for. If your catalogue is still in the connection process, please contact your technical representative at Unite or send an email to supplier.integration@unite.eu.

  3. Unite will then check the file and set up everything necessary in the system.

  4. You'll receive an invitation to preview the catalogue, which you can then review and approve.

  5. Unite will inform you about the next steps, such as naming conventions and SFTP transfer.

Troubleshooting: Items not displaying

If items from your conditions file don't appear in the catalogue, check these common causes:

  • The item may not be present in the CSV file.

  • The item is not included in the base catalogue.

  • The item is already faulty in the base catalogue.

  • The item number exists twice, either in the catalogue or in the CSV file.

  • The item has been blocked by Unite (placed on a backlist).

We're happy to help you troubleshoot any issues. Please contact support@unite.eu for assistance.

Was this helpful?