Margin report
margin_report[Analysis] Margin of the products actually sold on a marketplace in a period, line by line and per product: sale price without VAT, the real commission from the statement, the real courier cost of the order from the shipping invoices (shared between its lines by value), the product cost from the company system (Odoo, by barcode or SKU) and what is left, in money and percent. Lists the products sold at a loss or under the margin floor, the lines without a known cost, and returns in the period. Statements and courier invoices where the marketplace has them (Trendyol); elsewhere the finalised orders with the commission of the rules.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| account | No | Account id, label, domain or "channel country" (e.g. "emag ro"). Optional when only one account is connected. | |
| date_to | No | YYYY-MM-DD. Default: yesterday. | |
| date_from | No | YYYY-MM-DD. Default: 30 days ago. | |
| cost_field | No | Which Odoo cost: the main supplier price (default, what the factory charges) or the standard price. | |
| cost_source | No | auto (default): the pricing app (materials + factory labour) where the seller connected it, else Odoo. odoo: the transfer price in Odoo. | |
| vat_percent | No | Default 21. | |
| cost_account | No | The company-system account with the product costs. Default: the Odoo account that knows the barcodes. | |
| min_margin_percent | No | Floor under which a product is flagged, in % of the price without VAT. Default 10. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||