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

#   Performance with lots of variants

##

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

Less More

- Posts: 10
- Thank you received: 0
-
-

11 years 1 week ago [\#218247](#218247) by [aredman](/forum/user/5136-aredman "View aredman's Profile")  *[Performance with lots of variants](/forum/26-product-category-display/880033-performance-with-lots-of-variants#218247 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : chrome (any browser actually)  Greetings Hikashop:  I have a site where by which I have one product. There are a total of 35 varieties of the product and 45 options that can be selected for each respective 35 varieties. This creates 1470 variants and when accessing the options to select for the product I see the following:  &quot;Gateway Time-out  The gateway did not receive a timely response from the upstream server or application.&quot;  If I refresh, then I can sometimes get to the page to then select the drop-down options. I need some guidance on how to tune the shop to perform more efficiently.  Thanks so much,  Andy")* was created by *[aredman](/forum/user/5136-aredman "View aredman's Profile")*

-- HikaShop version -- : 2.6.0
-- Joomla version -- : 3.4.5
-- PHP version -- : 5.6.14
-- Browser(s) name and version -- : chrome (any browser actually)

Greetings Hikashop:

I have a site where by which I have one product. There are a total of 35 varieties of the product and 45 options that can be selected for each respective 35 varieties. This creates 1470 variants and when accessing the options to select for the product I see the following:

"Gateway Time-out

The gateway did not receive a timely response from the upstream server or application."

If I refresh, then I can sometimes get to the page to then select the drop-down options. I need some guidance on how to tune the shop to perform more efficiently.

Thanks so much,

Andy

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84ODAwMzMtcGVyZm9ybWFuY2Utd2l0aC1sb3RzLW9mLXZhcmlhbnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86323
- Thank you received: 14283
-
-

11 years 1 week ago [\#218273](#218273) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Performance with lots of variants](/forum/26-product-category-display/880033-performance-with-lots-of-variants#218273 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : chrome (any browser actually)  Greetings Hikashop:  I have a site where by which I have one product. There are a total of 35 varieties of the product and 45 options that can be selected for each respective 35 varieties. This creates 1470 variants and when accessing the options to select for the product I see the following:  &quot;Gateway Time-out  The gateway did not receive a timely response from the upstream server or application.&quot;  If I refresh, then I can sometimes get to the page to then select the drop-down options. I need some guidance on how to tune the shop to perform more efficiently.  Thanks so much,  Andy")*

Hi,

I doubt that you need 1470 variant for a product.
I'm sure that at least some options and/or characteristics could be replaced by the creation of a custom field of the table "item" via the menu Display&gt;Custom fields. These are really lightweight and you want have many of them on the page without changing anything performance-wise.

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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84ODAwMzMtcGVyZm9ybWFuY2Utd2l0aC1sb3RzLW9mLXZhcmlhbnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation.

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

Less More

- Posts: 10
- Thank you received: 0
-
-

11 years 1 week ago [\#218347](#218347) by [aredman](/forum/user/5136-aredman "View aredman's Profile")  Replied by *[aredman](/forum/user/5136-aredman "View aredman's Profile")* on topic *[Performance with lots of variants](/forum/26-product-category-display/880033-performance-with-lots-of-variants#218347 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : chrome (any browser actually)  Greetings Hikashop:  I have a site where by which I have one product. There are a total of 35 varieties of the product and 45 options that can be selected for each respective 35 varieties. This creates 1470 variants and when accessing the options to select for the product I see the following:  &quot;Gateway Time-out  The gateway did not receive a timely response from the upstream server or application.&quot;  If I refresh, then I can sometimes get to the page to then select the drop-down options. I need some guidance on how to tune the shop to perform more efficiently.  Thanks so much,  Andy")*

Thanks much for the reply. The custom fields is the key to this issue, as the product is singular, but the product does have a significant amount of options that can be selected from to customize it. I may have another solution as well. Thanks much for your recommendation.

Appreciated,

Andy

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84ODAwMzMtcGVyZm9ybWFuY2Utd2l0aC1sb3RzLW9mLXZhcmlhbnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation.

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

Less More

- Posts: 10
- Thank you received: 0
-
-

10 years 11 months ago [\#220029](#220029) by [aredman](/forum/user/5136-aredman "View aredman's Profile")  Replied by *[aredman](/forum/user/5136-aredman "View aredman's Profile")* on topic *[Performance with lots of variants](/forum/26-product-category-display/880033-performance-with-lots-of-variants#220029 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : chrome (any browser actually)  Greetings Hikashop:  I have a site where by which I have one product. There are a total of 35 varieties of the product and 45 options that can be selected for each respective 35 varieties. This creates 1470 variants and when accessing the options to select for the product I see the following:  &quot;Gateway Time-out  The gateway did not receive a timely response from the upstream server or application.&quot;  If I refresh, then I can sometimes get to the page to then select the drop-down options. I need some guidance on how to tune the shop to perform more efficiently.  Thanks so much,  Andy")*

So I've been digging into the different methods for accomplishing the objective that I'm after ... struggling a bit to accomplish.

Look at the following:
[ trex-arms.com/store/fenrir-holster/](http://trex-arms.com/store/fenrir-holster/)

You can see that one holster can have a significant amount of variants. Do you believe that custom fields is the best method to accomplish having all the different options? This is exactly what I'm after.

Thanks,

Andy

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84ODAwMzMtcGVyZm9ybWFuY2Utd2l0aC1sb3RzLW9mLXZhcmlhbnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86323
- Thank you received: 14283
-
-

10 years 11 months ago [\#220036](#220036) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Performance with lots of variants](/forum/26-product-category-display/880033-performance-with-lots-of-variants#220036 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : chrome (any browser actually)  Greetings Hikashop:  I have a site where by which I have one product. There are a total of 35 varieties of the product and 45 options that can be selected for each respective 35 varieties. This creates 1470 variants and when accessing the options to select for the product I see the following:  &quot;Gateway Time-out  The gateway did not receive a timely response from the upstream server or application.&quot;  If I refresh, then I can sometimes get to the page to then select the drop-down options. I need some guidance on how to tune the shop to perform more efficiently.  Thanks so much,  Andy")*

Hi,

If you want to do the same as there, then yes, I would go with custom item fields.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84ODAwMzMtcGVyZm9ybWFuY2Utd2l0aC1sb3RzLW9mLXZhcmlhbnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation.

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

Less More

- Posts: 10
- Thank you received: 0
-
-

10 years 11 months ago [\#220411](#220411) by [aredman](/forum/user/5136-aredman "View aredman's Profile")  Replied by *[aredman](/forum/user/5136-aredman "View aredman's Profile")* on topic *[Performance with lots of variants](/forum/26-product-category-display/880033-performance-with-lots-of-variants#220411 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : chrome (any browser actually)  Greetings Hikashop:  I have a site where by which I have one product. There are a total of 35 varieties of the product and 45 options that can be selected for each respective 35 varieties. This creates 1470 variants and when accessing the options to select for the product I see the following:  &quot;Gateway Time-out  The gateway did not receive a timely response from the upstream server or application.&quot;  If I refresh, then I can sometimes get to the page to then select the drop-down options. I need some guidance on how to tune the shop to perform more efficiently.  Thanks so much,  Andy")*

So I've created quite a few custom fields, selected single drop down and the preview is never showing a drop down. I can select other options, such as check box and they render correctly, but single or multiple drop down never show correctly.

[ ![issue.jpg](/forum/attachment/27630) ](/forum/attachment/27630 "issue.jpg")

- [ ![issue.jpg](/forum/attachment/27630) ](/forum/attachment/27630 "issue.jpg") [ ](/forum/attachment/27630?download=1 "issue.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84ODAwMzMtcGVyZm9ybWFuY2Utd2l0aC1sb3RzLW9mLXZhcmlhbnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86323
- Thank you received: 14283
-
-

10 years 11 months ago [\#220420](#220420) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Performance with lots of variants](/forum/26-product-category-display/880033-performance-with-lots-of-variants#220420 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : chrome (any browser actually)  Greetings Hikashop:  I have a site where by which I have one product. There are a total of 35 varieties of the product and 45 options that can be selected for each respective 35 varieties. This creates 1470 variants and when accessing the options to select for the product I see the following:  &quot;Gateway Time-out  The gateway did not receive a timely response from the upstream server or application.&quot;  If I refresh, then I can sometimes get to the page to then select the drop-down options. I need some guidance on how to tune the shop to perform more efficiently.  Thanks so much,  Andy")*

Hi,

Did you enter values on that page ?
The values you enter in your field are used to populate the dropdown displayed by your custom field. If you don't have any, then there is no dropdown.

Also, I told you to create custom fields of the table "item", not of the table "product", which are for something else.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84ODAwMzMtcGVyZm9ybWFuY2Utd2l0aC1sb3RzLW9mLXZhcmlhbnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation.

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

Less More

- Posts: 10
- Thank you received: 0
-
-

10 years 11 months ago [\#220535](#220535) by [aredman](/forum/user/5136-aredman "View aredman's Profile")  Replied by *[aredman](/forum/user/5136-aredman "View aredman's Profile")* on topic *[Performance with lots of variants](/forum/26-product-category-display/880033-performance-with-lots-of-variants#220535 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : chrome (any browser actually)  Greetings Hikashop:  I have a site where by which I have one product. There are a total of 35 varieties of the product and 45 options that can be selected for each respective 35 varieties. This creates 1470 variants and when accessing the options to select for the product I see the following:  &quot;Gateway Time-out  The gateway did not receive a timely response from the upstream server or application.&quot;  If I refresh, then I can sometimes get to the page to then select the drop-down options. I need some guidance on how to tune the shop to perform more efficiently.  Thanks so much,  Andy")*

Yes, I put in 35+ values, but in the 'product' table ... I missed that part before. I'm not sure where 'item' is ...

- [ ![example.jpg](/forum/attachment/27646) ](/forum/attachment/27646 "example.jpg") [ ](/forum/attachment/27646?download=1 "example.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84ODAwMzMtcGVyZm9ybWFuY2Utd2l0aC1sb3RzLW9mLXZhcmlhbnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation.

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

Less More

- Posts: 10
- Thank you received: 0
-
-

10 years 11 months ago [\#220537](#220537) by [aredman](/forum/user/5136-aredman "View aredman's Profile")  Replied by *[aredman](/forum/user/5136-aredman "View aredman's Profile")* on topic *[Performance with lots of variants](/forum/26-product-category-display/880033-performance-with-lots-of-variants#220537 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : chrome (any browser actually)  Greetings Hikashop:  I have a site where by which I have one product. There are a total of 35 varieties of the product and 45 options that can be selected for each respective 35 varieties. This creates 1470 variants and when accessing the options to select for the product I see the following:  &quot;Gateway Time-out  The gateway did not receive a timely response from the upstream server or application.&quot;  If I refresh, then I can sometimes get to the page to then select the drop-down options. I need some guidance on how to tune the shop to perform more efficiently.  Thanks so much,  Andy")*

You know, I see that 'item' is only available in the Business edition ... I won't have a very large store, perhaps (10) products, just with quite a few options as referenced previously ... and really would like to avoid moving from essential just for this functionality. Is that the only option that I have to make this simple?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84ODAwMzMtcGVyZm9ybWFuY2Utd2l0aC1sb3RzLW9mLXZhcmlhbnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation.

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

Less More

- Posts: 10
- Thank you received: 0
-
-

10 years 11 months ago [\#220538](#220538) by [aredman](/forum/user/5136-aredman "View aredman's Profile")  Replied by *[aredman](/forum/user/5136-aredman "View aredman's Profile")* on topic *[Performance with lots of variants](/forum/26-product-category-display/880033-performance-with-lots-of-variants#220538 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.6.14 -- Browser(s) name and version -- : chrome (any browser actually)  Greetings Hikashop:  I have a site where by which I have one product. There are a total of 35 varieties of the product and 45 options that can be selected for each respective 35 varieties. This creates 1470 variants and when accessing the options to select for the product I see the following:  &quot;Gateway Time-out  The gateway did not receive a timely response from the upstream server or application.&quot;  If I refresh, then I can sometimes get to the page to then select the drop-down options. I need some guidance on how to tune the shop to perform more efficiently.  Thanks so much,  Andy")*

I've answered my own question. I just upgraded and am able to accomplish the desired objective now. Thanks.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84ODAwMzMtcGVyZm9ybWFuY2Utd2l0aC1sb3RzLW9mLXZhcmlhbnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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.149 seconds

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