{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Instructions","WATCHES\n (25.1.2021)","Refinements","DB"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":35,"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":45,"n_cols":3,"rows_kept":45,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"How to use the Browse Tree Guide"]
[null,null,"These usage notes reveal proprietary information. Please do not forward to anyone not bound by Amazon.ca's confidentiality agreement."]
[null,"    "]
[null,"Background Information & General Definitions"]
[null," ","The Browse Tree Guides (BTGs) contain the rules that Amazon.ca uses to assign products to browse categories online.  In it you will find mappings between browse categories and  Amazon's list of controlled terms which will allow your product to surface in those categories."]
[]
[null," ","The Browse Tree Guide is a tool to assist you in merchandising your products effectively online."]
[]
[null," ","Category to term mappings are works in progress and are subject to ongoing revision."]
[]
[null," ","To categorize products in browse categories, Amazon relies upon data in catalog records as supplied by merchants. The data used by Browse is found in the following universal catalog field:"]
[null," ","-RecommendedBrowseNode1    "]
[null," ","-RecommendedBrowseNode2"]
[]
[null," ","The field is populated using a controlled list of terms that describe individual products."]
[]
[null," ","Amazon.ca uses this data to create groups of categories called browse trees. These categories are structured in logical paths so that users can navigate from point to point in the browse tree. Each point in the path is a browse node. A point that has subcategories is a branch node, and a node that is the terminal point in the path is a leaf node. Browse nodes are identified by their browse node IDs."]
[]
[null,"Instructions for Use   "]
[null," ","Navigate to the next tab"]
[null," ","Locate the category path that best describes your product."]
[null," ","Once identified, ensure the numeric value for the node is placed in RecommendedBrowseNode1-2."]
[null," ","Attention: Please do not assign to the greyed out main categories since they serve primarily to clarify the navigation within this document. The use of these main categories is recommended only in the exceptional case that your product(s) do not fit into any available product categories."]
[null," ","For example:"]
[null," ","You need to classify: Spin Dryers"]
[null," ","You locate the node: 10706311 Large Appliances/Washing Machines & Tumble Dryers/Spin Dryers"]
[null," ","In the production template you paste the corresponding NodeId in the field RecommendedBrowseNode1"]
[null," ","RecommendedBrowseNode1=10706311"]
[]
[null," ","Note that we have provided you with a second field for RecommendedBrowseNode - this is in case you have come across an additional node that is relevant for your product.  Please only use this additional field in select cases where it absolutely makes sense."]
[]
[null,"\t    "]
[null,"Adding your Products to Refinements"]
[null," ","Selecting a browse category on the website can trigger useful additional refinement possibilities which allow customers to narrow the product selection for an enhanced shopping experience."]
[null," ","For your product to appear in refinements you need to provide additional data. Using the BTG tab, you will first determine the correct primary category for your product. Once located, you can click on the link to the right of your chosen browse category which will take you to the refinements tab of the document. There In the refinements tab you will see the corresponding refinements available for the category you have selected."]
[null,"  "]
[null,"  ","The refinements tab will display the following columns from left to right:"]
[null,"  "," - Node ID [Node ID of the primary browse category selected]"]
[null,"  "," - Node Name [Descriptive name of the primary browse category selected]"]
[null,"  "," - Refinement Name [Website display name of the refinement]"]
[null,"  "," - Attribute [Field in which to upload the data to describe your product]"]
[null,"  "," - Accepted Values (combo boxes) [Terms to add to the corresponding attribute field which will get the product into the correct refinement]"]
[null,"  "," - Modifiers [for some attributes you can select a modifier e.g. storage_capacity has GB as modifier]"]
[null,"  "]
[null,"  ","To determine the data you need, identify the correct refinement to accurately describe your product. The Attribute column will tell you which field to add your data. The Valid Value Combo Box column will tell you which terms are accepted for that field."]

