CSV Template

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's field namesRepeated part numbers flaggedTry it free

MRPeasy Items

Try the template with up to 3 rows

What You'll Collect

Part description & Part No.

String
*Required

A name for each item and a unique part number, kept as text so leading zeros stay.

Group & unit

String
*Required

The product group and unit of measurement, spelled the same every time so MRPeasy doesn't make duplicates.

Cost & stock

Number
*Required

Net cost per unit and quantity at stock, which MRPeasy needs together.

Procured or made

Enum
*Required

Whether you buy the item (1) or make it in-house (0), as a dropdown.

Vendor terms

String
*Required

One vendor with its part number, price, lead time, minimum quantity and vendor units.

Prices & reorder point

Number
*Required

Selling 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 form

MRPeasy'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.

Need a CSV form of your own?

Create a custom Import Builder form with your own fields, validation and row limits.

Get started
Import Builder is an independent product and is not affiliated with, endorsed by, or sponsored by MRPeasy. MRPeasy is a trademark of its owner. Fields as described in MRPeasy's user manual, November 2026.