How to prepare for a bulk product import into QuickBooks Online?
Before running a bulk product import into QuickBooks Online (QBO), a few quick checks will prevent the most common import failures. Work through these in order before opening the import wizard.
» Step 1: Confirm your access
- Log into QuickBooks Online with an admin or accountant-level account. Standard user accounts do not have import access.
- Confirm you are in the correct company file before proceeding. Importing into the wrong entity is difficult to undo.
» Step 2: Set up your categories in QBO first
Categories must exist in QBO before you run the import. If a category in your import file doesn't match an existing QBO category, those rows will either fail or land uncategorized.
- In the QBO search bar, type Products and Services and click the result.
- Click the More dropdown in the top-right of the screen.
- Select Manage Categories.
- Click New Category for any category that's missing. Save each one before moving to the next.
Tip: Parent/child categories use a > separator. For example, Home and Wellness>Reed Diffusers. Type it exactly as it should appear — QBO is case-sensitive.
» Step 3: Check for duplicate SKUs
QBO rejects any row where the product name or SKU already exists in your account.
- In Products and Services, use the search box to spot-check a few of the SKUs you plan to import.
- If any already exist in QBO, remove those rows from your import file before running the import.
» Step 4: Make sure your import file is set up correctly
QBO accepts .xlsx files. Each row represents one product. You can download the import template to get started. Make sure these key columns are populated correctly before uploading:
| Column | What to populate |
|---|---|
| Product/Service Name | Unique product name |
| Sales Description | Full product description |
| SKU | Unique SKU identifier |
| Type | Must be exactly Inventory — no trailing spaces, no variations |
| Sales Price / Rate | Numeric value — cell format must be Number or Currency, not Text |
| Taxable | Yes or No |
| Quantity on Hand | Required for Inventory type — do not leave blank. Use a placeholder (e.g. 10,000) if the actual count isn't ready |
| Quantity as-of Date | Today's date or the date of your physical inventory count |
| Category | Must match an existing QBO category exactly |
Columns for Income Account, Purchase Cost, Expense Account, Reorder Point, and Inventory Asset Account can be left blank. QBO applies its defaults during import.
» Tips for a smooth import
- Download the import template. Use the provided template to ensure your file is in the correct format before uploading.
- Always create products in QuickBooks first. If QBO is connected to WizCommerce, add products in QBO and let them flow through — not the other way around. Reverse order causes mismatched IDs and reconciliation issues.
- Test with a small batch first. Before running a large import, try 5–10 rows to confirm field mappings are correct.
- Save every import file. Keep a dated copy of each import file. It's your fastest recovery path if anything needs to be re-done.
Still need help? Reach out to our support team at help@wizcommerce.com.