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

#   Products Not displaying on all pages

##

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

Less More

- Posts: 94
- Thank you received: 0
-
-

15 years 4 weeks ago [\#27340](#27340) by [Mattlab](/forum/user/3719-mattlab "View Mattlab's Profile")  *[Products Not displaying on all pages](/forum/3-bug-report/27340-products-not-displaying-on-all-pages#27340 "So I think this is a bug and I sent an email about it just to be sure with my web address so that you guys can check it out.  Basically I have about 59 products in one of my categories. The first 40 show and the last 20 do not. The system splits it among 3 pages and page 1 and 2 have the correct products in order and then page 3 for some reason repeats the products from page 1?????  Then if I set it to show all products at the same time it displays them all (59) with no issues. Ideas?  Please help as this is a big problem.")* was created by *[Mattlab](/forum/user/3719-mattlab "View Mattlab's Profile")*

So I think this is a bug and I sent an email about it just to be sure with my web address so that you guys can check it out.

Basically I have about 59 products in one of my categories. The first 40 show and the last 20 do not. The system splits it among 3 pages and page 1 and 2 have the correct products in order and then page 3 for some reason repeats the products from page 1?????

Then if I set it to show all products at the same time it displays them all (59) with no issues. Ideas?

Please help as this is a big problem.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yNzM0MC1wcm9kdWN0cy1ub3QtZGlzcGxheWluZy1vbi1hbGwtcGFnZXM/dG1wbD1tYXJrZG93bg==) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86541
- Thank you received: 14304
-
-

