Unique Product Models

[securit]

Hi there,

is there a simple way to make ZenCart check to ensure that product models are unique when they are entered?

I could add a function as follows:

function checkUnique ($table, $field, $compared) { $tablenew=mysql_real_escape_string($table); $fieldnew=mysql_real_escape_string($field); $comparednew=mysql_real_escape_string($compared); $query="SELECT $fieldnew FROM $tablenew WHERE $fieldnew='$comparednew'"; $result=mysql_query($query); $num=mysql_num_rows($result); if($num==0) { return TRUE; } else { return FALSE } }

and call that PHP validation with the collect_info
checkUnique('products', 'product_model', $_POST['product_model'])==FALSE

But I was really hoping that there would be a way of doing this without affecting the base code too much.

Many thanks

[dbltoe]

If you are talking about making sure someone orders the right size t-shirt, it's there in the attributes.

For instance, the Option would be Size with values of 5, 6, 7, and 8. You'd add Please Select as the default value, for display only. The system will require the customer to select a size.

[securit]

Hi dbltoe,
No I'm not talking about attributes. Each product in the cart has a unique ID, but also a unique product model. I want to check to ensure that the same model number isnt entered more than once.
Cheers!

[dbltoe]

You can set the maximum amount to one, but that doesn't preclude two simultaneous customer orders.

[swguy]

Each product in the cart has a unique ID, but also a unique product model. I want to check to ensure that the same model number isnt entered more than once.

Using phpMyAdmin, create a unique index on products.products_model. The field will already need to be unique before you can do this; if it fails because you have duplicates you can find them by doing a count() of products_model. Once you have done this, inserts with a duplicate products_model will fail.