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.

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.
  • SupplierItem: - Reference source of an ITscope product. A specific offer from an ITScope listed distributor.
  • Attribute: - Properties for a product.
  • 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
  • accessory: - Original accessories and compatible accessories to a product

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
manufacturerId Yes long Reference to the manufacturer of this product (n: 1 on Manufacturer.id)
manufacturerName   String (255) Name of the producer
productNameWithManufacturer Yes String Product name , including manufacturer name
shortDescription   String Kurzbezeichner the product
longDescription   String Long description of the product
productTypeId Yes long Reference to the product type of this product
productTypeGroupId Yes String (3) Reference to product type group (ProductTypeGroup.id, n: 1)
productTypeGroupName Yes String (255) Name of the group of product types, eg network technology. Can be used as 1st category level are used.
productTypeName 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
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 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
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 pricewas used
priceLastUpdate Yes Date Time of last update of price information
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
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
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
accessory   List <accessory> Original accessories and compatible accessories to a product

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
supplierId Yes long Refers 1: 1 to Supplier.id
supplierName   String (255) Name of Supplier
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
price Yes BigDecimal 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
stockSupplierText   String Stock information on the source of supply, as supplied by the supplier
stockStatus   Integer Numeric key of the delivery status of the inventory information
stockStatusText   String (255) Delivery status of inventory information , such as "in stock" or "outdoor storage"
floor   Integer stock quantity
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
lastStockUpdate   Date Time of last update of inventory information

attribute

Properties to a product.

name Compulsory field Data type description
displayValue   String (1024) The readable value of the property, including unit
attributeTypeId   long Unique identifier of a concrete property type
attributeTypeName   String (255) Name of the concrete property type
attributeTypeRank   long Ranking of the property type, for example, can be used for sorting
attributeTypeGroupId   long Identifier of a property group, no table reference, but uniquely identifies attributeTypeGroupName
attributeTypeGroupName   String (255) Name of the property group

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
productTypeName   String (255) Name of the product type to which this property belongs, optional
attributeTypeName   String (255) Name of a property. Can be the same as the name from ProductType.attributeTypeName (1..5)
attributeTypeGroupName   String (255) Name of a property group
name   String (255) Identifier of the design (eg 2 GB, 15 ", 80 W - 120 W)
rank   long Rank of the property

accessory

Original accessories and compatible accessories to a product

name Compulsory field Data type description
referencedProductId   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.

Database scripts for CSV



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

Have more questions? Submit a request