Excel specification

ExtProdID

Character (∞) 

ExtProdID

Unique number

Mandantory if SupplierAID is empty

SupplierID

Character (9)

Supplier ID

The SupplierID is your supplier number also called vendor number. This number is maintained individually by the customer.

SupplierName

Character (50)

Supplier Name

The SupplierID is your supplier number also called vendor number. This number is maintained individually by the customer.

Your supplier name is entered here.

SupplierAID

Character (30)

Supplier Article ID

Your own supplier part number is maintained here, which is available for an article. If you do not have your own supplier number, we recommend that you use a sequential number here.

Mandantory if ExtProdID is empty

ManufacturerID

Character (9)

Manufacturer ID

The manufacturer number is the number maintained by the manufacturer. Again, this number can be individual from the customer. 

ManufacturerName

Character (50)

Manufacturer Name

Here the name of the manufacturer can be maintained, if they are not manufacturer. 

ManufacturerAID

Character (30)

Manufacturer Article ID

Here the manufacturer part number can be maintained. This number varies from manufacturer to manufacturer. 

Language

Mandatory if suffix (multilanguage) is not used in both descriptions and remarks headings

Language

The language indicates in which language your catalog content is stored. This Excel template is multilingual. To use multiple languages within one Exceltemplate, please contact the support for the Excel file. Only ISO 639-1 codes are allowed. You can find them here for example:

ISO 639-1

Allowed ISO 639-1 codes.

Mandatory if suffix is not used in both descriptions and remarks headings

DescriptionShort

Character (80) will by cutted by OCI to 40

Description Short

Short Description of item

max 80 characters

DescriptionLong

Character (2000)

Description Long

Long Description of item

max 2000 characters

DeliveryTime

Float not less than 0 (4 bytes, IEEE 754)

Delivery Time

Delivery time shows how long the product will take to reach the customer. This information must be given in whole days.

Keywords

Character (1000)

Keywords

When a user starts a search, it starts in the search bar. The search words entered in it also search the keyword field.   Please include several applicable keywords. You can also use keywords that have a similar meaning. 

CatalogViews

Character (∞) *

Catalog Views

Via the field CatalogView you have the possibility to sort the view concept on article level. 

ProductType

Character (∞) *

Product Type

Product Type (flag with X if this is a service item in SAP). With the attribute ProductType you define if it is a service in SAP. This field should usually be agreed with the customer. 

EAN

Character (13)

EAN

European Article Number

BuyerAID

Character (∞) *

Buyer Article ID

Buyer Article Number (SAP Material Code in Buyer System)

Contract

Character (∞) *

Contract

Contract Item in SAP

ContractItem

Character (∞) *

Contract Item

Contract Item Position in SAP

Catalog

Character (∞) *

Catalog

Catalog

Remarks

Character (∞) *

Remarks

Additional remarks

BuyCtrl

Character (∞) *

Buy Control

Allows to control the behavior of item display in the hit list

CoreArticle

Character (∞) *

Core Article

Core Article, Values Y or N allowed

HazardousGood

Character (∞) *

Hazardous Good

HazardousGood indicates whether it is a Hazardous item.  Allowed Value Y or N.

HazardousSubstance

Character (∞) *

Hazardous Substance

HazardousSubstance indicates whether it is a hazardous substance. Allowed Value Y or N.

ArticleOrderDetails.OrderUnit

Character (∞) *

Order Unit

Unit in which the article can be ordered; it is only possible to order multiples of the article unit.

The price also always refers to this unit (or to part of or multiples of it).

Order Unit must be ISO compliant

Validation for supported values

ArticleOrderDetails.ContentUnit

Character (∞) *

Content Unit

Unit of the article within an order unit. Content Unit must be ISO compliant (packing details)

Mandatory if ArticleOrderDetails.NoCuPerOu not blank

ArticleOrderDetails.NoCuPerOu

Float

Number of Content Unit per Order Unit

Number of content units per order unit of the article.

Example: Box of mineral water with 6 bottles

Order unit: "crate", contents unit/unit of the article: "bottle"
Packing quantity: "6"

(4 bytes, IEEE 754)

Mandatory if ArticleOrderDetails.ContentUnit not blank

ArticleOrderDetails.PriceQuantity

Float

Price Quantity

A multiple or a fraction of the order unit which indicates the quantity to which all the specified prices refer. If nothing is specified in this field the default value 1 is assumed, in other words the price refers to exactly one order unit.

