Manual order By does not work

04.10.2012 18:39
#1
festrada
Joomshopping forum user no avatar
Name: fer
21.12.2010
Сообщения: 36
Quote
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?
Manual order By does not work
list_products_front.png


Joomla: 2.5.6
JoomShopping: 3.7
 
04.10.2012 21:11
#2
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 25853
Quote
Aw: Manual order By does not work

See configuration / category/product
Product sorting

 
04.10.2012 21:20
#3
festrada
Joomshopping forum user no avatar
Name: fer
21.12.2010
Сообщения: 36
Quote
Aw: Manual order By does not work

Yes, i have select the default order.
Aw: Manual order By does not work

 
04.10.2012 21:32
#4
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 25853
Quote
Aw: Manual order By does not work

enable debug mode

see query

 
04.10.2012 21:43
#5
festrada
Joomshopping forum user no avatar
Name: fer
21.12.2010
Сообщения: 36
Quote
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
#6
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 25853
Quote
Aw: Manual order By does not work

install plugin or addon?

 
05.10.2012 08:19
#7
festrada
Joomshopping forum user no avatar
Name: fer
21.12.2010
Сообщения: 36
Quote
Aw: Manual order By does not work

No.

 
05.10.2012 10:00
#8
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 25853
Quote
Aw: Manual order By does not work

/tienda/vial.html - page category or page product

See item menu (Need create item menu as page category)

 
05.10.2012 10:45
#9
festrada
Joomshopping forum user no avatar
Name: fer
21.12.2010
Сообщения: 36
Quote
Aw: Manual order By does not work

ok, then ordered only if coming from the category page.
Is there another way to sort the products by the order within the category?

 
05.10.2012 10:52
#10
festrada
Joomshopping forum user no avatar
Name: fer
21.12.2010
Сообщения: 36
Quote
Aw: Manual order By does not work

Ok, i do it.
thanks

 


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.