Amazon Inventory Upload

Amazon Template in Excel for Shoes & Handbags

Similar to Car & Motorbike Category, Shoes & Handbags Category products are too manufactured in an uncountable variety. Moreover, shoes, handbags, wallets, accessories, etc are no more limited to a specific gender. They are equally produced, uploaded, sold & delivered across the globe.

Read some interesting facts about the shoes & handbags below.

  • Sneakers got its name due to rubber sole which didn’t make noise.
  • Men were the first to wear heels.
  • Average women in the US own 19 pairs of shoes.
  • The most expensive shoes ever sold were $660,000.
  • The first handbag with a zipper was introduced in 1923
  • According to a 2007 survey man chooses a handbag based on its brand.
  • The Mouawad 1001 Nights Diamond Purse is the most expensive handbag worth $3.8M.
  • An average woman owns 6 handbags at a time.

The benefit of listing & selling Shoes & Handbags Category product is that it has a very substantial buyer group and overtime this category has seen a steady increase in the number of target users too. Let’s see what you can sell in the Shoes & Handbags Category.

List of Products in the Shoes & Handbags Category

  1. Handbags, Purses & Clutches
    (Baguettes, Bowling Bags, Clutches, Handbags, Hobos & Shoulder Bags, Messenger Bags, Potlis & Wristlets, Satchels, Sling & Cross-Body Bags, Totes, Women’s Backpacks, Women’s Wallets & Other Handbags, Purses & Clutches)
  2. Shoe Care & Accessories
    (Boot Jacks, Boot Trees, Colours & Dyes, Insoles, Comfort, Orthotic, Sport, Other Insoles, Overshoes, Shoe & Boot Toe Guards, Shoe Brushes, Shoe Care Kits, Shoe Decoration Charms, Shoe Fitting Devices, Shoe Horns, Shoe Laces, Shoe Treatments & Polishes, Shoe Trees, Other Shoe Care & Accessories)
  3. Shoes
    Baby Shoes, Booties, First Walking Shoes, Boys’ Shoes, Boat Shoes, Boots, Clogs, Espadrille Flats, Loafers & Moccasins, Sneakers, Dress & Formal Shoes, Ethnic Footwear, Flip-Flops & Slippers, Sandals & Floaters, Floaters & Outdoor Sandals, Thong Sandals, School Shoes, Sports & Outdoor Shoes, American Football Shoes, American Handball Shoes, Badminton Shoes, Baseball Shoes, Basketball Shoes, Boating Shoes, Bowling Shoes, Boxing Shoes, Cheerleading Shoes, Climbing Shoes, Cricket Shoes, Cycling Shoes, Equestrian Sports Boots, Fishing Shoes, Football Shoes, Futsal Shoes, Golf Shoes, Gymnastics Shoes, Hockey Shoes, Hunting Boots, Indoor Court Shoes, Lacrosse Shoes, Martial Arts Shoes, Racquetball Shoes, Rugby Boots, Running Shoes, Skateboarding Shoes, Soft Tennis Shoes, Softball Shoes, Squash Shoes, Table Tennis Shoes, Team Handball Shoes, Tennis Shoes, Track & Field Shoes, Training Shoes, Trekking & Hiking Footwear, Triathlon Shoes, Volleyball Shoes, Walking Shoes, Water Shoes, Wrestling Shoes, Girls’ Shoes, Ballet Flats, Boots, Casual Shoes, Ethnic Footwear, Fashion Sandals, Fashion Slippers, Flip-Flops & Slippers, Floaters & Outdoor Sandals, Formal Shoes, Mary Jane, Pumps, School Shoes, Sports & Outdoor Shoes, Men’s Shoes, Dress & Formal Shoes, Ethnic Footwear, Flip-Flops & Slippers, Safety Shoes, Sandals & Floaters, Sports & Outdoor Shoes, Thong Sandals, Women’s Shoes, Fashion Sandals, Fashion Slippers, Flip-Flops & Slippers, Floaters & Outdoor Sandals, Formal Shoes, Mary Jane, Pumps, Sports & Outdoor Shoes
  4. Other (Shoes & Handbags)

How to Download Amazon Inventory File for Shoes & Handbags Category?

  • Log in to your Amazon India seller account.
  • Click on Add Products via Upload under the Inventory tab.

  • Scroll down to the Product Classifier option
  • Find Car & Motorbike category. For reference, we have taken “Handbags” as an example.
  • Choose the product sub-category. Click the “Select” button
  • Select the template mode as “Advanced”.
  • Click “Generate Template”. A product inventory excel file will be downloaded.
  • Check your download folder to locate the file.

How to Fill Excel Inventory File for Shoes & Handbags Category?

In the downloaded “Handbags” excel file for Shoes & Handbags Category, there are 7 worksheets out of which only the “Template” sheet is to be filled. Rest of the sheets are only for reference purpose.

There are total 10 sections in the Handbags Excel Template. These sections remain the same (with a minor change in the sequence of field columns) for any Shoes & Handbags product excel sheet that you download.

  1. Required product information
  2. Images
  3. Variation
  4. Basic product details
  5. Discovery
  6. Product enrichment
  7. Dimensions
  8. Fulfillment
  9. Compliance (Not relevant)
  10. Offer

