{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Data Definitions","Valid Values","BookLoader Template"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Data Definitions","index":0,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,4]],"flags":["formulas_cached_only"]}
["How to complete your BookLoader template:"]
["Field Name","Definition","Accepted Values","Example","Required/Optional"]
["author","Author name(s).","Any string value up to 200 characters.","J.K.Rowling","Required if product-id is absent."]
["title","Title of the book.","Any string value up to 500 characters.","Harry Potter and the Half-Blood Prince (Book 6)","Required if product-id is absent."]
["publisher","The book's publisher.","Any string value up to 500 characters.","Scholastic, Inc. (July 16, 2005)","Required if product-id is absent."]
["pub-date","Date of publication (edition-specific).","A date value with format of YYYY-MM-DD.","2007-01-25","Required if product-id is absent."]
["binding","Binding type (hardcover, paperback, etc.).","See 'Valid Values' worksheet.","paperback","Required if product-id is absent."]
["illustrator","Illustrator name(s).","Any string value up to 50 characters.","John Smith","Optional."]
["condition","You can enter textual condition descriptions into this field instead of using numeric condition codes in the item-condition field. If no value is provided in the item-condition field, but a product-id is either provided in the listing, or assigned during the upload process, the Book Loader will take any text entry in the condition field and attempt to classify it as one of the Used conditions (see 'Valid Values' worksheet). If no match can be found, the item-condition will default to Used; Acceptable.","See 'Valid Values' worksheet.","New","Optional."]
["edition","Edition of the book.","Any string value up to 50 characters.","Third","Optional."]
["comments","This field is no longer in use. The column heading is being left in place for backwards compatibility, but any contents in this field will be ignored.","N/A","N/A","N/A"]
["price","The price (per item), in local currency, without currency symbols.","Item price.","9.99","Required if product-id is absent."]
["sku","A SKU is a \"stock keeping unit\" used to track inventory. The SKUs must be unique for each individual item in your current template and existing listings.","Any string up to 40 characters.","12345","Required"]
["category1","This field is no longer in use. The column heading is being left in place for backwards compatibility, but any contents in this field will be ignored.","N/A","N/A","N/A"]
["image-url","This field is no longer in use. The column heading is being left in place for backwards compatibility, but any contents in this field will be ignored.","N/A","N/A","N/A"]
["main-offer-image","The URL where the main offer-specific image of the product is located.\n\nThis column is used for Collectible Book listings.","Images should have 72-pixels-per-inch resolution and be 500 pixels minimum in length (on the longest side). The preferred file format is JPEG (.jpg). When naming your image, please use the following convention: Product SKU + View Indicator (i.e., .main) + File Extension (i.e., .jpg). An example would be: \"15774.main.jpg\". Save the image to your Web server and supply the URL to the image in this field. There cannot be any spaces or high ascii characters in the image url.","http://www.companyname.com/images/1250.offer.jpg","Optional."]
["offer-image1 - offer-image4","The URL where an offer-specific image of the product is located.\n\nThis column is used for Collectible Book listings.","Images should have 72-pixels-per-inch resolution and be 500 pixels minimum in length (on the longest side). The preferred file format is JPEG (.jpg). When naming your image, please use the following convention: Product SKU + View Indicator (i.e., .main) + File Extension (i.e., .jpg). An example would be: \"15774.main.jpg\". Save the image to your Web server and supply the URL to the image in this field. There cannot be any spaces or high ascii characters in the image url.","http://www.companyname.com/images/1250.offer.jpg","Optional."]
["quantity","Enter a non-negative integer greater than zero. \nIf you are enrolled in Fulfillment By Amazon and Amazon fulfills this product for you, do not supply a quantity, as Amazon will determine this from inventory on hand.  If Amazon fulfills this product, submitting a quantity will switch the item to Merchant-fulfilled, and remove the Amazon-fulfilled offering.","Any integer between 1 and 1000.","`","Desired."]
["add-delete","Indicate with a 'd' those listings you wish to delete from your current inventory. Indicate with an 'a' those listings you wish to update/add to your current inventory. If no value is provided for this field, the record will be applied as an update/add.","a = (update/add)\nd = (delete)\n","a","Optional (defaults to update/add when absent)."]
["will-ship-internationally","Select the code corresponding to your choice: \"1\" or \"n\": Will ship within US only; \"2\" or \"y\": Will ship to international locations","\"1\" or \"n\"  = Will ship in US only\n\"2\" or \"y\" = Will ship to international locations","1","Optional."]
["expedited-shipping","Select the option corresponding to your choice: \"y\" if you are offering expedited shipping to your customers; \"n\" otherwise.","\"n\" = Expedited shipping not available\n\"y\" = Expedited shipping available","n","Optional."]
["item-is-marketplace","This field is no longer in use. The column heading is being left in place for backwards compatibility, but any contents in this field will be ignored.","N/A","N/A","N/A"]
["product-id","The ISBN of your book listing (if applicable). This field is optional, but recommended if you have it cataloged in your database or can otherwise provide it.  If product-id is not provided, then the following six fields are required: author, title, publisher, pub-date, binding, and price.","Any valid ISBN","0452011876","Required, unless the following six fields are submitted: author, title, publisher, pub-date, binding, and price."]
["product-id-type","A numerical entry that indicates if the product-id is an ASIN, ISBN, UPC, or EAN code/number. When uploading files in Standard Book format, this field value will default to 2 (ISBN) unless otherwise specified.","1 = ASIN\n2 = ISBN\n3 = UPC\n4 = EAN","2","Required if product-id is present."]
["item-condition","A numerical entry that indicates the condition of the item. Review the condition guidelines definitions.","1 = Used; Like New\n2 = Used; Very Good\n3 = Used; Good\n4 = Used; Acceptable\n5 = Collectible; Like New\n6 = Collectible; Very Good\n7 = Collectible; Good\n8 = Collectible; Acceptable\n11 = New",2,"Desired."]
["item-note","You can use this field to describe any differences your item might have from the New item sold at Amazon.com. This field is limited to 1000 characters for all Used, New, Collectible, and Refurbished items appearing as Amazon Marketplace listings.","Any string up to 1000 characters.","Slightly worn on the corners.","Desired."]
["browse-path","This field is no longer in use. The column heading is being left in place for backwards compatibility, but any contents in this field will be ignored.","N/A","N/A","N/A"]
["storefront-feature","This field is no longer in use. The column heading is being left in place for backwards compatibility, but any contents in this field will be ignored.","N/A","N/A","N/A"]
["boldface","This field is no longer in use. The column heading is being left in place for backwards compatibility, but any contents in this field will be ignored.","N/A","N/A","N/A"]
["fulfillment-center-id","Amazon-fulfilled products: For those merchants using Amazon fulfillment services, this designates which fulfillment network will be used to fulfill this item. Specifying 'AMAZON_NA' will cancel any existing Merchant-fulfilled offering for the item.  Resubmitting with no value, or with a value of ‘DEFAULT’ for the fulfillment-center-id, along with quantity, will switch the item back to Merchant-fulfilled.  \nMerchant-fulfilled products: Do not enter fulfillment-center-id, as it is not applicable.","AMAZON_NA","AMAZON_NA","Optional"]
["dust-jacket","This field takes a numerical entry that indicates the condition and presence of the dust jacket. This column is used for Collectible Book listings.","0 = No Dust Jacket\n1 = Like New\n2 = Very Good\n3 = Good\n4 = Acceptable","2","Desired for Collectible Book Items."]
["signed-by","This field indicates the Contributor Role of the autographer (e.g., Author, Illustrator, Editor, Photographer, Other).  If this field is populated with a valid value, it indicates that the book being offered is signed, and the offer will receive a “Signed” flag on the Collectible Offer Listing Page.  This field is typically used for Collectible Book listings.","See 'Valid Values' worksheet.","Author","Optional"]