{"sheet":"WATCHES\n (25.1.2021)","index":1,"n_rows":77,"n_cols":5,"rows_kept":77,"cut":false,"hidden":false,"merged":[],"flags":["cells_out_of_order","formulas_cached_only","rows_out_of_order"]}
[null,"Node Path",null,"Refinement Link","Node ID"]
[2235621011,"Watches"]
[2304964011,"Watches/Accessories"]
[7012503011,"Watches/Accessories/Cabinets & Cases"]
[7012504011,"Watches/Accessories/Pocket Watch Chains"]
[7012505011,"Watches/Accessories/Repair Tools & Kits"]
[8876990011,"Watches/Accessories/Smart Watch Accessories"]
[18108428011,"Watches/Accessories/Smart Watch Accessories/Cables"]
[18108429011,"Watches/Accessories/Smart Watch Accessories/Charging Docks"]
[18108430011,"Watches/Accessories/Smart Watch Accessories/Replacement Bands"]
[18108431011,"Watches/Accessories/Smart Watch Accessories/Screen Protectors"]
[18108432011,"Watches/Accessories/Smart Watch Accessories/Skins"]
[7012550011,"Watches/Accessories/Watch Bands"]
[7012509011,"Watches/Accessories/Watch Bands/Boys' Watch Bands"]
[7012514011,"Watches/Accessories/Watch Bands/Girls' Watch Bands"]
[7012518011,"Watches/Accessories/Watch Bands/Men's Watch Bands"]
[7012522011,"Watches/Accessories/Watch Bands/Women's Watch Bands"]
[7012506011,"Watches/Accessories/Watch Winders"]
[7012507011,"Watches/Boys"]
[7012508011,"Watches/Boys/Pocket Watches"]
[7012509011,"Watches/Boys/Watch Bands"]
[7012510011,"Watches/Boys/Wrist Watches"]
[7012511011,"Watches/Girls"]
[7012513011,"Watches/Girls/Pocket Watches"]
[7012514011,"Watches/Girls/Watch Bands"]
[7012515011,"Watches/Girls/Wrist Watches"]
[7012516011,"Watches/Men"]
[15863987011,"Watches/Men/Certified Pre-Owned"]
[21353429011,"Watches/Men/Fashion Smartwatches"]
[7012517011,"Watches/Men/Pocket Watches"]
[7012518011,"Watches/Men/Watch Bands"]
[7012519011,"Watches/Men/Wrist Watches"]
[7014069011,"Watches/Novelty Watches"]
[7012520011,"Watches/Women"]
[15863988011,"Watches/Women/Certified Pre-Owned"]
[21353428011,"Watches/Women/Fashion Smartwatches"]
[7012521011,"Watches/Women/Pocket Watches"]
[7012522011,"Watches/Women/Watch Bands"]
[7012523011,"Watches/Women/Wrist Watches"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]
[null,null,null,"See Available Refinements"]

{"sheet":"Refinements","index":2,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Node ID","Node Name","Refinement Name","Attribute","Accepted Values (combo boxes)","Modifiers"]
[7012508011,"Boys' Pocket Watches","Customer Reviews","review-rating\n"]
[7012509011,"Boys' Watch Bands","Customer Reviews","review-rating\n"]
[7012507011,"Boys' Watches","Customer Reviews","review-rating\n"]
[7012510011,"Boys' Wrist Watches","Customer Reviews","review-rating\n"]
[7012513011,"Girls' Pocket Watches","Customer Reviews","review-rating\n"]
[7012514011,"Girls' Watch Bands","Customer Reviews","review-rating\n"]
[7012511011,"Girls' Watches","Customer Reviews","review-rating\n"]
[7012515011,"Girls' Wrist Watches","Customer Reviews","review-rating\n"]
[15863987011,"Men's Certified Pre-Owned Watches","Customer Reviews","review-rating\n"]
[21353429011,"Men's Fashion Smartwatches","Customer Reviews","review-rating\n"]
[7012517011,"Men's Pocket Watches","Customer Reviews","review-rating\n"]
[7012518011,"Men's Watch Bands","Customer Reviews","review-rating\n"]
[7012516011,"Men's Watches","Customer Reviews","review-rating\n"]
[7012519011,"Men's Wrist Watches","Customer Reviews","review-rating\n"]
[7014069011,"Novelty Watches","Customer Reviews","review-rating\n"]
[7012504011,"Pocket Watch Chains","Customer Reviews","review-rating\n"]
[8876990011,"Smart Watch Accessories","Customer Reviews","review-rating\n"]
[18108428011,"Smart Watch Cables","Customer Reviews","review-rating\n"]
[18108429011,"Smart Watch Charging Docks","Customer Reviews","review-rating\n"]
[18108430011,"Smart Watch Replacement Bands","Customer Reviews","review-rating\n"]
[18108431011,"Smart Watch Screen Protectors","Customer Reviews","review-rating\n"]
[18108432011,"Smart Watch Skins","Customer Reviews","review-rating\n"]
[2304964011,"Watch Accessories","Customer Reviews","review-rating\n"]
[7012550011,"Watch Bands","Customer Reviews","review-rating\n"]
[7012503011,"Watch Cabinets & Cases","Customer Reviews","review-rating\n"]
[7012505011,"Watch Repair Tools & Kits","Customer Reviews","review-rating\n"]
[7012506011,"Watch Winders","Customer Reviews","review-rating\n"]
[2235621011,"Watches","Customer Reviews","review-rating\n"]
[15863988011,"Women's Certified Pre-Owned Watches","Customer Reviews","review-rating\n"]
[21353428011,"Women's Fashion Smartwatches","Customer Reviews","review-rating\n"]
[7012521011,"Women's Pocket Watches","Customer Reviews","review-rating\n"]
[7012522011,"Women's Watch Bands","Customer Reviews","review-rating\n"]
[7012520011,"Women's Watches","Customer Reviews","review-rating\n"]
[7012523011,"Women's Wrist Watches","Customer Reviews","review-rating\n"]

{"sheet":"DB","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}