A detailed explanation of the necessary attributes and fields relevant to the product is given below. You can leave fields blank if they are irrelevant to your product.

1. Required product information

Product sub-type: Describe the type of product. For example, Handbags, Floaters, etc.
Seller SKU: The inventory identification number given to the product.
Brand name: The brand name of the product.
Product ID: Write the 12, 14 or 16 digit numerical value of the product ID.
Product ID type: Select UPC, EAN, GCID, ASIN etc. from the drop-down list.
Manufacturer part number: This is a kind of product model number. Refer the product packing.

Product name: Write the name of the product including its brand, size, materials, etc.
Outer material type: The outer material of the product. For example, Plastic, Wood, Steel, Leather, etc.
Colour & colour map
: List all the standard colour names here which may be the closest of your product colour. For example, if your product is violet in colour then in the map column write purple.
Material type: The material out of which the product is made.
Style name
: Give the common industry name of the product that your buyers are familiar with.

Department: The shoe or handbag department where the product can be found. Example, men’s, women’s, etc.
Standard price: Specify the product price. This is not the MRP.
Quantity: Give the product quantity you want to sell.
Maximum retail price: Write the MRP of your product. This is not the selling price.
Main image URL: Insert the URL of the main product image here.

2. Images

Other than the main image URL space, a seller can insert additional images to attract buyers into their inventory product listings. In this excel file, you will get only 1 column space to add other product images. Whereas Amazon India gives you 12 image space in the product back end page when you click edit on the manage your inventory page.

How to Add Other Image URL?

Upload all product images on Google Drive, Dropbox or any other similar cloud platform. Create shareable links for these images. Right click on the image & click Get Shareable Link option from the drop-down list. Copy the link & paste it here.

3. Variation

Parentage: Values here will be either parent or child. To understand variation better, refer to the “example” tab in the excel worksheet.
Parent SKU: Provide the SKU of the main product if you are listing an accessory or variant of the main product.
Relationship type: Describe whether the product that is being listed is an accessory or a close variant of the main product. If you are listing the main product then leave this entire section blank.
Variation theme: Define the variation theme of product here. For example, size, colour, material etc.

When to Add Variation of a Product?

Variation section is to be filled only if you are listing an accessory or a close variant of the main product. Remember that if you are adding main product then leave this section empty. For example, a handbag is your main product but a stylish handbag leather handle in red, black or brown colour is an additional accessory to it.

4. Basic Product Details

Update delete: You get 3 options in the drop-down list. Delete, Partial Update or Update. If you are listing or updating a new product then select Update or Partial Update. If you want to delete a product completely then select Delete.
Model number: Describe the model number of the shoe or handbag. Refer the packing.
Manufacturer: Write the name of the manufacturer.
Product description: Describe your product here. Write vital info about the product.
Recommended browse nodes: Check the valid values tab in your excel sheet for 10 digit browse node.
Inner material type
: The material of the product used on the inner side.
Closure type: Indicate the method used to close the bag or shoe. For example, zip, staps, stick, etc.

5. Discovery

Bullet points: Write 5 key features in the bullet point columns of your product.
Search terms: A set of specific words that a potential buyer will type & search for your products. You get total 5 columns to write the search terms.
Style keywords: Insert keywords that are specific to the style of the product.
Platinum Keywords: These are keywords inserted by platinum sellers.
Catalogue number: An alphanumeric value for an entire catalogue of shoe or handbag.

How to Write Bullet Points & Insert Search Terms (Keywords) to Attract Buyers on Amazon India?

Search terms are keywords that a buyer will type in the Amazon.in – search bar to find their product. Refer the image below.

Open Amazon.in link and type “handbag”. You will see suggestions these are potential search terms that buyers type to find a handbag. Note down these suggestions and repeat the above step using these suggestions to find more variables of suggestions. In the end, you will see that you have a list of search terms that an actual buyer is searching in real time to find a handbag.

Now, use these search terms in your bullet points, product description & product titles to create a relevancy. When a buyer searches for a product that is relevant to the search terms which are inserted throughout the product detail page your Amazon product listing gets a hit & is ranked organically in the search results.

Hence, this way you can SEO optimize your Amazon India Product Listings without any cost. Also, note that you do not overuse, repeat or spam search terms because that will decrease your product ranking & overall seller ratings on Amazon India.

6. Product enrichment

Strap type: The type of strap used in the product.
Size & size map
: Specify the size of your product.
Material composition: The material of the product from which it is made.
Occasion lifestyle: Indicate whether the product can be used for specific occasion, place, day, etc.
Season: Describe whether the product can be used in a specific season or it’s an all season product.

Warranty type: Select Manufacturer, Seller, Manufacturer & Seller or No Warranty from the list.
Occasion description: Select Business, Casual, Evening, Ethnic & Traditional or Special Needs from the list.
Warranty description: A text-based short product description including search terms.
Product care instructions: Instruct buyers how to use the product.

7. Dimensions

