Overview
Import Vendor Costs (CSV) uploads a price sheet from your distributor and updates costs on parts that already exist in My Components. Each row is matched to a catalog component by reference numbers (part number, SKU, system number, and similar fields), then the cost for that vendor is refreshed.
This tool does not add new parts to your catalog. Rows that do not match an existing component are skipped. Use Import Components (CSV) or Smart Import Tool when you need to bring in new parts first.
This tool is available to account owners.
Where in the app: Sidebar → Fence → My Components → Catalog tools → Vendor costs & updates → Import vendor costs (CSV)
Open: My Components (then Catalog tools)
When to use this tool
Use Import Vendor Costs (CSV) when a supplier sends an updated price list with exact dollar amounts and your catalog already has the matching parts with reference numbers filled in.
Skip it when you only need a blanket percentage change across many parts. Use Cost Update Wizard instead. See Related.
Prepare your spreadsheet
Your file can be CSV or Excel (.xlsx). For Excel, only the first sheet is read.
Required columns
| Field | Notes |
|---|---|
| Cost | Unit cost or price. Currency symbols and commas are cleaned on import. |
| At least one reference column | Map one or more of: System Number, Part Number, Vendor Part Number, Manufacturer Part Number, SKU. Values must match components already in your catalog. |
Reference matching uses this order: System Number, then Part Number, then Vendor Part Number, then Manufacturer Part Number, then SKU.
Optional columns
| Field | Notes |
|---|---|
| Vendor Name | If your file has no vendor column, you choose one vendor for all rows in a later step. |
| Quantity Per Package | Pack size for ordering |
| Lead Time (Days) | Expected delivery time |
| Minimum Order Quantity | MOQ from the supplier |
| Set as Default Vendor | Yes/true/1 marks this vendor as default on matched parts |
Column headers do not need to match Dirt Face labels exactly. On the mapping step you connect your columns to the system fields. Use Download Template on the upload screen to see suggested column names.
Step 1: Open Import Vendor Costs
- Go to Fence → My Components. Open My Components
- Click Catalog tools on the toolbar.
- Open Vendor costs & updates, then choose Import vendor costs (CSV).
Step 2: Upload your file
- Click Choose CSV / XLSX file and select your price sheet.
- Optionally click Download Template if you are building a file from scratch.
- Expand the help section on the upload screen for a quick checklist of required fields.
After the file loads, the wizard moves to column mapping.
Step 3: Map columns
- Review the auto-detected mappings. Adjust any column that landed on the wrong system field.
- Confirm Cost is mapped (required).
- Confirm at least one reference column is mapped (System Number, Part Number, Vendor Part Number, Manufacturer Part Number, or SKU).
- Map Vendor Name if your file includes it. Leave it unmapped when the whole file is from one supplier.
- Map optional fields (quantity per package, lead time, MOQ, default vendor) when your sheet includes them.
- Click Continue.
Step 4: Resolve vendors (when needed)
Depending on your file, one of these screens may appear:
No vendor column mapped: Select the vendor whose costs will be updated for every row in the file.
Vendor names not in your account: For each unknown name, choose Create new vendor with this name or Use existing vendor and pick a match from your vendor list.
If all vendor names already exist in your account, this step is skipped.
Step 5: Apply now or schedule
- Review the summary (file name, row count, and vendor source).
- Choose Apply Now to process every row immediately, or Schedule for Later to pick a future date and time (useful when a supplier announces a price change that takes effect on a specific day).
- Click Apply Now or Schedule Update.
Scheduled updates run automatically at the chosen time. You can track them in Vendor Cost Import History. Open Vendor cost import history
Step 6: Review results
While the import runs, a progress bar and row-by-row log show what happened on each line.
| Status | Meaning |
|---|---|
| Updated | Component matched and vendor cost saved |
| Skipped | No matching component, missing required fields, or vendor could not be resolved |
| Error | Row failed during processing |
When the run finishes, review the summary counts (total, updated, skipped, errors). Fix reference numbers in My Components for skipped rows and re-import if needed.
Tip: Match on the same reference field you maintain in My Components. If your price sheet uses distributor SKUs, map SKU and make sure those SKUs are filled in on your catalog parts.
Warning: Import updates vendor costs in My Components. Future quotes that use those parts pick up the new pricing. Double-check the mapping and a sample of updated costs before sending customer proposals.