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`