Скачать презентацию Product classification Standard for international e-Commerce ETIM International Скачать презентацию Product classification Standard for international e-Commerce ETIM International

473f4e1c8e2a605dc98ca9ca7f23fc7f.ppt

  • Количество слайдов: 55

Product classification Standard for international e-Commerce ETIM International Marc Habets 19 March 2018 Sheet Product classification Standard for international e-Commerce ETIM International Marc Habets 19 March 2018 Sheet : 1

Marc Habets - ETIM NL – Director ETIM Netherlands • Employed since 2003 – Marc Habets - ETIM NL – Director ETIM Netherlands • Employed since 2003 – President ETIM International • Since foundation in 2008 19 March 2018 Sheet : 2

Agenda • ETIM Netherlands • Standards in product data management • ETIM model : Agenda • ETIM Netherlands • Standards in product data management • ETIM model : what is it, how and why? • ETIM International 19 March 2018 Sheet : 3

ETIM Netherlands • ETIM = European Technical Information Model • ETIM NL = Foundation ETIM Netherlands • ETIM = European Technical Information Model • ETIM NL = Foundation (started in 1991) • Participants – Manufacturers 76 companies, majority position – Wholesalers federations ECEG and TGF – and installers federation UNETO-VNI • Standards for product classification and communication formats (e-business) • Electrotechnical, heating and sanitary 19 March 2018 Sheet : 4

Necessity of standards in product data management - To make the ever increasing material Necessity of standards in product data management - To make the ever increasing material databases easily accessible for the user - in a user (customer) - friendly way. 19 March 2018 Sheet : 5

