Every membership purchase and renewal is a Shopify order for your membership product. A saved sales report filtered to that product shows what your membership earns each month.
✅ Before you begin
A membership tier is set up in Okendo Loyalty. See Set up a Membership program in Okendo Loyalty.
In this article, you will learn about;
Build your membership sales report
In your Shopify admin, go to Analytics > Reports and open Total sales over time.
Set the date range, then set Group by to Month.
Under Filters, add Product title, select is and choose your membership product. If you sell more than one membership product, select is one of and choose each one.
Under Metrics, include Gross sales, Discounts, Sales reversals and Net sales. Add Net quantity to see how many memberships were sold after refunds.
If you sell several membership products or variants (for example, monthly and yearly), add Product title or Variant title as a dimension to compare them.
Select Save as and name the report, for example
Membership product sales.
Your report now appears in Analytics > Reports for you to open at any time.
Read your membership figures
Gross sales is membership sales before discounts and reversals.
Net sales is what remains after discounts and reversals. Use this as your headline figure.
Sales reversals appear in the month they're processed. A refund this month lowers this month's net sales, even if the membership was bought earlier.
⚠️ Call this figure "Membership product net sales", not "revenue from members". It counts membership purchases and renewals only, not everything your members buy.
Shopify sales reports measure order sales, not cash received, so they can include pending, unpaid and canceled orders. Net quantity also counts purchases, not people: one member who renews three times counts three times.
Pair sales with your member count
For a simple monthly summary, show two numbers side by side:
Current members: the customer count from your membership segment. See Create a Shopify customer segment for your members.
Membership product net sales: the monthly figure from this report.
Together they show how many members you have and what the membership earns. Keep them as separate figures, since one counts people today and the other counts sales over time.
FAQs
Q: Do membership renewals show in this report?
A: Yes. Membership renewals are treated as a new order within Shopify so they will be represented in this view.
Q: Why is my net sales figure lower than my number of members times the price?
A: Net sales takes off discounts and any refunds processed that month, and members may be on different billing intervals. Some members also joined in earlier months, so their payment falls outside the date range.
Q: Can I see how much my members spend on other products?
A: Not with this report, which only covers membership products.

