Support › Reports

Report: Margin and prices

Short answer

Shows whether you're making money on what you sell. Your average margin over time, items below cost or your floor and why, why prices changed, and EJD's biggest cost increases.

This report answers "am I making money on what I sell, and what's squeezing it?" It comes with Growth.

  1. Open Reports and select Margin and prices.
  2. Pick a period at the top: Last 30 days, Last 90 days or Last 12 months.
  3. Read the sentence at the top, for example "Average margin held at 31% over the last 30 days. 42 items are below your 20% floor: 30 after EJD raised costs."

Margin here is margin on price: (your price minus EJD's cost) divided by your price, across live EJD items.

What's on it

  • Average margin, with the change over the period.
  • Below cost or margin-protected price: items selling below EJD's cost, or below the price margin protection would set at today's cost.
  • Price changes applied, split into up and down, and EJD cost increases, with the average rise.
  • Price overrides: how many you have, with a link to manage them on Products.
  • Average margin chart, with your floor drawn across it. For days before the app's first daily record, the line is an estimate worked back through the price and cost changes the app applied. The chart's description says when that applies.
  • How your margins spread: items grouped in 5-point steps. Red bars are below your floor.
  • Price changes, by reason: the rule that set each price the app changed.
  • Margin by department: for each department, how many priced items it has, its share of your catalog, its average margin, how many items are below cost or the margin-protected price, how many have a thin margin at EJD's price, and how many show sold out. Select Brand to see the same by brand. Select a department or brand to open its items on Products, lowest margin first. The CSV has every department or brand.
  • Below cost or the margin-protected price: each item with EJD's cost, your price, your margin, the margin-protected price, and why. Below it, Thin margin at EJD's price lists items at EJD's suggested price whose margin is under your floor, for information. Each table has its own CSV. See Items below the margin floor.
  • Biggest cost increases from EJD: by percent over the period, with the cost per each before and now, your price and your margin now. A case listing's price is for the case, so its margin uses the cost times the case size.
  • Price changes applied: the newest price changes the app made, with the price before and after, the change, the reason, and when. Select the date to open the catalog run. The CSV has every change in the period, with EJD's cost at the time and whether it was undone later.

Reasons a price changed

  • EJD's suggested price: EJD changed its recommended price (RRP).
  • Margin floor: cost met or passed the recommended price, so margin protection set the price.
  • Department rule: a pricing rule for the item's department set it.
  • Minimum advertised price: EJD's MAP kept the price from going lower.
  • Your override: a price override set it.
  • Raised from below cost: your store's price was below EJD's cost, so the run raised it. See Never below cost.

Use it to

  • See when a cost increase started squeezing an item. Each product's page also has a Price and cost history chart for that item.
  • Find the departments where margins are thin, then set a pricing rule for the department.
  • Check whether a price override is still needed.
  • Spot brands or departments where EJD raises cost often. Download the cost increases as a CSV and sort it in a spreadsheet.
  • Hand your bookkeeper what prices did in a period: download Price changes applied as a CSV.

Related

Still stuck? Open Help and support inside the app to ask about your own store or write to a person.