Longer Product Name

How do I increase the length of the product name field?

The product name field can be lengthened by running these two commands in the Tools > Install SQL Patches page:

ALTER TABLE products_description MODIFY COLUMN products_name varchar(191) NOT NULL default '';
ALTER TABLE orders_products MODIFY COLUMN products_name varchar(191) NOT NULL default '';

Note that the product name data is stored in two tables. The same is true of other fields in Zen Cart; when you expand a field, be sure to do all locations. Other similar examples:

  • Company name is in the address book table and the orders table (and is stored three times in the orders table, since customer, shipping and billing can all be different).
  • Products Model is in the products and orders_products tables.

Still have questions? Use the Search box in the upper right, or try the full list of FAQs. If you can't find it there, head over to the Zen Cart support forum and ask there in the appropriate subforum. In your post, please include your Zen Cart and PHP versions, and a link to your site.

Is there an error or omission on this page? Please post to General Questions on the support forum. Or, if you'd like to open a pull request, just review the guidelines and get started. You can even PR right here.
Last modified September 28, 2022 by Scott C Wilson (94e6826).