Variables for data import and export

Variable

Description

nummer

Product number

name_de

Product name (German)

name_en

Product name (English)

artikelbeschreibung_de

Product description (German)

artikelbeschreibung_en

Product description (English)

kurztext_de

Short text (German)

kurztext_en

Short text (English)

uebersicht_de

Online shop / Product description (German)

uebersicht_en

Online shop / Product description (English)

metatitle_de

In Product master/texts, Tag for alternative product

metatitle_en

English meta title

metadescription_de

Other product description

metadescription_en

English meta description

metakeywords_de

Key terms used to search for products

metakeywords_en

English meta keywords

artikelkategorie (id)

Product category ID for assignment during import

artikelkategorie_name

Product category

artikelbaumX (X=1 to 20; CLEAR to delete all assignments)

X is the variable for the numbering of product categories in the item tree

bildtitelX (X=1 to 20; X corresponds to the sorting of the images in the files of the item)

Defines the sorting order for the import of image files, X is replaced by a number between 1-20

bildbeschreibung(X=1 to 20; X corresponds to the sorting of the images in the files of the item)

Similar to image title (bildtitel), just that it relates to the description

internerkommentar

Internal comment

hersteller

Field manufacturer in the product master

herstellerlink

URL to the manufacturer

herstellernummer

Identifier for the manufacturer

ean

EAN number

herstellerland

Country in which the manufacturer resides

herkunftsland

Country in which the product was made

zolltarifnummer

Customs number

ursprungsregion

Subnational region from which the product hails

allelieferanten

Activates the check box "Purchase" for all products in the product master

standardlieferant

Default supplier number

geraet

Activates the check box “Device” to define product as device. Only relates to reporting

serviceartikel

Activates the check box "Service product".

inventurek

Inventory value in product master will be imported

inventurekaktiv

Activates the Inventory value

berechneterek

Calculated purchase price from product master

berechneterekwaehrung

Currency of calculates purchase price

verwendeberechneterek

Activates the calculated purchase price

steuer_erloese_inland_normal

Product → Details → Financial Accounting, field Domestic (normal) under Revenues

steuer_erloese_inland_ermaessigt

Field Inland (reduced) under Revenues

steuer_aufwendung_inland_nichtsteuerbar

Field Domestic (tax-free) under Revenues

steuer_erloese_inland_innergemeinschaftlich

Field Intra-community EU under Revenues

steuer_erloese_inland_eunormal

Field EU (normal) under Revenues

steuer_erloese_inland_euermaessigt

Field EU (reduced) under Revenues

steuer_erloese_inland_export

Field Export under Revenues

steuer_aufwendung_inland_normal

Field Domestic (normal) under Expenses

steuer_aufwendung_inland_ermaessigt

Field Inland (reduced) under Expenses

steuer_aufwendung_inland_nichtsteuerbar

Field Domestic (tax-free) under Expenses

steuer_aufwendung_inland_innergemeinschaftlich

Field Intra-community EU under Expenses

steuer_aufwendung_inland_eunormal

Field EU (normal) under Expenses

steuer_aufwendung_inland_euermaessigt

Field EU (reduced) under Expenses

steuer_aufwendung_inland_import

Field Import under Expenses

mindesthaltbarkeitsdatum (1=active,0=not active)

Check box Best before date is activated

seriennummern (keine,eigene,vomprodukt,vomprodukteinlagern)

