You can set up your initial stock in Katana using four main methods:
Import from your e-commerce store (e.g. Shopify, WooCommerce)
Manually create a Stock adjustment
Import via spreadsheet
Adding stock levels per item
This guide explains each method step-by-step so your inventory is accurate from the start.
Note: If you use batch tracking (available with the Full Traceability add-on), batch details cannot be imported from e-commerce. You’ll need to import batches separately using our batch import spreadsheet.
Method 1: Import from your e-commerce platform
If you already manage product stock levels in an e-commerce store:
Connect your e-store to Katana (via Integrations).
Import all your products and their current stock levels directly.
Limitations:
Only product stock can be imported this way (materials usually aren’t tracked in e-commerce).
Batch tracking details are not included — use the batch import spreadsheet if needed.
Method 2: Create a Stock adjustment
Use this method to manually enter your initial stock for products and/or materials.
Go to Stock > Stock adjustments tab > + New Stock adjustment.
In the Reason field, type "Initial stock" so it’s easy to find later.
Add existing items from Katana or type a new name and select Create new [item name].
Choose whether the item is a Product or Material and fill in the required details.
If you use batch tracking, specify the batch information here.
Method 3: Import via spreadsheet
Use this method if you want to import both products and materials in bulk.
Download the Update stock levels and stock values import template from Settings > Data import.
Fill in item names, quantities, and values in the spreadsheet.
If you use batch tracking, follow this guide to import new batches with quantities and values.
Upload the spreadsheet to Katana.
Result: Katana will create a Stock adjustment automatically, with the reason set to "Imported from Excel". You can view it in Stock > Stock adjustments.
Method 4: Add stock levels per item
If you want to add stock levels as you add each item, this is the best method.
Note: If the item is serial number or batch trackable, when adding the initial stock for these items, unbatched batches will be created. To fix this, you'll need to create a stock adjustment to remove unbatched quantities and add the quantities back with the correct batch.
Add a new product or material.
Under the In stock column of the item's table, click on Add initial stock.
Add the stock quantity and cost per unit, and press Add initial stock.
Tip: For the fastest setup, choose the method that best matches your current system:
Already tracking product stock in e-commerce? → Method 1
Want to manually enter stock? → Method 2
Have a large list of items? → Method 3
Want to add stock as you go → Method 4
Quick Comparison of Methods
Method | Best For | Supports products | Supports materials | Tracking | Speed |
Import from e-commerce | You already manage product stock in Shopify, WooCommerce, etc. | ✅ | ❌ | ❌ | Fast |
Stock adjustment | Manually entering stock for a small or medium list | ✅ | ✅ | ✅ | Medium |
Spreadsheet import | Bulk updates for products and materials | ✅ | ✅ | ✅ | Fast |
Per item | Adding stock when adding individual items | ✅ | ✅ | ❌ | Medium |
Your feedback is invaluable. Let us know your thoughts on this article or anything in Katana you'd like to see improved: [email protected]