Dogtamer:
…
It’s perhaps noteworthy that the links to Book Loader on the still-extant “Text-File” version “Inventory file templates, style guides, and browse tree guides” SHC page (renamed ca. 2020 from the previous “Inventory file templates and BTG”) @ https: //sellercentral.amazon.com/help/hub/reference/1641 are either inoperative, or now lead to an entirely-unrelated page…
Dogtamer:
…
At some point between the time I made the above-quoted 020725 post and today,* 112625, Amazon has eviscerated that SHC (“Seller Help Content”) page nearly entirely, removing the decades-old table of links (links that slowly deteriorated in performance, especially since the 2018 Help Consolidation Initiative began) to templates, application pages, BTGs (“Browse Tree Guides”), & Category Style Guides entirely :
…
In a 'glass half-full" moment, I see that as of 010426 (the date I first discovered the latest change, & archived the page as reproduced below; in a vain & forlorn hope that the observed inaccuracies might possibly be ‘anchors’ for a page still under construction, I waited 2 weeks to see if anything changed before posting this reply), the Editorial Team has restored the BTG table to that SHC page:
Inventory file templates, style guides, and browse tree guides
On this page
Product Spreadsheet
Video Tutorial
Listing Loader
Price and Quantity
Style guides and Browse Tree Guides
Troubleshooting
A catalog bulk template is a Microsoft Excel spreadsheet that contains multiple data columns for describing your products. You can use these templates to create and update your products and offers on Amazon. There are 3 main types of templates to create and manage your listings in bulk:
Product Spreadsheet – primarily used to create new products that are not currently listed in the Amazon catalog. You can generate spreadsheet templates specific to the types of products you sell. You can list information for different types of products across multiple categories in one template, up to a limit of 20 product types.
Listing Loader – primarily used to create new offers on products that are already listed in the Amazon catalog. You can search for products and download a pre-filled template, or start from a blank template.
Price & Quantity template – primarily used to update your existing offers on products in the Amazon catalog with minimal requirements.
Product Spreadsheet
You can create products that do not exist yet in the Amazon catalog and add offers for them using the Product Spreadsheet. Product details are required in this template. Follow these steps to create your listings:
Go to Add Products section on Seller Central; choose Spreadsheet tab; click Download a blank template and select List products that are not currently in Amazon’s catalog card.
Select the Product Types you want to sell, using the search box (Limit: Up to 20 Product Types per file). Review your selected Products Types.
Select the Stores you are interested in selling in.
Click Generate spreadsheet to generate and download a blank template. You can find it later in the Previously Generated Templates section. This will have the attributes of the product types you selected.
For the products you want to sell, follow these steps:
Add information to the columns in the template for Product identity and details, Variations, Safety & Compliance, Offer etc. Attributes may be required, conditionally required or optional. Repeat for all products in your list.
Upload the completed file by going to Add Products and choosing Spreadsheet .
You can check the processing summary for your SKUs by clicking Check Upload Status .
Note: We do not maintain or support “category” template types anymore, but you can go to the section below on Style guides and Browse Tree Guides for product types that require approvals and additional information.
Video Tutorial
Go to the following link for video tutorial and additional information: Match or create product listings and variations in bulk
Listing Loader
You can search for products that already exist in the Amazon catalog and add your own offers to them using the Listing Loader template. Minimal product details are required to add offers. You can choose to generate a blank Listing Loader file by not providing any product IDs in the search box and edit your blank file, or pre-fill SKUs in the file before template generation. Follow these steps to add offers:
Go to Add Products section on Seller Central; choose Spreadsheet tab; click Download a blank template and select List Products already in Amazon’s catalog card.
Select the template Language and Store you are interested in selling in.
[OPTIONAL]: You can search for products using UPCs, European Article Numbers (EANs), International Standard Book Numbers (ISBNs) or ASINs. You can enter multiple product IDs separated by a comma, space or line break. Up to 500 products can be searched at once.
Click Generate spreadsheet to generate and download a blank or pre-filled template (if you searched for product IDs). You can find it later in the Previously Generated Templates section. The pre-filled template will have the SKUs of products that you searched for with status on whether you can add an offer or not.
For the products you want to sell, follow these steps:
Add information to the columns in the template for Offer and Fulfilment. Attributes may be required, conditionally required or optional. Repeat for all products in your list.
[OPTIONAL – Pre-filled template]: If you do not want to add an offer for a particular pre-filled SKU, you can either delete that row or change the Record Action for the row to Ignored . This option is only available if you searched for product IDs.
Upload the completed file by going to Add Products and choosing Spreadsheet .
You can check the processing summary for your SKUs by clicking Check Upload Status
Price and Quantity
You can update the offer attributes of your existing offers for products in the Amazon catalog using the Price & Quantity template. No product details are required in this template. Follow these steps to update your offers:
Go to Add Products section on Seller Central; choose Spreadsheet tab; click Download a blank template option and select Update price and quantity card.
Download the template for the Store for which you want to update offer details.
Verify the offers you want to update and follow these steps:
Add information to the columns in the template for Offer and Fulfilment Availability that you want to update. Repeat for all products in your list.
Upload the completed file by going to Add Products and choose Spreadsheet tab.
You can check the processing summary for your SKUs by clicking Check Upload Status
Style guides and Browse Tree Guides
The information you provide will be uploaded to our site and will be displayed to our customers on the detail page of each product. In the Style guidelines for each category, you will find useful tips about title formats, image quality, content type and product classification. Please keep this in mind as you review these guidelines that a good detail page will drive your sales by ensuring that our customers are able to make effective buying decisions. You can use these links to download the appropriate Style guidelines for the categories in which you sell products.
Note: If your product does not have UPC/European Article Number (EAN)/Barcodes, go to How to list without UPC .
Categories
Style guides
Browse Tree Guide (BTG)
Approval required
Automotive (Parts & Accessories)
Automotive (Tyres & Wheels)|Automotive (PDF) Motorcycles & ATVs (PDF) |Automotive and Powersports BTG |View requirements |
|Baby|Baby (PDF) |Baby BTG |No|
|Beauty|Beauty (PDF) |Beauty BTG ||
|Books|Use Product Spreadsheet: ABIS_BOOK product type|Books BTG |For Books, approval is only required for listing in “Collectible” condition.|
|Camera and Photo|Go to Consumer Electronics.|Go to Consumer Electronics.|No|
|Mobile Phones & Accessories (Wireless)|Go to Consumer Electronics.|Mobile Phone & Accessories BTG |No|
|Clothing & Accessories|Clothing & Accessories (PDF) |Clothing & Accessories BTG |No|
|Collectible Coins|Collectible Coins (PDF) |There is no separate BTG available for this category.|View requirements |
|Computers|Go to Consumer Electronics.|Go to Consumer Electronics.|No|
|Consumer Electronics|Consumer Electronics (PDF)
Consumer Electronics Store Style Guide |Consumer Electronics BTG |No|
|Entertainment Collectibles|Entertainment Collectibles (PDF) |BTG available upon approval to sell in this category.|View requirements |
|Eyewear (Go to Clothing & Accessories)|Eyewear |Clothing & Accessories BTG |No|
|Fine Art – Inventory File Template available upon approval to sell in this category.|Fine Art (PDF) |BTG available upon approval to sell in this category.|View requirements |
|Gift Cards|Gift Cards (PDF) |BTG available upon approval to sell in this category.||
|Grocery and Gourmet Food|Grocery and Gourmet Food (PDF) |Grocery and Gourmet Food BTG |View requirements |
|Health & Personal Care|Health & Personal Care (PDF) |Health & Personal Care BTG |No|
|Home, Home Decor, Kitchen & Garden Furniture|Furniture Home Kitchen (PDF) |Home & Kitchen BTG
Patio, Lawn & Garden BTG
Arts, Crafts & Sewing BTG |No|
|Industrial & Scientific (Fasteners)
Industrial & Scientific (Food Service and Janitorial, Sanitation & Safety)
Industrial & Scientific (Lab & Scientific Supplies)
Industrial & Scientific (Power Transmission)
Industrial & Scientific (Raw Materials)
Industrial & Scientific (Industrial and Other)|Industrial & Scientific (PDF) |Industrial & Scientific BTG |Selling Guidelines |
|Jewellery|Jewellery (PDF) |Jewellery BTG |View requirements |
|Lighting|Lighting (PDF) |Go to Tools & Home Improvement.|No|
|Luggage|Luggage |There is no separate BTG available for this category.||
|Motorcycles & ATVs (Go to Automotive Parts & Accessories)|||View requirements |
|Music|Use Product Spreadsheet: ABIS_MUSIC product type|There is no separate BTG available for this category.|View requirements |
|Musical Instruments|Go to Consumer Electronics.|Musical Instruments BTG |No|
|Office Products|Go to Consumer Electronics.|Office Products BTG |No|
|Outdoors (Outdoor Gear, Outdoor Sports Apparel, Cycling and Action Sports)|Outdoors (PDF) |Outdoors BTG |No|
|Pet Supplies|Home, Garden & Pets (PDF) |Pet Supplies BTG |No|
|Shoes, Handbags & Sunglasses|Handbags
Shoes & Accessories (PDF) |Clothing & Accessories BTG ||
|Clothing & Accessories BTG |Software & Video Games |Software BTG
Video Games BTG |View requirements |
|Sports (Exercise & Fitness, Hunting Accessories, Team Sports, Licensed Fan Shop, Athletic Apparel, Boating & Fishing and Game Room)|Sports (PDF)
Selling Sports Apparel |Sports BTG |No|
|Sports Collectibles
Trading Cards|Sports Collectibles |BTG available upon approval to sell in this category.|View requirements |
|Tools & Home Improvement|Tools & Home Improvement (PDF)
Reconditioned Tools & Hardware |Tools & Home Improvement BTG |No|
|Toys & Games|No specific style guide|Toys & Games BTG |No|
|Video & DVD|Use Product Spreadsheet: VIDEO_DISC_PLAYER product type|There is no separate BTG available for this category.|View requirements |
|Watches|Watches (PDF) |Watches BTG ||
Troubleshooting
If you encounter a processing error after trying to upload your catalog templates, go to the following pages to identify a solution:
All mention of Book Loader has been suppressed, and it’s certainly helpful that one can yet again access the Browse Tree Guides - but the glass is only ½-full, in me own estimation, due to the fact that several of the other (in fact, most of them, dadgummit) embedded links offered up on that page are behind the internal use-only M.A.P. (“Midway Authentication Portal”) gateway:
1 - In the “Product Spreadsheet” section, we all can see that the “Add Products” embedded URL currently points here:
https://www.sellercentral.amazon.dev/product-search/bulk
the correct URL for the Add Products Dashboard, in ‘simplified’ form (& ‘broken’ for display in Discourse) is this:
https: //sellercentral.amazon.com/product-search/bulk
AND we can see that the the “Check Upload Status” link is currently this:
https://www.sellercentral.amazon.dev/product-search/status
The correct ‘simplified’ URL for that resource is apparently not the following, as might be presumed @ the first blush (again, link ‘broken,’ as are all following URLs in this post, when applicable):
https: //sellercentral.amazon.com/product-search/status
because on the seller-side of things, it simply redirects to the new (and rather execrable, IMHO) Add Products Dashboard; it appears to me that Amazon’s actual intent is to link to the “Check Upload Status” Dashboard found here:
https: //sellercentral.amazon.com/listing/status
2 - In the “Video Tutorial” section, the link to the Seller University Module “Match or create product listings and variations in bulk” is currently this:
https://www.sellercentral.amazon.dev/learn/courses?moduleId=c7bf5534-c5fb-4bc0-a6f8-549ac4b3aafc&ref_=su_home_rum&modLanguage=English&videoPlayer=airy
The correct ‘simplified’ URL for that module is this:
https: //sellercentral.amazon.com/learn/courses?moduleId=c7bf5534-c5fb-4bc0-a6f8-549ac4b3aafc
2 - In the “Listing Loader” section, once again, we can again see that the “Check Upload Status” URL points behind the M.A.P.-shielded gateway, as is true of the afore-mentioned “Product Spreadsheet” ¶ (paragraph).
3 - In the “Price and Quantity” section not only is that same mistake repeated, but we can also all see that there are two other missteps there, to wit -
a) The currently-embedded link to the “Update price and quantity” ‘card’ is this:
https://www.sellercentral.amazon.dev/product-search/bulk/generate/edit-offer
The correct ‘simplified’ URL for that resource - which is supposed to invoke the ‘slide-in’ menu-dialog box that’s part & parcel of the execrably-redesigned Add Products workflow, so that a user can advance through the steps intended to provide the latest-and-greatest Attribute-Harmonized flat-file template for this or that Catalog Category, targeted specifically to this or that of Amazon’s Global Marketplaces - is this:
https: //sellercentral.amazon.com/product-search/bulk/generate/edit-offer
b) As is true of the “Product Spreadsheet” section previously pointed out, the “Add Products” embedded URL in that section currently points to the same ‘shielded’ URL reproduced above.
4 - In the “Style guides and Browse Tree Guides” section, the first two links - to the SHC’s “List products that do not have a Product ID (UPC, EAN, JAN or ISBN)” @ https: //sellercentral.amazon.com/help/hub/reference/200426310 in the Note, and to “Categories and products that require approval” @ https: //sellercentral.amazon.com/help/hub/reference/200333160 embedded in the restored Table’s last Column Header, “Approval required,” are both correct (& even presented in best-practice ‘simplified’ form - no need to strip a superfluous “G” prefix from the SHC ID #); all of the links (save four of them ) in the “Style Guides” & “Browse Tree Guides (BTG)” columns are also correctly accessible from the seller-side of things.
Those 4 exceptions can begin to be found in the second link in the Consumer Electronics row, “Consumer Electronics Store Style Guide,” which is currently supplied w/ a M.A.P.-shielded link to the newest iteration of Amazon’s “Rainier” database (more on this to come in the concluding ¶ of this post):
A) https: //rainier-m1k.integ.amazon.com/gp/help/200288470
The correct URL to the SHC’s “The Consumer Electronics Store Style Guide” page is here:
https: //sellercentral.amazon.com/help/hub/reference/200288470
B) The second exception is notable in the Style Guides column, in the badly-bollixed “Clothing & Accessories BTG” row, which has been inexplicably mixed up with Software & Video Games - the embedded link of which label points here:
https://rainier-m1k.integ.amazon.com/help/hub/reference/G200390640
instead of to the apparently intended SHC page, “Product detail page rules” @ https://sellercentral.amazon.com/help/hub/reference/200390640
C) The third exception also occurs in that same row, & is documented in item ‘5 - i)’ below.
D) The fourth exception repeats the same mistake as the third, in the second of the Style Guides offered up in the “Tools & Home Improvement” row - “Reconditioned Tools & Hardware” currently points here:
https://rainier-m1k.integ.amazon.com/help/hub/reference/G200390640
rather than where it, too, should lead: to the SHC’s “Product detail page rules” @ https://sellercentral.amazon.com/help/hub/reference/200390640
5 - As if this litany of errors weren’t already long enough, we can also find that EVERY SINGLE LINK in the aforementioned “Approval required” column is also inaccessible; when Amazon restored the table to the SHC page in question, it kept the same labels for each cell that have been there (prior to last year’s temporary disappearance) for the past ten years and more, so all but one of them display as “View requirements”:
a) In the “Automotive (Parts & Accessories)/Automotive (Tyres & Wheels)” row - n.b. the bleedover from alternate contributory attribute sources w/ the cross-pond spelling of “tires” - “View requirements” points here:
https://rainier-m1k.integ.amazon.com/help/hub/reference/G200584550
The intended SHC page is “Selling in Automotive & Powersports” @ https: //sellercentral.amazon.com/help/hub/reference/200584550
b) In the “Collectible Coins” row, “View requirements” points here:
https://rainier-m1k.integ.amazon.com/gp/help/201526800
The intended SHC page is “Collectible Coins” @ https: //sellercentral.amazon.com/help/hub/reference/201526800
c) In the “Entertainment Collectibles” row, “View requirements” points here:
https://rainier-m1k.integ.amazon.com/gp/help/200944120
The intended SHC page is “Entertainment Collectibles” @ https: //sellercentral.amazon.com/help/hub/reference/200944120
d) In the “Fine Art – Inventory File Template available upon approval to sell in this category.” row, “View requirements” points here:
https://rainier-m1k.integ.amazon.com/gp/help/201257400
The intended SHC page is “Fine Art” @ https: //sellercentral.amazon.com/help/hub/reference/201257400
e) In the “Grocery and Gourmet Food” row, “View requirements” points here:
https://rainier-m1k.integ.amazon.com/gp/help/201511970
The intended SHC page is “Grocery & gourmet foods” @ https: //sellercentral.amazon.com/help/hub/reference/201511970
f) In the “BISS”* section, we find the only label that varies from “View requirements,” the embedded link for “Selling Guidelines” points here:
https://rainier-m1k.integ.amazon.com/gp/help/201847780
The intended SHC page is “Selling Industrial & Scientific Products” @ https: //sellercentral.amazon.com/help/hub/reference/201847780
g) In the “Jewellery” row - again, n.b. abnormality in that misspelling - “View requirements” points here:
https://rainier-m1k.integ.amazon.com/gp/help/200332590
The intended SHC page is “Jewelry” @ https: //sellercentral.amazon.com/help/hub/reference/200332590
h) In the “Motorcycles & ATVs (Go to Automotive Parts & Accessories)” row, “View requirements” points here:
https://rainier-m1k.integ.amazon.com/help/hub/reference/G200584550
As was the case with the aforementioned Automotive row, the intended SHC page is “Selling in Automotive & Powersports” @ https: //sellercentral.amazon.com/help/hub/reference/200584550
h) In the “Music” row, “View requirements” points here:
https://rainier-m1k.integ.amazon.com/help/hub/reference/202188990
The intended SHC page is “Music & DVD” @ https: //sellercentral.amazon.com/help/hub/reference/202188990
i) In the badly -bollixed “Clothing & Accessories BTG” row - already subject to obvious disassociation error(s), as noted above - “View requirements” points here:
https://rainier-m1k.integ.amazon.com/help/hub/reference/GP9BGQD68HQ5V4YF
The intended SHC page is “Condition guidelines: Software & Computer Games” @ https://sellercentral.amazon.com/help/hub/reference/P9BGQD68HQ5V4YF
j) In the “Sports Collectibles”/“Trading Cards” row, “View requirements” points here:
https://rainier-m1k.integ.amazon.com/gp/help/200800780
The intended SHC page is “Sports Collectibles” @ https: //sellercentral.amazon.com/help/hub/reference/200800780
k) In the “Video & DVD” row, “View requirements” points here:
https://rainier-m1k.integ.amazon.com/help/hub/reference/202188990
Which is supposed to be the same SHC page supplied in the “Music” row, “Music & DVD” @ https: //sellercentral.amazon.com/help/hub/reference/202188990
6 - All 4 of the links in the “Troubleshooting” section @ the bottom of the page are also shielded:
a) “Review a Processing Report” points here:
https://rainier-m1k.integ.amazon.com/gp/help/G200194300
rather than to the SHC’ “Review a Processing Report” @ https: //sellercentral.amazon.com/help/hub/reference/200194300
b) “Review my inventory results” currently points here:
https://rainier-m1k.integ.amazon.com/gp/help/G611
rather than to the SHC’s “Review My Inventory Results” @ https: //sellercentral.amazon.com/help/hub/reference/611
c) “Inventory file upload FAQ” is pointing here:
https://rainier-m1k.integ.amazon.com/gp/help/G201201070
instead of to “Inventory file upload FAQ” @ https://sellercentral.amazon.com/help/hub/reference/201201070
d) “Error code explanations” now points here:
https://rainier-m1k.integ.amazon.com/gp/help/G17781
but it should lead to "Error code explanations: @ https://sellercentral.amazon.com/help/hub/reference/17781
The “Rainier” database has been around for a long time - Project Rainier was originally launched more than 20 years ago, in Q3 of 2005, and it’s always had the intent of reducing support infrastructure costs via replacing humans with Amabots - but it this sorry offering is an example of the project making progress, I’ll eat my hat.
*
“BISS” is an ‘Amazonese’ acronym for “Business, Industrial, and Scientific Supplies”