itemVariations
Use the itemVariations data format creator to export variation data 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.
1. Technical specifications
See Table 1 for further information on the available properties and their corresponding values.
Property | Meaning | Value | Explanation |
---|---|---|---|
dataName |
Name |
itemVariations |
Name of the creator process and prefix of the created file. |
fileFormat |
File format |
CSV, GZIP |
The data is provided as a GZIP-compressed CSV file (RFC 1952). |
limitPage |
Lines per request |
up to 8,000 |
The maximum number of data rows that is written into a single file. |
limitDay |
Lines per day |
up to 400,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 |
iv_updated_at |
Name of the column that contains the time stamp of the last data update. |
defaultActive |
Activated by default |
no |
The data is only exported automatically in the background after you have activated the creator in the Setup » plentyBI » Raw data menu. |
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 XS |
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 itemVariations data columns included in the CSV file during raw data export.
Column name | Data type | Full name | Explanation |
---|---|---|---|
plenty_id |
INTEGER NOT NULL |
plenty id |
ID of the plentymarkets system |
iv_id (Primary key) |
VARCHAR NOT NULL |
item variation id |
ID of the variation |
i_id |
VARCHAR NOT NULL |
item id |
The item’s ID |
im_id |
VARCHAR |
item manufacturer id |
Manufacturer ID |
iv_attribute_value_set_id |
VARCHAR |
item variation attribute value set id |
ID of the combination of content and attribute value |
c_id |
VARCHAR |
category id |
Category ID |
c_level_1_id |
VARCHAR |
category level 1 id |
Category ID: level 1 |
c_level_2_id |
VARCHAR |
category level 2 id |
Category ID: level 2 |
iv_number |
VARCHAR |
item variation number |
Variation number |
i_revenue_account |
INTEGER |
item revenue account |
The revenue account saved in the item data record. |
i_name |
VARCHAR |
item name |
Item name |
iv_active |
SMALLINT NOT NULL |
item variation active |
Possible values: |
iv_availability |
SMALLINT NOT NULL |
item variation availability |
ID of the availability of the variation |
i_created_at |
TIMESTAMPTZ NOT NULL |
item created at |
Time stamp of the creation |
iv_updated_at |
TIMESTAMPTZ NOT NULL |
item variation updated at |
Time stamp of the last update |