Back

Audit my store's catalog for sold-out and broken items

A sweep of every product flagging sold-out, missing images, and price issues

FoundersMarketingOps
Prompt

Audit my store's catalog: [storefront URL]. Go through every collection and product listing and flag what's broken or quietly losing sales. For each collection, count the live products, then check each product page for: sold-out or unavailable items (including ones where every variant is gone), missing or broken images, placeholder text, obviously wrong prices [e.g. $0, or way off similar items], and dead links. Note items down to their last variant separately from fully sold out. Build a sheet with one row per problem: collection, product, URL, issue type, and detail. Add a per-collection summary tab: total products, live, sold out, flagged. Work through the whole catalog — don't sample — and finish with the totals plus the top 10 items I should fix or restock first.

Works withsheets.google.com