Article Import

Short description

This import is enabled for customers that manage their product data in the PIM component of Vendisto.

The Article XML import is the XML equivalent of the Article Excel import. These files enable the user to batch update product data in Vendisto.

The file can be upload by hand into Vendisto via the import/export dialog or by an automated process that is started when the file is placed in the correct upload location within in the FTP root.

If an optional field is left empty, or the element itself does not exist, the importer will use an empty string.

Delivery method

Update Frequency: Batch at least once a day

Incremental or complete set: Incremental

Filetype: Zipped XML

Filename: [SHOPNAME]_Articles_[INDEXNUMBER].xml Transport: over FTPS, FTPS Vendisto server hosted by INTEGRACE, file will be placed on FTPS server by ERP party.

Location within FTP root: \Vendisto\Integration\

Structure XML

<?xml version="1.0" encoding="utf-8"?>
<Import>
    <ImportSettings>
        <Importer>Articles</Importer>
        <Version>1.0</Version>
        <IsPartial>Y</IsPartial>
        <CreateUnknownClassificationPaths>Y</CreateUnknownClassificationPaths>
        <SplitArticlePropertyValuesInUnits>Y</SplitArticlePropertyValuesInUnits>
        <DisableGtinValidation>N</DisableGtinValidation>
    </ImportSettings>
    <ArticleGroups>
        <ArticleGroup id="">
            <Name>String</Name>
            <DescriptionHeader>String</DescriptionHeader>
            <DescriptionFooter>String</DescriptionFooter>
            <Brand>String</Brand>
            <Kind>String</Kind>
            <BluePencil transposed=""/>
            <Classification declassify="">
                <Level1>string</Level1>
                <Level2>string</Level2>
                <Level3>string</Level3>
                <Level4>string</Level4>
            </Classification>
            <Assets>
                <Logo>
                    <Name>String</Name>
                    <Value>String</Value>
                </Logo>
                <Image>
                    <Name>String</Name>
                    <Value>String</Value>
                </Image>
                <Icon>
                    <Name>String</Name>
                    <Value>String</Value>
                </Icon>
                <Document>
                    <Name>String</Name>
                    <Value>String</Value>
                </Document>
                <Media>
                    <Name>String</Name>
                    <Value>String</Value>
                </Media>
            </Assets>
            <Articles>
                <Article number="" gtin="" state="">
                    <Title>String</Title>
                    <Description>String</Description>
                    <TypeNumber>String</TypeNumber>
                    <Manufacturer gln="" mpn="" gtin=""/>
                    <SubGroup id="" index=""/>
                    <Assets>
                        <Logo>
                            <Name>String</Name>
                            <Value>String</Value>
                        </Logo>
                        <Image>
                            <Name>String</Name>
                            <Value>String</Value>
                        </Image>
                        <Icon>
                            <Name>String</Name>
                            <Value>String</Value>
                        </Icon>
                        <Document>
                            <Name>String</Name>
                            <Value>String</Value>
                        </Document>
                        <Media>
                            <Name>String</Name>
                            <Value>String</Value>
                        </Media>
                    </Assets>
                    <Properties>
                        <Property>
                            <Header>String</Header>
                            <Value>String</Value>
                            <Unit>String</Unit>
                            <Icon>String</Icon>
                            <BluePencil hidden="" spec="" index="">
                                <Description>String</Description>
                                <Icon>String</Icon>
                            </BluePencil>
                        </Property>
                    </Properties>
                    <AuthorizationProfiles>
                        <AuthorizationProfile>
                        </AuthorizationProfile>
                        <AuthorizationProfile>
                        </AuthorizationProfile>
                    </AuthorizationProfiles>
                </Article>
            </Articles>
            <SubGroups>
                <SubGroup id="">
                    <DescriptionHeader>String</DescriptionHeader>
                    <DescriptionFooter>String</DescriptionFooter>
                </SubGroup>
            </SubGroups>
        </ArticleGroup>
    </ArticleGroups>
</Import>

Fields XML

Import element:

Name

Description

Type

Required/Optional

ImportSettings

Container element for the import settings

Element

Required

ArticleGroups

Container for the ArticleGroup elements

Element

Required

ImportSettings element:

Name

Description

Type

Required/Optional

Importer

Name of the importer. Should be ArticleGroups.

Text

Optional

Version

Version of the import xml. To be used for backward compatibility issues.

Text, default 1.0

Optional

IsPartial

If set to N, articles that are not in the import will be suspended.

Boolean

Default: Y

Optional

CreateUnknownClassificationPaths

If set to Y, new classification nodes will be added. If set to N, an error will be generated if unknow classification nodes are encountered.

Boolean

Default: Y

Optional

SplitArticlePropertyValuesInUnits

