Unique Product Models in osCommerce

By | February 20, 2010

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!

2 thoughts on “Unique Product Models in osCommerce

  1. jared

    I like it! Rebecca tells me that someone was inquiring about this on the osC forums a few days ago…

  2. Gary Post author

    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…

Leave a Reply

Your email address will not be published.