Article Fields in the Import CSV

TIP:
The table's second column only indicates, whether a field is considered a technical requirement by TB.One. Most channels require additional fields to be filled.

TIP:
An explanation of the variables in the field names (displayed in square, curly and angle brackets) can be found here.

p_nr

Y

CHAR(50)

Product number. Used to assign newly created articles to a product. Can also used for existing articles. If the product number changes for an article, it will be moved to a different product. Some channels do not allow this!

N

a_nr

Y

CHAR(50)

Article number (SKU). Mandatory for article data. Unique number for this article/variant across all articles

▪do not use spaces or special characters

▪use a maximum of 16 characters

N

a_nr2

N

CHAR(50)

Article number 2 (additional article number)

N

a_ean

Y

EAN13

EAN-code for this article

N

a_prodnr

N

CHAR(50)

Manufacturer's article number

N

a_chnr[channel]

N

CHAR(50)

Channel article number (if the channel assigns its own article numbers, e.g. Amazon's ASIN); when exporting the product data as PANDA.CSV or ARTICLE.CSV, this column is referenced as "a_nr_channel[channel]".

N

a_active

N

INT(0/1)

Indicator for article activation (yes/no). This setting applies to all distribution channels.

N

a_active[channel]

N

INT(0/1)

Indicator for channel-specific article activation (yes/no). This setting only applies to the indicated distribution channel. To activate an article on a specific channel, both the field "a_active[channel]" and the field "a_active" need to contain the value "1".
If you want to use the channel specific article activation, your import files must not contain the column "p_active[channel]".

N

a_comp[key]

mutiple

N

CHAR(255)

Variant information (import key as key; content = variant value; import assignment via TB.One available)

If you provide variant dimensions via import, deliver ALL dimensions. The information must be complete. Otherwise, variants already created will be deleted again.

Y

ap_comp[key]

N

CHAR(255)

(Non-variant-forming) article component

Y

a_tag[key]{seqno}

N

CHAR(100)

Article attributes

N

a_provision[channel]

N

CHAR(50)

Commission group for a channel (see channel sign). Commission groups can be created in TB.One under "Channels > [Channel] > Commission groups".

N

a_vk[channel/price list key]

Y

FLOAT

Retail price referring to a price list or a channel (see channel sign).

N

a_vk_old[channel/price list key]

N

FLOAT

Former selling price referring to a price list or a channel; causes a cross price to be displayed (see channel sign)

N

a_uvp[channel/price list key]

N

FLOAT

Manufacturer's suggested retail price (MSRP) referring to a price list or a channel

N

a_mwst[channel/price list key]

N

INT(0/1)

VAT rate for sales channel. Possible values are:
1 = reduced
2 = normal
3 = free

N

a_ek

N

FLOAT

Purchase price (internal information)

N

a_ch_ek[channel/price list key]

N

FLOAT

Net purchase price for distribution channel

N

a_base_price[key]

N

FLOAT

Base price; key = import key according to "Basic data > Prices > Base prices"

N

a_media[key]{seqno}

N

CHAR(255)

References article media.
key = media type according to "Basic data > Properties > Media types" (e.g. image, color, manual, energy).

If the same media should be used for several articles, use the same reference value in this field.

N

a_stock
or
a_stock[key]

N

INT(0/1)

Stock
if you use multiple storage facilities:
key = import key of the storage facility

N

a_warn

N

INT(0/1)

Warning stock (in TB.One, you can filter for articles that have reached the warning stock amount)

N

a_delivery

N

INT(0/1)

Delivery time in business days (order to arrival of the shipment)

N

a_replace

N

INT(0/1)

Replaceable (1 = yes/0 = no)
If "replaceable = yes", the field "a_repltime" below must be filled

N

a_repltime

N

INT(0/1)

Replacement time in business days

N

a_separate

N

INT(0/1)

Only valid for neckermann.at
If this flag is set, a separate order and invoice will be generated for this position.

N

a_maxsep

N

INT(0/1)

Only valid for neckermann.at
If "a_separate" is is activated, you can use "a_maxsep" to split orders for this item by quantity (e.g. the value "1" would mean, that each ordered article would create a separate order).

N

a_shipping_type

N

CHAR(50)

The article's shipping type. The import key according to "Basic data > Shipping > Shipping types" is transferred.

N

a_depot

N

CHAR(100)

Storage compartment; the storage compartment can be printed on pick lists and delivery notes.

N

a_depot_text

N

CHAR(255)

Comment regarding the storage compartment

N

a_pieces

N

INT(0/1)

Number of pack pieces

N

The package data is optional. However, if one of the values is specified, all other values become mandatory!

a_width

N

INT(0/1)

Width of all the article's packages in cm

N

a_length

N

INT(0/1)

Length of all the article's packages in cm

N

a_height

N

INT(0/1)

Height of all the article's packages in cm

N

a_weight

N

FLOAT

Weight of all the article's packages in kg

N

a_org_country

N

CHAR(2)

Country of origin (ISO alpha 2)

N

a_intrastat

N

CHAR(8)

8-digit IntraStat number

N

a_unit

N

ENUM

The article's unit

ST = pieces
CM = centimeters
QM = square meters

N

a_order_min

N

INT

Minimum order quantity

N

a_order_max

N

INT

Maximum order quantity

N

a_order_intervall

N

INT

Order interval

N

p_master_vk[channel/price list key]

N

FLOAT

Retail price (see channel sign)

N

p_master_vk_old[channel/price list key]

N

FLOAT

Former selling price; causes a cross price to be displayed (see channel sign)

N

p_master_uvp[channel/price list key]

N

FLOAT

Manufacturer's suggested retail price (MSRP)

N

p_master_mwst[channel/price list key]

N

INT(1/2)

VAT rate for the sales channel. Possible values are:
1 = reduced
2 = normal
3 = free

N

p_master_ek

N

FLOAT

Purchase price (internal information)

N

p_master_ch_ek[channel/price list key]

N

FLOAT

Net purchase price for distribution channel

N

a_shipping_unit[width]{seqno}

Y

INT

Width of the pack piece (starting with package no. 0)

N

a_shipping_unit[length]{seqno}

Y

INT

Length of the pack piece (starting with package no. 0)

N

a_shipping_unit[height]{seqno}

Y

INT

Height of the pack piece (starting with package no. 0)

N

a_shipping_unit[weight]{seqno}

Y

INT

Weight of the pack piece (starting with package no. 0)

N