{"text_format":"2","workbook":"xls","n_sheets":6,"sheets":["Instructions","Data Definitions","Create Plan Example","Create Plan Template","Case Quantity Example","Case Quantity Template"],"not_rendered":{"charts":0,"images":16,"macros":1,"external_links":1,"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":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["How to use your Create 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 \"Create Plan Template\" tab below to view the template you will follow to create Inbound Plans. If you want to create a plan using case quantities, click on the \"Case Quantity Template\" tab. 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 provide 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"]
["Look at the \"Example\" tabs for examples of valid templates to upload. This spreadsheet provides two examples - one for normal plan creation, and another example using case quantities. In order to avoid including invalid information in your request, do not work on your own inbound plan within the \"Example\" worksheet. If you find it helpful, feel free to add color, bold, borders and other formatting (not additional text) to the actual templates templates."]
["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 Inbound Plan Request for testing purposes. After a successful upload, you can create additional requests with more items."]
["Option for Case Packed Items"]
["All three columns - UnitsPerCase, NumberOfCases and Quantity - are required. The Quantity column must equal UnitsPerCase multiplied by NumberOfCases. If you set any of these three to a zero value, we will set the other two to zero as well, and you will have to enter positive values before proceeding in the Seller Central shipping workflow."]
["Notes"]
["Your plan will be named using PlanName field. Once created, the plan can be accessed via the Inbound 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":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,5,11,5]],"flags":["formulas_cached_only"]}
["How to complete your Create Inbound Plan Request template"]
["Label Name","Definition and Use","Accepted Values","Example","Required","Notes"]
["PlanName","A name for the plan. ","An alphanumeric string; 1 character minimum in length and 100 characters maximum in length. ","Plan-books-0910","Required","These fields are required in the header only"]
["ShipToCountry","The country where the shipments created for this plan will be shipped. The default will be the country of your home marketplace.","ISO country code, US for United States, CA for Canada, GB for United Kingdom, DE for Germany, ES for Spain, FR for France, IT for Italy","US","Optional"]
["AddressName","The name of the person sending the shipments created with this plan. ","An alphanumeric string; 1 character minimum in length and 50 characters maximum in length.","Susan McGregor","Required"]
["AddressFieldOne","The first line of the ship-from address","An alphanumeric string; 1 character minimum in length and 180 characters maximum in length.","123 Main Street","Required"]
["AddressFieldTwo","The second line of the ship-from address, if applicable.","An alphanumeric string; 1 character minimum in length and 60 characters maximum in length.",null,"Desired"]
["AddressCity","The city of of the ship-from address.","An alphanumeric string; 1 character minimum in length and 30 characters maximum in length.","Seattle","Required"]
["AddressCountryCode","The country of the ship-from address.","An alphanumeric string 2 character in length.","US","Required"]
["AddressStateOrRegion","The state or region of the ship-from address.","An alphanumeric string 2 character in length. Currently, we only accept standard 2-character state abbreviations.","WA","Required"]
["AddressPostalCode","The postal (zip) code of the ship-from address.","An alphanumeric string; 5 character minimum in length and 10 characters maximum in length.","98104","Required"]
["AddressDistrict","The district of the ship-from address. ","An alphanumeric string; 1 character minimum in length and 50 characters maximum in length.",null,"Optional"]
["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.","An integer that is zero or greater.",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":"Create Plan Example","index":2,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["PlanName","Plan-books-0910"]
["ShipToCountry","US"]
["AddressName","Susan McGregor"]
["AddressFieldOne","123 Main Street"]
["AddressFieldTwo"]
["AddressCity","Seattle"]
["AddressCountryCode","US"]
["AddressStateOrRegion","WA"]
["AddressPostalCode","98104"]
["AddressDistrict"]
[]
["MerchantSKU","Quantity"]
["MySku123","2"]
["MySku999","1"]
["MySku001","1"]
["MySku10020-book","5"]

{"sheet":"Create Plan Template","index":3,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["PlanName"]
["ShipToCountry"]
["AddressName"]
["AddressFieldOne"]
["AddressFieldTwo"]
["AddressCity"]
["AddressCountryCode"]
["AddressStateOrRegion"]
["AddressPostalCode"]
["AddressDistrict"]
[]
["MerchantSKU","Quantity"]

{"sheet":"Case Quantity Example","index":4,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["PlanName","Plan-books-0910"]
["ShipToCountry","US"]
["AddressName","Susan McGregor"]
["AddressFieldOne","123 Main Street"]
["AddressFieldTwo"]
["AddressCity","Seattle"]
["AddressCountryCode","US"]
["AddressStateOrRegion","WA"]
["AddressPostalCode","98104"]
["AddressDistrict"]
[]
["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":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["PlanName"]
["ShipToCountry"]
["AddressName"]
["AddressFieldOne"]
["AddressFieldTwo"]
["AddressCity"]
["AddressCountryCode"]
["AddressStateOrRegion"]
["AddressPostalCode"]
["AddressDistrict"]
[]
["MerchantSKU","UnitsPerCase","NumberOfCases","Quantity"]