Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi there, Cheryl.
Let's make sure you'll be able to migrate your Product/Service Item List with sub-items into QuickBooks Online (QBO).
When migrating, you can save time by importing a spreadsheet of your products and services into QuickBooks. I'll walk you through formatting your spreadsheet in Google Sheets or Excel and importing it right into QuickBooks.
In QBO, you can download our sample file that shows you how to format your spreadsheet so it imports correctly. Here's how:
Here are some formatting tips:
Now with regard to formatting your items with sub-items, you'll need to use a row for each item variation. For example, if your items are pieces of clothing in multiple colors and sizes, your format will look like this: [Item]:[Size]:[Color]
You can browse through this article for the detailed step-by-step process of importing your Product/Service Item List: Import products and services into QuickBooks Online.
Additionally, I got you an article that'll guide you in case you'll need to change the item type of your products and services: Change product and service item types in QuickBooks Online.
I'll be here if you've got additional queries about managing your products and services in QBO. It's always my pleasure to be of assistance. Take care.