This necessity is demonstrated by: - rapid growth of product range (90. 000 in This necessity is demonstrated by: - rapid growth of product range (90. 000 in 1995, 160. 000 in 1997, 280. 000 in 2000, 500. 000 in 2002, > 1. 000 in 2009) - further growth of information needs per article - shorter product life cycle and quicker TTM (time to market) - product database quality more important 19 March 2018 Sheet : 6

Requirements - Maintenance of product databases in an efficient way - Automated processing of Requirements - Maintenance of product databases in an efficient way - Automated processing of article information - The suppliers are the owner – and responsible – for product information and distribution of product data in a standard way ! - All participants have to use the same standards - Names - Structure - Interfaces 19 March 2018 Sheet : 7

Standards in product data management - Identification Classification of products Interfaces for data-exchange Networks Standards in product data management - Identification Classification of products Interfaces for data-exchange Networks Data carrier / media All this aspects are important individually – don‘t mix! All this aspects are requirements for efficient e. Business – but only in a standardized way! 19 March 2018 Sheet : 8

Overview 19 March 2018 Sheet : 9 Overview 19 March 2018 Sheet : 9

Phase 1 Assortment growth Identification modus Type of grouping Phase 2 „ 100“ articles Phase 1 Assortment growth Identification modus Type of grouping Phase 2 „ 100“ articles „ 1. 000“ articles Article number and article name Grouping of articles Codification Product selection sources From stock + from catalogues Product offering Buy, what you can touch Buy, what you can read 19 March 2018 Phase 4 „ 10. 000“ articles „ 100. 000“ articles Basic product description Structured product description Overview Identification Type of communication Phase 3 Face - to face Classification + from company database Buy, what you can select + from external database(s) Buy, what exists Computer - to computer Sheet : 10

Classification of products - Relevant for all companies in the supply chain - Relevant Classification of products - Relevant for all companies in the supply chain - Relevant for all kind of processes Manufacturer 19 March 2018 Wholesaler Installer / contractor Sheet : 11

ETIM Classification • What is it? - Fixed model for classifying electrotechnical articles - ETIM Classification • What is it? - Fixed model for classifying electrotechnical articles - without hierarchy - with features / parametric - Listing of the most important technical characteristics of each article class to describe and find the articles. - multi – lingual - media neutral - supplier neutral Sheet : 12

ETIM Classification • How? – By using product classes, features and values, that are ETIM Classification • How? – By using product classes, features and values, that are descibed in a standardized way. Synomyms are used to easily find the right products! • Why? – No double work, minimal failure costs, high data quality, optimal data applications, efficient product data management. Cost savings, surplus value and … your customers ask for it! Sheet : 13

ETIM Classification - Is NOT - A software application - An article data base ETIM Classification - Is NOT - A software application - An article data base - A catalogue production tool - A search engine These are applications which use ETIM as the basis !!! 19 March 2018 Sheet : 14

Advantages • Reduction of failure costs. • Wrong orders are reduced to a minimum. Advantages • Reduction of failure costs. • Wrong orders are reduced to a minimum. Direct Cost reductions! Sheet : 15

Advantages • Increase in the efficiency of the communication (internal as well as external) Advantages • Increase in the efficiency of the communication (internal as well as external) – Standardised – Automated – Direct coupling and/or processing in internal automation Fewer actions necessary and faster acting! Time gained and thus savings! Sheet : 16

Advantages • Heightens the information level to customers – Up to date-, complete- and Advantages • Heightens the information level to customers – Up to date-, complete- and correct product data (throughout the entire supply chain) Quality, service and fewer errors! Sheet : 17

Advantages • Better logistics – Besides reduction in failure costs also reductions possible in Advantages • Better logistics – Besides reduction in failure costs also reductions possible in systems for stock management and order processing Sheet : 18

Advantages • Possibility to re-use information – Data only have to be entered once Advantages • Possibility to re-use information – Data only have to be entered once – Data can be used for multiple purposes Efficient management of product databases! Sheet : 19

Advantages • Uniform information flow – – Product information is specified once by producer. Advantages • Uniform information flow – – Product information is specified once by producer. . and entered in a standard format. . and used by all parties in the supply chain. . so the exchange of information is always based on the same, original data in all direction – from and to the producer Product information from the source and thus up to date, correct and complete! Sheet : 20

Advantages • Optimization of catalogue management – Data are media neutral and can be Advantages • Optimization of catalogue management – Data are media neutral and can be used for different layouts (catalogue software) Time savings, less corrections and lower production costs! Sheet : 21

Advantages • Standard interfaces – In the future only a few standard interfaces are Advantages • Standard interfaces – In the future only a few standard interfaces are needed for the exchange of product data Continuous adaptation of systems to new demands no longer needed! Sheet : 22

Advantages • Marketing instrument – Possible to arrange information to target group – 1 Advantages • Marketing instrument – Possible to arrange information to target group – 1 on 1 marketing possible – Unique product features are emphasized by complementary, specific marketing texts. Distinguish by extra service! Sheet : 23

Advantages • Efficient management reporting – Classification makes statistical analysis possible Turnover figures and Advantages • Efficient management reporting – Classification makes statistical analysis possible Turnover figures and strategy possible on product class level! Sheet : 24

Advantages - summary • Reduction of failure costs. • Increase in the efficiency of Advantages - summary • Reduction of failure costs. • Increase in the efficiency of the communication (internal as well as external) • Heightens the information level to customers • Better logistics • Possibility to re-use information • Uniform information flow • Optimalisation of catalogue management • Standard interfaces • Marketing instrument • Efficient management reporting Sheet : 25

ETIM Classification • Who uses it? – Manufacturers : the ‘source’ of the product ETIM Classification • Who uses it? – Manufacturers : the ‘source’ of the product – Electronic and printed catalogues, online and offline databases and applications as configurator – Provide wholesaler with standardized product data – Wholesalers: – – Ideally receives classified product data from manufacturer Adds his own trade information to the product data Information to his customers: catalogues and databases Ordering: Online search/selection of articles – Installers: – Online when searching or ordering products at the wholesaler or producer – Offline to build and update their own article database Sheet : 26

ETIM classification – the model • • • Product groups Product classes Synonyms Features ETIM classification – the model • • • Product groups Product classes Synonyms Features Values Units productgroup productclass unit productclasssynonym productclassfeature synonym featurevalue Sheet : 27

Types of features: • Alphanumerical features – List of possible values (color, material, …) Types of features: • Alphanumerical features – List of possible values (color, material, …) • Numerical- and Range features – Number values (length, voltage, …) • Logical features – “Yes or No” questions (true/false) Sheet : 28

productgroup productclass unit productclasssynonym productclassfeature (search) feature synonym valuefeature value Sheet : 29 productgroup productclass unit productclasssynonym productclassfeature (search) feature synonym valuefeature value Sheet : 29

Sheet : 30 Sheet : 30

ICS E 4 W 11 ETIM 4. 0 International Classified product NL Classified product ICS E 4 W 11 ETIM 4. 0 International Classified product NL Classified product DE Classified product EN Klassenaam Klassename Classname Wurgnippel Kabeleinsteckstutzen Cable sealing clamp Kenmerk Merkmahl Feature Nominale diameter Nenndurchmesser Nominal diameter Nominale diameter PG Nenngröße PG Nominal size PG Uitvoering Ausführung Model Afdichtbereik Dichtbereich Sealing range Beschermingsgraad (IP) Schutzart (IP) Degree of protection (IP) Materiaal Werkstoff Material Kleur Farbe Colour Halogeenvrij Halogenfrei Halogen free Waarde Wert Value nvt nvt 13, 5 Gesloten Geschlossen Closed 6 -10, 6 IP 55 PVC PVC Wit Weiß White Ja Ja Yes Klassenaam Class name Klassenaam 229450915 EC 000451 Kenmerk Feature Kenmerk Waarde Value Waarde 3348 EF 005114 9663 EF 005115 13, 5 5916 EF 000010 8911 EF 004593 149 EV 000116 6 -10, 6 198 EF 005474 6942 EF 002169 7461 EV 006420 315 EV 000163 EF 000007 8 EF 000025 87 440 EV 000202 True Sheet : 31

ETIM classification – publication scheme Sheet : 32 ETIM classification – publication scheme Sheet : 32

ETIM – model evolution 1993 ETIM From national and company standards UNETO ETIM TU ETIM – model evolution 1993 ETIM From national and company standards UNETO ETIM TU 1996 ETIM Sonepar 1999 ETIM 1. 1/2. 0 MECIM 2002 2008 NL ETIM NL Germany e. Cl@ss To an international European standard ETIM International Sheet : 33

(company-) specific classifications ETIM – implementation in classification systems Sector UNSPSC Macro family Family (company-) specific classifications ETIM – implementation in classification systems Sector UNSPSC Macro family Family Hierarchic approach ETIM 4. 0 Product Model Shape Material Color Etc. . Parametric approach Features Sheet : 34

Communication standards NL Technique ASCII XML Productinfomessage Discountmessage Order change Order confirmation Packing list Communication standards NL Technique ASCII XML Productinfomessage Discountmessage Order change Order confirmation Packing list Invoice ------- transactioncommunication Functional Articlemessage objectcommunication EANCOM Sheet : 35

Product data exchange NL • Scope for international data exchange – NL-specific formats not Product data exchange NL • Scope for international data exchange – NL-specific formats not suitable for international use – GS 1 standard formats worldwide orientation – BMECat currently best solution for international use • Status BMECat in NL – Import in 2 BA database easy and frequently used • Export in NL formats to importers and/or wholesalers – Larger wholesalers can import BMECat directly as well Sheet : 36

Product data exchange NL • Bilateral between supplier and customer – Manufacturer-supplier – Supplier-installer/endcustomer Product data exchange NL • Bilateral between supplier and customer – Manufacturer-supplier – Supplier-installer/endcustomer • Through central branch database (2 BA) In both cases using the defined standard formats! Sheet : 37

Data distribution - Netherlands - Central branch article database (2 BA) operative - Joint Data distribution - Netherlands - Central branch article database (2 BA) operative - Joint venture installers and wholesalers - Non-profit - Data based on branch standards classification + communication - 223 companies already distribute their product data through 2 BA - 965. 363 products 4. 784. 379 ‘buyable’ articles (article-numbers) - Strong incentive for increase in classified data. Sheet : 38

Producer Importer 2 ba db Wholesaler Installer • Price Conditions 39 Sheet : 39 Producer Importer 2 ba db Wholesaler Installer • Price Conditions 39 Sheet : 39

19 March 2018 Sheet : 40 19 March 2018 Sheet : 40

Software tools for export to standard ETIM formats • Software tools necessary – To Software tools for export to standard ETIM formats • Software tools necessary – To convert company data in ETIM classified product data – To make export in standard communication formats 19 March 2018 Sheet : 41

Software tools for export to standard ETIM formats • Software provided by software companies Software tools for export to standard ETIM formats • Software provided by software companies – Exact, Proplanet, AG&P, …. – From simple and relatively cheap to complex and expensive • Tools provided by 2 BA – Excel-import sheet • limited classification – only classname • Simple solution for easy start – Basic softwaretool 2 C for general use • Technique: combination of. Net framework and SQL Server • Simple and cheap solution • Limitations, designed only for import in 2 BA database, no additional features Sheet : 42

19 March 2018 Sheet : 43 19 March 2018 Sheet : 43

19 March 2018 Sheet : 44 19 March 2018 Sheet : 44

ETIM in use- Netherlands • Example online database/webshop wholesaler 19 March 2018 Sheet : ETIM in use- Netherlands • Example online database/webshop wholesaler 19 March 2018 Sheet : 45

Sheet : 46 Sheet : 46

Sheet : 47 Sheet : 47

ETIM International – full member organisations • • ADIME Spain ELDAS Switzerland ETIM Austria ETIM International – full member organisations • • ADIME Spain ELDAS Switzerland ETIM Austria ETIM Germany ETIM Netherlands ETIM Poland ICGME Belgium SEG Sweden 19 March 2018 Sheet : 48

ETIM International • Non-profit organization, founded in 2008, seat in Brussels • Administration of ETIM International • Non-profit organization, founded in 2008, seat in Brussels • Administration of all languages / classes from one administration group • One model for Europe, one interface for suppliers, sharing of costs • The use of ETIM offers advantages for all partners in the supply chain • ETIM is operational in more than one language and available for the use in different countries • Cooperations with other standardization organizations (like e. Cl@ss) 19 March 2018 Sheet : 49

ETIM International - Ever more international wholesalers adopt ETIM as standard for their (global) ETIM International - Ever more international wholesalers adopt ETIM as standard for their (global) product data management - Solar - Rexel - Sonepar - …. . - The number of international suppliers that join and provide ETIM data increases rapidly 19 March 2018 Sheet : 50

ETIM International • No barriers for new member countries! – No charges for the ETIM International • No barriers for new member countries! – No charges for the development done in the last 15 years! • Just join ETIM International – Translate ETIM in your own language • Implement and start experiencing the benefits !! • ETIM classified data from important international manufacturers are available and ready to use! 19 March 2018 Sheet : 51

Online database and service portal ETIM CMT • ETIM CMT (Classification Management Tool) launched Online database and service portal ETIM CMT • ETIM CMT (Classification Management Tool) launched and operational • Online tutorials available soon • Further extensions planned – Example/image database connected to classes – … 19 March 2018 Sheet : 52

19 March 2018 Sheet : 53 19 March 2018 Sheet : 53

19 March 2018 Sheet : 54 19 March 2018 Sheet : 54

e-Business = ETIM-Business !! Thank you for your attention Any questions? 19 March 2018 e-Business = ETIM-Business !! Thank you for your attention Any questions? 19 March 2018 Sheet : 55