How Do I Track Gift Card Revenue Separately From Regular Product Sales?

Separate gift card sales, redemptions, and product revenue
The cleanest setup is simple: treat gift card purchases as one category, redemptions as another, and actual merchandise sold as a third.
That matters most in mixed reporting. If a customer buys a $50 digital gift card today, your store has taken in cash, but your store has also created an outstanding balance the customer can spend later. If that same customer redeems the card next week for a $38 product order in your OpoShop store, the redemption event and the merchandise sale are related, but they are not the same line item.
A lot of reporting confusion starts right there. Cash collected, balance issued, balance redeemed, and product revenue earned are connected. They are not interchangeable.
If you're also setting up gift cards from scratch, read how to sell gift cards on your online store.
What is gift card revenue tracking in ecommerce?
Gift card revenue tracking is the process of recording gift card sales, redemptions, store credit activity, and product revenue as separate events so your reports reflect what actually happened.
Here are the terms that need to stay clear:
| Term | What it means | What it should not be confused with |
|---|---|---|
| Gift card sale | A customer pays for a gift card | A normal product sale |
| Gift card redemption | A customer uses gift card balance on an order | New gift card issuance |
| Store credit | Merchant-issued balance, often after a return or service recovery | Customer-paid gift card value |
| Gift card liability | Outstanding unused balance still owed to the customer | Earned merchandise revenue |
| Product revenue | Revenue from goods or services actually sold | Gift card value sold but not yet spent |
The big distinction is this: a customer-paid gift card creates prepaid value, while merchant-issued store credit usually comes from a return, exchange, or service decision.
That sounds small, but it changes how you read the numbers. If an EverBee merchant approves a return and issues $40 in store credit, that $40 did not come in as a fresh sale. It is a balance adjustment tied to a return workflow. That store credit belongs in its own reporting lane, even if it behaves a lot like a gift card at checkout.
If you sell on OpoShop, this separation helps your team avoid looking at one balance system and assuming every dollar in it means the same thing.
Why does tracking gift card revenue separately matter?
Tracking gift card revenue separately matters because combined reporting overstates product sales, muddies retention analysis, and makes gift cards look better or worse than they really are.
The finance reason is obvious. If your team counts issued gift card value as merchandise revenue and then also counts the redeemed order as merchandise revenue, the same customer value gets counted twice in your analytics.
The retention reason is the part more merchants miss. Gift cards are not only an accounting item. Gift card redemptions often show you whether prepaid value is pulling a customer back into your store. A redeemed card that leads to a larger order tells a different story than an unredeemed balance sitting untouched for months.
Store credit needs the same attention, but not the same label. A return credit can bring a customer back too, yet it should not be mixed into purchased gift card performance because the customer behavior behind it is different.
Here is a clean way to think about it:
- Issued gift card value tells you how much prepaid balance customers bought
- Redeemed gift card or store credit value tells you how much stored balance customers used
- Merchandise sales tell you what shoppers actually bought
That three-bucket view gives OpoShop merchants a much more useful picture than one broad “gift cards” line in a report.
If you want your reporting setup to support retention goals too, read how gift cards can increase customer retention.
Need a cleaner home for that reporting structure in your OpoShop workflow? This is a good next step.
[[button:See reporting options|https://oposhop.io]]
How do you track gift card revenue separately from regular product sales?
The best way to track gift card revenue separately from regular product sales is to log issuance, redemption, and resulting merchandise sales as separate transaction types and review them on a schedule.
[[steps:Create separate categories|Set up distinct reporting buckets for gift card sales, gift card redemptions, store credit issuance, store credit redemptions, and merchandise sales.; Split mixed orders|If one checkout includes a gift card and physical products, break the order into separate reporting lines so the gift card sale does not inflate product revenue.; Log issuance and redemption events|Record when value is created and when value is used. Those are different business events and need different timestamps and totals.; Track store credit independently|Keep return-related credit in its own category so purchased gift cards and return balances do not get blended together.; Review reports weekly or monthly|Check outstanding balances, redeemed value, and merchandise sales created from redemptions on a recurring basis.]]
A mixed-cart example makes this easier to see. Say a customer checks out in your OpoShop store with a $50 digital gift card and a $30 physical product in the same cart. Your reporting should show $50 under gift card issued value and $30 under merchandise sales. It should not show $80 under product revenue.
Then later, if the recipient spends that $50 gift card on a $65 order, your reporting should show $50 under redeemed gift card value and $65 under merchandise sales, with the extra $15 paid by another method.
That split matters even more if your team exports orders from OpoShop and reviews them in a spreadsheet or BI tool. One line per order is usually too blunt. One line per transaction type is much closer to the truth.
Here is the weak version versus the stronger version:
Weak: “Gift card sales: included in total sales. Redemptions: included in total sales.”
Stronger: “Gift card sales: tracked as issued prepaid value. Redemptions: tracked as stored value applied to an order. Merchandise sales: tracked as products actually sold, including orders funded by gift card or store credit.”
That stronger version is what keeps your reporting usable six months from now, not just readable today.
Best ways to organize gift card, store credit, and product reporting
The best reporting setup is the one your team will actually maintain, but most merchants do well with one of three structures.
| Reporting setup | How it works | Best for | Watch out for |
|---|---|---|---|
| Separate sales categories | Each transaction type gets its own category in reports | Merchants who want simple recurring reporting | Categories need to stay consistent |
| Tagged transaction exports | Orders and balance events are tagged before export | Teams using spreadsheets or external reporting | Tags can get messy if naming is loose |
| Dashboard by transaction type | A dashboard shows issued value, redeemed value, balances, and merchandise sales in separate widgets | Operators reviewing trends every week | Dashboard logic needs clean source data |
For many OpoShop merchants, the easiest starting point is separate categories plus tagged exports. That gives you a simple on-platform view and a deeper view if you need to audit mixed orders, returns, or redemption patterns later.
The EverBee-style return case is where this really pays off. If a customer returns a product, your team approves the return, and the customer gets $60 in store credit, that $60 should land in a store credit issuance bucket. If the customer later uses $45 of that balance on a new order, that $45 belongs in store credit redemption, not gift card redemption.
That sounds fussy until you review a quarter of data and realize one bucket was hiding two very different behaviors.
Common mistakes when tracking gift card revenue
The most common mistakes are predictable, and they all lead to inflated or muddy reporting.
The first mistake is combining gift card purchases with merchandise sales. A prepaid balance is not the same thing as a product leaving inventory.
The second mistake is ignoring redemption data. If your team only tracks issued value, your team cannot tell whether gift cards are sitting unused or bringing customers back.
The third mistake is mixing store credit with gift cards. Customer-paid gift cards and merchant-issued return credit both create balances, but the business meaning is different.
The fourth mistake is failing to split mixed carts. If a shopper buys a gift card and a product in one OpoShop checkout, the report still needs two categories even though the customer saw one order.
The fifth mistake is reviewing only top-line sales. Top-line numbers are easy to glance at and easy to misread.
If your current setup is messy, do not overcorrect by building a giant reporting system all at once. Start with the three buckets. Clean beats fancy here.
What we recommend for GiftKit merchants
We recommend a three-bucket reporting structure: issued gift card value, redeemed gift card or store credit value, and merchandise sales created by those redemptions.
That structure is easy to explain to finance, easy to review in weekly ops, and much better for retention analysis. It also gives OpoShop merchants a cleaner way to answer practical questions like: Are gift cards bringing people back? Is store credit getting used quickly after returns? Are redemption orders larger than standard orders?
Keep customer-paid gift cards separate from merchant-issued store credit. Keep mixed orders split. Keep redemptions visible.
That is the whole game.
If your team wants a simpler way to keep issuance, redemption, and follow-on purchase activity organized, this is the natural next step.
[[button:Set up tracking|https://oposhop.io]]
Best answer: Use one reporting structure across your whole store: one bucket for issued gift card value, one bucket for redeemed gift card and store credit value, and one bucket for merchandise sales tied to those redemptions. That setup keeps accounting cleaner, makes OpoShop reporting easier to review, and gives your team a much clearer read on repeat-purchase behavior.
FAQs
Do gift card sales count as revenue before the card is redeemed?
Gift card sales should be tracked separately from product revenue before redemption. A gift card sale creates prepaid value and an outstanding balance, while merchandise revenue is tied to products or services actually sold.
How do I handle an order that includes both products and a gift card?
Split the order into separate reporting lines. The gift card portion belongs under issued gift card value, and the product portion belongs under merchandise sales, even if both were purchased in one checkout.
Should store credit be tracked the same way as gift cards?
Store credit should be tracked in a similar structure, but not in the same category. Store credit is usually merchant-issued after a return or service issue, while gift cards are usually customer-paid balances.
What is gift card liability in ecommerce?
Gift card liability is the unused gift card balance your store still owes to customers. Until that balance is redeemed or expires under your rules, it should not be treated the same way as earned product revenue.
How can I see whether gift cards are driving repeat purchases?
Track redemption events alongside the resulting merchandise orders. If redeemed gift cards lead to later purchases, larger carts, or returning customers in your OpoShop store, your reporting will show that gift cards are supporting retention instead of just sitting as unused balances.
Summary
The clean answer is to stop treating gift card activity as one number.
Track issued gift card value, redeemed gift card or store credit value, and merchandise sales as separate reporting buckets. Split mixed carts. Keep store credit separate from purchased gift cards. Review balances and redemptions on a schedule.
That gives your team cleaner accounting and a much sharper read on what gift cards are actually doing in the business.
Use GiftKit to keep gift cards and store credit organized so your team can track issuance, redemption, and repeat-purchase activity more clearly.
[[button:Organize gift card tracking|https://oposhop.io]]


