{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Table Of Contents","WH Maintenance","Item","itembind","Xref","CID","Trait","Store Trait","Assortment","Dropdown","Shipper Creation","Copy Item","Scan Issue","MCN"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":108,"comments":7,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Table Of Contents","index":0,"n_rows":48,"n_cols":22,"rows_kept":48,"cut":false,"hidden":false,"merged":[[6,1,6,11],[9,1,13,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"H&S","Hardlines","Apparel","Consumables","Pharmacy","D92","Food","DSD","D96NS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,40,38,null,80,96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,49,null,null,90,81]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,50,null,null,97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,2,null,null,98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84]
[null,"Last Updated:  10/29/2019",null,null,null,null,null,null,null,null,null,null,null,null,11,null,8,null,null,94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,13,null,null,83]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,"Please take the time to review each page before completing.  Each page contains a legend explaining the different requirements for each task.  Fields required for the basic task will be in dark blue.  All lines in yellow are example lines only should not be used as part of the request.  Any other required fields will be designated in orange or dark green.  Task specific information will also be included in the legend section of the worksheet.  ",null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,null,46,null,null,93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,null,1,null,null,91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,77,null,82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,85,null,92]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,87,null,95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,67]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,71]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,78]

{"sheet":"WH Maintenance","index":1,"n_rows":12,"n_cols":75,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,6,1]]}
["WH Maintenance",null,null,null,null,null,"Select field to maintain from drop down menu","CWO or DELETE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item, Xref, CID, Trait, Store Trait, Assortment, Shipper Creation, Copy Item"]
["Last Updated:  06/13/2019",null,null,null,null,null,"Brand","CWO"]
[null,null,null,null,null,null,"Compliance Indicator - Aerosol Ind","DELETE"]
["Required Field",null,null,null,null,null,"Compliance Indicator - Battery Type","ADD"]
["Example Line",null,null,null,null,null,"Compliance Indicator - Chemical Ind"]
["Current Values/Values to be Edited",null,null,null,null,null,"Compliance Indicator - Composite Wood Level Code"]
["UPC Changes Only",null,null,null,null,null,"Compliance Indicator - CPSC Regulated Ind"]
["DC CWO Changes Only",null,null,null,null,null,"Compliance Indicator - Paper/Wood Ind"]
[null,null,null,null,null,null,"Compliance Indicator - Pesticide Ind"]
[]
["Item Number","DC To Update","ACTION","CWO Date","EOS Date"]
[123456789,0,"CWO","2049-12-31","2049-12-31"]