Shipping weight: The final weight of the product after packing.
Website shipping weight unit of measure: Select GR, KG, OZ or LB from the drop-down list.
Item length, height & width: Specify the length, height & width of the product.
Item dimensions unit of measure: Give the display dimensions measuring unit of the product.

8. Fulfillment

Package height, width & length: Indicate the height, width & length of the final package.
Package dimensions unit of measure: Write the package dimension unit of measure in CM, FT, IN, M, MM.

Package weight: The package weight including the packaging.
Package weight unit of measure: Specify the package weight unit in LB, OZ, KG, Milligrams, GR, etc.
Fulfillment centre ID:  Select AMAZON_IN or DEFAULT for fulfillment centre ID.

9. Compliance

Compliance section includes battery info. For Shoes & Handbags Category we will skip this section as it is irrelevant. There are certain attributes like country, the region of origin, HSN code, legal disclaimer, etc. which can be filled if a seller wishes to or else leave it completely empty.

10. Offer

Max order quantity: Indicate the largest quantity that a buyer may purchase in a single order.
Condition: Write values like New, Club, Collectible, Refurbished, Used, etc.
Condition note: If item condition is not “New” then describe the condition here in brief.
Product tax code: Specify the product tax code available of sales.
Launch & restock date: Write the launch & restock date of the product if any.

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.
Item package quantity: The number of packages in a single order.
Number of items: The number of product/items in a single package.
Can be gift message: If you can print a gift message then select True or else False.

Is gift wrap available?: If the product is available in gift wrap then select True or else False.
Is discontinued by manufacturer: Select true or false from the drop-down list.
Handling time: Time needed to pick, pack & ship the product.
Max aggregate ship quantity: Number of items in a single shipment.

List price: Manufacturer’s suggested list price for the product.
Stop selling date: The date after which your product will be unavailable for selling.
Shipping Template: Write Migrated Template here.
Offering release date: The date when the product is available for buyers to order.

Click the link below to create your own promotion to generate more sales:

Creating Amazon India Promotions To Generate More Sales

How to Upload Your Inventory File?

The excel worksheet that you have prepared for the Shoes & Handbag Category will have some errors which need to be rectified before final upload. Moreover, Amazon India itself doesn’t allow sellers to add stock using an excel file that has errors. so, let us check the file first.

Steps to Check Your Inventory File:

  • Keep your excel inventory file ready.
  • Select Inventory Files in File Type.
  • Click Choose File in File to Check section.
  • The email alert is optional, you can skip it.
  • Click Check my File & refresh the page.
  • Go to Monitor Upload Status to see the file validation process.

If there are any errors in the bulk upload file than correct them and repeat the above steps till your file is error-free. The next step is to upload the Amazon India validated excel worksheet for a final add-on to the inventory.

Steps to Upload Your Inventory File:

  • Keep File Type Inventory Files.
  • Click Choose File in File Upload option.
  • The email alert is optional, you can skip it.
  • Select Excel radio button in Processing Report Format.
  • Click Upload & refresh the page.
  • Go to Monitor Upload Status to see the product upload process.

We can conclude that using a single excel stock template a seller can add a variety of shoes and handbag products along with variation and related accessories.

Amazon India sellers can browse easy to use bulk upload excel template in other important Amazon India Product Listing Categories like Clothing & Accessories, Computer & Accessories, Mobile & Accessories, Kitchen & Home Appliances, Beauty, Grocery & Gourmet Foods, Sports, Fitness & Outdoors, Jewellery, Health & Personal Care, Office Products, Toys & Games, Video Games, Books and Car & Motorbike to list & sell relevant category products.

If you aren’t able to find your product in the “Product Classifier” section, then use an Amazon Product Flat File to bulk upload your inventory stock.

Additionally, you can also download free and ready-to-use Business Excel Templates in different categories like accounting, HR, Payroll etc that will be helpful for the smooth running of your business.

Happy Selling on Amazon India.

We thank our readers for liking, sharing and following us on different social media platforms.

If you have any queries or suggestions please share in the comment section below. I will be more than happy to assist you.

Shabbir Bhimani

I have worked in Excel and like to share functional excel templates at ExcelDataPro.

Share
Published by
Shabbir Bhimani

Recent Posts

Download UK VAT Taxable Turnover Calculator Excel Template

To simplify the process, we have created a simple and easy UK VAT Taxable Turnover…

4 years ago

Step By Step Guide TO UK VAT Registration Process

Every business has to register for VAT with HM Revenue and Customs if their VAT…

4 years ago

Download UK VAT Dual Currency Invoice Excel Template

We have created the UK VAT Dual Currency Invoice excel template with predefined formulas that…

4 years ago

Download UK VAT Purchase Register Excel Template

We have created a simple and easy UK VAT Purchase Register Excel Template with predefined…

4 years ago

Download UK VAT Sales Register Excel Template

We have created a simple and easy UK VAT Sales Register Excel Template with predefined…

4 years ago

Download UK VAT Progress Billing Invoice Excel Template

We have created a ready to use UK VAT Progress Billing Invoice template in excel…

4 years ago