--- title: PURCHASE ORDERS - Import description: How to Import Purchase Orders --- [Skip to content](https://cs.geminilogic.com/en/manual/purchase-orders-import#main-content) English Show submenu for translations [New Ticket](https://cs.geminilogic.com/en/manual/kb-tickets/new?hsLang=en) [Customer portal](https://cs.geminilogic.com/tickets-view?hsLang=en) ![Gemini-Logic-Logo (1).png\]](https://cs.geminilogic.com/hs-fs/hubfs/Gemini-Logic-Logo%20(1).png?height=40&name=Gemini-Logic-Logo%20(1).png) - Home - Products - Pricing - Blog - Company Open main navigation Close main navigation - Home - Products - Pricing - Blog - Company - English Show submenu for translations - [New Ticket](https://cs.geminilogic.com/en/manual/kb-tickets/new) - [Customer portal](https://cs.geminilogic.com/tickets-view) - [Go to Gemini Logic](https://www.geminilogic.com/) [Go to Gemini Logic](https://www.geminilogic.com/) Search the User Manual - There are no suggestions because the search field is empty. 1. [User Manual](https://cs.geminilogic.com/en/manual?hsLang=en) 2. [Spire User Manual - Purchase Orders](https://cs.geminilogic.com/en/manual/spire-user-manual-purchase-orders?hsLang=en) # PURCHASE ORDERS - Import ## How to Import Purchase Orders ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Apr-29-2023-08-31-54-1021-PM.png?width=194&height=138&name=image-png-Apr-29-2023-08-31-54-1021-PM.png) **![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Apr-29-2023-08-31-29-5482-PM.png?width=50&height=47&name=image-png-Apr-29-2023-08-31-29-5482-PM.png)** - **Access** - Tools \> Import - option to ![ImportOpenConfig](https://cs.geminilogic.com/hs-fs/hubfs/ImportOpenConfig.png?width=27&height=25&name=ImportOpenConfig.png) open a previously saved import configuration / mapping or continue as follows: ![PurchaseOrdersImport](https://cs.geminilogic.com/hs-fs/hubfs/PurchaseOrdersImport.png?width=477&height=391&name=PurchaseOrdersImport.png) - select the .xlsx or .csv file **Source** location using **Browse Files…** if this is a new Import or **Browse Folders…** if this is a previously saved Import - accept or change **Date Format** if applicable - select from the **Import Type** list - **Purchase Order** - map fields (including [UDFs](https://cs.geminilogic.com/en/manual/user-defined-fields-add-edit-fields?hsLang=en)): - select the field under **Import File** - ie: ‘Vendor No.’ - select the corresponding field under **Spire Fields** (ie: ‘Vendor Number’) - note the ‘Group By’ field which is used to group lines on the spreadsheet to an individual order - click the **Match** button - matched items will transfer down to lower section, where you can then select the field and Unmatch if desired - continue to Match all fields you want to import into Spire - option to select a **Destination** folder to move the successful imported file to - option to select a **Failure** folder to move the unsuccessfully imported file to - determine if your spreadsheet ![CheckBoxCheckedBlue](https://cs.geminilogic.com/hs-fs/hubfs/CheckBoxCheckedBlue.png?width=16&height=16&name=CheckBoxCheckedBlue.png) **Has** **Header Row** - click on ![](https://cs.geminilogic.com/hubfs/image-png-Dec-22-2022-03-03-26-8433-PM.png) **Save config** / ![](https://cs.geminilogic.com/hubfs/image-png-Dec-22-2022-03-03-32-6930-PM.png) **Save config as** to save the Source, Import Type, Field Mapping, Destination and Failure folders into the current user’s documents folder - click on ![](https://cs.geminilogic.com/hubfs/image-png-Dec-22-2022-03-03-37-5249-PM.png) Import to finish and review the newly imported records in Spire - [Spire Systems - General Knowledge Base](https://cs.geminilogic.com/en/manual/spire-systems-general-knowledge-base?hsLang=en#main-content) - [Tips and Tricks](https://cs.geminilogic.com/en/manual/spire-systems-general-knowledge-base?hsLang=en#tips-and-tricks) - [Spire Administration - General Ledger](https://cs.geminilogic.com/en/manual/spire-systems-general-knowledge-base?hsLang=en#spire-administration-general-ledger) - [Spire Administration - Sales](https://cs.geminilogic.com/en/manual/spire-systems-general-knowledge-base?hsLang=en#spire-administration-sales) - [Spire Administration - Inventory](https://cs.geminilogic.com/en/manual/spire-systems-general-knowledge-base?hsLang=en#spire-administration-inventory) - [Analytics for Spire](https://cs.geminilogic.com/en/manual/analytics-for-spire?hsLang=en) - [Spire User Manual - System Overview](https://cs.geminilogic.com/en/manual/spire-user-manual-system-overview?hsLang=en) - [Spire User Manual - User Settings](https://cs.geminilogic.com/en/manual/spire-user-manual-user-settings?hsLang=en) - [Spire User Manual - Vendors](https://cs.geminilogic.com/en/manual/spire-user-manual-vendors?hsLang=en) - [Spire User Manual - Inventory](https://cs.geminilogic.com/en/manual/spire-user-manual-inventory?hsLang=en#main-content) - [Pricing](https://cs.geminilogic.com/en/manual/spire-user-manual-inventory?hsLang=en#pricing) - [Spire User Manual - Price Matrix](https://cs.geminilogic.com/en/manual/spire-user-manual-price-matrix?hsLang=en) - [Spire User Manual - Purchase Orders](https://cs.geminilogic.com/en/manual/spire-user-manual-purchase-orders?hsLang=en) - [Spire User Manual - Sales Orders](https://cs.geminilogic.com/en/manual/spire-user-manual-sales-orders?hsLang=en) - [Spire User Manual - Keyboard Shortcuts](https://cs.geminilogic.com/en/manual/spire-user-manual-keyboard-shortcuts?hsLang=en) - [Spire User Manual - Company Settings](https://cs.geminilogic.com/en/manual/spire-user-manual-company-settings?hsLang=en) - [Spire User Manual - New Instal/Company Setup](https://cs.geminilogic.com/en/manual/spire-user-manual-new-instal-company-setup?hsLang=en) - [Spire User Manual - General Ledger](https://cs.geminilogic.com/en/manual/spire-user-manual-general-ledger?hsLang=en) - [Spire User Manual - Accounts Receivable](https://cs.geminilogic.com/en/manual/spire-user-manual-accounts-receivable?hsLang=en) - [Spire User Manual - Accounts Payable](https://cs.geminilogic.com/en/manual/spire-user-manual-accounts-payable?hsLang=en) - [Spire User Manual - Payroll](https://cs.geminilogic.com/en/manual/spire-user-manual-payroll?hsLang=en) - [Spire User Manual - Production Manager](https://cs.geminilogic.com/en/manual/spire-user-manual-production-manager?hsLang=en) - [Spire User Manual - Service Manager](https://cs.geminilogic.com/en/manual/spire-user-manual-service-manager?hsLang=en) - [Spire User Manual - User Defined Fields](https://cs.geminilogic.com/en/manual/spire-user-manual-user-defined-fields?hsLang=en) - [Spire User Manual - Job Costing](https://cs.geminilogic.com/en/manual/spire-user-manual-job-costing?hsLang=en) - [HubSpot](https://cs.geminilogic.com/en/manual/hubspot?hsLang=en#main-content) - [Updates](https://cs.geminilogic.com/en/manual/hubspot?hsLang=en#updates) - [Gemini Logic](https://cs.geminilogic.com/en/manual/gemini-logic?hsLang=en) - [Shipping](https://cs.geminilogic.com/en/manual/shipping?hsLang=en) - [Sales Taxes](https://cs.geminilogic.com/en/manual/sales-taxes?hsLang=en) - [Spire User Manual](https://cs.geminilogic.com/en/manual/spire-user-manual?hsLang=en#main-content) - [Customers](https://cs.geminilogic.com/en/manual/spire-user-manual?hsLang=en#customers) - Home - Products - Pricing - Blog - Company [![Chill listening crop-3](https://cs.geminilogic.com/hs-fs/hubfs/Gemini%20Logic%20-%20Black-1.png?width=77&height=24&name=Gemini%20Logic%20-%20Black-1.png "Chill listening crop-3")](https://www.geminilogic.com/) Gemini Logic Copyright © 2026, 9858733 Canada Inc. (Gemini Logic)