Discount Leakage Detector

Upload your Shopify orders CSV to instantly detect discount stacking, repeated code use, and margin-draining leakage. 100% client-side privacy.

Configure Your Threshold

Orders above this effective discount % will be flagged as over-discounted.

%
Default is 30%. Set this to match your highest intended discount level (e.g. 20% for a flash sale).

Upload Shopify Orders Export

Export from Shopify Admin → Orders → Export → Orders by date (last 30 days) → CSV (plain). No reformatting needed.

Drag & drop your CSV here

or click to browse — .csv files only

🔒 All processing happens in your browser. No data is uploaded or stored.

How this detector works

1

Upload your CSV

Drag and drop your Shopify orders export. The tool instantly parses the file in your browser.

2

Configure your threshold

Set your maximum planned discount % so the tool can flag over-discounted orders accurately.

3

Review the flagged orders

See a breakdown of leakage types, the top codes causing margin loss, and a line-by-line list of flagged orders.

Key Assumptions

1
Requires standard Shopify CSV format with columns: Name, Email, Discount Code, Discount Amount, Subtotal, Total, Created at.
2
Analysis is limited to the most recent 30 days of data within the uploaded file.
3
File size is capped at 5,000 recent orders to ensure instant browser performance.

How to use this tool

1

Export from Shopify

Export your last 30 days of orders as a CSV from your Shopify admin.

2

Upload the file

Drop the CSV into the upload area above.

3

Analyse the results

Review the breakdown cards and print the report for your team if needed.

Why this matters for referral

Planning is great, but real data is better. Referbro gives you actual attribution from day 1.

Learn about referral

Frequently Asked Questions

It flags 4 scenarios: 1) Discount stacking (multiple codes or compounding), 2) Repeated code use by the same email, 3) Codes applied to already-discounted items (effective % too high), and 4) Orders exceeding your maximum planned discount threshold.
Yes, 100% secure. The CSV is parsed entirely in your browser using local JavaScript. No order data is ever uploaded to a server or stored.
Go to Shopify Admin → Orders → Export. Choose "Orders by date" (last 30 days recommended) and export as "CSV for Excel, Numbers, or other spreadsheet apps".

Ready for real data?

Planning is great, but real data is better.
Referbro gives you actual attribution from day 1.

Install on ShopifyBook a demo