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.

Many artists have 0 merch products because their merch is sold through label mega-stores (Warner Music, Rockabilia, MerchNow, Impericon) rather than individual Shopify stores. Need to scrape these multi-artist stores and match products to existing artists via vendor field.

Need to detect new products on Shopify stores quickly (within 30 minutes) without re-scraping entire catalogs each time. Full re-scrapes are wasteful — most stores don't add products daily.

Updating Shopify Dawn theme homepage to match a preview HTML design with horizontal product scrolling, image-overlay cards, feature banners, and new sections — without breaking Dawn's built-in product rendering (cart, variants, inventory).

Selecting the best free Shopify theme for an industrial B2B/B2C ecommerce store (PPE, safety gear, industrial supplies) requires balancing bulk-ordering UX, professional aesthetics, technical spec display, and plan-specific feature availability. Most theme comparisons focus on fashion/lifestyle stores and miss critical B2B considerations like quick-order workflows and metafield-driven spec tables.

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.