Discount Profitability Calculator

Upload your Shopify product export to instantly evaluate whether a discount campaign remains profitable across three discount tiers.

Global Cost Settings

Applied uniformly across all SKUs to avoid per-SKU entry.

Rs.
%

Upload Product Export

Export from Shopify Admin → Products → Export → All products → CSV (plain). Must include Cost per item.

Drag & drop your CSV here

or click to browse — .csv files only

🔒 Processed in your browser. No data uploaded.

How this calculator works

1

Upload your Product CSV

Export your products from Shopify (ensuring costs are filled in) and drop the file here.

2

Set global shipping & fees

Enter your average Shipping Cost and Payment Gateway Fee % to calculate your actual true costs.

3

Adjust discount tiers

Edit the three discount % tiers at the top of the table to instantly simulate different sale scenarios across your entire catalogue.

Key Assumptions

1
Requires standard Shopify CSV format with columns: Title, Variant SKU, Variant Price, Cost per item.
2
SKUs with missing costs cannot have profitability calculated and will be skipped.
3
Gateway fee is calculated against the discounted sale price, not the original price.

How to use this tool

1

Export from Shopify

Go to Shopify Admin → Products → Export (choose "All products" and "CSV").

2

Upload and configure

Drop the file into the upload area above and set your global shipping and gateway costs.

3

Analyse and print

Review the colour-coded dashboard to spot at-risk SKUs. Use "Print Report" to save a PDF for your team.

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

A standard Shopify Product CSV export. It must include Cost per item, Variant SKU, and Variant Price.
Yes, 100% secure. Everything runs locally in your browser. No product or cost data is ever sent to our servers.
Each D2C category has different margin expectations (e.g. Beauty needs >50% gross margin, Electronics much lower). The vertical dropdown adjusts the green/amber/red thresholds to match your industry standards.

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