Skip to main content

​
When To Use This Report

Use Product Margin when sales look healthy but profitability needs explanation.
  • Find loss SKUs and best-margin SKUs.
  • Compare margin by SKU, category, sales channel, or customer.
  • Include or exclude allocated shipping cost when you want to see margin both ways.
  • Open the related order or product from the report.
  • Export line-level detail for purchasing, pricing, or finance review.

​
Choose Filters

  • Window: review the last 7, 30, 90, 180, or 365 days.
  • Group by: summarize by SKU, category, sales channel, or customer.
  • Sort by: show worst loss first, best margin first, highest volume first, or lowest margin percent first.
  • Shipping cost: include allocated shipping cost when you want shipping to reduce product margin.
Use the shipping toggle intentionally Excluding shipping gives a cleaner SKU view. Including shipping helps explain whether fulfillment cost is changing the real profit picture.

​
Read Summary Tiles

  • Total margin: margin dollars in the selected window.
  • Revenue: line revenue represented in the selected window.
  • Loss SKUs: SKU count with negative margin, with the worst SKU shown when available.
  • Best SKU: SKU with the strongest margin contribution.

​
Review Missing Margin

If the report shows lines without computed margin, those rows are excluded from average margin percent. Review the affected products and set the correct unit cost before using the margin percent as a final decision point.

​
Read The Detail Tables

The By group table rolls up lines by your selected grouping. SKU rows can link to the product when a product record is available. The Line items table shows order, SKU/product, units, revenue, unit cost, optional allocated shipping, margin, margin percent, and fulfilled date. Use it to confirm whether a margin issue is pricing, cost, shipping, discounting, or product setup.

​
Common Blocks

  • No margin data this period: widen the window or confirm orders were fulfilled in the period.
  • Margin percent is blank: the line may not have a usable cost or revenue baseline.
  • Loss SKUs look surprising: inspect price, discounts, unit cost, returns, and shipping inclusion.
  • Export is disabled: load report rows first, then export the current result set.

Analytics Dashboard

Use operational report links for freight, listing, margin, and exception review.

Shipping Margin

Review package-level shipping margin by carrier, status, and order.

Product Types and Costing

Understand cost basis, FIFO layers, product value, and recost repair behavior.

Pricing Rules

Configure quantity breaks, customer pricing, and multiplier rules.