Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
posted
Best answer May 06, 2024
Solved
Best Answers
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.
- Go to Sales.
- Click Products and Services.
- On the right side of your screen, hover your mouse over the dropdown arrow in the New button.
- Click Import, and select the Excel file you will import.
- Follow on-screen instructions.
- Put a checkmark on the Buy and Sell boxes.
- Remove the Track checkmark for the service items, and select Service from the Type drop-down.
Moreover, let me share these articles that can help you manage your inventory:
- Adjust inventory quantity on hand in QuickBooks Online
- Add inventory products in QuickBooks Online
- Set up and track your inventory in QuickBooks Online
Keep me posted if you still have concerns about importing your Products and Services. Have a great day, and take care.
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!
