Amazon Inventory Upload

Amazon Template in Excel for Musical Instruments

The Musical Instruments Category on Amazon.in has mainly 12 important sub-categories where a seller can list & sell products that are either musical instruments or related accessories. Apart from the main product, there are many small & medium size vital accessory that is to be packed & shipped with the main item.

Hence, the scope of getting good Amazon sales increases. One can really think about setting up an Amazon Online Store to sell innovative musical instruments. But, before that let us see what type of items can be sold under the Musical Instruments Category.

List of Products in the Musical Instruments Category

  1. Bass Guitars & Gear
    (Accessories, Amplifiers, Bass Effects, Electric Bass Guitars, Electro-Acoustic Bass Guitars, Kits & Upright)
  2. DJ & VJ Equipment
    (Bags, Cases & Racks, Cartridges & Needles, CD Players, DJ Controllers, DJ Digital Media Players, DJ Effects, DJ Headphones, DJ Mixer, DJ Sets, Drive Belts, Slipmats, Tape Decks, Turntables & VJ Equipment)
  3. Drums & Percussion
    (Accessories, Concert & Mallet Percussion, Cymbals, Drum Sets, Drums, Electronic Drums, Gongs, Hand Drums, Hand Percussion, Hardware & Practice Pads)
  4. Guitars & Gear
    (Accessories, Acoustic Guitars, Classical Guitars, Electric Guitar Kits, Electric Guitars, Electro-Acoustic Guitars, Guitar Amplifiers & Guitar Effects)
  5. Karaoke Equipment
    (Bags & Cases, Players, Stands & Hardware, Systems & Video Monitors)
  6. Microphones
    (Accessories, Bags & Cases, Clips & Mounts, Phantom Power Supplies, Preamps, Stands, Windscreens & Pop Filters, Condenser, Dynamic, Ribbon Microphones & Wireless)
  7. PA & Stage
    (DI Units, Effects & Signal Processors, In-Ear-Monitoring, Lighting, Microphones, Mixers, PA Systems, Power-Amplifiers, Speakers & Trussing)
  8. Piano & Keyboard
    (Accessories, Accordions, Digital Pianos, Electronic Keyboards, Grand Pianos, Harmoniums, Harpsichords, MIDI Keyboards & Equipments, Organs & Upright Pianos)
  9. Recording & Computer
    (Acoustic Room Treatment, Audio Interfaces, Digital Audio Workstation Sets, Digital Converters, Effects & Signal Processors, In-Ear-Monitoring, Microphones, MIDI Controller, MIDI Interfaces, Mixing Desks, Multitrack Recorders, Portable Recording Devices, Power Conditioners, Preamps, Studio Accessories, Studio Monitors, Studio Subwoofers)
  10. String Instruments
    (Accessories, Autoharps, Banhu, Banjos, Bouzoukis, Cellos, Ching Hu, Classical Guitars, Dihu(Bass Hu), Dilruba & Esraj, Double Bass, Dulcimers, Erh Hu, Gaohu, Guqin, Guzhengs, Harps, Jing Erhu, Kits, Koto, Lap & Pedal Steel Guitars, Lutes, Mandolins, Matouqin(Morin Khuurs), Ouds, Pipa(Chinese Lute), Psalteries, Qinqin, Rabab, Ruans(Moon Guitars), Santoors, Sanxian, Saranda, Sarangi, Sarods, Shamisen, Sihu, Sitars, Strum Sticks, Surbahar, Swarmandal, Tamburas, Taus, Ukulele, Veenas, Violas, Violins, Yueqin, Zhonghu, Zhuiqin & Zithers)
  11. Synthesizer & Sampler
    (Accessories, Production Stations, Sampler, Sequencer & Rhythm Machines, Sound Data, Sound Modules & Synthesizer)
  12. Wind Instruments
    (Accessories, Brass, Conch Shells, Didgeridoos, Harmonica, Jew’s Harps, Kazoos, Kits, Melodicas, Neys, Ojas, Shawms, Shenais, Shofars, Shruti Boxes, Suonas, Whistles, Woodwind & Zurnas)

How to Download Amazon Inventory File for Musical Instruments 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 Musical Instruments Category. We have taken “Harmoniums” 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 Musical Instruments Category?

