Post by carolinagirl » Sat Mar 23, 2013 2:08 am

Auto complete in the admin only brings up 20 items and if I keep typing it stops working. We have over 36,000 products and they will not always be in the top 20 when trying to feature them and add them to modules. We are using 1.5.4.
Last edited by carolinagirl on Mon Mar 25, 2013 11:16 pm, edited 1 time in total.

Newbie

Posts

Joined
Tue Feb 12, 2013 5:25 am

Post by carolinagirl » Sat Mar 23, 2013 10:26 am

And why am I being passed by?????????????????????????????????????????

Newbie

Posts

Joined
Tue Feb 12, 2013 5:25 am

Post by butte » Sun Mar 24, 2013 10:42 am

The latter post's answer relates to who with something intelligent to offer while hopefully understanding the question or problem is awake when and moreover is logging in when around the globe. The initial post hints at wishing everything could go on any "page one" (and starting with petroglyphs and cuneiform, that never happens), so I probably won't be the only one who paused for a while.

The initial post raises a frustration that I fully appreciate but am not sure I fully understand in context of scores at a time. One way to manipulate one field or several of them in vastly more than a score of records at a time is to edit the appropriate database tables (e.g., with a good pure text editor or with a database workbench, and a modicum of proficiency in using those). One way to "feature" vastly more than a score of products at a time is to utilize a carousel of one or another sort, without commandeering the entire page with as many featured products as already appear in product categories that can be selected with one or another sort of rhyme and reason.

Autocompletion is inherently limited even by your own operating system as well as by on-line html, php, and js (among others), owing both to memory limitations for relatively unimportant matters among everything the machines are expected to do, and as precaution against anyone (even an owner) completely swamping a box beyond all reasonable metes and bounds. Some of those limitations are specifically rooted in means to disallow, thwart, or offset some of what hackers can do. Even in an operating system on your own machine, the memory for autocompletion must reside somewhere, such as among ram and drive and such inherently limited places as the registry (in Win). The server cannot be expected to accommodate an endless volume of it, either. Certainly OC itself is not designed as an autocompletion paradise.

With that said, it may (or not) be appropriate to provide both your url and a practical idea of what you're trying to do (feature 1,000 of 36,000, or what?) that prompted your [okay, edit, balance deleted:] frustration.
Last edited by butte on Mon Mar 25, 2013 3:46 am, edited 2 times in total.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by Daniel » Mon Mar 25, 2013 2:06 am

are you trying to answer a problem with a poem?

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by carolinagirl » Mon Mar 25, 2013 9:47 pm

My problem is I need more than 20 results to show with auto complete in the admin in all modules. I want to feature items that may have 300 starting with the same beginning letters ex. Sparco products, there may be 300 and I only get 20 results in auto complete and the item I need is not in the first 20. does this make my problem more clear?

Newbie

Posts

Joined
Tue Feb 12, 2013 5:25 am

Post by daik01 » Mon Mar 25, 2013 10:40 pm

Most easy way to change this is to edit admin\controller\catalog\product.php. Search for $limit = 20; and change it to $limit = 300;

This makes autocomplete much slower. I hope it will work for you.

TOP 5 Opencart Extensions:
1:Opencart Reservations
2:Stock Report, import/export stock levels with Excel
3:3D Carousel
4:Product Price Changer by Category
5:Set price Inclusive Taxes
DEMO SHOP


Active Member

Posts

Joined
Sun Oct 21, 2012 3:18 am


Post by ase618 » Mon Mar 25, 2013 10:55 pm

Daniel wrote:are you trying to answer a problem with a poem?
Awesome response!:lol:

artisantool.co
Don't forget to add [SOLVED] to your Thread Title (first post), if your issue is solved.


Active Member

Posts

Joined
Sun Jul 29, 2012 9:59 pm

Post by carolinagirl » Mon Mar 25, 2013 11:15 pm

That solved my problem thank you for a straight answer and not a poem! LOL

Newbie

Posts

Joined
Tue Feb 12, 2013 5:25 am

Post by daik01 » Tue Mar 26, 2013 1:51 am

carolinagirl wrote:That solved my problem thank you for a straight answer and not a poem! LOL
I am not at my best with poetry ;-)

TOP 5 Opencart Extensions:
1:Opencart Reservations
2:Stock Report, import/export stock levels with Excel
3:3D Carousel
4:Product Price Changer by Category
5:Set price Inclusive Taxes
DEMO SHOP


Active Member

Posts

Joined
Sun Oct 21, 2012 3:18 am


Post by butte » Tue Mar 26, 2013 2:34 am

With on the order of 36,000 entries, where a limit of 20 or even 300 would seem to be in your way, you may find your tasks eased by using Oracle's Workbench or something similar. If you reset the limit all the way to 40,000, the admin panel may be less effective than the former.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Active Member

Posts

Joined
Sun Oct 21, 2012 3:18 am


Post by paveldiaz1 » Thu Feb 04, 2016 11:20 am

Dear all,
have the same problem with opencart 2.X , but the solution doenst work.
so, could you give me some advise?

Newbie

Posts

Joined
Sat Dec 12, 2015 7:22 am

Post by Rezman » Fri Mar 25, 2016 11:16 pm

I've run into this as well on 2.x. I have a hard time believe this would be hard coded at a max of 5 entries. 20 or 25 would be better.

EDIT: I was trying to increase the results for the "Categories" under the Links tab when editing a product. I solved this. Post here: viewtopic.php?f=184&t=140199&p=610809#p610809

Newbie

Posts

Joined
Tue Feb 26, 2013 3:28 am

Post by stavrosa » Fri Jul 05, 2019 1:46 am

Daniel wrote:
Mon Mar 25, 2013 2:06 am
are you trying to answer a problem with a poem?
I think this is the best comment in the whole opencart forum! :laugh:

Newbie

Posts

Joined
Wed Sep 23, 2015 8:08 pm
Who is online

Users browsing this forum: No registered users and 3 guests