Magento – How to increase custom attribute’s text field limit

productproduct-attribute

I have a custom product attribute with input type "Text Field" .So generally magento is allowing to enter maximum 255 characters into this.

Now my query is,I don't want to limit characters into text fields. Admin can enter more then 255 characters in this custom attribute.

Best Answer

This might help you: here first name is the custom option. so change the max length value.

$productData = Mage::getSingleton('core/session')->getProductData();
$product_id = $productData['id'];
$product = Mage::getModel('catalog/product')->load($product_id);


 <?php foreach ($product->getOptions() as $_option): ?>
                    <?php if ($_option->getType() == Mage_Catalog_Model_Product_Option::OPTION_TYPE_FIELD): ?>
                        <?php if (stristr($_option->getTitle(), "first name")): ?>
                            <div class="form-group row">
                                <label class="col-sm-4 control-label line" for="options_<?php echo $_option->getId() ?>_text"><?php echo $_option->getTitle(); ?></label>
                                <div class="col-sm-8">
                                    <input  title="Enter <?php echo $_option->getTitle(); ?>" <?php if($_option->getMaxCharacters()): ?>maxlength="<?php echo $_option->getMaxCharacters() ?>"<?php endif; ?> type="text" value="<?php if (isset($options[$_option->getId()]))
                    echo $options[$_option->getId()]; ?>"  placeholder="" autocomplete="off" id="firstname" class="form-control <?php echo $_option->getIsRequire() ? ' required-entry required' : '' ?> <?php echo $_option->getMaxCharacters() ? ' validate-length maximum-length-' . $_option->getMaxCharacters() : '' ?> product-custom-option" name="options[<?php echo $_option->getId() ?>]"/>
                                </div>
                            </div> 
                        <?php endif ?>

Related Solutions

Magento – Limit text field size in product custom attribute to 80 characters

To my knowledge Magento does not allow the limiting of lengths for EAV attributes. For a varchar this gets stored in the table catalog_product_entity_varchar which has the definition value => varchar(255).

One option you could do is to add a backend model for this attribute. In this model you could write your own beforeSave function that will process the length of given value and trim it to be the desired length. The class should extend Mage_Eav_Model_Entity_Attribute_Backend_Abstract

public function beforeSave($object)
{
    $attrCode = $this->getAttribute()->getAttributeCode();
    if ($object->hasData($attrCode)) {
        $object->setData($attrCode, substr($object->getData($attrCode),0,50));
    }
    return $this;
}

Maximum Limit for Product Attribute Value in Magento 1.9

The text attributes are stores in the table catalog_product_entity_text. Their values are stores in the value column that is of type text.
You can see here the max lengths allowed for all column types.

This is what's important to you:

BLOB, TEXT               L + 2 bytes, where L < 2^16   (64 Kilobytes)

You can also use long text for an attribute, but this is more complicated. You would have to create a table similar to catalog_product_entity_text but with the column value having the type LONGTEXT.

THe max storage for this is (from the same source)

LONGBLOB, LONGTEXT       L + 4 bytes, where L < 2^32

But you will also have to search through the code to see where you need to tell magento to consider your new table. I have no idea what this will take.

I suggest using the TEXT attribute. It should be enough storage. If you plan to keep more than 64k in one column you might need to rethink your architecture.

Best Answer

Related Solutions

Magento – Limit text field size in product custom attribute to 80 characters

Maximum Limit for Product Attribute Value in Magento 1.9

Related Topic