The downloaded excel file for the Indian Classical Musical Instrument “Harmoniums” has 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 Harmonium Excel Template. These sections remain the same (with a minor change in the sequence of field columns) for any Musical Instruments Category 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
  10. Offer

A detailed explanation of the necessary attributes and fields relevant to the product is given below. Leave irrelevant fields blank.

1. Required product information

Product type: Describe the type of product. For example, Starters, Tyre rims, etc.
Seller SKU: The inventory identification number given to the product.
Brand name: The brand name of the product.
Item name: The name of the product aka a short product title.
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: The name of the product manufacturer.
Model number: This is a kind of product model number. Refer the product packing.
Recommended browse nodes: For browse, nodes refer to the “Valid Values” tab in the excel sheet.
Item type name: Describe the name of the item type here.
Manufacturer warranty description: Provide the warranty description terms & conditions in brief.

Standard price: The selling price of the product.
Quantity: Enter the quantity of the product.
Maximum retail price: Provide the MRP of your product.
Main image URL: Insert the main product image URL.

2. Images

Seller gets total 8 column space to insert high-quality image URLs of their product in this excel worksheet. Keep in mind that this space is to insert URLs of images and not any kind of text.

How to insert image URL in the excel sheet?

Make a separate folder that contains all your product images. Upload this folder on Google Drive or Dropbox or any similar cloud platform that allows storage facility. Now right click on the folder & click “Get shareable link” option to make the entire folder shareable.

Sharing the entire folder will create shareable links for individual images too. Once you are done with creating shareable links just copy & paste those links here in the excel sheet. One in each column space. You need to select 8 best images of your product that you want to upload.

3. Variation

Parent SKU: Provide the SKU of the main product.
Parentage: Describe whether the product is a parent or child.
Relationship type: The relationship of the main product with the product you are adding using this file.
Variation theme: Define the product variation theme. For example, size, colour, material, etc.

What is Parent & Child in the Variation Section?

Firstly, the Variation section is to be filled only if you are uploading the main product. Now there are many products which come with related accessories. So, the main product becomes the Parent & the related accessory will be treated as a Child here in this excel sheet.

For example, Harmonium is the main product & will be treated like a Parent. Now if you want to sell Harmonium strings, keys, covers or any related accessory then these products will be treated as Child.

4. Basic Product Details

Update delete: Enter Update or Partial Update if updating current product details or adding a totally new product. Use “Delete” if you want to completely remove a product listing.
Product description: Describe the product in brief. Write the main features only.
Manufacturer part number: Refer product packing for part number given by the manufacturer.

5. Discovery

Key product features: Indicate the most important features of the product in short sentences or phrases.
Search terms
: Write searchable keywords that user often uses to find your product. You Get total 5 space.
Platinum Keywords: This section is to insert keywords, but only for platinum Amazon sellers.

Target audience keywords: Specify your product target audience using favourable keywords.
Thesaurus attribute keywords: Describe other attributes of your product.
Catalogue number
: An Alphanumerical catalogue ID for the entire collection.

6. Product enrichment

Model name: The model name of the instrument.
Number of keys: The total number of keys in the instrument.
Colour & colour map
: The colour of the instrument & other available colour variety.
Size & size map: Specify the size of the instrument.

7. Dimensions

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

Item display weight unit of measure: The measuring unit of weight of the instrument.
Display volume: The volume capacity of the instrument.
Item display volume unit of measure: The measuring unit of display volume of the instrument.
Display length: The displayed length of the instrument.

Item display length unit of measure: The measuring unit of display length of the instrument.
Item diameter string: The diameter of the circular percussion instrument (drum, cymbal, etc.).
Item diameter unit of measure: Select from the list of feet, inches, meters, centimetres, or millimetres.
Item dimensions unit of measure: The measuring unit of dimensions of the instrument.

8. Fulfillment

Fill details in this section only if you are a registered Amazon India FBA seller. If not leave this section blank.

Fulfillment centre ID:  Select the fulfillment center ID from the list.
Package height, width & length: Specify the package height, width & length at the fulfillment centre.

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.
Package dimensions unit of measure: Write the package dimension unit of measure in CM, FT, IN, M, MM.

9. Compliance

