Hi, 

Follow the steps to get the pos session report (product category-wise).

1- Point of Sale > Reporting > Orders.  

2- Add custom group ( Session and Product category).

3 - Session Report can be seen as follows.

Graph view

Pivot View

You can export the data into Excel as shown in the image below.

Hope it helps.

Odoo’s Default Behavior

In standard Odoo 18 POS, the Session Summary Report shows:

• Total sales,
• Payments by method,
• Taxes,
• Cash in/out movements,
  but does not group sales by product category out of the box.

You can see sales by product in the backend (POS > Orders > Reporting), but category-based grouping in the session report needs customization.

Step-by-Step Ways to Achieve This

 1. POS Sales Report by Category (Manual)

• Navigate to Point of Sale > Orders > Reporting > Orders.
• Use Group By > Product > Product Category.
• Export if needed.

(✅ Good for manual reporting, ❌ not automatically tied to session closing.)

 2. Customizing the POS Session Report

You can create a custom module or override the session closing logic to:

• Group order lines by product_id.categ_id
• Summarize quantity and amount per category
• Display this in the closing report or in a custom dashboard.

Technical steps:

• Extend pos.session model.
• Aggregate order lines on session close.
• Add computed fields or JSON field to store category-wise sales.