Export requests for quote

*

At different stages of your request for quote events, you can use generic flat files to export event data from Fairmarkit to your purchasing application. Fairmarkit currently supports export for events in Closed, Awarded, Canceled, and Archived status.

Requests for quote data

The following table outlines the column headers you will need to create when you export your request for quote events out of Fairmarkit. The *required fields are marked.

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

Note: This template is on the line level. Group items are at the group item level.

Fairmarkit field	Header	Description
*	Requisition ID	requisition_id	Purchase requisition ID from your purchasing application Data type: Text Example: R1000
	Requisition Title	requisition_title	Purchase requisition title. This title will display in Fairmarkit and defaults to the first line item title. Data type: Text Example: Req for FMKT
*	Fairmarkit RFQ ID	fairmarkit_rfq_id	Fairmarkit request for quote event ID. Data type: Text Example: 41298
	Line Number	line_number	Line number or order of the line item. Data type: Text Example: 1
*	Item Title	item_title	Item name. Data type: Text Example: coffee beans
	Item Identifier	item_identifier	Unique identifier for the line item in your purchasing application, if it exists. Data type: Text Example: G123 Note: This data is preserved when imported into Fairmarkit.
	Buyer Email	buyer_email	Buyer's email. Fairmarkit does not validate the email. This value is used to assign request for quote events in Fairmarkit. Data type: Text Example: [email protected]
