When products are bulk-scraped from Shopify stores, the database created_at timestamp reflects import time, not when the product was actually released. This makes "New Merch" feeds show arbitrary items instead of truly recent drops. All products appear to have the same date.

When building genre-based artist discovery, Spotify genre tags include language/country prefixes (e.g., "french hip hop", "german rap", "turkish pop"). Without filtering, selecting "Rap" shows French, German, Turkish rappers mixed with US artists, which is confusing for users expecting English-speaking artists.

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.

Need to populate artist merchandise data from official online stores. Most artist stores use Shopify but many URLs are guessed wrong, stores are down, or use non-Shopify platforms. Need a reliable method to test and scrape multiple artist stores efficiently.