Column Mapping Basics
Map supplier file columns to Pricelist Heaven fields.
Available Fields
Required
- Product Code or EAN or Product Name (at least one)
- Price
Optional
- Purchase Price, Retail Price
- Description
- Product Category
- Tax Code
- Unit of Measure
- Minimum Quantity
- Barcode/EAN
- Lead Time
- Weight
Calculated
- Calculated Purchase Price (with VAT conversion)
- Calculated Sales Price
- Calculated Min Quantity
Mapping Process
- Review detected columns
- Select Pricelist Heaven field for each column
- Mark unused columns as "Skip"
- Verify required fields are mapped
- Save as template (optional)
Auto-Detection
Pricelist Heaven attempts to auto-detect common column names:
- "Prijs" → Price
- "Code" → Product Code
- "EAN" → Barcode
Always verify auto-detected mappings.