198: How to Do Business With Target 6/5/2014

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