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

#   Show newest products

##

- **[colpc](/forum/user/6409-colpc "View colpc's Profile")**
- [![colpc's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6409.gif)](/forum/user/6409-colpc "View colpc's Profile") Topic Author
- [ Offline](/forum/user/6409-colpc)

Less More

- Posts: 77
- Thank you received: 3
-
-
-
-

13 years 3 months ago [\#116259](#116259) by [colpc](/forum/user/6409-colpc "View colpc's Profile")  *[Show newest products](/forum/4-how-to/85858-show-newest-products#116259 "The feature in Modules that allows you to choose the ordering field In our case, published. This simply does NOT work the way you expect.  We have several products, usually we will make available once a week. based on publish date. When using the module to show what products were the latest, based on publish date in descending order. It still does not show the correct products.  The only way I can get it to show is based by created. or maybe modified.  Is this a bug ?")* was created by *[colpc](/forum/user/6409-colpc "View colpc's Profile")*

The feature in Modules that allows you to choose the ordering field
In our case, published. This simply does NOT work the way you expect.

We have several products, usually we will make available once a week.
based on publish date. When using the module to show what products were the latest, based on publish date
in descending order. It still does not show the correct products.

The only way I can get it to show is based by created. or maybe modified.

Is this a bug ?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg1ODU4LXNob3ctbmV3ZXN0LXByb2R1Y3RzP3RtcGw9bWFya2Rvd24=) 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: 86576
- Thank you received: 14321
-
-

13 years 3 months ago [\#116276](#116276) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Show newest products](/forum/4-how-to/85858-show-newest-products#116276 "The feature in Modules that allows you to choose the ordering field In our case, published. This simply does NOT work the way you expect.  We have several products, usually we will make available once a week. based on publish date. When using the module to show what products were the latest, based on publish date in descending order. It still does not show the correct products.  The only way I can get it to show is based by created. or maybe modified.  Is this a bug ?")*

Hi,

There is no published date for products. There is a product_published field which has either a value of 0 or 1 if the product is published or not. So ordering on it doesn't mean anything since anyway you only see the published products on the frontend.
So no, it's not a bug.

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

- **[colpc](/forum/user/6409-colpc "View colpc's Profile")**
- [![colpc's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6409.gif)](/forum/user/6409-colpc "View colpc's Profile") Topic Author
- [ Offline](/forum/user/6409-colpc)

Less More

- Posts: 77
- Thank you received: 3
-
-
-
-

13 years 3 months ago -  13 years 3 months ago [\#116287](#116287) by [colpc](/forum/user/6409-colpc "View colpc's Profile")  Replied by *[colpc](/forum/user/6409-colpc "View colpc's Profile")* on topic *[Show newest products](/forum/4-how-to/85858-show-newest-products#116287 "The feature in Modules that allows you to choose the ordering field In our case, published. This simply does NOT work the way you expect.  We have several products, usually we will make available once a week. based on publish date. When using the module to show what products were the latest, based on publish date in descending order. It still does not show the correct products.  The only way I can get it to show is based by created. or maybe modified.  Is this a bug ?")*

OK, so than how can we show a list of the most recent products that have been published ?

Also among the options for [Ordering field] listing I see " product last seen date "

What is that exactly ? and where is that date derived from ?

Last edit: 13 years 3 months ago by [colpc](/forum/user/6409-colpc "View colpc's Profile"). Reason: add

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg1ODU4LXNob3ctbmV3ZXN0LXByb2R1Y3RzP3RtcGw9bWFya2Rvd24=) 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: 86576
- Thank you received: 14321
-
-

13 years 3 months ago [\#116291](#116291) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Show newest products](/forum/4-how-to/85858-show-newest-products#116291 "The feature in Modules that allows you to choose the ordering field In our case, published. This simply does NOT work the way you expect.  We have several products, usually we will make available once a week. based on publish date. When using the module to show what products were the latest, based on publish date in descending order. It still does not show the correct products.  The only way I can get it to show is based by created. or maybe modified.  Is this a bug ?")*

There is no such information in the products data so you can't.
You can order the listing on the product_modified column in order to get the most recently modified products if you want instead.

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

- **[colpc](/forum/user/6409-colpc "View colpc's Profile")**
- [![colpc's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6409.gif)](/forum/user/6409-colpc "View colpc's Profile") Topic Author
- [ Offline](/forum/user/6409-colpc)

Less More

- Posts: 77
- Thank you received: 3
-
-
-
-

13 years 3 months ago [\#116296](#116296) by [colpc](/forum/user/6409-colpc "View colpc's Profile")  Replied by *[colpc](/forum/user/6409-colpc "View colpc's Profile")* on topic *[Show newest products](/forum/4-how-to/85858-show-newest-products#116296 "The feature in Modules that allows you to choose the ordering field In our case, published. This simply does NOT work the way you expect.  We have several products, usually we will make available once a week. based on publish date. When using the module to show what products were the latest, based on publish date in descending order. It still does not show the correct products.  The only way I can get it to show is based by created. or maybe modified.  Is this a bug ?")*

Ya tried that..
BUT you have to go into to each, in the order that you need displayed..

I wish you guys could come up with something to achieve.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg1ODU4LXNob3ctbmV3ZXN0LXByb2R1Y3RzP3RtcGw9bWFya2Rvd24=) 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: 86576
- Thank you received: 14321
-
-

13 years 3 months ago [\#116299](#116299) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Show newest products](/forum/4-how-to/85858-show-newest-products#116299 "The feature in Modules that allows you to choose the ordering field In our case, published. This simply does NOT work the way you expect.  We have several products, usually we will make available once a week. based on publish date. When using the module to show what products were the latest, based on publish date in descending order. It still does not show the correct products.  The only way I can get it to show is based by created. or maybe modified.  Is this a bug ?")*

Then why not use a custom product field where you would enter the number you want for each product ?
Or use the "product sale start date" ?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg1ODU4LXNob3ctbmV3ZXN0LXByb2R1Y3RzP3RtcGw9bWFya2Rvd24=) 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.079 seconds

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