Read previously out the subject data formats and output formats to make sure that you will use this data format.

Database diagram

Abhängigkeitsdiagram the csv output format, including SQL scripts for generating the tables and to load the data with loadData local infile at the end of the contribution.

Overview of data format elements

In csv output format, these elements are files, in xml or json output format it is nodes.

The data format standard consists of the following elements:

  • Product: - Product of the ITscope catalog.
  • ProductPriceInfo: - Calculated price information for a product. Is only present if from the supplier deposited within the platform pricing rules , a product may be selected and calculated.
  • ProductStockInfo: - Availability information of the source selected in productPriceInfo.
  • SupplierItem: - Reference source of an ITscope product. A specific offer from an ITScope listed distributor.
  • Supplier: - supplier of a reference source.
  • SupplierPriceInfo: - Price data for a reference source. For each configured price source, a PriceInfo is stored, eg Realtime, individual price list, generally available price list. For some vendors, no generally available prices are listed, here the supplierPriceInfo is empty, if no own price list has been configured.
  • SupplierStockInfo: - Availability information for the source of supply.

product

Product of the ITscope catalog.

name Compulsory field Data type description
puid Yes long Unique key
productPriceInfo   productPriceInfo Calculated price information for a product. Is only present if from the supplier deposited within the platform pricing rules , a product may be selected and calculated.
productStockInfo   productStockInfo Availability information of the source selected in productPriceInfo.
supplierItem Yes List <supplierItem> Reference source of an ITscope product. A specific offer from an ITScope listed distributor.

productPriceInfo

Calculated price information for a product. Is only present if from the supplier deposited within the platform pricing rules , a product may be selected and calculated.

name Compulsory field Data type description
price Yes BigDecimal Price based on the closing price
priceCalc Yes BigDecimal Calculated price, based on the individual pricing
currencyCode Yes String (3) Currency unit that applies to this price information
priceCalcVat Yes BigDecimal Sales tax rate to calculate the calculated price was used
priceLastUpdate Yes Date Time of last update of price information
minScale Yes Integer Price from season
priceSourceId Yes Integer Identifier for the source of price information
priceSourceName   String (255) Readable text on the origin of the price information, eg "Individual price list"
priceStatus Yes String (255) Textual information on price retrieval, eg "The retrieval of the data was successful"
in the present circumstancesHier, an Yes long Reference to a supplier (1: 1) who has provided the source with this price information
priceSupplierName Yes String (255) Name of the supplier who provided this reference source
priceSupplierItemId Yes long Reference to a reference source (n: 1); If this field is zero, the price information refers to a product (reference source reference and product reference are mutually exclusive)
in the present circumstancesHier, an Yes String (40) Product identifier of the supplier who provided this reference source

productStockInfo

Availability information of the source selected in productPriceInfo.

name Compulsory field Data type description
stockSupplierText   String (40) Textual inventory information of the supplier, directly taken over, without interpretation
stockStatus Yes Integer Numeric key of the delivery status of the inventory information
stockStatusText Yes String (255) Delivery status of inventory information , such as "in stock" or "outdoor storage"
floor Yes Integer Quantity of the delivery status indicated in this structure
externalStock   Integer External stock in stock (additional information from suppliers in structures of delivery status "in stock")
incomingStock   Integer Quantity in stock (additional information from some suppliers in delivery status "in stock")
stockAvailabilityDate   Date Delivery date for goods not in stock
stockLastUpdate Yes Date Time of last update of inventory information
stockSourceId Yes Integer Numeric key of the source of asset information
stockSourceName Yes String (255) Source of stock information , eg "Individual price list"
stockUnlimited Yes Boolean Indicates whether the goods of this stock information are available in an unlimited quantity

supplierItem

Reference source of an ITscope product. A specific offer from an ITScope listed distributor.

name Compulsory field Data type description
id Yes long Unique key
supplierSKU   String (40) Product number of the supplier
supplier Yes supplier Refers 1: 1 to Supplier.id
supplierPriceInfo   List <supplierPriceInfo> Price data to a reference source. For each configured price source, a PriceInfo is stored, eg Realtime, individual price list, generally available price list. For some vendors, no generally available prices are listed, here the supplierPriceInfo is empty, if no own price list has been configured.
supplierStockInfo   List <supplierStockInfo> Availability information of the source of supply.

supplier

Supplier of a reference source.

name Compulsory field Data type description
id Yes long Unique key
name Yes String (255) Identifier of the supplier
deeplink Yes String (2048) URL, link to the supplier within the ITscope platform
customerAccountNumber   String (255) Customer number in case of partnership. Can be used as a filter to determine if there is a partnership with this supplier

supplierPriceInfo

Price data to a reference source. For each configured price source, a PriceInfo is stored, eg Realtime, individual price list, generally available price list. For some vendors, no generally available prices are listed, here the supplierPriceInfo is empty, if no own price list has been configured.

name Compulsory field Data type description
price Yes BigDecimal Price based on the closing price
priceCalc Yes BigDecimal Calculated price, based on the individual pricing
currencyCode Yes String (3) Currency unit that applies to this price information
priceCalcVat Yes BigDecimal Sales tax rate to calculate the calculated price was used
priceLastUpdate Yes Date Time of last update of price information
minScale Yes Integer Price from season
priceSourceId Yes Integer Identifier for the source of price information
priceSourceName   String (255) Readable text on the origin of the price information, eg "Individual price list"
priceStatus Yes String (255) Textual information on price retrieval, eg "The retrieval of the data was successful"

supplierStockInfo

Availability information of the source of supply.

name Compulsory field Data type description
stockSupplierText   String (40) Textual inventory information of the supplier, directly taken over, without interpretation
stockStatus Yes Integer Numeric key of the delivery status of the inventory information
stockStatusText Yes String (255) Delivery status of inventory information , such as "in stock" or "outdoor storage"
floor Yes Integer Quantity of the delivery status indicated in this structure
externalStock   Integer External stock in stock (additional information from suppliers in structures of delivery status "in stock")
incomingStock   Integer Quantity in stock (additional information from some suppliers in delivery status "in stock")
stockAvailabilityDate   Date Delivery date for goods not in stock
stockLastUpdate Yes Date Time of last update of inventory information
stockSourceId Yes Integer Numeric key of the source of asset information
stockSourceName Yes String (255) Source of stock information , eg "Individual price list"
stockUnlimited Yes Boolean Indicates whether the goods of this stock information are available in an unlimited quantity

Database scripts for CSV

Note: This page has been translated with the Google Translation Service.

Have more questions? Submit a request