How to download amazon inventory file

Watch the short 2 minute video. There are two sections. One for non-clothing and one for clothing. Everything else is self explanatory. Amazon has over different Amazon seller fees and transaction types in their payment reports. How do you know which one is which and properly account for them when you run your profit loss statements and taxes? To organize your payment and transaction reports , it takes over an hour to consolidate and calculate.

Not with our template. Want to know your best seller profit and loss over the time period:. This spreadsheet is impossible to update manually. If you use Gorilla ROI addon to pull your data into the spreadsheet, follow the instructions on how to install and add any 3 of your SKUs. Detailed instructions are here. With this Amazon spreadsheet, it will automatically sort, reorganize and provide a dashboard to help you understand your data. Just copy and paste and the spreadsheet will take care of the rest.

Let the spreadsheet become your Amazon sales analysis tool along with the rest of the seller spreadsheets here. It works very similar to the Child Items Detail report above. This template takes a higher level approach of analyzing and deciphering your overall business performance based on the Sales and Traffic report. Once you copy this spreadsheet over to your account, you can copy and paste your data in it to quickly see:.

Search term are the terms that customers type in and find your products. Note that this is a manual spreadsheet. So you have to copy and paste the data in from your CSV file. Automation will come later via the addon for Gorilla ROI. This type of analysis should help you figure out where you need to improve, or where your current campaigns are strong so that you can make it even stronger and box out competitors.

This is the second of the two advertising report analyzer spreadsheets. While the customer search term spreadsheet above looks up the stats for the search terms your customer types in to the search bar, this one looks up the stats related to the keywords you currently have in your campaign. Focus on getting a higher RoAS number as it means your return is higher compared to the spend.

The way this spreadsheet has been designed is to make the data easy to understand and without having to click the same filter button so-many-times to do the same thing over and over again. The food and beverage excel flat file have 6 tabs:. Furthermore, the template tab is divided into 9 different sections like:. For easy understanding of readers, we have explained each and every attribute along with example where ever necessary.

It may happen that the flat file downloaded by you may have more or less excel tabs or attributes altogether depending upon the product type. Item name aka Title : The product name which is a combination of brand, color, size, material, weight etc. Product Type : Select appropriate value from the drop-down menu based on your product. Brand name : Describe the brand name of the product. Manufacturer : Write the name of the manufacturer.

Product description : A text-based short description of a product. Manufacturer part number : This can be the model number of your product. Sellers can leave it empty. Update delete : There are 3 values in the drop-down menu.

To add new product or update product info select update or partial update. If you want to completely delete a product then select delete. Product tax code: Enter the product tax code given by Amazon India. Package Quantity: Specify the number of items in a single package. Maximum retail price : Give the maximum retail price of the product.

Standard price : Describe the selling price of the product. Quantity : Recommended quantity of products to sell. This is your inventory commitment. This price must be low compared to MRP and selling price. Number of items : The number of items included in the product. You can leave it blank too. Is Gift Wrap Available? Launch date: The date when it will be available for buyers. Release date : It can be the same as the launch date.

Restock date : Leave this field empty. Inventory can be re-stocked anytime under inventory options on seller central. Handling time : Number of days that you need to pick, pack and ship a product after an order is made. Max aggregate ship quantity : Maximum number of items shipped together in single order.

Is discontinued by the manufacturer : Select true or false from the drop-down. Shipping-template : Write Migrated Template here. If you have your own shipping template then write their name or else leave this field empty. Item weight: Describe the actual item weight without packing materials.

Shipping weight: Write the final weight of the product after packing. Key product features: Write the most important features of your product.

Recommended browse nodes : Browse node means in which category you wish to list your product. Refer the valid value tab in the excel sheet. You can select the browsing path later on in the product detail page by leaving this field empty here. Minimum total gemstone weight : The weight of gemstone used in the jewellery.

Minimum total gemstone weight unit of measure : Numerical values of gemstone weight in carat. Item diameter : The diameter of the product. Item display diameter unit of measure : The measuring unit of the product diameter. Item weight : The weight of the product.

Item weight unit of measure : The measuring unit of the product weight. Shipping weight : The weight of the product with packaging materials. Shipping weight unit of measure : The measuring unit of the shipping weight. Item package weight : The package weight after packing. Item package weight unit of measure : The measuring unit of package weight.

Package dimensions unit of measure : The total package dimensions measuring unit. Compliance mainly comprises of battery information if your product runs on a battery or either the product is itself a battery. We will skip the battery info for jewellery products by filling in only the initial details as shown below.

Legal disclaimer : Specify any legal disclaimer associated with the product. Safety warning : Describe safety warning related while using the product. Condition : The condition of the product whether new or used. Condition Note : If not new then write a note about the condition. Max order quantity : Number of items a buyer can order at a time.

Discontinued by the manufacturer : Select true or false from the drop-down. Item package quantity: The number of items in a single package. Release date : The date when the product will be released. Number of items : The number of items packed together. Can be gift messaged : Select True if you can gift message the product to a buyer or else False.

Is gift wrap available? Launch date : Specify the product launch date. Product tax code: Enter the product tax code. Restock date : The date when the product will be restocked after the inventory is exhausted. List price : The retail price of the product.

There are few more attributes in the Offer section after the sale end date which can be left empty as they are optional information. The first step is to check the excel file. Choose your excel sheet and click check my file. Amazon India starts the validation process and informs you if there are any errors in the file. Hence, using just a single excel template a seller can upload and add any number of products to their Amazon India Inventory.

You can download free and ready-to-use other excel business templates in different categories helpful for the smooth running of your business. If you have any queries or suggestions please share in the comment section below. I will be more than happy to assist you. Your email address will not be published. Save my name, email, and website in this browser for the next time I comment. Notify me of follow-up comments by email. Notify me of new posts by email.