Unique Product Models in osCommerce
Buy Gary A Beer?
Buying me a "beer" helps me to keep my contributions updated and keep this blog alive - and you get a link from my homepage to your site. Cheers!
Quite an interesting task to set up a method to easily allow the Shop Owner to see if a model name for a product has already been used whilst adding a new product.
This type of checking is done a lot for usernames in forums and blogs etc. With a bit of thought, it's easy to replicate in osCommerce.
I used jQuery, linking to MySQL to interrogate the database and then return a message, and easy to see CSS changes (green if OK, red if not).
In the video I used MG200MMS as a test as this model number exists in the database. As it exists, the entry field turns red and gives an error message with a stop image;
If I then change it to something else (that doesn't already exist), it turns green with a nice message and image;
Nice, I think!
I like it! Rebecca tells me that someone was inquiring about this on the osC forums a few days ago…
Comment by jared — February 21, 2010 @ 8:06 am
Indeed – it was my post in this thread which led to someone (who did not believe it could be done!!) to message me and prove it…
Comment by Gary — February 21, 2010 @ 11:30 am