VedronERP · Import & Export
Importing Customers
Import customers in bulk from CSV or Excel files with column mapping.
Import Process
- Go to the Import/Export page and open the "Import Customers" tab.
- "Step 1: Upload File": drop your CSV or Excel file (CSV, XLSX or XLS) onto the page or click to browse.
- "Step 2: Map Columns": match each column of your file to an ERP field. Green fields were matched automatically, orange fields are required and still need a column, and optional fields can be skipped.
- Check the preview of the first rows.
- Under Import Options, tick "Skip existing records (duplicate detection)" to avoid duplicates and, if wanted, choose a "Default Company".
- Click the import button, which shows how many rows will be imported. "Import Results" lists what was "Imported", "Skipped" and "Errors", with logs you can open.
Column Mapping
The import wizard lets you map each column in your file to the corresponding ERP field. Required fields include customer name and at least one address field. Optional fields include email, phone, tax ID, etc.
Tip: Prepare your import file with clean, consistent data before uploading. Check for duplicate entries and ensure addresses are complete.