Help Shorten and/or Truncate the Products Model Length

Does anyone know how I could shorten the number of characters allowed in the 'Products Model' code field?

http://www.limelites.co.uk/screenPL.jpg

When I sometimes write too much in this field, it pushes onto a new line. It'd be ideal if I could reduce the allowed characters so this never happens again.

Also, if I change PHP code to force a shorter length, what would happen to the existing 'Products Model' Codes? Would they just truncate??

Just as a starter, you can set the size of a field in the database using phpMyAdmin. The existing field is probably something like varchar 64 or varchar 32.

Hi Glen,

I don't know the first thing about using phpMyAdmin. I've heard of it, but never used it before. I don't like tampering with my database in any way.

I wondered if there was maybe a PHP file that specified the character length?

I know how you feel. Messing with the db can be scary, but I don't know of a PHP file that affects the products_model field length. There could be one, but the usual advice given for things like this is to change it in the db.

If I'd need to screw about with the DB then I think I'll just forget it and I'll just consciously make the effort to keep the Product Model short :unsure:

phpMyAdmin is just another tool, and not that difficult to figure out. I would set up another Zenacrt installation, probably in a subdirectory, with its own database, and try changing the length in that first. You'll find it's really easy.

Why not just remove/prevent it from showing on the product listing?