You can import inventory items from text files or from Excel spreadsheets directly into QuickBooks using the Zed Axis software. Download and install the Zed Axis software on your computer.

1. Open your QuickBooks company file as Administrator and open Zed Axis
2. Select your text file or spreadsheet which contains the inventory items that you want to import.
3. Set up the a Mapping of the columns in your inventory items import file to the corresponding fields in QuickBooks
4. Click Import and your inventory items will be directly added to your QuickBooks company file:

For more information about importing inventory items into QuickBooks, search the Knowledge Base, watch the movies in the Learning Centre, or raise a ticket with Zed Support

Troubleshooting Common Errors

The COGS account cannot be changed - This error occurs when trying to modify an Inventory Item that has been used on a historical transaction in QuickBooks, due to the Inventory valuation calculations and the impact on balance sheet and on Closed Periods, restrictions are imposed by QuickBooks on modifying the COGS Account.  As a workaround you could modify the name of the item make inactive and then create a new Item with the required COGS Account.

Invalid Parent Specified - This error occurs when trying to modify a inventory item and the Parent Ref Full Name that has been specified does not exist or is not the correct parent for the item that you are importing.  Please check that the parent name appears correctly.  Further explanation of how parent names should appear is provided in the table above.