Read previously out the subject data formats and output formats to make sure that you will use this data format.

Database diagram

Abhängigkeitsdiagram the csv output format, including SQL scripts for generating the tables and to load the data with loadData local infile at the end of the contribution.

developercsv_20.png

Overview of data format elements

In csv output format, these elements are files, in xml or json output format it is nodes.

The data format standard consists of the following elements:

  • Product: - Product of the ITscope catalog.
  • Manufacturer: - manufacturer of a product.
  • ProductType: - Type of product, eg server, processor.
  • ProductTypeGroup: - Product Type Grouping.
  • ProductPriceInfo: - Calculated price information for a product. Is only present if from the supplier deposited within the platform pricing rules , a product may be selected and calculated.
  • ProductStockInfo: - Availability information of the source selected in productPriceInfo.
  • SupplierItem: - Reference source of an ITscope product. A specific offer from an ITScope listed distributor.
  • Supplier: - supplier of a reference source.
  • SupplierPriceInfo: - Price data for a reference source. For each configured price source, a PriceInfo is stored, eg Realtime, individual price list, generally available price list. For some vendors, no generally available prices are listed, here the supplierPriceInfo is empty, if no own price list has been configured.
  • SupplierStockInfo: - Availability information for the source of supply.
  • Attribute: - Properties for a product.
  • AttributeType: - Specific property types of product properties.
  • AttributeUnit: - Units of all concrete property types.
  • AttributeCluster: - Property clusters in which the product can be found for feature searches. Can summarize several property expressions according to the quantity in intervals, eg 64-128MB RAM
  • KeyContent: - Content data for a product in the form of keys (eg category IDs, tariff tariff numbers)
  • content model: - classification of content in different types by the content provider. ,
  • content providers: - origin of the content eg CNET, Icecat, Manufacturer, Distributor
  • MediaContent: - Images, data sheet links and other media such as videos of a product.
  • content category: - ITscope categorization of content (eg Structured feature articles, product photo, etc.).
  • contentTag: - Tags for content , uniform markings on content providers across.
  • RefContent: - Various product references for a product, eg original accessories, compatible accessories, similar products, follow-up products
  • TextContent: - Texts for the product, such as marketing texts, short texts, long texts, HTML descriptions.

Elements marked with  change their language depending on the selected export oder api request language.

 

Fields marked green are new in comparision to the API 2.0, fields marked orange have been moved to a different location within the file only.

product

Product of the ITscope catalog.

