CSV formats (zip) for API 1.0

Last modified: 6. July 2022

CSV all data 2 (full2.csv)

This format contains all product data, divided into several tables. The tables contain references to each other. The format is available in the export. API retrieval is done with “full.csv”.

SQL database import

Dependencies graph for the individual table and export files

The RatingContent, MediaContent, and TextContent tables do not have a foreign key to the ContentTag table, because the column contentTagRefId contains an ascending comma-separated list of TagIds in the respective tables.

MySql script for creating database tables

This script for MySql creates the tables similar to the dependency diagram including primary and foreign keys.

Download MySql Script

Sequence for importing the files

  1. SetGroup
  2. set
  3. Supplier
  4. Alten
  5. ContentProvider
  6. ContentModel
  7. ContentCategory
  8. ContentTag
  9. FeatureModel
  10. AttributeCluster
  11. Product
  12. ProductXRefAttributeCluster
  13. SupplierItem
  14. ProductPriceInfo
  15. ProductStock
  16. SupplierItemPriceInfo
  17. SupplierItemStock
  18. KeyContent
  19. RatingContent
  20. RefContent
  21. MediaContent
  22. TextContent

Main table

Product

Contains all products

fieldData typedescription
PuidLongUnique key
SetRefIdLongPoints 1: 1 to Set.id
ManRefIdLongRefers 1: 1 to Manufacturer.id
RankIntegerGeneral popularity rank (rank 1 to n, a high number corresponds to a bad ranking)
QualificationIntegerQualification of the product
EanString (20)EAN
ManufacturerSKUString (40)Manufacturer part number
ShortInfotextShort identifier
ProductNameStringProduct name, long name
EntryDateDateWhen is the product on the platform
RecRetailPriceDoubleManufacturer’s UVP
vatDoubleMore fire control
EstimateGrossWeightDoubleweight
LargeDimXStringLength of product
LargeDimYStringHeight of the product
LargeDimZStringWidth of the product
DeeplinkStringDeeplink on the ITscope.com platform
RelevanceDoubleAddiction relevance
FeatureAttribute1String (2000)Property value for the attributes from Set.attributeTypeId1
FeatureAttribute2String (2000)Property value for the attributes from Set.attributeTypeId2
FeatureAttribute3String (2000)Property value for the attributes from Set.attributeTypeId3
FeatureAttribute4String (2000)Property value for the attributes from Set.attributeTypeId4
FeatureAttribute5String (2000)Property value for the attributes from Set.attributeTypeId5
ProductTypeString (2000)Construction property
ProductLineString (2000)Product line
ProductModelString (2000)Product model

Referenced tables

ProductPriceInfo

Contains the Min and Max price data on the products

fieldData typedescription
ProdRefIdLongRefers to product.puid (eg minimum price of the product)
SupreFIdLongRefers 1: 1 to Supplier.id
PriceDoubleprice
TypeStringNature of the prize as MIN or MAX
MinScaleIntegerPrice from season
PriceSourceIdIntegerIdentifier for the origin of the price and stock information (relating to price source name)
PriceSourceNameStringreadable text for origin pricing and inventory information
LastUpdateDatePrice date
CurrencyCodeStringCurrency unit
CalcPriceDoubleCalculated price
CalcPriceBaseDoublePrice based on the closing price

ProductStock

Contains aggregated inventory data for products

fieldData typedescription
PuidLongUnique ITscope Product ID
AggregatedStatusIntegerBest availability status
AggregatedStatusTextStringBest readable availability status
AggregatedStockIntegerTotal of all inventories
AggregatedSupplierItemsIntegerSum of all distributors to this product

SupplierItem

References to products

fieldData typedescription
idLongUnique key
ProdRefIdLongRefers to Product.puid
SupreFIdLongRefers 1: 1 to Supplier.id
SetRefIdLongPoints 1: 1 to Set.id
ManRefIdLongRefers 1: 1 to Manufacturer.id
SupplierItemIdString (40)Product number of the supplier
ProductNameStringExact identifier of the article at the supplier
InfoTexttextExtended article description at the supplier
StateIdIntegernumeric code of the state of the goods
StateNameStringCondition of item (new, used, B-goods, refurbished etc.)
MatchQualityIntegerMapping quality of the article for ITscope product catalog
NewProductBooleanFlag new article
EolProductBooleanFlag Discontinued Items
SupplierEanString (20)EAN specification of the supplier
EanValidBooleanFlag, whether the EAN of the vendor is valid according to the EAN criteria
SupplierManufacturerSKUString (40)Supplier’s part number (does not have to match ITscope)
SupplierManufacturerNameString (80)Manufacturer name as specified by supplier
RecRetailPriceDoubleUVP-indication of the supplier
SupplierPromoString (40)Name of the promotion activity of the supplier
vatIntegerVAT rate for the item
LargeDimXDoubleLength of the product
LargeDimYDoubleHeight of the product
LargeDimZDoubleWidth of the product
WarrantyString (40)Supplier’s warranty
DeeplinkStringLink to the article at the supplier
SpecialOfferBooleanFlag whether item is special offer
TopSellerBooleanFlag if the article is a top seller
FlatChargeDoubleCopyright
CustTariffNumberString (50)Customs tariff number
SourceCountryString (20)Country of origin of the article

