Report: Items below the margin floor
This list shows items selling below EJD's cost or below the price margin protection would set, why, and the price that fixes each. The next run raises most of them unless you set an override.
The Margin and prices report has two lists. Only the first one is something the app acts on.
- Below cost or the margin-protected price: items selling below EJD's cost, or below the price margin protection would set. The next run raises these, unless a price override holds them down.
- Thin margin at EJD's price: items at EJD's suggested price whose margin is under your floor. This list is for information only. Margin protection only steps in when EJD's cost meets or passes the suggested price, so the app leaves these alone. Set a price override or a department rule if you want more on them.
- Open Reports and select Margin and prices.
- Scroll to Below cost or the margin-protected price. The lowest margin is first.
- Each row shows the SKU, the item, EJD's cost, your price, your margin, the margin-protected price, and why the item is there. Select the SKU to see the item's history on Products.
- For each item, set or change a price override under Price overrides on Products, pull the item, or keep it if you accept the loss.
- When there are more items than the screen shows, Download CSV gets all of them.
Why an item is on the first list
- Selling below EJD's cost: EJD's cost is at or above your price.
- Your price override: a price override you set is under the margin-protected price.
- Your override, after EJD raised its cost: the override was fine until EJD raised its cost in this period.
- EJD raised its cost: EJD raised the cost in this period and the price hasn't caught up yet.
- Price is under the margin-protected price at today's cost: none of the above, but the price is still under what margin protection would set. The next run raises it.
On the Thin margin at EJD's price list, the reason is EJD's suggested price leaves a thin margin.
For a case listing, the cost is the case's cost (the cost of one item times the case size), so the margin compares like with like.
Each catalog run also raises an alert for any override below the floor (WARN_OVERRIDE_BELOW_FLOOR). It shows on Home with a link to Products.
The Margin and prices report comes with Growth. See Report: Margin and prices.