{"id":2419,"date":"2020-09-25T08:56:04","date_gmt":"2020-09-25T08:56:04","guid":{"rendered":"https:\/\/support.itscope.hostpress.me\/?post_type=kb&#038;p=2419"},"modified":"2025-10-01T19:31:42","modified_gmt":"2025-10-01T17:31:42","slug":"opportunities-for-integration-into-an-erp-system","status":"publish","type":"kb","link":"https:\/\/guide.itscope.com\/en\/kb\/opportunities-for-integration-into-an-erp-system\/","title":{"rendered":"Opportunities for integration into an ERP system"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"1\">Preparations<\/h2>\n\n\n\n<p>Checklist for planning the project<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Identify <a href=\"https:\/\/guide.itscope.com\/en\/kb\/authentication-via-api-credentials\/\">API Key<\/a><\/li>\n\n\n\n<li>It must be possible to specify one\u00a0<a href=\"https:\/\/guide.itscope.com\/en\/kb\/authentication-via-api-credentials\/\">API Key<\/a> per client in the enterprise resource planning (ERP) system (alternatively at user level)<\/li>\n\n\n\n<li>Get to know the <a href=\"https:\/\/guide.itscope.com\/en\/kb\/basic-structure-of-the-api-url\/\">ITscope API<\/a>, this can be done\u00a0<a href=\"https:\/\/guide.itscope.com\/en\/kb\/interactive-api\/\">interactively<\/a><\/li>\n\n\n\n<li>Use prepared\u00a0<a href=\"https:\/\/guide.itscope.com\/en\/kb\/ready2go-api-clients-and-data-model-generation\/\">API clients<\/a>\u00a0and create a\u00a0<a href=\"https:\/\/guide.itscope.com\/en\/kb\/ready2go-api-clients-and-data-model-generation\/\">data model<\/a><\/li>\n\n\n\n<li>Set <a href=\"https:\/\/guide.itscope.com\/en\/kb\/mandatory-user-agent-in-api-requests\/\">user agent<\/a><\/li>\n\n\n\n<li>Take note of <a href=\"https:\/\/guide.itscope.com\/en\/kb\/api-limitations\/\">API limitations<\/a><\/li>\n\n\n\n<li>set <a href=\"https:\/\/guide.itscope.com\/en\/kb\/data-formats-and-output-formats\/\">data and output format<\/a><\/li>\n\n\n\n<li>Configure price list eServices with partners that offer this service. It is not enough to configure only the real-time eService. Without the price list eService, there are no prices in the export or via the API<\/li>\n\n\n\n<li>Try to create\u00a0<a href=\"https:\/\/guide.itscope.com\/en\/kb\/products-methods\/\">data exports<\/a>\u00a0if more than 5000 products are involved.\u00a0We recommend using exports. If a product selection is not possible via export, then the products can be added\/updated via\u00a0<a href=\"https:\/\/guide.itscope.com\/en\/kb\/products-search-method\/\">the API batch<\/a>\u00a0(up to 50 IDs)<\/li>\n\n\n\n<li>If <a href=\"https:\/\/guide.itscope.com\/en\/kb\/products-methods\/\">data exports<\/a>\u00a0are used, then the specification of one or more\u00a0<a href=\"https:\/\/guide.itscope.com\/en\/kb\/setting-up-a-data-export\/\">ExportIDs or ExportUrls<\/a>\u00a0must be possible<\/li>\n\n\n\n<li>Clarify whether <a href=\"https:\/\/guide.itscope.com\/en\/kb\/products-search-method\/\">price list line products<\/a> are of interest (i.e. products that are not in the ITscope catalogue)<\/li>\n\n\n\n<li>Clarify whether a re-import of an ITscope product should update the product data in the ERP system, i.e. overwrite any potential changes that were made yourself<\/li>\n\n\n\n<li>The installation of the integration should be as simple as possible<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"2\">Metadata<\/h2>\n\n\n\n<p>For an integration to take place at all, master data may have to be loaded.&nbsp;Changes in the&nbsp;master data are very rare, therefore we recommend matching the master data once a day or even only once a week.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/guide.itscope.com\/en\/kb\/company-metadata-methods\/\">Distributors<\/a> &#8211; mapping of creditors, suppliers and distributors in the ERP system onto ITscope supplier IDs<\/li>\n\n\n\n<li><a href=\"https:\/\/guide.itscope.com\/en\/kb\/company-metadata-methods\/\">Manufacturers<\/a> &#8211; mapping of manufacturers in the ERP system onto ITscope manufacturer IDs<\/li>\n\n\n\n<li><a href=\"https:\/\/guide.itscope.com\/en\/kb\/products-methods\/\">Product categories<\/a> &#8211; mapping the ERP categories onto\u00a0<a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-categories\/\">ITscope categories<\/a><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"3\">Adding and updating products<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/guide.itscope.com\/en\/kb\/data-formats-and-output-formats\/\">Adding products<\/a>\u00a0via API methods <a href=\"https:\/\/guide.itscope.com\/en\/kb\/products-methods\/\">directly via IDs<\/a> or <a href=\"https:\/\/guide.itscope.com\/en\/kb\/products-search-method\/\">product searches<\/a> or <a href=\"https:\/\/guide.itscope.com\/en\/kb\/products-methods\/\">data exports<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/guide.itscope.com\/en\/kb\/data-formats-and-output-formats\/\">Updating products<\/a>\u00a0via API methods <a href=\"https:\/\/guide.itscope.com\/en\/kb\/products-methods\/\">directly via IDs<\/a> or <a href=\"https:\/\/guide.itscope.com\/en\/kb\/products-search-method\/\">product searches<\/a> or <a href=\"https:\/\/guide.itscope.com\/en\/kb\/products-methods\/\">data exports<\/a><\/li>\n\n\n\n<li>Adding products in the ERP system\u00a0<a href=\"https:\/\/guide.itscope.com\/en\/kb\/send-product-data-directly-from-the-online-platform-itscope-com-to-your-own-application\/\">directly from the ITscope online platform<\/a>. Use the &#8216;Share&#8217; function to send to your own system<\/li>\n\n\n\n<li>Updating products in the ERP system <a href=\"https:\/\/guide.itscope.com\/en\/kb\/send-product-data-directly-from-the-online-platform-itscope-com-to-your-own-application\/\">directly from the ITscope online platform<\/a>. Use the &#8216;Share&#8217; function to send to your own system<\/li>\n\n\n\n<li>Evaluate <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-descriptions-and-product-texts\/\">product descriptions and extended texts<\/a><\/li>\n\n\n\n<li>Integrate product <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-datasheets-and-content-provider-selection-priority\/\">datasheets<\/a><\/li>\n\n\n\n<li>Integrate product <a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-pictures\/\">images<\/a><\/li>\n\n\n\n<li>Product\u00a0<a href=\"https:\/\/guide.itscope.com\/en\/kb\/format-description-for-products-data-format-standard\/\">sources of supply (&#8216;supplierItems&#8217;)<\/a><\/li>\n\n\n\n<li>Take note of\u00a0<a href=\"https:\/\/guide.itscope.com\/en\/kb\/product-condition-codes\/\">product condition codes<\/a><\/li>\n\n\n\n<li>Product <a href=\"https:\/\/guide.itscope.com\/en\/kb\/format-description-for-product-data-format-standardupdate\/\">prices and stock levels<\/a>: perhaps retrieve prices, stock levels and\u00a0<a href=\"https:\/\/guide.itscope.com\/en\/kb\/availability-status-codes\/\">availability status codes<\/a>\u00a0when adding quotes or orders<\/li>\n\n\n\n<li><a href=\"https:\/\/guide.itscope.com\/en\/kb\/format-description-for-products-data-format-standard\/\">Product accessories<\/a><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"4\">Orders<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Load <a href=\"https:\/\/guide.itscope.com\/en\/kb\/format-description-for-orders\/\">order metadata<\/a> via the <a href=\"https:\/\/guide.itscope.com\/en\/kb\/business-deals-methods\/\">order API<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/guide.itscope.com\/en\/kb\/business-deals-send-method\/\">Automatically send order from ERP system to the corresponding distributor via ITscope<\/a><\/li>\n\n\n\n<li>Import <a href=\"https:\/\/guide.itscope.com\/en\/kb\/business-documents-method\/\">ITscope order documents<\/a> into the ERP system as <a href=\"https:\/\/guide.itscope.com\/en\/kb\/order-and-quote-data-in-opentrans-2-1-format\/\">OpenTrans 2.1<\/a>\u00a0documents<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"5\">Quotes<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Load <a href=\"https:\/\/guide.itscope.com\/en\/kb\/format-description-for-quotes\/\">quote metadata<\/a> via the <a href=\"https:\/\/guide.itscope.com\/en\/kb\/business-quotes-methods\/\">quote API<\/a><\/li>\n\n\n\n<li>Import <a href=\"https:\/\/guide.itscope.com\/en\/kb\/business-documents-method\/\">ITscope quotes<\/a> into the ERP system as <a href=\"https:\/\/guide.itscope.com\/en\/kb\/order-and-quote-data-in-opentrans-2-1-format\/\">OpenTrans 2.1<\/a>\u00a0documents<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"6\">Development of a middleware application<\/h2>\n\n\n\n<p>Not every ERP system has a direct way to import or manipulate data via the database. There may also be no way to execute program code that you have written yourself. Therefore, it may be necessary to write your own application that encapsulates access to the database or the ERP API. This plugin or middleware application is used to communicate with the ERP system.<\/p>\n\n\n\n<p>The application must then be installed on each workstation in order to allow <a href=\"https:\/\/guide.itscope.com\/en\/kb\/send-product-data-directly-from-the-online-platform-itscope-com-to-your-own-application\/\">the &#8216;Share&#8217; function to be used on the ITscope platform<\/a>.<\/p>\n\n\n\n<p>More details can be found in the &#8216;<a href=\"https:\/\/guide.itscope.com\/en\/kb\/send-product-data-directly-from-the-online-platform-itscope-com-to-your-own-application\/\">Send product data directly from the online platform ITscope.com to your own application<\/a>&#8216; support article.<\/p>\n\n\n\n<p>For cloud applications, the control of a product or quote API can be accomplished through ITscope and credentials can be deposited (e.g. using oauth).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Preparations Checklist for planning the project Metadata For an integration to take place at all, master data may have to be loaded.&nbsp;Changes in the&nbsp;master data are very rare, therefore we &#8230;<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"kbtopic":[172],"kbtag":[],"class_list":["post-2419","kb","type-kb","status-publish","hentry","kbtopic-api-export-connection"],"_links":{"self":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/2419","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=2419"}],"version-history":[{"count":4,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/2419\/revisions"}],"predecessor-version":[{"id":19365,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/2419\/revisions\/19365"}],"wp:attachment":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/media?parent=2419"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kbtopic?post=2419"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kbtag?post=2419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}