Any Mysql experts to help contstruct a Mysql statement ?

[gray]

Any Mysql experts to help construct a Mysql statement ?

I used to have a brilliant little module to do a task, which was to list all products and quantities within a certain date range, that were tagged as 'Payment Recieved'

Unfortunatly that module has not been maintained for the last couple of years.

So I am asking if there are any Mysql experts to help construct a Mysql statement to do that task.

 

[4presta]

Hi.

I'm happy to help for free 😉

Edited January 29 by 4presta (see edit history)

[wepresta]

2 hours ago, gray said:

Any Mysql experts to help construct a Mysql statement ?

I used to have a brilliant little module to do a task, which was to list all products and quantities within a certain date range, that were tagged as 'Payment Recieved'

Unfortunatly that module has not been maintained for the last couple of years.

So I am asking if there are any Mysql experts to help construct a Mysql statement to do that task.

 

d

Edited January 29 by wepresta (see edit history)

[PrestaHeroes.com]

Hey, if you can attach the module here I can update it to work.  Also make sure to include your prestashop version.

I would need to know payment received order stat id.

or

from phpmyadmin or ps sql manager

First, get the order_state ID(s)

SELECT id_order_state, name
FROM ps_order_state_lang
WHERE name LIKE '%Payment%' OR name LIKE '%Received%';

 

Use those IDs in this report query

This returns product + total qty for orders whose current status is “Payment Received”, within a date range:

SELECT
  od.product_id,
  od.product_reference,
  od.product_name,
  SUM(od.product_quantity) AS qty_sold
FROM ps_orders o
JOIN ps_order_detail od      ON od.id_order = o.id_order
WHERE o.current_state IN (/* put id_order_state(s) here */)
  AND o.date_add >= '2026-01-01 00:00:00'
  AND o.date_add <= '2026-01-31 23:59:59'
GROUP BY
  od.product_id, od.product_reference, od.product_name
ORDER BY qty_sold DESC;