Format description for product data format standardUpdate

Last modified: 14. October 2022

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 this article.

Overview of data format elements

In CSV output format, these elements are files, in XML or JSON output format these are nodes.

The data format standardUpdate consists of the following elements:

  • Product: product from the ITscope catalogue.
  • SupplierItem: source of supply for an ITscope product. A specific product offering from a distributor listed on ITscope.
  • Project: price, availability and further information on a project item.

Elements marked with a globe vary depending on the selected export language:

Dieses Bild hat ein leeres Alt-Attribut. Der Dateiname ist globus-1.png

product

Product from the ITscope catalogue.

NameCompulsory fieldData typeDescription
puid longUnique key
price BigDecimalPrice basis for the calculated price
priceCalc BigDecimalCalculated price, based on the individual price calculation
currencyCode String (3)Currency unit that applies to this price information
priceCalcVat BigDecimalSales tax rate that was used to determine the calculated price
priceLastUpdate DateTime of last update of price information
priceSupplierId longReference to a supplier (1:1) who has provided the source of supply with this price information
priceSupplierName String (255)Name of the supplier that provided this source of supply
priceSupplierItemId longReference to a source of supply (n:1); if this field is zero, then the price information refers to a product (source of supply reference and product reference are mutually exclusive)
priceSupplierSKU String (150)Product identifier given by the supplier that provided this source of supply [was String(40) before 18/10/2021]
stockSupplierText String (40)Textual inventory information of the supplier, directly taken over, without interpretation
stockStatus IntegerNumeric key of the delivery status of the inventory information
stockStatusText String (255)Delivery status of inventory information, such as ‘in stock’ or ‘in field warehouse’
stock IntegerQuantity of products for the delivery status indicated in this structure
externalStock IntegerExternal stock (additional information provided by some suppliers in structures with ‘in stock’ delivery status)
incomingStock IntegerStock quantity that will be replenished (additional information provided by some suppliers in structures with ‘in stock’ delivery status)
stockAvailabilityDate DateDelivery date for products that are not in stock
stockLastUpdate DateTime of last update of inventory information
aggregatedStatusYesIntegerBest availability status
aggregatedStatusTextYesString (20)Best availability status
aggregatedStockYesIntegerSum of all stock levels
aggregatedSupplierItemsYesIntegerSum of all distributors offering this product
priceBillingPeriodIntegerLength of the price billing period
priceBillingPeriodUnitString (40)Unit of the price billing period (e.g. “Years”, “Month”)
priceSubscriptionPeriodIntegerLength of the price subscription period
priceSubscriptionPeriodUnitString (40)Unit of the price subscription period (e.g. “Years”, “Month”)
supplierItemYesList <supplierItem>Source of supply of an ITscope product. A specific offer from a distributor listed on ITscope.

supplierItem

Source of supply for an ITscope product. A specific offering from a distributor listed on ITscope.

NameCompulsory fieldData typeDescription
idYeslongUnique key
supplierSKU String (150)Product number of the supplier [was String(40) before 18/10/2021]
supplierIdYeslongRefers 1:1 to Supplier.id
supplierName String (255)Name of Supplier
priceYesBigDecimalPrice
priceCalcYesBigDecimalCalculated price, based on the individual price calculation
currencyCodeYesString (3)Currency unit that applies to this price information
priceCalcVatYesBigDecimalSales tax rate that was used to determine the calculated price
priceLastUpdateYesDateTime of last update of price information
stockSupplierText StringStock information on the source of supply, as given by the supplier
stockStatus IntegerNumeric key for the delivery status of the inventory information
stockStatusText String (255)Delivery status of inventory information, such as ‘in stock’ or ‘in field warehouse’
stock IntegerStock level
externalStock IntegerExternal stock (additional information provided by some suppliers in structures with ‘in stock’ delivery status)
incomingStock IntegerStock quantity that will be replenished (additional information provided by some suppliers in structures with ‘in stock’ delivery status)
stockAvailabilityDate DateDelivery date for products that are not in stock
lastStockUpdate DateTime of last update of inventory information
priceBillingPeriodIntegerLength of the price billing period
priceBillingPeriodUnitString (40)Unit of the price billing period (e.g. “Years”, “Month”)
priceSubscriptionPeriodIntegerLength of the price subscription period
priceSubscriptionPeriodUnitString (40)Unit of the price subscription period (e.g. “Years”, “Month”)

project

Price, availability and further information on a project agreement.

nameCompulsory fieldData typedescription
supplierProjectId String (40)Project number of the supplier
manufacturerProjectIdYesString (40)Project number of the manufacturer (unique key)
priceYesBigDecimalProject price
remainingQuantityYesIntegerRemaining quota that can be ordered
projectLastUpdate DateTime of last update of project information
projectBundleIdString (50)Unique key of the project bundle (activation via ITscope test lab)
projectPositionIntegerProject line item number (activation via ITscope test lab)

Database scripts for CSV

Was this article helpful?
Dislike 0
Views: 170