{"id":2400,"date":"2020-09-25T07:08:35","date_gmt":"2020-09-25T07:08:35","guid":{"rendered":"https:\/\/support.itscope.hostpress.me\/?post_type=kb&#038;p=2400"},"modified":"2022-11-11T12:46:40","modified_gmt":"2022-11-11T10:46:40","slug":"format-description-for-product-data-format-standard-deprecated","status":"publish","type":"kb","link":"https:\/\/guide.itscope.com\/en\/kb\/format-description-for-product-data-format-standard-deprecated\/","title":{"rendered":"Format description for product 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 <a href=\"https:\/\/guide.itscope.com\/en\/kb\/format-description-for-products-data-format-standard\/\">SQL scripts for generating the tables and to load the data with load data local infile<\/a> at the end of this article.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"808\" height=\"306\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/image-353.png\" alt=\"\" class=\"wp-image-2332\" srcset=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/image-353.png 808w, https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/image-353-300x114.png 300w, https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/image-353-768x291.png 768w\" sizes=\"auto, (max-width: 808px) 100vw, 808px\" \/><\/figure>\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 these 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\"><li>product: product from the ITscope catalogue.<\/li><li>supplierItem: source of supply for an ITscope product. A specific product offering from a distributor listed on ITscope.<\/li><li>project: price, availability and further information&nbsp;on a project item.<\/li><li>attribute: properties of a product.<\/li><li>attributeCluster: property clusters in which the product can be found for feature searches. Can summarise several property expressions in intervals, according to the quantity, e.g. 64-128 MB RAM.<\/li><li>accessory: <a href=\"https:\/\/guide.itscope.com\/en\/kb\/accessory-types\/\">original accessories and compatible accessories<\/a> for a product.<\/li><\/ul>\n\n\n\n<p>Elements marked with a globe vary depending on the selected export language:<\/p>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" 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\" width=\"49\" height=\"49\"\/><\/figure>\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>Compulsory field<\/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 (40)<\/td><td>Manufacturer article number<\/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>manufacturerId<\/td><td>Yes<\/td><td>long<\/td><td>Reference to the manufacturer of this product (n:1 on Manufacturer.id)<\/td><\/tr><tr><td>manufacturerName<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Name of the manufacturer<\/td><\/tr><tr><td>productNameWithManufacturer<\/td><td>Yes<\/td><td>String<\/td><td><a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-descriptions-and-product-texts\/\">Product name<\/a>, including manufacturer name<\/td><\/tr><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" style=\"width: 30px;\"> shortDescription<\/td><td>&nbsp;<\/td><td>String<\/td><td><a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-descriptions-and-product-texts\/\">Short description<\/a>&nbsp;for the product<\/td><\/tr><tr><td><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" 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<\/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 for 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 to 1:n on 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>Unambiguous Attribute Key to build a possible subcategory, points to 1:n on 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>Unambiguous Attribute Key to build a possible subcategory, points to 1:n on 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>Unambiguous Attribute Key to build a possible subcategory, points to 1:n on 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>Unambiguous Attribute Key to build a possible subcategory, points to 1:n on 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><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" 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 a 3rd\u00a0<a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-categories\/\">category level<\/a>, if applicable.<\/td><\/tr><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" style=\"width: 30px;\"> attributeValue2<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Attribute cluster value for the attribute from ProductType.attributeTypeId2. Can be used as a 4th <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-categories\/\">category level<\/a>, if applicable.<\/td><\/tr><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" style=\"width: 30px;\"> attributeValue3<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Attribute cluster value for the attribute from ProductType.attributeTypeId3. Can be used as a 5th <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-categories\/\">category level<\/a>, if applicable.<\/td><\/tr><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" 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><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" 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 product sub type<\/td><\/tr><tr><td>productSubType<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Design property of the product, e.g. mouse or keyboard for input devices.&nbsp;Should&nbsp;<strong>not<\/strong>&nbsp;be used as a 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>estimateGrossWeight<\/td><td>&nbsp;<\/td><td>Double<\/td><td>Weight in kilograms<\/td><\/tr><tr><td>largeDimX<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Length of the product including unit of measurement<\/td><\/tr><tr><td>largeDimY<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Height of the product including unit of measurement<\/td><\/tr><tr><td>largeDimZ<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Width of product including unit of measurement<\/td><\/tr><tr><td>customsTariffNumber<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Customs tariff number<\/td><\/tr><tr><td>deeplink<\/td><td>Yes<\/td><td>String (2048)<\/td><td>Deep link to the ITscope.com platform<\/td><\/tr><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" style=\"width: 30px;\"> standardHtmlDatasheet<\/td><td>Yes<\/td><td>String (2048)<\/td><td>URL, link to HTML standard datasheet<\/td><\/tr><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" 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><\/td><\/tr><tr><td>imageThumbWidth<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Width of the preview image in pixels<\/td><\/tr><tr><td>imageThumbHeight<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Height of the preview image in pixels<\/td><\/tr><tr><td>image1<\/td><td>&nbsp;<\/td><td>String (1024)<\/td><td>Link to the best possible <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-pictures\/\">product 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 the 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 including product packaging (never the same as the first image)<\/td><\/tr><tr><td>imageWidth2<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Width of the image in pixels<\/td><\/tr><tr><td>imageHeight2<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Height of the 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 (not one of the already listed images above)<\/td><\/tr><tr><td>imageWidth3<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Width of the image in pixels<\/td><\/tr><tr><td>imageHeight3<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Height of the 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 (not one of the already listed images above)<\/td><\/tr><tr><td>imageWidth4<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Width of the image in pixels<\/td><\/tr><tr><td>imageHeight4<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Height of the 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 the already listed)<\/td><\/tr><tr><td>imageWidth5<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Width of the image in pixels<\/td><\/tr><tr><td>imageHeight5<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Height of the 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>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\/\">Qualification of the product<\/a><\/td><\/tr><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" 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><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" 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=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" 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 properties<\/a> of the product, in HTML format<\/td><\/tr><tr><td>recommendedRetailPriceNet<\/td><td>&nbsp;<\/td><td>Double<\/td><td>Manufacturer&#8217;s RRP<\/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\/kbtopic\/price-calculation\/\">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 that was used to determine 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 update of price information<\/td><\/tr><tr><td>priceSupplierId<\/td><td>&nbsp;<\/td><td>long<\/td><td>Reference to a supplier (1:1) who has provided the source of supply with 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);&nbsp;if this field is zero, then 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 (40)<\/td><td>Product identifier given by the supplier that provided this source of supply<\/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><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" 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 field warehouse&#8217;<\/td><\/tr><tr><td>stock<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Quantity of products for the delivery status indicated in this structure<\/td><\/tr><tr><td>externalStock<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>External stock (additional information provided by some suppliers in structures with &#8216;in stock&#8217;&nbsp;delivery status)<\/td><\/tr><tr><td>incomingStock<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Stock quantity that will be replenished&nbsp;(additional information provided by some suppliers in structures with &#8216;in stock&#8217;&nbsp;delivery status)<\/td><\/tr><tr><td>stockAvailabilityDate<\/td><td>&nbsp;<\/td><td>Date<\/td><td>Delivery date for products that are 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>Yes<\/td><td>Integer<\/td><td>Best availability status<\/td><\/tr><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" style=\"width: 30px;\"> aggregatedStatusText<\/td><td>Yes<\/td><td>String (20)<\/td><td>Best availability status<\/td><\/tr><tr><td>aggregatedStock<\/td><td>Yes<\/td><td>integer<\/td><td>Sum of all stock levels<\/td><\/tr><tr><td>aggregatedSupplierItems<\/td><td>Yes<\/td><td>Integer<\/td><td>Sum of all distributors offering this product<\/td><\/tr><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" style=\"width: 30px;\"> supplierItem<\/td><td>Yes<\/td><td>List &lt;supplierItem&gt;<\/td><td>Source of supply of an ITscope product. A specific offer from a distributor listed on ITscope<\/td><\/tr><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" style=\"width: 30px;\"> attribute<\/td><td>&nbsp;<\/td><td>List &lt;attribute&gt;<\/td><td>Properties of a product<\/td><\/tr><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" style=\"width: 30px;\"> attributeCluster<\/td><td>&nbsp;<\/td><td>List &lt;attributeCluster&gt;<\/td><td>Property clusters in which the product can be found for feature searches.&nbsp;Can summarise several property expressions in intervals, according to the quantity, e.g. 64-128 MB RAM<\/td><\/tr><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" 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><\/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 offering from a distributor listed on ITscope.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Name<\/th><th>Compulsory field<\/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<\/td><\/tr><tr><td>manufacturerSKU<\/td><td>&nbsp;<\/td><td>String (40)<\/td><td>Supplier&#8217;s part number (does not have to match ITscope)<\/td><\/tr><tr><td>supplierSKU<\/td><td>&nbsp;<\/td><td>String (40)<\/td><td>Product number of the supplier<\/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 Supplier<\/td><\/tr><tr><td>manufacturerName<\/td><td>&nbsp;<\/td><td>String (80)<\/td><td>Manufacturer name as specified by 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>Extended product description by the supplier<\/td><\/tr><tr><td>conditionId<\/td><td>Yes<\/td><td>Integer<\/td><td>Numerical code for the <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-condition-codes\/\">product condition<\/a><\/td><\/tr><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" 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 item<\/a> (new, used, B-Stock, Refurbished, etc.)<\/td><\/tr><tr><td>eolProduct<\/td><td>Yes<\/td><td>Boolean<\/td><td>Notice for discontinued products<\/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 with the ITscope product catalogue<\/td><\/tr><tr><td>eanValid<\/td><td>Yes<\/td><td>Boolean<\/td><td>Flag to indicate whether the EAN of the suppler is valid according to the EAN criteria<\/td><\/tr><tr><td>specialOffer<\/td><td>Yes<\/td><td>Boolean<\/td><td>Flag to indicate if the item is on special offer<\/td><\/tr><tr><td>promotion<\/td><td>&nbsp;<\/td><td>String (40)<\/td><td>Name of the promotion activity of the supplier<\/td><\/tr><tr><td>vat<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>VAT rate for the item<\/td><\/tr><tr><td>copyrightLevy<\/td><td>&nbsp;<\/td><td>Double<\/td><td>Copyright levy<\/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>largeDimX<\/td><td>&nbsp;<\/td><td>Double<\/td><td>Length of the product including unit of measurement<\/td><\/tr><tr><td>largeDimY<\/td><td>&nbsp;<\/td><td>Double<\/td><td>Height of the product including unit of measurement<\/td><\/tr><tr><td>largeDimZ<\/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>RRP indication from 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>Calculated price, based on the individual <a href=\"https:\/\/guide.itscope.com\/en\/kbtopic\/price-calculation\/\">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>Sales tax rate that was used to determine 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>Time of last update of price information<\/td><\/tr><tr><td>stockSupplierText<\/td><td>&nbsp;<\/td><td>String<\/td><td>Stock information on the source of supply, as given by the supplier<\/td><\/tr><tr><td>stockStatus<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Numeric key for the <a href=\"https:\/\/guide.itscope.com\/en\/kb\/availability-status-codes\/\">delivery status of the inventory information<\/a><\/td><\/tr><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" 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 field warehouse&#8217;<\/td><\/tr><tr><td>stock<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Stock level<\/td><\/tr><tr><td>externalStock<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>External stock (additional information provided by some suppliers in structures with &#8216;in stock&#8217;&nbsp;delivery status)<\/td><\/tr><tr><td>incomingStock<\/td><td>&nbsp;<\/td><td>Integer<\/td><td>Stock is being replenished&nbsp;(additional information provided by some suppliers in structures with &#8216;in stock&#8217;&nbsp;delivery status)<\/td><\/tr><tr><td>stockAvailabilityDate<\/td><td>&nbsp;<\/td><td>Date<\/td><td>Delivery date for products that are not in stock<\/td><\/tr><tr><td>lastStockUpdate<\/td><td>&nbsp;<\/td><td>Date<\/td><td>Time of last update of inventory information<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">project<\/h2>\n\n\n\n<p>Price, availability and further information&nbsp;on a project agreement.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Name<\/th><th>Compulsory field<\/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><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"5\">attribute<\/h2>\n\n\n\n<p>Properties of a product.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Name<\/th><th>Compulsory field<\/th><th>Data type<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" style=\"width: 30px;\"> displayValue<\/td><td>&nbsp;<\/td><td>String (10000)<\/td><td>The readable value of the property, including unit<\/td><\/tr><tr><td>attributeTypeId<\/td><td>&nbsp;<\/td><td>long<\/td><td>Unique identifier of a concrete property type<\/td><\/tr><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" style=\"width: 30px;\"> attributeTypeName<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Name of the concrete property type<\/td><\/tr><tr><td>attributeTypeRank<\/td><td>&nbsp;<\/td><td>long<\/td><td>Ranking of the property type, for example, can be used for sorting<\/td><\/tr><tr><td>attributeTypeGroupId<\/td><td>&nbsp;<\/td><td>long<\/td><td>Identifier of a property group, no table reference, but uniquely identifies attributeTypeGroupName<\/td><\/tr><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" style=\"width: 30px;\"> attributeTypeGroupName<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Name of the property group<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"6\">attributeCluster<\/h2>\n\n\n\n<p>Property clusters in which the product can be found for feature searches. Can summarise several property expressions in intervals, according to the quantity, e.g. 64-128 MB RAM.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Name<\/th><th>Compulsory field<\/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><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" style=\"width: 30px;\"> productTypeName<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Name of the product type to which this property belongs, optional<\/td><\/tr><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" style=\"width: 30px;\"> attributeTypeName<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Name of a property. Can be the same as the name from ProductType.attributeTypeName (1..5)<\/td><\/tr><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" style=\"width: 30px;\"> attributeTypeGroupName<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Name of a property group<\/td><\/tr><tr><td><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" style=\"width: 30px;\"> name<\/td><td>&nbsp;<\/td><td>String (255)<\/td><td>Identifier of the characteristic (e.g. 2 GB, 15&#8243;, 80 W &#8211; 120 W)<\/td><\/tr><tr><td>rank<\/td><td>&nbsp;<\/td><td>long<\/td><td>Rank of the property<\/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>Compulsory field<\/th><th>Data type<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td>referencedProductId<\/td><td>&nbsp;<\/td><td>long<\/td><td>Reference to a reference product, e.g. a product that is offered as an original accessory for another 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><img decoding=\"async\" src=\"\/hc\/de\/article_attachments\/209391225\/1481139072_world.svg\" alt=\"\"><img decoding=\"async\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/globus-1.png\" alt=\"\" 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\" 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 load data local infile at the end of &#8230;<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"kbtopic":[179],"kbtag":[],"class_list":["post-2400","kb","type-kb","status-publish","hentry","kbtopic-api-2-0-en"],"_links":{"self":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/2400","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=2400"}],"version-history":[{"count":9,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/2400\/revisions"}],"predecessor-version":[{"id":13980,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/2400\/revisions\/13980"}],"wp:attachment":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/media?parent=2400"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kbtopic?post=2400"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kbtag?post=2400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}