Which columns and values belong in a product cost estimate CSV?
Each row describes one estimate for an existing product, supplier or internal source, cost type, and quantity tier.
| Column | Requirement |
|---|---|
| SKU | Required; exact existing product SKU. |
| Supplier Handle | Existing supplier handle; blank for your own estimate. |
| Cost Type | Required; Standard (default) or Dropship (dropship). |
| Unit Cost | Required; greater than zero. |
| Quantity | Required; whole number of zero or more for Standard, exactly 1 for Dropship. |
| Materials Cost, Labor Cost, Packaging Cost | Optional nonnegative portions of Unit Cost. |
| Inbound Freight Cost, Duties & Tariffs Cost | Optional nonnegative additional costs per unit. |
| Lead Time | Optional whole number of days, zero or more. |
| Effective Date | Optional date; use YYYY-MM-DD. |
Enter costs without currency symbols. Estimated landed cost is Unit Cost + Inbound Freight Cost + Duties & Tariffs Cost. Review the materials, labor, and packaging breakdown against Unit Cost; those values are stored independently.
SKU,Supplier Handle,Cost Type,Unit Cost,Materials Cost,Labor Cost,Packaging Cost,Inbound Freight Cost,Duties & Tariffs Cost,Quantity,Lead Time,Effective Date
TEE-001,acme-manufacturing,default,7.50,5.50,1.50,0.50,0.50,0.25,100,30,2026-08-11
TEE-001,,dropship,9.50,,,,0,0,1,5,2026-08-11
The Standard estimate has an estimated landed cost of 8.25. The Dropship row is an internal estimate for one unit.
Keep SKU, Supplier Handle, Cost Type, and Quantity unchanged to update an estimate. Changing them identifies a different estimate. See matching, blank cells, and import results.