[Skip to main content](#vessel-content)

#   Custom Field Limit

##

- **[trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")**
- [![trevsmiff's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar9214.jpg)](/forum/user/9214-trevsmiff "View trevsmiff's Profile") Topic Author
- [ Offline](/forum/user/9214-trevsmiff)

Less More

- Posts: 306
- Thank you received: 42
-
-

11 years 6 months ago [\#200431](#200431) by [trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")  *[Custom Field Limit](/forum/32-content-creation/876721-custom-field-limit#200431 "-- 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")* was created by *[trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")*

-- 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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2NvbnRlbnQtY3JlYXRpb24vODc2NzIxLWN1c3RvbS1maWVsZC1saW1pdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86564
- Thank you received: 14311
-
-

11 years 6 months ago [\#200478](#200478) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Custom Field Limit](/forum/32-content-creation/876721-custom-field-limit#200478 "-- 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.

The following user(s) said Thank You: [trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2NvbnRlbnQtY3JlYXRpb24vODc2NzIxLWN1c3RvbS1maWVsZC1saW1pdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")**
- [![trevsmiff's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar9214.jpg)](/forum/user/9214-trevsmiff "View trevsmiff's Profile") Topic Author
- [ Offline](/forum/user/9214-trevsmiff)

Less More

- Posts: 306
- Thank you received: 42
-
-

11 years 6 months ago [\#200482](#200482) by [trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")  Replied by *[trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")* on topic *[Custom Field Limit](/forum/32-content-creation/876721-custom-field-limit#200482 "-- 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")*

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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2NvbnRlbnQtY3JlYXRpb24vODc2NzIxLWN1c3RvbS1maWVsZC1saW1pdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")**
- [![trevsmiff's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar9214.jpg)](/forum/user/9214-trevsmiff "View trevsmiff's Profile") Topic Author
- [ Offline](/forum/user/9214-trevsmiff)

Less More

- Posts: 306
- Thank you received: 42
-
-

11 years 6 months ago [\#200526](#200526) by [trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")  Replied by *[trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")* on topic *[Custom Field Limit](/forum/32-content-creation/876721-custom-field-limit#200526 "-- 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 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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2NvbnRlbnQtY3JlYXRpb24vODc2NzIxLWN1c3RvbS1maWVsZC1saW1pdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86564
- Thank you received: 14311
-
-

11 years 6 months ago [\#200560](#200560) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Custom Field Limit](/forum/32-content-creation/876721-custom-field-limit#200560 "-- 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,

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.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2NvbnRlbnQtY3JlYXRpb24vODc2NzIxLWN1c3RvbS1maWVsZC1saW1pdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.068 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
