Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
We regularly import multiple products into Products & Services by csv. However, it does not import CATEGORY into QBO which is a big issue for us as we have 1000s of products under multiple categories.
Has anyone got a workaround for this. I have been sending feedback since Jan 2023 and I see from other posts this is an issue since 2020 and maybe before.
.
Hello Mcooney, thanks for posting on the Community page, we appreciate what you are saying and have left it back as feedback, we have passed this on as well to the team. It goes on demand so if there is lots of customers asking it about it may be a feature that comes out in the future.
Like this one?
Name | Type | UnitPrice | SKU | QtyOnHand | InvStartDate | InvAssetAccount | SalesDescription | Taxable | PurchaseDescription | PurchaseCost | IncomeAccount | ExpenseAccount |
Gift Certificate | NonInventory | 25 | $50 Gift Certificate | Y | $50 Gift Certificate | 15 | Product Sales | Purchases | ||||
Music Titles | NonInventory | 20 | Artist CDs | Y | Artist CDs | 12.5 | Product Sales | Purchases | ||||
Handhelds | NonInventory | 100 | Portable Game Player | Y | Portable Game Player | 50 | Product Sales | Purchases | ||||
Software | Service | 59.95 | 1 Year Warranty | Y | 1 Year Warranty | 32.5 | Product Sales | Purchases | ||||
Extended Warranty | Service | 29.95 | 1 Year Extended Warranty | Y | 1 Year Extended Warranty | 15.25 | Product Sales | Purchases | ||||
Magazine Subscription | Service | 12.95 | Annual Magazine Subscription | Y | Annual Magazine Subscription | 10 | Product Sales | Purchases |
Yes but the CATEGORY field is not an option for importing.
I just found out... By preceeding the Product / Service name (in the import file) with the CATEGORY name followed by a colon, this successfully imports the category into Quickbooks Online! Tried and tested today.
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.