Google Sheets Order PrestaShop 8-9 | Orders, KPIs, VAT, SLA | OpenPresta

OpenPresta Google Sheets Order Control Room — Orders, Lines, KPIs, VAT & SLA in One Sheet

A live order dashboard inside Google Sheets: every order, every line, every KPI, every VAT breakdown, every shipping SLA. Your whole team — accounting, ops, marketing, customer service — works from one shared sheet. Change an order status in the sheet, the shop follows. No more CSV exports, no more SQL queries, no more waiting for a report.

• 5 sheets in one spreadsheet - Orders, OrderLines, KPIs, VAT, SLA
• Two-way status sync - change a status in the sheet, the shop follows instantly
• Event-sourced order log - every order event (created, paid, shipped, refunded) logged as a row
• Line-item detail sheet - one row per order line, pivot-friendly in Sheets
• Live KPI dashboard - revenue, orders, avg basket, top products, top customers
• Per-country VAT breakdown - monthly compliance-ready report by country and rate
• SLA tracker - paid → shipped delay per order, with color-coded flags
• Real-time hooks - orders flow in the moment they happen, no waiting for a cron
• Delta push - only changed orders are rewritten, not the whole sheet
• Tracking column writable - paste a tracking number, it's saved on the order
• Internal notes column - staff write notes in the sheet, they're saved as order notes
• Multi-shop aware - all shops visible in one sheet, filterable
• Deletion-safe - deleted orders stay in the sheet with a flag, no history loss
• Privacy mode - anonymize customer names and emails when needed
• Automatic cosmetics - money format, conditional colors, protected columns
• Compatible with PrestaShop 8 & 9 - Symfony + Twig architecture, PHP 7.4+
• No core file changes - works exclusively through hooks, upgrade-safe
• Lightweight - zero external dependencies, vanilla JS, minimal requests