Unique Product Models in osCommerce

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 Replies to “Unique Product Models in osCommerce”

Leave a Reply

Your email address will not be published. Required fields are marked *