This overview of the data groups contains an overview of all fields from the export and API, regardless of the data formats.
Meaning of colours:
- Fields that have been added in API 2.1 do not exist in API 1.0
- Fields with changed name. These fields are present in both API versions, but with different names.
- Fields that are no longer present in API 2.1 and are only available in API 1.0. These fields have been moved to other files, or were not filled with data or simply not useful.
Deprecated
- TextContent
- ContentTag
- KeyContent
- ContentModel
- FeatureContent
- ExportMetadata
- RatingContent
- ContentProvider
- MediaContent
- FeatureModel
- FilteredOutProduct
- ContentCategory
- Warning
- SetGroup
- Supplier
- Manufacturer
Quote
| Name Api 1.0 | Pfade Api 1.0 | Name Api 2.1 | Pfade Api 2.1 | Daten- formate Api 2.1 |
|---|---|---|---|---|
| quoteId | Quote/quoteId | quoteId | quote/quoteId | |
| quoteNo | Quote/quoteNo | quoteNo | quote/quoteNo | |
| shortUrl | Quote/shortUrl | shortUrl | quote/shortUrl | |
| name | Quote/name | name | quote/name | |
| status | Quote/status | status | quote/status | |
| validUntil | Quote/validUntil | validUntil | quote/validUntil | |
| itemCount | Quote/itemCount | itemCount | quote/itemCount | |
| lastModified | Quote/lastModified | lastModified | quote/lastModified | |
| organisation | Quote/organisation | organisation | quote/organisation | |
| person | Quote/person | person | quote/person |
SupplierItem
| Name Api 1.0 | Pfade Api 1.0 | Name Api 2.1 | Pfade Api 2.1 | Daten- formate Api 2.1 |
|---|---|---|---|---|
| prodRefId | SupplierItem/prodRefId SupplierItemStock/prodRefId | productId | supplierItem /productId | standard standardUpdate |
| id | SupplierItem/id SupplierItemStock/id | id | supplierItem/id | standard standardUpdate |
| priceInfo | SupplierItem/priceInfo | |||
| supplierItemId | Product/supplierItemId SupplierItem/supplierItemId SupplierItemStock/supplierItemId | supplierSKU | supplierItem/supplierSKU | standard standardUpdate |
| productName | SupplierItem/productName | productName | supplierItem/productName | standard |
| infoText | SupplierItem/infoText | |||
| description | Product/description | |||
| supRefId | SupplierItem/supRefId SupplierItemStock/supRefId | supplierId | supplierItem/supplierId | standard standardUpdate |
| supplier | SupplierItem/supplier | |||
| setRefId | SupplierItem/setRefId SupplierItemStock/setRefId | |||
| manRefId | SupplierItem/manRefId SupplierItemStock/manRefId | |||
| newProduct | SupplierItem/newProduct | |||
| eolProduct | SupplierItem/eolProduct | eolProduct | supplierItem/eolProduct | standard |
| supplierPromo | SupplierItem/supplierPromo | promotion | supplierItem/promotion | standard |
| stateId | SupplierItem/stateId | conditionId | supplierItem/conditionId | standard |
| stateName | SupplierItem/stateName | conditionName | supplierItem/conditionName | standard |
| vat | SupplierItem/vat | vat | supplierItem/vat | standard |
| warranty | SupplierItem/warranty | warrantyText | supplierItem/warrantyText | standard |
| grossDimX | SupplierItem/grossDimX | grossDimX | supplierItem/grossDimX | standard |
| grossDimY | SupplierItem/grossDimY | grossDimY | supplierItem/grossDimY | standard |
| grossDimZ | SupplierItem/grossDimZ | grossDimZ | supplierItem/grossDimZ | standard |
| deeplink | SupplierItem/deeplink | deeplink | supplierItem/deeplink | standard |
| supplierEan | SupplierItem/supplierEan | ean | supplierItem/ean | standard |
| supplierStockText | SupplierItem/supplierStockText SupplierItemStock/supplierStockText | stockSupplierText | supplierItem/stockSupplierText | standard standardUpdate |
| supplierManufacturerSKU | SupplierItem/supplierManufacturerSKU | manufacturerSKU | supplierItem/manufacturerSKU | standard |
| supplierManufacturerName | SupplierItem/supplierManufacturerName | manufacturerName | supplierItem/manufacturerName | standard |
| recRetailPrice | SupplierItem/recRetailPrice | recommendedRetailPriceNet | supplierItem/recommendedRetailPriceNet | standard |
| specialOffer | SupplierItem/specialOffer | specialOffer | supplierItem/specialOffer | standard |
| topSeller | SupplierItem/topSeller | |||
| flatCharge | SupplierItem/flatCharge | copyrightLevy | supplierItem/copyrightLevy | standard |
| custTariffNumber | SupplierItem/custTariffNumber | customsTariffNumber | supplierItem/customsTariffNumber | standard |
| sourceCountry | SupplierItem/sourceCountry | countryOfOrigin | supplierItem/countryOfOrigin | standard |
| eanValid | SupplierItem/eanValid | eanValid | supplierItem/eanValid | standard |
| matchQuality | SupplierItem/matchQuality | matchQuality | supplierItem/matchQuality | standard |
| externalStock | supplierItem/externalStock | standard standardUpdate | ||
| incomingStock | supplierItem/incomingStock | standard standardUpdate | ||
| stock | Product/stock SupplierItem/stock SupplierItemStock/stock | stock | supplierItem/stock | standard standardUpdate |
| lastStockUpdate | SupplierItem/lastStockUpdate SupplierItemStock/lastStockUpdate | lastStockUpdate | supplierItem/lastStockUpdate | standard standardUpdate |
| stockStatus | Product/stockStatus SupplierItem/stockStatus SupplierItemStock/stockStatus | stockStatus | supplierItem/stockStatus | standard standardUpdate |
| stockStatusText | Product/stockStatusText SupplierItem/stockStatusText SupplierItemStock/stockStatusText | stockStatusText | supplierItem/stockStatusText | standard standardUpdate |
| stockAvailabilityDate | SupplierItem/stockAvailabilityDate SupplierItemStock/stockAvailabilityDate | stockAvailabilityDate | supplierItem/stockAvailabilityDate | standard standardUpdate |
| stockSourceId | SupplierItem/stockSourceId SupplierItemStock/stockSourceId | |||
| stockSourceName | SupplierItem/stockSourceName SupplierItemStock/stockSourceName | |||
| stockUnlimited | SupplierItem/stockUnlimited SupplierItemStock/stockUnlimited | |||
| supplierName | supplierItem/supplierName | standard standardUpdate |
RefContent
| Name Api 1.0 | Pfade Api 1.0 | Name Api 2.1 | Pfade Api 2.1 | Daten- formate Api 2.1 |
|---|---|---|---|---|
| prodRefId | RefContent/prodRefId | productId | accessory/productId | standard |
| contentProvider | RefContent/contentProvider | |||
| contentModelRefId | RefContent/contentModelRefId | |||
| contentModel | RefContent/contentModel | |||
| contentProviderRefId | RefContent/contentProviderRefId | |||
| key | RefContent/key | |||
| crossProdRefId | RefContent/crossProdRefId | referencedProductId | accessory/referencedProductId | standard |
| typeId | RefContent/typeId | typeId | accessory/typeID | standard |
| type | RefContent/type | type | accessory/type | standard |
| originalReference | RefContent/originalReference |
Deal
| Name Api 1.0 | Pfade Api 1.0 | Name Api 2.1 | Pfade Api 2.1 | Daten-formate Api 2.1 |
|---|---|---|---|---|
| orderId | Deal/orderId | orderId | deal/orderId | |
| customerOrderId | Deal/customerOrderId | customerOrderId | deal/customerOrderId | |
| status | Deal/status | status | deal/status | |
| statusMessage | Deal/statusMessage | statusMessage | deal/statusMessage | |
| statusDate | Deal/statusDate | statusDate | deal/statusDate | |
| company | Deal/company | |||
| companyId | deal/companyId |
Product
| Name Api 1.0 | Pfade Api 1.0 | Name Api 2.1 | Pfade Api 2.1 | Daten- formate Api 2.1 |
|---|---|---|---|---|
| puid | Product/puid ProductStock/puid Report/puid | puid | product/puid | standard standardUpdate |
| manufacturerName | product/manufacturerName | standard | ||
| supplierItem | Product/supplierItem | |||
| featureContent | Product/featureContent | |||
| productName | Product/productName Report/productName | product/productName | standard | |
| bechlemId | product/bechlemId | standard | ||
| icecatId | product/icecatId | standard | ||
| ratingContent | Product/ratingContent | |||
| refContent | Product/refContent | |||
| textContent | Product/textContent | |||
| keyContent | Product/keyContent | |||
| mediaContent | Product/mediaContent | |||
| qualification | Product/qualification | qualification | product/qualification | standard |
| bestImageLink | Product/bestImageLink | image1 | product/image1 | standard |
| vat | Product/vat | |||
| set | Product/set | |||
| setRefId | Product/setRefId | productTypeId | product/productTypeId | standard |
| manRefId | Product/manRefId | manufacturerId | product/manufacturerId | standard |
| man | Product/man | |||
| ean | Product/ean Report/ean | ean | product/ean | standard |
| manufacturerSKU | Product/manufacturerSKU Report/manufacturerSKU | manufacturerSKU | product/manufacturerSKU | standard |
| shortInfo | Product/shortInfo Report/shortInfo | shortDescription | product/shortDescription | standard |
| marketingText | product/marketingText | standard | ||
| longDescription | product/longDescription | standard | ||
| htmlSpecs | product/htmlSpecs | standard | ||
| warrantyText | product/warrantyText | standard | ||
| rank | Product/rank Report/rank | rank | product/rank | standard |
| relevance | Product/relevance | |||
| grossDimX | Product/grossDimX | grossDimX | product/grossDimX | standard |
| grossDimY | Product/grossDimY | grossDimY | product/grossDimY | standard |
| grossDimZ | Product/grossDimZ | grossDimZ | product/grossDimZ | standard |
| recRetailPrice | Product/recRetailPrice | recommendedRetailPriceNet | product/recommendedRetailPriceNet | standard |
| estimateGrossWeight | Product/estimateGrossWeight | estimateGrossWeight | product/estimateGrossWeight | standard |
| deeplink | Product/deeplink | deeplink | product/deeplink | standard |
| standardHtmlDatasheet | product/standardHtmlDatasheet | standard | ||
| standardPdfDatasheet | product/standardPdfDatasheet | standard | ||
| manufacturerDatasheet | product/manufacturerDatasheet | standard | ||
| entryDate | Product/entryDate | entryDate | product/entryDate | standard |
| manufacturerSite | Product/manufacturerSite | manufacturerSite | product/manufacturerSite | standard |
| productType | Product/productType Report/productType | productSubType | product/productSubType | standard |
| productSubTypeId | product/productSubTypeId | standard | ||
| productLine | Product/productLine | productLine | product/productLine | standard |
| productLineId | product/productLineId | standard | ||
| productModel | Product/productModel | productModel | product/productModel | standard |
| aggregatedStatus | Product/aggregatedStatus ProductStock/aggregatedStatus | aggregatedStatus | product/aggregatedStatus | standard standardUpdate |
| aggregatedStatusText | Product/aggregatedStatusText ProductStock/aggregatedStatusText | aggregatedStatusText | product/aggregatedStatusText | standard standardUpdate |
| aggregatedStock | Product/aggregatedStock ProductStock/aggregatedStock Report/aggregatedStock | aggregatedStock | product/aggregatedStock | standard standardUpdate |
| aggregatedSupplierItems | Product/aggregatedSupplierItems ProductStock/aggregatedSupplierItems | aggregatedSupplierItems | product/aggregatedSupplierItems | standard standardUpdate |
| bestDescription | Product/bestDescription | |||
| featureAttribute1 | Product/featureAttribute1 Report/featureAttribute1 | attributeValue1 | product/attributeValue1 | standard |
| featureAttribute2 | Product/featureAttribute2 Report/featureAttribute2 | attributeValue2 | product/attributeValue2 | standard |
| featureAttribute3 | Product/featureAttribute3 Report/featureAttribute3 | attributeValue3 | product/attributeValue3 | standard |
| featureAttribute4 | Product/featureAttribute4 Report/featureAttribute4 | attributeValue4 | product/attributeValue4 | standard |
| featureAttribute5 | Product/featureAttribute5 Report/featureAttribute5 | attributeValue5 | product/attributeValue5 | standard |
| minPriceInfo | Product/minPriceInfo | |||
| maxPriceInfo | Product/maxPriceInfo | |||
| cnetId | product/cnetId | standard | ||
| customsTariffNumber | product /customsTariffNumber | standard | ||
| eClass | product/eClass | standard | ||
| imageThumb | product/imageThumb | standard | ||
| image2 | product/image2 | standard | ||
| image3 | product/image3 | standard | ||
| image4 | product/image4 | standard | ||
| image5 | product/image5 | standard | ||
| energyLabel | product/energyLabel | standard |
Set
| Name Api 1.0 | Pfade Api 1.0 | Name Api 2.1 | Pfade Api 2.1 | Daten- formate Api 2.1 |
|---|---|---|---|---|
| id | Product/id Set/id | id | productType/id | standard |
| name | Product/name Report/name Set/name | name | product/name | standard |
| attributeTypeId1 | Product/attributeTypeId1 Set/attributeTypeId1 | attributeTypeId1 | product/attributeTypeId1 | standard |
| attributeTypeName1 | Product/attributeTypeName1 Set/attributeTypeName1 | attributeTypeName1 | product/attributeTypeName1 | standard |
| attributeTypeId2 | Product/attributeTypeId2 Set/attributeTypeId2 | attributeTypeId2 | product/attributeTypeId2 | standard |
| attributeTypeName2 | Product/attributeTypeName2 Set/attributeTypeName2 | attributeTypeName2 | product/attributeTypeName2 | standard |
| attributeTypeId3 | Product/attributeTypeId3 Set/attributeTypeId3 | attributeTypeId3 | product/attributeTypeId3 | standard |
| attributeTypeName3 | Product/attributeTypeName3 Set/attributeTypeName3 | attributeTypeName3 | product/attributeTypeName3 | standard |
| attributeTypeId4 | Product/attributeTypeId4 Set/attributeTypeId4 | attributeTypeId4 | product/attributeTypeId4 | standard |
| attributeTypeName4 | Product/attributeTypeName4 Set/attributeTypeName4 | attributeTypeName4 | product/attributeTypeName4 | standard |
| attributeTypeId5 | Product/attributeTypeId5 Set/attributeTypeId5 | attributeTypeId5 | product/attributeTypeId5 | standard |
| attributeTypeName5 | Product/attributeTypeName5 Set/attributeTypeName5 | attributeTypeName5 | product/attributeTypeName5 | standard |
| grpRefId | Set/grpRefId | productTypeGroupRefId | product/productTypeGroupRefId | standard |
| group | Set/group |
Company
| Name Api 1.0 | Pfade Api 1.0 | Name Api 2.1 | Pfade Api 2.1 | Daten- formate Api 2.1 |
|---|---|---|---|---|
| name | Company/name | name | company/name vendor/name | |
| manufacturer | Company/manufacturer | |||
| manufacturerId | company/manufacturerId | |||
| supplier | Company/supplier | |||
| supplierId | company/supplierId vendor/supplierId |
Log
| Name Api 1.0 | Pfade Api 1.0 | Name Api 2.1 | Pfade Api 2.1 | Datenformate Api 2.1 |
|---|---|---|---|---|
| id | log/id | standard standardUpdate | ||
| cause | log/cause | standard standardUpdate | ||
| eventid | log/eventid | standard standardUpdate |
StockInfo
| Name Api 1.0 | Pfade Api 1.0 | Name Api 2.1 | Pfade Api 2.1 | Daten- formate Api 2.1 |
|---|---|---|---|---|
| stockSupplierText | product/stockSupplierText | standard standardUpdate | ||
| stock | product/stock | standard standardUpdate | ||
| externalStock | product/externalStock | standard standardUpdate | ||
| incomingStock | product/incomingStock | standard standardUpdate | ||
| stockLastUpdate | product/stockLastUpdate | standard standardUpdate | ||
| stockStatus | product/stockStatus | standard standardUpdate | ||
| stockStatusText | product/stockStatusText | standard standardUpdate | ||
| stockAvailabilityDate | product/stockAvailabilityDate | standard standardUpdate |
PriceInfo
| Name Api 1.0 | Pfade Api 1.0 | Name Api 2.1 | Pfade Api 2.1 | Daten- formate Api 2.1 |
|---|---|---|---|---|
| prodRefId | PriceInfo/prodRefId ProductPriceInfo/prodRefId | |||
| supItemRefId | PriceInfo/supItemRefId SupplierItemPriceInfo/supItemRefId | priceSupplierItemId | product/priceSupplierItemId | standard standardUpdate |
| supRefId | PriceInfo/supRefId PriceInfoSingle/supRefId Product/supRefId ProductPriceInfo/supRefId SupplierItemPriceInfo/supRefId | priceSupplierId | product/priceSupplierId | standard standardUpdate |
| priceSupplierSKU | product/priceSupplierSKU | standard standardUpdate | ||
| priceSupplierName | product/priceSupplierName | standard standardUpdate | ||
| currencyCode | PriceInfo/currencyCode PriceInfoSingle/currencyCode ProductPriceInfo/currencyCode SupplierItemPriceInfo/currencyCode | currencyCode | product/currencyCode supplierItem/currencyCode | standard standardUpdate |
| minScale | PriceInfo/minScale PriceInfoSingle/minScale ProductPriceInfo/minScale SupplierItemPriceInfo/minScale | minScale | standard | |
| price | PriceInfo/price PriceInfoSingle/price Product/price ProductPriceInfo/price Report/price SupplierItemPriceInfo/price | price | supplierItem/price | standard standardUpdate |
| type | PriceInfo/type PriceInfoSingle/type Product/type ProductPriceInfo/type SupplierItemPriceInfo/type | |||
| lastUpdate | PriceInfo/lastUpdate PriceInfoSingle/lastUpdate Product/lastUpdate ProductPriceInfo/lastUpdate SupplierItemPriceInfo/lastUpdate | priceLastUpdate | product/priceLastUpdate supplierItem/priceLastUpdate | standard standardUpdate |
| priceSourceId | PriceInfo/priceSourceId PriceInfoSingle/priceSourceId Product/priceSourceId ProductPriceInfo/priceSourceId SupplierItemPriceInfo/priceSourceId | |||
| priceSourceName | PriceInfo/priceSourceName PriceInfoSingle/priceSourceName Product/priceSourceName ProductPriceInfo/priceSourceName SupplierItemPriceInfo/priceSourceName | |||
| calcPrice | PriceInfo/calcPrice PriceInfoSingle/calcPrice ProductPriceInfo/calcPrice SupplierItemPriceInfo/calcPrice | priceCalc | product/priceCalc supplierItem/priceCalc | standard standardUpdate |
| calcPriceBase | PriceInfo/calcPriceBase PriceInfoSingle/calcPriceBase ProductPriceInfo/calcPriceBase SupplierItemPriceInfo/calcPriceBase | price | product/price | standard standardUpdate |
| priceCalcVat | product/priceCalcVat supplierItem/priceCalcVat | standard standardUpdate |
ProdXRefCluster
| Name Api 1.0 | Pfade Api 1.0 | Name Api 2.1 | Pfade Api 2.1 | Daten- formate Api 2.1 |
|---|---|---|---|---|
| prodRefId | ProductXRefAttributeCluster/prodRefId | productRefId | products2Cluster/productRefId | standard |
| attributeClusterRefId | ProductXRefAttributeCluster/attributeClusterRefId | attributeClusterRefId | products2Cluster/attributeClusterRefId | standard |
Cluster
| Name Api 1.0 | Pfade Api 1.0 | Name Api 2.1 | Pfade Api 2.1 | Daten-formate Api 2.1 |
|---|---|---|---|---|
| id | AttributeCluster/id | id | attributeCluster/id | standard |
| name | AttributeCluster/name | name | attributeCluster/name | standard |
| min | AttributeCluster/min | min | attributeCluster/min | standard |
| max | AttributeCluster/max | max | attributeCluster/max | standard |
| setId | AttributeCluster/setId | productTypeId | attributeCluster/productTypeId | standard |
| rank | AttributeCluster/rank | rank | attributeCluster/rank | standard |
| attributeTypeId | AttributeCluster/attributeTypeId | attributeTypeId | attributeCluster/attributeTypeId | standard |
| attributeTypeName | AttributeCluster/attributeTypeName | attributeTypeName | attributeCluster/attributeTypeName | standard |
| attributeTypeRank | AttributeCluster/attributeTypeRank | attributeTypeRank | attributeCluster/attributeTypeRank | standard |
| attributeTypeUnit | AttributeCluster/attributeTypeUnit | attributeTypeUnit | attributeCluster/attributeTypeUnit | standard |
| attributeTypeGroupName | AttributeCluster/attributeTypeGroupName | attributeTypeGroupName | attributeCluster/attributeTypeGroupName | standard |
| attributeTypeGroupId | AttributeCluster/attributeTypeGroupId | attributeTypeGroupId | attributeCluster/attributeTypeGroupId | standard |
| productTypeName | attributeCluster/productTypeName | standard |