{"text_format":"2","workbook":"xls","n_sheets":6,"sheets":["Instructions","Data Definitions","Example","Update Inbound Plan Request","Case Quantity Example","Case Quantity Template"],"not_rendered":{"charts":0,"images":16,"macros":1,"external_links":2,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Instructions","index":0,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["How to use your Update Inbound Plan Request \nTemplate workbook"]
["Step 1"]
["Print this page. "]
["Step 2"]
["Refer to the \"Data Definitions\" tab so you can familiarize yourself with the data that will be entered into your template.  We recommend printing the Definitions sheet so you can refer to it as you examine your template. "]
["Step 3"]
["Click on the \"Update Inbound Plan Request\" tab below to view the template you will follow to create Inbound Plans. The column headers in bold are the required fields - columns with a green background are only required in the header section of the file. To have your request uploaded properly, please complete all required fields.  If you are not providing data for a particular field, leave that field blank (do not fill it with N/A or something similar).   Bold/color formatting is not exported and will not interfere with processing."]
["Step 4 - Example"]
["See the \"Example\" tab for an example upload.  In order to avoid including invalid information in your request, do not work on your own inbound plan within the \"Example\" worksheet. If you would find it helpful, feel free to add color, bold, borders and other formatting (not additional text) to the Inbound Plan Request Template."]
["Step 5 - SAVE AS TAB-DELIMITED"]
["Save your file (as tab delimited .txt file format) and upload via Seller Central.  We highly recommend saving the file for your future reference.  Note: We recommend uploading a single item Update Inbound Plan Request for testing purposes. After a successful upload, you can proceed to create additional requests with more items."]
["Notes"]
["Once updated, the Plan can be accessed via the Plan Queue in Seller Central found at this URL: https://sellercentral.amazon.com/gp/ssof/shipping-queue.html#plans"]

{"sheet":"Data Definitions","index":1,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["How to complete your Update Inbound Plan Request template"]
["Label Name","Definition and Use","Accepted Values","Example","Required","Notes"]
["PlanId","A unique identifier for the plan. ","An alphanumeric string; must match the Plan ID shown in the Plan Queue for the plan to be updated.","PLN2RHD","Required","This field is required in the header only"]
["MerchantSKU","A unique identifier for the product. A MerchantSKU is expected to be listed only once in the file. If a SKU is listed more than once, the last instance of the MerchantSKU in the file will determine the quantity set in the plan.","An alphanumeric string; 1 character minimum in length and 80 characters maximum in length. ","MySku124","Required"]
["Quantity","The number of this item to be included in the plan. This quantity will replace any previous quantity specified for this MerchantSKU","An integer that is zero or greater or the word DELETE to remove this sku from the plan.",1,"Required"]
["UnitsPerCase","If items are to be shipped in cases, this is the number of units in each case.",null,null,"Required (if using the Case Quantity template)"]
["NumberOfCases","If items are to be shipped in cases, this is the number of cases to be included in the shipment.",null,null,"Required (if using the Case Quantity template)"]

{"sheet":"Example","index":2,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["PlanId","PLN2RHD"]
[]
["MerchantSKU","Quantity"]
["MySku123","5"]
["MySku999","12"]
["MySku001","1"]
["MySku10020-book","5"]
["MySku1112343","DELETE"]
["MySku-Book-1","2"]

{"sheet":"Update Inbound Plan Request","index":3,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["PlanId"]
[]
["MerchantSKU","Quantity"]

{"sheet":"Case Quantity Example","index":4,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["PlanId","PLN2RHD"]
[]
["MerchantSKU","UnitsPerCase","NumberOfCases","Quantity"]
["MySku123","2","2","4"]
["MySku999","2","3","6"]
["MySku001","4","2","8"]
["MySku10020-book","2","1","2"]

{"sheet":"Case Quantity Template","index":5,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["PlanId"]
[]
["MerchantSKU","UnitsPerCase","NumberOfCases","Quantity"]