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.
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.
14 templates and counting. Run them on your own data →