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

#   Would be a problem to create 180 custom fields

##

- **[ingjjaa](/forum/user/38158-ingjjaa "View ingjjaa's Profile")**
- [![ingjjaa's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/38158-ingjjaa "View ingjjaa's Profile") Topic Author
- [ Offline](/forum/user/38158-ingjjaa)

Less More

- Posts: 25
- Thank you received: 0
-
-

10 years 5 months ago [\#243271](#243271) by [ingjjaa](/forum/user/38158-ingjjaa "View ingjjaa's Profile")  *[Would be a problem to create 180 custom fields](/forum/27-checkout/885122-would-be-a-problem-to-create-180-custom-fields#243271 "-- HikaShop version -- : 3.5.6 -- Joomla version -- : 3.5.2 -- PHP version -- : 5.4 -- Browser(s) name and version -- : chrome -- Error-message(debug-mod must be tuned on) -- : Maximun number of custom fields  Hi i know that that would sound crazy i thought that when my customer required me that but he want to have 180 fields, those field is going to be just text but i have never see any mysql table with around 200 columns, Do you think that could be possible or it could create any problem???")* was created by *[ingjjaa](/forum/user/38158-ingjjaa "View ingjjaa's Profile")*

-- HikaShop version -- : 3.5.6
-- Joomla version -- : 3.5.2
-- PHP version -- : 5.4
-- Browser(s) name and version -- : chrome
-- Error-message(debug-mod must be tuned on) -- : Maximun number of custom fields

Hi i know that that would sound crazy i thought that when my customer required me that but he want to have 180 fields, those field is going to be just text but i have never see any mysql table with around 200 columns, Do you think that could be possible or it could create any problem???

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg4NTEyMi13b3VsZC1iZS1hLXByb2JsZW0tdG8tY3JlYXRlLTE4MC1jdXN0b20tZmllbGRzP3RtcGw9bWFya2Rvd24=) 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: 86561
- Thank you received: 14307
-
-

10 years 4 months ago [\#243291](#243291) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Would be a problem to create 180 custom fields](/forum/27-checkout/885122-would-be-a-problem-to-create-180-custom-fields#243291 "-- HikaShop version -- : 3.5.6 -- Joomla version -- : 3.5.2 -- PHP version -- : 5.4 -- Browser(s) name and version -- : chrome -- Error-message(debug-mod must be tuned on) -- : Maximun number of custom fields  Hi i know that that would sound crazy i thought that when my customer required me that but he want to have 180 fields, those field is going to be just text but i have never see any mysql table with around 200 columns, Do you think that could be possible or it could create any problem???")*

Hi,

It's not a problem.
MySQL can handle up to 4000 columns in a table.
Of course, the more columns in the table, the slower the queries are so it's best to try to not have too many of them. But 200 should still be fine unless you have hundred of thousands of entries in the table.

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

- **[ingjjaa](/forum/user/38158-ingjjaa "View ingjjaa's Profile")**
- [![ingjjaa's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/38158-ingjjaa "View ingjjaa's Profile") Topic Author
- [ Offline](/forum/user/38158-ingjjaa)

Less More

- Posts: 25
- Thank you received: 0
-
-

10 years 4 months ago [\#243374](#243374) by [ingjjaa](/forum/user/38158-ingjjaa "View ingjjaa's Profile")  Replied by *[ingjjaa](/forum/user/38158-ingjjaa "View ingjjaa's Profile")* on topic *[Would be a problem to create 180 custom fields](/forum/27-checkout/885122-would-be-a-problem-to-create-180-custom-fields#243374 "-- HikaShop version -- : 3.5.6 -- Joomla version -- : 3.5.2 -- PHP version -- : 5.4 -- Browser(s) name and version -- : chrome -- Error-message(debug-mod must be tuned on) -- : Maximun number of custom fields  Hi i know that that would sound crazy i thought that when my customer required me that but he want to have 180 fields, those field is going to be just text but i have never see any mysql table with around 200 columns, Do you think that could be possible or it could create any problem???")*

Thanks for the answer and i would like to ask you the 180 fields are going to field text fields is there any way that i could create them by mysql o duplicate one 100 times ![XD](/laugh.gif "XD")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg4NTEyMi13b3VsZC1iZS1hLXByb2JsZW0tdG8tY3JlYXRlLTE4MC1jdXN0b20tZmllbGRzP3RtcGw9bWFya2Rvd24=) 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: 86561
- Thank you received: 14307
-
-

10 years 4 months ago [\#243382](#243382) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Would be a problem to create 180 custom fields](/forum/27-checkout/885122-would-be-a-problem-to-create-180-custom-fields#243382 "-- HikaShop version -- : 3.5.6 -- Joomla version -- : 3.5.2 -- PHP version -- : 5.4 -- Browser(s) name and version -- : chrome -- Error-message(debug-mod must be tuned on) -- : Maximun number of custom fields  Hi i know that that would sound crazy i thought that when my customer required me that but he want to have 180 fields, those field is going to be just text but i have never see any mysql table with around 200 columns, Do you think that could be possible or it could create any problem???")*

Hi,

You would have to add the columns in the destination table by hand via phpmyadmin and then run an export/import on the hikashop_field table to create the corresponding entries there.
So it's possible if you know your way around in phpmyadmin.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg4NTEyMi13b3VsZC1iZS1hLXByb2JsZW0tdG8tY3JlYXRlLTE4MC1jdXN0b20tZmllbGRzP3RtcGw9bWFya2Rvd24=) 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.052 seconds

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