6/5/2014 198: How to Do Business With Target Jason Lavik, Target June 11, 2014 1 6/5/2014 AGENDA • Target Overview • Item Initiatives • Data Operations Overview • Data Quality/Scorecard • Global Data Synchronization • Resources • Contact Information © GS1 US 2014 ALL RIGHTS RESERVED 2 2 6/5/2014 TARGET OVERVIEW • Target is a Fortune 100 company with 1,789 stores in 49 states – 0 – 0 : opened in 2013; 127 stores – – O : apps for iPad, iPhone, and Android • Our guests – Median age of 40 – Median household income of approximately $64K – Approximately 43% have children at home © GS1 US 2014 ALL RIGHTS RESERVED 3 3 6/5/2014 ITEM MANAGEMENT (IMN) • Suppliers access via our portal – Partners Online – Suppliers see what Target sees for their items • IMN is our Item Master Data system – Intuitive navigation – Less free-form text; More value list selections • IMN is a repository of information about the products that Target carries • IMN includes Item Setup and Item Maintenance • GDS Publications feed directly into IMN © GS1 US 2014 ALL RIGHTS RESERVED 4 4 6/5/2014 Item Initiatives System Enhancements © GS1 US 2014 ALL RIGHTS RESERVED 5 5 6/5/2014 2013 IMN ENHANCEMENTS Multichannel: Required attributes for ALL new items must be completed before a Purchase Order can be written. Multichannel: Target can now collect more relevant item specific data. Ink Color Lead Size Multichannel: Items sold only on Target.com now use IMN to initiate new item setups and item maintenance © GS1 US 2014 ALL RIGHTS RESERVED 6 6 6/5/2014 2014 ITEM ENHANCEMENTS Multichannel: Common Item Catalog Multichannel: Convert legacy Target.com only items into IMN throughout 2014 Multichannel: New Item Relationships Dynamic Assortments Bundles Running Change © GS1 US 2014 ALL RIGHTS RESERVED 7 7 6/5/2014 Item Data Operations © GS1 US 2014 ALL RIGHTS RESERVED 8 8 6/5/2014 DATA OPERATIONS TEAM Mission: Instill Confidence in Item & Business Partner Data by developing processes to Manage, Measure, and Monitor its Completeness, Accuracy, and Relevance for Target team members, external partners, and ultimately our guests. © GS1 US 2014 ALL RIGHTS RESERVED 9 9 6/5/2014 DOMAIN DATA MANAGEMENT Goals: Maintain Enterprise Definitions & Metadata Establish Local & Enterprise Governance Vendor Management & Maintenance (VMM) = Single source of truth for Business Partner data Item Management (IMN) = Common item catalog for Target stores & Target.com Data Quality • Develop Tools and Processes with MDM principles in effort to receive complete, accurate, and relevant data. • However the self service format relies upon getting complete, accurate, and relevant data from you – our business partners. © GS1 US 2014 ALL RIGHTS RESERVED 10 10 6/5/2014 PRODUCT TAXONOMY Goal: Maintain Target’s Product Classifications Maintain Target’s Selling Attribute structure Grocery Product Category Rebuild – Reduced Merchandise Types (Product Categories) from 134 to 59 – Reduced Item Types from ~2600 to 260 Previous Product Categories (13): 1) Fresh Fruit 2) Dried Fruit 3) Frozen Fruit 4) Canned & Packaged Fruit 5) Fruit Snacks 6) Fresh Vegetables 7) Frozen Vegetables 8) Canned Vegetables 9) Canned Tomatoes 10) Canned Prepared & Baked Beans 11) Canned Ingredient & Variety Beans 12) Dry Beans 13) Frozen & Refrigerated Potatoes Previous Item Types: 270 across those 13 categories New Product Category (1): Fruit & Vegetables New Item Types (4): 1) Fruit 2) Vegetables 3) Mixed Fruit 4) Mixed Vegetables © GS1 US 2014 ALL RIGHTS RESERVED 11 11 6/5/2014 ATTRIBUTE REMEDIATION Goal: Identifies Item & Business Partner data issues Manage updates and remediation Update Product Specific Tasks Need YOU to complete these tasks! Result from: • Changes in data structure • Change in required attributes Data Quality Monitors: Brand/SubBrand Net Content Barcode © GS1 US 2014 ALL RIGHTS RESERVED 12 12 6/5/2014 Attribute Validation © GS1 US 2014 ALL RIGHTS RESERVED 13 13 6/5/2014 ATTRIBUTE VALIDATION Goal: Ensures accurate data that positively impacts Target’s supply chain and guests. Target validates item attributes against production samples Timing Pilot completed across 24 departments Rollout across organization now beginning © GS1 US 2014 ALL RIGHTS RESERVED 14 14 6/5/2014 ITEM VALIDATION – ATTRIBUTES VALIDATED • Brand • Storage Temperature (food only) • License • Temperature Sensitive (food only) • Color/Size/Pattern • Random Weight (food only) • Net Content/Net Content Unit of Measure • Lot Controlled (food only) • Open Coded Date (food only) • Product Specific Attributes • Shipped with Ice (food only) • Return Policy • Organic (food only) • Edible Flag • Country of Origin (Import items only) • Barcode • Case/Inner Pack quantity (Not dimensions) • Cost/Retail • Manufacturer Style © GS1 US 2014 ALL RIGHTS RESERVED 15 15 6/5/2014 VALIDATION RESULTS Color, Size, Pattern, License: Product Specific Attributes Material: 100 % Polyester Closure Style: Pullover Garment Fit: Regular Sleeve length: Short Sleeve Neckline: Crew Gender: Male Target Audience: Adult … 5% error rate at Item Setup Average 2 errors per item at Item Setup Barcode Net Content/Unit of Measure 8% error rate at Item Setup 6% error rate at Item Setup © GS1 US 2014 ALL RIGHTS RESERVED 16 16 6/5/2014 INTRODUCTION OF ITEM DATA SCORECARD Monthly report on your item set-up accuracy as audited by our Item Validation team SUMMARY report: High level review of your item setup validation results DETAILS report: Item Attribute detail of changes made by our Item Validation team Expectations: • Pushed to Partners Online (POL) & Vendor Management/Maintenance (VMM) system admin(s) at the supplier. • POL/VMM Admin(s) distribute to those within supplier organization responsible for item data. • Goal is to drive awareness of data accuracy & provide clarity on our data expectations. • Review but no action on these items is needed because our Item Validation team has already corrected the error. © GS1 US 2014 ALL RIGHTS RESERVED 17 17 6/5/2014 ITEM DATA SCORECARD – HOW TO READ SUMMARY VENDOR: Results total by Vendor, Target Department, and by Target Department/Class. TOTAL ITEMS MEASURED: Total items validated that month by category. ITEMS W/ NO ERRORS: Total items with no errors found by category. ITEMS W/ ERRORS: Total items with errors found by category. ACCURACY%: Percentage of items that had no errors found by category. TOTAL ATTRIBUTE ERRORS: Total number of attribute errors. A single item can have more than 1 attribute error. AVG # ERRORS/ITEM: Total number of attributes with errors divided by number of items. © GS1 US 2014 ALL RIGHTS RESERVED 18 18 6/5/2014 ITEM DATA SCORECARD – HOW TO READ DETAIL ITEM: DPCI Number and Item Description of Item validated. UPC: Barcode of the item validated. MFG STYLE: Manufacturer Style Number of item validated. ATTRIBUTE: Product information that was validated. ORIGINAL VALUE: Attribute value entered by supplier at time of new item setup. CHANGED VALUE: Attribute value entered by Target Item validation team at time of audit. CHANGED DATE: Date that Target Item Validation team made the attribute change based on time of item audit. © GS1 US 2014 ALL RIGHTS RESERVED 19 19 6/5/2014 Trivia Question #1 © GS1 US 2014 ALL RIGHTS RESERVED 20 20 6/5/2014 QUESTION #1 Question: Which of the following item attributes are not included on Target’s Validation Scorecard? 1. 2. 3. 4. 5. Barcode Net Content Color Case Dimensions None of the above Answer: Case Dimensions © GS1 US 2014 ALL RIGHTS RESERVED 21 21 6/5/2014 Global Data Synchronization © GS1 US 2014 ALL RIGHTS RESERVED 22 22 6/5/2014 GLOBAL DATA SYNCHRONIZATION Goal: Establish GDS as the preferred method of item setup & maintenance leading to improved efficiencies & item accuracy. Overall GDS Vendor Connections by Year 749 800 600 400 200 228 54 193 87 0 3 2008 2009 0 2007 GDS Connected Suppliers Distribution Center Carton Volume 2010 2011 2012 2013 1600 68% © GS1 US 2014 ALL RIGHTS RESERVED 23 23 6/5/2014 Data Quality Global Data Synchronization © GS1 US 2014 ALL RIGHTS RESERVED 24 24 6/5/2014 CASE & EACH DIMENSIONS Case Dimensions: Cubiscan Data was within GS1 Package Measurement rules tolerances: 64% of the time for GDSN items 32% of the time for Non-GDSN items Each Dimensions: Cubiscan Data was within GS1 Package Measurement rules tolerances: 36% of the time for GDSN items 21% of the time for Non-GDSN items •More accurate freight handling in Distribution Centers (conveyable v. non-conveyable) •More accurate truckload optimization •More accurate ship to guest Rialto CA Tucson AZ © GS1 US 2014 ALL RIGHTS RESERVED 25 25 6/5/2014 INTRODUCTION OF GDS DIMENSION SCORECARD Compares Cube (LxWxH) from our Cubiscan to Cube of Dimensions in IMN. Pushed to Vendor Partners as Follows: • Top 25 Carton Volume Vendors: Every 6 months • Next Top 100 Carton Volume Vendors: Every 12 months • Anyone in this room who is interested (sign up sheet) • Others as reporting shows need Three tabs: SUMMARY tab: High level review of your dimension data CASE tab: Distribution Center (DC) Cubiscan of CASE v. IMN Case data EACH tab: Target.com Fulfillment Center (FC) Cubiscan of EACH v. IMN Each data © GS1 US 2014 ALL RIGHTS RESERVED 26 26 6/5/2014 DIMENSION SCORECARD – HOW TO READ SUMMARY • High level overview of how your data compared to our Cubiscan data. • Summarizes the total number and percentage of items within and outside our acceptable tolerance for both the Case and Each level. • We also further breakdown that information by GDS synchronized items and non-GDS items. © GS1 US 2014 ALL RIGHTS RESERVED 27 27 6/5/2014 GDS DIMENSION SCORECARD – HOW TO READ DETAIL Item & Business Partner Identifiers DEPT/CLASS/ITEM: Target’s internal item number for item VEND# & VENDOR NAME: Target’s internal vendor number & name for supplier BARCODE: UPC attached to item in Target’s system CASE GTIN/EACH GTIN: GTIN attached to item in Target’s system. If no value is present, this item has not been synchronized via the GDSN MFR STYLE: Manufacturer Style # attached to item in Target’s system. DESCRIPTION: Description of the item in Target’s system © GS1 US 2014 ALL RIGHTS RESERVED 28 28 6/5/2014 GDS DIMENSION SCORECARD – HOW TO READ DETAIL Dimensions TOTAL CARTONS: Number of cartons cubiscanned for that item in the last month DC (or FC) LENGTH: Longest Side as measured by our Cubiscan DC (or FC) WIDTH: Next Longest Side as measured by our Cubiscan DC (or FC) HEIGHT: Shortest Side as measured by Cubiscan DC (or FC) CUBE: Length x Width x Height Does Not necessarily follow GS1 Package Measurement Rules DIFF: Calculation of % difference between DC(or FC) Cube & IMN Cube IMN CUBE: IMN Length (Depth) x IMN Width x IMN Height IMN LENGTH: Length (Depth) measurement present in IMN system IMN WIDTH: Width measurement present in IMN system IMN HEIGHT: Height measurement present in IMN system Should Follow GS1 Package Measurement Rules © GS1 US 2014 ALL RIGHTS RESERVED 29 29 6/5/2014 GDS DIMENSION SCORECARD EXPECTATIONS Expectations: 1) Target will share scorecard with you and expect you to address the discrepancies within 8 weeks of receiving report. • Our acceptable tolerance (DIFF) is less than or equal to 12% (Report will be sorted with largest differences on top) 2) Target wants all your active items via Global Data Sync so any items not synchronized via GDS will need to be synchronized within that 8 weeks. • If value does not exist in CASE_GTIN (or EACH_GTIN) field, we want that data sent via GDSN. 3) Work with our [email protected] Specialists throughout that 8 week window to address issues. © GS1 US 2014 ALL RIGHTS RESERVED 30 30 6/5/2014 Trivia Questions #2 & #3 © GS1 US 2014 ALL RIGHTS RESERVED 31 31 6/5/2014 QUESTION #2 Question: True/False: When reviewing dimensions, your height value must match the height value from the Target Cubiscan data? Answer: FALSE Your Height does not need to match our Height, etc. Instead, the total cube should be within our tolerance. © GS1 US 2014 ALL RIGHTS RESERVED 32 32 6/5/2014 QUESTION #3 Question: What does Target consider as acceptable tolerance for the cube dimensions? Answer: Less than or equal to 12% © GS1 US 2014 ALL RIGHTS RESERVED 33 33 6/5/2014 New Item Setup Process Global Data Synchronization does not stop after Initial Load © GS1 US 2014 ALL RIGHTS RESERVED 34 34 6/5/2014 GDS NEW ITEM SETUP – VENDOR USAGE TARGET GDS SUPPLIERS = 1600 5% Use GDS New Item Setup Do NOT use GDS New Item Setup 95% 1800 new item setups have been initiated via Global Data Synchronization in the last year. 500,000 new items have been set up in IMN in the last year. © GS1 US 2014 ALL RIGHTS RESERVED 35 35 6/5/2014 GDS NEW ITEM SETUP: SUPPLIER BENEFITS Attributes Requested What was: IMN New Item Setup time 35 Attributes What is: 90 Attributes (approx) 9 minutes 46 Attributes (Net) 5 minutes What could be: gds global data synchronization 90 Attributes (approx) 44 Attributes Saves 4 minutes per item of manual entry © GS1 US 2014 ALL RIGHTS RESERVED 36 36 6/5/2014 NEW ITEM - STEPS FOR SYNCHRONIZING 1. Target awards business to Supplier or Target buyer asks for item setup 2. Supplier Account Rep advises GDS Rep to publish new item(s). 3. Supplier GDS Rep publishes New to Target’s GLN: 0085239000007 and advises Supplier Sales Rep 4. Supplier Account Rep logs into Partners Online to access Target’s Item Management (IMN) application. 5. Supplier Account Rep accesses the finish item setup task from the workbench tab of the IMN home page. Order of these steps is very important! © GS1 US 2014 ALL RIGHTS RESERVED 37 37 6/5/2014 NEW ITEM - STEPS FOR SYNCHRONIZING 6. Supplier Account Rep finds GDS submitted item in the task list. • Filter criteria “Source” = GDS 7. Supplier Account Rep “tops off” the item(s) following the IMN guided setup process and submits item(s). • GDS submitted attributes will be pre-populated 8. Target Merchant reviews and approves item setup • CIC Message SYNCHRONIZED is sent for the GDS attributes synched • CIC Message REVIEW is sent if additional information is needed. Merchant has the option to include comments explaining next steps needed. © GS1 US 2014 ALL RIGHTS RESERVED 38 38 6/5/2014 Trivia Question #4 © GS1 US 2014 ALL RIGHTS RESERVED 39 39 6/5/2014 QUESTION #4 Question: True/False: For a GDS New Item Setup, I should first create the item in IMN and then publish the item as “NEW” in the GDSN? Answer: FALSE GDS NEW Item Setups must first be published in GDSN and then topped off in IMN © GS1 US 2014 ALL RIGHTS RESERVED 40 40 6/5/2014 Good to Know © GS1 US 2014 ALL RIGHTS RESERVED 41 41 6/5/2014 GDS ATTRIBUTE LIST Pallet/Mod Pallet GTIN Case/Display GTIN Inner Pack GTIN gtin gtin gtin Hi & Ti Each GTIN gtin totalQuantityOfNextLo totalQuantityOfNextL werLevelTradeItem owerLevelTradeItem eanuccCode/type alternateItemIdentific ation eanuccCode/code depth depth depth depth netContent width width width width netContentUOM height height height height globalClassificationC ategory dimensionsUOM dimensionsUOM dimensionsUOM dimensionsUOM brandName grossWeight grossWeight grossWeight grossWeight productDescription grossWeightUOM grossWeightUOM grossWeightUOM grossWeightUOM suggestedRetail/price © GS1 US 2014 ALL RIGHTS RESERVED 42 42 6/5/2014 BEST RESOURCE FOR TARGET GDSN INFO http://1WORLDSYNC.com/Target © GS1 US 2014 ALL RIGHTS RESERVED 43 43 6/5/2014 GDS – TARGET SPECIFIC VALIDATIONS Dimensions & Weight • Case & Inner Pack dimensions and weights must have same UOM. • Gross Weight is required Barcodes • UPC (EANUCC Code) required at Each level • EANUCC Code types other than UK/UP/EN will not be processed by Target – UK = UPC/EAN Shipping Container Code (1-2-5-5-1) – UP = UPC Consumer Package Code (1-5-5-1) – EN = European Article Number (EAN 8) or (EAN 2-5-5-1) Publication Delete • Incoming CIN with message type DELETE is ignored © GS1 US 2014 ALL RIGHTS RESERVED 44 44 6/5/2014 ACCEPTABLE GTIN HIERARCHIES • 4 Level GTIN Hierarchies – PL/CA/PK/EA PL/DS/PK/EA – MX/CA/PK/EA MX/DS/PK/EA • 3 Level GTIN Hierarchies – PL/CA/EA PL/DS/EA – MX/DS/EA CA/PK/EA MX/CA/EA DS/PK/EA 2 Level GTIN Hierarchies – CA/EA DS/EA PK/EA • • 1 Level GTIN Hierarchies – EA Target cannot support a GTIN hierarchy with multiple Case, Inner Pack, or Each options. Target will not use the GDSN for assortment items, displays, or bonus packs. © GS1 US 2014 ALL RIGHTS RESERVED 45 45 6/5/2014 FAQS Q: Is data synchronization being used for Target.com items? A: YES! The GDSN can be used for both Item Setup & Maintenance for ALL Target.com items. Q: Is data synchronization being used in Canada for Target? A: Target’s GDSN focus is in the U.S. only. Target is not currently leveraging data synchronization for our Canadian operations. © GS1 US 2014 ALL RIGHTS RESERVED 46 46 6/5/2014 FAQS Q: How do I get access to see my item information in IMN? A: Please contact the Partners Online admin at your organization. They have the ability to give you a user ID and password. Q: How long does it take for the data to show up in IMN after I have published? A: Target processes GDSN messages every 4 hours (8AM, Noon, 4PM, 8PM, Midnight, 4AM Central time). • NEW: Data inserted in the IMN “Finish Item Setup” task after that 4 hour batch has processed. • INITIAL LOAD, MODIFY, CORRECT: Depends on how the data you sent compares to what is currently in Target’s system Watch the CIC messages sent by Target for updates © GS1 US 2014 ALL RIGHTS RESERVED 47 47 6/5/2014 Trivia Question #5 © GS1 US 2014 ALL RIGHTS RESERVED 48 48 6/5/2014 QUESTION #5 Question: What is the website address that contains the best and most detailed information on doing data synchronization with Target? Answer: WWW.1WORLDSYNC.COM/TARGET © GS1 US 2014 ALL RIGHTS RESERVED 49 49 6/5/2014 TARGET ITEM COMMUNICATION Quarterly GDS Newsletter Monthly Item & Business Partner Update © GS1 US 2014 ALL RIGHTS RESERVED 50 50 6/5/2014 KEY TAKEAWAYS Complete Data • Work your update product specific tasks in IMN Accurate Data • Use our Item Data scorecard to understand where issues exist with your data • GDS supplied data is proven more accurate than manually entered data – Use GDS for Target new item set-up – Use our GDS Dimension scorecard to understand and fix issues with your dimensions Relevant Data • Target continues to invest in systems and processes to ensure that we are collecting relevant data from our suppliers © GS1 US 2014 ALL RIGHTS RESERVED 51 51 6/5/2014 CONTACT INFORMATION GDS [email protected] (IMN or EDI) Request Support Link from Help Menu 612-304-3310 Option #3 (8AM – 5PM CST) 1WorldSync [email protected] 866-280-4013 © GS1 US 2014 ALL RIGHTS RESERVED 52 52 6/5/2014 Questions © GS1 US 2014 ALL RIGHTS RESERVED 53 53
© Copyright 2024