Help Shorten and/or Truncate the Products Model Length

[limelites]

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

[SCR]http://www.limelites.co.uk/screenPL.jpg[/SCR]

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??

[gjh42]

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.

[limelites]

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?

[gjh42]

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.

[limelites]

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

[stevesh]

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.

[Kim]

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