Before You Begin
Before starting your upload, ensure your file meets these requirements:- File Format: Your vendor list must be saved as a .CSV file.
- Scope: This tool creates or updates vendor records (name, code, billing info, notes) and, optionally, one contact per vendor.
Prepare Your Upload File
Download the vendor upload template to get started, or build your own file with the following columns:| Field Name | Requirement | Notes |
|---|---|---|
| Vendor Name | Required | The display name for the vendor. |
| Vendor Code | Optional | Your internal code for the vendor. |
| Billing Name | Optional | The name on the vendor’s invoices. |
| Billing Address | Optional | The vendor’s full billing address. |
| Min Order Value | Optional | The minimum dollar amount required to place an order. |
| Tax ID | Optional | The vendor’s tax identification number. |
| Notes | Optional | Any internal notes about the vendor. |
| Contact Name | Optional | Defaults to the vendor name if left blank. |
| Contact Email | Optional | The contact’s email address. |
| Contact Phone | Optional | The contact’s phone number. |
| Is Ordering Contact | Optional | Enter Yes if this contact should receive purchase order emails. Defaults to No. |
| Vendor Vori ID | Optional | Vori’s internal vendor ID. Include this to match and update an existing vendor. |
app.vori.com/retail/vendors/29201/settings).
Upload and Map Your Data
Once your file is ready, upload it directly from the Vendors page.- Navigate to Inventory & Supply Chain on the left-hand menu in Back Office and select Vendors.
- Click Upload Vendors in the top right corner.
- Drag and drop your CSV file into the upload area, or click Select File to browse your computer.
- Map your columns: Vori attempts to auto-match your file headers to the fields above. Confirm each column is mapped correctly, then click Next.
Review and Commit Changes
The review step shows you exactly what will change before anything saves.- Valid Rows and Invalid Rows: Vori checks each row for missing or malformed data. Only valid rows move forward.
- New Vendors: Vendors with no match in your file will be created here, along with any contact you included.
- Matched Vendors to Update: Vendors are matched by Vendor Vori ID or an exact Vendor Name match, in that order. Matched vendors are updated with the non-empty values from your file. Contacts are matched by email, phone, or name within that vendor. If no contact matches, Vori creates a new one.
Troubleshooting
Why is my row marked as “Invalid”?- Missing Vendor Name: Every row requires a Vendor Name. Vori skips rows without one.
- Malformed Contact Info: Contact Email must be a valid email address, and Contact Phone must contain only digits, spaces, dashes, or parentheses.
- Vori only matches existing vendors by Vendor Vori ID or an exact Vendor Name match. A close but non-exact name (e.g., “Acme Bread Co.” vs. “Acme Bread Company”) creates a new vendor instead of updating the existing one. Include the Vendor Vori ID to match reliably, or merge duplicates afterward using the Merging Duplicate Vendors and Products guide.