Open Designs

Open Designs Forum » Designer Talk

1. summitr
   Member

   This seems to be a weird request as I have searched for it and haven't found anything on search engines.

   What I have is basically a point-of-sale system that is web-based. I type in a product sku and it automatically brings up all the information for that product. What it doesn't have is an autocomplete/autosuggest feature. I have to know the sku to find the product. I have over 30000 products so it gets hard sometimes.

   Is there any way to have an autocomplete somewhere else? I was thinking something like having it hosted locally and just recognize when I'm typing in certain input fields on a certain website.

   Has anyone heard of something like this or implemented something like this?

   Posted 3 years ago #

2. rhcom
   Member

   Id wouldn't really make sense … This service has to know each and every content on each site you visit. If a crawler visit "my shop" and starts crawling tons of gigabyte only for one user I would kill the admin for that. ;-)

   Posted 3 years ago #

3. Rob
   Member

   I'm a little confused, perhaps I missed something.

   Surely the data is in your database? So you'd just use ajax to query the suggestions as the user is typing?

   If you want something to work on any website you'd have to make an add on or toolbar. But then you'd have to make one for all browsers as well.

   Posted 3 years ago #

4. summitr
   Member

   Maybe I didn't explain well enough. The point-of-sale is web-based and ran by another company. I am not able to edit any files relate to the design, function, or database for the site. They automatically pull in all the stock numbers from my suppliers. What they don't have is an autosuggest feature when i'm typing up an order for a customer. I have asked them about it, but it isn't on the roadmap right now.

   I understand your concern rhcom, but I assure you that isn't an issue here. I also am given all the stock numbers by my supplier. Conveniently enough, I have it as an SQL file (or CSV, can't remember for sure) so I can easily load it into a database of my choosing.

   Posted 3 years ago #

5. rhcom
   Member

   Than you'll need to setup a simple form which is querying your database via ajax.
   Simple tutorial I've found … http://www.talkphp.com/advanced-php-programming/1588-auto-suggest-using-php-mysql-ajax.html …

   just search for "autosuggest php tutorial" and you'll get more of that.

   Hope that helps.

   Posted 3 years ago #

RSS feed for this topic