Extend number of characters in product reference.

[nzrobert]

Hi there,

I would like to change the number of characters allowed in the reference field from 32 characters to 256 characters.
I have changed the database field from varchar(32) to varchar(256), but what else do i need to change.

How do i change the error in the backoffice that comes up when i enter more than 32 characters?

Cheers
Robert

[rocky]

You must change line 157 of classes/Product.php from:

protected $fieldsSize = array('reference' => 32, 'supplier_reference' => 32, 'location' => 64, 'ean13' => 13);

to:

protected $fieldsSize = array('reference' => 256, 'supplier_reference' => 32, 'location' => 64, 'ean13' => 13);

[nartov]

You must change line 157 of classes/Product.php from:<br/><br/>

<br/>protected $fieldsSize = array('reference' => 32, 'supplier_reference' => 32, 'location' => 64, 'ean13' => 13);<br/>

<br/><br/>to:<br/><br/>

<br/>protected $fieldsSize = array('reference' => 256, 'supplier_reference' => 32, 'location' => 64, 'ean13' => 13);<br/>

 

 

Thanks . It worked perfectly...THANKS a lot, guys. With this im doing the google category thing. Google category is recomended by google for feed , so im using the field location for google category according to Taxonomy http://www.google.com/support/merchants/bin/answer.py?answer=160081