How to manage a product with 8 charateristic and a total of 1800 Variant

  • Posts: 117
  • Thank you received: 3
8 years 4 months ago #260654

-- HikaShop version -- : 3.0.0
-- Joomla version -- : 3.6.4
-- PHP version -- : 5.5
-- Browser(s) name and version -- : firefox
-- Error-message(debug-mod must be tuned on) -- : Service Unavailable

The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.

Additionally, a 503 Service Unavailable error was encountered while trying to use an ErrorDocument to handle the request.

I have an ecommerce with particular product that can be personalized.

For example a single product can have till 2000 variants.

My server can't generate the page.

I want to ask you if it's only a problem of server or hika can't support so much variants?

If i buy a faster server, it always need a lot of time ti generate the page?

Please Log in or Create an account to join the conversation.

  • Posts: 26247
  • Thank you received: 4038
  • MODERATOR
8 years 4 months ago #260672

Hi,

If you have 8 characteristics and 1800 variants ; you definitively do not choose the right way to configure your product.

It would be far better to use "item custom field" (or options) in order to let the customer choose some specificity which will not impact the image, the stock or the product description.
Even with item custom field you can, thanks to a plugin, change the product price.

But having 1800 variants means you really have 1800 different products in your store and each product have his own product stock.

Regards,


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

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 117
  • Thank you received: 3
8 years 4 months ago #260914

Jerome wrote: Hi,

If you have 8 characteristics and 1800 variants ; you definitively do not choose the right way to configure your product.

It would be far better to use "item custom field" (or options) in order to let the customer choose some specificity which will not impact the image, the stock or the product description.
Even with item custom field you can, thanks to a plugin, change the product price.

But having 1800 variants means you really have 1800 different products in your store and each product have his own product stock.

Regards,

I understand your point of view, but this particular product has a lot of configuration: 3 dimension, 2 different part with different color and material, and other caratheristic.

I have a page with 50.000 lines of HTML code: hikashop infact create for each combination (non only for each variant!!!) the part to substitute inside the html, either for non available variant!!!

Do you think it's possible to develope a plugin that can charge from database only the values of the main product, and when i chose a variant, it read from db only the values of that variant, insted write all the values in the html code?

Will you ever implement such feature in HikaShop?

Last edit: 8 years 4 months ago by crealiagroup.

Please Log in or Create an account to join the conversation.

  • Posts: 83905
  • Thank you received: 13581
  • MODERATOR
8 years 4 months ago #260916

Hi,

The HTML page should display quite fast with 84 variants. We've seen people with 300 variants for their products with pages loading under 1 second. Now it depends on the speed of the server, and the total amount of products you have on the shop. If you have 10 000 products with 87 variants each, that's 870 000 entries in the hikashop_product table which starts to be quite a lot and can slow down the MySQL queries.

Having the HTML directly available on the page without AJAX has the advantage that the update of the data on the page is instantaneous when you change the selection.
Making it with AJAX instead is something we want to work on in the future.
So it's surely possible to have that developed. The development won't be simple as there will probably be a few hundred lines of code to write but it's totally possible.

Please Log in or Create an account to join the conversation.

  • Posts: 117
  • Thank you received: 3
8 years 4 months ago #261044

Thanks Nicolas for reply.

Any idea about when you'll plan to work on AJAX for this feature?

Thanks in advance.

Please Log in or Create an account to join the conversation.

  • Posts: 26247
  • Thank you received: 4038
  • MODERATOR
8 years 4 months ago #261064

Hi,

No, we do not have any precise schedule.
We already have a huge TODO list and a lot to do for HikaShop 3.0
But sometimes, custom projects allow to "speed up" the implementation of some features.

Regards,


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

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

Time to create page: 0.066 seconds
Powered by Kunena Forum