Results 1 to 4 of 4

Hybrid View

  1. #1
    Join Date
    Jun 2010
    Posts
    23
    Plugin Contributions
    0

    Default 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.
    Last edited by shinypenguin; 13 Feb 2013 at 09:36 PM. Reason: Added version

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default 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

  3. #3
    Join Date
    Jun 2010
    Posts
    23
    Plugin Contributions
    0

    Default 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.

  4. #4
    Join Date
    Jan 2004
    Posts
    66,380
    Blog Entries
    7
    Plugin Contributions
    274

    Default 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.

 

 

Similar Threads

  1. v139h increasing Product Category Name character limitation?
    By kevinmc3 in forum General Questions
    Replies: 3
    Last Post: 19 Nov 2012, 10:20 PM
  2. Problem increasing Option Value Length - Please Help
    By Sam74 in forum Setting Up Categories, Products, Attributes
    Replies: 8
    Last Post: 23 Jun 2011, 10:13 AM
  3. Increasing the option comments length
    By ktomas in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 23 Dec 2009, 09:42 PM
  4. Increasing Size of Product Name Field
    By Jay Gee in forum Templates, Stylesheets, Page Layout
    Replies: 10
    Last Post: 14 Nov 2009, 07:39 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR