{"id":71779,"date":"2016-06-07T15:36:44","date_gmt":"2016-06-07T19:36:44","guid":{"rendered":"http:\/\/www.templatemonster.com\/help\/?p=71779"},"modified":"2017-03-14T11:22:25","modified_gmt":"2017-03-14T15:22:25","slug":"virtuemart-3-x-how-to-change-the-product-title-length-limit-set-for-database-table-field","status":"publish","type":"post","link":"https:\/\/www.templatemonster.com\/help\/virtuemart-3-x-how-to-change-the-product-title-length-limit-set-for-database-table-field.html","title":{"rendered":"VirtueMart 3.x. How to change the product title length limit set for database table field"},"content":{"rendered":"<div class=\"video-container\">\r\n\t<iframe src=\"https:\/\/www.youtube.com\/embed\/5QfZodR6ppg\"><\/iframe>\r\n<\/div>\r\n<p>Hello, this time we will learn how to extend the <strong>title length<\/strong> of your product.<\/p>\r\n<p>Originally it is rather limited, that is why in case you need to change it, we will need to extent it in the SQL.<\/p>\r\n<p>In order to get that working, you need to follow the steps, listed below.<\/p>\r\n<ol>\r\n\t<li><p>Enter your <strong>PhpMyadmin tool<\/strong>, which can be found on your hosting server.<\/p><\/li>\r\n\t<li><p>Find the database your Joomla is connected to.<\/p><\/li>\r\n\t<li><p>After that find the table named <strong>jos_virtuemart_products<\/strong> and then open the <strong>structure<\/strong> tab.<\/p>\r\n\t\r\n<a class=\"darkbox\" href=\"\/help\/wp-content\/uploads\/2016\/06\/VirtueMart-3.x.-How-to-change-product-title-length-limit-set-for-database-table-field.jpg\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2016\/06\/VirtueMart-3.x.-How-to-change-product-title-length-limit-set-for-database-table-field-300x243.jpg\" alt=\"VirtueMart 3.x. How to change product title length limit set for database table field\" width=\"300\" height=\"243\" class=\"alignnone size-medium wp-image-71781\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/06\/VirtueMart-3.x.-How-to-change-product-title-length-limit-set-for-database-table-field-300x243.jpg 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/06\/VirtueMart-3.x.-How-to-change-product-title-length-limit-set-for-database-table-field-150x122.jpg 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/06\/VirtueMart-3.x.-How-to-change-product-title-length-limit-set-for-database-table-field.jpg 669w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\t\r\n\t<\/li>\r\n    <li><p>Here you need to find the <strong>product_name<\/strong>, its value should be changed from the <strong>char()<\/strong> to <strong>text<\/strong>.<\/p>\r\n\t\r\n<a class=\"darkbox\" href=\"\/help\/wp-content\/uploads\/2016\/06\/VirtueMart-3.x.-How-to-change-product-title-length-limit-set-for-database-table-field2.jpg\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2016\/06\/VirtueMart-3.x.-How-to-change-product-title-length-limit-set-for-database-table-field2-300x107.jpg\" alt=\"VirtueMart 3.x. How to change product title length limit set for database table field2\" width=\"300\" height=\"107\" class=\"alignnone size-medium wp-image-71780\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/06\/VirtueMart-3.x.-How-to-change-product-title-length-limit-set-for-database-table-field2-300x107.jpg 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/06\/VirtueMart-3.x.-How-to-change-product-title-length-limit-set-for-database-table-field2-150x54.jpg 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/06\/VirtueMart-3.x.-How-to-change-product-title-length-limit-set-for-database-table-field2.jpg 597w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\t\r\n\t<\/li>\r\n    <\/ol>\r\n    <p>You can enter your VirtueMart admin panel and check the products, the title that you can enter is much longer now.<\/p>\r\n<p>In case you are looking for more templates, browse our wide collection of <a href=\"https:\/\/www.templatemonster.com\/virtuemart-templates.php\"target=\"_blank\"title=\"VirtueMart Templates\">VirtueMart themes<\/a> and <a href=\"https:\/\/www.templatemonster.com\/joomla-templates.php\" target=\"_blank\">Joomla templates<\/a>! <\/p>\r\n<p>Feel free to check the detailed video tutorial below:<\/p>\r\n\r\n<a href=\"http:\/\/www.youtube.com\/watch?v=5QfZodR6ppg?width=1280&amp;height=720\" rel=\"prettyPhoto\">VirtueMart 3.x. How to change product title length limit set for database table field<\/a>","protected":false},"excerpt":{"rendered":"<p>Hello, this time we will learn how to extend the title of your product in VirtueMart.<\/p>\n","protected":false},"author":63,"featured_media":71784,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[733],"tags":[1010,2404],"_links":{"self":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/71779"}],"collection":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/users\/63"}],"replies":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/comments?post=71779"}],"version-history":[{"count":0,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/71779\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media\/71784"}],"wp:attachment":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media?parent=71779"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/categories?post=71779"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/tags?post=71779"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}