Import purchase orders

After your sourcing process in Fairmarkit, you'll create purchase orders for the items and services that you've sourced. Then, you can import the purchase order information into Fairmarkit. By providing your purchase orders, you will continue to improve your supplier recommendations.

Purchase order data

The following table outlines the column headers you will need to create when you import your purchase orders into Fairmarkit. The *required fields are marked.

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

Fairmarkit field	Header	Description
*	Purchase Order ID	po_id	Purchase requisition ID in your purchasing application. Data type: Text Example: S1000
*	Line Item ID	line_item_id	Unique identifier of the line item in your purchasing application. Data type: Text Example: G123
	Purchased At	purchased_at	Purchase order purchasing date. Data type: Text Example: 2022-07-28
	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
*	Item Description	item_description	Item description. Data type: Text Example: coffee beans
*	Unit of Measure	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.
*	Quantity	quantity	Item quantity. Data type: Text Example: 1
*	Unit Price	unit_price	Unit price of line item Data type: Text Example: 8.00
	Extended Price	extended_price	Total cost of the line item. Data type: Text Example: 8.00
*	Currency	currency	Unit price currency. This should be the three letter currency code. Data type: Text Example: USD
*	Supplier Title	supplier_name	Supplier name. Data type: Text Example: Catherine's Coffee Shop
	Supplier ID	supplier_id	Supplier ID in your purchasing application. Data type: Text Example: S1000
	Supplier URI	supplier_uri	Supplier's email or domain. This is useful for reporting and when multiple emails have the same supplier_id. Data type: Text Example: cdw.com
	Fairmarkit Line Item ID	fm_line_item_id	Fairmarkit Line Item ID. # pandas code PO_HASH_COLUMNS - list of columns for the cache (usually PO_ID and PO_LINE_ID po['FM_PO_ID'] = po.apply(lambda row: hashlib.md5('|'.join([str(row[x]) for x in PO_HASH_COLUMNS]).encode('utf-8')).hexdigest(),axis=1 ) Data type: Text Example: 0065f967671d5d960e02253ada162502
	UNSPSC	unspsc	Standard 8 digit UNSPSC code for the item or requested service. Data type: Text Example: 50201706
	Manufacturer	manufacturer	Manufacturer of the line item. Data type: Text Example: Local Co
	SKU	sku	Supplier or manufacturer part number. Data type: Text Example: S12094
	Category	category	Category as defined in your purchasing application. Data type: Text Example: Supplies
	Category ID	category_id	Category ID. Data type: Text Example: 1001
	Subcategory	subcategory_1 subcategory_2 subcategory_3	Subcategory. Data type: Text Example: Coffee
	Subcategory ID	subcategory_1_id subcategory_2_id subcategory_3_id	Subcategory ID. Data type: Text Example: 23
	Notes	notes	Notes about the requisition, request for quote event, purchase order, etc. Data type: Text Example: Buying some coffee
	Requisition ID	requisition_id	Purchase requisition ID from your purchasing application Data type: Text Example: R1000
	Status	status	Purchase order status. Default: PURCHASED Data type: Text Example: PURCHASED Accepted values: PURCHASED/CANCELLED/REFUNDED/IN_PROGRESS
	Ordered At	ordered_at	Purchase order date. Data type: Text Example: 2022-07-28
	Global Ledger ID	global_ledger_id	Global ledger ID. Data type: Text Example: 650666
	Global Ledger	global_ledger	Global ledger. Similar to category, this value can be used for supplier recommendations. E.g., Tools & Fixtures, Calibrations, and Chemicals. Data type: Text Example: Repairs & Maintenance
	Plant ID	plant_id	Plant ID. Data type: Text Example: 1002
	Plant	plant	Plant or branch. This value is related to the shipping information. Data type: Text Example: US Plant
	Cost Center ID	cost_center_id	Cost Center ID. Data type: Text Example: 11MDO501
	Cost Center	cost_center	Cost center. Similar to category, this value can be used for supplier recommendations. E.g., Braid & Cable, R&D, HR. Data type: Text Example: Braid & Cable
	Funds Center ID	funds_center_id	Funds Center ID. Data type: Text Example: 55665
	Funds Center	funds_center	Funds Center. Data type: Text Example: Marketing
	Department ID	department_id	Department ID. Data type: Text Example: 11010
	Department	department	The department within your organization that purchased the items or services. Data type: Text Example: HR
	Buyer ID	buyer_id	Buyer ID Data type: Text Example: buyer.example
	Buyer	buyer	Buyer Data type: Text Example: Buyer Example
	ERP System	erp	Your purchasing application. When entered, it will override the system level settings. Data type: Text Example: SAP Ariba
	ERP System Id	erp_system_id	ERP System Id
	Purchase Order Description	po_description	Purchase Order Description. Data type: Text Example: Coffee Beans Order
	Manufacturer Part Number	manufacturer_pn	Manufacturer part number of the line item. Data type: Text Example: 900
	Language	language	Purchase order language. Default: en Data type: Text Example: en Accepted values: See list of ISO 639-1 codes.
	Shipping City	shipping_city	Shipping address city. Data type: Text Example: Boston
	Shipping State	shipping_state	Shipping address state. Data type: Text Example: MA
	Shipping Zip	shipping_zip	Shipping address zip code. Data type: Text Example: 02108
	Shipping Country	shipping_country	Shipping address country. Data type: Text Example: US
	Shipping Address	shipping_address	Shipping address - first line. Data type: Text Example: 27 School St
	Shipping Notes	shipping_notes	Shipping notes. Data type: Text Example: Leave at doorstep