Inventory Management in Excel

Looking for examples of how to manage your warehouse and inventory with Excel? On this page, you'll find all the Excel examples and templates you need.

Inventory template

With this Excel template, you can track all your product inventory: how many items you have, their value, and which products are reserved. The 'available stock' in the list is the inventory you can still sell. This is the stock level you also display on your webshop.

Download inventory template

Inventory management with locations

Packing slip template

Once you have an order ready to ship, you'll also want to create a packing slip. The packing slip lists all the products in the box. This allows the customer to verify they've received everything you've sent.

More about packing slips

Walk less in the warehouse

Automate your warehouse with Picqer

Picqer is warehouse software specially designed for ecommerce. With Picqer, you no longer have to track inventory manually – everything is handled automatically for you. No more messing around in Excel.

Inventory is tracked automatically, and automatic purchase suggestions can be sent to your supplier with just one click. Picqer supports you in everything that needs to be done. From smart purchasing to processing and shipping your orders.

Learn more about Picqer

Free book with warehouse tips

Want to know more about running a professional warehouse? Request our free hardcover book, packed with tips for your warehouse.

Our mission is to help as many online stores as possible run professionally. This book helps you achieve that.

Order the book