{"sheet":"Valid Values","index":1,"n_rows":145,"n_cols":3,"rows_kept":145,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Valid Values:"]
["binding","condition","signed-by"]
["unknown_binding","New","Author"]
["mass_market","Used","Illustrator"]
["paperback","Collectible","Editor"]
["hardcover","Refurbished","Photographer"]
["school","Club","Other"]
["cassette"]
["audioCD"]
["VHStape"]
["audio_video"]
["misc_supplies"]
["software"]
["spiral_bound"]
["cd_rom"]
["map"]
["poster"]
["leather_bound"]
["accessory"]
["game_cartridge"]
["ring_bound"]
["dvd"]
["t_shirt"]
["hat"]
["microfiche"]
["board_book"]
["game"]
["roughcut"]
["unbound"]
["turtleback"]
["vas"]
["journal"]
["flap"]
["pop-up"]
["lp_record"]
["perfect"]
["mini_disc"]
["dcc"]
["consumer_electronics"]
["toy"]
["gift"]
["puppet"]
["game_blocks"]
["game_computer"]
["game_video"]
["game_board"]
["housewares"]
["workbook"]
["nintendo64"]
["jewelry"]
["stationery"]
["battery"]
["miscellaneous"]
["diskette"]
["3_5_inch_disk"]
["3_5_and_5_25_inch_disk"]
["5_25_inch_disk"]
["theatrical_release"]
["license"]
["volume_license"]
["multiple_license"]
["lawn_and_garden"]
["digital"]
["tools"]
["bundle"]
["wireless_phone_accessory"]
["wireless_plan"]
["wireless_phone_SIMM"]
["paperback_bunko"]
["pod_generic"]
["pod_paperback"]
["pod_hardback"]
["wireless_collateral"]
["tankobon_hardcover"]
["tankobon_softcover"]
["magnetic_media"]
["comic"]
["mook"]
["jp_oversized_book"]
["e-points"]
["digital_audio_tape"]
["audio_reel_tape"]
["baby_product"]
["film"]
["slide"]
["transparency"]
["microfilm"]
["card_book"]
["wall_chart"]
["audio_download"]
["rag_book"]
["dvd_audio"]
["pc"]
["prepaid_phone_card"]
["health_and_beauty"]
["target_apparel"]
["target_home"]
["target_jewelry"]
["target_outdoor_sport"]
["target_gift"]
["target_ce"]
["target_kitchen"]
["target_gift_card"]
["target_luggage"]
["target_media"]
["target_beauty"]
["target_toys"]
["target_hardware"]
["target_food"]
["target_pets"]
["target_sports"]
["cadillac_binding"]
["bargain_book"]
["textbook"]
["laser_disc"]
["calendar"]
["pamphlet"]
["sheet_music"]
["cards"]
["consumer_magazine"]
["plastic_comb"]
["camera"]
["game_puzzle"]
["playstation"]
["home_improvement"]
["cd_rom_and_3_5_inch_disk"]
["wireless_phone"]
["wireless_plan_option"]
["paperback_shinsho"]
["paper_catalog"]
["target_baby"]
["target_furniture"]
["office_product"]
["watch"]
["loose_stones"]
["album"]
["bath_book"]
["foam_book"]
["video_cd"]
["hardcover_comic"]
["loose_leaf"]
["pocket_book"]
["email_gift_certificate"]
["paper_gift_certificate"]
["ecard_gift_certificate"]

{"sheet":"BookLoader Template","index":2,"n_rows":1,"n_cols":33,"rows_kept":1,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["author","title","publisher","pub-date","binding","illustrator","condition","edition","comments","price","sku","category1","image-url","main-offer-image","offer-image1","offer-image2","offer-image3","offer-image4","quantity","add-delete","will-ship-internationally","expedited-shipping","item-is-marketplace","product-id","product-id-type","item-condition","item-note","browse-path","storefront-feature","boldface","fulfillment-center-id","dust-jacket","signed-by"]