--- title: INVENTORY - Items Import description: Add / Change multiple Inventory items at once through the Import utility --- [Skip to content](https://cs.geminilogic.com/en/manual/inventory-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 - Inventory](https://cs.geminilogic.com/en/manual/spire-user-manual-inventory?hsLang=en) # INVENTORY - Items Import ## Add / Change multiple Inventory items at once through the Import utility **![](https://cs.geminilogic.com/hubfs/image-png-Aug-01-2022-06-35-54-85-PM.png)** - **Access** - Tools \> Import ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-May-11-2023-11-51-45-5136-AM.png?width=182&height=157&name=image-png-May-11-2023-11-51-45-5136-AM.png) - option to open a previously saved import configuration / mapping ![ImportOpenConfig](https://cs.geminilogic.com/hs-fs/hubfs/ImportOpenConfig.png?width=28&height=26&name=ImportOpenConfig.png) or continue as follows: - select the file **Source** location using the **Browse Files…** if this is an unsaved Import or **Browse Folders…** button if this is a previously saved Import, to load the .xlsx or .csv file     ![InventoryImport](https://cs.geminilogic.com/hs-fs/hubfs/InventoryImport.png?width=503&height=420&name=InventoryImport.png) - accept or change **Date Format** if applicable - select from the **Import Type** list - **Inventory** - import to add new or change existing inventory items - Inventory Adjustment (see [Inventory Quantity / Cost Adjustment  / Physical Inventory Count Sheet](https://cs.geminilogic.com/en/manual/inventory-adjust-inventory-quantity-/-cost?hsLang=en)) - **Inventory Code Change** (see [Inventory Code Change](https://cs.geminilogic.com/en/manual/inventory-code-change?hsLang=en)) - **Inventory Product Code Sales Taxes** (see [Inventory Product Code Sales Taxes](https://cs.geminilogic.com/en/manual/inventory-product-codes?hsLang=en#InventoryProductCodeSalesTaxes)) - **Inventory Sales Taxes** (see [Inventory Sales Tax](https://cs.geminilogic.com/en/manual/inventry-sales-tax-exceptions?hsLang=en)) - **Inventory Sell Price** (see [Inventory Sell Prices](https://cs.geminilogic.com/en/manual/sell-prices?hsLang=en)) - **Inventory Transfer** (see [Warehouse Transfer](https://cs.geminilogic.com/en/manual/inventory-warehouse-transfer?hsLang=en)) - **Inventory UPC** - import UPC codes for your inventory items - 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: ‘Warehouse’ - select the corresponding field under **Spire Fields** - ie: ‘Warehouse’ - 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 successfully imported file to - option to select a **Failure** folder to move the unsuccessfully imported file to - determine whether or not your spreadsheet ![CheckBoxCheckedBlue](https://cs.geminilogic.com/hs-fs/hubfs/CheckBoxCheckedBlue.png?width=16&height=16&name=CheckBoxCheckedBlue.png) **Has** **Header Row** (see top) - click on ![](https://cs.geminilogic.com/hubfs/image-png-Aug-01-2022-06-37-46-05-PM.png) **Save config** / ![](https://cs.geminilogic.com/hubfs/image-png-Aug-01-2022-06-37-52-45-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-Aug-01-2022-06-38-02-83-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)