Weekly Shopify image fill for products missing a cover photo

Build me a code workflow that runs every Sunday at 10pm and fills in missing product cover images across my Shopify catalog, then posts a Slack digest for my team to spot-check the picks before customers see them. The whole loop should be deterministic and idempotent, so re-running only touches products that are still missing images.

Trigger: a cron schedule, weekly on Sunday at 10pm in my local timezone.

Step 1, enumerate my Shopify catalog. Use Shopify "List Products" with pagination (Link header, page_info cursor, limit up to 250) to walk every product. Make the minimum image count configurable, default 1. For each product whose images array has fewer than the minimum, collect it into a work list along with its id, title, product_type, vendor, and storefront URL.

Step 2, for each product in the work list, build a search query from the product title plus product_type (fall back to title only if product_type is empty) and call Image Search "Search for Images". Take the top-ranked result's image URL. If the search returns no results, skip the product and record it as "no candidate found" in the digest.

Step 3, attach the candidate image by calling Shopify "Update Product" with an images array containing the candidate URL. Capture whether the update succeeded for each product so we can show outcomes in the digest.

Step 4, build a digest of everything the sweep touched: products that got a new image (title, storefront URL, candidate image URL, the search query used), products that were skipped because no candidate was found, and a one-line summary at the top ("Filled X of Y products missing a cover image"). Post it to a designated Slack review channel using Slack "Send a Message" so a merchandiser can keep, swap, or reject each pick.

Constraints. Be polite to Shopify rate limits and respect Retry-After on 429s. Never replace an existing image, only add when the count is below the threshold. Make the Slack channel, the minimum image count, and the schedule easy configuration knobs at the top of the workflow.

Integrations: Shopify, Image Search, and Slack.

Additional information

What does this prompt do?

Sweeps your entire Shopify catalog every Sunday night and finds products that have no cover image, or fewer images than you want
Searches the web for a likely cover photo using the product title and type, then attaches the top result to that product
Posts a digest in Slack listing every product that got a new image so your team can keep, swap, or reject each pick before customers see it
Re-runs cleanly week after week and only touches products that are still missing images, so nothing gets overwritten

What do I need to use this?

A Shopify store admin login with permission to read and update your product catalog
A Slack workspace and the channel where your merchandising or content team should review the picks
Image Search is included with General Input, no separate signup required

How can I customize it?

Change the day or time the sweep runs, for example move it to Saturday morning or run it twice a week
Pick a different Slack review channel, and tune the minimum number of images each product should have
Adjust how the search query is built, for example title only, or title plus vendor, to get sharper picks for your category

Frequently asked questions

Will this overwrite images on products that already have a cover photo?

No. The sweep skips any product that already meets your image threshold, so re-runs only touch products that are still missing images. Existing photos are never replaced.

Can my team review the picks before customers see them?

Yes. That is the whole point of the Slack digest. Each product in the digest links back to its Shopify page and the candidate image URL, so a merchandiser can keep, swap, or reject the pick in a few clicks.

What happens if the image search returns nothing for a product?

The product is skipped on this run and noted in the Slack digest. It will be retried next Sunday, so you can also fix the product title or category in the meantime to give the search more to work with.

Can I run this more or less often than weekly?

Yes. Sunday at 10pm is just the default. You can move the schedule to daily, weekly on a different day, or any cadence that fits your team's review rhythm.

Will this work on a large catalog with thousands of products?

Yes. The workflow pages through your full catalog and only spends time on products that are actually missing images, so the Slack digest stays focused on what changed this week.