Copy-paste, ready-to-run SQL for PrestaShop, WooCommerce and Magento — and run them safely on a clone of your database, never on production.
Find your best-selling PrestaShop products by units sold and revenue.
Total valid PrestaShop order revenue grouped by month for trend analysis.
List customers who registered in your PrestaShop store in the last 30 days.
Find PrestaShop carts that were created but never converted into an order.
Surface PrestaShop products at or below a stock threshold so you can reorder.
Rank PrestaShop customers by lifetime revenue from valid orders.
Average lifetime spend per PrestaShop customer across all valid orders.
Share of PrestaShop customers who placed more than one valid order.
Split PrestaShop order revenue between first-time and returning buyers.
Best-selling WooCommerce products by quantity, from the order line items.
WooCommerce revenue grouped by month from completed and processing orders.
Rank WooCommerce customers by total spend across their paid orders.
Average lifetime spend per WooCommerce customer (by billing email).
Share of WooCommerce customers (by email) with more than one order.
Best-selling Magento products by ordered quantity and revenue.
Magento order revenue grouped by month from the sales_order table.
List Magento customers created in the last 30 days from customer_entity.
Average lifetime spend per Magento customer (by order email).
Share of Magento customers (by email) who ordered more than once.
21 templates and counting. Run them on your own data →