{"id":2335,"date":"2020-09-24T12:11:26","date_gmt":"2020-09-24T12:11:26","guid":{"rendered":"https:\/\/support.itscope.hostpress.me\/?post_type=kb&#038;p=2335"},"modified":"2025-12-19T10:57:41","modified_gmt":"2025-12-19T08:57:41","slug":"format-description-for-products-data-format-standard","status":"publish","type":"kb","link":"https:\/\/guide.itscope.com\/en\/kb\/format-description-for-products-data-format-standard\/","title":{"rendered":"Format description for products data format standard"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"1\">Database diagram<\/h2>\n\n\n\n<p>Dependency diagram for the CSV output format, including SQL scripts for generating the tables and to load the data with loadData local infile at the end of this article.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"457\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/grafik-28-1024x457.png\" alt=\"\" class=\"wp-image-18631\" srcset=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/grafik-28-1024x457.png 1024w, https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/grafik-28-300x134.png 300w, https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/grafik-28-768x343.png 768w, https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/grafik-28-1536x686.png 1536w, https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/grafik-28.png 1632w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"2\">Overview of data format elements<\/h2>\n\n\n\n<p>In CSV output format, these elements are files, in XML or JSON output format they are nodes.<\/p>\n\n\n\n<p>The data format standard consists of the following elements:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>product: product from the ITscope catalogue<\/li>\n\n\n\n<li>supplierItem: source of supply of an ITscope product. A specific offer from a distributor listed on ITscope<\/li>\n\n\n\n<li>project: price, availability and further information&nbsp;on a project agreement<\/li>\n\n\n\n<li>attribute: properties for a product<\/li>\n\n\n\n<li>attributeCluster: property clusters using which the product can be found for feature searches. Can summarise several property expressions according to the quantity in intervals, e.g. 64-128 MB RAM<\/li>\n\n\n\n<li>accessory: <a href=\"https:\/\/guide.itscope.com\/en\/kb\/accessory-types\/\">original accessories and compatible accessories<\/a> for a product<\/li>\n<\/ul>\n\n\n\n<p>Elements marked with a globe&nbsp;change their language depending on the selected export oder API request language:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><a href=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" class=\"wp-image-1537\" style=\"width:45px;height:45px\"\/><\/a><\/figure>\n\n\n<div class=\"mkb-shortcode-container\">        <div class=\"mkb-info\">\n            <div class=\"mkb-info__icon\">\n                <i class=\"fa fa-info-circle fa-lg\"><\/i>\n            <\/div>\n            <div class=\"mkb-info__content\">\n                Fields marked with a<strong> * are new <\/strong>compared to the API 2.0, fields with a <strong>** have been moved to a different location within the file, <\/strong>fields with a <strong>*** have been renamed.<\/strong>            <\/div>\n        <\/div>\n        <\/div>\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"3\">product<\/h2>\n\n\n\n<p>Product from the ITscope catalogue.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Name<\/th><th>Mandatory<\/th><th>Data type<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td>puid<\/td><td>Yes<\/td><td>long<\/td><td>Unique key<\/td><\/tr><tr><td>ean<\/td><td>&nbsp;<\/td><td>String (18)<\/td><td>EAN<\/td><\/tr><tr><td>manufacturerSKU<\/td><td>&nbsp;<\/td><td>String (150)<\/td><td>Manufacturer&#8217;s SKU\/article number [was String(40) before 18\/10\/2021] <\/td><\/tr><tr><td>icecatId<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Icecat ID<\/td><\/tr><tr><td>cnetId<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>1WorldSync ID (formerly CNET)<\/td><\/tr><tr><td>bechlemId<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Bechlem ID<\/td><\/tr><tr><td>eClass<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>eClass ID Version 5.1.2<\/td><\/tr><tr><td>eClassV7 *<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>eClass ID Version 7.0<\/td><\/tr><tr><td>customsTariffNumber *<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Customs tariff number<\/td><\/tr><tr><td>UNSPSC *<\/td><td>&nbsp;<\/td><td>String (14)<\/td><td>UNSPSC Classification Code<\/td><\/tr><tr><td>manufacturerId<\/td><td>Yes<\/td><td>Long<\/td><td>Reference to the manufacturer of this product (n:1 to Manufacturer.id)<\/td><\/tr><tr><td>manufacturerName<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Name of the manufacturer<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> productName ***<\/td><td>Yes<\/td><td>String<\/td><td><meta charset=\"utf-8\"><a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-descriptions-and-product-texts\/\">Product identifier<\/a>, by default including manufacturer name, removal of manufacturer name can <strong>only<\/strong> be <a href=\"https:\/\/guide.itscope.com\/en\/kb\/setting-up-a-data-export\/\">configured via export<\/a><\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> shortDescription<\/td><td>&nbsp;<\/td><td>String<\/td><td>By default the <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-descriptions-and-product-texts\/\">short name<\/a> of the product, but can <strong>only<\/strong> be additionally <a href=\"https:\/\/guide.itscope.com\/en\/kb\/setting-up-a-data-export\/\">configured via the export<\/a><\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> longDescription<\/td><td>&nbsp;<\/td><td>String<\/td><td><a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-descriptions-and-product-texts\/\">Long description text<\/a> for the product<\/td><\/tr><tr><td>productTypeId<\/td><td>Yes<\/td><td>Long<\/td><td>Reference to the product type of this product<\/td><\/tr><tr><td>productTypeGroupId<\/td><td>Yes<\/td><td>String (3)<\/td><td>Reference to product type group (ProductTypeGroup.id, n: 1)<\/td><\/tr><tr><td>productTypeGroupName<\/td><td>Yes<\/td><td>String (255)<\/td><td>Name of the group of product types, e.g. network technology. Can be used as 1st <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-categories\/\">category level<\/a><\/td><\/tr><tr><td>productTypeName<\/td><td>Yes<\/td><td>String (255)<\/td><td>Identifier of the product type. Can be used as 2nd <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-categories\/\">category level<\/a><\/td><\/tr><tr><td>attributeTypeId1<\/td><td>&nbsp;<\/td><td>Long<\/td><td>Unambiguous attribute key to build a possible subcategory, points 1:n to AttributeCluster.attributeTypeId<\/td><\/tr><tr><td>attributeTypeName1<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Identifier of the attribute to build up a possible subcategory<\/td><\/tr><tr><td>attributeTypeId2<\/td><td>&nbsp;<\/td><td>Long<\/td><td><meta charset=\"utf-8\">Unambiguous attribute key to build a possible subcategory, points 1:n to AttributeCluster.attributeTypeId<\/td><\/tr><tr><td>attributeTypeName2<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Identifier of the attribute to build up a possible subcategory<\/td><\/tr><tr><td>attributeTypeId3<\/td><td>&nbsp;<\/td><td>Long<\/td><td><meta charset=\"utf-8\">Unambiguous attribute key to build a possible subcategory, points 1:n to AttributeCluster.attributeTypeId<\/td><\/tr><tr><td>attributeTypeName3<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Identifier of the attribute to build up a possible subcategory<\/td><\/tr><tr><td>attributeTypeId4<\/td><td>&nbsp;<\/td><td>Long<\/td><td><meta charset=\"utf-8\">Unambiguous attribute key to build a possible subcategory, points 1:n to AttributeCluster.attributeTypeId<\/td><\/tr><tr><td>attributeTypeName4<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Identifier of the attribute to build up a possible subcategory<\/td><\/tr><tr><td>attributeTypeId5<\/td><td>&nbsp;<\/td><td>Long<\/td><td><meta charset=\"utf-8\">Unambiguous attribute key to build a possible subcategory, points 1:n to AttributeCluster.attributeTypeId<\/td><\/tr><tr><td>attributeTypeName5<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Identifier of the attribute to build up a possible subcategory<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> attributeValue1<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Attribute cluster value for the attribute from ProductType.attributeTypeId1. Can be used as 3rd <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-categories\/\">category level<\/a> if available<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> attributeValue2<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td><meta charset=\"utf-8\">Attribute cluster value for the attribute from ProductType.attributeTypeId1. Can be used as 4th <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-categories\/\">category level<\/a> if available<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> attributeValue3<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td><meta charset=\"utf-8\">Attribute cluster value for the attribute from ProductType.attributeTypeId1. Can be used as 5th <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-categories\/\">category level<\/a> if available<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> attributeValue4<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Attribute cluster value for the attribute from ProductType.attributeTypeId4<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> attributeValue5<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Attribute cluster value for the attribute from ProductType.attributeTypeId5<\/td><\/tr><tr><td>productSubTypeId<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>ID of the product sub type<\/td><\/tr><tr><td>productSubType<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Product sub type, e.g. mouse or keyboard for input devices. Should&nbsp;<strong>not<\/strong>&nbsp;be used as 3rd <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-categories\/\">category level<\/a><\/td><\/tr><tr><td>productLineId<\/td><td>&nbsp;<\/td><td>Long<\/td><td>ID of the product line<\/td><\/tr><tr><td>productLine<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Product line<\/td><\/tr><tr><td>productModel<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Product model identifier<\/td><\/tr><tr><td>colorFamilyId *<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>ID of the colour family<\/td><\/tr><tr><td>colorFamily *<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Colour family<\/td><\/tr><tr><td>estimateGrossWeight<\/td><td>&nbsp;<\/td><td>Double<\/td><td>Weight in kilograms<\/td><\/tr><tr><td>grossDimX<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Length of the product including unit of measurement<\/td><\/tr><tr><td>grossDimY<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Height of the product including unit of measurement<\/td><\/tr><tr><td>grossDimZ<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Width of product including unit of measurement<\/td><\/tr><tr><td>combinedLengthAndGirth *<\/td><td>&nbsp;<\/td><td>String (36)<\/td><td>Girth<\/td><\/tr><tr><td>netWeight *<\/td><td>&nbsp;<\/td><td>String (36)<\/td><td>Net weight<\/td><\/tr><tr><td>netDimX *<\/td><td>&nbsp;<\/td><td>String (36)<\/td><td>Net dimension X<\/td><\/tr><tr><td>netDimY *<\/td><td>&nbsp;<\/td><td>String (36)<\/td><td>Net dimension Y<\/td><\/tr><tr><td>netDimZ *<\/td><td>&nbsp;<\/td><td>String (36)<\/td><td>Net dimension Z<\/td><\/tr><tr><td>valueAddedTaxGermany *<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>German VAT rate<\/td><\/tr><tr><td>deeplink<\/td><td>Yes<\/td><td>String (2048)<\/td><td>Deeplink to the ITscope.com platform<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> standardHtmlDatasheet<\/td><td>Yes<\/td><td>String (2048)<\/td><td>URL, link to HTML standard datasheet<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> standardPdfDatasheet<\/td><td>&nbsp;<\/td><td>String (2048)<\/td><td>URL, link to PDF standard datasheet<\/td><\/tr><tr><td>manufacturerSite<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>URL, link to manufacturer page<\/td><\/tr><tr><td>manufacturerDatasheet<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>URL, link to manufacturer datasheet<\/td><\/tr><tr><td>imageThumb<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Preview of the best <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-pictures\/\">product image<\/a> (thumbnail)<\/td><\/tr><tr><td>imageThumbWidth<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Width of thumbnail image in pixels<\/td><\/tr><tr><td>imageThumbHeight<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Height of thumbnail image in pixels<\/td><\/tr><tr><td>imageHighRes1 ***<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Link to the best possible <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-pictures\/\">image<\/a>, in the largest version<\/td><\/tr><tr><td>imageWidth1<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Width of image in pixels<\/td><\/tr><tr><td>imageHeight1<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Height of image in pixels<\/td><\/tr><tr><td>image2<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Link to another good <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-pictures\/\">product image<\/a>, preferably product packaging (never the same as the first image)<\/td><\/tr><tr><td>imageWidth2<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Width of image in pixels<\/td><\/tr><tr><td>imageHeight2<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Height of image in pixels<\/td><\/tr><tr><td>image3<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Link to the first <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-pictures\/\">image<\/a> in the gallery (never one of those already listed)<\/td><\/tr><tr><td>imageWidth3<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Width of image in pixels<\/td><\/tr><tr><td>imageHeight3<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Height of image in pixels<\/td><\/tr><tr><td>image4<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Link to the second <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-pictures\/\">image<\/a> in the gallery (never one of those already listed)<\/td><\/tr><tr><td>imageWidth4<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Width of image in pixels<\/td><\/tr><tr><td>imageHeight4<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Height of image in pixels<\/td><\/tr><tr><td>image5<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Link to the third <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-pictures\/\">image<\/a> in the gallery (never one of those already listed)<\/td><\/tr><tr><td>imageWidth5<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Width of image in pixels<\/td><\/tr><tr><td>imageHeight5<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Height of image in pixels<\/td><\/tr><tr><td>energyLabel<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Link to the Energy Label <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-pictures\/\">image<\/a><\/td><\/tr><tr><td>energyEfficiencyClass *<\/td><td>&nbsp;<\/td><td>String (10)<\/td><td>Energy efficiency class<\/td><\/tr><tr><td>entryDate<\/td><td>Yes<\/td><td>Date<\/td><td>Since when has the product been listed on the platform?<\/td><\/tr><tr><td>rank<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Overall popularity rank (rank 1 to n, a high number corresponds to a bad ranking)<\/td><\/tr><tr><td>qualification<\/td><td>&nbsp;<\/td><td>Integer<\/td><td><a href=\"https:\/\/guide.itscope.com\/en\/kb\/qualification-of-the-product\/\">Product qualification level<\/a><\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> warrantyText<\/td><td>&nbsp;<\/td><td>String<\/td><td><a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-descriptions-and-product-texts\/\">Warranty text<\/a> for the product<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> marketingText<\/td><td>&nbsp;<\/td><td>String<\/td><td><a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-descriptions-and-product-texts\/\">Marketing text<\/a> for the product<\/td><\/tr><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> keySellingPoints *<\/td><td>&nbsp;<\/td><td>String<\/td><td>Key Selling Points<\/td><\/tr><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> packageContents *<\/td><td>&nbsp;<\/td><td>String<\/td><td>Scope of delivery<\/td><\/tr><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> productFeatures *<\/td><td>&nbsp;<\/td><td>String<\/td><td>Product features<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> <img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\">htmlMainSpecs *<\/td><td>&nbsp;<\/td><td>String<\/td><td>Technical characteristics of the product in short form, separated with br-tags<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> htmlSpecs<\/td><td>&nbsp;<\/td><td>String<\/td><td><a href=\"https:\/\/guide.itscope.com\/en\/kb\/technical-properties-in-html-format-htmlspecs\/\">Technical characteristics<\/a> of the product, in HTML format<\/td><\/tr><tr><td>recommendedRetailPriceNet<\/td><td>&nbsp;<\/td><td>Double<\/td><td>Manufacturer&#8217;s Net MSRP recommended retail price<\/td><\/tr><tr><td>price<\/td><td>&nbsp;<\/td><td>BigDecimal<\/td><td>Price basis for the <a href=\"https:\/\/guide.itscope.com\/en\/kb\/origin-of-price-and-stock-level-information\/\">calculated price<\/a><\/td><\/tr><tr><td>priceCalc<\/td><td>&nbsp;<\/td><td>BigDecimal<\/td><td>Calculated price, based on the individual <a href=\"https:\/\/guide.itscope.com\/en\/kb\/origin-of-price-and-stock-level-information\/\">price calculation<\/a><\/td><\/tr><tr><td>currencyCode<\/td><td>&nbsp;<\/td><td>String (3)<\/td><td>Currency unit that applies to this price information<\/td><\/tr><tr><td>priceCalcVat<\/td><td>&nbsp;<\/td><td>BigDecimal<\/td><td>Sales tax rate for the <a href=\"https:\/\/guide.itscope.com\/en\/kb\/origin-of-price-and-stock-level-information\/\">calculated price<\/a><\/td><\/tr><tr><td>priceLastUpdate<\/td><td>&nbsp;<\/td><td>Date<\/td><td>Time of last price information update<\/td><\/tr><tr><td>priceSupplierId<\/td><td>&nbsp;<\/td><td>Long<\/td><td>Reference to the supplier (1:1) that provided the source of supply for this price information<\/td><\/tr><tr><td>priceSupplierName<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Name of the supplier that provided this source of supply<\/td><\/tr><tr><td>priceSupplierItemId<\/td><td>&nbsp;<\/td><td>Long<\/td><td>Reference to a source of supply (n:1); if this field is zero, the price information refers to a product (source of supply reference and product reference are mutually exclusive)<\/td><\/tr><tr><td>priceSupplierSKU<\/td><td>&nbsp;<\/td><td>String (150)<\/td><td>Product identifier of the supplier that provided the source of supply [was String(40) before 18\/10\/2021] <\/td><\/tr><tr><td>stockSupplierText<\/td><td>&nbsp;<\/td><td>String (40)<\/td><td>Textual inventory information of the supplier, directly taken over, without interpretation<\/td><\/tr><tr><td>stockStatus<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Numeric key of the <a href=\"https:\/\/guide.itscope.com\/en\/kb\/availability-status-codes\/\">delivery status of the inventory information<\/a><\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> stockStatusText<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td><a href=\"https:\/\/guide.itscope.com\/en\/kb\/availability-status-codes\/\">Delivery status of inventory information<\/a>, such as &#8216;in stock&#8217; or &#8216;in&nbsp;field warehouse&#8217;<\/td><\/tr><tr><td>stock<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Quantity for the delivery status indicated in this structure<\/td><\/tr><tr><td>externalStock<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Quantity available from external sources (additional information provided by some suppliers for delivery status &#8216;in stock&#8217;)<\/td><\/tr><tr><td>incomingStock<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Quantity in transit (additional information provided by some suppliers for delivery status &#8216;in stock&#8217;)<\/td><\/tr><tr><td>stockAvailabilityDate<\/td><td>&nbsp;<\/td><td>Date<\/td><td>Delivery date for products currently not in stock<\/td><\/tr><tr><td>stockLastUpdate<\/td><td>&nbsp;<\/td><td>Date<\/td><td>Time of last update of inventory information<\/td><\/tr><tr><td>aggregatedStatus<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Best availability status<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> aggregatedStatusText<\/td><td>&nbsp;<\/td><td>String (20)<\/td><td>Best availability status<\/td><\/tr><tr><td>aggregatedStock<\/td><td>&nbsp;<\/td><td>integer<\/td><td>Total of all inventories<\/td><\/tr><tr><td>aggregatedSupplierItems<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Sum of all distributors for this product<\/td><\/tr><tr><td>contractTypeId *<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>The ID of the <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-family\/\">product family<\/a> for licence and service products<\/td><\/tr><tr><td>contractTypeName *<\/td><td>&nbsp;<\/td><td>String (20)<\/td><td><meta charset=\"utf-8\">The name of the <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-family\/\">product family<\/a> for licence and service products<\/td><\/tr><tr><td>priceBillingPeriod<\/td><td><\/td><td>Integer<\/td><td>Length of the price billing period<\/td><\/tr><tr><td>priceBillingPeriodUnit<\/td><td><\/td><td>String (40)<\/td><td>Unit of the price billing period (e.g. &#8220;Years&#8221;, &#8220;Month&#8221;)<\/td><\/tr><tr><td>priceSubscriptionPeriod<\/td><td><\/td><td>Integer<\/td><td>Length of the price subscription period<\/td><\/tr><tr><td>priceSubscriptionPeriodUnit<\/td><td><\/td><td>String (40)<\/td><td>Unit of the price subscription period (e.g. &#8220;Years&#8221;, &#8220;Month&#8221;)<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> supplierItem<\/td><td>yes<\/td><td>List &lt;supplierItem&gt;<\/td><td>Sources of supply for an ITscope product. Specific offers from distributors listed on ITscope<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> attribute<\/td><td>&nbsp;<\/td><td>List &lt;attribute&gt;<\/td><td>Attributes of a product<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> attributeCluster<\/td><td>&nbsp;<\/td><td>List &lt;attributeCluster&gt;<\/td><td>Attribute clusters in which the product can be found for feature searches. Can summarise multiple attribute values according to the quantity in intervals, eg 64-128MB RAM<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> accessory<\/td><td>&nbsp;<\/td><td>List &lt;accessory&gt;<\/td><td><a href=\"https:\/\/guide.itscope.com\/en\/kb\/accessory-types\/\">Original accessories and compatible accessories<\/a> for a product<\/td><\/tr><tr><td>keyContent<\/td><td><\/td><td>List&lt;keyContent&gt;<\/td><td>Content data for a product that is available in the form of keys (e.g. category IDs, classification IDs forEclass, UNSPSC, ETIM, each with different versions of the classifications and customs tariff numbers)<\/td><\/tr><tr><td>priceCalcNet<\/td><td><\/td><td>BigDecimal<\/td><td>Calculated net price, based on the individual <a href=\"https:\/\/guide.itscope.com\/en\/kb\/origin-of-price-and-stock-level-information\/\">price calculation<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"4\">supplierItem<\/h2>\n\n\n\n<p>Source of supply for an ITscope product. A specific offer from a distributor listed on ITscope.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Name<\/th><th>Mandatory<\/th><th>Data type<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>Yes<\/td><td>Long<\/td><td>Unique key<\/td><\/tr><tr><td>ean<\/td><td>&nbsp;<\/td><td>String (18)<\/td><td>EAN specified by the supplier<\/td><\/tr><tr><td>manufacturerSKU<\/td><td>&nbsp;<\/td><td>String (150)<\/td><td>Supplier&#8217;s SKU\/article number (does not have to match ITscope&#8217;s) [was String(40) before 18\/10\/2021]<\/td><\/tr><tr><td>supplierSKU<\/td><td>&nbsp;<\/td><td>String (150)<\/td><td>Product number specified by the supplier [was String(40) before 18\/10\/2021] <\/td><\/tr><tr><td>supplierId<\/td><td>Yes<\/td><td>Long<\/td><td>Refers 1:1 to Supplier.id<\/td><\/tr><tr><td>supplierName<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Name of the supplier<\/td><\/tr><tr><td>manufacturerName<\/td><td>&nbsp;<\/td><td>String (80)<\/td><td>Manufacturer name as specified by the supplier<\/td><\/tr><tr><td>productName<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Exact identifier of the product, as given by the supplier<\/td><\/tr><tr><td>longDescription<\/td><td>&nbsp;<\/td><td>String (60000)<\/td><td>Long product description specified by the supplier<\/td><\/tr><tr><td>conditionId<\/td><td>Yes<\/td><td>Integer<\/td><td>Numeric code for the <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-condition-codes\/\">product&#8217;s condition<\/a><\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> conditionName<\/td><td>Yes<\/td><td>String (255)<\/td><td><a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-condition-codes\/\">Condition of the product<\/a> (new, used, B-Stock, refurbished, etc.)<\/td><\/tr><tr><td>eolProduct<\/td><td>Yes<\/td><td>Boolean<\/td><td>Flag a product as end of life (soon to be discontinued)<\/td><\/tr><tr><td>matchQuality<\/td><td>Yes<\/td><td>Integer<\/td><td><a href=\"https:\/\/guide.itscope.com\/en\/kb\/matching-quality\/\">Mapping quality<\/a> of the product to ITscope&#8217;s product catalogue<\/td><\/tr><tr><td>eanValid<\/td><td>Yes<\/td><td>Boolean<\/td><td>Flag to indicate whether the EAN of the supplier is valid according to EAN criteria<\/td><\/tr><tr><td>specialOffer<\/td><td>Yes<\/td><td>Boolean<\/td><td>Flag to indicate whether product is a special offer<\/td><\/tr><tr><td>promotion<\/td><td>&nbsp;<\/td><td>String (40)<\/td><td>Name of the supplier&#8217;s promotional campaign<\/td><\/tr><tr><td>vat<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>VAT rate for the product<\/td><\/tr><tr><td>copyrightLevy<\/td><td>&nbsp;<\/td><td>Double<\/td><td>Levy due to copyright<\/td><\/tr><tr><td>customsTariffNumber<\/td><td>&nbsp;<\/td><td>String (50)<\/td><td>Customs tariff number<\/td><\/tr><tr><td>countryOfOrigin<\/td><td>&nbsp;<\/td><td>String (20)<\/td><td>Country of origin of the product<\/td><\/tr><tr><td>grossDimX<\/td><td>&nbsp;<\/td><td>Double<\/td><td>Length of the product including unit of measurement<\/td><\/tr><tr><td>grossDimY<\/td><td>&nbsp;<\/td><td>Double<\/td><td>Height of the product including unit of measurement<\/td><\/tr><tr><td>grossDimZ<\/td><td>&nbsp;<\/td><td>Double<\/td><td>Width of product including unit of measurement<\/td><\/tr><tr><td>warrantyText<\/td><td>&nbsp;<\/td><td>String (40)<\/td><td>Supplier&#8217;s warranty<\/td><\/tr><tr><td>deeplink<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Link to the product with the supplier<\/td><\/tr><tr><td>recommendedRetailPriceNet<\/td><td>&nbsp;<\/td><td>Double<\/td><td>MSRP indication provided by the supplier<\/td><\/tr><tr><td>price<\/td><td>Yes<\/td><td>BigDecimal<\/td><td>Price<\/td><\/tr><tr><td>priceCalc<\/td><td>Yes<\/td><td>BigDecimal<\/td><td><meta charset=\"utf-8\">Calculated price, based on the individual <a href=\"https:\/\/guide.itscope.com\/en\/kb\/origin-of-price-and-stock-level-information\/\">price calculation<\/a><\/td><\/tr><tr><td>currencyCode<\/td><td>Yes<\/td><td>String (3)<\/td><td>Currency unit that applies to this price information<\/td><\/tr><tr><td>priceCalcVat<\/td><td>Yes<\/td><td>BigDecimal<\/td><td><meta charset=\"utf-8\">Sales tax rate for the <a href=\"https:\/\/guide.itscope.com\/en\/kb\/origin-of-price-and-stock-level-information\/\">calculated price<\/a><\/td><\/tr><tr><td>priceLastUpdate<\/td><td>Yes<\/td><td>Date<\/td><td><meta charset=\"utf-8\">Time of last price information update<\/td><\/tr><tr><td>stockSupplierText<\/td><td>&nbsp;<\/td><td>String<\/td><td><meta charset=\"utf-8\">Textual inventory information of the supplier, directly taken over, without interpretation<\/td><\/tr><tr><td>stockStatus<\/td><td>&nbsp;<\/td><td>Integer<\/td><td><meta charset=\"utf-8\">Numeric key of the <a href=\"https:\/\/guide.itscope.com\/en\/kb\/availability-status-codes\/\">delivery status of the inventory information<\/a><\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> stockStatusText<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td><a href=\"https:\/\/guide.itscope.com\/en\/kb\/availability-status-codes\/\"><meta charset=\"utf-8\"><\/a><a href=\"https:\/\/guide.itscope.com\/en\/kb\/availability-status-codes\/\">Delivery status of inventory information<\/a>, such as &#8216;in stock&#8217; or &#8216;in&nbsp;field warehouse&#8217;<\/td><\/tr><tr><td>stock<\/td><td>&nbsp;<\/td><td>Integer<\/td><td><meta charset=\"utf-8\">Quantity for the delivery status indicated in this structure<\/td><\/tr><tr><td>externalStock<\/td><td>&nbsp;<\/td><td>Integer<\/td><td><meta charset=\"utf-8\">Quantity available from external sources (additional information provided by some suppliers for delivery status &#8216;in stock&#8217;)<\/td><\/tr><tr><td>incomingStock<\/td><td>&nbsp;<\/td><td>Integer<\/td><td><meta charset=\"utf-8\">Quantity in transit (additional information provided by some suppliers for delivery status &#8216;in stock&#8217;)<\/td><\/tr><tr><td>stockAvailabilityDate<\/td><td>&nbsp;<\/td><td>Date<\/td><td><meta charset=\"utf-8\">Delivery date for products currently not in stock<\/td><\/tr><tr><td>lastStockUpdate<\/td><td>&nbsp;<\/td><td>Date<\/td><td><meta charset=\"utf-8\">Time of last update of inventory information<\/td><\/tr><tr><td>contractTypeId *<\/td><td>&nbsp;<\/td><td>Integer<\/td><td><meta charset=\"utf-8\"><meta charset=\"utf-8\">The ID of the <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-family\/\">product family<\/a> for licence and service products<\/td><\/tr><tr><td><img decoding=\"async\" style=\"width: 30px;\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\"> contractTypeName *<\/td><td>&nbsp;<\/td><td>String (20)<\/td><td><meta charset=\"utf-8\">The name of the <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-family\/\">product family<\/a> for licence and service products<\/td><\/tr><tr><td>priceBillingPeriod<\/td><td><\/td><td>Integer<\/td><td>Length of the price billing period<\/td><\/tr><tr><td>priceBillingPeriodUnit<\/td><td><\/td><td>String (40)<\/td><td>Unit of the price billing period (e.g. &#8220;Years&#8221;, &#8220;Month&#8221;)<\/td><\/tr><tr><td>priceSubscriptionPeriod<\/td><td><\/td><td>Integer<\/td><td>Length of the price subscription period<\/td><\/tr><tr><td>priceSubscriptionPeriodUnit<\/td><td><\/td><td>String (40)<\/td><td>Unit of the price subscription period (e.g. &#8220;Years&#8221;, &#8220;Month&#8221;)<\/td><\/tr><tr><td>weeeRegNo<\/td><td><\/td><td>String (12)<\/td><td>WEEE number, is considered as proof of the registration of the manufacturer, the brand and the type of electrical or electronic equipment carried out in the country of manufacture.<\/td><\/tr><tr><td>projects<\/td><td><\/td><td>List&lt;project&gt;<\/td><td>Projects for the source of supply<\/td><\/tr><tr><td>supplierPackagingInfo<\/td><td><\/td><td>supplierPackagingInfo<\/td><td>Information on the packaging units of a source of supply<\/td><\/tr><tr><td>scaledPriceInfo<\/td><td><\/td><td>scaledPriceInfo<\/td><td>Information on scaled prices of a source of supply<\/td><\/tr><tr><td>priceCalcNet<\/td><td>Yes<\/td><td>BigDecimal<\/td><td>Calculated net price, based on the individual <a href=\"https:\/\/guide.itscope.com\/en\/kb\/origin-of-price-and-stock-level-information\/\">price calculation<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">supplierPackageInfo<\/h2>\n\n\n\n<p>Information on packaging units of a source of supply. The unit codes for packaging units are in UN\/ECE Recommendation No.21. This standard is recommended by UN\/CEFACT. Details see <a href=\"https:\/\/unece.org\/trade\/uncefact\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">UNECE<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Name<\/th><th>Mandatory<\/th><th>Data type<\/th><th>description<\/th><\/tr><\/thead><tbody><tr><td>contentUnit<\/td><td>&nbsp;<\/td><td>String (50)<\/td><td>Unit code of the contents of a package<\/td><\/tr><tr><td>intervalQuantity<\/td><td>\ufeff<\/td><td>Integer<\/td><td>Number indicating in which graduation the item can be ordered (in order units).<\/td><\/tr><tr><td>minQuantity<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Minimum number of packaging units to trigger an order<\/td><\/tr><tr><td>numberContentUnitPerOrderUnit<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Number of contents of a packaging unit<\/td><\/tr><tr><td>orderUnit<\/td><td>\ufeff<\/td><td>String (50)<\/td><td>Packaging unit code<\/td><\/tr><tr><td>priceQuantity<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Number of packaging units for a given price<\/td><\/tr><tr><td>supplierPackingQuantity<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Number of packaging units a supplier provides in a purchase order<\/td><\/tr><tr><td>totalPriceQuantity<\/td><td>\ufeff<\/td><td>Integer<\/td><td>Total number of units (packaging units * contents) for a given price<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">scaledPriceInfo<\/h2>\n\n\n\n<p>Information on scaled prices of a source of supply<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Name<\/th><th>Mandatory<\/th><th>Data type<\/th><th>description<\/th><\/tr><\/thead><tbody><tr><td>scale<\/td><td>Yes<\/td><td>Integer<\/td><td>Indicates the scale from which the price applies<\/td><\/tr><tr><td>price<\/td><td>Yes<\/td><td>BigDecimal<\/td><td>The price for the scale<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"5\">project<\/h2>\n\n\n\n<p>Price, availability and further information&nbsp;for a project item.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>name<\/th><th>Mandatory<\/th><th>Data type<\/th><th>description<\/th><\/tr><\/thead><tbody><tr><td>supplierProjectId<\/td><td>&nbsp;<\/td><td>String (40)<\/td><td>Project number of the supplier<\/td><\/tr><tr><td>manufacturerProjectId<\/td><td>Yes<\/td><td>String (40)<\/td><td>Project number of the manufacturer (unique key)<\/td><\/tr><tr><td>projectName<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Project description<\/td><\/tr><tr><td>endCustomer<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>End customer for the project item<\/td><\/tr><tr><td>price<\/td><td>Yes<\/td><td>BigDecimal<\/td><td>Project price<\/td><\/tr><tr><td>validFrom<\/td><td>&nbsp;<\/td><td>Date<\/td><td>Date the project conditions become valid<\/td><\/tr><tr><td>validTo<\/td><td>&nbsp;<\/td><td>Date<\/td><td>Date the project conditions expire<\/td><\/tr><tr><td>targetQuantity<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Negotiated project amount<\/td><\/tr><tr><td>remainingQuantity<\/td><td>Yes<\/td><td>Integer<\/td><td>Remaining quota that can be ordered<\/td><\/tr><tr><td>minQuantity<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Minimum ordering quantity<\/td><\/tr><tr><td>projectLastUpdate<\/td><td>&nbsp;<\/td><td>Date<\/td><td>Time of last update of project information<\/td><\/tr><tr><td><meta charset=\"utf-8\">projectBundleId *<\/td><td><\/td><td><meta charset=\"utf-8\">String (50)<\/td><td><meta charset=\"utf-8\"><\/meta>Unique key for the project bundle<\/td><\/tr><tr><td><meta charset=\"utf-8\">projectBundleName *<\/td><td><\/td><td><meta charset=\"utf-8\">String (255)<\/td><td><meta charset=\"utf-8\"><\/meta>Name of the project bundle<\/td><\/tr><tr><td><meta charset=\"utf-8\">projectPosition *<\/td><td><\/td><td><meta charset=\"utf-8\">Integer<\/td><td><meta charset=\"utf-8\"><\/meta>Project line item number<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"5\">attribute<\/h2>\n\n\n\n<p>Attributes of a product.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Name<\/th><th>Mandatory<\/th><th>Data type<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td>value *<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>The base value (see also <a href=\"https:\/\/guide.itscope.com\/en\/kb\/units-for-product-properties-in-the-form-of-a-number\/\">base unit<\/a>) of the attribute. For text as a text module, for numbers as the smallest value<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> displayValue<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>The readable value of the attribute, including unit<\/td><\/tr><tr><td>attributeTypeId<\/td><td>&nbsp;<\/td><td>Long<\/td><td>Unique identifier of the attribute type<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> attributeTypeName<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Name of the attribute type<\/td><\/tr><tr><td>attributeTypeRank<\/td><td>&nbsp;<\/td><td>Long<\/td><td>Ranking of the attribute type &#8211; this can, for example, be used for sorting<\/td><\/tr><tr><td>attributeTypeGroupId<\/td><td>&nbsp;<\/td><td>Long<\/td><td>Identifier of an attribute group, no table reference, but uniquely identifies attributeTypeGroupName<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> attributeTypeGroupName<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Name of the attribute group<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"6\">attributeCluster<\/h2>\n\n\n\n<p><meta charset=\"utf-8\">Attribute clusters in which the product can be found for feature searches. Can summarise multiple attribute values according to the quantity in intervals, eg 64-128MB RAM.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Name<\/th><th>Mandatory<\/th><th>Data type<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>&nbsp;<\/td><td>Long<\/td><td>Unique ITscope Key<\/td><\/tr><tr><td>productTypeId<\/td><td>&nbsp;<\/td><td>Long<\/td><td>Reference to the product type, optional<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> productTypeName<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Name of the product type to which this attribute belongs, optional<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> attributeTypeName<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Name of an attribute. Can be the same as the name from ProductType.attributeTypeName (1..5)<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> attributeTypeGroupName<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Name of an attribute group<\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> name<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Identifier of the product version (e.g. 2 GB, 15 &#8220;, 80 W &#8211; 120 W)<\/td><\/tr><tr><td>rank<\/td><td>&nbsp;<\/td><td>Long<\/td><td>Rank of the attribute<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"7\">accessory<\/h2>\n\n\n\n<p><a href=\"https:\/\/guide.itscope.com\/en\/kb\/accessory-types\/\">Original accessories and compatible accessories<\/a> for a product.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Name<\/th><th>Mandatory<\/th><th>Data type<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td>referencedProductId<\/td><td>&nbsp;<\/td><td>Long<\/td><td>Refers to a reference product, e.g. a product which is listed as an original accessory for this particular product<\/td><\/tr><tr><td>typeId<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Internal identifier for the <a href=\"https:\/\/guide.itscope.com\/en\/kb\/accessory-types\/\">type of the reference product<\/a><\/td><\/tr><tr><td><meta charset=\"utf-8\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> type<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Identifier for the <a href=\"https:\/\/guide.itscope.com\/en\/kb\/accessory-types\/\">type of the reference product<\/a>, including original accessories, all compatible accessories, etc.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">keyContent<\/h2>\n\n\n\n<p>Content data for a product that is in the form of keys (eg category IDs, customs tariff numbers)<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Name<\/th><th>Mandatory<\/th><th>Data type<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td>key<\/td><td>&nbsp;<\/td><td>Long<\/td><td>Key of the record, not unique<\/td><\/tr><tr><td>langId<\/td><td>&nbsp;<\/td><td>Long<\/td><td>Internal <a href=\"https:\/\/guide.itscope.com\/en\/kb\/language-ids-for-content\/\">identifier of the language<\/a>&nbsp;of this content<\/td><\/tr><tr><td>contentModel<\/td><td>&nbsp;<\/td><td>contentModel<\/td><td>Reference to the <a href=\"https:\/\/guide.itscope.com\/en\/kb\/model-for-content\/\">type of content<\/a> (ContentModel.id, n:1)<\/td><\/tr><tr><td>contentProvider<\/td><td>&nbsp;<\/td><td>contentProvider<\/td><td>Reference to the <a href=\"https:\/\/guide.itscope.com\/en\/kb\/content-providers\/\">content provider<\/a> (ContentProvider.id, n:1)<\/td><\/tr><tr><td><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/hc\/de\/article_attachments\/209385085\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" style=\"width: 30px;\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\"> contentCategory <\/td><td>&nbsp;<\/td><td>contentCategory<\/td><td>Reference to the <a href=\"https:\/\/guide.itscope.com\/en\/kb\/categories-for-content\/\">content category<\/a> (ContentCategory.id, n:1)<\/td><\/tr><tr><td>value<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Content of the content (value of the key)<\/td><\/tr><tr><td>lang<\/td><td>&nbsp;<\/td><td>String (10)<\/td><td>Language code in ISO639 for the language of the content<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">contentModel<\/h2>\n\n\n\n<p><a href=\"https:\/\/guide.itscope.com\/en\/kb\/model-for-content\/\">Classification of content in different types by the content provider<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Name<\/th><th>Mandatoy<\/th><th>Data type<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>&nbsp;<\/td><td>long<\/td><td>Unique key<\/td><\/tr><tr><td>name<\/td><td>&nbsp;<\/td><td>String (1023)    <\/td><td>Displayed name of the content (e.g. Icecat standard image large, 1WorldSync product ID)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">contentProvider<\/h2>\n\n\n\n<p><a href=\"https:\/\/guide.itscope.com\/en\/kb\/content-providers\/\">Origin of the content<\/a> e.g. CNET, Icecat, manufacturer or distributor<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Name<\/th><th>Mandatory<\/th><th>Data type<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>&nbsp;<\/td><td>long<\/td><td>Unique key<\/td><\/tr><tr><td>name<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Clear text name of the content supplier (e.g. Icecat, 1WorldSync)<\/td><\/tr><tr><td>rank<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Prioritisation for sorting, same values \u200b\u200bare possible several times<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">contentCategory<\/h2>\n\n\n\n<p><a href=\"https:\/\/guide.itscope.com\/en\/kb\/categories-for-content\/\">ITscope categorisation<\/a> of content (e.g. structured feature descriptions, product photo, etc.).<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Name<\/th><th>MAndatory<\/th><th>Data type<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>&nbsp;<\/td><td>long<\/td><td>Unique key<\/td><\/tr><tr><td><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/hc\/de\/article_attachments\/209385085\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png\" style=\"width: 30px;\"> name<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Identifier of category<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"8\">Database scripts for CSV<\/h2>\n","protected":false},"excerpt":{"rendered":"<p>Database diagram Dependency diagram for the CSV output format, including SQL scripts for generating the tables and to load the data with loadData local infile at the end of this &#8230;<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"kbtopic":[174],"kbtag":[],"class_list":["post-2335","kb","type-kb","status-publish","hentry","kbtopic-api-export-data-formats-product-data"],"_links":{"self":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/2335","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=2335"}],"version-history":[{"count":47,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/2335\/revisions"}],"predecessor-version":[{"id":19748,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/2335\/revisions\/19748"}],"wp:attachment":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/media?parent=2335"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kbtopic?post=2335"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kbtag?post=2335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}