The Scenario
The store reorganization is done. The new collection structure is approved, the products are categorized, and an Excel workbook has been built with 300 rows mapping product IDs to their target collection IDs. The head of e-commerce wants the changes live before the weekend so the new navigation reflects the updated structure.
Someone needs to create 300 Shopify collects. That person has a meeting in 20 minutes.
The bad version:
- Open Shopify's collection editor for the first target collection, click Add products, search for the product by title.
- Realize the search doesn't support product ID lookup, so you're scanning a product list by title and trying to match it to the workbook row.
- Add the product, navigate back, open the next collection. At 15 collections, you realize this is going to take the rest of the day.
The navigation goes live Friday. Today is Wednesday afternoon.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the product-collection mapping and creates each Shopify collect — the association that links a product to a custom collection — via the API in one batch.
Read my Product-Collection Mapping Excel sheet and create Shopify collects for all rows where column C is blank — write the collect ID into column C once created
What You Get
- A Shopify collect created for each row where column C is blank, linking the product in column A to the collection in column B.
- The collect ID written back into column C once created, giving you a permanent reference.
- Collection pages in the Shopify storefront update immediately as the collects are added.
What If the Data Is Not Quite Ready
Some products may already be in the target collection from a previous partial run
Read my Product-Collection Mapping Excel sheet and create Shopify collects for all rows where column C is blank — skip any row where the product is already a member of the collection — write the collect ID or 'already in collection' into column C
Collection IDs are missing — you only have collection handles
For each row in my Product-Collection Mapping Excel sheet where column C is blank, look up the Shopify collection ID for the handle in column B — create a collect for product ID in column A at that collection — write the resolved collection ID into column D and the collect ID into column C
The mapping spans two worksheets — furniture products on one, decor products on another
Create Shopify collects for all rows in my Furniture Mapping sheet (product ID column A, collection ID column B, blank column C) and all rows in my Decor Mapping sheet (same structure) — write the collect ID into column C of whichever sheet each row came from
Resolve handles, skip existing, create from both sheets, and log collect IDs and timestamps
For each row in my Product-Collection Mapping Excel sheet and my Decor Mapping sheet where column C is blank, look up the collection ID from the handle in column B if needed, add product ID in column A to that collection if not already a member — write the collect ID and timestamp into columns C and D
Running the lookup, duplicate check, and creation in one pass means you can re-run the prompt safely after adding more rows to the workbook.
Try It
Get the 7-day free trial of SheetXAI and open the collection mapping workbook before the Friday navigation update, then ask SheetXAI to create all 300 collects in one operation. The next store reorganization will start with the same workbook structure. Also worth reading: how to remove orphaned collection associations when collections are retired, or the hub overview for all Shopify workflows.