6/5/2014 195: How to Do Business With Lowe’s Companies, Inc. Kristy Hart, Lowe’s Companies, Inc. Bryan Samples , Lowe’s Companies, Inc. Katie Spikes, Lowe’s Companies, Inc. June 11, 2014 1 6/5/2014 AGENDA 1. Lowe’s Product MDM • Current Item Setup Process • How did we get here? • Where are we going? 2. Standards • Purpose • Opportunities 3. Product Data Deliverables © GS1 US 2014 ALL RIGHTS RESERVED 2 2 6/5/2014 Product MDM © GS1 US 2014 ALL RIGHTS RESERVED 3 3 6/5/2014 CURRENT STATE PROCESS Solution Provider Merchandising Buying Decision Made LowesLink Retail Channels PCM FootPrints PI Builder File Publish GDSN Data • Marketing Data • GDSN Data • Cost • Restrictions Digital Assets • Product Images • Use & Care Guide • Installation Manual • EnergyGuide Submit PI Builder File Communicate with Product Information Available for Purchase • Selling Center • Lowes.com • In Store • Mobile App © GS1 US 2014 ALL RIGHTS RESERVED 4 4 6/5/2014 ITEM SETUP BEST PRACTICES • Partner with Lowe’s to proactively manage the item setup process • Hold your Solution Provider accountable • Publish data prior to submitting the Builder File • Check CIC messages often • Follow GTIN allocation rules • Provide clear, consistent data • Know your data expectations (B2B, B2C) • Keep lines of communication open with Product Information © GS1 US 2014 ALL RIGHTS RESERVED 5 5 6/5/2014 MATURITY OF PRODUCT INFORMATION •Item Set‐up centralized within PI •1 Millionth GTIN Synchronized – July •Product DQ metrics •Repair Services & IPE begin utilizing product data •2X items on Lowes.com in 2011 •PCM deployed •GDSN vendor on‐boarding begins •Defining categories/ attributes for Marketing data begins 2001‐ 2004 •GDSN Data faster – Pub before Sub implemented •Flow from PCM to Selling Tools for Marketing Data completed •Reached 90% Stock Sales Dollars Online 2006 2005 2008 2007 •Build and implementation of PCM •Enhanced Marketing Data Collection – includes multiple images •Item Restrictions Collection begins •Canadian PI team established •Product MDM project approval‐ Excalibur 2012 2010 2009 2011 2013 •Marketing Data Collection brought in house •Marketing Data Standards Guide Published •More focus on Data Quality •Increase internal usage of data.. Buying, Services •GDSN vendor on‐boarding •PCM Internal roll‐out •Focus shifted to speed of publication •Flow from PCM to Selling Tools turned on for Marketing data •GDSN/Marketing Implemented for Lowe’s Canada •Lowes.CA launched(Oct) © GS1 US 2014 ALL RIGHTS RESERVED 6 6 6/5/2014 But now it’s time to cultivate new and better processes… © GS1 US 2014 ALL RIGHTS RESERVED 7 7 6/5/2014 MORE THAN ITEM SETUP… • Previously focused on item setup – laying the foundation for a larger data management organization • Expanded to include important enterprise data sectors to create a Master Data & Content Management powerhouse Data Quality & Governance Enterprise Content Management Customer Data Product Information All enterprise data sets Strategy, have now been centralized Standards under one roof & Solutions © GS1 US 2014 ALL RIGHTS RESERVED 8 8 6/5/2014 MDM PRODUCT PROGRAM Program Intent: • A robust product master data management (MDM) practice will provide a simplified interface and dynamic data architecture that will enable unprecedented item growth and data quality while increasing speed to market and customer satisfaction. • The Product MDM system will provide the flexible data foundation to meet the current and future needs of the company vision as well as increasing our ability to maintain compliance with standards. © GS1 US 2014 ALL RIGHTS RESERVED 9 9 6/5/2014 EXCALIBUR: FINDING THE RIGHT SOLUTION How do we intend to leverage a solution… Analytical • • How many customers did I have today? How many of the promotional products were purchased today? Operational • • Does the system need to process hundreds of transactions per second ? Are there multiple systems that need to interact real-time with the MDM system? Collaborative • • Do multiple groups contribute to the creation and cleansing of the data? Is workflow and task management needed to coordinate activities on the master data? © GS1 US 2014 ALL RIGHTS RESERVED 10 10 6/5/2014 EXCALIBUR: FINDING THE RIGHT SOLUTION What is the right type of solution… Consolidation • Cleanse the data in source system and merge into single system to be referenced throughout the enterprise Registry • System identifies where the data is stored in the source systems Transactional • System supports real-time consistency of all master data within domain across the enterprise Coexistence • Leverage a solution to cleanse the data with consistent processes and workflow capabilities © GS1 US 2014 ALL RIGHTS RESERVED 11 11 6/5/2014 EXCALIBUR: DEFINING SUCCESS Defining our data values: • Clearly define qualities of Product Master Data • Does inaccuracy of the data asset impact sales, customer experience or operations across the enterprise? • MDM Architectural Principles 9 Data Consistency 9 Data Integrity 9 Reuse 9 Source of Truth Strategic execution to deliver on our values: • Data Residence – tactical approach to determine where data will be stored and maintained • Enterprise Adoption – tactical approach to propagate the data throughout the organization © GS1 US 2014 ALL RIGHTS RESERVED 12 12 6/5/2014 EXCALIBUR OBJECTIVES Improve visibility to product data Tiered FlexibleData Sourcing Model Improved focus on Data Quality management within Lowe’s © GS1 US 2014 ALL RIGHTS RESERVED 13 13 6/5/2014 Standards © GS1 US 2014 ALL RIGHTS RESERVED 14 14 6/5/2014 PURPOSE OF STANDARDS Keys to a great customer experience: • Consistency and accuracy • Functionality • Clarity and comprehension • Compliance • Professional appearance © GS1 US 2014 ALL RIGHTS RESERVED 15 15 6/5/2014 STANDARDS • GS1 GTIN Allocation Rules • GS1 Dimensions Guide • NIST • Lowe’s Dimensions Guide • Lowe’s Product Weights and Measures Standards • Lowe’s Marketing Data & Image Standards © GS1 US 2014 ALL RIGHTS RESERVED 16 16 6/5/2014 COPY GUIDELINES • Descriptions • Bullets • Lowe’s Description creation Category: Solar Product Landscape Lights Online Package Quantity + Collection Name + Color/Finish + “Solar-Powered” + Tab Description Bulb Type + Lighting Application Bin/Beam Label (In-store) Item #484687 SOLAR 8X TIER PATH LIGHT BLACK © GS1 US 2014 ALL RIGHTS RESERVED 17 17 6/5/2014 DIMENSIONS AND SCORECARDING The use of the 1WorldSync Data Accuracy Scorecard (DAS) will allow companies: • To compare internal operational data to Suppliers GDSN data • To identify inconsistencies within dimensional data • Provide visibility to inconsistencies both internally and to the suppliers © GS1 US 2014 ALL RIGHTS RESERVED 18 18 6/5/2014 GS1 DATA QUALITY FRAMEWORK • Lowe’s is participating in the GS1 US Data Quality Scorecard – Intent is to provide insight into the current state of data quality throughout industry – This DQ Scorecard process will audit the Foundational and Fundamental attributes as defined by the GS1 US Data Quality Program • Looked at Brand, GTIN, Net Contents/UOM, Pack Quantity, COO, Dimensional Data, Gross Weight/UOM, and TI/HI – Audit will be used to determine the level of data quality as a benchmark – One time pilot that targeted 100 items for 4 suppliers • Ultimate goal is to develop a universal data quality program that is applicable across industries and product categories that will lead to a data quality certification program © GS1 US 2014 ALL RIGHTS RESERVED 19 19 6/5/2014 Product Data Deliverables © GS1 US 2014 ALL RIGHTS RESERVED 20 20 6/5/2014 BUSINESS FOCUS Product data is an integral part of our business. Your data directly supports major customer-facing initiatives allowing us to provide a seamless customer experience. © GS1 US 2014 ALL RIGHTS RESERVED 21 21 6/5/2014 CUSTOMER FOCUSED TECHNICAL SOLUTIONS Distribution Channels Flexible Fulfillment Product Locator Online Customer Experience © GS1 US 2014 ALL RIGHTS RESERVED 22 22 6/5/2014 CUSTOMER FOCUSED BUYING Merchandising uses your product information to make purchasing decisions! © GS1 US 2014 ALL RIGHTS RESERVED 23 23 6/5/2014 CUSTOMER FOCUSED COMPLIANCE 1”X12”X8” UTILITY SHELVING 1-IN X12-IN X8-IN UTILITY SHELVING © GS1 US 2014 ALL RIGHTS RESERVED 24 24 6/5/2014 Questions? © GS1 US 2014 ALL RIGHTS RESERVED 25 25