Get ID's of last Products Sold

[TonyKapa]

Hello!

I am developing a module where I want to show in the home page for example the last 10 products that got sold, how can I get their ID's ? 

Thanks in advance!

[Nickz]

I think that Module is unnecessary. You can filter your sales after all kinds factors.  

[TonyKapa]

So how do you suggest I do that? Is there a native module that can do that?

[Mediacom87]

Hi,

You can have this list of products by going to the Statistics menu and selecting the Catalog Evaluation tab.

In this part, you can select a period and then sort the list of products by number of sales.

[TonyKapa]

Thanks for your replies , 

Maybe I was unclear, I want to show those products front end,to the customers. In my eshop Home page not admin home page. And I want to do it dynamically, with each new order, products shown in front home page will be updated automatically with the newly sold items. 

[Mediacom87]

Do it with a simple SQL query where you get the product id of the last orders and then work on it.

[Ress]

Hi,

The products purchased are in the ps_order_detail table. Basically, you just have to make a select, ordering them in descending order. If you want something more complex, you can also check the current status of the order that the products are part of, so that it is not a canceled order, or one that has not yet been processed.

[Tom Girou]

50 minutes ago, Ress said:

Hi,

The products purchased are in the ps_order_detail table. Basically, you just have to make a select, ordering them in descending order. If you want something more complex, you can also check the current status of the order that the products are part of, so that it is not a canceled order, or one that has not yet been processed.

Indeed. Also use LIMIT 10 in your SQL query, to get only the 10 latest instead of filtering in PHP.

[TonyKapa]

Thanks for the help it works fine 

$request = 'SELECT `product_id` FROM `' . _DB_PREFIX_ . 'order_detail` ORDER BY `id_order` DESC LIMIT 10'

 

[Mediacom87]

Don't forget to used DISTINCT if you really get 10 lasts unique products