Get product position in category

[LéonMoff]

Hi, I’m trying to get and display a product’s position within a category. The position that you can find in the backend on the right side by filtering products by category. I can’t find anything about this on the internet, can anyone help?

I’m using Prestashop 1.7.8.7

Edited September 15, 2022 by LéonMoff (see edit history)

[ps8modules]

Hi.
The position of the product in the category can be obtained from the ps_category_product table.
For example, information on product sorting in a category can be found here:

https://prestapros.com/en/instruction/prestashop-17-changing-the-order-of-products-in-category-view