Track product variants and inventory levels with a free SKU generator

Create SKUs or stock keeping units and assign them to all your product variants with a free SKU generator template. This Excel file will not only generate SKUs but help you track material and product availability, identify shrinkage, and keep you in stock.

Thank you for downloading and happy manufacturing!

If your download doesn’t start, get your free SKU generator here.

SKU generators give you the overview you need to stay in stock

If you’re a small manufacturer, you may already be familiar with the term SKU and already are using SKUs in some capacity. With the help of an SKU generator tool you can easily create and track SKUs as you start boosting your product offering and scaling your team.
MRP software with barcode scanning

What is a stock-keeping unit (SKU) and what are they used for?

SKUs or stock-keeping units are internal product codes you can use to identify and track product variants. They are typically alphanumeric and represent characteristics of each variant to make them easier to identify. With an SKU generator, you can easily keep track of item availability and get more control over your inventory.

Barcode scanners for inventory control need to be carefully investigated to fit the conditions of your manufacturing plant.

Reasons to use an Excel SKU generator like this free tool

Using a single tool to generate SKUs reduces the risk of human error and ensures that all your teams use the correct references when referring to materials and products.

  • Easily manage stock availability and track product SKUs
  • Identify the products that have the highest profit margins
  • Keep your team aligned by using the same product references
Tracking physical inventory counts with Katana

You can also track and assign SKUs with manufacturing software

Spreadsheets are static, but your inventory is not. With Katana, you can effortlessly manage up to 20,000 unique SKUs, making it possible to continuously add products and materials to your catalog without affecting your account’s performance. No risk of corrupted Excel spreadsheets or manual updates required.

Start free 14-day trial

Boost efficiency and align your teams
with features designed to give you total
visibility and control

Get a live look at your manufacturing business with features
that keep your teams and products moving.
LIVE INVENTORY MANAGEMENT

The inventory optimization and control you need

Keep track of materials and product stock to avoid stock-outs

  • Get total inventory control for finished products and raw materials
  • Automate inventory transactions and set reorder points to prevent stock-outs
  • Track on-hand, committed, and expected stock amounts in real-time
  • Manage product variants and materials in one place
  • Monitor your inventory across multiple warehouses
  • Use barcodes to receive and count stock
  • Use stocktakes to find and eliminate discrepancies in your stock levels
See what else is included in your plan
REAL-TIME MASTER PLANNING

Production, scheduling, and
resource management in one place

Gain real-time visibility to optimize all your key resources

  • Make accurate manufacturing and purchasing decisions with live data
  • Ensure optimal inventory levels at all times
  • Prioritize production based on raw material availability
  • Get task-level control for effective shop floor management
  • Automate manufacturing cost calculations based on your bill of materials and operations
See what else is included in your plan
TOTAL SHOP FLOOR CONTROL

Floor-level control from scheduling to task prioritization

Use the Katana Shop Floor App to align sales and production

  • Send tasks to the app according to product operations for incoming manufacturing orders
  • Assign and reassign jobs to operators who can start, pause, and resume tasks to keep you up to date on production
  • View manufacturing order task and ingredient list for every task in the app
  • Track time spent on tasks to optimize shop floor activities
  • View resource consumption with live material tracking
  • Add notes to manufacturing orders to be displayed for related tasks
  • Scan barcodes with any smart device to monitor material usage and track batches and products

See what else is included in your plan
OMNICHANNEL ORDER MANAGEMENT

Unified B2B and e-commerce sales order management

Sync your sales channels for optimal order fulfillment

  • Track the availability of required products for sales orders
  • Drag-and-drop order priorities according to material availability and delivery deadlines
  • Choose to make to order or fulfill from available product stock
  • Identify delivery delay risks and reprioritize to boost efficiency
  • Sync sales orders from multiple channels into a single dashboard
  • Select and use multiple currencies to automatically convert sales order values

See what else is included in your plan
END-TO-END TRACEABILITY

Tracing for batches, materials, expiry dates, and more

Keep an eye on your inventory beyond the warehouse

  • End-to-end traceability for materials and products with batch tracking
  • Track the expiry date of items and stay in control of expiring stock
  • Autogenerate batch and internal barcodes
  • Quickly locate items across multiple warehouses, giving all teams access to the same live data
  • Trace faulty batches, materials, and products from materials to sold goods for effective quality assurance and recalls
See what else is included in your plan
PRODUCTION PLANNING

Routing and matrix BOMs for your variable products

Automate the reallocation of materials based on priorities you set

  • Drag-and-drop priorities for manufacturing tasks
  • Track availability for required materials for efficient sales order fulfillment
  • Identify delay risks related to material supply lead times
  • Get accurate expected completion dates to keep sales teams informed
  • Have a live floor-level production status overview
See what else is included in your plan
Simplified screenshot
PURCHASE ORDER MANAGEMENT

Granular purchase order tracking for maximum visibility

Avoid stock-outs and keep your teams and products moving

  • Ensure on-time purchasing based on clear material requirements
  • Know when to purchase missing raw materials from suppliers
  • Update your inventory to reflect when purchase orders were received in parts
  • Track delay risks in your supply chain to keep all teams informed
  • Select and use multiple currencies to automatically convert purchase order values
See what else is included in your plan
CONTRACT MANUFACTURING WORKFLOWS

Get the visibility you need when working with contractors

Katana gives you an overview of material usage and the statuses of your outsourced purchase orders.

  • Issue purchase orders for outsourced manufacturing
  • Track materials in your partner locations in real time
  • Spot and purchase missing materials in contract suppliers’ locations
  • Receive items to stock with accurate cost values
Accurate costing with Katana's software
ACCURATE COSTING

Real-time reliable costing made easy

Ensure accuracy with costing features built for precision

  • Track manufacturing costs based on your bill of materials (BOM) and production operations
  • Create multilevel BOMs with subassemblies for accurate costing
  • Make precise pricing decisions based on your product margins
See what else is included in your plan
Simple workflows with Katana's software
CUSTOM WORKFLOWS VIA API

Katana’s open API and no-code solutions

Set up integrations and create workflows to streamline your operations

 

  • Sync your Katana data with hundreds of e-commerce, shipping, accounting, and reporting platforms
  • Build your own apps into Katana using our developer resources and open API
  • Take advantage of apps that have been built into Katana on our open API
  • Develop your custom workflows with Katana API

 

See what else is included in your plan

Sign up for a free 14-day Katana trial

Katana is an upgrade from Excel SKU generators to a total manufacturing software solution that keeps your inventory, sales, and production in sync.
*No credit card required

Why NatureWall turned to Katana instead of Excel templates to track stock

NatureWall home and furniture products built using Katana — living room slatfwall
Katana is a very educated Excel sheet, which is easier to use. If you give someone an Excel sheet with all the data that Katana has behind it, it would just be confusing, but you have lovely click buttons and icons that make it so easy — it’s the perfect Excel package.

Stephen Newlove, Procurement and Logistics Manager at NatureWall

 

Read the full case study
Get the visibility you need to move products and make decisions
Start a free 14-day trial*
*No credit card required