How Do I Change Zen Cart Product & Category Title Length?
The VERY FIRST and most important thing to do is back up your Zen Cart database… Better safe than sorry.
Open your cPanel and look for phpMyAdmin. Upon opening phpMyAdmin, you will see any and all databases in your hosting account.
Locate your current Zen Cart database. If you are not sure which database it is then, check at the bottom of includes/configuration.php for database name.
Next, click the database you need in the left menu… This will open a new window and display all of the database tables in the left hand menu.
For Zen Cart products, select DATABASE-PREFIX_products_description
This will display the table entries in this table on your right.
Look for the entry products_name and click on the edit/change button in its row… Usually a “pencil” icon.
You will then see the contents of this entry, including Length/Values1 …. which by default I believe is 32. This is the number you will edit.
!!! DO NOT UNDER ANY CIRCUMSTANCES GO SHORTER THAN THE NUMBER LISTED, THIS WILL SHORTEN ALL OF YOUR EXISTING PRODUCT TITLES, WHICH CAN ONLY BE REPOPULATED BY HAND OR RESTORING THE DATABASE !!!
Change the characters number to a larger number of your choice ( recommend less than 75 characters max) and then click save in the bottom right.
When changing this Zen Cart product title its value is used in more than one location. So click the database name in the top left to return to the main phpMyAdmin database screen.
In the left menu, your Zen Cart database tables list select DATABASE-PREFIX_orders_products
You will repeat the steps above for this table editing the products_name entry to match the other entry you edited in products_description.
To change the length of your Zen Cart category name, the task is exactly as changing the product titles length, except different areas and only one edit.
In the left list/menu of your Zen Cart tables you will select DATABASE-PREFIX_categories_description
Then edit categories_name and save as before. REMEMBER DO NOT EVER GO SHORTER……
