Custom Field Limit

-- HikaShop version -- : 2.4.0
-- Joomla version -- : 3.4.1
-- PHP version -- : 5.4.29
-- Browser(s) name and version -- : Firefox 33.1
-- Error-message(debug-mod must be tuned on) -- : No errors displayed

Hi

Is there a limit to the number of products that a custom field can be assigned to?

I have 47 products that have been assigned to a custom field (Text field in the Item table) but when I try to add another product to the list it is not saved. No errors are generated.

My workaround is to create a new field with a slightly different column name.

Regards
Trevor

Hi,

Yes, there is a limit. The field where the data is stored has 255 characters and the system stored in it a list of the ids of the products separated by commas. So the amount of products you can select will vary based on the length of the ids of your products.

There are two other nicer work arounds than what you do:
1. You can modify the type of the "field_products" column of the hikashop_field table in your database via phpmyadmin and change it from VARCHAR (255) to TEXT which will allow for around 65000 characters in the column for each custom field instead of 255.
2. Instead of selecting all the products in the field, I would rather recommend to create an unpublished category and select it in your field. Then, in each product where you want to add that field, add that category in the list of categories and it will add the field to the product. In that case, there are no limits on the amount of products you can add to a field.

Thanks Nicolas.

Option 2 sounds like the way to go as it enables the fields to be included without working in the back-end.

regards
Trevor

Hi Nicolas

2. Instead of selecting all the products in the field, I would rather recommend to create an unpublished category and select it in your field. Then, in each product where you want to add that field, add that category in the list of categories and it will add the field to the product. In that case, there are no limits on the amount of products you can add to a field.

When I select the category and click Save the category disappears and the field is left empty!

Any ideas?

regards
Trevor

Hi,

That's a bug of the current release. Download again the install package and install it on your website and it will add the patch for that problem.