This article outlines the process of deleting product and service records directly in QuickBooks Online with SaasAnt Transactions Online. It emphasizes the importance of identifying unused items, safely removing them, and confirming that no linked transactions are present to keep company records accurate.

Why use SaasAnt for deleting products/services?

SaasAnt Transactions Online lets you search with filters, review the matching products or services, take a backup, and delete multiple items in just a few clicks.

What should you have before you start?

You need:

• SaasAnt Transactions Online installed from the QuickBooks App Store (30-day trial available).

• A QuickBooks Online company connected to SaasAnt Transactions Online.

How do you bulk delete products/services using SaasAnt?

Step 1: How do you open SaasAnt Transactions Online?

1. Open the QuickBooks App Store.

2. Install SaasAnt Transactions Online and connect your QuickBooks Online company.

3. Launch SaasAnt Transactions Online.

Step 2: Where do you start the delete flow?

1. From the SaasAnt dashboard, select Delete.

2. On the setup screen, select Ready to clean up.

Step 3: Which delete method should you choose?

Choose one:

• Delete by Reference: Use this when you already know the exact Product/Service Name or SKU you want to delete.

• Delete by Searching: Use this when you want to find products/services using filters (example: finding duplicates, specific types, or creation dates).
  Select your method, then select Next.

Step 4: How do you set product/service type and date filters?

1. Set Entity Type to Product/Service (often labeled as "Item").

2. Choose the Date Type you want to filter by:

   • Created Date: When the item was first created in QuickBooks.

   • Last Updated Date: When the item details were last edited in QuickBooks.

3. Enter the Date Range.

Step 5: How do you narrow results using filters?

1. Select Customize.

2. Apply the filters you need, such as:

   • Total Amount (From amount - To amount): Use this to target items within a specific price/cost range.

   • Show Records From (Start At): To skip a specific number of records.

   • Status:

     • All: Includes all products/services.

     • Active: Includes only active products/services.

     • Deleted/Inactive: Includes only previously deleted/inactive items.

   • Name: Filter by the name of the product/service.

   • SKU: Filter by the Stock Keeping Unit.

   • Type: Filter by Inventory, Non-Inventory, or Service.

   • Detailed Report [Multi Lines]: Turn this on when you want to review specific details.

3. Select Search to load matching products/services.

Step 6: How do you review, backup, and delete?

1. Review the search results carefully.

2. Select the products or services you want to delete.

3. Download a backup (CSV or Excel) before deleting.

4. Select Delete.

5. Confirm the deletion in the pop-up.

Important: Deleting is not reversible. Always take the backup first, and delete in smaller batches if you are removing a large volume. Note: In QuickBooks Online, deleting a product with history usually makes it "Inactive."

Step 7: Where do you see the deletion summary?

After deletion, SaasAnt shows a Deletion Summary. This summary is available to download for up to 2 days and can be used for records and audit tracking.

Troubleshooting

What if no product/service shows up after the search?

Check these:

• Confirm the Date Type and Date Range match when the item was created or edited.

• Remove filters one by one (Name, SKU, Amount Range) to broaden the search.

What if the delete fails for some product/service?

Common reasons:

• The product/service is restricted by QuickBooks because it is linked to existing transactions (like invoices or bills).

• QuickBooks Inventory items with Quantity on Hand may require an inventory adjustment before deletion.

• Try deleting a smaller selection to identify which specific records are failing, then review those items inside QuickBooks Online.

What if you deleted the wrong product/service?

You cannot undo a delete in QuickBooks Online (though you can often reactivate an "Inactive" item). Use your SaasAnt backup file to re-create the product/service if needed, or restore using your own backup process if available.