This format contains selected product data. A single wide table contains one line per product. References were resolved and written into this product line. The format is available in the export. API retrieval is done with "small.csv" or "small.xlsx".

For the time being, only the most important and explanatory fields are described here.

field Data type description
Puid Long Unique product ID (ITscope ID)
ShortInfo text Short identifier
ProductName String Product name, long name
Ean String (20) EAN
ManufacturerSKU String (40) Manufacturer's article number
Rank Integer General popularity (a high number corresponds to a bad ranking)
Relevance Double Addiction relevance
BestImageLink String URL, link the best product picture
Deeplink String URL, link to the product in the ITscope platform
ManufacturerSite String URL, link to the manufacturer page
EntryDate Date Date on which the product was created
BestDescription text Best product description
EstimateGrossWeight Double weight
vat Double More fire control
LargeDimX String Length of the product
LargeDimY String Height of the product
LargeDimZ String Width of the product
Qualification Integer Qualification of the product
AggregatedStatus Integer Best availability status
AggregatedStatusText String Best readable availability status
AggregatedStock Integer Total of all inventories
AggregatedSupplierItems Integer Sum of all distributors to this product
FeatureAttribute1 String (2000) Property value for the attributes from Set.attributeTypeId1
FeatureAttribute2 String (2000) Property value for the attributes from Set.attributeTypeId2
FeatureAttribute3 String (2000) Property value for the attributes from Set.attributeTypeId3
FeatureAttribute4 String (2000) Property value for the attributes from Set.attributeTypeId4
FeatureAttribute5 String (2000) Property value for the attributes from Set.attributeTypeId5
ProductType String (2000) Construction property
ProductLine String (2000) Product line
ProductModel String (2000) Product model
SetGroup_id String Identifier of the product type group to which this product belongs, unique ID to SetGroup-name
SetGroup_name String Name of the set group
Set_id Long Identifier of the product type to which the product belongs, unique ID to set-name
Set_name String Name of the product type
Set_attributeTypeId1 Long Unique attribute key to build a possible subcategory, 1: n points to AttributeCluster.attributeTypeId
Set_attributeTypeName1 String Identifier of the attribute to build up a possible subcategory
Set_attributeTypeId2 Long Unique attribute key to build a possible subcategory, 1: n points to AttributeCluster.attributeTypeId
Set_attributeTypeName2 String Identifier of the attribute to build up a possible subcategory
Set_attributeTypeId3 Long Unique attribute key to build a possible subcategory, 1: n points to AttributeCluster.attributeTypeId
Set_attributeTypeName3 String Identifier of the attribute to build up a possible subcategory
Set_attributeTypeId4 Long Unique attribute key to build a possible subcategory, 1: n points to AttributeCluster.attributeTypeId
Set_attributeTypeName4 String Identifier of the attribute to build up a possible subcategory
Set_attributeTypeId5 Long Unique attribute key to build a possible subcategory, 1: n points to AttributeCluster.attributeTypeId
Set_attributeTypeName5 String Identifier of the attribute to build up a possible subcategory
Manufacturer_id Long Unique identifier of the manufacturer of this product, unique ID to Manufacturer.name
Manufacturer_name String Name manufacturer
MINPriceInfo_price Double The lowest price found for the product
MINPriceInfo_type String Type of price
MINPriceInfo_priceSourceId Integer Identifier for the origin of the price and stock information (refers to priceSourceName)
MINPriceInfo_priceSourceName String readable text for the origin of the stock information (General Price List, individual rate, real-time polling)
MINPriceInfo_lastUpdate Date Price date
MINPriceInfo_supRefId Long Unique identification of the supplier
MINPriceInfo_Suppliername String Name of Supplier
MINPriceInfo_supplierItemId String (40) Product number of the supplier
MINPriceInfo_SupplierItemstock Integer Stock in this reference source
MINPriceInfo_SupplierItemstockStatus Integer Identifier for the origin of the stock information (relating to Supplier Items Tock status text)
MINPriceInfo_SupplierItemstockStatusText String Readable inventory status
MINPriceInfo_SupplierItemdescription text Description of the supplier
MAXPriceInfo_price Double The maximum price found for the product
MAXPriceInfo_type String Type of price
MAXPriceInfo_priceSourceId Integer Identifier for the origin of the stock information (relating to price source name)
MAXPriceInfo_priceSourceName String readable text for the origin of the stock information (General Price List, individual rate, real-time polling)
MAXPriceInfo_lastUpdate Date Price date
MAXPriceInfo_supRefId Long Unique identification of the supplier
MAXPriceInfo_Suppliername String Name of Supplier
MAXPriceInfo_supplierItemId String (40) Product number of the supplier
MAXPriceInfo_SupplierItemstock Integer Stock in this reference source
MAXPriceInfo_SupplierItemStatus Integer Identifier for the origin of the stock information (relating to Supplier Items Tock status text)
MAXPriceInfo_SupplierItemstockStatusText String Readable inventory status
MAXPriceInfo_SupplierItemdescription text Description of the supplier

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

Have more questions? Submit a request