Should I create a Mother's Day bestseller collection based on last year's data?

Using Last Year's Data to Build a Mother's Day Bestseller Collection

Historical sales data reduces the guesswork in seasonal merchandising. Mother's Day gift purchases are driven by consistent buyer psychology and product category preferences that change slowly year over year. Using prior-year data as the foundation for this year's collection is a lower-risk strategy than curating based on current feelings about which products will perform.

Data Extraction Process

• Step 1 - Go to Shopify Analytics, set date range to the 3-week window before last Mother's Day, and export Sales by Product report.
• Step 2 - Sort by total revenue descending, then by units sold descending to identify volume versus high-ticket performers.
• Step 3 - Cross-reference top 20 products with current inventory levels, verifying each is in stock and available for the full campaign window.
• Step 4 - Remove any discontinued items and fill gaps with similar new products that match the category and price point of the removed items.

Balancing Historical Data with Current Trends