{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Instructions","Data Definitions","Example","Fulfillment Request"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":1,"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 Fulfillment Request Template 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 for reference as you examine your template. "]
["Step 3"]
["Click on the \"Fulfillment Request\" tab below to view the template you will follow to create Fulfillment Requests for Amazon to ship out your products. The column headers in bold are the required fields; columns in green background are item-level (as opposed to order-level) data. 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 does not interfere with processing."]
["Step 4 - Order-level Grouping"]
["Sort your data table by the column marked MerchantFulfillmentOrderID, so items from the same order are contiguous. You may leave blank group-level data for the order-level data in subsequent (all but the first) items in an order. (That is, you don't need to copy the same AddressName value for every item in an order.)   "]
["Step 5 - Example"]
["See the \"Example\" tab for an example upload. In order to avoid including invalid information in your fulfillment request, do not work on your own fulfillment requests 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 Fulfillment Request Template."]
["Step 6 - 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 future reference.  Note: We recommend uploading a single-item Fulfillment Request for testing purposes. After a successful upload, you can proceed to create additional requests."]

{"sheet":"Data Definitions","index":1,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,5,4,5],[5,5,6,5],[7,5,8,5],[11,5,24,5]],"flags":["formulas_cached_only"]}
["How to complete your Fulfillment Request templates"]
["Label Name","Definition and Use","Accepted Values","Example","Required","Notes"]
["MerchantFulfillmentOrderID","A unique identifier for the order. You may use any ID that will help you track this order.  We recommend that you use the same value for both MerchantFulfillmentOrderID and DisplayableOrderID. ","An alphanumeric string; 1 character minimum in length and 40 characters maximum in length. ","Order-0122","Required","Place items with the same value contiguous within the feed."]
["DisplayableOrderID","The identifier to display on the packing slip.  This should match the order number you provide to your customer.","An alphanumeric string; 1 character minimum in length and 40 characters maximum in length. ","Order-0122","Required","For non-lead order items, omit to use same value as the order's lead item."]
["DisplayableOrderDate","The order date to display on the packing slip.","A date in xsd:dateTime format:  [-]CCYY-MM-DDThh:mm:ss[Z|(+|-)hh:mm]          ","2001-10-26T21:32:52","Required"]
["MerchantSKU","A unique identifier for the product, assigned by the merchant.  The SKU must be unique for each product listed.","An alphanumeric string; 1 character minimum in length and 40 characters maximum in length.","MySku123","Required","Item Level Columns"]
["Quantity","The number of this item to ship.","A positive integer.",1,"Required"]
["MerchantFulfillmentOrderItemID","A unique identifier for the item within the order.","An alphanumeric string; 1 character minimum in length and 80 characters maximum in length.",1,"Required"]
["GiftMessage","The gift message displayed on the packing slip for this item.","An alphanumeric string; 1 character minimum in length and 512 characters maximum in length.","Happy Birthday","Desired"]
["DisplayableComment","A comment displayed on the packing slip for this item.","An alphanumeric string; 1 character minimum in length and 250 characters maximum in length.","Item ships in its own box.","Desired"]
["PerUnitDeclaredValue","Required for FBA Export only.  The perUnitDeclaredValue may be specified to indicate the monetary value assigned to each unit of inventory for this line item","A numeric string; decimal value is valid; 1 character minimum length and maximum is 20 characters, the PerUnitDeclaredValue should be greater than or equal to 0.",200.99,"Desired"]
["DisplayableOrderComment","This text will be placed on the packing slip with your order. We recommend that you include information about your return policy, contact information for service requests, etc.","An alphanumeric string; 1 character minimum in length and 150 characters maximum in length. ","Thank you for ordering from YourWebsite.com.  We appreciate your order.  For customer returns, please visit http://yourwebsite.com/returns.","Required","For non-lead order items, omit to use same value as the order's lead item."]
["DeliverySLA","The delivery service level (Standard, Expedited, Priority) requested for the order.  Standard is 3-5 business days, Expedited is 2 business days, and Priority is 1 business day.","Standard, Expedited, Priority.  Standard assumed when omitted.","Standard","Required"]
["AddressName","The name of the recipient.","An alphanumeric string; 1 character minimum in length and 50 characters maximum in length.","Susan McGregor","Required"]
["AddressFieldOne","The first line of the recipient's address.","An alphanumeric string; 1 character minimum in length and 60 characters maximum in length.","123 Anywhere Street","Required"]
["AddressFieldTwo","The second line of the recipient's address, if applicable.","An alphanumeric string; 1 character minimum in length and 60 characters maximum in length.",null,"Desired"]
["AddressFieldThree","The third line of the recipient's 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 recipient's address.","An alphanumeric string; 1 character minimum in length and 50 characters maximum in length.","Seattle","Required"]
["AddressCountryCode","The country of the recipient's address.","An alphanumeric string 2 character in length. For FBA Export, Amazon-supported countries can be found on the following list : http://www.amazon.com/gp/help/customer/display.html/?nodeId=537734#outside.  The list of accepted 2 character ISO county codes can be found at http://www.iso.org/iso/iso-3166-1_decoding_table. ","US","Required"]
["AddressStateOrRegion","The state or region of the recipient's address.","An alphanumeric string 2 character in length. ","WA","Required"]
["AddressPostalCode","The postal (zip) code of the recipient's address.","An alphanumeric string; 5 character minimum in length and 10 characters maximum in length.","98104","Required"]
["AddressPhoneNumber","The recipient's phone number, if available.","An alphanumeric string; 1 character minimum in length and 20 characters maximum in length.","206-555-1212","Desired"]
["NotificationEmail","The notificationEmail provides e-mail addresses to receive e-mail notifications when items are shipped.","An alphanumeric string;64 characters maximum in length. ","youremail@server.com","Desired"]
["FulfillmentAction","The action to take upon processing this request.","Hold, Ship. Ship assumed when omitted.","Ship","Desired"]
["MarketplaceID","The marketplace on which the order should be placed.","A valid marketplace ID corresponding to the Amazon marketplace the order should be placed on. If omitted, the marketplace originally used for registration will be used. Valid marketplace values can be found in the Amazon Marketplace Web Service (MWS) Developer Guide.","ATVPDKIKX0DER","Desired"]

