6/10/2013 101: How to do Business with Target Amanda Alwy, Target Jason Lavik, Target Joe Spreitzer, Spreitzer Target Agenda • Target Overview • Item It Management M t Initiatives I iti ti • Global Data Synchronization • EDI and Barcodes • Contact Information 2 © GS1 US 2012 1 6/10/2013 Target Overview • Target is a Fortune 100 company with 1,784 stores in 49 states nationwide –T : expanded grocery – : full service grocery – : smaller format urban neighborhoods – : 4th most visited retail site – : apps for iPad, iPhone, and Android – :: 124 stores to open throughout 2013 • Our guests – Median age of 40 – Median household income of approximately $64K – Approximately 43% have children at home 3 © GS1 US 2012 Item Initiatives 4 © GS1 US 2012 2 6/10/2013 Item Management (IMN) • IMN is our Item Master Data system – Web based application – Intuitive navigation – Less free-form free form text – More drop-down selections • IMN is a repository of information about the products that Target carries • IMN includes Item Setup and Item Maintenance 5 © GS1 US 2012 Data Operations Team Merchandising Process & System Development (MPSD) established a Data Operations team in 2012 with goal to manage, monitor, and safeguard item and supplier data. • Master Data Management • Attribute Remediation & Enrichment • Item Validation • Taxonomy • Global Data Synchronization 6 © GS1 US 2012 3 6/10/2013 Master Data Management Goals: Maintain Enterprise Definitions & Metadata Establish Local & Enterprise Governance Beginning in March 2013, items sold only on Target.com will use IMN to initiate new item setups and item maintenance – Rollout by merchandising divisions over a 3 month period. • All divisions are currently rolled out • Training available on Partners Online 7 © GS1 US 2012 Attribute Remediation & Enrichment Goal: Assist Supply Partners in providing the enriched data needed to display core items on Target.com g Effective March 2013, required attributes for ALL new items must be completed before a Purchase Order can be written. – Required information includes Marketing/Selling Attributes – Tools: Use the IMN Task list to see items that are not ready for order 8 © GS1 US 2012 4 6/10/2013 Item Validation Goal: Ensure accurate data is available to guests on Target.com and supports Target’s reporting and business intelligence capabilities. Target will begin validating item attributes against a production sample and the business award document • Timing » Pilot Fall 2013 » Rollout Spring 2014 9 © GS1 US 2012 Item Validation – Attributes Validated • Brand • Storage Temperature (food only) • License • Temperature Sensitive (food only) • Color/Size/Pattern • Random Weight (food only) • Nett C N Content/Net t t/N t C Content t tU Unit it off Measure • L t Controlled Lot C t ll d (f (food d only) l ) • Open Coded Date (food only) • Marketing/Selling Attributes • Shipped with Ice (food only) • Return Policy • Organic (food only) • Edible Flag • Country of Origin (Import items only) • Item dimensions and image g • Barcode • Case/Inner Pack quantity (Not dimensions) • Cost/Retail • Manufacturer Style 10 © GS1 US 2012 5 6/10/2013 Taxonomy Goal: Maintain Target’s Product Classifications and Selling Attribute structure Beginning in Fall 2013, Target will have the capability to collect more accurate item specific data. – Example: Pen • Product Classification: Pens & Pencils – Attributes: » Ink Color » Lead Size 11 © GS1 US 2012 Trivia 12 © GS1 US 2012 6 6/10/2013 Question #1 Question: Which of the following Item Initiatives are currently in place? 1. 2. 3. 4 4. Use IMN for Target.com Item Setups Required Attributes needed for Purchase Order Item Validation against a Production Sample More accurate item data collection Answer: #1 & #2 13 © GS1 US 2012 Question #2 Question: Which of the following Item Initiatives will be in place in Fall 2013? 1. 2. 3. 4 4. Use IMN for Target.com Item Setups Required Attributes needed for Purchase Order Item Validation against a Production Sample More accurate item data collection Answer: All of them! 14 © GS1 US 2012 7 6/10/2013 Global Data Synchronization 15 © GS1 US 2012 GDS Initiative Establish GDS as the preferred method of item setup and maintenance leading to improved efficiencies and item accuracy. 1. Realize the benefit (consistent, accurate item data) that GDS vendor onboarding can bring to Target e e op a sca scalable ab e a and d repeatable epeatab e vendor e do 2. Develop onboarding program that provides a positive experience for all of Target’s supplier community. 16 © GS1 US 2012 8 6/10/2013 Target GDS History & Goals Dist. Center Carton Volume GDS Connected Suppliers 350 200 500 350 Prior to 2012 20% Dec 31 15% Dec 31 31% 2012 2013 Dec 31 11% Dec 31 4% 2014 350 2015 1750 Totals 81% •More accurate carton dimensions & weights •More accurate freight handling in Distribution Centers (conveyable v. non-conveyable) •More accurate truckload optimization © GS1 US 2012 17 Your Best Resource for Target GDSN info http://1WORLDSYNC.com/Target 18 © GS1 US 2012 9 6/10/2013 GDS Attribute List Pallet/Mod Pallet GTIN Case/Display GTIN Inner Pack GTIN gtin gtin gtin Hi & Ti totalQuantityOfNextLowe totalQuantityOfNextLo rLevelTradeItem werLevelTradeItem Each GTIN gtin alternateItemIdentificat ion eanuccCode/type eanuccCode/code netContent depth depth depth depth width width width width netContentUOM height height height height globalClassificationCate gory dimensionsUOM dimensionsUOM dimensionsUOM dimensionsUOM brandName grossWeight grossWeight grossWeight grossWeight productDescription grossWeightUOM grossWeightUOM grossWeightUOM grossWeightUOM suggestedRetail/price 19 © GS1 US 2012 Initial Load 20 © GS1 US 2012 10 6/10/2013 Steps for Synchronizing with Target – Initial Load 1. Review Target GDS Implementation Guide for attribute requirements. 2. Complete the Trading Partner Form on the Target landing page: www.1worldsync.com/target 3. Request a list of your items carried by Target from your internal Target Account team. team 4. Target will create a subscription for your Information Provider GLN/Target Market US and confirm readiness to accept the initial publication. •Publish items carried by Target •Publish as Initial Load •Publish to Target GLN: 0085239000007 5. E-mail publication notification to [email protected] 6. Manage Confirmation (CIC) Responses from Target. •If If you receive i REVIEW or REJECTED status, t t determine d t i the th cause off error and next step/resolution. •Republish as Initial Load and notify Target. 7. Once eligible items are synchronized Target will consider supplier “Complete.” 21 © GS1 US 2012 Initial Load FAQs • Question: My Target GDS Operations Specialist has asked me to “re-publish” some items to them. How do I do that? • “R “Republish” bli h” ffunction ti in i 1WorldSync 1W ldS system t iis responding di tto a request by Target to resend an item that was already published once to Target. • Publication (Publication Add) is only used the first time you are publishing to Target. – A Publication (Add) can only be done once in the 1WorldSync IM system. – Subsequent S Publication (Adds) ( ) are considered duplicates that 1WorldSync ignores. 22 © GS1 US 2012 11 6/10/2013 New Item 23 © GS1 US 2012 Supplier Benefits – Reduced Manual Entry Attributes Requested What was: 35 Attributes What is: 90 Attributes (approx) What could be: gds global data synchronization 90 Attributes (approx) 24 46 Attributes (Net) 44 Attributes © GS1 US 2012 12 6/10/2013 Supplier Benefits – Reduced Manual Entry IMN New Item Setup time What is: 9 minutes What could be: gds 5 minutes global data synchronization gds global data synchronization Saves 4 minutes per item of manual entry 25 © GS1 US 2012 FAQs Does my sales team need to be involved with data synchronization? Yes!! Sales people play an important role in the success of this process. Please get familiar with the sales team at your organization that works with Target. 26 © GS1 US 2012 13 6/10/2013 Steps for Synchronizing with Target – New Item 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. 27 © GS1 US 2012 Steps for Synchronizing with Target – New Item 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. 28 © GS1 US 2012 14 6/10/2013 Modifications/Corrections 29 © GS1 US 2012 FAQs Q: How will Target handle ongoing Data Synchronization? Data Synchronization with Target does not stop after the initial load process is complete. Target is taking item changes via GDSN. 30 © GS1 US 2012 15 6/10/2013 Steps for Synchronizing with Target – Modify/Correct 1. Supplier logs into Partners Online and accesses the Item Management Application (IMN) 2. Supplier searches for items in IMN to review for accuracy or updates • Search capability by barcode, GTIN 3. Supplier submits any necessary changes via GDS for any Target GDS item attributes • If attribute needing maintenance is not a GDS synched attribute, Supplier Sales Rep must update item information via IMN 4. GDS Publications are routed to the appropriate Target merchandising department associated with the barcode on the request. 5. If change is within a certain threshold, it will automatically be accepted by the system with no merchant action needed. 31 © GS1 US 2012 Steps for Synchronizing with Target – Modify/Correct 6. If change does not meet the auto approval thresholds, the merchant approves or rejects the item update that has been submitted from the Supplier via an IMN tasklist. Notes: 1.Any change to Case or Inner Pack quantity will require merchant review. 2.Suppliers can NOT request cost changes via GDS. 32 © GS1 US 2012 16 6/10/2013 Good to Know 33 © GS1 US 2012 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. 34 © GS1 US 2012 17 6/10/2013 GDS – Target specific Validations Dimensions & Weight • Case & Inner Pack dimensions and weights must have same UOM. • Gross Weight g is required q 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 35 © GS1 US 2012 FAQs 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. 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. 36 © GS1 US 2012 18 6/10/2013 FAQs 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 LOAD, MODIFY 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 37 © GS1 US 2012 Trivia 38 © GS1 US 2012 19 6/10/2013 Question #3 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 39 © GS1 US 2012 Question #4 Question: If I still have questions about data synchronization with Target, what email address at Target should I contact? Answer: [email protected] 40 © GS1 US 2012 20 6/10/2013 EDI and Barcodes 41 © GS1 US 2012 EDI • Required EDI documents – 850 Purchase Order – 860 Purchase Order Change g – 856 Ship Notice Manifest (ASN) – 810 Invoice – 864 Text Message – 997 Functional Acknowledgement • ASN Benefits – Determine replenishment p – Plan and schedule – Automated receiving – Improved receipt accuracy and payment 42 © GS1 US 2012 21 6/10/2013 ASN Match to Shipment 2012 Match Rates: Domestic: 94% Import: p 99% Total: 96% Expectations: Accurate and Timely  ASN Transmitted within 1 hour of trailer close / freight tendered Bill of Lading(BOL) number in ASN must match the BOL number provided to carrier  Target supports the use of the VICS BOL format  Use of Master BOL on shipments routed through our Consolidation points 43 © GS1 US 2012 Shipping Container Bar Codes Shipping Container Identification Code SSCC (Serial Shipping Container Code) Examples Bar Code Type GS1‐128 May be used on floor‐loaded or unitized shipments. GTIN‐14/13/12 (SCC) May only be used unitized shipments in conjunction with a pallet SSCC‐18 label. GTIN‐12/13 (UPC/EAN) ITF‐14 GS1‐128 UPC‐A / EAN‐13 May only be used as the shipping container code when the carton is the selling unit. 44 © GS1 US 2012 22 6/10/2013 Automated Receiving • Used for complex trailers – multiple POs and items • Unload cartons direct from trailer • Automatically scans carton barcode and applies internal label C ossdoc a and d immediate ed ate need eed ca cartons to s • Crossdock automatically diverted to outbound store trailers • Barcode read rate at 97% © GS1 US 2012 Trivia 46 © GS1 US 2012 23 6/10/2013 Question #5 Question: Which of the following Bar Codes are not used by Target in upstream receipt processing for automated product d t identification? id tifi ti ? • A. GS1-128 • B. GS1 DataBar • C. UPC-A / EAN-13 • D. Data Matrix • E. E ITF-14 ITF 14 Answer: GS1 Databar (B) & Data Matrix (D) 47 © GS1 US 2012 Contact Information GDS [email protected] (IMN or EDI) Request Support Link from Help Menu 612-304-3310 Option #3 (8AM – 5PM CST) 1WorldSync 1WorldS nc [email protected] 866-280-4013 48 © GS1 US 2012 24 6/10/2013 Questions? 49 © GS1 US 2012 25