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.

When an SQLAlchemy model has a @property (like image_url derived from a JSON column), using it in queries like Artist.image_url.isnot(None) fails with 'property object has no attribute isnot'. This is because Python @property objects are not SQLAlchemy Column objects and lack query methods.