Creating Product Shot Briefs

Given messy scraped data like search results or product listings, extract structured product entries:

Product: Spooky Halloween Downloadable PDF Pattern
Brand: Bunny Hill Designs
Price: $39.95
Category: Quilt Pattern (Digital/PDF)
Shot Type: Isolated product flat-lay or styled pattern cover

Repeat for each distinct product found, deduplicating repeated listings and stripping social media noise (Instagram/Facebook captions, repeated boilerplate).

Progress:

• Step 1: Scan raw data and identify genuine product/listing entries vs. noise (social captions, repeated blog links, navigation cruft)
• Step 2: Deduplicate — the same product often appears many times across a scrape
• Step 3: Extract structured fields per product: name, brand/seller, price (if present), product type/category, source
• Step 4: Group into categories (e.g., Quilt Kits, Patterns/PDFs, Panels, Tools/Templates, Mini Quilts)
• Step 5: Flag which entries have commercial data (price, seller) vs. editorial/blog-only mentions
• Step 6: Produce an isolated product shot brief for each priced/sellable item — background (white/transparent), angle, styling notes, and any seasonal props implied by the listing (e.g., Halloween motifs: pumpkins, ghosts, spiders)
• Step 7: Output final clean table/list, separating "Products for photography" from "Reference/inspiration content"

Example 1: Input: HALLOWEEN SPOOK Quilt Kit featuring the Fear Factory Collection — All Things Quilty · $90.99 Output:

Name: HALLOWEEN SPOOK Quilt Kit (Fear Factory Collection)
Seller: All Things Quilty
Price: $90.99
Type: Quilt Kit
Shot Brief: Isolated product shot, folded kit box/bundle on white background,
  show fabric collection swatches fanned beside it, top-down or 3/4 angle,
  soft diffused lighting to show fabric print detail.

Example 2: Input: This is hands-down the silliest (and most fun!) Halloween quilt ever 🎃 ... delivered to you in a cute little box each month — Facebook Output:

Classification: Editorial/social content, NOT a sellable product listing.
Action: Exclude from product catalog; optionally log as inspiration/lead
  for a "box club" subscription product category.

Example 3: Input: Multiple repeated entries for "Spooky Over and Under Quilt Kit - Halloween Quilt Kit – Block Party Quilt Co" appearing 5+ times Output:

Name: Spooky Over and Under Quilt Kit
Seller: Block Party Quilt Co
Price: Not listed (needs lookup)
Type: Quilt Kit
Note: Deduplicated from 5 duplicate scrape entries.