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

#   Product characteristics and variant records

##

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

Less More

- Posts: 15
- Thank you received: 0
-
-

13 years 6 months ago [\#103874](#103874) by [jwatson912](/forum/user/9699-jwatson912 "View jwatson912's Profile")  *[Product characteristics and variant records](/forum/2-general-talk-about-hikashop/81846-product-characteristics-and-variant-records#103874 "Hi,  I offer a (custom) product that has 3 different characteristics(size,color option 1, and color option 2). The 1st characteristic has 13 choices. The 2nd and 3rd characteristics both have 20 choices. This generates approximately 5,200 variant records. This large number of records slows the server and sometimes creates a 500 error when the product is accessed. Is there a way to maintain the product characteristics without creating a record for every possible combination. In my situation the only thing that is changing is the color/size of the item. So, I do not require any changes (price, weight, ect...) across these variants.  I've tried to create a new product and split the number of the 1st characteristic (child and adult sizes) to receive 2500 variants, but the number of records was still to large. Any help is greatly appreciated!  Thanks")* was created by *[jwatson912](/forum/user/9699-jwatson912 "View jwatson912's Profile")*

Hi,

I offer a (custom) product that has 3 different characteristics(size,color option 1, and color option 2). The 1st characteristic has 13 choices. The 2nd and 3rd characteristics both have 20 choices. This generates approximately 5,200 variant records. This large number of records slows the server and sometimes creates a 500 error when the product is accessed. Is there a way to maintain the product characteristics without creating a record for every possible combination. In my situation the only thing that is changing is the color/size of the item. So, I do not require any changes (price, weight, ect...) across these variants.

I've tried to create a new product and split the number of the 1st characteristic (child and adult sizes) to receive 2500 variants, but the number of records was still to large. Any help is greatly appreciated!

Thanks

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgxODQ2LXByb2R1Y3QtY2hhcmFjdGVyaXN0aWNzLWFuZC12YXJpYW50LXJlY29yZHM/dG1wbD1tYXJrZG93bg==) 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: 86576
- Thank you received: 14320
-
-

