Suppliers,ready for MRPeasy's vendor import.
Collect suppliers under the names of MRPeasy's vendor import fields, with company names, vendor numbers, contact details, lead times and payment terms checked before the CSV goes into Procurement.
MRPeasy Vendors
Try the template with up to 3 rows
What You'll Collect
Company name & vendor number
StringA company name for every vendor, and a unique vendor number if you use your own codes.
Contact details
EmailContact person, phone, fax, email and website, checked as they are typed.
Address
StringThe address in one free-text cell, as MRPeasy's simplest address column.
Currency & tax rate
StringThe vendor's default currency and tax rate.
Lead time
NumberDefault lead time in whole business days.
Payment terms
EnumPayment period in days, and 0 (from invoice date) or 10 (from end of invoice month).
Need more than three rows?
Collect every supplier's details.
The free template is limited to three rows so you can try the workflow. Create your own form to send to each buyer or supplier, and get vendor details back in one file instead of a different spreadsheet from every source.
Create your own formMRPeasy's field names
Company name, Vendor number, Default lead time in days and the rest, so MRPeasy maps the columns for you.
Checked as they type
Repeated company names and vendor numbers, email addresses, websites and payment period types are checked.
Your own fields
Add a certification expiry or a quality rating to your own form.
Up to 1,000 rows
Well inside MRPeasy's 3,000 lines per upload.
How it works
From the supplier list to MRPeasy in three steps.
01
Collect
Import a supplier list, or send the form to each buyer.
02
Complete
One vendor per row. Repeated names, bad emails and websites without https:// are highlighted.
03
Download and import
Download the CSV and import it in Procurement, Vendors, ticking that the first row is a heading, then check the column mapping.
Why use a form?
A repeated vendor number is silently skipped.
When a vendor number already exists, MRPeasy ignores that row instead of reporting an error, so a vendor can go missing without anyone noticing. A company typed two ways, in the items import, creates a second vendor.
A form flags repeated names and numbers as they are entered, so every supplier makes it in.
Vendor numbers that already exist
MRPeasy ignores the row. Each number is used once in your file and checked against MRPeasy.
Payment period type
Only 0 (from the invoice date) and 10 (from the end of the invoice month) are valid.
Lead times in the wrong form
Lead time is a whole number of business days, not "2 weeks".
MRPeasy vendors import template
How MRPeasy imports vendors
MRPeasy keeps your suppliers in Procurement, Vendors, and can import many at once from a CSV file. As with items, you match each column to a vendor field on screen instead of following a fixed template.
Only the company name is required. A vendor number is optional: if you give one and a vendor with that number already exists, the row is ignored when creating vendors. You can also supply a contact person, phone, fax, email, website, an address, notes, currency, tax rate, default lead time in business days and a payment period.
The payment period type is 0 to count the days from the invoice date or 10 to count from the end of the invoice month. MRPeasy takes up to 3,000 lines per upload and returns a skip file listing any rows it couldn't import. The manual recommends backing up your database first.
This template uses those field names and checks each column as it's filled in. It uses the single free-text address column, and leaves out the structured address columns and custom fields. To give an item its own vendor terms, use the MRPeasy items template.
Related Templates
Read MRPeasy import errors for every rule and its fix, or see Import Builder for manufacturing. Importing parts too? Use the MRPeasy items template.
Need a CSV form of your own?
Create a custom Import Builder form with your own fields, validation and row limits.
Get started