HawklifyConnect your Odoo

Inventory valuation in Odoo: what your stock is worth

Set the costing method in Odoo, see where a product's cost comes from, and read the value of everything in stock, product by product. Community and Enterprise.

Stock shelves with a price tag and the total value of the stock in Odoo.

Your accountant asks what the stock is worth at the end of the month. The answer is not the sales price of everything on the shelves: it is what the goods cost you. In Odoo, every product carries a cost, the costing method decides how that cost follows your purchases, and one report adds it all up. This guide sets the costing method, checks a product’s cost, and reads the value of the stock.

It works the same in Community and Enterprise. The versions we tested are listed at the end.

This guide is also an AI tutorial. At the end, an AI assistant connected to Odoo finds the dead stock on your shelves and the money stuck in it, prepares a clearance price list after your approval, and stops a slow product from being reordered.See it in action ↓

Before you start

  • The Inventory and Invoicing (or Accounting) apps installed, with products in stock. Here, six products of the category Living.
  • An Odoo user with the Inventory / Administrator access right.

1. The costing method

The costing method is set on the product category. Open Inventory → Configuration → Categories and open Living.

Set Costing Method to Average Cost (AVCO): every purchase updates the product’s cost with the price you paid. Save.

The Living category with Costing Method Average Cost One setting for every product of the category.

2. The cost of a product

Open Inventory → Products → Products and open the Walnut Sideboard. The Cost field is the value of one unit: $380.00. The Sales Price, $790.00, plays no part in the value of the stock.

The Walnut Sideboard with its cost of 380 dollars The cost, not the price, values the stock.

With Average Cost, you don’t type the cost: Odoo computes it from the purchases you receive.

3. The value of your stock

Open Inventory → Reporting → Stock and pick Living in the Category panel on the left. Each line shows the Unit Cost, the Total Value and the quantity On Hand. The total at the bottom is the value of the category: $16,810.

The stock report of the Living category with unit cost, total value and quantity on hand $16,810 of furniture on the shelves.

Group by category, or remove the panel filter, to see the value of the whole warehouse.

Common mistakes

  • Products without a cost. A product with an empty cost is worth zero in the report. Check the Unit Cost column for zeros.
  • Changing the method in the middle of the year. Odoo revalues the stock the moment you change it. Do it at the end of a period.
  • One category for everything. The costing method is per category: put the products you buy at changing prices in an Average Cost or FIFO category.
  • Reading the value as profit. The report says what the stock cost you, not what it will sell for, nor how long it has been sitting there.

Inventory valuation with AI: ask your AI assistant through MCP

With the Hawklify MCP server, Claude, ChatGPT and other assistants work in your Odoo as you, with your permissions. The stock report shows what you have, not what’s stuck. Products that haven’t moved for months tie up your money, and finding them means opening the history of every product. The assistant checks every last move, and prepares the clearance prices in a card you approve: card mode is on here.

Dead stock ⌄Card mode
Which products in stock haven't moved for six months? How much money is stuck in them? Prepare a clearance price list at 30% off for those.
✓Searched 6 products in stock in Odoo›
✓Searched their last stock moves in Odoo›

3 products haven't moved since before May 14, $10,030.00 at cost:

  1. Walnut Sideboard: 14 at $380.00, $5,320.00, last move March 2.
  2. Glass Coffee Table: 22 at $145.00, $3,190.00, last move February 10.
  3. Velvet Pouf: 40 at $38.00, $1,520.00, last move April 20.

The Leather Armchair last moved on May 30: slow, not dead. Oak Bookcase and Brass Desk Lamp move every week.

✓Prepared the change in Odoo›

Approval needed in OdooCreate

Create the price list Clearance -30% with 30% off the three products that have not moved for six months: Walnut Sideboard, Glass Coffee Table, Velvet Pouf.

product.pricelist · 1 record

New price list

FieldCurrentNew
Pricelist NameClearance -30%
Price Rules30% off: Walnut Sideboard, Glass Coffee Table, Velvet Pouf
Approve and runRejectExpires in 3:59:59

Change applied in Odoo.

Organisation administrators can turn the approval cards off on the Members page.

Approved.

The price list Clearance -30% is ready: the three products at 30% off. Use it on a quotation or in your shop when you run the promotion.

AI app on the computer · Card modeEvery product's last move checked: $10,030 stuck on the shelves, and a clearance price list created after one approval.

On the stock report. In a side panel of the browser, the assistant starts from the report you are reading: a slow product that Odoo would still reorder, compared with its real sales, and its reordering rule fixed once you say yes.

The stock report of the Living category with unit cost, total value and quantity on hand
✳ AssistantSmart mode
The Leather Armchair is slow. Will Odoo buy more of them anyway?
✓Read the armchair's sales and reordering rule in Odoo›

Yes. Its reordering rule says min 4, max 10, and you sold 2 in six months. With 6 on hand, three more sales would trigger an order of 7 more armchairs, $3,640 at cost.

Shall I lower the rule to min 1, max 3?

Yes, do it.
✓Updated the reordering rule of the Leather Armchair in Odoo›

Done. The Leather Armchair now reorders only below 1, up to 3. With today's 6 on hand, Odoo won't buy any for months.

AI side panel in the browser · Smart modeOn the stock report: a slow product that Odoo would still reorder, and the rule fixed in one go.Works with AI assistants that run in a browser side panel and can use MCP connectors.

Versions we tested

Version Result
Odoo 16 Same steps. The menu is Product Categories, and the category also shows Inventory Valuation: Manual or Automated.
Odoo 17 Like 16.
Odoo 18 Like 16.
Odoo 19 As in this guide. Inventory at Date in the stock report shows the value on a past date. The screenshots come from Odoo 19.
Odoo 20 Same steps. The costing method is in the category’s Accounting tab, for users with accounting access. The stock report has an Inventory at Date panel.

Frequently asked questions

Standard Price, Average Cost or FIFO?

Standard Price keeps the cost you type. Average Cost updates it with every purchase. FIFO values each unit at the price it was bought. Average Cost is the simplest choice when purchase prices change.

Can I change the costing method later?

Yes, but Odoo revalues the products in stock at that moment. Change it at the end of a period, and tell your accountant.

Why is the Total Value zero for some products?

Their Cost is empty. Fill in the Cost on the product, or receive a purchase with Average Cost or FIFO.

Do I need Odoo Accounting?

No. Inventory with the Invoicing app is enough for the costing method and the stock value. Accounting adds the journal entries of the stock, for automated valuation.

Questa guida è disponibile anche in italiano: Valorizzazione magazzino Odoo: quanto vale davvero