Transcription
Sears Holdings Data SynchronizationInitiativeData Synchronization Implementation GuideVersion 18August 2015Confidential & Proprietary
Sears Holdings Data Synchronization Implementation GuideTABLE OF CONTENTS1234567OVERVIEW . 3SEARS HOLDINGS DATA SYNCHRONIZATION INFORMATION . 42.1 Primary Data Synchronization Contact . 42.2 Sears Holdings GLN – Publish To . 42.3 Key Points to Synchronizing Data with Sears Holdings . 4STEPS TO BEGIN SYNCHRONIZING YOUR NEW ITEM DATA TOSEARS HOLDINGS . 5SEARS HOLDINGS NEW ITEM PROCESS FLOW WITH GDSN . 7ADDITIONAL SEARS HOLDINGS IMA REQUIRED ATTRIBUTES . 8CATALOG ITEM CONFIRMATION ERROR HANDLING . 9SEARS HOLDINGS MAPPED FIELDS . 1225-Aug-2017Copyright 2015, All Rights Reserved.2
Sears Holdings Data Synchronization Implementation Guide1OVERVIEWThis document is intended to be used by vendors who will be sending item data to SearsHoldings Corporation (SHC) using electronic Data Synchronization with the Global DataSynchronization Network (GDSN ).Data Synchronization is the electronic transfer of standardized product information betweenTrading Partners and the continuous synchronization of the data over time.The benefits of data synchronization include: Facilitates accuracy of item data Speeds Item Introduction & Creation Enables electronic review and approval processes Improves market share by increasing speed to shelf for new items Reduces out-of-stocks Reduced shelf-tag and checkout errors in stores Builds foundation for future applications25-Aug-2017Copyright 2015, All Rights Reserved.3
Sears Holdings Data Synchronization Implementation Guide2SEARS HOLDINGS DATA SYNCHRONIZATION INFORMATION2.1Primary Data Synchronization ContactIMA HelpdeskPhone: 1 800.931.3141Email: IMAHelp@searshc.com2.2Sears Holdings GLN – Publish ToProduction: 0633815000004Note: this GLN identifies both Kmart and Sears.SHC’s GDSN data pool is 1WorldSync.2.3 Key Points to Synchronizing Data with Sears Holdings Sears Holdings is now accepting Initial Loads to synchronize items in IMA that werenot built using data sync.Publish your items at the highest level. This includes the publication of DS(display/shipper), commonly referred to as cartons at SHC. For MX (mixed module)which is commonly referred to as pallet at SHC, please sync the lower levels and addthe MX directly in IMA.Sears Holdings may take in unlimited packaging configurations of an item.For items originally published as “New Item”, Sears is now processing updates(modify/corrections) into IMA from GDSN for mapped fields. Suppliers are no longerrequired to manually update these specific items fields in IMA. (Reference1WorldSync IMA Mapping Guide)25-Aug-2017Copyright 2015, All Rights Reserved.4
Sears Holdings Data Synchronization Implementation Guide3STEPS TO BEGIN SYNCHRONIZING YOUR ITEM DATA TO SEARSHOLDINGSAre youalreadysubscribed to aCatalogueProvider?NoThings to Do Yes Choose your Data Pool. All GDSN Data Pools are listed n/gdsn certified data pools.pdfFor more information, call 1WorldSync at 1 866.280.4013Follow procedure belowMake sure that you are setup with Sears Holdings. If you have not beenpreviously contacted about setup, submit Data Synchronization VendorRequest Form online at the Data Synchronization tab on IMA HomepageWork with your Data Pool to get the item information published to SearsHoldings1. Load items into your Catalogue(Data Pool) Obtain Education/Training from your Data Pool or Solution Partner Review GDSN Package Measurement Standards and GTIN allocation rules2. Publish new items, updates, and initial loads to Sears Holdings Production GLN: 0633815000004 (for both Sears and Kmart)3. Check for Catalogue Item Confirmations (CICs) ACCEPT CIC: Item ready for review in IMA (add additional information andsubmit the item for approval). REVIEW CIC: Data discrepancies; vendor action required. SYNCHRONIZED CIC: Item is operational and POs can be placed. REJECT CIC: Item was rejected by Sears Holdings or deleted from IMA dueto inactivity (after 60 days).4. Once an “ACCEPT” CIC is received, login to IMA to add additional requiredinformation. Be sure to contact your buyer foro Division, Category, and Order DUNSo Additional fields to be provided For assistance, please call the IMA Helpdesk at 800.931.3141 or email:IMAHelp@searshc.com.5. Make updates to existing items in your Catalogue (Data Pool) Only fields mapped from Catalogue (Data Pool) for accepting updates willcome over to SHC as Corrections/Modifies (Refer to the Fields Mappeddocument on landing page for details). Item must have originally beenpublished to SHC as new. For making changes to unmapped fields, use ‘Change Existing Items’ optionunder ‘Data Catalogue’ in IMA.6. Check for Catalogue Item Confirmations (CICs).25-Aug-2017Copyright 2015, All Rights Reserved.5
Sears Holdings Data Synchronization Implementation Guide REVIEW CIC: Data discrepancies; vendor action required.SYNCHRONIZED CIC: Item update is operational.REJECT CIC: Item was rejected by Sears Holdings or deleted from IMA dueto inactivity (after 60 days).25-Aug-2017Copyright 2015, All Rights Reserved.6
Sears Holdings Data Synchronization Implementation Guide4SEARS HOLDINGS NEW ITEM PROCESS FLOW WITH GDSNThe below diagram outlines the Sears Holdings New Item Process flow as it exists withGDSN.25-Aug-2017Copyright 2015, All Rights Reserved.7
Sears Holdings Data Synchronization Implementation Guide5ADDITIONAL SEARS HOLDINGS IMA REQUIRED ATTRIBUTESIn addition to the standard required GDSN attributes (1WorldSync customers should refer toAppendix N of the IM Participant Dictionary for a full list of these attributes), there is onlyone additional attribute that SHC requires via Data Synchronization: GTIN Name. For non1WorldSync customers, if GTIN Name is not provided, Functional Name must be present.There are also additional IMA required attributes that can be leveraged via datasynchronization. Sending these attributes through your data pool (e.g., 1WorldSync) willalleviate the manual entry required for completing your items in IMA. For a complete listingof mapped fields please reference section 7 of this guide.Sears HoldingsName1WorldSync ItemManagement (IM) NameGDSN NameNotesCost Type/Cost ModeList PricecataloguePrice/tradeItemPrice/valueList Price /currencyISOCodeAll three attributes mustbe populated in order forany of the List Priceattributes to besynchronized.List Price Effective Start DateCountry of OriginImport Classification TypeImport Classification ValueManufacturer tionValueManufacturerOrder Quantity MultiplePricing On ProductFirst Arrival DateFirst Delivery DateShort Description/POS Desc. yDateTimedescriptionShortSecurity Tag LocationsecurityTagLocationAlternate Item IdentificationMaintenance te Item NumberadditionalTradeItemIdentificationValueVendor CostCountry of OriginHTS CodeManufacturer ID /NameOrder Qty MultiplePrepriced IndicatorProjected First InStore DateRegister ReceiptDescriptionVendor Applied EASTagVendor Stock #25-Aug-2017Copyright 2015, All Rights Reserved.8Both attributes aredependent on each other.Both attributes aredependent on each other.
Sears Holdings Data Synchronization Implementation Guide6CATALOG ITEM CONFIRMATION ERROR HANDLINGThe following table lists the different status codes that would be returned in a CIC with aReview State and how to resolve the issue.CIC Review Status Detail Code DescriptionsCodeStatus MessageCIC999Missing or invalid InformationProvider GLNInvalid catalog costCIC999CIC999What actions should betaken to resolve the issue?IP GLN is not set up correctly at SHCHolding; contact SHC to fix setup.UOM on cost is not valid for SHC. SHCrequires USD.Only accept EN, EO and UP.CIC999CIC999Invalid or missing eanuccCODE forSHCMissing GTIN NameItem is recalledCIC999Missing store formatNo valid store format.CIC999No valid SHC PayDUNS/Div/Catgassociated with GLNNo valid network distribution codefor SHC divisionSHC already processing thisGtin/ShipGtin in another hierarchyNo consumer unitNo hierarchy set up for GLN.CIC999CIC999CIC999CIC999CIC999CIC999Missing consumer unit EAN UCCCodeHierarchy is a CORRECTION. SHCcan’t handle CORRECTIONS nowHierarchy is a Delete. SHC can’thandle Deletes nowgtinName is a required field for SHC.SHC will not accept recalled items.Recommended SolutionContact IMA Support Help Desk at1.800.931.3141Vendor needs to take corrective action.Correct Code else contact SHC Merchant forcorrective course of action.Correct name.If vendor feels item is not a recall please contactyour respective SHC merchant.This is derived off whether you are set up as aKmart Vendor or a SHC Vendor. For furthersupport Contact IMA Support Help Desk at1.800.931.3141.Network distribution is required forpackage configuration.Configuration must be enteredthrough IMA.isConsumerUnit is set to false for allitems in document.EAN UCC Code is required on theconsumer unit for SHC.Vendor must make corrections in IMA.Please contact IMA Help Desk for correctivecourse of action.Correct network distribution code or contact IMAHelp Desk.Either perform updates in IMA on this UPC orContact the IMA Support Help Desk.Correct consumer unit or contact merchant forcorrective course of action.Correct consumer unit EAN UCC Code or contactmerchant for corrective course of action.Vendor must make corrections in IMA.Vendor must make delete in IMA ifitem is still in staging.Vendor must make delete in IMA if item is still instaging.CIC999Missing shipping GTINShipping GTIN required by SHC at thisconfiguration level.Shipping GTIN required by SHC at thisconfiguration level.CIC999SHC can only accept two pkgconfigurations at this timeVendor must build packagingconfiguration in IMA.Vendor must build packaging configuration inIMA.CIC999Must setup this hierarchy manuallyin IMA. Will accept each gtinVendor must build packagingconfiguration in IMA.Vendor must build packaging configuration inIMA.CIC999SHC already accepted Each that is inthis hierarchyCan only accept packagingconfigurations for new retail GTINs.Build packaging in IMA.Can only accept packaging configurations fornew retail GTINs. Build packaging configurationin IMA.CodeStatus MessageWhat actions should betaken to resolve the issue?Recommended SolutionCIC999SHC was not able to load the item into IMASHC cannot process Case or DisplayShipper without EachPlease resend as a Correction (CorrectionCommand)CIC999SHC was not able to load the item into IMAVendor duns# not authorized for anexisting GTINs SHC Division; contactyour SHC merchantCall or email data recipient25-Aug-2017Copyright 2015, All Rights Reserved.9
Sears Holdings Data Synchronization Implementation GuideWhat actions should betaken to resolve the issue?CodeStatus MessageCIC999SHC was not able to load the item into IMAExploding Assortment not loaded dueto error(s) with one or more of themembersPlease resend as a Correction (CorrectionCommand)CIC999SHC was not able to load the item into IMAThe data received was not as expected andneeds reviewed for updateCIC999SHC was not able to load the item into IMACIC999SHC was not able to load the item into IMACIC999SHC was not able to load the item into IMACIC999SHC was not able to load the item into IMACIC999SHC was not able to load the item into IMACIC999SHC was not able to load the item into IMACIC999Delete ProcessedUpdates to in-process GTIN(s) werenot applied as the GTIN(s) are nolonger in the vendor role; check GTINstatus in IMAShip Carton exists in IMA but allcomponents received are not attachedto ship carton in IMAShip Carton exists in IMA but all of itscomponents are not in the datareceivedSHC can only accept first threecountry of origins for new GTIN.Send again as an update to getremaining countries in IMA.Updates to in-process Ship GTIN(s)were not applied as the Ship GTIN(s)are no longer in the vendor role;check Ship GTIN status in IMAChange request already in process forShip GTIN on the same field. CheckShip GTIN status in IMAChange request already in process forRetail GTIN on the same field. CheckRetail GTIN status in IMADelete ProcessedCIC999Delete NOT ProcessedThe data received was not as expected andneeds reviewed for updateCIC999Delete NOT ProcessedCIC999Delete NOT ProcessedCIC999Delete NOT ProcessedCIC999Delete NOT ProcessedDelete not processed as Ship GTIN isoperational; submit a change requestto the purchase status field to makestatus “unavailable” or emailimahelp@searshc.comDelete not processed as Ship GTIN isstill in process in an internal role;submit a change request to thepurchase status field to make status“unavailable” after it becomesoperational or emailimahelp@searshc.comDelete not processed as Retail GTIN isoperational; submit a change requestto the purchase status field to makestatus “unavailable” or emailimahelp@searshc.comDelete not processed as Retail GTIN isstill in process in an internal role;submit a change request to thepurchase status field to make status“unavailable” after it becomesoperational or emailimahelp@searshc.comDelete not processed; all or part ofHierarchy sent not found in IMACIC999Delete NOT ProcessedDelete not processed as one or moreRetail GTINs are part of anotherCarton configuration; submit a changeThe data received was not as expected andneeds reviewed for update25-Aug-2017Copyright 2015, All Rights Reserved.10Recommended SolutionThe data received was not as expected andneeds reviewed for
Manufacturer ID / Name Manufacturer GLN Manufacturer Order Qty Multiple Order Quantity Multiple orderQuantityMultiple Prepriced Indicator Pricing On Product isPriceOnPack Projected First In-Store Date First Arrival Date First Delivery Date N/A firstDeliveryDateTime Register Receipt Description Short Description/POS Desc. 1 descriptionShort Vendor Applied EAS Tag Security Tag Location .