SupplierItemPriceInfo

Contains the price data for the individual sources of supply

fieldData typedescription
SupItemRefIdLongRefers to SupplierItem.id if this price is a reference source
SupreFIdLongRefers 1: 1 to Supplier.id
PriceDoubleprice
TypeStringType of price
MinScaleIntegerPrice from season
PriceSourceIdIntegerIdentifier for the origin of the price and stock information (relating to price source name)
PriceSourceNameStringreadable text for origin pricing and inventory information
LastUpdateDatePrice date
CurrencyCodeString (10)Currency unit
CalcPriceDoubleCalculated price
CalcPriceBaseDoublePrice based on the closing price

SupplierItemStock

Reference sources only with storage data for products

fieldData typedescription
idLongRefers 1: 1 to SupplierItem.id
SupplierStockTextStringInventory report of the supplier
StockIntegerStock in this reference source
LastStockUpdateDateTime of last update of inventory
StockStatusIntegerIdentifier for state of the stock (refers to stockStatusText)
StockStatusTextStringReadable inventory status
StockSourceIdIntegerIdentifier for the origin of the price and stock information (refers to stockSourceName)
StockSourceNameStringReadable text on the origin of the stock information (stock list, …)
StockUnlimitedBooleanTrue = unlimited stock, false = not unlimited
StockAvailabilityDateDateThe time at which the reference source is available again

Content tables

KeyContent

Keys from content providers for Contentlink

fieldData typedescription
KeyLongKey of the record, not unique
ContentModelRefIdLongReferences n: 1 on ContentModel.id
ProdRefIdLongRefers to Product.puid
ContentProviderRefIdLongRefers to n: 1 on ContentProvider.id
ValuetextValue of the key
longStringLanguage code in Iso639

MediaContent

Media (such as images) to products

fieldData typedescription
KeyLongKey of the record, not unique
LongIdLongLanguage identifier , suitable for long field, but does not reference a table
ContentModelRefIdLongRefers to ContentModel.id
ProdRefIdLongRefers to Product.puid
ContentProviderRefIdLongRefers to n: 1 on ContentProvider.id
ContentCategoryRefIdLongRefers to n: 1 on ContentCategory.id
ContentTagRefIdStringComma separated list of tags, refer to ContentTag.id
ValuetextValue of the medium
longStringLanguage code in Iso639
MimeTypeStringMimeType eg image / jpeg, text / html, …
HeightLongHeight of medium
WidthLongWidth of medium

RatingContent

Reviews for a product (eg tests, awards, …)

fieldData typedescription
KeyLongKey of the record, not unique
ContentModelRefIdLongReferences n: 1 on ContentModel.id
ProdRefIdLongRefers to Product.puid
ContentProviderRefIdLongRefers to n: 1 on ContentProvider.id
ContentTagRefIdStringComma separated list of tags, refer to ContentTag.id
ValuetextValue of rankings
longStringLanguage code in Iso639
UnitString (20)Unit of the ranking, eg note, points, …
DeeplinkStringDeeplink on the ranking platform

RefContent

References to external content

fieldData typedescription
KeyLongKey of the record, not unique
ContentModelRefIdLongReferences n: 1 on ContentModel.id
ProdRefIdLongN: 1 on Product.puid (product to which this content belongs)
ContentProviderRefIdLongRefers to n: 1 on ContentProvider.id
CrossProdRefIdLongN: 1 on Product.puid (Crossref products)
TypeIdIntegeris the unique identifier for the type field , no reference to a table
TypeStringIdentifier for the type field
OriginalReferenceStringExternal reference

TextContent

Texts on the product, such as marketing texts, short texts, long texts

fieldData typedescription
KeyLongKey of the record, not unique
ContentModelRefIdLongReferences n: 1 on ContentModel.id
ProdRefIdLongN: 1 on Product.puid (product to which this content belongs)
ContentProviderRefIdLongRefers to n: 1 on ContentProvider.id
CrossProdRefIdLongN: 1 on Product.puid (Crossref products)
TypeIdIntegeris the unique identifier for the type field , no reference to a table
TypeStringIdentifier for the type field
OriginalReferenceStringExternal reference

Aggregated master data

ContentProvider

Provider of Content as 1WorldSync, Icecat, Manufacturer, Distributor

fieldData typedescription
idLongUnique key
nameStringClear text name of the content supplier (eg Icecat, 1WorldSync, …)
RankIntegerPrioritization, for sorting, same values ​​are possible several times

ContentModel

Model / type of content , according to content providers

fieldData typedescription
idLongUnique key
nameStringDisplay name of the content (eg Icecat standard image large, 1WorldSync product ID, …)

ContentCategory

ITscope categorization of content , what content is present (eg Structured feature articles, product photo, …)

fieldData typedescription
idLongUnique key
nameStringIdentifier of category

ContentTag

Tags for content , content description of the content, uniform across content providers across

