Dirt Face Logo

Import Components (CSV)

Import parts from a structured CSV or spreadsheet export into My Components.

Published · Updated · 5 min read

Open in app →

Overview

Import Components (CSV) adds parts from a spreadsheet when you already maintain a fixed export format with column headers for part number, description, and cost. You map each column to Dirt Face fields before the import runs.

Where in the app: Sidebar → Fence → My Components → Catalog tools → Import Components (CSV)
Open: Import Components (CSV)

Before you import

  • Export from your vendor or ERP with columns: name, part number, cost (minimum)
  • Optional columns: color, UOM, vendor, bundle qty, weight
  • Remove customer contact columns (email, phone). They are not needed for parts

Step 1: Open import

  1. Go to Fence → My Components. Open My Components
  2. Open Catalog tools → Import Components (CSV). Open Import Components (CSV)

Step 2: Upload and map columns

  1. Upload your .csv or .xlsx file
  2. Match each spreadsheet column to Dirt Face fields
  3. Preview a few rows before confirming

Step 3: Review and commit

  1. Resolve duplicate part numbers (skip, update, or create new)
  2. Assign section and category if the file does not include them
  3. Run the import and verify counts in My Components

Troubleshooting

IssueFix
Wrong costs on quotesRe-import with cost mapped to vendor price, not retail
DuplicatesNormalize part numbers (trim spaces, leading zeros) before import
Missing categoriesBulk-assign category after import from the catalog grid

Related