Costs above price
get_cost_above_priceVariants sold in the period whose recorded unit cost is at or above their list price without VAT — a cost Nuira does not believe, so it estimates it instead: label, realisedUnitPrice (what it actually sold at), listPrice and listPriceExVat, recordedUnitCost (on the order) and catalogueCost (in Shopify now), units, the cogs counted for them and costedRevenue. state check_cost = the cost in Shopify still looks wrong, fix it there; corrected = the catalogue has been fixed since. windowCogs is the period's whole COGS, to size the problem. Use for 'are my costs right', 'why is the margin of product X so low', or 'which products sell below cost'. Optional from and to (inclusive YYYY-MM-DD, both or neither, never after today) read another span instead of the default period. A named month, a week or two dates the operator gave MUST be sent here: without them this reads the last 30 days, which is not that month.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| to | No | Last day of the span, inclusive, as YYYY-MM-DD; not after today. Send together with `from`, or omit both to read the default 30-day period. | |
| from | No | First day of the span, inclusive, as YYYY-MM-DD. Send together with `to`, or omit both to read the default 30-day period. |