Importing Raw Materials
A step-by-step guide to importing raw materials with supplier part numbers and costs.
Step-by-step guide
Set up your suppliers
Go to the Suppliers page and add each vendor you purchase raw materials from. Include the company name, contact info, and address. This step comes first because the CSV importer matches supplier names to existing supplier records.
Supplier names in your CSV must match the company name in your supplier records exactly. Double-check spelling and capitalization.
Prepare your CSV
Build a spreadsheet with one row per raw material. The two required columns are SKU and Name. Set the Type column to RAW_MATERIAL for each row. Add supplier details (Supplier, Supplier Part Number, Supplier Cost) to automatically create the supplier-to-SKU mappings on import.
| Column | Required | Description |
|---|---|---|
SKU | Yes | Your internal SKU code |
Name | Yes | Product name |
Type | Optional | Set to RAW_MATERIAL |
Supplier | Optional | Must match an existing supplier’s company name exactly |
Supplier Part Number | Optional | The supplier’s catalog or part number |
Supplier Cost | Optional | What the supplier charges per unit |
Description | Optional | Optional product description |
MPN | Optional | Manufacturer part number |
UPC | Optional | Universal product code / barcode |
Reorder Point | Optional | Minimum stock level before reordering |
Reorder Qty | Optional | Default quantity to reorder |
Standard Cost | Optional | Your standard unit cost for this SKU |
Download the template
Not sure about the column format? Go to the SKUs page → Import → Download Template to get a pre-formatted CSV with all supported columns. Fill it in and save as CSV.
Import on the SKUs page
Go to SKUs → Import → upload your CSV file. The importer creates each SKU as a raw material, matches supplier names to your existing supplier records, and creates the supplier part number and cost mappings automatically.
Verify your data
Open a few SKU detail pages and confirm that the supplier part numbers and supplier-specific costs appear correctly. Check the Suppliers page to verify that each supplier shows the linked SKUs.
What if a supplier name doesn’t match?
If a supplier name in your CSV doesn’t match an existing supplier record, the SKU still imports successfully — only the supplier mapping is skipped. You’ll see an error message in the import results noting which rows had unmatched suppliers. You can add the missing supplier and re-import, or manually link the SKU from the supplier detail page.
Ready to import? Head to the SKUs page to get started.