Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I am trying to import my products using exel.
All my products are non inventory but on importing using the file, it still shows me an error of category and still asks me to enter quantity.
This becomes a very tedious process when you have more than 1500 products to import.
Please help me resolve this issue
Hi Monex!
I understand that you need to import your products into QuickBooks Online. Let me help you!
You'll want to review your Excel file. Please note that QuickBooks Online only reads and assesses the data based on what was in the file.
Open the file and make sure you entered "Noninventory" under the Type column. If there is a Quantity on Hand column, set it to zero. You can also delete all columns related to inventory except for the Type so that the system won't assume that it is an inventory item.
Please check this article for your reference on how to import products: Import products and services into QuickBooks Online.
Not only products and services but you can also import other data in QuickBooks. Check it here: Common questions about importing data.
Comment below if you need anything else. I'll be here!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here