{"sheet":"Example","index":2,"n_rows":7,"n_cols":23,"rows_kept":7,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["MerchantFulfillmentOrderID","DisplayableOrderID","DisplayableOrderDate","MerchantSKU","Quantity","MerchantFulfillmentOrderItemID","GiftMessage","DisplayableComment","PerUnitDeclaredValue","DisplayableOrderComment","DeliverySLA","AddressName","AddressFieldOne","AddressFieldTwo","AddressFieldThree","AddressCity","AddressCountryCode","AddressStateOrRegion","AddressPostalCode","AddressPhoneNumber","NotificationEmail","FulfillmentAction","MarketplaceID"]
["Order-0122","Order-0122","2001-10-26T21:32:52","MySku123","1","AN-123","Happy Birthday",null,null,"Please enjoy these items. We are happy to do business with you again.","Standard","Susan McGregor","123 Anywhere Street",null,null,"Seattle","US","WA","98104","206-555-1212","youremail@server.com","Ship","ATVPDKIKX0DER"]
["Order-0122",null,null,"MySku998","5","AN-998"]
["Order-0122",null,null,"MySku456","2","AN-456"]
["Order-0123","Order-0123","2001-10-26T21:32:52","MySku003","1","AN-003",null,null,"49.98","Thank you for ordering from YourWebsite.com. We appreciate your order. For customer returns, please visit http://yourwebsite.com/returns.","Standard","Jane Marksman","321 Main Street",null,null,"Vancouver","CA","BC","V5K 1N6",null,null,"Hold","ATVPDKIKX0DER"]
["Order-0124","Order-0124","2001-10-26T21:32:52","MySku003","10","AN-003","Thanks for everything, see you next year.",null,null,"Thank you for ordering from YourWebsite.com. We appreciate your order. For customer returns, please visit http://yourwebsite.com/returns.","Priority","John Holden","246 Maple Street","Apt 3G",null,"Boston","US","MA","02101",null,null,null,"ATVPDKIKX0DER"]
["Order-0125","Order-0125","2001-10-26T21:32:52","MySku190",7,"Item-1",null,null,null,"Thank you from ordering from CanadianWebsite.ca.","Standard","Mark Smith","1723 Main Street",null,null,"Vancouver","CA","BC","V5K 1N6",null,null,null,"A2EUQ1WTGCTBG2"]

{"sheet":"Fulfillment Request","index":3,"n_rows":1,"n_cols":23,"rows_kept":1,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["MerchantFulfillmentOrderID","DisplayableOrderID","DisplayableOrderDate","MerchantSKU","Quantity","MerchantFulfillmentOrderItemID","GiftMessage","DisplayableComment","PerUnitDeclaredValue","DisplayableOrderComment","DeliverySLA","AddressName","AddressFieldOne","AddressFieldTwo","AddressFieldThree","AddressCity","AddressCountryCode","AddressStateOrRegion","AddressPostalCode","AddressPhoneNumber","NotificationEmail","FulfillmentAction","MarketplaceID"]