{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Instructions","Definitions","ShippingConfirmation"],"not_rendered":{"charts":0,"images":4,"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":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["How to prepare your Shipping Confirmation Template"]
["Create a Shipping Confirmation file, using this template, to inform your customers of when and how you shipped their order(s).  The information you are providing will appear in customers' \"Your Account\" area.  See the \"ORDERS\" tab -> \"Upload Shipping Confirm File\" within Seller Central for instructions on how to upload this file."]
[]
["How to use the features of the Shipping Confirmation Template"]
["This template contains validation macros that will help you complete the template correctly. The validations may be turned on or off at your discretion, but we urge you to keep them on until you learn how to use the template. The following is a list of helpful hints on how to use the validation macros."]
["Enabling Macros: If you disabled the validation macros when you opened this file, you will need to close this file and open it again to enable them. Upon reopening the file, check “Always trust macros from this source” in the security warning that appears.  Next, select \"Enable Macros.\"  This will enable the macros each time you access the files.  If you are not confident that you know how to complete this adjustments template correctly, we strongly recommend you enable macros.  \n"]
["Drop-down menus: If you wish to enter data in a cell where a drop-down menu is presented, you must select a value from the drop-down menu.  You cannot type in your own value, even if it is valid.  If you receive an error, delete the existing value and choose an alternative from the drop-down menu."]
["Amazon.com Toolbar: This floating toolbar appears when the macros are enabled.  It provides quick access to Seller Central, a \"Validate\" option,  and a toggle button for turning the validations on or off.  To access Seller Central, you must have an active Internet connection. The \"Validate\" button allows you to run a validation on the data that has been entered into the template. This feature works regardless of whether the validations are on or off. If you close the Amazon.com Toolbar, it can be reopened by selecting \"Toolbars -> Amazon.com\" from the View menu."]
["Definitions: By double-clicking on a cell, the definition for that cell will be displayed. This generally gives you the requirement level, definition, accepted value and example entry for the cell. This is a quick way to check the validity of your entry in the cell."]
[".log File: The macros will create a .log file of errors and warnings in the same location as your Product Template. The warnings will indicate which cells still require an entry. The errors are macro failures. You can delete this .log file once you have successfully uploaded your inventory file."]
[]
["Step 1"]
["Open the order report that contains the orders you are confirming. You will need to copy into this template some of the information contained in them."]
[]
["Step 2"]
["Click the \"ShippingConfirmation\" tab and enter the appropriate data relating to the shipment you are confirming. For help understanding each field, click the \"Definitions\" tab. \nYou can combine multiple shipment confirmations in a single file for upload.\nThe more complete the information is that you provide, the fewer contacts you are likely to receive from your customers."]
[]
["Step 3"]
["When you've populated the \"ShippingConfirmation\" tab with your data and are ready to generate a file for upload, first save a copy of this file as an Excel workbook.  Next, select the \"ShippingConfirmation\" tab and save the file as a \"Text (Tab-delimited) (*.txt)\" file.  This text file is your file to be uploaded via Seller Central."]
[]
["Still have questions?"]
["If you have not been able to find the answers you need in these instructions or in the Data Definitions, then please visit the Seller Central Help Center for additional support."]
["Seller Central Help Center"]

{"sheet":"Definitions","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,3],[13,0,13,3]],"flags":["formulas_cached_only"]}
["Definitions - Shipping Confirmation Template"]
["Bold items are required however, the more complete information you provide, the fewer customers service contacts you will receive. "]
["Label Name","Description","Accepted Values","Example"]
["order-id","Amazon's unique, displayable identifier for an order, provided in your OrderReport.","Alphanumeric text with 17 numbers, formatted as ###-#######-#######.","123-1234567-1234567"]
["order-item-id","Amazon's unique, displayable identifier for an item within an order, provided in your OrderReport. This is not required if you are confirming shipment of an entire order. Please see the note below for split shipments.","A positive Integer of 14 numbers in length.","12345678901234"]
["quantity","If more than one unit of an item has been ordered, this is the quantity of that item included in this shipment.  If you are splitting a shipment, it is required that you include a quantity in the shipping confirmation for each of the split shipments, so customers know how many items to expect when each shipment arrives.","A positive whole number.","23456"]
["ship-date","The date that the order/items were actually shipped or picked up, depending on the fulfillment method specified in the order.  For instructions on how to upload this report, log on to your Amazon.com Merchant Account and click on the Transactions Page.","A date in this format: yyyy-mm-dd, which indicates the shipment date of the product.","2002-12-02"]
["carrier-code","The shipping carrier that delivered the item. Select from the enumerated options at right or offered in the drop-down menu. \nNOTE:  If you are using a carrier that is not listed, please enter 'Other' in this field and refer to the carrier-name field.","Select one of the following: \n• UPS\n• UPSMI\n• USPS\n• DHL\n• DHL Global Mail\n• FedEx\n• FedEx Smartpost\n• OnTrac\n• Newgistics\n• Canada Post\n• Lasership","USPS"]
["carrier-name","The shipping carrier that delivered the item. Open string; Merchants may choose carrier-name instead of carrier-code if the latter does not contain the carrier used.\nNOTE: :  Please populate this field only when a value of 'Other' is provided in the carrier-code field.","Alphanumeric text, 1 character minimum, 50 characters maximum.","Airborne Express"]
["tracking-number","The tracking number for the shipment of the item.\n","Alphanumeric text, 1 character minimum, 50 characters maximum.",22344455]
["ship-method","The shipping method that was used to deliver the item.","Alphanumeric text, 1 character minimum, 50 characters maximum.","First Class"]
[]
["Important Note Regarding Split Shipments:"]
["If a customer has ordered more than one item from you and you are fulfilling the order in more than one shipment, then order-id, order-item-id, quantity and ship-date are all required for each shipment that your are confirming."]

{"sheet":"ShippingConfirmation","index":2,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["order-id","order-item-id","quantity","ship-date","carrier-code","carrier-name","tracking-number","ship-method"]