name Compulsory field Data type description
puid Yes long Unique key
ean   String (18) EAN
manufacturerSKU   String (40) Manufacturer's article number
icecatId   String (255) IceCat ID
cnetId   String (255) CNET ID
bechlemId   String (255) Bechlem ID
eClass   String (255) eClass ID Version 5.1.2
manufacturer Yes manufacturer Reference to the manufacturer of this product (n: 1 on Manufacturer.id)
productNameWithManufacturer Yes String Product name , including manufacturer name
shortDescription   String Kurzbezeichner the product
longDescription   String Long description of the product
productType Yes productType Reference to the product type of this product
attributeValue1   String (1024) Property value for the attribute from ProductType.attributeTypeId1. Can, if any, as a 3rd category level are used.
attributeValue2   String (1024) Property value for the attribute from ProductType.attributeTypeId2. Can, if any, as a 4th category level are used.
attributeValue3   String (1024) Property value for the attribute from ProductType.attributeTypeId3. Can, if any, as a 5th category level are used.
attributeValue4   String (1024) Property value for the attribute from ProductType.attributeTypeId4
attributeValue5   String (1024) Property value for the attribute from ProductType.attributeTypeId5
productSubTypeId   String (1024) ID of Construction Property
productSubType   String (1024) Design property of the product, eg mouse or keyboard for input devices. If not as a 3rd category level are used.
productLineId   long ID of the product line
productLine   String (1024) Product line
productModel   String (1024) Product model identifier
estimateGrossWeight   Double Weight in kilograms
largeDimX   String (1024) Length of the product including unit of measurement
largeDimY   String (1024) Height of the product including unit of measurement
largeDimZ   String (1024) Width of product including unit of measurement
customsTariffNumber   String (255) Customs tariff number
deeplink Yes String (2048) Deeplink on the ITscope.com platform
standardHtmlDatasheet Yes String (2048) URL, link to HTML standard data sheet
standardPdfDatasheet   String (2048) URL, link to PDF standard data sheet
manufacturerSite   String (255) URL, link to manufacturer page
manufacturerDatasheet   String (1024) URL, link to manufacturer data sheet
imageThumb   String (1024) Preview of the best product image
imageThumbWidth   Integer Width of the image medium in pixels
imageThumbHeight   Integer Height of the image medium in pixels
image1   String (1024) Link to the best possible image , in the largest version
imageWidth1   Integer Width of the image medium in pixels
imageHeight1   Integer Height of the image medium in pixels
image2   String (1024) Link on another good product image , the preferred product packaging (never the same as the first image)
imageWidth2   Integer Width of the image medium in pixels
imageHeight2   Integer Height of the image medium in pixels
image3   String (1024) Link to the first image in the gallery (never one of the already listed)
imageWidth3   Integer Width of the image medium in pixels
imageHeight3   Integer Height of the image medium in pixels
image4   String (1024) Link to second picture in the gallery (never one of the already listed)
imageWidth4   Integer Width of the image medium in pixels
imageHeight4   Integer Height of the image medium in pixels
image5   String (1024) Link to third image in the gallery (never one of the already listed)
imageWidth5   Integer Width of the image medium in pixels
imageHeight5   Integer Height of the image medium in pixels
energyLabel   String (1024) Link to the Energy Label image
entryDate Yes Date When is the product on the platform
rank   Integer Overall popularity rank (rank 1 to n, a high number corresponds to a bad ranking)
qualification   Integer Qualification of the product
warrantyText   String Warranty text of the product
marketingText   String Marketing text for product
htmlSpecs   String Technical characteristics of the product, in HTML format
recommendedRetailPriceNet   Double Manufacturer's UVP
productPriceInfo   productPriceInfo Calculated price information for a product. Is only present if from the supplier deposited within the platform pricing rules , a product may be selected and calculated.
productStockInfo   productStockInfo Availability information of the source selected in productPriceInfo.
aggregatedStatus Yes Integer Best availability status
aggregatedStatusText Yes String (20) Best availability status
aggregatedStock Yes Integer Total of all inventories
aggregatedSupplierItems Yes Integer Sum of all distributors to this product
supplierItem Yes List <supplierItem> Reference source of an ITscope product. A specific offer from an ITScope listed distributor.
attribute   List <attribute> Properties to a product.
attributeCluster   List <attributeCluster> Property clusters in which the product can be found for feature searches. Can summarize several property expressions according to the quantity in intervals, eg 64-128MB RAM
keyContent   List <keyContent> Content data for a product that is in the form of keys (eg category IDs, customs tariff numbers)
mediaContent   List <mediaContent> Images, data sheet links, and other media, such as videos to a product.
refContent   List <refContent> Various product references for a product, eg original accessories, compatible accessories, similar products, follow-up products
textContent   List <textContent> Texts on the product, such as marketing texts, short texts, long texts, HTML descriptions.

manufacturer

Manufacturer of a product.

name Compulsory field Data type description
id Yes long Unique key
name Yes String (255) Identifier of the manufacturer
shortName Yes String (255) Manufacturer's nickname
deeplink Yes String (2048) URL, link to the manufacturer within the ITscope platform

productType

Type of a product, eg server, processor.

name Compulsory field Data type description
id Yes long Unique key
productTypeGroup Yes ProductTypeGroup (3) Reference to product type group (ProductTypeGroup.id, n: 1)
name Yes String (255) Identifier of the product type. Can be used as 2nd category level are used.
attributeTypeId1   long Unambiguous Attribute Key to build a possible subcategory points to 1: n on AttributeCluster.attributeTypeId
attributeTypeName1   String (255) Identifier of the attribute to build up a possible subcategory
attributeTypeId2   long Unambiguous Attribute Key to build a possible subcategory points to 1: n on AttributeCluster.attributeTypeId
attributeTypeName2   String (255) Identifier of the attribute to build up a possible subcategory
attributeTypeId3   long Unambiguous Attribute Key to build a possible subcategory points to 1: n on AttributeCluster.attributeTypeId
attributeTypeName3   String (255) Identifier of the attribute to build up a possible subcategory
attributeTypeId4   long Unambiguous Attribute Key to build a possible subcategory points to 1: n on AttributeCluster.attributeTypeId
attributeTypeName4   String (255) Identifier of the attribute to build up a possible subcategory
attributeTypeId5   long Unambiguous Attribute Key to build a possible subcategory points to 1: n on AttributeCluster.attributeTypeId
attributeTypeName5   String (255) Identifier of the attribute to build up a possible subcategory

