Books are still in fashion despite a huge appetite for e-books in today’s modern times where thousands of tech gadgets and websites are heavily loaded with free reading material. In today’s e-reading technology we will discuss uploading the traditional printed books category excel file.
It is estimated that the sales of printed books grew by 7% in 2016 compared to the previous year. Hence, we can have a sigh of relief that printed reading material is really not out of the trend and a seller can go consider going with an online bookstore.
To help booksellers we have listed all the books category below. Walk through the list to find out whether your category is present or not.
List of Books Category on Amazon India
- Action & Adventure
- Arts, Film & Photography
(Architecture, Cinema & Broadcast, Dance, Design & Fashion, History, Theory & Criticism, Museums & Museology, Music, Painting, Photography, Sculpture, Theatre & Spectacles)
- Biographies, Diaries & True Accounts
(Biographies & Autobiographies, Diaries, Letters & Journals & True Accounts)
- Business & Economics
(Business Self-Help, Business, Strategy & Management, Economics & Industries & Business Sectors)
- Children’s & Young Adult
(Adventure, Comics & Mangas, Crafts, Hobbies & Practical Interests, Crime & Thriller, Early Learning, Family, Personal & Social Issues, Fantasy, Science Fiction & Horror, Games, Toys & Activities, Historical Fiction, History, Humour, Interactive & Activity Books, Language Learning, Literature & Fiction, Money & Jobs, Mysteries & Curiosities, Painting, Arts & Music, Picture Books, Reference, Religion, Science, Nature & Technology, Sport & Traditional Stories)
- Comics & Mangas
- Computing, Internet & Digital Media
(Computer & Video Games, Computer Science, Computer Security, Databases, Digital Media & Graphic Design, Hardware & Handheld Devices, Internet & Web, Networks & System Administration, Operating Systems, Programming & Software Development & Software & Business Applications)
- Crafts, Home & Lifestyle
(Antiques & Collectables, Food, Drink & Entertaining, Games & Quizzes, Gardening, Handicrafts, Decorative Arts & Crafts, Home & House Maintenance, Lifestyle & Personal Style Guides, Models & Model Railroading & Pets)
- Crime, Thriller & Mystery
- Exam Preparation
(Banking & Insurance, Defence, Engineering Entrance, Exams by UPSC, Finance & Accounting, Government Exams, IGNOU Entrance Exam, International Entrance Exams, Interview Preparation, Law Entrance Exams, Management Entrance, Medical Entrance, Polytechnics & ITI & Professional Certification Exams)
- Fantasy, Horror & Science Fiction
(Fantasy, Horror & Science Fiction Books)
- Health, Family & Personal Development
(Family & Relationships, Healthy Living & Wellness, Mind, Body & Spirit, Personal Development & Self-Help)
- Historical Fiction
(Africa, Ancient, Asia, Europe, Indian History, Latin America, Middle East, Military & United States)
- Language, Linguistics & Writing
(Dictionaries, Grammar, Journalism, Language Learning & Teaching, Linguistics, Rhetoric & Speech & Writing Guides)
(Bar Exams, Business Law, Constitutional Law, Criminal Law, Legal Reference & Tax Law)
- Literature & Fiction
(Anthologies, Classic Fiction, Contemporary Fiction, Essays, Indian Writing, Literary Theory, History & Criticism, Myths, Legends & Sagas, Plays, Poetry, Religious & Spiritual Fiction, Short Stories & Travel Writing)
- Maps & Atlases
(Freedom & Security, International Relations & Globalization, Political Ideologies, Political Parties, Political Structure & Processes, Political Theory & Public Administration)
(Dictionaries & Thesauruses, Encyclopaedias & Reference Works, Etiquette, Library & Information Science, Words, Language & Grammar)
(Baha’i, Buddhism, Christianity, Ethnical, Hinduism, Islam, Jainism, Judaism, New Age, Religious Studies, Shintoism & Sikhism)
(Anthologies, Contemporary, Fantasy, Futuristic & Ghost, Historical & Romantic Suspense)
- Sciences, Technology & Medicine
(Agriculture & Farming, Astronomy, Biology & Life Sciences, Chemistry, Earth Sciences, Engineering & Technology, Environment, Geography, Mathematics, Medicine, Physics, Transportation & Automotive)
- Society & Social Sciences
(Anthropology, Education, Philosophy, Psychology, Social Welfare & Social Services, Society & Culture & Sociology)
(Active Outdoor Pursuits, Air Sports, American Football, Badminton, Baseball, Basketball, Bodybuilding & Weightlifting, Bowls, Bowling & Petanque, Cheerleading, Combat Sports & Self-Defence, Cricket, Cycling, Equestrian & Animal Sports, Field Sports, Golf, Gymnastics, Hockey, Hurling, Juggling, Lacrosse, Marathon & Running, Motor Sports, Netball, Pool, Billiards & Snooker, Rugby, Skateboarding & Rollerblading, Soccer, Softball, Sporting Events & Organisations, Squash & Racquetball, Table Tennis, Tennis, Training & Coaching, Triathlon, Volleyball, Water Sports & Winter Sports)
- Textbooks & Study Guides
(Higher Education Textbooks, Reference, School Textbooks, Study Guides & Workbooks)
(Food, Lodging & Transportation, Illustrated Books, Specialty Travel, Travel & Holiday Guides & Travel Writing)
- Other (Books)
How to Download Amazon Inventory File for Books 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 Books category. We have taken Crime, Thriller & Mystery Book 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 Books Category?
Here we have taken “Crime, Thriller & Mystery” template as an example in Books Category. The downloaded excel file has 7 worksheets, out of which only the “Template” sheet is to be filled. Rest of the sheets are for reference purpose only.
There are total 10 sections in the Crime, Thriller & Mystery Books Excel Template. These sections remain the same (with a minor change in the sequence of field columns) for any genre book excel sheet that you download.
- Required information
- Basic product details
- Product enrichment
In this excel worksheet, you will come across the “Compliance” section which requires battery information. In order to upload books, we will leave this entire section empty. Compliance section is totally irrelevant for certain categories and a seller can always upload the excel sheet keeping these fields empty.
Read further for a better understanding of the necessary attributes and fields relevant to Books Category.
1. Required Information
Product type: Describe the type of product. For example, Crime, Thriller or Mystery Books.
Seller SKU: The inventory identification number given to the book.
Title: A short title including book name, author, genre, subject, etc.
Product ID: Write the 12, 14 or 16 digit numerical value of the ID above.
Product ID type: Select UPC, EAN, GCID, ASIN etc. from the drop-down list.
Recommended browse nodes: Refer valid values tab in the downloaded excel file for browse nodes.
Product format: The format of the book. For example, thread bound, spiral bound, etc.
Publisher: Name of the publisher or publication house.
Author: The author of the book. You get 3 column space to write author name.
Publication year: The year in which the book was published.
Standard price: The selling price of the book.
Quantity: Enter the quantity of the book available for sales.
Shipping Template: Write Migrated Template here.
Main image URL: Insert the main image URL of the book.
Insert other images of the book with white background & high definition zoomable quality.
Pro Tip for Images
Upload all the product images on Google Drive or Dropbox or any other could platform. Generate shareable links of the images. Copy these links & paste them here. You have total 8 column space to insert image URLs.
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.
Brand name: Th brand or a famous name of the book.
Description: Describe the subject or genre of the book in brief.
Edition: Write the current edition (volume) of the book.
Auto encoding language: Select a value for language from the drop-down list. You get 3 column space.
Catalog number: Write a unique ID given to a specific collection of books.
Search terms: You Get total 5 space to write search terms or search keywords.
Bullet points: Key features or highlights of the book with a total 5 column space.
BIC subject code: BIC is a commonly used classification tool developed by Book Industry Communication. For example, if you are listing a political thriller, you can post this under F (for Fiction), FH (for Fiction Thriller), and also FHP (for a Political/Legal thriller).
Target audience: Describe the target audience of your book. For example, male, female, kids, adults, etc.
5. Product Enrichment
Series number: A book series or volume number of the book in sequence.
Preface: A short introduction to the book written by the author.
Illustrator: Name of the person who has created pictures in the book.
Contributor: Name of an individual or group of people who contributed towards the making of the book.
Editor: Name of the person or group who finalised the content of the book.
Introduction: The person who wrote the initial part of the book.
Translator: The name of the person who is responsible for translating the original content of the book.
Foreword: The person who has written the introductory remarks in the book other than the author.
Photographer: The person who took the photo images in the book.
Narrator: The name of the person who has written the narration of the book other than the author.
Series title: The title of the current book series which is uploaded for selling on Amazon India.
Character: The name of a specific character of the book.
Shipping weight: The weight of the book after packing in numerical.
Website shipping weight unit of measure: The measuring unit of shipping weight.
Item height & length: Specify the height & length of the book.
Item length unit of measure: The measuring unit of the item length.
Width: Specify the width of the book.
Item weight: The actual weight of the book without packing.
Item weight unit of measure: The measuring unit of the book weight.
Item dimension unit of measure: The measuring unit of the book’s dimension.
Package height, width & length: Write the package height, width & length.
Package length unit of measure: Specify the package length measuring unit.
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.
Package dimensions unit of measure: Write the package dimension unit of measure in CM, FT, IN, M, MM.
Handling time: Time needed to pick, pack & ship the product.
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.
Max order quantity: Number of items or books a buyer can order at a time.
Launch & release date: Specify the current dates as launch & release dates.
Number of items: Total number of items in a single package.
Item package quantity: The total number of books included in a single package.
Is gift wrap available?: If the book is available in gift wrap then select True or else False.
Can be gift message: If you can print a gift message then select True or else False.
Is discontinued by manufacturer: Select true or false from the drop-down.
Registered parameter: Select from the values like PrivateLabel, Specialized, NonConsumer, or PreConfigured.
Sale price: The price at which a seller offers a book on SALE.
Sale start & end date: The date when you want to start & end a sale.
Product tax code: Specify the tax code of the book, genre or the category.
Restock date: The date when a product will be restocked again. This is not mandatory.
Stop selling date: The date after which your product will be unavailable for selling.
Offering release date: The date when the product will be available for order dispatch.
Maximum retail price: The price which is higher than or equal to the selling price.
How to Upload Your Inventory File?
After filling in all the details its time to check the excel file. It is advisable to check the stock upload excel file so that you can figure out probable errors or warnings if any before final upload. Follow the steps below to check your file.
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.
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.
Hence, using a single excel stock template a seller can add an unlimited number of books in the Books Category.
To create a self-shipping template click the link below:
Browse 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 and Electronics to list & sell relevant category products.
If a seller cannot find an excel template for his/her desired product then they can go with an Amazon Product Flat File to add items to the inventory stock.
You can also download free and ready-to-use Business Excel Templates in different categories like accounting, financial management, 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.