Hi there, @meara.
The best way to only see one product list and avoid the error is to rename the inactive products.
QuickBooks Online only allows you to inactivate products & services instead of deleting them to avoid damaging your historical data. We'll need to rename the inactivated products so you can easily identify which is active.
Here's how:
- On the left menu, head to Sales and select Products & Services.
- Click the Filter button.
- Change the Status to All, then click Apply.

- Find the inactivated item and click Make it Active under its ACTION column. You'll see if it's inactivated if it has the"(deleted)" text after its name.

- Open the same item and rename it to anything (for example, InactivatedBolts).

- Click Save.
- Make the item inactive again.
You can also consider grouping products and services into different categories in QBO. When you run reports, categories can provide helpful insights into your sales and inventory.
Let us know if you have additional concerns about your QBO account.