Hi i sort the products of one category manually, and i see them in the frontend and they aren´t sort. why?
list_products_front.png
Joomla: 2.5.6
JoomShopping: 3.7
JoomShopping: 3.7
04.10.2012 18:39
|
|
festrada
Name: fer
21.12.2010
Posts: 36
|
Manual order By does not work
Hi i sort the products of one category manually, and i see them in the frontend and they aren´t sort. why? list_products_front.png
Joomla: 2.5.6
JoomShopping: 3.7 |
04.10.2012 21:11
|
|
admin
(Support Team) Name: Admin
05.08.2010
Posts: 25854
|
|
04.10.2012 21:20
|
|
festrada
Name: fer
21.12.2010
Posts: 36
|
|
04.10.2012 21:32
|
|
admin
(Support Team) Name: Admin
05.08.2010
Posts: 25854
|
|
04.10.2012 21:43
|
|
festrada
Name: fer
21.12.2010
Posts: 36
|
Aw: Manual order By does not work
this whe i order by name SELECT prod.product_id, pr_cat.category_id, prod.`name_es-ES` as name, prod.`short_description_es-ES` as short_description, prod.product_ean, prod.product_thumb_image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices FROM `ef1zb_jshopping_products` AS prod LEFT JOIN `ef1zb_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `ef1zb_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (3) GROUP BY prod.product_id ORDER BY name ASC LIMIT 0, 12 And this with the default order SELECT prod.product_id, pr_cat.category_id, prod.`name_es-ES` as name, prod.`short_description_es-ES` as short_description, prod.product_ean, prod.product_thumb_image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices FROM `ef1zb_jshopping_products` AS prod LEFT JOIN `ef1zb_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `ef1zb_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (3) GROUP BY prod.product_id LIMIT 0, 12 There is no Order BY |
05.10.2012 07:45
|
|
admin
(Support Team) Name: Admin
05.08.2010
Posts: 25854
|
|
05.10.2012 08:19
|
|
festrada
Name: fer
21.12.2010
Posts: 36
|
|
05.10.2012 10:00
|
|
admin
(Support Team) Name: Admin
05.08.2010
Posts: 25854
|
|
05.10.2012 10:45
|
|
festrada
Name: fer
21.12.2010
Posts: 36
|
|
05.10.2012 10:52
|
|
festrada
Name: fer
21.12.2010
Posts: 36
|
|