13 years 6 months ago [\#103913](#103913) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product characteristics and variant records](/forum/2-general-talk-about-hikashop/81846-product-characteristics-and-variant-records#103913 "Hi,  I offer a (custom) product that has 3 different characteristics(size,color option 1, and color option 2). The 1st characteristic has 13 choices. The 2nd and 3rd characteristics both have 20 choices. This generates approximately 5,200 variant records. This large number of records slows the server and sometimes creates a 500 error when the product is accessed. Is there a way to maintain the product characteristics without creating a record for every possible combination. In my situation the only thing that is changing is the color/size of the item. So, I do not require any changes (price, weight, ect...) across these variants.  I've tried to create a new product and split the number of the 1st characteristic (child and adult sizes) to receive 2500 variants, but the number of records was still to large. Any help is greatly appreciated!  Thanks")*

Hi,

Then maybe you actually don't want to use characteristics but options ( [ www.hikashop.com/en/support/documentatio...ct-form.html#options](http://www.hikashop.com/en/support/documentation/integrated-documentation/19-hikashop-product-form.html#options) ) or custom fields of the table "item" ( [ www.hikashop.com/en/support/documentatio...p-field-listing.html](http://www.hikashop.com/en/support/documentation/41-hikashop-field-listing.html) ). Each one has a pros and cons. One of the pros of options and custom fields is that they are light weight as they don't create variants for the product (which is a cons if you need to change the price/image, etc per variant).

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

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

Less More

- Posts: 15
- Thank you received: 0
-
-

13 years 6 months ago -  13 years 6 months ago [\#103935](#103935) by [jwatson912](/forum/user/9699-jwatson912 "View jwatson912's Profile")  Replied by *[jwatson912](/forum/user/9699-jwatson912 "View jwatson912's Profile")* on topic *[Product characteristics and variant records](/forum/2-general-talk-about-hikashop/81846-product-characteristics-and-variant-records#103935 "Hi,  I offer a (custom) product that has 3 different characteristics(size,color option 1, and color option 2). The 1st characteristic has 13 choices. The 2nd and 3rd characteristics both have 20 choices. This generates approximately 5,200 variant records. This large number of records slows the server and sometimes creates a 500 error when the product is accessed. Is there a way to maintain the product characteristics without creating a record for every possible combination. In my situation the only thing that is changing is the color/size of the item. So, I do not require any changes (price, weight, ect...) across these variants.  I've tried to create a new product and split the number of the 1st characteristic (child and adult sizes) to receive 2500 variants, but the number of records was still to large. Any help is greatly appreciated!  Thanks")*

Hi,

After I've created a custom field (drop down box), how do I get it to appear in product?

[ ![screenshot.png](/forum/attachment/10145) ](/forum/attachment/10145 "screenshot.png")

- [ ![screenshot.png](/forum/attachment/10145) ](/forum/attachment/10145 "screenshot.png") [ ](/forum/attachment/10145?download=1 "screenshot.png")

Last edit: 13 years 6 months ago by [jwatson912](/forum/user/9699-jwatson912 "View jwatson912's Profile").

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

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26401
- Thank you received: 4081
-
- [](http://obsi.dev)
-

13 years 6 months ago [\#103943](#103943) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Product characteristics and variant records](/forum/2-general-talk-about-hikashop/81846-product-characteristics-and-variant-records#103943 "Hi,  I offer a (custom) product that has 3 different characteristics(size,color option 1, and color option 2). The 1st characteristic has 13 choices. The 2nd and 3rd characteristics both have 20 choices. This generates approximately 5,200 variant records. This large number of records slows the server and sometimes creates a 500 error when the product is accessed. Is there a way to maintain the product characteristics without creating a record for every possible combination. In my situation the only thing that is changing is the color/size of the item. So, I do not require any changes (price, weight, ect...) across these variants.  I've tried to create a new product and split the number of the 1st characteristic (child and adult sizes) to receive 2500 variants, but the number of records was still to large. Any help is greatly appreciated!  Thanks")*

Hi,

The "product" custom field is stored in the product table and is seen as a fixed value in the product page.
The "item" custom field is stored in the user cart. The customer will have to select a value in the product page.

To resume
product : the drop down is displayed in the backend. Value displayed in the front-end product page.
item : the drop down is displayed in the front-end. Value displayed in the backend order page.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

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

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

Less More

- Posts: 15
- Thank you received: 0
-
-

13 years 6 months ago -  13 years 6 months ago [\#103965](#103965) by [jwatson912](/forum/user/9699-jwatson912 "View jwatson912's Profile")  Replied by *[jwatson912](/forum/user/9699-jwatson912 "View jwatson912's Profile")* on topic *[Product characteristics and variant records](/forum/2-general-talk-about-hikashop/81846-product-characteristics-and-variant-records#103965 "Hi,  I offer a (custom) product that has 3 different characteristics(size,color option 1, and color option 2). The 1st characteristic has 13 choices. The 2nd and 3rd characteristics both have 20 choices. This generates approximately 5,200 variant records. This large number of records slows the server and sometimes creates a 500 error when the product is accessed. Is there a way to maintain the product characteristics without creating a record for every possible combination. In my situation the only thing that is changing is the color/size of the item. So, I do not require any changes (price, weight, ect...) across these variants.  I've tried to create a new product and split the number of the 1st characteristic (child and adult sizes) to receive 2500 variants, but the number of records was still to large. Any help is greatly appreciated!  Thanks")*

Hi,

What do I have to do so that the fixed values (drop down options) are accessible to the customer in the product page? Also what should be done to have the customers selected value appear in the order on the back-end for processing?

Thanks Again,

Last edit: 13 years 6 months ago by [jwatson912](/forum/user/9699-jwatson912 "View jwatson912's Profile").

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

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26401
- Thank you received: 4081
-
- [](http://obsi.dev)
-

13 years 6 months ago [\#103982](#103982) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Product characteristics and variant records](/forum/2-general-talk-about-hikashop/81846-product-characteristics-and-variant-records#103982 "Hi,  I offer a (custom) product that has 3 different characteristics(size,color option 1, and color option 2). The 1st characteristic has 13 choices. The 2nd and 3rd characteristics both have 20 choices. This generates approximately 5,200 variant records. This large number of records slows the server and sometimes creates a 500 error when the product is accessed. Is there a way to maintain the product characteristics without creating a record for every possible combination. In my situation the only thing that is changing is the color/size of the item. So, I do not require any changes (price, weight, ect...) across these variants.  I've tried to create a new product and split the number of the 1st characteristic (child and adult sizes) to receive 2500 variants, but the number of records was still to large. Any help is greatly appreciated!  Thanks")*

Hi,

Well, as explain in my previous post, product custom field are not the right solution.
So you have to delete the product custom field and create an item custom field.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

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

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

Less More

- Posts: 15
- Thank you received: 0
-
-

13 years 6 months ago [\#104111](#104111) by [jwatson912](/forum/user/9699-jwatson912 "View jwatson912's Profile")  Replied by *[jwatson912](/forum/user/9699-jwatson912 "View jwatson912's Profile")* on topic *[Product characteristics and variant records](/forum/2-general-talk-about-hikashop/81846-product-characteristics-and-variant-records#104111 "Hi,  I offer a (custom) product that has 3 different characteristics(size,color option 1, and color option 2). The 1st characteristic has 13 choices. The 2nd and 3rd characteristics both have 20 choices. This generates approximately 5,200 variant records. This large number of records slows the server and sometimes creates a 500 error when the product is accessed. Is there a way to maintain the product characteristics without creating a record for every possible combination. In my situation the only thing that is changing is the color/size of the item. So, I do not require any changes (price, weight, ect...) across these variants.  I've tried to create a new product and split the number of the 1st characteristic (child and adult sizes) to receive 2500 variants, but the number of records was still to large. Any help is greatly appreciated!  Thanks")*

Okay, I got it. Works great now. Thanks Jerome!

Best regard,

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

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