Import suppliers
How to load your supplier list from a CSV file - download the template, validate, and confirm the import.
Import suppliers
If you are migrating to Mosce ERP from another system or receive a list of suppliers from your purchasing department, the Import button lets you load all the records in a single step instead of creating them one by one. Mosce ERP validates the file before saving anything, so you can fix errors with no consequences.
Before you start
- You need the
suppliers:bulk-importpermission. If the Import button does not appear in the toolbar of the suppliers list, ask whoever administers the account to assign it to you. - The file must be in CSV format (comma-separated values), encoded in UTF-8.
- There is a limit on rows per file and files per month depending on your plan (see "Limits" below).
Step 1 - Download the template
On the Suppliers page, click the Import button in the toolbar. On the first screen of the wizard, download the template with the Download CSV template button.
The template includes two example rows and all the headers that Mosce ERP expects. The columns are:
| Column | Required | Description |
|---|---|---|
name | Yes | Name or legal name of the supplier. |
taxId | No | RNC of the supplier. Primary key for duplicate lookup - always recommended to include it. |
email | No | Main email address of the supplier. |
phone | No | Main phone. |
address | No | Physical address. |
contactPerson | No | Name of the contact person within the supplier. |
contactPhone | No | Direct phone of the contact. |
paymentTerms | No | Payment term days (whole number, for example 30 for 30 net days). |
withholdingRate | No | Withholding percentage applicable to payments to this supplier (whole number, for example 5). Defaults to 0. |
isActive | No | true for active, false for inactive. Defaults to true. |
Important: the column names must be exactly as they appear in the template. Do not translate or rename them.
Step 2 - Validate your file
With your file ready, drag it into the window or select it with the file explorer. Mosce ERP reviews it without saving anything yet.
If everything is correct, you will see a preview of the first rows and the Continue button becomes enabled.
If there are errors, a table appears with the row number, the problematic field, and the reason. You can download the full report with the Download errores.csv button, fix the file, and upload it again.
Step 3 - Confirm the import
Before loading the data, choose a mode:
- Create new records only - if a row has the same RNC as a supplier that already exists, it is discarded without error. Useful for initial loads.
- Create new and update existing - if a row has the same RNC as an existing supplier, its data is updated. If there is no match, a new supplier is created.
Click Import to begin. When it finishes, you will see a summary with the number of suppliers created and the number of suppliers updated.
If your file is very large, Mosce ERP processes it in the background and notifies you when it finishes. You can close the wizard and keep working normally.
How does Mosce ERP identify duplicate suppliers?
Mosce ERP compares each row of your CSV with your account's existing suppliers using the RNC (taxId). If the RNC matches an existing supplier, it is considered the same supplier. If the row does not include an RNC or there is no match, the record is created as new (Create new and update existing mode) or discarded (Create new records only mode).
Limits
| Plan | Rows per file | Files per month |
|---|---|---|
| Free | 1 000 | 3 |
| Starter | 10 000 | 20 |
| Professional | 100 000 | unlimited |
| Enterprise | unlimited | unlimited |
The files-per-month counters reset on the first day of each month.
Frequently asked questions
What if Excel saves my CSV with semicolons instead of commas? Mosce ERP only accepts commas as the delimiter. When saving from Excel, choose CSV (comma delimited) or CSV UTF-8 (comma delimited).
What about accents and the letter ñ? Make sure to save the file in UTF-8 encoding. If special characters look wrong after importing, save the CSV as UTF-8 and try again.
Are the expenses associated with a supplier migrated automatically when importing? No. The supplier import only creates or updates the supplier record. Expenses and supplier invoices are recorded or imported separately.
Can I import suppliers more than once?
Yes. If you use the Create new and update existing mode, later imports update the data using the RNC as the identification key. If a supplier has no RNC, each import will create it as a new record.
Can I import columns that are not in the template? No. Mosce ERP only reads the columns from the template. Any extra column is ignored without causing an error.
Related
Last updated: 2026-05-11