Selling Digital Products: Templates, E-Books & Presets – Pricing Tiers, Bundles, Licences, Refunds & Store Fees

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn creation hours and tool costs into the cost each product must recover, work out how many sales it needs to break even (rounded up), how many months that takes at the expected pace, and flag the products with a slow payback.
• Calculate the net amount of a sale after a percentage store fee, a percentage payment fee and a fixed fee, see how the effective fee rate explodes on small prices, flag the prices above a target rate with IF and solve for the lowest price that stays within it.
• Price orders by licence with a multiplier table and XLOOKUP, total the revenue per licence with SUMIFS, work out the average revenue per buyer at a planned licence mix with SUMPRODUCT and find the licence that brings the most money.
• Add up the single prices inside each bundle with SUMPRODUCT, turn the bundle price into a discount, work out how many more buyers the discount needs to keep the revenue and calculate the net amount per bundle after fees.
• Apply a launch code with IF, count the buyers per day with COUNTIFS, total the revenue per day with SUMIFS and work out how much revenue the code gave away during launch week.
• Total the refunds of each product with SUMIFS, turn them into a refund rate by value, flag the products above a review threshold with IF and find the refund reason that costs the most.
• Measure each product by its revenue per creation hour, rank the catalogue with RANK.EQ, mark the top 20% with PERCENTILE.INC and compare product types with pooled SUMIFS ratios.
• Build a product × channel grid with two-criteria SUMIFS and mixed references, total the months, add a running total and chart the months for the year-end review.