Inventory Master List & SKU Master
Create a central inventory database for SKU codes, barcodes, suppliers, pricing, replenishment settings, warehouse locations and item-control information.
Keep your item information in one place
A well-maintained SKU master helps small businesses, e-commerce sellers and warehouse teams keep product information consistent across inventory operations.
SKU & Barcode
Maintain unique item codes and barcode references for each inventory item.
Supplier Information
Record the primary supplier and supplier-specific item code for easier purchasing.
Pricing & Margin
Enter unit cost and selling price to automatically calculate gross profit and gross margin.
Warehouse Location
Record the warehouse and bin location where each item is normally stored.
Essential SKU master fields
The workbook combines product, supplier, pricing, replenishment and warehouse information.
Product Identification
SKU / Item Code, barcode, item description, category, brand and unit of measure.
Supplier Data
Maintain the primary supplier and supplier SKU used when purchasing the item.
Cost & Selling Price
Record unit cost and selling price with automatic gross profit and gross margin calculations.
Replenishment Settings
Maintain reorder level, safety stock and supplier lead time for inventory planning.
Storage Location
Record warehouse and bin-location information for faster item identification.
Traceability Settings
Identify items that require batch or expiry tracking and maintain their current status.
Built-in checks and calculations
The workbook includes useful controls to help maintain cleaner and more complete inventory master data.
Automatic Gross Profit
Gross profit is calculated automatically from selling price minus unit cost.
Automatic Gross Margin
Gross margin percentage is calculated automatically when valid pricing information is entered.
Duplicate SKU Warning
Duplicate SKU codes are highlighted to help prevent multiple products using the same item code.
Missing Data Warning
Important missing master-data fields are highlighted when an SKU has been created.
Quick inventory master overview
The workbook includes a simple summary area that updates as you build your item master.
Total Records • Active Items • Inactive Items
Duplicate SKU Records • Missing Description / UOM
Average Gross Margin • Items with Reorder Setup
Build your SKU master in four steps
Create the SKU
Assign a unique SKU or item code and enter the product description, barcode, category and UOM.
Add supplier details
Record the primary supplier and supplier item reference used when purchasing.
Set inventory controls
Add reorder level, safety stock, lead time, warehouse and bin location.
Maintain the master
Review the list regularly and mark obsolete products as inactive or discontinued rather than reusing SKU codes.
Automatic product margin calculations
Gross Profit
Selling Price − Unit Cost
Gross Margin %
Gross Profit ÷ Selling Price × 100
Download the Inventory Master List
The workbook includes the Inventory Master, reference lists, instructions and example data.
Inventory Master List — Excel
Manage up to 100 inventory items with SKU controls, supplier information, pricing and replenishment settings.
Download Excel →Stock Movement Register
Once your SKUs are established, use the Stock Movement Register to track receipts, issues and adjustments.
View Stock Movement Register →Inventory Master List — Frequently Asked Questions
What is an inventory master list?
An inventory master list is a central record containing the core information used to identify and manage each inventory item.
What is an SKU?
SKU means Stock Keeping Unit. It is a unique internal code used by a business to identify and manage a product or inventory item.
Can I use the template for e-commerce products?
Yes. The template can be used for many small-business and e-commerce inventory operations that need a structured SKU and product master.
Does the template detect duplicate SKUs?
Yes. Duplicate SKU codes are highlighted to help identify potential master-data errors.
Does it calculate product profit?
Yes. Enter unit cost and selling price and the workbook calculates gross profit and gross margin percentage.
What should I do with discontinued products?
Rather than deleting historical item information or reusing the SKU for another product, you can mark the item as discontinued in the Status field.
Continue building your inventory system
Stock Count Sheet
Record physical quantities during cycle counts and full inventory counts.
Stock Variance Report
Compare physical quantities with system stock and investigate inventory differences.
Stock Movement Register
Track receipts, issues, transfers, returns and inventory adjustments.