Parts and products,ready for MRPeasy's item import.
Collect new items from every supplier and department under the names of MRPeasy's item import fields, with part numbers, units, costs, stock and vendor terms checked before the CSV goes into Stock.
MRPeasy Items
Try the template with up to 3 rows
What You'll Collect
Part description & Part No.
StringA name for each item and a unique part number, kept as text so leading zeros stay.
Group & unit
StringThe product group and unit of measurement, spelled the same every time so MRPeasy doesn't make duplicates.
Cost & stock
NumberNet cost per unit and quantity at stock, which MRPeasy needs together.
Procured or made
EnumWhether you buy the item (1) or make it in-house (0), as a dropdown.
Vendor terms
StringOne vendor with its part number, price, lead time, minimum quantity and vendor units.
Prices & reorder point
NumberSelling price, reorder point and minimum manufacturing quantity, as numbers.
Need more than three rows?
Collect items from every team and supplier.
The free template is limited to three rows so you can try the workflow. Create your own form to send to each supplier, buyer or production lead, and get one clean item file back instead of a different spreadsheet from every source.
Create your own formMRPeasy's field names
Part description, Part No., Net cost per 1 unit and the rest, so MRPeasy maps the columns for you.
Checked as they type
Repeated part numbers, negative costs, lead times that aren't whole days and flags that aren't 0 or 1 are flagged.
Your own fields
Add a drawing number or material grade to your own form.
Up to 1,000 rows
Well inside MRPeasy's 3,000 lines per upload.
How it works
From the supplier's list to MRPeasy in three steps.
01
Collect
Import an existing parts list, or send the form to each supplier or buyer.
02
Complete
One item per row. Repeated part numbers, missing descriptions and costs without a quantity are highlighted.
03
Download and import
Download the CSV and import it in Stock, Items, ticking that the first row is a heading, then check the column mapping.
Why use a form?
Typos here become new units, groups and vendors.
MRPeasy creates a unit, a product group or a vendor when it doesn't recognise the name, so pcs and pc become two units and one vendor typed two ways becomes two vendors. Cost without a quantity is imported as zero, and stock can only be set when an item is first created.
A form checks each item as it's entered, so the item list is clean before it goes into MRPeasy.
Names that create duplicates
Units, product groups and vendors are created from whatever you type. Repeat each one exactly.
Cost without quantity
Net cost and quantity at stock must come together, or MRPeasy sets the cost to zero.
Part numbers that lose zeros
Part numbers are kept as text, so 00123 stays 00123 and matches later imports.
MRPeasy items import template
How MRPeasy imports items
MRPeasy is manufacturing software for small and mid-sized makers. Its Stock, Items page can import many items at once from a CSV file, and you match each column to an item field on screen instead of following a fixed template.
Only the part description is required. A part number is optional but recommended: it is how later imports and bills of materials find the item. You can set a product group, a unit of measurement, a selling price, a reorder point, whether the item is bought or made, and, at creation only, opening stock with its cost, plus one vendor purchase term.
Unit, product group and vendor names are created if they don't exist, so spelling matters. Net cost and quantity at stock must be given together, and a vendor needs a price and a lead time with it. MRPeasy takes up to 3,000 lines per upload and returns a skip file listing any rows it couldn't import.
This template uses those field names and checks each column as it's filled in. It leaves out fields that need optional MRPeasy features, such as quality control, shelf life, serial numbers and barcodes. Importing the bill of materials afterwards? See the bill of materials template.
How-To Guides
Related Templates
Read MRPeasy import errors for every rule and its fix, or see Import Builder for manufacturing. Need vendors on their own? Use the MRPeasy vendors template.
Need a CSV form of your own?
Create a custom Import Builder form with your own fields, validation and row limits.
Get started