Bills of materials,one component per row.
Collect what goes into each product, component by component, in the layout MRP systems import: product SKU, component SKU and quantity, with part numbers kept exactly as written.
Bill of Materials
Try the template with up to 3 rows
What You'll Collect
Product SKU
StringThe finished product or sub-assembly, repeated on each of its rows.
Component SKU
StringThe part or material that goes into it, kept as text so leading zeros stay.
Quantity
NumberHow much one finished product uses, as a plain number such as 2 or 0.25.
Names for reference
StringProduct and component names, so whoever fills it in can check what they're entering.
Notes
StringHandling or assembly notes for each component.
Sub-assemblies
StringA sub-assembly is a component in one bill of materials and a product in its own rows.
Need more than three rows?
Load every product's recipe at once.
The free template is limited to three rows so you can try the workflow. Create your own form to collect up to a thousand component lines, from engineering, a contract manufacturer or the system you're moving from.
Create your own formUp to 1,000 rows
One row per component, for a whole product range.
Katana's column names
The headers are Katana's recipe import headers, and each maps directly onto an MRPeasy BOM field.
Checked as they type
Missing SKUs, quantities that aren't numbers and part numbers Excel would change are caught as people type.
Your SKUs as dropdowns
In your own form, turn the SKU columns into lists of your existing items, so every row matches something in your system.
How it works
From product structure to MRP in three steps.
01
Collect
Import an existing BOM export, or send the form to whoever knows what goes into each product.
02
Complete
Each component gets a row. Missing SKUs and quantities that aren't plain numbers are highlighted.
03
Download
Download the CSV and import it: in Katana as a BOMs & Recipes import (saved as .xlsx), or in MRPeasy under Bills of materials, Import from CSV.
Why use a form?
A BOM only imports if every SKU matches.
Katana and MRPeasy can't create items from a BOM import: every product and component must already exist, with exactly the same code. A part number that lost its leading zero in Excel, or a component typed slightly differently, doesn't match and the line fails.
A form keeps part numbers exactly as typed, and in your own form the SKU columns can be dropdowns of the items you already have.
Part numbers Excel has changed
SKUs are kept as text, so 00412 keeps its zeros and long codes never become 1.23E+11.
Quantities that aren't numbers
2 pcs, ½ or 1,5 are flagged; quantities must be plain numbers such as 2 or 0.25.
Rows without a product
Every row needs its product SKU, so no component ends up in no one's bill of materials.
BOM CSV template
How a bill of materials is laid out for import
A bill of materials lists what goes into a product: each component and how much of it one finished unit uses. For import, MRP systems such as Katana and MRPeasy take it flat, one row per component, with the product's code repeated on each of its rows. A product with five components is five rows.
Multi-level products work the same way. A sub-assembly appears as a component in the bill of materials of the product it goes into, and as a product in its own rows, listing its own components. Each sub-assembly needs its own item code.
The import can't create items, so add your products and materials first, then the bills of materials. Katana reads the three required columns used here (Product variant code / SKU, Ingredient variant code / SKU and Quantity) from an .xls or .xlsx file, and asks whether to replace existing recipes or add to them. MRPeasy reads CSV, lets you choose a field for each column, and takes up to 3,000 lines per upload.
This template checks each column as it's filled in. It can't check that a SKU exists in your system, or that a component isn't listed twice for the same product, so in your own form, turn the SKU columns into dropdowns of your items, and add quantities up rather than repeating a component.
How-To Guides
Related Templates
Setting up the parts first? Use the Fishbowl part import template, or for kits sold as one product, the bundle and kit assembly template.
Need a CSV form of your own?
Create a custom Import Builder form with your own fields, validation and row limits.
Get started