Thank you for dropping by here in the Community, Let me explain the accurate way to import Products and Services into QuickBooks Online (QBO).
QuickBooks doesn't allow you to import inventory items if you do not have the Quantity on hand, as this is one of the most important pieces of information required when importing an inventory list. You can have the option to import the inventory list with the temporary Quantity on hand and then adjust the number immediately afterward, or import using another Product and Service type like Non-inventory or Service, so that QuickBooks won't ask you for the Quantity on hand, then make the changes after importing them to QBO.
Before we start, please note that we can only import 1,000 rows at a time. If your list is longer, I recommend splitting it into smaller files.
In importing products and services, you may check this article: Learn how to import a list of your products and services from Excel or CSV to QBO.
If you've imported with the option using another Product and Service type, here's how to edit:
- Go to the Sales tab and select Products and Services.
- Select the Non-inventory or Service type you've created, then click Edit.
- Click on the Change Type option, then select Inventory.
- Enter the correct number in the Initial Quantity on Hand, Sales Price, Cost, and Reorder Point fields.
- Click Save and Close.
For more information, please refer to this article: Change product and service item types in QBO.
Furthermore, this article will be helpful if you need to track your stock in QBO: Set up and track your stock.
Should you ever need anything, the Community is just a post away. Have a good one.
