Import suppliers

With Fairmarkit, you will invite suppliers to respond to your events in Fairmarkit. In addition to the suppliers in the Fairmarkit database, you can sync your list of registered suppliers and contacts to Fairmarkit from your purchasing application.

Supplier data

The following table outlines the column headers you will need to create when you import your suppliers into Fairmarkit. The *required fields are marked, and the remaining fields are optional but recommended. All fields are used to improve your supplier recommendations on events.

Template: Make sure you have the latest version of the flat file template (view | download CSV file).

Fairmarkit field	Header	Description
*	Supplier ID	supplier_id	Supplier ID in your purchasing application. Data type: Text Example: S1000
*	Supplier Title	supplier_title	Name or title of the supplier. Data type: Text Example: Catherine's Coffee Shop
*	Supplier Email	supplier_email	Supplier's email. Fairmarkit does not validate the email. Data type: Text Example: [email protected]
	Address1	supplier_address1	Supplier's address - line 1. Data type: Text Example: 1234 Main St
	Address2	supplier_address2	Supplier's address - line 2. Data type: Text Example: Floor 2
	City	supplier_city	Supplier's city Data type: Text Example: Boston
	State	supplier_state	Supplier's state. Data type: Text Example: MA
	Zip	supplier_zip	Supplier's zipcode. Data type: Text Example: 02445
*	Country	supplier_country	Supplier's country. This value can be a country name, Alpha-2, Alpha-3. Data type: Text Example: US
	Contact First Name	supplier_first_name	Supplier contact's first name. Data type: Text Example: Catherine
	Contact Last Name	supplier_last_name	Supplier contact's last name. Data type: Text Example: Jones
	Phone Number	supplier_phone_number	Supplier contact's phone number. Data type: Text Example: 617-123-4567
	Fax Number	supplier_fax_number	Supplier contact's fax number. Data type: Text Example: 617-123-7654
	Is Active	supplier_is_active	Is the supplier active? This value is not case sensitive. Default value: True Data type: Text Example value: TRUE Accepted values:y,yes,t,true,on,1,n,no,f,false,off,0
	Originating ERP System	supplier_erp_system	The purchasing application associated with the supplier. Data type: Text Example: SAP Ariba
	Supplier Tag XXX	supplier_tag_XXX	Supplier tag. Replace XXX with your value. For example, add plant for supplier_tag_plant. You can add as many supplier tags as needed. Data type: Text Example: P663
	Supplier Meta Tag XXX	supplier_meta_tag_XXX	Supplier meta tag. Replace XXX with your value. For example, add account for supplier_meta_tag_account. You can add as many supplier meta tags as needed. Data type: Text Example: preferred
	Supplier Category XXX	supplier_category_XXX	Supplier category. Replace XXX with your value. The value does not have to related to a category. For example, supplier_category_1, supplier_category_2. Data type: Text Example: Coffee
	Supplier Business Classification XXX	supplier_business_ classification_XXX	Supplier business classification. Replace XXX with your value. The value does not have to be related to a business calculation. For example, supplier_business_classification_1, supplier_business_classification_2. Data type: Text Example: sdvet Accepted values: 8a Alaskan bcorp Dbe Dobe Edwosb Fairtrade Fsc Gsa Hbcu International_soc_automation Iso_9001 Lbe Lgbt Minority_business_enterprise Msc Sdb Sdvbe Sdvet small_business_certification small_business_enterprise Veteran_business_enterprise Woman_owned_business_enterprise Wosb
	Additional Information	additional_info_XXX	Space for additional information. Data type: Text Example: Boston