Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    729
    Plugin Contributions
    0

    Default Increase Product Name Field

    hello there,

    how do i increase the number of characters you can enter on the product name field when entering new products.

    any help would be much appreciated.

    thank you :)

  2. #2
    Join Date
    Jan 2004
    Posts
    60,240
    Blog Entries
    4
    Plugin Contributions
    139

    Default Re: Increase Product Name Field

    The default limit is 64 characters, and is determined from your database structure.

    If you want to make it longer, simply use phpMyAdmin to change the "products_name" field in the products_description table to a longer length.

    Be sure to do a database backup first.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donations always welcome: www.zen-cart.com/donate

    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.



  3. #3
    Join Date
    Jul 2006
    Posts
    16
    Plugin Contributions
    0

    Default Re: Increase Product Name Field

    I am trying to lengthen the product name to recieve a longer description on the packing slip and/or invoice. I went into my data base
    and changed only the field length and I recieved the error listed below. Any ideas what I need to do different. Thank You

    Error
    SQL query:

    ALTER TABLE `zen_products_description` CHANGE `products_name` `products_name` LONGTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL

    MySQL said:

    #1170 - BLOB/TEXT column 'products_name' used in key specification without a key length

 

 

Similar Threads

  1. Urgent: Subcategories don't display when products exist
    By cfe in forum Templates, Stylesheets, Page Layout
    Replies: 6
    Last Post: 11 Jul 2006, 07:55 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
  •