The compliance section contains certain attributed that are relevant to toy products only. Hence, sellers can leave them blank while filling details for musical instrument products. Additionally, the compliance section demands seller to fill in the battery details if the musical instrument runs on a battery. If no, then you may leave it blank.

Item weight unit of measure: The measuring unit of the instrument weight.
Item weight: The weight of the instrument.
Legal disclaimer description: Provide a short legal disclaimer about using the product.
EU toys safety directive age-specific warning: Filling in this field might be required by law only for toy products. Select the applicable toys safety age warning statements or ‘no_warning_applicable’. To verify warnings, contact the manufacturer or check the packaging.

EU toys safety directive non-age-specific warning: Filling in this field might be required by law only for toy products. Select the applicable toys safety age warning statements or ‘no_warning_applicable’. To verify warnings, contact the manufacturer or check the packaging.
EU Toys Safety Directive language warning: Filling in this field might be required by law only for toy products. For each product subject to toys safety warnings, please specify the language the toy safety warning statements are in. To check which warnings apply, contact the manufacturer or check the packaging
Country/region of origin: The country where the product originated.

Region of origin: Name of a specific region where the product originated.
Batteries are included: State whether your product includes batteries or not.
Is this product a battery or does it use batteries?: Specify whether the product is itself a battery or runs on a battery.
Battery type/size: The size and type of battery in the product. Total 3 column space.

Number of batteries: Give the total number of batteries used to operate the product.
Battery composition: Refer the battery packing for battery composition info.
Battery weight (grams): The total battery weight excluding any cover or product.
Battery weight unit of measure: The measuring unit of battery weight.
Number of lithium metal cells: The lithium metal cell content in the battery. Refer the battery packing.

Number of lithium-ion cells: Describe the total number of lithium-ion cells in the battery.
Lithium battery packaging: Select values from the drop-down list depending on the how the battery is contained in the product. For example, batteries only, with equipment, pre-installed in the equipment, etc.
Watt hours per battery: Specify the total run time of the battery in hours.
Lithium battery energy content unit of measure: The measuring unit of battery in watt-hours.

Lithium content (grams): The lithium content in the battery. Refer the battery packing.
Lithium battery weight unit of measure: The measuring unit of lithium battery weight.
Applicable dangerous goods regulations: Certain products are regulated as dangerous goods. Here you need to select values from the drop-down list. You have total 5 column space. This section is to be filled only if your product runs on battery.

UN number: The UN number is Hazmat United Nationals Regulatory ID. You can get the UN details from the manufacturer or in the safety data sheet. For example, UN1920.
Safety data sheet (SDS) URL: Insert the URL of the safety data sheet. It can be found on the manufacturer website.
Volume: The volume capacity of the product.
Item volume unit of measure: The measuring unit of the product volume.
Country/region of origin: The country where the product originated.

Flashpoint (°c)?: The flashpoint details are found in the safety data sheet or on the battery packaging.
HSN code: Write the 4 digit HSN code as per the GST regulation.
Categorisation/GHS pictograms: Select appropriate value from the drop-down list. For example, explosive, toxic, oxidizing, corrosive, etc. One value per column. Total 3 column space.

10. Offer

Item condition: State the condition of the item. For example, new, used, refurbished, etc.
Offer condition note
: Write a brief note about the item condition based on the above value.
Launch & release date: Write the launch & release date of the product if any.
Handling time: Time needed to pick, pack & ship the product.
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 aggregate ship quantity: Give the maximum number of products shipped in single order.
Product tax code
: Specify the product tax code available of sales.
Max order quantity
: Number of items a buyer can order at a time.
Shipping template: Write Migrated Template here.
Offering release date: The date when the product is available for buyers to order.

How to Upload Your Inventory File?

Till now you might have got the idea of how to prepare an excel worksheet to upload & add musical instrument category items to your Amazon India inventory. It may be very obvious that this excel file will have some errors that need to be rectified before final upload. So, let’s do that 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 then you will get to download the error report in the Monitor Upload Status. Correct them and repeat the above steps until your file is error-free. The next step is to upload the Amazon India validated excel worksheet.

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 an unlimited number of products & accessories in the Musical Instruments Category.

If you are planning to create an auto-ad campaign, click the link below for step by step guide:

Create Auto-targeted Ad Campaigns at Amazon India

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, Shoes & Handbags 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