Page 1 of 1

*FYI* Category -> Sub-Category 5 item limit

Posted: Fri Jan 23, 2015 7:19 am
by rdracing
I couldn't find anything to help rectify this problem, but managed to correct myself so I thought I'd share it in hope that it may help someone else.
OpenCart V.2.0.1.1
My client is setting up a store that has several child categories for products and ran into a road block while trying to add products to the 3rd and 4th level child categories.
From the admin panel under products, he would go to the "Links" tab, click in the "categories" field and type a few letters of the child category for that product. The auto-fill feature is limited by default to (5) items. No mater how he would type the child category name (even the full name) not enough would show to find the one he needed.

* THE FIX*
Browse to the Admin directory: GoTo: admin->controller->catalog and open category.php in your html editor. Scroll down to about line 590 (mine was actually 589) and look for the $filter_data = array(
The last line in that array limits the number of 'catalog/category' (the default is 5). Increase that number to display a larger list of child categories and it's fixed. I changed it to 20 for now, but I have a feeling I may need to go higher than that.

I hope this can help someone else out that's struggling with the same issue.

-Ron

Re: *FYI* Category -> Sub-Category 5 item limit

Posted: Sat Jan 24, 2015 5:39 pm
by Goffer
Thanks, a nice little workaround.
Pretty stupid problem though :D

Re: *FYI* Category -> Sub-Category 5 item limit

Posted: Wed Apr 01, 2015 12:21 am
by westernfirebrand
Thanks for the answer. As a newbie I have had fun trying to find out how to view more than 5 categories in the drop down box, but this fixed it. Now I can stop banging my head against the wall. :crazy:

Re: *FYI* Category -> Sub-Category 5 item limit

Posted: Thu Apr 02, 2015 10:44 am
by gilaraujo
RdRacing, i think this is relevant and i browsed arround on the forum and 3-4 ppl had the same issue.

Maybe you can come in and comment with more experience on the issue here:
https://github.com/opencart/opencart/pull/2846

Regards

Re: *FYI* Category -> Sub-Category 5 item limit

Posted: Mon Apr 13, 2015 5:23 pm
by midlifedesign
Brilliant - absolutely brilliant. I have lost two days alloted to my web site because of this issue. Why the hell its been limited to 5 I have no idea. Surely this should be changed in the download.

Thank you for your cure!!!!

have a virtual beer on me!!

Re: *FYI* Category -> Sub-Category 5 item limit

Posted: Tue Apr 28, 2015 6:53 pm
by Slayss
Super, Thank you very much!

Re: *FYI* Category -> Sub-Category 5 item limit

Posted: Fri May 22, 2015 1:59 pm
by MoreCoffeePlease
Perfect and thanks for sharing! This one was making me crazy as well.

Re: *FYI* Category -> Sub-Category 5 item limit

Posted: Wed Sep 16, 2015 12:49 am
by TomHughes
I applied the change described above, but I set the limit to 0 (zero). By doing this, SQL returns all the rows in the query result and you won't have to make any more changes to increase the limit in the future.

Re: *FYI* Category -> Sub-Category 5 item limit

Posted: Wed Dec 09, 2015 10:20 pm
by wilson2015
extremely helpful, I wasted hours on this. Changed to "0" as well. thank you!

Re: *FYI* Category -> Sub-Category 5 item limit

Posted: Sat Apr 02, 2016 2:17 am
by Mikeydude
Also had this issue...this fixed it...can't believe it is set up as 5 by default...most first time users would be really struggling with this

Re: *FYI* Category -> Sub-Category 5 item limit

Posted: Tue Aug 30, 2016 1:13 pm
by Tekland
Thank you for this fix. It also works on 2.3.0.2 but was on line 621. By the way leaving it blank also seemed to work but put in 40 just in case it left something hanging elsewhere.

Re: *FYI* Category -> Sub-Category 5 item limit

Posted: Tue Aug 30, 2016 9:30 pm
by cyclops12
There is also a nice little extension to sort this Here

Re: *FYI* Category -> Sub-Category 5 item limit

Posted: Mon Jan 08, 2018 7:58 am
by accessbit
But this does not work either on the Version 3.0.x
Probably developers blocked it again.
I have tried by adding from 10 to 90
Nothing work.
I guess it is a stupid piece of crap. I may have to change the app to something else.
What is the point of putting this kind of bogus stuff out there to waste people time!

Re: *FYI* Category -> Sub-Category 5 item limit

Posted: Sun Oct 07, 2018 8:42 pm
by bellacard
Thanks for the fix. It works on Version 3 as well. The line of code to change in v3.0.20 is #596. Change it:

admin/controller/catalogue/category.php then find line #596 (or thereabouts - in mine it that line)

'limit' => 0

as per previous comments.

Re: *FYI* Category -> Sub-Category 5 item limit

Posted: Mon Oct 08, 2018 1:41 am
by IP_CAM
One of those Extensions could solve your problem for good:
Admin List Limit
https://www.opencart.com/index.php?rout ... n_id=21393
---
Dissable Autocomplete
https://www.opencart.com/index.php?rout ... n_id=20490
---

Re: *FYI* Category -> Sub-Category 5 item limit

Posted: Thu Nov 15, 2018 7:36 pm
by flashgraham
Hiya,
Thanks for this answer, it worked for me in the options limit, previousley set to 5, now set to 8
Thanks again