Results 1 to 3 of 3

Hybrid View

  1. #1
    Join Date
    May 2006
    Posts
    725
    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
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

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

  3. #3
    Join Date
    Jul 2006
    Posts
    15
    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. Increase length of Product Image URL field?
    By KNM Computers in forum Customization from the Admin
    Replies: 9
    Last Post: 25 Jul 2013, 04:39 PM
  2. Increase product name for new product
    By gloerick in forum Customization from the Admin
    Replies: 10
    Last Post: 13 Apr 2012, 10:11 PM
  3. Increase Product Name Character Count
    By sports guy in forum Basic Configuration
    Replies: 4
    Last Post: 13 Aug 2010, 04:36 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