The Scenario
The store went through a collection restructure three months ago. The discontinued seasonal collection was removed from the navigation, but 60 product-collection associations — collects — were never deleted. Products from that collection are still surfacing in internal search and showing up in the sitemap.
The developer who ran the initial audit left a note: "collect IDs are in the Excel workbook, needs someone to delete them." That note has been sitting there for six weeks.
The bad version:
- Open the discontinued collection in Shopify admin — wait, it's been removed from the navigation. Find it through the collections list by searching.
- Discover the collection page shows products but doesn't offer a bulk-remove option.
- Navigate to each product individually, open the product editor, find the collection association, and remove it.
- Repeat for 60 products, knowing that some are out of stock and won't show by default in the collection view.
Six weeks of a sitemap inconsistency is enough. The workbook exists. The collect IDs are in it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the collect IDs and deletes each one from Shopify via the API — no admin navigation, no product-by-product removal.
Read my Collection Cleanup Excel sheet and remove each Shopify collect ID in column A, writing the result status into column B
What You Get
- Each collect deleted from Shopify, with "deleted" written back into column B for confirmation.
- Collect IDs that are no longer found in Shopify get "not found" in column B — useful if some were already deleted in a previous partial cleanup.
- The products disappear from the discontinued collection immediately and stop appearing in sitemap crawls.
What If the Data Is Not Quite Ready
Some collect IDs may have already been deleted from a previous partial cleanup run
Read my Collection Cleanup Excel sheet and attempt to delete each collect ID in column A where column B is blank — if the collect no longer exists, write 'already gone' in column B instead of erroring
You only have product IDs and collection IDs, not collect IDs
For each row in my Collection Cleanup Excel sheet, look up the Shopify collect ID for product ID in column A and collection ID in column B — delete that collect — write 'deleted' or 'not found' into column C
The cleanup spans two worksheets — associations from two different discontinued collections
Read my Cleanup-A Excel sheet and my Cleanup-B Excel sheet and delete each Shopify collect ID in column A of both sheets — write the result status into column B of whichever sheet each row came from
Resolve collect IDs from product+collection pairs, skip already-deleted, delete from both sheets, and timestamp
For each row in my Collection Cleanup Excel sheet and my Cleanup-B sheet where column C is blank, look up the Shopify collect for product ID in column A and collection ID in column B — delete it if found — write 'deleted' and the timestamp into column C, or 'already gone' if not found
Resolving the collect ID from product and collection pairs in the same step as deletion means you don't need a separate lookup script first.
Try It
Get the 7-day free trial of SheetXAI and open the collection cleanup workbook that's been sitting in the project folder for six weeks, then ask SheetXAI to delete all 60 collects before the next sitemap audit. Future cleanup tasks will use the same pattern. Also worth reading: how to bulk add products to the new collections they should belong to, or the hub overview for all Shopify workflows.