Which products to push in Q4: ABC analysis of stock and margin

.comparison-cards { display: flex; flex-direction: column; gap: 1.5rem; } .comparison-card { background: #fff; border-radius: 16px; padding: 20px; border: 2px solid #efefef; } .comparison-header { display: flex; justify-content: space-between; font-size: 16px; margin-bottom: 12px; } .comparison-row { display: flex; justify-content: space-between; padding: 8px 0; border-top: 1px solid #efefef; font-size: 14px; color: #1f2937; } .comparison-label { font-size: 14px; width: 30%; } .comparison-value { width: 65%; text-align: right; } @media (max-width: 600px) { .comparison-row { flex-direction: column; align-items: flex-start; } .comparison-value { text-align: left; margin-top: 4px; } } In Q4 ad budgets go up, clicks get more expensive and stock becomes more valuable than ever. The mistake I see most often: the store spreads the budget evenly across the whole catalogue or lets Performance Max decide on its own, and on 2 December finds out that the product bringing in the most profit has sold out. Below is the method I use with my clients to decide which products to push until Christmas, what to leave aside and how not to run out of best sellers. 1. The export: sales, margin and stock per product You need a table with one row per product (or per variant, if stock is held per variant) and these columns for the last 12 months: units sold and revenue; product cost, so you can calculate the margin in money per unit; return rate, where you have it; today's stock and the supplier lead time. Take 12 months, not 3, so you also capture last year's Q4. A product that sells modestly in September can be the star of December, especially for gifts. 2. ABC analysis by profit, not revenue A classic ABC analysis ranks products from largest to smallest and cuts them into three groups. The usual convention: A products together bring roughly the first 80% of the total, B the next 15% and C the last 5%. The thresholds are not a law; you can use 70/20/10 if your catalogue is small. The…