Odoo POS · Loyalty Point Engine

POS Order → Member Point Report Generator

Import a single Odoo POS Orders RAW export. The 5-segment pipeline rebuilds the Edited sheet, splits product categories, pivots each group per order, calculates member points (including birthday doubling and point deductions), generates the Partner ID domain script, and exports one styled workbook.

1. Import POS Order export

Export Point of Sale → Orders (with order lines) from Odoo as .xlsx, then drop it here.

How this works — the 5 segments

Template example — required POS export headers (Column A–L)