(4 bytes, IEEE 754)

ArticleOrderDetails.QuantityMin

Float

Quantity Min

Minimum number of order units which must be ordered. If nothing is specified in this field the default value 1 is assumed.

(4 bytes, IEEE 754)

ArticleOrderDetails.QuantityInterval

Float

Quantity Interval

Number indicating the quantity steps in which the articles can be ordered. The first step always corresponds to the minimum order quantity specified.

The unit of the quantity interval is the same as the order unit.

(4 bytes, IEEE 754)

ArticlePriceDetails.ValidStartDate

Character (∞) *

Valid Start Date

Date on which the article prices comes into effect.

 Expected format: YYYY-MM-DD

ArticlePriceDetails.ValidEndDate

Character (∞) *

Valid End Date

Date on which the article prices terminate.

 Expected format: YYYY-MM-DD

ArticlePriceDetails.ArticlePrice.1.PriceType

Character (∞) *

Price Type

Attribute which specifies the type of price. Supported Price Type are:

net_list, gros_list, net_customer, nrp, net_customer_exp, udp_*

ArticlePriceDetails.ArticlePrice.1.PriceAmount

Float

Price Amount

Amount of the price.

 decimal separator with dot

not less than 0

2 decimal places

(4 bytes, IEEE 754)

ArticlePriceDetails.ArticlePrice.1.PriceCurrency

Character (∞) *

Price Currency

Currency of the price

Please use ISO 4217 (currencies not included in ISO 4217 will lead to an error.)

ArticlePriceDetails.ArticlePrice.1.Tax

Character (∞) *

Tax

Tax

ArticlePriceDetails.ArticlePrice.1.PriceFactor

Float

Price Factor

Specify discount or any other price factor 1= 100 %.

if blank, system will set 1

(4 bytes, IEEE 754)

default value - 1

ArticlePriceDetails.ArticlePrice.1.LowerBound

Float

Lowerbound

Lower quantity limit for graduated prices.

The unit for the graduated price limit is the order unit.

Note: the upper graduated price limit is determined by the LOWER_BOUND value of the next price. If there are no more graduations, the price applies to all quantities which are higher than the lower graduated price limit.

(4 bytes, IEEE 754)

Classification.1.ClassificationSystem

Character (∞) *

Classification System

Classification System

You can leave this field empty, than system copy the correct value

Check for Classification chosen on the upload screen

Classification.1.ClassificationID

Character (∞) *

Classification ID

Classification ID

check if valid code supplied

Check if correct code supplied

Mime.1.MimeType

Character (∞) *

Mime Type

supported values (url, application/pdf, image/jpeg, image/gif, text/html, text/plain)

mandatory if mime source is used, check for allowed values

Mandatory if mime source is used, check for allowed values

Mime.1.MimeSource

Character (∞) *

Mime Source

Mime path relative, or absolute with full https reference

mandatory if mime is used

Mandatory if mime is used

Mime.1.MimeDescr

Character (∞) *

Mime Description

Mime Description

mandatory if mime is used

Mandatory if mime is used

Mime.1.MimePurpose

Character (∞) *

Mime Purpose

supported values (thumbnail, normal, others)

mandatory if mime is used, check for allowed values

Mandatory if mime is used, check for allowed values

Relation.1.SupplierID

Character (∞) *

Related Supplier ID

Together with "Related SupplierAID" this is the key to the reference article out of this catalog

optional for valid product relation

Optional for valid product relation

Relation.1.SupplierAID

Character (∞) *

Related Supplier AID

Together with "Related SupplierID" this is the key to the reference  article out of this catalog

mandatory for valid product relation

Mandatory for valid product relation

Relation.1.Type

Character (∞) *

Relation Type

supported values (accessories, similar, sparepart, followup, diff_orderunit, consists_of, mandatory, select, mandatory_choose_quantity, mandatory_default_quantity, mandatory_choose_item, others)

mandatory for valid product relation

Mandatory for valid product relation

Relation.1.ContainerID

Character (∞) *

Related Catalog ID

In case of cross catalog relations the catalog ID has to be entered

optional for valid product relation

Optional for valid product relation (long)

DocField.1.Name

Character (∞) *

DocField Name

Customter Field - Name

DocField.1.Value

Character (∞) *

DocField Value

Customter Field - Value