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: catherine@example.com
  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

ClosedAccepted 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

ClosedAccepted 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