Skip to main content

variationValidation

Use the variationValidation data format creator to export information on variations that do not comply with important rules of specific markets. You can export the results of the validation and save this data in the cloud. The raw data file is stored in the cloud for a maximum of 6 months. Therefore, the data must be processed before this date. The following tables contain further information about the format.

The export to the following markets currently can be validated:

  • Amazon:

    • Flatfile 2020.1109-1_Clothing_DE

    • Flatfile 2020.1109-1_ConsumerElectronics_DE

1. Technical specifications

See Table 1 for further information on the available properties and their corresponding values.

Table 1. Technical specifications of the format variationValidation
Property Description Value Explanation

dataName

Name

variationValidation

Name of the creator process and prefix of the created file.
File name: variationValidation-xxx.csv.gz

fileFormat

File format

CSV, GZIP

The data is provided as a GZIP-compressed CSV file (RFC 1952).

limitPage

Lines per request

up to 500

The maximum number of data rows that is written into a single file.

limitDay

Lines per day

up to 10,000

The maximum number of data rows that is written on one day in total.

earliestPossibleDataDate

Earliest point in time

2020-01-01

Point in time as of which the raw data can be collected. The data is filtered by the date saved in the dataUpdatedAtColumnName column.

filterType

Filter type

lastUpdate

Data are filtered based on the last update.

dataUpdatedAtColumnName

Column header

createdAt

Name of the column that contains the time stamp of the last data update.

defaultActive

Activated by default

yes

As standard, the export runs automatically in the background.

interval

Interval

daily

With this setting, all data that has been changed since the last run is exported once a day, usually during the night.

storableFromPlan

Storage starting from tariff

plentyBI S

Minimum fee plan required for saving the data in cloud storage and making it available via REST.

processableFromPlan

Usage starting from tariff

plentyBI L

Minimum fee plan required for making the data available in plentyBI Data Warehouse, i.e. for using, filtering and processing key figures.

2. Data columns

See Table 2 for further information on the variationValidation data columns included in the CSV file during raw data export.

Table 2. Data columns of the format variationValidation
Column name Data type Full name Explanation

plentyId

INTEGER NOT NULL

plenty ID

The unique ID of the plentymarkets system

id (primary key)

VARCHAR NOT NULL

ID

Internal ID for technical purposes

processId

VARCHAR NOT NULL

Process ID

The unique ID of the validation process

originId

VARCHAR NOT NULL

origin ID

The ID of the catalogue that was validated.

originType

VARCHAR NOT NULL

Origin type

This origin is always Catalogue.

identifierType

VARCHAR NOT NULL

identifier type

The record can be identified based on the identifier type. For example, the identifier type may be the ASIN.

identifierValue

VARCHAR NOT NULL

identifier value

Identifier value of the record
The value of the identifier type that identifies the record. For example, if the identifier type is ASIN, the column identifierValue will contain the ASIN of the variation.

variationId

INTEGER NOT NULL

Variation ID

The unique ID of the variation

referrerId

NUMERIC(5,2)

Referrer ID

The ID of the market’s order referrer
Note: Only variations to be exported to some platforms of the market Amazon are saved.

errorType

VARCHAR NOT NULL

Error type

Error type
Possible error types:
MISSING = The value is missing.
INVALID = The value is invalid.

key

VARCHAR NOT NULL

key field

The plentymarkets data field that contains the error

meta

JSON NOT NULL

Meta

This column is currently empty.

createdAt

TIMESTAMP NOT NULL

Created on

The date and time that the validation took place.
Format of the timestamp: MM/DD/YYYY HH:MI:SS TZ

To top