[Skip to main content](#vessel-content)

#   Add ordering field in product class object

##

- **[ruchikanagarkar](/forum/user/40148-ruchikanagarkar "View ruchikanagarkar's Profile")**
- [![ruchikanagarkar's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/40148-ruchikanagarkar "View ruchikanagarkar's Profile") Topic Author
- [ Offline](/forum/user/40148-ruchikanagarkar)

Less More

- Posts: 28
- Thank you received: 0
-
-

10 years 5 months ago [\#242663](#242663) by [ruchikanagarkar](/forum/user/40148-ruchikanagarkar "View ruchikanagarkar's Profile")  *[Add ordering field in product class object](/forum/26-product-category-display/885010-add-ordering-field-in-product-class-object#242663 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.5  Hi,  I want to fetch all the products from a selected category and display through my custom code. For this I referred here:   hikashop.com/support/documentation/62-hi...umentation.html#code  $productClass = hikashop&#95;get('class.product'); $product=$productClass-&gt;get($product&#95;id);  I want to know how can I add an ordering parameter here ? for example I want to display products from selected category. So, here I am passing the product id of all the fetched products but want to order them by product&#95;name, product&#95;id etc. or do I need to write the whole sql query for this?")* was created by *[ruchikanagarkar](/forum/user/40148-ruchikanagarkar "View ruchikanagarkar's Profile")*

-- HikaShop version -- : 2.6.3
-- Joomla version -- : 3.5.1
-- PHP version -- : 5.5

Hi,

I want to fetch all the products from a selected category and display through my custom code. For this I referred here:
[ hikashop.com/support/documentation/62-hi...umentation.html#code](https://hikashop.com/support/documentation/62-hikashop-developer-documentation.html#code)

$productClass = hikashop_get('class.product');
$product=$productClass-&gt;get($product_id);

I want to know how can I add an ordering parameter here ? for example I want to display products from selected category. So, here I am passing the product id of all the fetched products but want to order them by product_name, product_id etc. or do I need to write the whole sql query for this?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84ODUwMTAtYWRkLW9yZGVyaW5nLWZpZWxkLWluLXByb2R1Y3QtY2xhc3Mtb2JqZWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

10 years 5 months ago [\#242689](#242689) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Add ordering field in product class object](/forum/26-product-category-display/885010-add-ordering-field-in-product-class-object#242689 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.5  Hi,  I want to fetch all the products from a selected category and display through my custom code. For this I referred here:   hikashop.com/support/documentation/62-hi...umentation.html#code  $productClass = hikashop&#95;get('class.product'); $product=$productClass-&gt;get($product&#95;id);  I want to know how can I add an ordering parameter here ? for example I want to display products from selected category. So, here I am passing the product id of all the fetched products but want to order them by product&#95;name, product&#95;id etc. or do I need to write the whole sql query for this?")*

Hi,

There is a function to load the ids of all the products of a category but you can't tweak it to change the ordering.
The best is to write your own MySQL query.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84ODUwMTAtYWRkLW9yZGVyaW5nLWZpZWxkLWluLXByb2R1Y3QtY2xhc3Mtb2JqZWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.048 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
