How to Update Product Quantity in Bulk on Amazon Seller Central

Last Updated on March 1, 2019 by

How to Update Product Quantity in Bulk on Amazon Seller Central

Amazon is one of the most popular e-commerce sites in the world, would mean the possibility to reach out to millions of potential customers in a single platform. Although updating the quantity of a large number of products, one-by-one can be a tedious task, it’s an essential part of the listing process for the regular sellers. This becomes a bigger headache as the seller’s inventory size grows over time. As Norman Vincent Peale said, “Every problem has in it the seeds of its own solution.”, the answer lies in update product quantity in bulk on Amazon using its own template.

How to Update Product Quantity in Bulk on Amazon Seller Central

Updating Quantity in bulk in amazon seller central can be done with several ways, one is from INventory Loader file or Price & Quantity file or using Category Specific inventory file, Here we will discuss the process with Category Specific inventory file using Partial Update features of the flat feed file. To get more detail about Partial Update feature of a flat file you can visit here.

Before getting into this article it is advised to use an Excel Spreadsheet to store the product SKUs and Latest Quantity Number of the products that need to be updated, before starting the process. You can also use free and open-source software like Apache OpenOffice Calc and LibreOffice Calc.

Update Product Quantity: Bulk Change or Edit quantity

Step 1:

Log in to your Amazon seller account and from the top-most menu bar in the dashboard, hover over the “Inventory” & select “Add Products via Upload” from the dropdown menu.
Update Product Quantity

Step 2:

Clicking on “Download an Inventory File” will enable you to choose the product category from the Product Classifier section positioned in the Step 1 section. Then, in the Step 2 section where you need to select the type of template, choose the option “Custom”.
Update Product Quantity

Update Product Quantity

Step 3:

Selecting the “Custom”, facilitates the users to pick attributes related to the product category selected in the “Product Classifier” section. For the Template type, select “Basic” from the left-hand side “Available Attribute Groups” list and then click on the “Add” button. You will see “Basic” will be on the right-hand side “Selected Attributes Group” area. Then click on “Generate Template” button which will automatically start downloading the template file on the browser.

Update Product Quantity

Step 4:

Navigate to where you have downloaded the template file & open it using any Spreadsheet application, i.e. MS Excel, OpenOffice, LibreOffice. In the Template file, you need to fill in the Seller SKU and the Quantity cells according to your products. From the “Basic” column, click the “Update Delete” cell and select the “Partial Update” option for each product. When you have completed editing the template file, save the file as .xls format.
Update Product Quantity

Step 5:

Now you need to upload the updated template file. Navigate back to that same Seller Central page where you downloaded that template file and this time click on the “Check and Upload your Inventory File” tab. Select the File Type as “Inventory Files for non-Media Categories”, find and select the saved Excel file from your computer by clicking on the “Choose file” button and then click on the “Check my file” button.
Update Product Quantity

Step 6:

After completing the file checking process, you can move on to the option to actually upload the file to the Amazon system. Select the “File Type” as “Inventory Files for non-Media Categories”, choose the same Excel file that you selected on Step 5 of this tutorial by clicking the “Choose File” button and select the “Excel” option on the “Processing Report (Output) Format” section. Finally, click on the “Upload” button.

Update Product Quantity

Usually, after about 15 minutes or more, the inventory & the quantity of the products will be updated. Files that are more than 5MB takes around a few hours to be processed & the corresponding products to be updated.

So, there you have it! Following these 6 simple steps will help you to solve that monotonous job at hand of updating each and every product on Amazon one-by-one. Amazon provides instructions and examples on the template file for your reference. After successfully completing the upload you can always check the status of your upload on the “Monitor Upload Status” tab next to the “Check and Upload your inventory File” tab. Last but not least, always keep in mind to strictly follow the attributes in the template file & fill in the required fields to avoid any unnecessary errors.
If you have any confusion, then feel free to contact us. we provide the best eCommerce solution.

Leave a Comment

BLOG CATEGORIES

BOOK FOR FREE CONSULTATION

    Sign Up For Our Newsletter

    Keep yourself updated with latest trends to maximize revenues across all of your sales channels.

    POPULAR TAGS

    What Clients Say About Us?

    Wow, their team has been great! I have been working with freelancers and remote marketing agencies for about a decade and they are among the best.

    Isaac Curtiss

    Office Furniture Outlet INC.

    Helped overcome difficult tasks that would have taken us a lot of time. We do recommend their services!

    Blake Tanner

    Tanner International INC.

    I’ve been working with Fred and his team for the past few months and have been very happy with their work.

    Dan Hawkins

    Mixles Limited

    Great help/addition to our business. All tasks are fully completed in a timely manner.

    Maurice Embry

    Sam Tucker LLC

    Used for years now and wil continue to use for many more years. I also have no doubt recommending friends and colleagues to use too.

    Nathan Reeves

    Xenons Online Limited

    Our company has worked with Ecomclips for over a year now. I’ve found the team to be very flexible, easy to coach, and adaptable. You won’t regret working with them.

    Abraham Kwan

    PG Incorporation

    The team at Ecomclips has served all my needs with excellence. They are very attentive to my requirements. Communication is fast and crystal clear. I definitely recommend them.

    PR

    Right Parts Group INC.

    So far I have hired Freddy and his team has been excellent, they are guiding me as grow my business. I will continue to work with them.

    Bev Matushewski

    FiTTeck INC.

    Excellent friendly prompt service

    Ahmedani

    Ahmedani Canada INC.

    We’ve been working with Ecomclips for a couple of years now and we are more than happy and appreciative of the their service. Definitely recommend.

    Michael Burnley

    Zooshoo INC.

    A+++ Perfect!!

    Imran Hassam

    Amedeo Apparels Limited

    RECENT BLOG POSTS

    How to List Items on Wish Manually | Step-by-Step Guide for Beginners

    Wish is an American-based online e-commerce platform. It is a perfect eCommerce platform t

    Read More

    How To Print Shipping Labels In Bulk Or Single from Linnworks

    How To Print Shipping Labels In Bulk Or Single from Linnworks

    Linnworks is one of the greatest tools that allows you to list items, manage inventory, an

    Read More

    Customize Your eBay Store | eBay Store Management Guide

    As we all know, eBay is one of the most popular online marketplaces around the globe. If y

    Read More