IQ
ProfitIQby My Code Magic
Help Center

Everything you need
to master ProfitIQ

Complete documentation, feature guides, troubleshooting, and more.

Getting started

Quick Start

1

Install from Shopify App Store

Search for ProfitIQ and click "Add app". Approve the read-only permissions (orders, products, shipping, customers). Shopify handles authentication — no API keys needed.

2

Wait for initial sync

ProfitIQ automatically syncs your last 60 days of orders and all products. For most stores this completes in under 60 seconds. You'll see orders appear in the Orders tab in real time.

3

Set a global COGS default

Go to Settings → COGS → Global Default. Enter a rough cost percentage (e.g. 30%). This gives every unconfigured product a baseline cost immediately so your dashboard shows profit estimates right away.

4

Fill in exact COGS per variant

Go to Products → COGS. For each product variant, enter the exact cost. You can import in bulk via CSV. The global default covers anything you haven't manually set.

5

Configure shipping and fees

Go to Settings → Costs. Enter your average carrier cost per order and your payment processor fee (percentage + fixed). These are deducted from every order automatically.

6

Verify with a test order

Open a known order in the Orders tab and check the cost breakdown: Revenue − COGS − Shipping − Fees = Net Profit. If the numbers match your records, setup is complete.

Profit formula

How Profit Is Calculated

Gross Revenue
Order subtotal + shipping charged to customer
− Discounts
Discount codes applied at checkout
=
= Net Revenue
The revenue ProfitIQ uses as the base
− COGS
Your product cost per variant
− Shipping Cost
What you paid the carrier (not what the customer paid)
− Transaction Fee
Payment processor fee (% + fixed)
− Custom Costs
Monthly overhead, proportionally allocated
=
= Net Profit
What you actually made on this order
Custom Costs are monthly fixed costs (warehouse, subscriptions, etc.) distributed proportionally across all orders in a period. They affect aggregate P&L figures but are not shown in individual order breakdowns.

Features

Feature Guide

Dashboard

The Dashboard shows your store's profit KPIs for any date range: revenue, net profit, gross margin %, and average order value (AOV).

Use the date picker to compare periods (e.g. this month vs. last month). Trend sparklines show the direction of each metric.

The chart at the top shows daily revenue and net profit bars. Hover any bar to see the exact values for that day.

Orders

The Orders tab lists every synced order with revenue, net profit, and margin. Click any column header to sort.

Click an order to open the detail view — a full cost breakdown showing exactly how each component (COGS, shipping, fees) reduces the gross revenue to net profit.

Use the status filter to view only profitable or unprofitable orders. Mark individual orders as excluded to remove them from profit calculations (e.g. test orders, wholesale).

Products & COGS

Products → COGS shows every product and variant from your Shopify store. The 'Coverage' column shows what % of recent orders have a COGS value.

Click any variant to edit its cost. Add date-range rules if your cost changed over time — each rule applies to orders within its date range.

Use Import CSV to bulk-update COGS. Download the template, fill in Product Title, Variant Title, and COGS, then upload.

Reports & P&L

The P&L report generates a formal profit and loss statement for any month: gross sales → discounts → net sales → COGS → gross profit → operating expenses → net profit.

Available on Advanced and Ultimate plans. Export as CSV or print as PDF for your accountant.

Monthly P&L data is also shown as a year-at-a-glance table — handy for comparing seasonal performance.

Attribution

Attribution shows which UTM source, medium, and campaign values generated orders in a given period — and critically, how profitable those orders were.

Unlike Shopify's marketing reports, ProfitIQ focuses on profit per channel, not just revenue. A channel driving high revenue but low-margin orders costs you money.

Available on Advanced and Ultimate plans.

Automation Rules

Create rules that trigger when conditions are met — e.g. 'margin < 10%' or 'profit < $5'. Actions: send email, Slack message, or HTTP webhook.

Rules evaluate in real time as orders sync. You can catch an unprofitable order the hour it arrives — not at end-of-month review.

Available on the Ultimate plan.

Getting the most out of ProfitIQ

Pro Tips

Set COGS before reviewing P&L

A P&L report is only meaningful when COGS coverage is >90%. Check the Data Quality report first and fill gaps before running monthly reviews.

Use date-range COGS rules for seasonality

If your supplier raised prices, add a date rule reflecting the new cost. This way historical profit isn't affected and current orders use the new cost automatically.

