Turn Supplier Files Into Usable Cost Data
Upload supplier price lists, review the extracted information, confirm how each column should be mapped, and convert messy purchasing data into organized Material and Packaging records.
Supports CSV, XLS, XLSX, and PDF files.
Supplier data rarely arrives ready to use
Supplier files may use different column names, pack descriptions, units, item numbers, and layouts. Entering everything manually takes time and increases the chance of errors.
Inconsistent Columns
Different suppliers use different labels for item name, SKU, pack, price, and unit.
Complicated Pack Descriptions
Values such as 6/24/OZ or 4/2.5/KG must be interpreted correctly.
Mixed Measurement Units
Supplier files may combine pounds, ounces, kilograms, liters, gallons, counts, and cases.
Repeated Manual Entry
Re-entering every supplier update makes cost maintenance slow and unreliable.
Review first, import with confidence
CostFoundry uses a guided import process so users can see the extracted information, review suggested mappings, confirm pack details, and approve records before they are added to the workspace.
Smart Import assists the process without hiding the source data or removing user control. Files are not interpreted perfectly without review — you confirm every mapping and record.
How Smart Import works
Upload the Supplier File
Upload a supported spreadsheet or PDF.
Review Extracted Rows
See the source columns and sample data before mapping.
Confirm Field Mappings
Map supplier columns to CostFoundry fields such as Material Name, Supplier Item Number, Pack Size, and Purchase Price.
Interpret Packs and Units
Review how case packs, quantities, weights, and units have been parsed.
Resolve Warnings
Review duplicates, missing information, invalid units, or uncertain mappings.
Preview and Import
Approve the final records and add them to the Material or Packaging database.
Upload the Supplier File
Upload a supported spreadsheet or PDF.
Review Extracted Rows
See the source columns and sample data before mapping.
Confirm Field Mappings
Map supplier columns to CostFoundry fields such as Material Name, Supplier Item Number, Pack Size, and Purchase Price.
Interpret Packs and Units
Review how case packs, quantities, weights, and units have been parsed.
Resolve Warnings
Review duplicates, missing information, invalid units, or uncertain mappings.
Preview and Import
Approve the final records and add them to the Material or Packaging database.
Built for real supplier files
Multi-Format Uploads
Support CSV, XLS, XLSX, and PDF supplier files.
User-Reviewed Mapping
Confirm where names, prices, SKUs, brands, pack sizes, and units belong.
Pack Parsing
Interpret common supplier pack formats into structured data.
- 6/24/OZ
- 4/2.5/KG
- 20/1/CN
- 6/10CN
Unit Normalization
Normalize supplier abbreviations into supported CostFoundry units.
- LBAV or LBA → LB
- PK → EA
- GL → GAL
- Z → OZ
Import Preview
Review the records that will be created before completing the import.
Saved Supplier Layouts
Reuse approved mappings for future files from the same supplier.
Duplicate Detection
Flag likely duplicate Materials or Packaging records for review.
Error and Warning Review
Identify missing prices, invalid packs, uncertain units, and other issues.
Materials and Packaging
Import into either the Material database or the Packaging database.
From supplier spreadsheet to Material database
A typical supplier file might include rows like the ones below. Smart Import parses each pack description and calculates cost per unit for your review.
Resin Pellets
Pack: 4/5/LB — $86.00
- Pack Number
- 4
- Pack Weight
- 5
- Unit
- LB
- Case Size
- 20 LB
- Cost per LB
- $4.30
Shipping Box
Pack: 25/1/EA — $42.50
- Pack Number
- 25
- Unit
- EA
- Case Size
- 25 EA
- Cost per EA
- $1.70
Metal Fastener
Pack: 10/100/EA — $135.00
- Pack Number
- 10
- Pack Quantity
- 100
- Unit
- EA
- Case Size
- 1,000 EA
- Cost per EA
- $0.14
Cost per unit is calculated from Purchase Price and Case Size. You confirm the parsed values before the records are saved.
See every step before saving
Drag and drop or browse for a supplier file. Supported formats are displayed clearly.
Drop supplier file here or click to browse
CSV, XLS, XLSX, or PDF — up to 25MB
Spend less time rebuilding supplier data
Reduce repeated manual entry
Create more consistent Material records
Catch import issues before saving
Reuse supplier mappings
Update costs more efficiently
Build a stronger foundation for Recipes, Builds, and Products
Continue the workflow
Materials and Packaging
Centralize supplier details, pack information, units, and cost calculations.
Learn MoreFlexible Cost Analysis
Build complete cost models using Materials, Packaging, labor, and custom categories.
Learn MorePrice Change Tracking
Track Material price changes and see which Recipes, Builds, and Products are affected.
Learn MoreWorkspace Health
Identify missing prices, incomplete records, and data-quality issues.
Learn MoreLearning Center
Learn CostFoundry with step-by-step guides and Quick Access links.
Learn MoreSmart Import FAQ
Smart Import supports CSV, XLS, XLSX, and PDF files. Each format is processed through the same review workflow so you can confirm mappings and pack details before importing.
Learn how to use this feature
Step-by-step instructions, examples, and troubleshooting tips in the CostFoundry Learning Center.