Export suppliers

Export the suppliers list to a spreadsheet whenever you need your supplier records outside SKU.io — for a bulk edit round-trip, an accountant, or a vendor review. The export is a fixed, full column set (it's not driven by which columns you have showing), and it doubles as a bulk-edit template you can import straight back in.

Before you begin

• You need the suppliers.export permission. Without it the Export button doesn't appear on the list.
• The export respects the current list view: your search, the Type filter (Product Supplier / Service Provider), and the archived scope. By default only active suppliers are exported — switch the list's archived toggle to All or Archived first if you need archived suppliers in the file.

Export the list

1. Go to the suppliers list.
2. Set up the view you want: apply any search, the Type filter, and the archived scope.
3. Click Export (top right). The file downloads as a CSV named suppliers-YYYY-MM-DD.csv.

Exporting never changes any data.

What the export contains

The export always writes the full supplier column set below, in this order — regardless of which columns you have visible on the list. Every supplier matching the current filters becomes one row.

Column	Re-importable?	Notes
ID	Yes	The supplier's database ID; re-imports as the id update key.
Name	Yes	The supplier name (also the natural match key).
Company Name	Yes
Email	Yes
Contact Name	Yes
Lead Time	Yes	Lead time in days. On re-import, map it to Lead Time (days).
Min Order Qty	Yes
Created At	No	Timestamp — export only.
Updated At	No	Timestamp — export only.
PO Email	Yes
Website	Yes
Minimum PO $	Yes	On re-import, map it to Minimum PO Amount.
Minimum PO Qty	No	Export only — there is no matching import column.
Fax	Yes
Address Line 1	Yes
Address Line 2	Yes
Address Line 3	No	Export only — the importer accepts lines 1 and 2.
City	Yes
State/Province	Yes	Re-imports to province.
State/Province Code	Yes	Re-imports to province_code.
Zip/Postal Code	Yes
Country	Yes
Country Code	Yes
Address Label	No	Export only.
Default Pricing Tier ID	No	Export only — the importer sets the tier by name, not ID (use the Default Pricing Tier column below).
Default Tax Rate	Yes	The tax-rate name (for example GST 10%). Round-trips into the importer's Default Tax Rate column.
Default Pricing Tier	Yes	The tier's display name (for example Supplier USD (USD)) — this carries the supplier's currency. Round-trips into the importer's Default Pricing Tier column.
Default Warehouse ID	No	Export only — the importer sets the warehouse by name.
Default Store ID	No	Export only — the importer sets the store by name.

A few fields are not in the export at all — Type, Timezone, Target Stock Days, Default Payment Term, and the name forms of Default Warehouse / Default Store. To set those on a re-import, add the corresponding columns to your file by hand (see the importable columns reference).

Bulk-edit tax rate and currency by round-trip

The round-trip below is the best way to set Default Tax Rate (for example GST) and currency across many suppliers at once — export the file, edit the two columns, and re-import it. Because a supplier's currency is carried by its pricing tier, currency lives in the Default Pricing Tier column — there is no separate currency column.

Just a few suppliers? Edit them in the list

You don't need a file for a handful of changes. Turn on the Default Tax Rate and Default Pricing Tier columns in the list's Column Selector, switch to grid view, and pick a value from the dropdown in each cell (clear to — to unset). See The suppliers list: columns.

1. Export your suppliers with this page. The file already includes a Default Tax Rate column (tax-rate name) and a Default Pricing Tier column (values like Supplier USD (USD)).
2. Edit those two columns — set the tax rate name and the pricing tier for each supplier. Leave the rest untouched.
3. Re-import the file (Import suppliers). On the Map Columns step, map Default Tax Rate and Default Pricing Tier, then validate and import.

The export and import use the same column labels for these two fields, and the importer accepts the tier's display-name form, so the values round-trip without reformatting. Match rows back to their suppliers by keeping the ID (or Name) column in the file.

Keep numbers intact

Spreadsheet apps can rewrite long numeric values (phone/fax, postal codes) into scientific notation or drop leading zeros. If you plan to re-import, keep the file as CSV or format those columns as Text before editing.

Next steps

• Import suppliers from a spreadsheet — bring the edited file back in.
• Importable supplier columns reference — every column the importer accepts and its validation.
• The suppliers list: columns — shape the view (search, type, archived) before you export.

Video transcript

Need your suppliers as a spreadsheet? Click Export. The file includes contacts, terms, and purchasing defaults. Edit it and re-import — names and IDs match back, so suppliers update instead of duplicating.