Revenue is not the same as profit. A Shopify Orders CSV can help you identify products worth investigating without giving a third-party app access to your store. The result is a screening estimate, not a replacement for processor payouts, bookkeeping or tax records.
1. Export the correct orders
In Shopify Admin, open Orders and use Export to obtain an Orders CSV for a defined period. Use Shopify's official export instructions. Keep the unmodified export secure: it may contain personal customer information.
Choose a single reporting period and confirm that the export reflects the currencies, order status, refunds and products you intend to assess. If the export includes multiple currencies, convert through an auditable source before calculating a unified USD result; do not silently treat one currency as another.
2. Start with net merchandise revenue, not order totals
For each product, begin with merchandise sales after discounts and associated refunds. Exclude sales taxes collected for tax authorities from business income calculations. Shipping amounts collected from customers and shipping expenses need separate treatment: don't subtract shipping costs without accounting for any shipping revenue.
Check each order's financial status and avoid counting unverified or pending payments as settled money. Refunds, partial refunds, gift cards and multi-item orders can complicate row-by-row calculations.
3. Add the missing expenses
- Product cost: supplier or manufacturing cost per SKU, adjusted for quantities and any freight or packaging you include.
- Payment cost: actual processing, currency-conversion and transaction charges from your payment reports.
- Order fulfillment: postage, picking and packing expenses where applicable.
- Acquisition: advertising spending attributed to the same period or order group, with a clear attribution method.
- Refund losses: refunds, return postage and unrecoverable goods costs.
Shopify Orders CSV exports do not contain every business expense. If a SKU's supplier cost or its share of advertising expense is unknown, mark the estimate incomplete rather than presenting it as verified profit.
4. Calculate estimated contribution, then reconcile
One simplified illustration: $50 merchandise price, $5 discount, $12 product and packaging cost, $4 fulfillment expense, $1.65 processing fee and $8 attributable advertising expense.
Estimated contribution: $50 − $5 − $12 − $4 − $1.65 − $8 = $19.35.
That is before any other overhead, additional refunds, taxes on earnings, and adjustments not included in the example. Verify your actual business numbers rather than using these illustrative assumptions.
5. Look for risk, not just a profit ranking
Start with three questions: Which SKUs are missing cost data? Which products have potentially negative contribution after their known expenses? Which orders include refunds or inconsistent financial statuses that make estimates unreliable? Answering those questions can be more valuable than a polished but misleading dashboard.
6. Keep customer data private
Never post real order exports to public forums or untrusted calculators. Use fictional demonstration files when evaluating software. Check a tool's privacy and storage behavior before importing data, especially if it asks to connect directly to your store or upload a complete customer export.
ATLAS Offline Profit Audit — available now
The ATLAS Offline Profit Audit ($29 USD) is now available as a one-time downloadable browser-local screening utility. It analyzes supported USD Shopify Orders CSV exports alongside a merchant-provided SKU cost file, flags missing cost inputs and estimated contribution concerns, and lets you export a review CSV without granting access to your Shopify Admin or APIs.
Results are preliminary estimates, not verified net profit or financial statements. Payment fees, refunds, taxes, shipping, advertising and overhead may require additional evidence and reconciliation. Read the supported input format, restrictions and delivery details before ordering. Do not send confidential order exports through the contact form.