One of the following serial number options can be entered: (keine (none), eigene (own), vomprodukt (from product), vomprodukteinlagern (store from product)

chargenverwaltung (0=none,2=use originals)

Defines whether product has batches

mindestlager

Minimum stock quantity

mindestbestellung

Numerical value in the field "Minimum order quantity"

umsatzsteuer

Reduced VAT

artikelabschliessenkalkulation

Check box 'Include purchase price in calculation when completing the order' available under Product > Calculation

artikelfifokalkulation

Checkbox 'Calculated purchase price automatically recalculates the mean value according to the FIFO principle of the last inputs' available under Product > Calculation

lieferantname

The name of the supplier in the "Purchase price" tab, when creating a purchase price

lieferantbestellnummer

Similiar to lieferantname, except it relates to the Product number of the supplier

lieferantartikelbezeichnung

Similiar to lieferantname, except it relates to the Product description of the supplier

lieferanteinkaufnetto

Purchase price (net) per item

lieferanteinkaufwaehrung

Currency of the purchase price, e.g. (EUR, CHF, USD)

lieferanteinkaufmenge

Staggered quantity of the purchase price e.g. from 10 items = 10, for standard price enter quantity = 1

lieferanteinkaufvpemenge

When creating the purchase price, a VPE / PU (packaging unit) can be created. This variable fills the quantity of the PU

lieferanteinkaufvpepreis

Price of the VPE / PU

lieferantbestellnummer2 - 3

Refer to lieferantbestellnummer

lieferantartikelbezeichnung2 - 3

Refer to lieferantartikelbezeichnung

lieferanteinkaufnetto2 - 3

Refer to lieferanteinkaufnetto

lieferanteinkaufwaehrung2 - 3

Refer to lieferanteinkaufwaehrung

lieferanteinkaufmenge2 - 3

Refer to lieferanteinkaufmenge

lieferanteinkaufvpemenge2 - 3

Refer to lieferanteinkaufvpemenge

lieferanteinkaufvpepreis2 - 3

Refer to lieferanteinkaufvpepreis

lieferantrahmenvertrag_vonX (X = empty, or 1-3)

A supplier framework agreement can be created, when creating a purchase price. Specifies the start date of the contract.

lieferantrahmenvertrag_bisX (X = empty, or 1-3)

End date of the contract

lieferantpreis_anfrage_vomX (X = empty, or 1-3)

When creating a purchase price a supplier price inquiry can be assigned to a specific date.

lieferantgueltig_bisX (X = empty, or 1-3)

Fills the "Valid until" field when creating a purchase price

lieferantdatum_lagerlieferantX (X = empty, or 1-3)

Value of the inventory

lieferantsicherheitslagerX (X = empty, or 1-3)

Field Security warehouse, when creating purchase price

lieferantrahmenvertrag_mengeX (X = empty, or 1-3)

Fills the quantity field under framework agreement, when creating a purchase price

lieferantlieferzeit_aktuellX (X = empty, or 1-3)

Fills in the field for the current delivery time, when creating the purchase price

lieferantlieferzeit_standardX (X = empty, or 1-3)

Fills in the field for the standard delivery time, when creating the purchase price

lieferantlager_lieferantX (X = empty, or 1-3)

Fills in the field Inventory supplier, when creating the purchase price

lieferantrahmenvertragX (X = empty, or 1-3)

Sets a check mark at the framework agreement, when creating the purchase price

lieferantbemerkungX (X = empty, or 1-3)

Fills in field “Internal commentary”, only for the information of employees

lieferantnichtberechnetX (X = empty, or 1-3)

Sets a check mark at “Price not calculated from currency table” when creating purchase price (0, 1)

lieferantennummer

Supplier number, must be present in the system

standardlieferant (Supplier number from Xentral)

Fills in field “Standard supplier” under Product > Details

kundennummer

Fills in field “Customer”, when creating a selling price

gewicht

Weight (in kg)

breite

Width (in cm)

hoehe

Height (in cm)

laenge

Length (in cm)

einheit

Unit of the item

xvp

Amount of Xentral Volume Points (XVPs)

produktion

Sets a check mark at “Production item” under Product > Details

lagerartikel

Stock item = 1, not a stock item (e.g. Service, postage) = 0

lager_platz

Standard storage space (specify shelf name, not warehouse name)

lager_menge_addieren

Stock to be added to the existing stock

lager_menge_total

Stock to be added to the storage space

lager_mhd

BBD to be stocked in a storage space

lager_charge

Batch to be stocked in a storage space

lager_platzX (X = 1-5)

Refer to lager_platz

lager_menge_addierenX (X = 1-5)

Refer to lager_menge_addieren

lager_menge_totalX (X = 1-5)

Refer to lager_menge_total

lager_mhdX (X = 1-5)

Refer to lager_mhd

lager_chargeX (X = 1-5)

Refer to lager_charge

lager_vpe_mengeX (X = 1-5)

The field “Quantity in PU” under Product > Warehouse > Stock > Pen icon (required for amazon seller app deliveries by FBA), X for numbering

lager_vpe_gewichtX (X = 1-5)

Weight of PU

lager_vpe_laengeX (X = 1-5)

Length of PU

lager_vpe_breiteX (X = 1-5)

Width of PU

lager_vpe_hoeheX (X = 1-5)

Height of PU

lager_vpe_mengeX2 (X = 1-5)

Quantity of PU of X2

lager_vpe_gewichtX2 (X = 1-5)

Weight of PU of X2

lager_vpe_laengeX2 (X = 1-5)

Length of PU of X2

lager_vpe_breiteX2 (X = 1-5)

Width of PU of X2

lager_vpe_hoeheX2 (X = 1-5)

Height of PU of X2

verkaufspreisXnetto (X = 1-10)

Selling price (net)

verkaufspreisXpreisfuermenge (X = 1-10)

Stated selling price verkaufspreisXnetto is valid for specified quantity

verkaufspreisXmenge (X = 1-10)

From quantity

verkaufspreisXwaehrung (EUR,CHF,USD,...) (X = 1-10)

Currency

verkaufspreisXgruppe (reference number) (X = 1-10)

Group specific price for group

verkaufspreisXkundennummer (X = 1-10)

Customer specific price for customer with customer number

verkaufspreisXartikelnummerbeikunde (X = 1-10)

Product number, the customer uses (for information purposes)

verkaufspreisXgueltigab (X = 1-10)

Starting date of selling price

verkaufspreisXgueltigbis (X = 1-10)

End date of selling price

verkaufspreisXinternerkommentar (X = 1-10)

Internal Commentary e.g. for special conditions or reasons for timeframe

variante_von

Product is a variant of (Item number)

projekt

Project

geloescht (set to 1)

Deleted product = 1, not deleted = 0

inaktiv

No check mark at product inactive under “Online shop options” (Inactive product = 1, active product = 0)

juststueckliste

Check mark at Just in Time parts list under Product > Details

stueckliste

Check mark at parts list under Product > Details

stuecklistevonartikel

In parts list (number): Specifies main item of a parts list product

stuecklistemenge

Amount of items in a parts list

stuecklisteart

Type of parts list: et = Purchasing, it = Information, bt = Provision

vkmeldungunterdruecken

Set a check mark at “No sales price message” under Product > Details

shop_shopid (Replace shopid with ID of the shop)

Here you must specify the ID of the shop to be connected e.g. shop_3 for shop with ID = 3. Tip: You can find the ID of the shop interface at the end of the URL of the shop interface

aktiv_shopid (Replace shopid with ID of the shop)

Specification under Product > Online shop options whether the shop link is active

fremdnummerX_shopid (Replace shopid with ID of the shop, X = 1-40)

Fills in the field “Shop” under Product > External numbers

fremdnummerbezeichnungX_shopid (Replace shopid with ID of the shop, X = 1-40)

Fills in the field “Designation” under Product > External numbers

pseudopreis

Pseudo price, e.g. for display in the online shop

freifeld1 - freifeld40

Free fields for the product according to own definition in the system, the type will not be checked

intern_gesperrt

Field “Lock active” under Product > Details

intern_gesperrtgrund

Field “Report” under Product > Details

autolagerlampe (Stock numbers sync)

Check mark at Stock numbers sync. under Product > Online shop options (activated = 1, deactivated = 0)

pseudolager

Fills in the field “Pseudo warehouse number” under Product > Online shop options

lagerkorrekturwert

Fills in the field “Stock correction value” under Product > Online shop options. To adjust inventory (e.g. "1" to increase, "-1" to decrease)

restmenge

Set check mark at Remaining quantity (sale): Product will be set to “not available” after sale

provision1 (in %)

Set a commission in the module Commissions > Provisionen > New entry > Commission in the Commission settings area

provisiontyp1 (ek, vk, erloes, leer)

In the same line as the field Type

provision2 (in %)

In the same settings as the field Sales management commission

provisiontyp2 (ek, vk, erloes, leer)

In the same line as the field Type

eigenschaftname1 bis 50 (multiple)

Fills in the field Property, when creating a new property under Product > Properties. When you use this variable and create a property using an already existing property name, a new property will be created. The old property will remain.

eigenschaftnameeindeutig1 to 50 (single)

When using this variable, entering an existing property name will overwrite the existing property

eigenschaftwert1 to 50

Fills in the field Value, when creating a new property under Product > Properties.

eigenschaftname1_xx bis 50 (xx country code en, fr...)

Fills in the field Property, when creating a new translation under Product > Properties.

eigenschaftwert1_xx bis 50 (xx country code en, fr...)

Fills in the field Value, when creating a new translation under Product > Properties.

matrixprodukt

Set a check mark for Matrix product under Product > Details

matrixproduktvon

Only gets filled, if it refers to the matrix product of another product

matrixproduktgruppe1

First dimension of matrix properties

matrixproduktgruppe2

Second dimension of matrix properties, other properties can be added in the same way

matrixproduktwert1

Value (Option) of the first dimension of matrix properties

matrixproduktwert2

Value (Option) of the second dimension of matrix properties

matrixgruppe1 (all options from Group1)

All options of the first dimension of the matrix

matrixgruppe2 (all options from Group2)

All options of the second dimension of the matrix

matrixartikelnummer (1 = Number ranges, 2 = Name of option as suffix, 3|separator|digits|Starting number = suffix)

Automatic generation of item numbers by matrix values following this structure: Item number of main article with suffix, separator and additional numbers

matrixnamefuerunterartikel (1 = Options will be added to the item name of the subitem, 0 = Item name will be adopted from the main item)

Automatic generation of item names by matrix values

Additional languages (X = 1-100, Replace YY with the ISO code of the language from the Languages module)

nameX_YY

Fills in the field Name, when creating item texts in a different language

kurztextX_YY

Fills in the field Short text, when creating item texts in a different language

beschreibungX_YY

Fills in the field Designation, when creating item texts in a different language

beschreibung_onlineX_YY

Fills in the field Description under Online shop texts in a different language

meta_titleX_YY

Fills in the field Meta title under Online shop texts, when creating item texts in a different language

meta_descriptionX_YY

Fills in the field Meta description under Online shop texts, when creating item texts in a different language

meta_keywordsX_YY

Fills in the field Meta keywords under Online shop texts, when creating item texts in a different language

katalogartikelX_YY

Set a check mark at catalog item in the Catalog area, when creating item texts in a different language

katalog_bezeichnungX_YY

Fills in the field Designation in the Catalog area, when creating item texts in a different language

katalog_textX_YY

Fills in the field Catalog text in the Catalog area, when creating item texts in a different language

shopX_YY

aktivX_YY

freifeld1_YY - freifeld40_YY

hinweis_einfuegen

Fills in the field Note text in the Texts area in the Details tab > Product subtab of the product.

Variable

Description

typ (herr,frau,firma)

Salutation

marketingsperre

Set a check mark at Marketing lock in the settings area of the Contact master data

trackingsperre

Set a check mark at Tracking email block in the settings area of the Contact master data

sprache

Language for documents

name

Name

vorname (falls nicht bei name)

First name (if not included in name)

abteilung

Department

unterabteilung

Subdepartment

ansprechpartner

Contact person

land (DE,AT,...)

Country

strasse

Street

strasse_hausnummer

Street and house number

hausnummer

House number

ort

Town

plz

Postcode

plz_ort

Postcode and town

telefon

Telephone number

telefax

Fax number

mobil

Mobile/Cell phone number

email

Email address

ustid

VAT ID number

ust_befreit

Variable for the import of customer taxation:

0 (for domestic)

1 (for EU delivery)

2 (for export)

3 (for domestic - vat free)

sonstiges

Miscellaneous

adresszusatz

Address supplement

kundenfreigabe

The dropdown menu Customer approval in the settings area of the Contact master data

kundennummer

Customer number

lieferantennummer

Supplier number

mitarbeiternummer

Employee number

bank

Name of bank

inhaber

Owner of bank account

swift

SWIFT-Code / BIC

iban

IBAN

waehrung

Account currency

paypal

Create under Contacts/Bank details field Paypal-Account under Paypal (for payments)

paypalinhaber

Create under Contacts/Bank details field Owner under Paypal (for payments)

paypalwaehrung

Create under Contacts/Bank details field Currency under Paypal (for payments)

projekt

Contact data field Main project

zahlungsweise

Fills the field Payment method under Payment terms/taxation under Terms of payment for the customer for invoices

zahlungszieltage

Fills the field Payment term (in days) under Payment terms/taxation

zahlungszieltageskonto

Fills the field Payment term discount (in days)

zahlungszielskonto

Fills the field Discount

versandart

Fills the field Shipping method

kundennummerlieferant

Fills the field customer number in the payment conditions of the supplier

zahlungsweiselieferant

Fills the field payment method in the payment conditions of the supplier

zahlungszieltagelieferant

Fills the field payment goal (in days) in the payment conditions of the supplier

zahlungszieltageskontolieferant

Fills the field payment goal discount (in days) in the payment conditions of the supplier

zahlungszielskontolieferant

Fills the field discount in the payment conditions of the supplier

versandartlieferant

Fills the field Shipping method in the payment conditions of the supplier

firma

Company name

webid

internetseite

Website

titel

Academic title

anschreiben

Cover letter

geburtstag

Date of birth

liefersperre

Fills the field delivery block in the settings area of the Contact master data

steuernummer

Fills the field tax number under Payment terms / taxation in the Tax / Currency / Customs area.

steuerbefreit

Chooses "Tax-free domestic" in the dropdown menu for the field Taxation

liefersperregrund

Fills the field “Delivery block reason” in the contact master data

verrechnungskontoreisekosten

The field “Traveling expenses” in Other data

abweichende_rechnungsadresse

Sets a check mark for Dev. Billing address in the contact master data

rechnung_vorname

Alternative address for invoices: First name

rechnung_name

Alternative address for invoices: Name

rechnung_titel

Alternative address for invoices: Academic title

rechnung_typ

Alternative address for invoices: Type (company, herr, frau, mr., mrs.)

rechnung_strasse

Alternative address for invoices: Street

rechnung_ort

Alternative address for invoices: Town

rechnung_land

Alternative address for invoices: Country

rechnung_abteilung

Alternative address for invoices: Department (line 2)

rechnung_unterabteilung

Alternative address for invoices: Subdepartment (line 3)

rechnung_adresszusatz

Alternative address for invoices: Address supplement

rechnung_telefon

Alternative address for invoices: Phone

rechnung_telefax

Alternative address for invoices: Fax

rechnung_anschreiben

Alternative address for invoices: Cover letter

rechnungs_email

Alternative address for invoices: Email

rechnung_plz

Alternative address for invoices: Post code (ZIP)

rechnung_ansprechpartner

Alternative address for invoices: Contact person

kennung

Fills the field “Unique identifier” in Other data

vertrieb

Employee Distribution; you need to specify the employee ID here, not the employee number

innendienst

Employee Back office

rabatt

rabattX (X = 1 - 5)

bonusX (X = 1-10)

bonusX_ab (X = 1-10)

verbandsnummer

portofreiab

Fills the field Postage free from … € a certain turnover (net) under Other data

zahlungskonditionen_festschreiben

Sets a check mark at “Establish payment terms” under Payment terms / Taxation

rabatte_festschreiben

provision

Fills the field Commission under Other data

portofrei_aktiv

Sets a check mark at Postage free

rabattinformation

freifeld1 - freifeld20

Free fields for the product according to own definition in the system, the type will not be checked

rechnung_periode

rechnung_anzahlpapier

usereditid

useredittimestamp

infoauftragserfassung

mandatsreferenz

Fills the field Mandate reference under Bank details

kreditlimit

abweichendeemailab

filiale

mandatsreferenzdatum

Fills the field Mandate reference date under Bank details

mandatsreferenzaenderung

Sets a check mark at Mandate reference change under Bank details

sachkonto

ansprechpartner1name (1-3 possible)

Fills the field Name in the Contact person tab, when creating a new contact person

ansprechpartner1typ

Fills the field Type in the Contact person tab, when creating a new contact person

ansprechpartner1strasse

Fills the field Street in the Contact person tab, when creating a new contact person

ansprechpartner1sprache

ansprechpartner1bereich

ansprechpartner1abteilung

Fills the field Department in the Contact person tab, when creating a new contact person

ansprechpartner1unterabteilung

Fills the field Subdepartment in the Contact person tab, when creating a new contact person

ansprechpartner1land

Fills the field Country in the Contact person tab, when creating a new contact person

ansprechpartner1ort

Fills the field Town in the Contact person tab, when creating a new contact person

ansprechpartner1plz

Fills the field ZIP-code in the Contact person tab, when creating a new contact person

ansprechpartner1telefon

Fills the field Phone in the Contact person tab, when creating a new contact person

ansprechpartner1telefax

Fills the field Fax in the Contact person tab, when creating a new contact person

ansprechpartner1mobil

Fills the field Mobile in the Contact person tab, when creating a new contact person

ansprechpartner1email

Fills the field Email in the Contact person tab, when creating a new contact person

ansprechpartner1sonstiges

Fills the field Miscellaneous in the Contact person tab, when creating a new contact person

ansprechpartner1adresszusatz

Fills the field Additional address in the Contact person tab, when creating a new contact person

ansprechpartner1ansprechpartner_land

ansprechpartner1anschreiben

ansprechpartner1titel

Fills the field Title in the Contact person tab, when creating a new contact person

ansprechpartner1marketingsperre

Sets a check mark for marketing lock

lieferadresse1name (1-3 possible)

Fills the field Name in the Delivery addresses tab, when creating a new entry

lieferadresse1typ

Fills the field Type in the Delivery addresses tab, when creating a new entry

lieferadresse1strasse

Fills the field Street in the Delivery addresses tab, when creating a new entry

lieferadresse1abteilung

Fills the field Department in the Delivery addresses tab, when creating a new entry

lieferadresse1unterabteilung

Fills the field Subdepartment in the Delivery addresses tab, when creating a new entry

lieferadresse1land

Fills the field Country in the Delivery addresses tab, when creating a new entry

lieferadresse1ort

Fills the field Town in the Delivery addresses tab, when creating a new entry

lieferadresse1plz

Fills the field ZIP-code in the Delivery addresses tab, when creating a new entry

lieferadresse1telefon

Fills the field Phone in the Delivery addresses tab, when creating a new entry

lieferadresse1gln

Fills the field GLN in the Delivery addresses tab, when creating a new entry

lieferadresse1email

Fills the field Email in the Delivery addresses tab, when creating a new entry

lieferadresse1adresszusatz

Fills the field Additional address in the Delivery addresses tab, when creating a new entry

lieferadresse1standardlieferadresse

Sets a check mark at Standard delivery address

lieferadresse1ustid

Fills the field VAT ID in the Delivery addresses tab, when creating a new entry

lieferadresse1ust_befreit

gruppe1-5

Group

kundennummer_buchhaltung

Posting account that differs from the customer number (debtor number)

lieferantennummer_buchhaltung

Posting account that differs from the supplier number (creditor number)

GLN

GLN of the customer

Variable

Description

datum_von

In the Time Recording module, when booking times, the field after "At the:"

zeit_von

Starting time

zeit_bis

End time

kennung

Selection from Work, Pause, Vacation, Sickness, Compensatory time off, Public holiday

taetigkeit

Short description of task

details

Extended description of task

mitarbeiternummer

Employee number

kundennummer

Customer number for working times booked to customers

Variable

Description

datum_faellig

Fills the field Reminder date in the Follow-Up module, when creating a new entry

uhrzeit_faellig

Fills the field Time in the Follow-Up module, when creating a new entry

kundennummer

Fills the field Contact in the Follow-Up module, when creating a new entry

mitarbeiternummer

Fills the field Contact person in the Follow-Up module, when creating a new entry

betreff

Fills the field Designation in the Follow-Up module, when creating a new entry

text

Fills the field Description in the Follow-Up module, when creating a new entry

abgeschlossen

Sets check mark at Completed

prio

Sets check mark at Priority

Variable

Description

datum

Fills the field Date / Submission by in the Tasks module, when creating a new entry

uhrzeit

Fills the field Time in the Tasks module, when creating a new entry

kundennummer

Fills the field For customer in the Tasks module, when creating a new entry

mitarbeiternummer

Fills the field Employee in the Tasks module, when creating a new entry

betreff

Fills the field Task in the Tasks module, when creating a new entry

text

Fills the field Description in the Tasks module, when creating a new entry