CRE Loaded Community

Hi there,
I've got a 6.4 Pro store and realised that the products name in Admin is limited to 64 chars even though the database field is set to 128 chars. I'm guessing that the reason for this is the concatenated names for subproducts which ends up as "products name + ' - ' + sub products name" (which would trigger a sql error if both products name and sub products name are 64 chars as there will be no space available for the divider ' - '. Nevermind).

So I need to extend it a bit by 1. increasing the database field to 255 and 2. set max length in /admin/categories.php to, say 120 and 3. ensure that the products listing and product info pages will display the full length.

My question is if there are any other logic or functions affecting the length of products name, which could trigger an error? Or is it safe to assume that the products name field will be displayed either in full or truncated...?

Many thanks,
Bjorn

Hi Bjorn

It won't trigger an error - it just won't show you the full name.
There are several places product names are shown - it sounds like you've got a handle on what to do.

Simon

Thanks Simon. I'll let you know how I get on. The run-up for christmas is not the best of times to play around with the site....

quick update - no probs at all with Cre Loaded after that I increased the products_name field in the database to varchar(500) and set the products_name field's maxlength to 240 in admin/category.php. But the Sage Form interface complains, probably because of the length of the field but need to figure out what the max length at Sage end might be. Suspect there may be similar issues with other external parties, like Google Base, as well.

There's not a lot of point increasing the product name field to 500 characters - many reasons, but in reference to sagepay form's description (max 100) and google merchant (max title of 70) you're going to be way over.

Simon