Bulk Shopify store discovery and Ticketmaster event fetching for a music app

Need to populate a music app with merch products and events for hundreds of artists. Manual store discovery is slow and Ticketmaster API has rate limits. Posts table uses foreign keys (product_id) not direct content columns. artist_events table needs a proper UNIQUE constraint on external_id for ON CONFLICT.

For merch: Write a bulk URL tester that tries common Shopify store URL patterns (store.{name}.com, shop.{name}.com, {name}shop.com, etc.) with /products.json?limit=1 to discover working stores. Then scrape discovered stores with /products.json?limit=10 and generate SQL with DO $$ blocks that INSERT product then INSERT post with the returned product_id. For events: Use Ticketmaster Discovery API with keyword search per artist (size=10, sort=date,asc, startDateTime=today), rate limited at 0.22s between requests. Before inserting, ensure artist_events.external_id has a proper UNIQUE constraint (not just an index) for ON CONFLICT to work. Event posts in the app only need artist_id, post_type=EVENT, posted_at=event_date - no title/content columns.

Shopify stores follow predictable URL patterns making bulk discovery feasible. Ticketmaster API allows keyword search but needs rate limiting. PostgreSQL ON CONFLICT requires UNIQUE constraint, not just an index. Posts table schema uses FKs to content tables rather than denormalized columns.