productTypeGroup

Product type grouping.

name Compulsory field Data type description
id Yes String (3) Unique key
name Yes String (255) Name of the group of product types, eg network technology. Can be used as 1st category level are used.

productPriceInfo

Calculated price information for a product. Is only present if from the supplier deposited within the platform pricing rules , a product may be selected and calculated.

name Compulsory field Data type description
price Yes BigDecimal Price based on the closing price
priceCalc Yes BigDecimal Calculated price, based on the individual pricing
currencyCode Yes String (3) Currency unit that applies to this price information
priceCalcVat Yes BigDecimal Sales tax rate to calculate the calculated price was used
priceLastUpdate Yes Date Time of last update of price information
minScale Yes Integer Price from season
priceSourceId Yes Integer Identifier for the source of price information
priceSourceName   String (255) Readable text on the origin of the price information, eg "Individual price list"
priceStatus Yes String (255) Textual information on price retrieval, eg "The retrieval of the data was successful"
in the present circumstancesHier, an Yes long Reference to a supplier (1: 1) who has provided the source with this price information
priceSupplierName Yes String (255) Name of the supplier who provided this reference source
priceSupplierItemId Yes long Reference to a reference source (n: 1); If this field is zero, the price information refers to a product (reference source reference and product reference are mutually exclusive)
in the present circumstancesHier, an Yes String (40) Product identifier of the supplier who provided this reference source

productStockInfo

Availability information of the source selected in productPriceInfo.

name Compulsory field Data type description
stockSupplierText   String (40) Textual inventory information of the supplier, directly taken over, without interpretation
stockStatus Yes Integer Numeric key of the delivery status of the inventory information
stockStatusText Yes String (255) Delivery status of inventory information , such as "in stock" or "outdoor storage"
floor Yes Integer Quantity of the delivery status indicated in this structure
externalStock   Integer External stock in stock (additional information from suppliers in structures of delivery status "in stock")
incomingStock   Integer Quantity in stock (additional information from some suppliers in delivery status "in stock")
stockAvailabilityDate   Date Delivery date for goods not in stock
stockLastUpdate Yes Date Time of last update of inventory information
stockSourceId Yes Integer Numeric key of the source of asset information
stockSourceName Yes String (255) Source of stock information , eg "Individual price list"
stockUnlimited Yes Boolean Indicates whether the goods of this stock information are available in an unlimited quantity

supplierItem

Reference source of an ITscope product. A specific offer from an ITScope listed distributor.

name Compulsory field Data type description
id Yes long Unique key
ean   String (18) EAN specification of the supplier
manufacturerSKU   String (40) Supplier's part number (does not have to match ITscope)
supplierSKU   String (40) Product number of the supplier
supplier Yes supplier Refers 1: 1 to Supplier.id
manufacturerName   String (80) Manufacturer name as specified by supplier
productName   String (255) Exact identifier of the article, as supplied by the supplier
longDescription   String (60000) Extended supplier description
conditionId Yes Integer Numeric Code of the state of the article
conditionName Yes String (255) Condition of the item (new, used, B-Stock, Refurbished, etc.)
eolProduct Yes Boolean Identification: Discontinued
matchQuality Yes Integer Mapping quality of the article for ITscope product catalog
eanValid Yes Boolean Flag, whether the EAN of the vendor is valid according to the EAN criteria
specialOffer Yes Boolean Flag whether item is special offer
promotion   String (40) Name of the promotion activity of the supplier
v   Integer VAT rate for the item
copyrightLevy   Double copyright
customsTariffNumber   String (50) Customs tariff number
countryOfOrigin   String (20) Country of origin of the article
largeDimX   Double Length of the product including unit of measurement
largeDimY   Double Height of the product including unit of measurement
largeDimZ   Double Width of product including unit of measurement
warrantyText   String (40) Supplier's warranty
deeplink   String (255) Link to the article at the supplier
recommendedRetailPriceNet   Double UVP-indication of the supplier
supplierPriceInfo   List <supplierPriceInfo> Price data to a reference source. For each configured price source, a PriceInfo is stored, eg Realtime, individual price list, generally available price list. For some vendors, no generally available prices are listed, here the supplierPriceInfo is empty, if no own price list has been configured.
supplierStockInfo   List <supplierStockInfo> Availability information of the source of supply.

