SQL query templates for your store

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.

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.

Get the exact number of rows in any table in your database.

Surface values that appear more than once — duplicate emails, SKUs, order references.