15 years 4 weeks ago [\#27342](#27342) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Products Not displaying on all pages](/forum/3-bug-report/27340-products-not-displaying-on-all-pages#27342 "So I think this is a bug and I sent an email about it just to be sure with my web address so that you guys can check it out.  Basically I have about 59 products in one of my categories. The first 40 show and the last 20 do not. The system splits it among 3 pages and page 1 and 2 have the correct products in order and then page 3 for some reason repeats the products from page 1?????  Then if I set it to show all products at the same time it displays them all (59) with no issues. Ideas?  Please help as this is a big problem.")*

Do you have the joomla cache activated ? If so you should disable it and try again.
Do you have the latest version of Hikashop ? If not, you should update and try again.

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

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

Less More

- Posts: 94
- Thank you received: 0
-
-

15 years 4 weeks ago [\#27343](#27343) by [Mattlab](/forum/user/3719-mattlab "View Mattlab's Profile")  Replied by *[Mattlab](/forum/user/3719-mattlab "View Mattlab's Profile")* on topic *[Re: Products Not displaying on all pages](/forum/3-bug-report/27340-products-not-displaying-on-all-pages#27343 "So I think this is a bug and I sent an email about it just to be sure with my web address so that you guys can check it out.  Basically I have about 59 products in one of my categories. The first 40 show and the last 20 do not. The system splits it among 3 pages and page 1 and 2 have the correct products in order and then page 3 for some reason repeats the products from page 1?????  Then if I set it to show all products at the same time it displays them all (59) with no issues. Ideas?  Please help as this is a big problem.")*

**nicolas wrote:**

> Do you have the joomla cache activated ? If so you should disable it and try again.
> Do you have the latest version of Hikashop ? If not, you should update and try again.

Cache is off and has been for a while and also I just installed Hikashop yesturday so yes I have the latest version 1.5.4.

Ideas?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yNzM0MC1wcm9kdWN0cy1ub3QtZGlzcGxheWluZy1vbi1hbGwtcGFnZXM/dG1wbD1tYXJrZG93bg==) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86541
- Thank you received: 14304
-
-

15 years 4 weeks ago [\#27347](#27347) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Products Not displaying on all pages](/forum/3-bug-report/27340-products-not-displaying-on-all-pages#27347 "So I think this is a bug and I sent an email about it just to be sure with my web address so that you guys can check it out.  Basically I have about 59 products in one of my categories. The first 40 show and the last 20 do not. The system splits it among 3 pages and page 1 and 2 have the correct products in order and then page 3 for some reason repeats the products from page 1?????  Then if I set it to show all products at the same time it displays them all (59) with no issues. Ideas?  Please help as this is a big problem.")*

Did you deactivate both the cache in the config of joomla AND the cache plugin ?

Could you try to activate the debug mode of joomla in the configuration and give us any error message you might have on that listing as well as the traces displayed at the both of the page when you're on the third page ?

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

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

Less More

- Posts: 94
- Thank you received: 0
-
-

15 years 4 weeks ago [\#27353](#27353) by [Mattlab](/forum/user/3719-mattlab "View Mattlab's Profile")  Replied by *[Mattlab](/forum/user/3719-mattlab "View Mattlab's Profile")* on topic *[Re: Products Not displaying on all pages](/forum/3-bug-report/27340-products-not-displaying-on-all-pages#27353 "So I think this is a bug and I sent an email about it just to be sure with my web address so that you guys can check it out.  Basically I have about 59 products in one of my categories. The first 40 show and the last 20 do not. The system splits it among 3 pages and page 1 and 2 have the correct products in order and then page 3 for some reason repeats the products from page 1?????  Then if I set it to show all products at the same time it displays them all (59) with no issues. Ideas?  Please help as this is a big problem.")*

**nicolas wrote:**

> Did you deactivate both the cache in the config of joomla AND the cache plugin ?
>
> Could you try to activate the debug mode of joomla in the configuration and give us any error message you might have on that listing as well as the traces displayed at the both of the page when you're on the third page ?

Ok I think I did both and did not see any errors. Can you maybe log into my admin panel and help me. I am sure it will take you 5 seconds to figure out what is wrong or if there is an error and where it would display. Can I PM you the login info?

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

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

Less More

- Posts: 94
- Thank you received: 0
-
-

15 years 4 weeks ago [\#27355](#27355) by [Mattlab](/forum/user/3719-mattlab "View Mattlab's Profile")  Replied by *[Mattlab](/forum/user/3719-mattlab "View Mattlab's Profile")* on topic *[Re: Products Not displaying on all pages](/forum/3-bug-report/27340-products-not-displaying-on-all-pages#27355 "So I think this is a bug and I sent an email about it just to be sure with my web address so that you guys can check it out.  Basically I have about 59 products in one of my categories. The first 40 show and the last 20 do not. The system splits it among 3 pages and page 1 and 2 have the correct products in order and then page 3 for some reason repeats the products from page 1?????  Then if I set it to show all products at the same time it displays them all (59) with no issues. Ideas?  Please help as this is a big problem.")*

**nicolas wrote:**

> Did you deactivate both the cache in the config of joomla AND the cache plugin ?
>
> Could you try to activate the debug mode of joomla in the configuration and give us any error message you might have on that listing as well as the traces displayed at the both of the page when you're on the third page ?

So I believe I figured it out. All of the products had an order of 0 listed. As soon as I changed one product to 1 the rest of the products automatically assigned themselves an order and it works normally now. This has to be a bug. If you don't have an order assigned in the import CSV it will then list everything as 0 and Hikashop gets confused. Thoughts?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yNzM0MC1wcm9kdWN0cy1ub3QtZGlzcGxheWluZy1vbi1hbGwtcGFnZXM/dG1wbD1tYXJrZG93bg==) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86541
- Thank you received: 14304
-
-

15 years 4 weeks ago [\#27362](#27362) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Products Not displaying on all pages](/forum/3-bug-report/27340-products-not-displaying-on-all-pages#27362 "So I think this is a bug and I sent an email about it just to be sure with my web address so that you guys can check it out.  Basically I have about 59 products in one of my categories. The first 40 show and the last 20 do not. The system splits it among 3 pages and page 1 and 2 have the correct products in order and then page 3 for some reason repeats the products from page 1?????  Then if I set it to show all products at the same time it displays them all (59) with no issues. Ideas?  Please help as this is a big problem.")*

That would explain the problem. It's probably MySQL which gives random results when the products listing is ordered by the ordering column and that you didn't set any ordering for your products.
The solution should be easy: just order your products with another column like the product_id.
You can do that by editing the hikashop options of your products listing menu/module and changing the option "ordering column" to "product_id".

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

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

Less More

- Posts: 94
- Thank you received: 0
-
-

15 years 3 weeks ago [\#27562](#27562) by [Mattlab](/forum/user/3719-mattlab "View Mattlab's Profile")  Replied by *[Mattlab](/forum/user/3719-mattlab "View Mattlab's Profile")* on topic *[Re: Products Not displaying on all pages](/forum/3-bug-report/27340-products-not-displaying-on-all-pages#27562 "So I think this is a bug and I sent an email about it just to be sure with my web address so that you guys can check it out.  Basically I have about 59 products in one of my categories. The first 40 show and the last 20 do not. The system splits it among 3 pages and page 1 and 2 have the correct products in order and then page 3 for some reason repeats the products from page 1?????  Then if I set it to show all products at the same time it displays them all (59) with no issues. Ideas?  Please help as this is a big problem.")*

Yeah I got it to work by just ordering the products...you may want to think about maybe editing the import process to fix this though...

Also on export it could be useful to allow for the selection of what fields you want exported... makes updating products easier. Just a suggestions. Love hikashop so far.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yNzM0MC1wcm9kdWN0cy1ub3QtZGlzcGxheWluZy1vbi1hbGwtcGFnZXM/dG1wbD1tYXJrZG93bg==) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86541
- Thank you received: 14304
-
-

15 years 3 weeks ago [\#27577](#27577) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Products Not displaying on all pages](/forum/3-bug-report/27340-products-not-displaying-on-all-pages#27577 "So I think this is a bug and I sent an email about it just to be sure with my web address so that you guys can check it out.  Basically I have about 59 products in one of my categories. The first 40 show and the last 20 do not. The system splits it among 3 pages and page 1 and 2 have the correct products in order and then page 3 for some reason repeats the products from page 1?????  Then if I set it to show all products at the same time it displays them all (59) with no issues. Ideas?  Please help as this is a big problem.")*

It is unfortunately done on purpose. You can't changing the ordering of all the products on the import. That would require to make at least one SQL query per product. And with more than a few hundreds products, the import would just crash the MySQL process. So the ordering is not set by default with you import products and we won't be able to change that.

Improving the import so that you can choose the fields is a neat idea. We'll add that to the todo list as a low priority.

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

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