*	Status	status	Fairmarkit request for quote event status. Fairmarkit automatically sets the status. Typically, the event will be in Awarded, Canceled, or Archived statues, but other end statues can be supported. Data type: Text Example: Awarded
	Status Date	status_date	Date that Fairmarkit automatically set the status. It may display as "Archived on status_date". Data type: Text Example: 2022-07-14
	Status Note	status_note	Status note. These are useful when comments on a line item are important for your purchasing application. For example, “Item awarded to XX at YY.” Data type: Text Example: Awarded to Catherine's Coffee Shop
	Price (Per Unit)	price_per_unit	Price per unit. This value is generated in your company currency based on the quoted price per unit (if awarded). Data type: Text Example: 8.00
	Currency	currency	Event currency when awarding. This should be the three letter currency code. Data type: Text Example: MXN
	Quantity	quantity	Awarded item quantity. This is assumed to be an integer. Data type: Text Example: 1
	UOM	uom	Unit of measure of awarded item. Default: Each Data type: Text Example: Each Accepted values: Fairmarkit defined values; For more information, see Available UOMs. Note: Custom mapping is available. For more information, contact your technical architect. Note: This may be different than the quote_uom.
	Supplier ID	supplier_id	Supplier ID. This should match the Supplier ID provided in your Supplier syncs where applicable. For more information, see Import suppliers. 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]
	Fairmarkit Supplier ID	fairmarkit_supplier_id	Fairmarkit Supplier ID. Data type: Text Example: 23908
	Quote Id	quote_id	Fairmarkit Quote ID. This value is entered by the supplier. Data type: Text Example: Q123
	Quote Price (Per Unit)	quote_price_per_unit	Quoted price per unit. This value is in the Quote Currency and based on the Quote UOM. Data type: Text Example: 160.00
	Quote Currency	quote_currency	Quote currency. This should be the three letter currency code. Data type: Text Example: MXN
	Quote Quantity	quote_quantity	Quote item quantity. This is assumed to be an integer. Data type: Text Example: 1
	Quote UOM	quote_uom	Unit of measure of the item. Data type: Text Example: Each Accepted values: Fairmarkit defined values; For more information, see Available UOMs. Note: Custom mapping is available. For more information, contact your technical architect.
	Quote Valid For	quote_valid_for	Number of days before the quote expires. Data type: Text Example: 30
	Quote Delivery Days	quote_delivery_days	Number of days to deliver the line item. This should be used to calculate the actual delivery date. Data type: Text Example: 5
	Quote SKU	quote_sku	Item SKU. This value is entered by the supplier. Data type: Text Example: S12094
	Quote Country of Origin	quote_country_of_origin	Line item's country of origin. This value is entered by the supplier. Data type: Text Example: MX
	Quote Minimum Order Quantity	quote_minimum_order_quantity	Minimum order quantity (integer) for the quote. The supplier enters this value. This value is sent for accounting purposes. Data type: Text Example: 1
	Quote Line Comment	quote_line_comment	Line item comment. This value is entered by the supplier. This value correlates with the user interface. Data type: Text Example: Will leave on doorstep
	Quote Notes About Bid	quote_notes_about_bid	Notes about the quote. This value is entered by the supplier. This value correlates with the user interface. Data type: Text Example: This is the best coffee in town
	Benchmark Supplier ID	benchmark_supplier_id	Benchmark supplier ID. Data type: Text Example: S1002
	Benchmark Supplier Title	benchmark_supplier_title	Benchmark supplier name. This can be a name, title, entity, or description. Data type: Text Example: Charlie's Convenience Store
	Benchmark Price (Per Unit)	benchmark_price_per_unit	Benchmark price per unit. This is internal to your company. Presumably in your currency and UOM for the item. Data type: Text Example: 10.00
	Internal Part Number	internal_part_number	Your organization's part number for the item. This value is entered at your discretion. Data type: Text Example: IPN100
	Manufacturer	manufacturer	Manufacturer of the line item. Data type: Text Example: Local Co
	Manufacturer Part Number	manufacturer_part_number	Manufacturer part number of the line item. Data type: Text Example: 900
	UNSPSC	unspsc	Standard 8 digit UNSPSC code for the item or requested service. Data type: Text Example: 50201706
	Start Date	start_date	Start date for the line item. Typically used for services, leases, and software subscriptions and licenses. Data type: Text Example: 2022-07-20
	End Date	end_date	End date for the line item. Typically used for services, leases, and software subscriptions and licenses. Data type: Text Example: 2022-07-27
	Buyer Line Comment	buyer_line_comment	Line item comments from you (buyer) to the suppliers. Data type: Text Example: We'll need your best coffee
	Item Kind	item_kind	Line item type. For more information, see 3. Add items or services. Default: Item Data type: Text Example: Item Accepted values
	Group Item Title	group_item_title	When Item Kind is Group, the name of the group. Data type: Text Example: Coffee Supplies
	Requester	requester	Requester name. This value can also be an entity. This value is entered at your discretion. Data type: Text Example: John Smith
	Preferred Delivery Date	preferred_delivery_date	The date when the line items are needed. This date is the preference used when defining shipping time lines and scheduling services. Data type: Text Example: 2022-07-20
	Shipping Type	shipping_type	Preferred shipping method. This value is selected from a list and does not default. Data type: Text Example: Ground
	Shipping Carrier	shipping_carrier	Preferred shipping carrier. This value is selected from a list and does not default. Data type: Text Example: USPS
	Address1	shipping_address_address1	Shipping address - first line. Data type: Text Example: 27 School St
	Address2	shipping_address_address2	Shipping address - second line. Data type: Text Example: STE 400
	City	shipping_address_city	Shipping address city. Data type: Text Example: Boston
	State	shipping_address_state	Shipping address state. Data type: Text Example: MA
	Zip	shipping_address_zip	Shipping address zip code. Data type: Text Example: 02108
	Country	shipping_address_country	Shipping address country. Data type: Text Example: US
	Internal Notes	internal_notes	Notes about the event. This is internal to your company. Multiple notes are concatenated into a long string. This correlates to the Internal Notes in the Fairmarkit user interface. Data type: Text Example: Get medium roast
	Note to Supplier	note_to_supplier	Add additional information and communication about the event with all invited suppliers. This correlates to the Notes to Suppliers in the Fairmarkit user interface. Data type: Text Example: Please leave on doorstep
	ERP System	erp_system	Your purchasing application. When entered, it will override the system level settings. Data type: Text Example: SAP Ariba
	Additional Information	additional_info_XXX	Space for additional information. Data type: Text Example: Boston

© 2025 Fairmarkit. All rights reserved.