supplier

Supplier of a reference source.

name Compulsory field Data type description
id Yes long Unique key
name Yes String (255) Identifier of the supplier
deeplink Yes String (2048) URL, link to the supplier within the ITscope platform
customerAccountNumber   String (255) Customer number in case of partnership. Can be used as a filter to determine if there is a partnership with this supplier

supplierPriceInfo

Price data to a reference source. For each configured price source, a PriceInfo is stored, eg Realtime, individual price list, generally available price list. For some vendors, no generally available prices are listed, here the supplierPriceInfo is empty, if no own price list has been configured.

name Compulsory field Data type description
price Yes BigDecimal Price based on the closing price
priceCalc Yes BigDecimal Calculated price, based on the individual pricing
currencyCode Yes String (3) Currency unit that applies to this price information
priceCalcVat Yes BigDecimal Sales tax rate to calculate the calculated price was used
priceLastUpdate Yes Date Time of last update of price information
minScale Yes Integer Price from season
priceSourceId Yes Integer Identifier for the source of price information
priceSourceName   String (255) Readable text on the origin of the price information, eg "Individual price list"
priceStatus Yes String (255) Textual information on price retrieval, eg "The retrieval of the data was successful"

supplierStockInfo

Availability information of the source of supply.

name Compulsory field Data type description
stockSupplierText   String (40) Textual inventory information of the supplier, directly taken over, without interpretation
stockStatus Yes Integer Numeric key of the delivery status of the inventory information
stockStatusText Yes String (255) Delivery status of inventory information , such as "in stock" or "outdoor storage"
floor Yes Integer Quantity of the delivery status indicated in this structure
externalStock   Integer External stock in stock (additional information from suppliers in structures of delivery status "in stock")
incomingStock   Integer Quantity in stock (additional information from some suppliers in delivery status "in stock")
stockAvailabilityDate   Date Delivery date for goods not in stock
stockLastUpdate Yes Date Time of last update of inventory information
stockSourceId Yes Integer Numeric key of the source of asset information
stockSourceName Yes String (255) Source of stock information , eg "Individual price list"
stockUnlimited Yes Boolean Indicates whether the goods of this stock information are available in an unlimited quantity

attribute

Properties to a product.

name Compulsory field Data type description
value   String (10000) The base value (see also the base unit ) of the property, in text as boilerplate in numbers as the smallest indication
displayValue   String (10000) The readable value of the property, including unit
qualification   long Qualification of the property
attributeType   attributeType Unique identifier of a concrete property type

attributeType

Specific property types of product properties.

name Compulsory field Data type description
id   long Unique identifier of a concrete property type
name   String (255) Name of the concrete property type
rank   long Ranking of the property type, for example, can be used for sorting
type   Integer Data type of the property type
attributeUnit   attributeUnit Reference to table attributeUnits
groupId   long Identifier of a property group, no table reference, but uniquely identifies attributeTypeGroupName
groupName   String (255) Name of the property group

attributeUnit

Units of all concrete property types.

name Compulsory field Data type description
id   String (100) Unique identifier of a unit
baseUnitId   String (100) The base unit of the unit
mFactor   long Multiplication factor for the conversion of the base unit to unit
divFactor   long Divisor for the conversion of the base unit to unit

attributeCluster

Property clusters in which the product can be found for feature searches. Can summarize several property expressions according to the quantity in intervals, eg 64-128MB RAM

