Product 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)

Unique product number - MANDATORY for product data!

If no variants are present you may use the article number (a_nr) as product number.

N

p_name

Y

CHAR(255)

Product designation. Can be maintained in one field (p_name) or split into the two fields common noun (p_name_keyword) and proper name (p_name_proper). Splitting the designation is recommended.

Whether or not the split designation is used is configured at "Admin > System settings > User Interface".

Y

p_name_keyword

Y

CHAR(254)

p_name_proper

N

CHAR(254)

p_supplement

N

CHAR(255)

The special text serves as a promotional second headline. Not all channels use this field. For eBay the special text can be exported as a subtitle (may cause added fees).

Y

p_text

N

TEXT

The product description has to be a continuous text. The handling of HTML line breaks ("<br/>" or "\n") can be configured via "Admin > Import > Settings".

Y

p_bullet{seqno}

N

CHAR(255)

Bulletpoints/selling points.

Y

p_keywords

N

Free text

Keywords/search terms for this products. Will be forwarded to the channel if possible.

Y

p_text_intern

N

Free text

Internal comment.

N

p_logo[key]
multiple

N

INT(0/1) or empty

Service logo (icon). Only exported if supported by the receiving channel (see keys).

N

p_comp[key]
multiple

N

Free text

Product component; import mapping via TB.One is possible (see keys); recommended length: max. 300 characters.

Y

p_tag[key]{seqno}

N

CHAR(300)

Product attribute; import mapping via TB.One is possible (see keys).

Import keys for new attribute values (tag_value) are automatically created in TB.One. The keys will be identical to the value's name. Preexisting values need to be imported via the key. If you have assigned keys that differ from the corresponding value's name (e.g. number codes), you need to use those keys to import the respective values.

N

p_brand

Y

CHAR(100)

Brand; import mapping via TB.One is possible.

N

p_catinternal

N

CHAR(255)

Internal category. Transfer the import key stored in TB.One.

N

p_cluster{seqno}

multiple

N

CHAR(255)

Indicator for automatic property and category assignments via clusters.

N

p_active[channel]
multiple

N

INT(0/1) or empty

Active for the indicated distribution channel (see channel sign).

N

p_catpri[channel]

N

CHAR(100)

Identifier for the primary category of a distribution channel (see channel sign).

N

p_catsec[channel]{seqno}
multiple

N

CHAR(100)

Identifier for the secondary categories (brand shops, promotions, etc.) of a distribution channel (see channel sign).

N

We recommend using clusters ("p_cluster") to transfer primary and secondary categories instead of the fields "p_catpri" and "p_catsec".

p_link[key]{seqno}
 

N

CHAR(100)

Product number of cross-selling products

key = type of product link

possible types:

cross = cross-selling (combinable)

upselling = up-selling (similar product, more expensive)

accessory = accessory (to a device)

device = device (for an accessory)

alternative = alternative

N

p_media[key]{seqno}

N

CHAR(255)

Link to product media.

key = media type from "Basic Data > Properties > Media types", e.g. image, color, manual, energy...

N

p_groupotde

N

CHAR(100)

Commodity group and target group for the channel Otto.de. If these tags are imported directly (not via clusters), they have to be provided together.

THESE COLUMNS ARE ONLY RELEVANT FOR Otto.de!

N

p_targetotde

N

CHAR(100)

N