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.
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.
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.
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.
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.
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.
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.
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:
Step-By-Step Guide to Create Self Ship Shipping Template For Amazon India
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.
To simplify the process, we have created a simple and easy UK VAT Taxable Turnover…
Every business has to register for VAT with HM Revenue and Customs if their VAT…
We have created the UK VAT Dual Currency Invoice excel template with predefined formulas that…
We have created a simple and easy UK VAT Purchase Register Excel Template with predefined…
We have created a simple and easy UK VAT Sales Register Excel Template with predefined…
We have created a ready to use UK VAT Progress Billing Invoice template in excel…