Automatically split units that are part of the Value field of property into the Unit field.

Boolean

Default: Y

Optional

DisableGtinValidation

If set to Y, the validation on the correctness of Gtin numbers is skipped in the import.

Boolean

Default: N

Optional

The IsPartial element works on rows, not columns. A partial import will update or add the articles it contains, and will not delete articles that are not mentioned. For a specific article, the partial import assumes that the information that is offered is exhaustive, and will delete any information that is present in the database but not mentioned in the file.

ArticleGroup element:

Name

Description

Type

Required/Optional

id

The unique identifier of the article group

GUID

Optional

Name

The name of the article group

Text

Required

DescriptionHeader

The description header of the article group

Text

Optional

DescriptionFooter

The description footer of the article group

Text

Optional

Brand

The brand of the article group

Text

Optional

Kind

The kind of the article group

Text

Optional

BluePencil

Container element for the blue article group blue pencil data

Element

Optional

Classification

Container element for the classification data

Element

Optional

Assets

Container element for the article group assets

Element

Optional

Articles

Container element for the articles in the article group

Element

Optional

SubGroups

The sub-groups of this group

Element

Optional

BluePencil element:

Name

Description

Type

Required/Optional

transposed

Indicates if the article group table is transposed

Boolean

Default: N

Optional

Classification element:

Name

Description

Type

Required/Optional

declassify

Specifies if the article group should be decoupled from the current classification node

Bool

Default: N

Optional

Level1

Level one classification nodes in the classification tree

Text

Optional

Level2

Level two classification nodes in the classification tree

Text

Optional

Level3

Level three classification nodes in the classification tree

Text

Optional

Level4

Level four classification nodes in the classification tree

Text

Optional

Assets element:

Name

Description

Type

Required/Optional

Logo

Asset, that belongs to this Article or Article group

Element

Optional

Image

Asset, that belongs to this Article or Article group

Element

Optional

Icon

Asset, that belongs to this Article or Article group

Element

Optional

Media

Asset, that belongs to this Article or Article group

Element

Optional

Logo, Image, Icon, Media (Asset) element:

Name

Description

Type

Required/Optional

Name

Text

Optional

Value

Text

Optional

Article element:

Name

Description

Type

Required/Optional

Number

The article number of the article

GUID

Required

gtin

The “Global Trade Item Number” of the article

Text

Optional

state

Active / Suspended / Deleted

ArticleLifeTimeState

Optional

Title

The title of the article

Text

Optional

Description

A description of the article

Text

Optional

TypeNumber

The type number of the article

Text

Optional

Manufacturer

Container element for the article manufacturer data

Element

Optional

SubGroup

Container element for the article sub-group data

Element

Optional

Assets

Container element for the article assets

Element

Optional

Properties

Container element for the article properties

Element

Optional

AuthorizationProfiles

Container element for the article authorization profiles

Element

Optional

Manufacturer element:

Name

Description

Type

Required/Optional

gln

The “Global Location Number” of the manufacturer

Text

Optional

mpn

The “Manufacturer Part Number”

Text

Optional

gtin

The “Global Trade Item Number”

Text

Optional

Article/SubGroup element:

Name

Description

Type

Required/Optional

id

The identifier of the sub-group that the article is in

GUID

Optional

index

The priority of the item in the sub group

Integer

Optional

Article/Property element:

Name

Description

Type

Required/Optional

Header

The name of the property

Text

Optional

Value

The value of the property

Text

Optional

Unit

The metric unit of the property

Text

Optional

Icon

The icon of the property

Text

Optional

BluePencil

Container for the blue pencil data of the property

Element

Optional

Properties are always imported as a full set. When importing properties, the full set should be present, or alternatively no properties at all. If the file contains only a subset of the properties for a specific article, all properties that are not specified will be deleted.

Property/BluePencil element:

Name

Description

Type

Required/Optional

hidden

Indicates if the property should be displayed

Boolean

Default: N

Optional

spec

If the property is to be shown below the description header

Boolean

Default: N

Optional

index

The position of the property in the article table

Integer

Optional

Description

The description of the property

Text

Optional

Icon

Only god knows

Text

Optional

SubGroup element:

Name

Description

Type

Required/Optional

id

The identifier of the sub-group

GUID

Optional

DescriptionHeader

The description header of the sub-group

Text

Optional

DescriptionFooter

The description footer of the sub-group

Text

Optional

AuthorizationProfile element:

Name

Description

Type

Required/Optional

AuthorizationProfile

Name of a profile that is allowed for this article

Text

Optional

Types:

Type

Values

GUID

00000000-0000-0000-0000-000000000000

Boolean

Y, N

ArticleLifeTimeState

Active / Suspended / Deleted

Last updated