fieldData typedescription
idLongUnique key
nameStringIdentifier for the content type (small picture, thumbnail, marketing text, ..)
RankIntegerPrioritization, for sorting, same values ​​are possible several times
SourceString“Itscope” when ITscope’s tag was entered, “supplier” for tags automatically generated from read-in data

FeatureModel

As supplied by the ContentProvider

fieldData typedescription
idLongUnique key
nameStringName of the property

AttributeCluster

Value ranges or characteristics of a product property

fieldData typedescription
idLongUnique key
SetIdLongRefers to Set.id 1: 1, but can also be null if the cluster is assigned to a general set
nameStringIdentifier of the expression (eg 2 GB, 15 “, 80 W – 120 W, …)
MinStringMininimal limit with respect to a property in which the expression of the product must fall in order to be assigned to this attribute cluster
MaxStringMaximum limit with respect to a property in which the value of the product must fall in order to be assigned to this attribute cluster
RankLongRank of the property
AttributeTypeIdLongIdentifies a property and identifies attributeTypeName, attributeTypeRank, and attributeTypeUnit. No table reference. Refer to Set.attributeTypeId (1..5)
AttributeTypeNameStringName of a property. Can be the same as the name from Set.attributeTypeName (1..5)
AttributeTypeRankLongRanking of the property, for example, can be used for sorting
AttributeTypeUnitStringUnit of the property
AttributeTypeGroupIdStringIdentifier of a property group, no table reference, but uniquely identifies attributeTypeGroupName
AttributeTypeGroupNameStringName of a property group

Alten

manufacturer

fieldData typedescription
idLongUnique key
nameStringIdentifier of the manufacturer
ShortNameStringManufacturer’s nickname
DeeplinkStringURL, link to the manufacturer within the ITscope platform

Supplier

Suppliers

fieldData typedescription
idLongUnique key
nameStringIdentifier of the manufacturer
DeeplinkStringURL, link to the supplier within the ITscope platform
partnerStringCustomer number in case of partnership. Can be used as a filter to determine whether there is a partnership for this supplier

set

Product types

fieldData typedescription
idLongUnique key
GrpRefIdStringRefers to SetGroup.id
nameStringIdentifier of the product type
AttributeTypeId1LongUnique attribute key to build a possible subcategory, 1: n points to AttributeCluster.attributeTypeId
AttributeTypeName1StringIdentifier of the attribute to build up a possible subcategory
AttributeTypeId2LongUnique attribute key to build a possible subcategory, 1: n points to AttributeCluster.attributeTypeId
AttributeTypeName2StringIdentifier of the attribute to build up a possible subcategory
AttributeTypeId3LongUnique attribute key to build a possible subcategory, 1: n points to AttributeCluster.attributeTypeId
AttributeTypeName3StringIdentifier of the attribute to build up a possible subcategory
AttributeTypeId4LongUnique attribute key to build a possible subcategory, 1: n points to AttributeCluster.attributeTypeId
AttributeTypeName4StringIdentifier of the attribute to build up a possible subcategory
AttributeTypeId5LongUnique attribute key to build a possible subcategory, 1: n points to AttributeCluster.attributeTypeId
AttributeTypeName5StringIdentifier of the attribute to build up a possible subcategory

SetGroup

Product type groups

fieldData typedescription
idStringUnique key
nameStringIdentifier of the product type group

Cross Table

ProductXRefAttributeCluster

Associates the tables Product and AttributeCluster n: m, thus assigning each product its set of attributes of product properties

fieldData typedescription
ProdRefIdLongPoints 1: n to Product.puid
AttributeClusterRefIdLongPoints 1: n to AttributeCluster.id

CSV PriceStoreUpdate 2 (prices2.csv)

In this format, everything from the Vollexport has been omitted, which has nothing to do with prices and inventory. The format is available in the export. API retrieval is done with “prices2.csv”.

This update format includes ProductPriceInfo, ProductStock, SupplierItemPriceInfo and SupplierItemStock, ie the price and warehouse data are similar to “CSV all data 2 (zip)”.

ProductPriceInfo

see all CSV data 2 – Product Price Info

ProductStock

see all CSV data 2 – Product Stock

SupplierItemPriceInfo

see all CSV data 2 – SupplierItemPriceInfo

SupplierItemStock

see all CSV data 2 – Supplier Items Tock

CSV Reference Source List including PriceStockUpdate (sources.csv)

In this format, everything from the Vollexport has been omitted, which does not have to do with prices, stock and reference sources. The format is available in the export. API retrieval is done with “sources.csv”.

The update format includes ProductPriceInfo, ProductStock, SupplierItemPriceInfo, SupplierItemStock, and SupplierItem as “CSV all data 2 (zip)” for each product. This update format includes product price, stock data and all reference source data including the respective price and stock data.

ProductPriceInfo

see all CSV data 2 – Product Price Info

ProductStock

see all CSV data 2 – Product Stock

SupplierItemPriceInfo

see all CSV data 2 – SupplierItemPriceInfo

SupplierItemStock

see all CSV data 2 – Supplier Items Tock

SupplierItem

see all CSV data 2 – SupplierItem

Was this article helpful?
Dislike 0
Views: 137