Filter by unprofitable orders weekly

In the Orders tab, filter by margin < 0%. Review these weekly. Unprofitable orders often reveal systemic issues: wrong COGS, unexpected shipping zones, or deep discounts eroding margin.

Exclude test and wholesale orders

Mark test orders or wholesale orders as 'excluded' in the order detail view. They'll be removed from your profit calculations without being deleted.

Use Share Links for accountants

Generate a time-limited Share Link to a P&L report. Your accountant gets read-only access to the specific report without needing an account. Available on Advanced+ plans.

Automate margin alerts

Set an automation rule for margin < 15%. Every time an order falls below your floor, you get an instant alert. This is more actionable than a monthly review.

Common issues

Troubleshooting

Orders not appearing in ProfitIQ
  • Check that the order is not cancelled or archived in Shopify.
  • Verify the order is within the synced date range (last 60 days for new installs).
  • Go to Settings → Sync Status and check for any sync errors.
  • Contact support if orders from the last 24 hours are missing — there may be a webhook delivery issue.
Profit showing as $0 on all orders
  • No COGS is configured. Go to Products → COGS and add cost prices.
  • Set a global COGS default in Settings → COGS to cover all products immediately.
  • Check that the correct currency is configured in Settings → General.
Revenue in ProfitIQ doesn't match Shopify
  • ProfitIQ uses gross order revenue. Shopify Analytics may use different accounting for refunds, taxes, or gift cards depending on your region.
  • Check if refunded orders are included in both views — in ProfitIQ, they're included but flagged.
  • Verify your store's currency setting matches in both Shopify and ProfitIQ Settings.
Team member can't log in
  • The invitation email may be in their spam folder — check there first.
  • Invitation links expire after 48 hours. Resend from Settings → Team → Resend Invite.
  • Team members must have a Shopify partner account associated with the email used in the invitation.
CSV COGS import failed
  • Download the template from Products → COGS → Import CSV → Download Template.
  • Check that Product Title and Variant Title exactly match what's in ProfitIQ (they're case-sensitive).
  • Ensure COGS values are numeric — no currency symbols or commas in numbers.
  • The file must be UTF-8 encoded CSV. Excel may save as a different encoding — use 'Save As → CSV UTF-8' when exporting.
If none of these resolve your issue, email info@mycodemagic.com with your store URL and a description of the issue. We typically respond within 24 hours.

Access control

Team & Roles

Owner
  • View reports and dashboard
  • Edit COGS and costs
  • Manage team members
  • Manage billing
  • Uninstall ProfitIQ

Only the store owner can be the ProfitIQ Owner. Ownership cannot be transferred.

Admin
  • View reports and dashboard
  • Edit COGS and costs
  • Manage team members
  • Manage billing
  • Uninstall ProfitIQ

Admins can manage all content and other team members, but cannot change billing or uninstall.

Analyst
  • View reports and dashboard
  • Edit COGS and costs
  • Manage team members
  • Manage billing
  • Uninstall ProfitIQ

Read-only access to all reports. Useful for accountants and junior marketing team members.

Terms explained

Glossary

COGS
Cost of Goods Sold. The direct cost of producing or purchasing the product sold in an order.
Net Profit
Revenue minus all costs: COGS, shipping, transaction fees, and custom costs.
Gross Margin
Net Profit divided by Net Revenue, expressed as a percentage. E.g., $20 profit on $100 revenue = 20% margin.
AOV
Average Order Value. Total revenue divided by the number of orders in a period.
LTV
Customer Lifetime Value. The total net profit generated by a customer across all their orders.
Attribution
Tracking which marketing channel (UTM source/medium/campaign) drove each order.
COGS Coverage
The percentage of orders that have a COGS value set for all line items. Aim for 95%+ for accurate profit figures.
Overage
Orders synced above your plan's monthly limit. Billed at the plan's per-order overage rate at end of billing cycle.
MCP
Machine Context Protocol. An API standard that lets AI assistants (Claude, ChatGPT) query ProfitIQ data in natural language.
P&L
Profit and Loss statement. A formal financial report showing all revenue and expenses for a period.
Webhook
A real-time HTTP callback from Shopify to ProfitIQ when an order is created, updated, or fulfilled.
Share Link
A time-limited public URL granting read-only access to a specific ProfitIQ report. No login required.

Couldn't find what you need?

Our support team is happy to help with anything not covered here.