{"sheet":"Item","index":2,"n_rows":21,"n_cols":134,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,1,0],[20,0,41,0]]}
["Item Maintenance",123456789,"A Random Item",20,123456,"OZ","RED",22.2,"Red Random","22.2OZ",40502,"RandomIRed",12345,"Single (123456790)",1234567891,5,"A random single item, color Red.",3,"2017-12-18","Y","N",4,"2049-12-31","N","A","2017-10-04",2,92,3555,0,12345678,87654321,1000000,"M","Y","N",2,2020,"N","N",null,"N","N",123456920,"N",2.02,3.56,"A",null,null,25.2,"Y",null,null,null,null,5001600010123,5001600010123,12,12.5,9.56,15.93,"IN",12.5,9.56,15.93,"IN",4,"L",100,1,13.73,2,13.73,"N","Y",8,null,11.8,7.66,2.19,"IN",1.39,null,"Y","Y","Y","Y","GD",null,6,null,null,372,null,365,0,null,null,null,null,null,0,132,5,null,null,null,null,null,"Y","N","N","N","EA","N","N","N","N","N","N","N","N",null,1,"N","N",1,"N","N","N","N","N","HI"]
[null,"Item Number","Item Description 1","Item Type","Brand","Unit Size UOM","Shelf 1 / Color","Unit Size/Sell Qty","Item Description 2","Shelf 2 / Size","Plu Number","UPC Description","Supplier Stock Number","Shop / Ticket Description","UPC","UPC CK Digit","Signing Desc","Diet Type","Item Effective Date","Corporate Orderbook","eCommerce Orderbook","Sub Type","Item Expiration Date","Guaranteed Sales","Item Status","Send to Store Date","Performance Rating","Department","Fineline","Subclass","Product Number","Shelf Number","Projected Yearly Sales Qty","MBM","Modular Batch Print","Each RFID Indicator","Season Code","Season Year","Cancel When Out Ind","MultiPack Ind","Space ID","Variety Pack Ind","Intangible Ind","Supplier Number","Item Opp","Mfgr Pre Price","Mfgr Suggested Retail","Whse Pack Calc Method","Price Comparison Qty","Price Comp UOM","Supplier Pack Cost","Allow Associate Discount","Gift Card Type","Face Amount","Fee Amount","Fee Percentage","Case UPC Supplier Pack","Warehouse Pack UPC Number","Pallet Ti","Supplier Pack Height","Supplier Pack Width","Supplier Pack Length","Supplier Pack DIM UOM","Whse Pack Height","Whse Pack Width","Whse Pack Length","Whse Pack DIM UOM","Pallet Hi","Pallet Size","Pallet Round Pct","Crush Factor","Whse Pack Weight Qty","Whse Rotation","Supplier Pack Weight","Master Carton Ind","Conveyable","Supplier Pack Qty","Order Sizing Factor","Item Height Qty","Item Width Qty","Item Length Qty","Item Dim Uom","Item Weight Qty","Factory ID","Wal-Mart","Supercenter","Online","Neighborhood Market / Amigo","Whse Alignment","Supplier Min Order Qty","Whse Area","Whse Max Order Qty","Variance Days","Min Whse Life Qty","Supplier Lead Time","Shelf Life Days","Whse Min Order Qty","Est Out of Stock Date","Ideal Temp Lo Qty","Exclusive Supply DC Number","Marshal ID","Ideal Temp Hi Qty","Reserve Mdse Code","Commodity ID","Segregation Code","Acceptable Temp Lo","Acceptable Temp Hi","Special Handling Instructions","Consideration Code","Quality Control Hold","Item Scannable Ind","Temp Sensitive Ind","Electronic Article Surveillance Ind","Shelf Rotation","Retail Unit Measurement","Scalable at Register Ind","Fpp Range Ind","Item Import Ind","Backroom Scale Ind","Chemical Ind","Pesticide Ind","Aerosol Ind","RPPC Ind","FHS DC Slotting Code","Composite Wood Level Code","CPSC Regulated Ind","Private Label/Unbranded Ind","Battery Type","Mercury Ind","Paper/Wood Ind","Electronic Ind","Controlled Indicator","DEA Flag","Buying Region Code"]
["Last Updated: 10/11/2019"]
["Required Field"]
["Example Line"]
["Current Values/Values to be Edited"]
["UPC Changes Only"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note:"]
[{"$f":"_xlfn.CONCAT(\"To Use:\", CHAR(10), CHAR(10),  \"Input item numbers to maintain.\", CHAR(10), CHAR(10), \"Click on Select Edit Fields, choosing the fields to change.\", CHAR(10), CHAR(10), \"Key in the new values only, current values are not required.\", CHAR(10), CHAR(10),  \"If you are \"\"clearing\"\" an item field make it blank.\")","v":"To Use:\n\nInput item numbers to maintain.\n\nClick on Select Edit Fields, choosing the fields to change.\n\nKey in the new values only, current values are not required.\n\nIf you are \"clearing\" an item field make it blank."}]

{"sheet":"itembind","index":3,"n_rows":119,"n_cols":2,"rows_kept":119,"cut":false,"hidden":true,"merged":[]}
["Acceptable Temp Hi",false]
["Acceptable Temp Lo",false]
["Aerosol Ind",false]
["Allow Associate Discount",false]
["Backroom Scale Ind",false]
["Battery Type",false]
["Brand",false]
["Cancel When Out Ind",false]
["Case UPC Supplier Pack",false]
["Chemical Ind",false]
["Commodity ID",false]
["Composite Wood Level Code",false]
["Consideration Code",false]
["Controlled Indicator",false]
["Conveyable",false]
["Corporate Orderbook",false]
["CPSC Regulated Ind",false]
["Crush Factor",false]
["DEA Flag",false]
["Department",false]
["Diet Type",false]
["Each RFID Indicator",false]
["eCommerce Orderbook",false]
["Electronic Article Surv Ind",false]
["Electronic Ind",false]
["Est Out of Stock Date",false]
["Exclusive Supply DC Number",false]
["Factory ID",false]
["FHS DC Slotting Code",false]
["Fineline",false]
["Fpp Range Ind",false]
["Gift Card Attributes",false]
["Guaranteed Sales",false]
["Ideal Temp Hi QTY",false]
["Ideal Temp Lo QTY",false]
["Intangible Ind",false]
["Item Description 1",false]
["Item Description 2",false]
["Item Dimensions",false]
["Item Effective Date",false]
["Item Expiration Date",false]
["Item Import Ind",false]
["Item Opp",false]
["Item Scannable Ind",false]
["Item Status",false]
["Item Type",false]
["Item Weight QTY",false]
["Marshal ID",false]
["Master Carton Ind",false]
["MBM",false]
["Mercury Ind",false]
["Mfgr Pre Price",false]
["Mfgr Suggested Retail",false]
["Min Whse Life QTY",false]
["Modular Batch Print",false]
["MultiPack Ind",false]
["Neighborhood Market / Amigo",false]
["Online",false]
["Order Sizing Factor",false]
["Pallet Hi",false]
["Pallet Round Pct",false]
["Pallet Size",false]
["Pallet Ti",false]
["Paper / Wood Ind",false]
["Performance Rating",false]
["Pesticide Ind",false]
["PLU Number",false]
["Price Comp UOM",false]
["Price Comparison QTY",false]
["Private Label / Unbranded",false]
["Product Number",false]
["Projected Yearly Sales QTY",false]
["Quality Control Hold",false]
["Reserve Mdse Code",false]
["Retail Unit Measurement",false]
["RPPC Ind",false]
["Scaleable at Register Ind",false]
["Season Code",false]
["Season Year",false]
["Segregation Code",false]
["Send to Store Date",false]
["Shelf 1 / Color",false]
["Shelf 2 / Size",false]
["Shelf Life Days",false]
["Shelf Number",false]
["Shelf Rotation",false]
["Shop / Ticket Description",false]
["Signing Desc",false]
["Space ID",false]
["Special Handling Instructions",false]
["Sub Type",false]
["Subclass",false]
["Supercenter",false]
["Supplier Lead Time",false]
["Supplier Min Order QTY",false]
["Supplier Number",false]
["Supplier Pack Cost",false]
["Supplier Pack Dimensions",false]
["Supplier Pack QTY",false]
["Supplier Pack Weight",false]
["Supplier Stock Number",false]
["Temp Sensitive Ind",false]
["Unit Size UOM",false]
["Unit Size/Sell QTY",false]
["UPC",false]
["UPC Description",false]
["Variance Days",false]
["Variety Pack Ind",false]
["Wal-Mart",false]
["Warehouse Pack UPC Number",false]
["Whse Alignment",false]
["Whse Area",false]
["Whse Max Order QTY",false]
["Whse Min Order QTY",false]
["Whse Pack Calc Method",false]
["Whse Pack Dimensions",false]
["Whse Pack Wegith QTY",false]
["Whse Rotation",false]
["Buying Region Code",false]

{"sheet":"Xref","index":4,"n_rows":11,"n_cols":24,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,5,4,5],[0,6,1,6]]}
["Cross Reference",null,null,null,null,"REMEMBER:","If an item is not effective yet, we cannot put into Prime position",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add "]
["Last Updated:  09/05/2018",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Remove (Use CID Tab for CID Updates)"]
[null,null,null,null,null,null,"Cross Referencing Assortments can only happen on the parent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modify"]
["Required Field",null,null,null,null,null,"level, you cannot cross reference babies"]
["Example Line"]
["Optional - Chain Position"]
[]
[]
[]
["Action to Take","Current Prime Item","Current Prime's CID","Item Description","Item Retail","Item to Update","Item Description","Item Retail","CID to Attach to New Prime","Desired Position in Chain","Prime Cross Reference Date","Comment"]
["Add ",123456789,98765432,"Blue Cup",9.99,987654321,"Blue Tumbler",9.99,98765432,"Prime","2016-12-31"]

{"sheet":"CID","index":5,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Consumer ID Maintenance"]
["Last Updated:  09/05/2018"]
[]
["Required Field"]
["Example Line"]
[]
[]
["Action to Take","Item Number","CID Group Action","CID #"]
["Remove",123456,"New CID ",78910]

{"sheet":"Trait","index":6,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Trait Maintenance"]
["Last Updated:  06/04/2018"]
[]
["Required Field"]
["Example Line"]
[]
["**Please only put the traits you wish to be added or removed from the item"]
["Item #","Description","Send Trait Action","Send Traits","Omit Trait Action","Omit Traits","Effective Date","Full Replace?"]
[9999999,"Blue Cup","Add","021661 O 049146","Remove","208369 O 184493 O 055741","2049-12-31"]

{"sheet":"Store Trait","index":7,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[3,0,3,1],[4,0,4,1]]}
["Store Trait Administration"]
["Last Updated:  09/05/2018"]
[]
["Required Field"]
["Example Line"]
[]
["Action","Trait #","Store #","Effective Date","Expiration Date","Reason Code","Comments"]
["Add","021661 O 049146",0,"2049-12-31","2049-12-31","Buyer Request"]

{"sheet":"Assortment","index":8,"n_rows":37,"n_cols":29,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,0,3,1],[4,0,4,1]]}
["Assortment Maintenance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Business Decision","Attach"]
["Last Updated:  09/05/2018",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Demand Change at Store/Club","Remove"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dynamic Distro Error"]
["Required Field",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Forecast Incorrect"]
["Example Line",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IDC - Reduced Recvg Capacity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Impact Store/Club"]
["Parent Item ","Child Item ","Remove/Attach","Edit Reason","Cost","Retail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incorrect Initial Distribuition"]
[123456789,987654321,"Attach","Substitute Item Received",5.2,7.48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incorrect Item received"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Internal WMT System Error"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Late Order - Changed Transport Mode"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Member/Customer Request"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Appt In Window"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recall"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Receiving Correction"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Store/Club Request"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Substitute Item Received"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supplier Capacity Issue"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supplier Closed - Inv/Weather"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supplier Error or Not Ready"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supplier Keyed Late Or Wrong"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supplier Requested Change - OK to reactivate if received at DC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supplier Requested Change"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transp Carrier Misc - Breakdown/Accident/Driver"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transp Carrier Missed Appt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transp Carrier Out Of Capacity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transp Carrier Unable to Use Avail Appts In Window"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transp Late Carrier Assign - Traf"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transp Pickup Sched Late - Carrier or Supplier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transp Rail Delay"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weather Earthquake"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weather Fire"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weather Flooding"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weather Hurricane"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weather Snow/Ice"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weather Tornado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO  "]

{"sheet":"Dropdown","index":9,"n_rows":103,"n_cols":7,"rows_kept":103,"cut":false,"hidden":true,"merged":[]}
["Item Maint","XREF","XREF","Trait Maint","Assortment Maint","Assortment Maint","MCN"]
["Brand","Current","Prime","Remove ","Business Decision","Attach","Assign New"]
["Compliance Indicator - Aerosol Ind","Future","Future Prime","Add","Demand Change at Store/Club","Remove","Move To"]
["Compliance Indicator - Battery Type",null,"2nd",null,"Dynamic Distro Error"]
["Compliance Indicator - Chemical Ind","Add ","3rd",null,"Forecast Incorrect"]
["Compliance Indicator - Composite Wood Level Code","Remove","4th",null,"IDC - Reduced Recvg Capacity"]
["Compliance Indicator - CPSC Regulated Ind","Modify","5th",null,"Impact Store/Club"]
["Compliance Indicator - Mercury Ind",null,"6th",null,"Incorrect Initial Distribuition"]
["Compliance Indicator - Paper/Wood Ind",null,"7th",null,"Incorrect Item received"]
["Compliance Indicator - Pesticide Ind",null,"8th",null,"Internal WMT System Error"]
["Compliance Indicator - Private Label/Unbranded Ind",null,"9th",null,"Late Order - Changed Transport Mode"]
["Compliance Indicator - RPPC Ind",null,"10th",null,"Member/Customer Request"]
["Conveyable",null,"11th",null,"No Appt In Window"]
["Corporate Orderbook",null,"12th",null,"Recall"]
["DC - Cancel When Out Ind",null,"13th",null,"Receiving Correction"]
["Destination - Neighborhood Market/Amigo",null,"14th",null,"Store/Club Request"]
["Destination - Supercenter",null,"15th",null,"Substitute Item Received"]
["Destination - Walmart",null,"16th",null,"Supplier Capacity Issue"]
["Factory ID",null,"17th",null,"Supplier Closed - Inv/Weather"]
["Fineline",null,"18th",null,"Supplier Error or Not Ready"]
["Item - Cancel When Out Ind",null,"19th",null,"Supplier Keyed Late Or Wrong"]
["Item Description 1",null,"20th",null,"Supplier Requested Change - OK to reactivate if received at DC"]
["Item Description 2",null,"21st",null,"Supplier Requested Change"]
["Item Effective Date",null,"22nd",null,"Transp Carrier Misc - Breakdown/Accident/Driver"]
["Item Expiration Date",null,"23rd",null,"Transp Carrier Missed Appt"]
["Item Send to Store Date",null,"24th",null,"Transp Carrier Out Of Capacity"]
["Item Status",null,"25th",null,"Transp Carrier Unable to Use Avail Appts In Window"]
["Item Sub Type",null,"26th",null,"Transp Late Carrier Assign - Traf"]
["Item Type",null,"27th",null,"Transp Pickup Sched Late - Carrier or Supplier"]
["MBM",null,"28th",null,"Transp Rail Delay"]
["Modular Batch Print",null,"29th",null,"Weather Earthquake"]
["Opening Price Point Flag",null,"30th",null,"Weather Fire"]
["Product Number",null,"31st",null,"Weather Flooding"]
["Season Code",null,"32nd",null,"Weather Hurricane"]
["Season Year",null,"33rd",null,"Weather Snow/Ice"]
["Segregation Code",null,"34th",null,"Weather Tornado"]
["Shelf 1/Color",null,"35th",null,"YES"]
["Shelf 2/Size",null,"36th",null,"NO  "]
["Shelf Number",null,"37th"]
["Signing Desc",null,"38th"]
["Supplier Min Order Qty",null,"39th"]
["Supplier Number",null,"40th"]
["Supplier Stock Number",null,"41st"]
["Unit Size UOM",null,"42nd"]
["Unit Size/Sell Qty",null,"43rd"]
["UPC  (Including Check Digit)",null,"44th"]
["UPC Description",null,"45th"]
["Vendor Pack Size",null,"46th"]
["Warehouse Alignment Code",null,"47th"]
[null,null,"48th"]
[null,null,"49th"]
[null,null,"50th"]
[null,null,"51st"]
[null,null,"52nd"]
[null,null,"53rd"]
[null,null,"54th"]
[null,null,"55th"]
[null,null,"56th"]
[null,null,"57th"]
[null,null,"58th"]
[null,null,"59th"]
[null,null,"60th"]
[null,null,"61st"]
[null,null,"62nd"]
[null,null,"63rd"]
[null,null,"64th"]
[null,null,"65th"]
[null,null,"66th"]
[null,null,"67th"]
[null,null,"68th"]
[null,null,"69th"]
[null,null,"70th"]
[null,null,"71st"]
[null,null,"72nd"]
[null,null,"73rd"]
[null,null,"74th"]
[null,null,"75th"]
[null,null,"76th"]
[null,null,"77th"]
[null,null,"78th"]
[null,null,"79th"]
[null,null,"80th"]
[null,null,"81st"]
[null,null,"82nd"]
[null,null,"83rd"]
[null,null,"84th"]
[null,null,"85th"]
[null,null,"86th"]
[null,null,"87th"]
[null,null,"88th"]
[null,null,"89th"]
[null,null,"90th"]
[null,null,"91st"]
[null,null,"92nd"]
[null,null,"93rd"]
[null,null,"94th"]
[null,null,"95th"]
[null,null,"96th"]
[null,null,"97th"]
[null,null,"98th"]
[null,null,"99th"]
[null,null,"100th"]
[null,null,"N/A"]

{"sheet":"Shipper Creation","index":10,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":false,"merged":[[8,10,8,19],[8,0,8,9],[18,0,18,2],[3,0,3,1],[4,0,4,1],[5,0,5,1],[13,3,13,4]]}
["Shipper Prime Creation "]
["Last Updated:  01/07/2021"]
[]
["Required Field"]
["Example Line"]
["Description of field information"]
[]
[]
["Required Fields"]
["Item Sub Type","Total Selling Units","Vendor Stock #","Prime","Prime UPC Check Digit","Description","Length (in.)","Width (in.)","Height (in.)","Supplier Pack Weight (lb)","Shipper Effective Date","Pallet Ti","Pallet Hi"]
[99,123,"123PC",1234567890123,4,"123 PIECE PALLET ",10,10,10,10,"mm-dd-yyyy",4,8]
[]
[]
[null,null,null,"Financial Summary"]
[null,null,null,"Total Cost","Total Retail"]
[null,null,null,250,600]
[]
[]
["Items in Assortment"]
[null,"WM Item Nbr","Qty in Shipper (total selling units)"]
["Child",123456789,0]
["Child"]
["Child"]
["Child"]
["Child"]
["Child"]
["Child"]
["Child"]
["Child"]
["Child"]
["Child"]
["Child"]
["Child"]
["Child"]
["Child"]
["Child"]
["Child"]
["Child"]

{"sheet":"Copy Item","index":11,"n_rows":11,"n_cols":23,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Copy to New Item",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GB-Bakery","1-Fresh meat"]
["Last Updated:  06/04/2018",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GC-Dairy","2- Fresh Deli"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GD-Dry Grocery","3- Fresh Dairy"]
["Required Field",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GV- Private label","4- Frozen"]
["Example Line",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GY- Deli","5- Ice Cream"]
["Optional Field",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Distribution","6- Dry Groc"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assembly","7- Wet Produce"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warehouse","8 Dry Produce"]
[null,null,null,null,null,null,null,"Supplier Pack Weight","Whse Pack Dimensions (LxWxH)","Whse Pack Weight","Supplier Number (9 digit)","Pallet Ti","Pallet Hi","Corporate Orderbook","Country of Origin","Factory ID","Warehouse Alignment","Warehouse Area","Item To Cross Reference To",null,null,"AP-staple stock","GF-Frozen Food"]
[null,null,null,null,null,null,null,99.99,"10x15x20",99.99,99999999,99,99,"on/off","NZ",999999999,"xx","x",123456789,null,null,"SS staple stock shoe","GM-Meats and Seafood"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GP-Produce"]

{"sheet":"Scan Issue","index":12,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,3,5,4]]}
["Store Scanning Issue"]
["Last updated 10/29/2018"]
[null,null,null,"Complete this form and submit for research on NOF issues, incorrect item scans store level, ETC."]
["Required Field"]
["Example Line"]
["Optional - Chain Position"]
[]
[]
[]
["UPC Number","Walmart Item Number","Correct Supplier Number","Store Number","Store Issue- Provide scanning error","Comment"]
[123456789123,12345,987654321,100,"Store showing under vendor number 654321"]

{"sheet":"MCN","index":13,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[3,0,3,1],[4,0,4,1]]}
["Merchandise Commerce Number Maintenance"]
["Last Updated:  09/26/2019"]
[]
["Required Field"]
["Example Line"]
[]
["Item Description","UPC","Item #","Current MCN","Action","New MCN","Comments"]
["Tomato",1234567890,0,1234567,"Assign New",7654321]