Your Cart is currently empty!
Product update
Coupon
add
Coupon code invalid! Please re-enter!
AJAX loader
You are here: HomeForum
Welcome, Guest

Categories display order in theme4
(1 viewing) (1) Guest
Userguide, Report bugs, New Ideas...
  • Page:
  • 1

TOPIC: Categories display order in theme4

Categories display order in theme4 11 years, 11 months ago #3345

  • jesuskj
  • OFFLINE
  • Single Product
  • Fresh Boarder
  • Posts: 13
  • Karma: 0
Hello again , i have one more question.
which is the order of the categories shown?
I ordered by id categorie and by order in K2 Categories, but the module show in other order the categories. Where can i change it?

Example:
CAT1 - order 1 - id 10
CAT2 - order 2 - id 11
CAT3 - order 3 - id 12

The module show CAT2-CAT1-CAT3 ¿?

Thanks!

Re: Categories display order in theme4 11 years, 11 months ago #3374

  • jesuskj
  • OFFLINE
  • Single Product
  • Fresh Boarder
  • Posts: 13
  • Karma: 0
Hi,
Its posible to order the next SELECT?

$query = "
SELECT c.id, c.name as title, c.alias
FROM #__k2_categories c
WHERE
c.published = 1
AND c.parent = $catId
";

I don't know, but this select take the k2 categories from the table. But, in order?
The module display the categories in this order: (not is alphabetical order)

Cat5 (idcat=105) --- Cat1 (idcat=101) --- Cat9 (idcat=109)
Cat7 (idcat=107) --- Cat4 (idcat=104) --- Cat2 (idcat=102)
Cat3 (idcat=103) --- Cat6 (idcat=106) --- Cat10 (idcat=110)
Cat8 (idcat=108) --- Cat11 (idcat=111)

How i can change this order?. I want ordered by idcat or by another other than i can distribute (creation date, order in k2, icat, ...) but not in alphabetical order.

Its posible?

Very, very thanks.

Re: Categories display order in theme4 11 years, 11 months ago #3375

  • jesuskj
  • OFFLINE
  • Single Product
  • Fresh Boarder
  • Posts: 13
  • Karma: 0
I found the solution.

I change two SELECT and i include ORDER BY catid.


Thanks for me.
  • Page:
  • 1
Time to create page: 0.21 seconds

Notification

Please find your issue via Suggested Posts before submitting your question. We have solved the most of issues and maybe your issue was solved before.

Latest My Topics

No posts to display.

Love all our templates?

Join our membership clubs starting at $49 only for access to all of our templates

Join Now
Home Pricing
Your Cart is currently empty!
Product update
Coupon
add
Coupon code invalid! Please re-enter!
AJAX loader
SearchSupport
Magento Themes Magento Extensions Free Magento Extensions Prestashop Themes Prestashop Modules Magento 2 Themes