Amazon Template in Excel For Sports, Fitness & Outdoors
The Sports, Fitness & Outdoors Category is the most trending category after Grocery & Gourmet Foods wherein sellers can add a wide variety of sports and fitness products to their existing Amazon India inventory. All this can be done using a single excel inventory file.
Below we have integrated a list of subcategories and products that come under the Sports, Fitness & Outdoors Category. Check whether your product is present in the list below or not.
List of Subcategories & Products For Sports, Fitness & Outdoors Category:
Accessories
(Sports Sunglasses, Water Bottle, Shakers & Accessories)
Sports Clothing
(Activewear, Jerseys, Pants & Socks for Boys, Girls, Men & Women for Sports like American Football, American Handball, Badminton, Baseball, Basketball, Boating, etc.)
Click on Add Products via Upload under the Inventory tab.
Scroll down on the page to locate Product Classifier option. Refer above image.
Find Sports, Fitness & Outdoors category. We have taken Skydiving as an example.
A seller needs to toggle subcategories & product list till he/she finds the final product. Click the Select button.
Select the template mode as Advanced.
Click Generate Template. A product inventory excel file will be downloaded.
Check the download folder. An excel file will be downloaded with the same product name.
The whole concept of the excel inventory file is to add products in bulk quantity. If you want to experience product upload one by one then you can always to do so by using Add a Product under Inventory tab. Refer: How to Add A New Product on Amazon India – Step By Step Guide
How to fill Sports, Fitness & Outdoors Category Inventory File?
In the excel inventory file, only the Template sheet is to be filled and other excel sheets are for reference purpose. We have taken Skydiving excel file in Sports, Fitness & Outdoors Category as an example to understand the attributes and field values.
There are total 10 sections in the Skydiving Excel Template. These sections will mostly remain the same for any product excel sheet that is downloaded with a minor change in the sequence of field columns depending on the product type.
Required product information
Images
Variation
Basic product details
Discovery
Product enrichment
Dimensions
Fulfillment
Compliance
Offer
Let us understand the column attributes and required field values necessary to fill in the details.
1. Required Product Information
Product type: The product type. For example, skydiving gear. Seller SKU: A unique product identification number given by a merchant to distinguish products. Brand name: The brand name of the product. Product ID: An numerical value of 12 or 16 digits. Product ID type: Select option from the drop-down list. GCID, UPC, EAN, etc. Item name: The product title including brand, color, size, material, weight etc.
Manufacturer: Name of the manufacturer of the product
Standard price: The selling price of the product. Quantity: The quantity of the product offered for sale. Shipping-template: Select the default template provided by Amazon or enter your own. Maximum retail price: Provide the MRP of your product. Main image URL: Paste the main product image URL here.
2. Images
Swatch image URL: Image format of the color chart. Enter URLs of color swatch here. Other image URL: Give other product image URLs.
Useful tip: Upload all product images on Google Drive, Dropbox or any other similar cloud platform and copy their links to paste it here. Keep image background white. The image pixels must be minimum 500 x 500 or more for better visibility when zoomed. Use HD product images.
3. Variation
Variation section in Sports, Fitness & Outdoors Category file is used only when you intend to add a product variation or an accessory of the main product. Leave this blank if you are listing main product. To understand variation better, refer to the “example” tab in the excel worksheet.
Parentage: Values will be either parent or child. Parent SKU: Provide the SKU of the main product. Relationship type: Describe whether the product is an accessory or a close variant of the main product. Variation theme: Define the variation theme of product here. it can size, color, material etc.
4. Basic Product Details
Update delete: Use “Update” or “Partial Update” if you want to update an existing product. Use “Delete” if you want to completely remove the listing. Product description: A short product description to describe your product. Manufacturer part number: Refer product packaging for the part number. Recommended browse nodes: See valid values tab for browse nodes. Outer material type: The outer material of the product.
5. Discovery
Department: Men, women or children specify for whom the product is made. Style: The industry name of the style.
Target audience: Define your product target audience. You get total 5 column space.
Thesaurus attributes keyword: Select from the list of valid value tab.
Search terms: Specify words that describe your products. You get total 5 column space.
Key product features: Indicate the most important features of your product in short sentences or phrase. You get total 5 column space.
6. Product enrichment
Model name: The model name of the product. Sport: Name of the sport in which the product is used. Item type name: Indicate the item type. Colour & color map: The standard color name of the product. Size: The size of the product.
Size map: The size map of the product. Material type: The type of material from which the product is made. Material composition: Name the composition of the material used n the product. Season: Season when the sport is played. Item shape: The shape of the item. Hand: Describe the hand orientation of the product.
As we have taken the example of skydiving the above-mentioned fields will be irrelevant for skydiving product and hence one can skip this section. Sellers planning to sell mountain bikes or golf sports product then only fill in the details.
Shaft material: For golf-related products. Tension level: The amount of force the product can withstand. Head size name: For golf-related products. Display maximum weight recommendation unit of measure: Select LB, OZ, KG or GR from the list.
The above attributes are for golf products under the Sports, Fitness & Outdoors Category. Sellers not dealing in golf products or items that don’t include shaft can skip this section.
Shipping options: Specify the shipping channel of the product. Model year: Year in which the product was made. Lens color: Fill the lens color name if the product has one or leave empty. What’s in the box: Describe the components in the package.
7. Dimensions
Shipping weight: The final weight of the product after packing. Website shipping weight unit of measure: Select GR, KG, OZ or LB here. Display width: The width of the product. Display width unit of measure: The measuring units of product width. For example, FT, IN, CM, MM, etc.
Display length: The length of the product. Item display length unit of measure: Indicate the measuring units of product length. For example, FT, IN, CM, MM, etc. Peak height: Maximum height of the product. Item display height unit of measure: The measuring units of product height. For example, FT, IN, CM, MM, etc.
Display weight: The weight of the product. Item display weight unit of measure: The measuring units of product weight. Boat fender diameter: For water sports product only. Item display diameter unit of measure: For water sports product only.
Display volume: The volume of the product. Item display volume unit of measure: The measuring units of product volume. Line capacity: Applicable for fishing products only. Item height: The height of the product. Item height unit of measure: The measuring unit of product height.
The above section is to describe the item length, width & weight of the product along with the measuring units respectively. For field value, you can refer the valid values tab.
Coverage area: The total area covered by the product Item area unit of measure: The measuring unit of the product area. Display dimensions unit of measure: The measuring unit of the display dimensions. Volume capacity name unit of measure: The measuring unit of the product volume capacity. Item dimensions unit of measure: The measuring unit of the product dimensions (LxBxH).
8. Fulfillment
Fulfillment basically refers to Fulfilled by Amazon (FBA) where Amazon delivers an order to the buyer on behalf of sellers. A seller can also use Amazon India easy ship services or an Alternative to Amazon India Easy Ship Program called Self Ship (Fulfilled by Merchant).
Fulfillment center ID: Select AMAZON_IN or DEFAULT for fulfillment center ID. Package weight: The package weight when ready to ship (including packaging). Package weight unit of measure: Specify the package weight unit in LB, OZ, KG, Milligrams, GR, etc.
Package height, length & width: Specify the package height, width & length at the fulfillment center. Package dimensions unit of measure: Write the package dimension unit of measure in CM, FT, IN, M, MM.
9. Compliance
Country/Region of origin: The country or region of origin of the product. Legal disclaimer description: A short description of any legal law pertaining to the product. Safety warning: Write safety warning for buyers while using the products. Fabric type: Applicable if you are selling sportswear items.
In compliance, section sellers need to provide battery details if their products run on batteries even under Sports, Fitness & Outdoors Category. If not then leave it blank.
10. Offer
Item condition: Write the item condition. Example New, Refurbished, Used, etc. Offer condition note: If item condition is not “New” then describe the condition here in brief. Launch, release & restock date: Specify the product launch, release & restock date. You can leave these field empty. Handling time: Time needed to pick, pack & ship the product.
Product tax code: Write amazon’s standard code to identify the product tax. Sale price: The price at which a seller offers a product on SALE. Sale start & end date: The date when you want to start & end a sale. Max order quantity: Specify the largest quantity that a buyer can order. Package quantity: The number of products packed in a single order.
Can be gift messaged: Select Yes or No. Is gift wrap available?: Select Yes or No. Is discontinued by manufacturer: Fill in the details only if your product is discontinued by the manufacturer. Number of items: The number of items in the products.
Max aggregate ship quantity: Number of items in a single shipment. Stop selling date: Specify the date when you want to stop selling the product. Offering release date: A specific date to fulfill a pre-orderable product.
How to Upload Inventory File?
Use the check file option to perform a file validation process by Amazon India before final upload. The check file option will find errors so that they can be corrected before you add the products to inventory. Chose the excel file & click check my file.
Once the excel inventory file is error free, choose the file and click upload. Now all your products will start adding to the inventory.
A seller can upload any product mentioned in the product classifier using a single excel inventory upload file.
You can download free and ready-to-use business templates in different categories helpful for the smooth running of your business.
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy
Privacy Overview
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
Leave a Reply