If this is your first visit, check our documentation. To post, register or login.
Forums / Basic Configuration / Increasing Product Name Length -- Can it cause problems?

Increasing Product Name Length -- Can it cause problems?

Started by shinypenguin on 13 Feb 2013, 8:33 PM · Views: 772

Results 1 to 4 of 4
13 Feb 2013, 8:33 PM
#1
shinypenguin avatar

shinypenguin

New Zenner

Join Date:
Jun 2010
Posts:
23
Plugin Contributions:
0

Increasing Product Name Length -- Can it cause problems?

I would like to extend the products_name length from the default of 64 characters to around 80. I know how to change the field length in the database to accomplish this, but I'm worried it may cause issues with other code expecting the name under a certain length.

I've searched on this forum and Google, but haven't found any reported issues.

Is there a maximum recommended limit, or has anyone changed the length and had problems? Mainly worried about checkout processes (Authorize.net and Google Checkout), since they are difficult to test for errors.

13 Feb 2013, 9:10 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Increasing Product Name Length -- Can it cause problems?

I know how to change the field length in the database to accomplish this
That is what would be required
But really 80 characters??

Can not chime in on Payment modules

I suggest you rethink your product naming schema

Zen-Venom Get Bitten

13 Feb 2013, 9:52 PM
#3
shinypenguin avatar

shinypenguin

New Zenner

Join Date:
Jun 2010
Posts:
23
Plugin Contributions:
0

Re: Increasing Product Name Length -- Can it cause problems?

Thank you for the feedback.

Most titles are kept as short as possible, but a couple need subtitles to differentiate the names.. 70 chars is the longest so far, so I figured 80 would be the worst-case scenario before shortening with an ellipsis or doing some serious butchering to cut it down.

I implemented the new length and haven't encountered issues while testing so far... will update if problems arise.

13 Feb 2013, 10:23 PM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Increasing Product Name Length -- Can it cause problems?

There are other database tables which store that information for later reference, such as orders_products. If you don't update those other tables as well, then the data will be truncated and irretrievable.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.