Edit History

1 hour ago, joseantgv said:

Could you please execute this query and paste the result?

SELECT `id_product`, count(*)
FROM `ps_category_product`
WHERE `id_category` = '2' /* Set your category ID */
GROUP BY `position`
HAVING count(*) > 1;

 

Well i set id_category some irrelevant category with 8 subcategories and no products in them and  BO sql manager said This SQL query returned an empty result.

Another category with subcategories and products said  but real amount of products in is not correct

id_product       count(*)

5099                  23

Target category with subcategories and products where i want to change some position of subcategories  returns This SQL query returned an empty result.

So some categories returns empty even there a products in them and some incorrect number of products in them if understand this query count how many products in category

But i dont need products, wanna change  ps_category position but when i changed position of one category in phpmyadmin to 3 in BO that category position was still 26

1 hour ago, joseantgv said:

Could you please execute this query and paste the result?

SELECT `id_product`, count(*)
FROM `ps_category_product`
WHERE `id_category` = '2' /* Set your category ID */
GROUP BY `position`
HAVING count(*) > 1;

 

Well i set id_category some irrelevant category with 8 subcategories and no products in them and  BO sql manager said This SQL query returned an empty result.

Another category with subcategories and products said  but real amount of products in is not correct

id_product       count(*)

5099                  23

Target category with subcategories and products where i want to change some position of subcategories  returns This SQL query returned an empty result.

So some categories returns empty even there a products in them and some incorrect number of products in them if understand this query count how many products in category

1 hour ago, joseantgv said:

Could you please execute this query and paste the result?

SELECT `id_product`, count(*)
FROM `ps_category_product`
WHERE `id_category` = '2' /* Set your category ID */
GROUP BY `position`
HAVING count(*) > 1;

 

Well i set id_category some irrelevant category with 8 subcategories and no products in them and  BO sql manager said This SQL query returned an empty result. Another category with subcategories and products said  but real amount of products in is not correct

id_product       count(*)

5099                  23

Target category with subcategories and products where i want to change some position of subcategories  returns This SQL query returned an empty result.

So some categories returns empty even there a products in them and some incorrect number of products in them if understand this query count how many products in category

1 hour ago, joseantgv said:

Could you please execute this query and paste the result?

SELECT `id_product`, count(*)
FROM `ps_category_product`
WHERE `id_category` = '2' /* Set your category ID */
GROUP BY `position`
HAVING count(*) > 1;

 

Well i set id_category some irrelevant category with 8 subcategories and no products in them and  BO sql manager said This SQL query returned an empty result. Another category with subcategories and products said  buy real amount of products is not correct

id_product       count(*)

5099                  23

Target category with subcategory and products where i want to change some position  returns This SQL query returned an empty result.

So some categories returns empty even there a products and some incorrect number of products in them if understand this query count how many products in category

1 hour ago, joseantgv said:

Could you please execute this query and paste the result?

SELECT `id_product`, count(*)
FROM `ps_category_product`
WHERE `id_category` = '2' /* Set your category ID */
GROUP BY `position`
HAVING count(*) > 1;

 

Well i set id_category some irrelevant category with 8 subcategories and no products in them and  BO sql manager said This SQL query returned an empty result. Another category with subcategories and products said  buy real amount of products is not correct

id_product       count(*)

5099                  23

Target category with subcategory and products where i want to change some position  returns This SQL query returned an empty result.

1 hour ago, joseantgv said:

Could you please execute this query and paste the result?

SELECT `id_product`, count(*)
FROM `ps_category_product`
WHERE `id_category` = '2' /* Set your category ID */
GROUP BY `position`
HAVING count(*) > 1;

 

Well i set id_category some irrelevant category with 8 subcategories and no products in them and  BO sql manager said This SQL query returned an empty result. Another category with subcategories and products said  buy real amount of products is not correct

id_product       count(*)

5099                  23