Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello,
I recently tried uploading an excel file with the Product/Service Name, Type, and Taxable columns filled out. The Type column was 'Service' for all of them. Taxable columns were a mixture of 'Yes' and 'No'.
Goal: upload a file with a less than 100 services that are either taxed or not.
Problem: It indicates that a Quantity is required.
Investigation:
Solved! Go to Solution.
I know the reason why you see an error message while importing services in QuickBooks Online (QBO), @phinoreo. Let's fix this by following the solutions below.
Based on the screenshot you attached previously, you've encountered the "0 of 0 products and services successfully imported" error message if you didn't set the service item to buy or sell after being imported. To successfully import your service items, make sure to indicate whether you Buy the item, Sell the item or both.
Regarding the item type, you'll want to manually pick the Service if they've been changed to another type. As to the quantity, please note that it will still be imported even if the cells are highlighted in red. See the screenshot below for your visual reference:
For additional details and formatting tips on importing items into the program, please refer to this article: Import products and services into QuickBooks Online.
Moreover, you'll want to check out this article to learn more about grouping your items into different classifications: Group products and services into different categories in QuickBooks Online.
The Community is always here to assist you with importing your service items. Comment below if you have further inquiries, and I'll provide prompt assistance. Have a good day!
I'm happy to help you import your Products and Services, @phinoreo.
I appreciate the information and screenshot you've shared with us. You can import your Excel file without putting anything in the quantity column. To ensure that the process will go through, make sure that you've checked the Buy and Sell checkbox for your items. Furthermore, to avoid transforming your service to inventory, we'll have to uncheck the Track option for those items. Then, manually pick Service from the Type drop-down.
Moreover, let me share these articles that can help you manage your inventory:
Keep me posted if you still have concerns about importing your Products and Services. Have a great day, and take care.
When I follow those steps, upon clicking the 'Import' button, I receive the message that '0 of 0 products and services successfully imported.'
I know the reason why you see an error message while importing services in QuickBooks Online (QBO), @phinoreo. Let's fix this by following the solutions below.
Based on the screenshot you attached previously, you've encountered the "0 of 0 products and services successfully imported" error message if you didn't set the service item to buy or sell after being imported. To successfully import your service items, make sure to indicate whether you Buy the item, Sell the item or both.
Regarding the item type, you'll want to manually pick the Service if they've been changed to another type. As to the quantity, please note that it will still be imported even if the cells are highlighted in red. See the screenshot below for your visual reference:
For additional details and formatting tips on importing items into the program, please refer to this article: Import products and services into QuickBooks Online.
Moreover, you'll want to check out this article to learn more about grouping your items into different classifications: Group products and services into different categories in QuickBooks Online.
The Community is always here to assist you with importing your service items. Comment below if you have further inquiries, and I'll provide prompt assistance. Have a good day!
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