Skip to content
Hypamoon

For teams that run on Odoo

Odoo slow moving stock: a monthly list with value

Odoo shows what you have in stock and every move in and out. Finding the products that sit on the shelf, and how much money is tied up in them, means grouping the moves by product, checking the last sale and adding the stock value by hand.

How it goes today

  1. Filter the done deliveries to customers and group them by product.
  2. Note the last date each product went out.
  3. Export the stock on hand with its value and match the two lists.
  4. Sort by value and decide by eye what to discount or return.

How it can go

The stock that does not sell, with what it is worth.

Once a month you get a list of products that are in stock but have not gone to a customer in 90, 180 or 365 days, per warehouse, with the quantity, the stock value, the last sale date and the last purchase date. The list is sorted by value, so the money tied up is at the top. Products you mark as seasonal are left out.

Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. You paste your Odoo key in the portal, never in the chat.

Your request

With Hypamoon, on the first of each month, list the products in Odoo that have stock but no delivery to a customer in the last 90, 180 or 365 days, per warehouse. Show the quantity, the stock value, the last sale date and the last purchase date, sorted by value. Leave out the products I mark as seasonal and email me the list with a spreadsheet.

You create an Odoo API key yourself under Preferences, Account Security, for a user with the access you want to give. A key lasts at most three months, so you renew it in the portal. On Odoo Online and Odoo.sh this needs the Custom plan. It stays yours.

More for teams on Odoo