In QuickBooks Desktop and inventory item list is used to track the products that are held in inventory and are purchased and sold by the business. Using the Zed Axis you can import inventory items from text files or from Excel spreadsheets directly into QuickBooks Desktop.
First download and install the Zed Axis software on your computer. Then follow these steps:
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.
Trouble logging in? Simply enter your email address OR username in order to reset your password.
For faster and more reliable delivery, add example@example.com to your trusted senders list in your email software.