Source<\/td> String<\/td> “Itscope” when ITscope’s tag was entered, “supplier” for tags automatically generated from read-in data<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nFeatureModel<\/h4>\n\n\n\n As supplied by the ContentProvider<\/p>\n\n\n\nfield<\/td> Data type<\/td> description<\/td><\/tr><\/thead> id<\/td> Long<\/td> Unique key<\/td><\/tr> name<\/td> String<\/td> Name of the property<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nAttributeCluster<\/h4>\n\n\n\n Value ranges or characteristics of a product property<\/p>\n\n\n\nfield<\/td> Data type<\/td> description<\/td><\/tr><\/thead> id<\/td> Long<\/td> Unique key<\/td><\/tr> SetId<\/td> Long<\/td> Refers to Set.id 1: 1, but can also be null if the cluster is assigned to a general set<\/td><\/tr> name<\/td> String<\/td> Identifier of the expression (eg 2 GB, 15 “, 80 W – 120 W, …)<\/td><\/tr> Min<\/td> String<\/td> Mininimal limit with respect to a property in which the expression of the product must fall in order to be assigned to this attribute cluster<\/td><\/tr> Max<\/td> String<\/td> Maximum limit with respect to a property in which the value of the product must fall in order to be assigned to this attribute cluster<\/td><\/tr> Rank<\/td> Long<\/td> Rank of the property<\/td><\/tr> AttributeTypeId<\/td> Long<\/td> Identifies a property and identifies attributeTypeName, attributeTypeRank, and attributeTypeUnit. No table reference. Refer to Set.attributeTypeId (1..5)<\/td><\/tr> AttributeTypeName<\/td> String<\/td> Name of a property. Can be the same as the name from Set.attributeTypeName (1..5)<\/td><\/tr> AttributeTypeRank<\/td> Long<\/td> Ranking of the property, for example, can be used for sorting<\/td><\/tr> AttributeTypeUnit<\/td> String<\/td> Unit of the property<\/td><\/tr> AttributeTypeGroupId<\/td> String<\/td> Identifier of a property group, no table reference, but uniquely identifies attributeTypeGroupName<\/td><\/tr> AttributeTypeGroupName<\/td> String<\/td> Name of a property group<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nAlten<\/h4>\n\n\n\n manufacturer<\/p>\n\n\n\nfield<\/td> Data type<\/td> description<\/td><\/tr><\/thead> id<\/td> Long<\/td> Unique key<\/td><\/tr> name<\/td> String<\/td> Identifier of the manufacturer<\/td><\/tr> ShortName<\/td> String<\/td> Manufacturer’s nickname<\/td><\/tr> Deeplink<\/td> String<\/td> URL, link to the manufacturer within the ITscope platform<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nSupplier<\/h4>\n\n\n\n Suppliers<\/p>\n\n\n\nfield<\/td> Data type<\/td> description<\/td><\/tr><\/thead> id<\/td> Long<\/td> Unique key<\/td><\/tr> name<\/td> String<\/td> Identifier of the manufacturer<\/td><\/tr> Deeplink<\/td> String<\/td> URL, link to the supplier within the ITscope platform<\/td><\/tr> partner<\/td> String<\/td> Customer number in case of partnership. Can be used as a filter to determine whether there is a partnership for this supplier<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nset<\/h4>\n\n\n\n Product types<\/p>\n\n\n\nfield<\/td> Data type<\/td> description<\/td><\/tr><\/thead> id<\/td> Long<\/td> Unique key<\/td><\/tr> GrpRefId<\/td> String<\/td> Refers to SetGroup.id<\/td><\/tr> name<\/td> String<\/td> Identifier of the product type<\/td><\/tr> AttributeTypeId1<\/td> Long<\/td> Unique attribute key to build a possible subcategory, 1: n points to AttributeCluster.attributeTypeId<\/td><\/tr> AttributeTypeName1<\/td> String<\/td> Identifier of the attribute to build up a possible subcategory<\/td><\/tr> AttributeTypeId2<\/td> Long<\/td> Unique attribute key to build a possible subcategory, 1: n points to AttributeCluster.attributeTypeId<\/td><\/tr> AttributeTypeName2<\/td> String<\/td> Identifier of the attribute to build up a possible subcategory<\/td><\/tr> AttributeTypeId3<\/td> Long<\/td> Unique attribute key to build a possible subcategory, 1: n points to AttributeCluster.attributeTypeId<\/td><\/tr> AttributeTypeName3<\/td> String<\/td> Identifier of the attribute to build up a possible subcategory<\/td><\/tr> AttributeTypeId4<\/td> Long<\/td> Unique attribute key to build a possible subcategory, 1: n points to AttributeCluster.attributeTypeId<\/td><\/tr> AttributeTypeName4<\/td> String<\/td> Identifier of the attribute to build up a possible subcategory<\/td><\/tr> AttributeTypeId5<\/td> Long<\/td> Unique attribute key to build a possible subcategory, 1: n points to AttributeCluster.attributeTypeId<\/td><\/tr> AttributeTypeName5<\/td> String<\/td> Identifier of the attribute to build up a possible subcategory<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nSetGroup<\/h4>\n\n\n\n Product type groups<\/p>\n\n\n\nfield<\/td> Data type<\/td> description<\/td><\/tr><\/thead> id<\/td> String<\/td> Unique key<\/td><\/tr> name<\/td> String<\/td> Identifier of the product type group<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nCross Table<\/h3>\n\n\n\nProductXRefAttributeCluster<\/h4>\n\n\n\n Associates the tables Product and AttributeCluster n: m, thus assigning each product its set of attributes of product properties<\/p>\n\n\n\nfield<\/td> Data type<\/td> description<\/td><\/tr><\/thead> ProdRefId<\/td> Long<\/td> Points 1: n to Product.puid<\/td><\/tr> AttributeClusterRefId<\/td> Long<\/td> Points 1: n to AttributeCluster.id<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nCSV PriceStoreUpdate 2 (prices2.csv)<\/h2>\n\n\n\n In this format, everything from the Vollexport has been omitted, which has nothing to do with prices and inventory. The format is available in the export. API retrieval is done with “prices2.csv”.<\/p>\n\n\n\n
This update format includes ProductPriceInfo, ProductStock, SupplierItemPriceInfo and SupplierItemStock, ie the price and warehouse data are similar to “CSV all data 2 (zip)”.<\/p>\n\n\n\n
ProductPriceInfo<\/strong><\/p>\n\n\n\nsee all CSV data 2 – Product Price Info<\/em><\/p>\n\n\n\nProductStock<\/strong><\/p>\n\n\n\nsee all CSV data 2 – Product Stock<\/em><\/p>\n\n\n\nSupplierItemPriceInfo<\/strong><\/p>\n\n\n\nsee all CSV data 2 – SupplierItemPriceInfo<\/em><\/p>\n\n\n\nSupplierItemStock<\/strong><\/p>\n\n\n\nsee all CSV data 2 – Supplier Items Tock<\/em>CSV Reference Source List including PriceStockUpdate (sources.csv)<\/h2>\n\n\n\n In this format, everything from the Vollexport has been omitted, which does not have to do with prices, stock and reference sources. The format is available in the export. API retrieval is done with “sources.csv”.<\/p>\n\n\n\n
The update format includes ProductPriceInfo, ProductStock, SupplierItemPriceInfo, SupplierItemStock, and SupplierItem as “CSV all data 2 (zip)” for each product. This update format includes product price, stock data and all reference source data including the respective price and stock data.<\/p>\n\n\n\n
ProductPriceInfo<\/strong><\/p>\n\n\n\nsee all CSV data 2 – Product Price Info<\/em><\/p>\n\n\n\nProductStock<\/strong><\/p>\n\n\n\nsee all CSV data 2 – Product Stock<\/em><\/p>\n\n\n\nSupplierItemPriceInfo<\/strong><\/p>\n\n\n\nsee all CSV data 2 – SupplierItemPriceInfo<\/em><\/p>\n\n\n\nSupplierItemStock<\/strong><\/p>\n\n\n\nsee all CSV data 2 – Supplier Items Tock<\/em><\/p>\n\n\n\nSupplierItem<\/strong><\/p>\n\n\n\nsee all CSV data 2 – SupplierItem<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"CSV all data 2 (full2.csv) This format contains all product data, divided into several tables. The tables contain references to each other. The format is available in the export. API …<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"kbtopic":[178],"kbtag":[],"class_list":["post-2379","kb","type-kb","status-publish","hentry","kbtopic-api-1-0-en"],"_links":{"self":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/2379","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=2379"}],"version-history":[{"count":6,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/2379\/revisions"}],"predecessor-version":[{"id":13090,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/2379\/revisions\/13090"}],"wp:attachment":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/media?parent=2379"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kbtopic?post=2379"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kbtag?post=2379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/guide.itscope.com\/wp-content\/uploads\/2020\/09\/image-355-1024x474.png\")
<\/figure>\n\n\n\n