oscommerce increase product name length, longer product name

If you ever had a problem with the length of the product name and it was cut off or truncated then here’s the simple solution. Here is the snapshot of the problem

osCommerce Product Name truncated

osCommerce Product Name truncated

I had previously:

osCommerce has a character limit on the product name of 64 characters. I’ll show two ways: one using phpMyAdmin via cPanel and the other using my MySQL IDE dbForge Studio for MySQL.

Change character length of product name of osCommerce using phpMyAdmin

Click on the phpMyAdmin icon

phpMyAdmin via cPanel

phpMyAdmin via cPanel

Then login to the phpMyAdmin. Some webhosts now force you to login to the phyMyAdmin after you login to cPanel. This is for security reasons.

phpMyAdmin Login Page

phpMyAdmin Login Page

Click on the osCommerce database. The click on the table ‘products_description’.

Click on the pencil icon corresponding to the column name ‘products_name’.

osCommerce Products Name Column

osCommerce Products Name Column

Change the Length/Values field of the ‘product_name’ column. Then click the Save button.

osCommerce Change Products Name Character Length

osCommerce Change Products Name Character Length

Change product name length of osCommerce using dbForge MySQL

It’s a little bit easier with the MySQL IDE that I use. I just double-click on the column name ‘products_name’ of the table ‘products_description’.

dbForge Products Description Table

dbForge Products Description Table

Then just change the Length/Values field as shown.

dbFroge Products Name Change Length osCommerce

dbFroge Products Name Change Length osCommerce

Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Share

You must be logged in to post a comment.