CSV / XLSX product list (small.csv, small.xlsx) for API 1.0

Last modified: 2. September 2022

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.

FieldData typeDescription
PuidLongUnique product ID (ITscope ID)
ShortInfotextShort identifier
ProductNameStringProduct name, long name
EanString (20)EAN
ManufacturerSKUString (40)Manufacturer’s article number
RankIntegerGeneral ranking (a high number corresponds to a bad ranking)
RelevanceDoubleSearch result relevance
BestImageLinkStringURL, link the best product picture
DeeplinkStringURL, link to the product on the ITscope platform
ManufacturerSiteStringURL, link to the manufacturer page
EntryDateDateDate on which the product was first listed
BestDescriptiontextBest product description
EstimateGrossWeightDoubleWeight
vatDoubleValue added tax
LargeDimXStringLength of the product
LargeDimYStringHeight of the product
LargeDimZStringWidth of the product
QualificationIntegerQualification of the product
AggregatedStatusIntegerBest availability status
AggregatedStatusTextStringBest readable availability status
AggregatedStockIntegerTotal of all inventories
AggregatedSupplierItemsIntegerSum of all distributors for this product
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)Type of product
ProductLineString (2000)Product line
ProductModelString (2000)Product model
SetGroup_idStringIdentifier of the product type group to which this product belongs, unique ID to SetGroup-name
SetGroup_nameStringName of the set group
Set_idLongIdentifier of the product type to which the product belongs, unique ID to set_name
Set_nameStringName of the product type
Set_attributeTypeId1LongUnique attribute key to build a possible subcategory, 1: n points to AttributeCluster.attributeTypeId
Set_attributeTypeName1StringIdentifier of the attribute to build up a possible subcategory
Set_attributeTypeId2LongUnique attribute key to build a possible subcategory, 1: n points to AttributeCluster.attributeTypeId
Set_attributeTypeName2StringIdentifier of the attribute to build up a possible subcategory
Set_attributeTypeId3LongUnique attribute key to build a possible subcategory, 1: n points to AttributeCluster.attributeTypeId
Set_attributeTypeName3StringIdentifier of the attribute to build up a possible subcategory
Set_attributeTypeId4LongUnique attribute key to build a possible subcategory, 1: n points to AttributeCluster.attributeTypeId
Set_attributeTypeName4StringIdentifier of the attribute to build up a possible subcategory
Set_attributeTypeId5LongUnique attribute key to build a possible subcategory, 1: n points to AttributeCluster.attributeTypeId
Set_attributeTypeName5StringIdentifier of the attribute to build up a possible subcategory
Manufacturer_idLongUnique identifier of the manufacturer of this product, unique ID to Manufacturer.name
Manufacturer_nameStringName manufacturer
MINPriceInfo_priceDoubleThe lowest price found for the product
MINPriceInfo_typeStringType of price
MINPriceInfo_priceSourceIdIntegerIdentifier for the origin of the price and stock information (refers to priceSourceName)
MINPriceInfo_priceSourceNameStringReadable text for the origin of the stock information (General Price List, individual rate, realtime polling)
MINPriceInfo_lastUpdateDatePrice date
MINPriceInfo_supRefIdLongUnique identification of the supplier
MINPriceInfo_SuppliernameStringName of Supplier
MINPriceInfo_supplierItemIdString (40)Product number of the supplier
MINPriceInfo_SupplierItemstockIntegerStock in this reference source
MINPriceInfo_SupplierItemstockStatusIntegerIdentifier for the origin of the stock information (relating to Supplier Items Tock status text)
MINPriceInfo_SupplierItemstockStatusTextStringReadable inventory status
MINPriceInfo_SupplierItemdescriptiontextDescription of the supplier
MAXPriceInfo_priceDoubleThe maximum price found for the product
MAXPriceInfo_typeStringType of price
MAXPriceInfo_priceSourceIdIntegerIdentifier for the origin of the stock information (relating to price source name)
MAXPriceInfo_priceSourceNameStringReadable text for the origin of the stock information (General Price List, individual rate, realtime polling)
MAXPriceInfo_lastUpdateDatePrice date
MAXPriceInfo_supRefIdLongUnique identification of the supplier
MAXPriceInfo_SuppliernameStringName of supplier
MAXPriceInfo_supplierItemIdString (40)Product number of the supplier
MAXPriceInfo_SupplierItemstockIntegerStock in this reference source
MAXPriceInfo_SupplierItemStatusIntegerIdentifier for the origin of the stock information (relating to Supplier Items Tock status text)
MAXPriceInfo_SupplierItemstockStatusTextStringReadable inventory status
MAXPriceInfo_SupplierItemdescriptiontextDescription of the supplier
Was this article helpful?
Dislike 0
Views: 53