{"id":2383,"date":"2020-09-24T12:49:09","date_gmt":"2020-09-24T12:49:09","guid":{"rendered":"https:\/\/support.itscope.hostpress.me\/?post_type=kb&p=2383"},"modified":"2025-10-01T19:40:59","modified_gmt":"2025-10-01T17:40:59","slug":"csv-xlsx-product-list-small-csv-small-xlsx-for-api-1-0","status":"publish","type":"kb","link":"https:\/\/guide.itscope.com\/en\/kb\/csv-xlsx-product-list-small-csv-small-xlsx-for-api-1-0\/","title":{"rendered":"CSV \/ XLSX product list (small.csv, small.xlsx) for API 1.0"},"content":{"rendered":"\n

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”.<\/p>\n\n\n\n

For the time being, only the most important and explanatory fields are described here.<\/p>\n\n\n\n

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

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 …<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"kbtopic":[178],"kbtag":[],"class_list":["post-2383","kb","type-kb","status-publish","hentry","kbtopic-api-1-0-en"],"_links":{"self":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/2383","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/comments?post=2383"}],"version-history":[{"count":4,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/2383\/revisions"}],"predecessor-version":[{"id":19377,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/2383\/revisions\/19377"}],"wp:attachment":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/media?parent=2383"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kbtopic?post=2383"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kbtag?post=2383"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}