Skip to main content
Resources & navigation
Products & admin

Manage suppliers and vendor item mappings

Last updated 2026-08-063 min read

Create suppliers, map vendor SKUs to inventory items, and safely preview recurring price-list imports.

On this page

A supplier record identifies who you buy from. A vendor item mapping connects that supplier's SKU and pack details to one Ellich inventory item. Create both before importing a price list or using supplier documents; adding a supplier alone does not create stock, a purchase order, or an inventory item.

Create or update a supplier

  1. Open Suppliers (Vendors) and select Add supplier.
  2. Enter Name and, when available, the code, contact, phone, email, lead time, and minimum order amount.
  3. Select Save, then confirm the supplier appears under Active suppliers.
  4. Use Edit when contact or purchasing terms change.

Archiving removes the supplier from active selection lists. Existing vendor item master rows remain until you archive those mappings separately.

Map the supplier's items

  1. Open Vendor Item Master and choose the supplier.
  2. Select Add mapping.
  3. Enter Vendor SKU, Vendor Item Name, UOM, pack size, unit cost, and currency.
  4. Enter the Inventory Item ID when this supplier item should resolve to an existing inventory item.
  5. Select Save Mapping, then verify the row in the active mapping table.

The Inventory Item ID is the Ellich inventory-item UUID, not the vendor SKU. A missing or incorrect link can leave an uploaded document line unmatched and prevent it from posting to inventory.

Import a vendor price list safely

Download the sample template, prepare a CSV, XLSX, or XLS file, and use Preview Upload before Upload Bulk. Review detected columns, preflight issues, suggested mappings, warnings, and every low-confidence field. Auto-map by name and Apply Suggestions (>= 0.86) are suggestions, not proof that the source column is correct. Approve ambiguous fields explicitly and confirm currency, quantity, amount, pack size, and vendor SKU before upload.

Use Vendor format profile to save the supplier's recurring column and number-format conventions. Use Save Location Policy only after checking the location confidence threshold. After upload, inspect Processed, Skipped, Auto-mapped, and error counts rather than treating file acceptance as a complete import.

Verify and correct the result

Search the active mapping table for representative SKUs and compare item name, UOM, pack size, unit cost, currency, and Inventory Item ID with the source file. Edit an incorrect mapping before processing invoices. Archive a mapping only when it should no longer be offered as an active supplier-item match; archiving does not reverse inventory movements or delete historical documents.