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 theorders
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
andorders_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).