name Compulsory field Data type description
id   long Unique ITscope Key
productTypeId   long Reference to the product type, optional
name   String (255) Identifier of the design (eg 2 GB, 15 ", 80 W - 120 W)
min   String (255) Mininimal limit with respect to a property in which the expression of the product must fall in order to be assigned to this attribute cluster
Max   String (255) Maximum limit with respect to a property in which the value of the product must fall in order to be assigned to this attribute cluster
rank   long Rank of the property
attributeTypeId   long Identifies a property and identifies attributeTypeName, attributeTypeRank, and attributeTypeUnit. No table reference. Refer to: ProductType.attributeTypeId (1..5)
attributeTypeName   String (255) Name of a property. Can be the same as the name from ProductType.attributeTypeName (1..5)
attributeTypeRank   long Ranking of the property, for example, can be used for sorting
attributeTypeUnit   String (100) Unit of the property
attributeTypeGroupId   String (20) Identifier of a property group, no table reference, but uniquely identifies attributeTypeGroupName
attributeTypeGroupName   String (255) Name of a property group

keyContent

Content data for a product that is in the form of keys (eg category IDs, customs tariff numbers)

name Compulsory field Data type description
key   long Key of the record, not unique
longId   long Internal identifier of the language into which the application of this content
contentModel   contentModel Reference to the type of content (ContentModel.id, n: 1)
contentProvider   contentProvider Reference to the content provider (ContentProvider.id, n: 1)
contentCategory   contentCategory Reference to the content category (ContentCategory.id, n: 1)
value   String (255) Content of the content (value of the key)
long   String (10) Language code in ISO639, where this content is available

contentModel

Classification of content in different types by the content provider. ,

name Compulsory field Data type description
id   long Unique key
name   String (1023) Display name of the content (eg ICEcat standard image large, CNET product ID)

contentProvider

Origin of the content eg CNET, Icecat, Manufacturer, Distributor

name Compulsory field Data type description
id   long Unique key
name   String (255) Clear text name of the content supplier (eg Icecat, CNET)
rank   Integer Prioritization, for sorting, same values ​​are possible several times

mediaContent

Images, data sheet links, and other media, such as videos to a product.

name Compulsory field Data type description
key   long Key of the record, not unique
longId   long Language identifier , suitable for long field, but does not reference a table
contentModel   contentModel Reference to the type of content (ContentModel.id, n: 1)
contentProvider   contentProvider Reference to the content provider (ContentProvider.id, n: 1)
contentCategory   contentCategory Reference to the content category (ContentCategory.id, n: 1)
contentTag   List (60) Comma separated list of tags, refer to ContentTag.id
value   String (1024) Content of the content (value of the medium)
long   String (10) Language code in ISO639
mimeType   String (255) MIME Type of content (eg image / jpeg, text / html)
imageWidth   Integer Width of the image medium in pixels
imageHeight   Integer Height of the image medium in pixels

contentCategory

ITscope categorization of content (eg Structured feature articles, product photo, etc.).

name Compulsory field Data type description
id   long Unique key
name   String (255) Identifier of category

contentTag

Tags for content , uniform markings on content providers across.

name Compulsory field Data type description
id   long Unique key
name   String (40) Identifier for the content type (small picture, thumbnail, marketing text)
rank   Integer Prioritization, for sorting, same values ​​are possible several times
source   String (10) "Itscope" when ITscope's tag was entered, "supplier" for tags automatically generated from read-in data

refContent

Various product references for a product, eg original accessories, compatible accessories, similar products, successor products

name Compulsory field Data type description
key   long Key of the record, not unique
contentModel   contentModel Reference to the type of content (ContentModel.id, n: 1)
contentProvider   contentProvider Reference to the content provider (ContentProvider.id, n: 1)
crossProductRefId   long Reference to a reference product, eg a product which is managed as original accessory
typeId   Integer Internal identifier for the type of the reference product
type   String (255) Identifier for the type of the reference product , including original accessories, all compatible accessories, etc.

textContent

Texts on the product, such as marketing texts, short texts, long texts, HTML descriptions.

name Compulsory field Data type description
key   long Key of the record, not unique
longId   long Language identifier , suitable for long field, but does not reference a table
contentModel   contentModel Reference to the type of content (ContentModel.id, n: 1)
contentProvider   contentProvider Reference to the content provider (ContentProvider.id, n: 1)
contentCategory   contentCategory Reference to the content category (ContentCategory.id, n: 1)
contentTag   List (60) Comma-separated list of tags, refer to ContentTag.id
value   String Content of the content (product texts)
long   String (10) Language code in ISO639
mimeType   String (255) MIME Type of content (eg plain / text, text / html)

Database scripts for CSV

Note: This page has been translated with the Google Translation Service.

Have more questions? Submit a request