Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI downloaded the sample product and services to see what I needed to on each column. I also created a few products and services and exported the excel spreadsheet. Here what I ran into:
Under "type" column you have the choice of choosing 1. Inventory 2. Non-Inventory 3. Service 4. Bundle. I used non-inventory and when I upload the excel spreedsheet it changes all of my non-inventory to inventory. I'm not sure how to fix this, there are too many items to upload and manually would take at least three days to do. Can anyone help provide some support?
Probably a sample excel spreadsheet with a few sample of each type of service type?
Any input will help thanks in advance!
I attached my spreadsheet.
I can help you upload your item lists in QuickBooks Online, PTG.
Let's review the spreadsheet once more. For non-inventory items, please delete all number zeroes (0) in the Quantity On Hand column. That the reason why the system reads them as Inventory since you're putting an initial quantity.
On the Import Products and Services page, please don't forget to put a check mark on the "Overwrite all values for each product or service that you import with the identical name. (This can’t be undone.)" box. This will prevent creating duplicate items, and merging the old items to the new ones.
Go ahead and import the item list again.
Please don't hesitate to post any questions. We're here to help.
Okay I was able to figure out the another thing, it will not take the "Non-Inventory", however if you enter it in as "Noninventory", then it will work.
Hi PTG,
You'll want to make sure you map your fields to QuickBooks' fields to record them to the right account. You can select the correct account in Excel, and then re-import.
You can also check out this article for your reference: How to import products and services from Excel.
We'll be around if you have any questions. Feel free to reach out.
Okay I was able to figure out the another thing, it will not take the "Non-Inventory", however if you enter it in as "Noninventory", then it will work.
Hey @PTG,
Currently, you can only add the sales tax category of your items after importing them to QuickBooks.
As a workaround, you can map your non-inventory items to a sales account, then edit it after the import. Here's how:
Also, I encourage sending feedback to our engineers to allow you to categorize taxable sales items when importing products and services. This way, they can review your suggestion and add it to future product updates.
Please leave a comment below if you have any other questions.
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.