Which columns can I use for product details, prices, and default costs?

Use Name and SKU on every product row, then add the columns for the details you want to change. Map the headings in the importer before starting.

Columns	Values
Name, SKU	Product name and exact SKU; Name is 2–200 characters.
UPC, Part Number	UPC is 12 or 13 digits; preserve leading zeros by formatting codes as text.
Brand	Existing brand handle.
Description, UOM	Description and unit of measure.
Product Type	Finished Good, Bundle, Alias, Part, or Non-Inventory; Kit and Component are also accepted.
Composition Type, Sourcing Method	Choose the mapped importer options.
Archived, Shippable	true or false. Shippable controls whether the product can ship.
Image, Tags	Comma-separated URLs or tags; quote cells containing commas.
MSRP, MAP	Prices without currency symbols.
Default Unit Cost	Default goods cost used when purchasing.
Default Landed Cost	Default cost including inbound charges.
Default Dropship Unit Cost	Default cost for supplier-direct fulfillment.
Restock Threshold	Restocking quantity threshold.
Packaging URL, Specs URL	Documentation links.
custom.	Value for an existing product attribute, such as custom.color.

Name,SKU,MSRP,Default Unit Cost,Default Landed Cost,Default Dropship Unit Cost,custom.color
Classic Tee,TEE-001,29.99,8.00,10.00,9.50,Red

For a minimal file, keep just Name and SKU. Most blank cells keep existing values. A blank default-cost cell clears that cost when its column is included. Omit the cost column to keep it unchanged.

A filled Image cell replaces images; Tags adds tags. Remove Image before reimporting an export if you want to keep every image.

See dimensions and packaging columns and component fulfillment settings.