Products and Services - Batch Change Items - Now A Missing Feature?
We’ve previous used the CSV to mass change prices etc for my products. Although I can download the CSV file there is now way to re-upload it back?
I’ve asked the AI assistant and it confirmed the previous method, then rowed back saying the feature isn’t available when I confirmed that import is missing from the More drops down menu.
Please advise as this is going to be very time consuming to batch change items.
AI CHAT LOG:
To re-import your edited Products & Services CSV back into QuickBooks Online:
- Go to Sales (or Get paid & pay) → Products & services
- On the Products & services page, look for the Import option (often near the top-right, sometimes under a small drop-down/“More” menu).
- Choose Products and services as what you’re importing.
- Upload your edited CSV file.
- On the mapping screen:
- Make sure QuickBooks is mapping your columns to the right fields (especially Name (and SKU if you use it), and Expense account).
- The key to updating existing items (not creating duplicates) is that the rows match existing items by Name(and/or SKU, depending on what you have populated consistently).
- Complete the import, then spot-check a few items: open the item → confirm the Expense account is now your COGS subaccount.
Two important cautions before you click “Import”:
- If you change item Name values in the CSV, QuickBooks may create new items instead of updating existing ones.
- Only map the columns you actually intend to update (for your case: Expense account), and leave other columns alone to avoid unintended changes.
If you paste (or upload) a sample of 3–5 rows of your CSV (just the header + a few lines, you can redact prices), I can tell you exactly what the column headers should look like for the Expense account update and what to watch for to avoid duplicates.
Download
The import is missing from the more drop down menu
On the Products & services page you’re on, QuickBooks has replaced the old Import option with Make quick edits to your items (that button is visible on your screen). That’s why you’re not seeing Import in More.
What to do instead (bulk-change the expense/COGS account)
- Go to Products & services (you’re already there).
- Click Make quick edits to your items.
- Find the column/field for the item’s Expense account (sometimes shown as Purchasing information → Expense account).
- Update the Expense account for the items you want, then Save.
If you specifically need CSV re-import
In some QBO accounts, CSV Import for Products & Services isn’t available (or is restricted by permissions), so you only get Export table + Quick edits.
Two things to check:
- Click Export table and confirm you can export—if export works but import doesn’t exist, that’s expected in some setups.
- Confirm you’re signed in as a user with full permissions (ideally Primary admin or a full-access admin). If you’re a standard user, import can be hidden.
Would you like me to look at what your More menu actually contains on-screen and tell you the exact option to use from your account’s UI.