noobfit.blogg.se - Inventory control for small business free

We’ve also included some columns highlighted in blue. And if you get lost, don’t worry-we’ve left some examples of inventory items on the sheet for you to take your cues from. We also left a spot where you can specify whether an item has been discontinued or not. Vendor: The company you order the item from.Reorder quantity: The number of units you should reorder (when it’s time to reorder).Reorder level: The stock level at which you need to reorder the item.

Stock location: The warehouse inventory location where the item’s stored (you can get as vague or as specific as you want-whatever’s most useful for you).

List price: The amount you sell the product for.

Description: A brief description of the item.

Name: A name for your product to help you recognize the item at first glance.

Product category: The category of your product (like “Clothing”).

SKU: The item number you use to track your products.

To enter your product info, you'll need the following information for each item:

Once you've received our Excel inventory tracking template, you'll want to get started entering your stock item information on the sheet labeled “Products.” This inventory sheet includes all the conditional formatting needed to highlight items that are due for reordering.