Skip to main content

Which supplier details can I export, and can I import the file back?

The supplier export gives you one CSV row per supplier, including its default contact and ship-from address. If no contact is the default, it uses the oldest contact. Missing contact or address values stay blank.

GroupColumns
IdentityName, Handle, Status, Category, Tax ID
Company contactEmail, Phone, Website, Location
PerformanceLead Time, Quality Rating, On Time Delivery, Response Time
TermsIncoterms, Payment Terms, Shipping Terms
OperationsBusiness Hours, Time Zone, Year Established
ContactContact Name, Contact Title, Contact Email, Contact Phone
AddressAddress 1, Address 2, City, State, Postal Code, Country
OtherNotes

Use Status and Category to group suppliers, contact details for supplier directories, and terms and performance columns for purchasing reviews.

The supplier import accepts a smaller set of fields: Name, Email, Phone, Website, Notes, Contact Name, Contact Email, and Contact Phone. Keep those columns when preparing an export for import; edit addresses, terms, and performance details on the supplier.

Name,Email,Phone,Website,Contact Name,Contact Email,Contact Phone
Acme Manufacturing,accounts@example.com,,https://example.com,Sam Lee,sam@example.com,

Name matches an existing supplier exactly. Contacts are added only when that supplier has none, and Notes are saved only when creating a supplier. See supplier matching and import results.