{"id":2402,"date":"2020-09-25T07:10:09","date_gmt":"2020-09-25T07:10:09","guid":{"rendered":"https:\/\/support.itscope.hostpress.me\/?post_type=kb&#038;p=2402"},"modified":"2025-12-19T11:00:56","modified_gmt":"2025-12-19T09:00:56","slug":"format-description-for-product-data-format-standardupdate","status":"publish","type":"kb","link":"https:\/\/guide.itscope.com\/en\/kb\/format-description-for-product-data-format-standardupdate\/","title":{"rendered":"Format description for product data format standardUpdate"},"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-product-data-format-standardupdate\/\">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 data-wp-context=\"{&quot;imageId&quot;:&quot;69f392df9810c&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"69f392df9810c\" class=\"wp-block-image size-large wp-lightbox-container\"><img decoding=\"async\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/standardupdate_csv_21-1024x574.png\" alt=\"\" class=\"wp-image-16054\"\/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Enlarge\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/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 these are nodes.<\/p>\n\n\n\n<p>The data format standardUpdate 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:&nbsp;source of supply for an ITscope product. A specific product offering from a distributor listed on ITscope.<\/li>\n\n\n\n<li>Project: price, availability and further information&nbsp;on a project item.<\/li>\n<\/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 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:49px;height:49px\"\/><\/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>&nbsp;<\/td><td>long<\/td><td>Unique key<\/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 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 (150)<\/td><td>Product identifier given by the supplier that provided this 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><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>priceBillingPeriod<\/td><td>Integer<\/td><td><\/td><td>Length of the price billing period<\/td><\/tr><tr><td>priceBillingPeriodUnit<\/td><td>String (40)<\/td><td><\/td><td>Unit of the price billing period (e.g. \u201cYears\u201d, \u201cMonth\u201d)<\/td><\/tr><tr><td>priceSubscriptionPeriod<\/td><td>Integer<\/td><td><\/td><td>Length of the price subscription period<\/td><\/tr><tr><td>priceSubscriptionPeriodUnit<\/td><td>String (40)<\/td><td><\/td><td>Unit of the price subscription period (e.g. \u201cYears\u201d, \u201cMonth\u201d)<\/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>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 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>supplierSKU<\/td><td>&nbsp;<\/td><td>String (150)<\/td><td>Product number of 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 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\/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>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 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>lastStockUpdate<\/td><td>&nbsp;<\/td><td>Date<\/td><td>Time of last update of inventory information<\/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. \u201cYears\u201d, \u201cMonth\u201d)<\/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. \u201cYears\u201d, \u201cMonth\u201d)<\/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>List&lt;scaledPriceInfo&gt;<\/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\">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>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>price<\/td><td>Yes<\/td><td>BigDecimal<\/td><td>Project price<\/td><\/tr><tr><td>remainingQuantity<\/td><td>Yes<\/td><td>Integer<\/td><td>Remaining quota that can be ordered<\/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 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\">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":[174],"kbtag":[],"class_list":["post-2402","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\/2402","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=2402"}],"version-history":[{"count":14,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/2402\/revisions"}],"predecessor-version":[{"id":19754,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/2402\/revisions\/19754"}],"wp:attachment":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/media?parent=2402"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kbtopic?post=2402"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kbtag?post=2402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}