Too many variations?

  • bydelight

    (@bydelight)


    11 years, 7 months ago

    When I load a product with many variations (more than 700…) I get an internal server error. The host increased the memory (now 256mb) and time-out (now 500) allowed because these were the initial errors I got. I tend to start getting errors after around 700, 1000, 1300 variations are loaded (max I have been able to load is just over 2000).

    Anyone else have any problems loading products with many variations?

    This is the specific message that comes up in the Variations area. Sometimes when I update the page afterwards a few more variations have been added:

    Internal Server Error
    The server encountered an internal error or misconfiguration and was unable to complete your request.Please contact the server administrator and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
    Apache/2.2.27 (Unix) mod_ssl/2.2.27 OpenSSL/1.0.1e-fips DAV/2 mod_bwlimited/1.4

    Any help is much appreciated!

    https://ww.wp.xz.cn/plugins/wp-e-commerce/

Viewing 4 replies - 1 through 4 (of 4 total)
  • whitelamp

    (@whitelamp)

    11 years, 7 months ago

    The variations feature isn’t really intended to handle so many variations, as best I know. Why do you want so many? Can you not have separate products?

    Jeffrey Schutzman

    (@jeffpyebrookcom)

    11 years, 7 months ago

    Hi bydelight,

    Your going to run into these issues with too many variations, or high magnitude on variations. The variations feature can usually handle one modifier. Sometimes two if both are small. You will quickly hit an issue where the cartesian product of the variables will kill your server.

    Under the hood, variations create child posts of your main product with one child for each combination of variations. Each child gets copies of the critical product data, and inherits data from the parent. That means that if you have 7 sizes and 10 colors the system will try to create 70 products. That means inserting 70 posts. THat is going to take time and memory.

    It’s my opinion that the best solution to problem will likely be abandoning variations, and using one of the the product options plugins that are available.

    Lee Willis has written a plugin that gives basic product options without using variations, the options can’t change product price and the controls available for selecting the options are a limited. It is easy to setup for simple cases.

    I have written a plugin that does very intricate product options that can change the final product price. It is a little more involved to setup. Dropdown, text, checkbox, image list and text area controls are supported. My plugin is being used on bling-transfers.com to change the product type, add optional text and pick colors.

    Post back if you have more questions.
    Jeff

    Thread Starter bydelight

    (@bydelight)

    11 years, 7 months ago

    Jeff, Thank you very much for the reply, what is the name of Lee Willis’s plugin? I would like to give it a try because the variations are designs and do not affect the price. I checked on his website but did not see a plugin matching your description. What is the name of your plugin?

    Thread Starter bydelight

    (@bydelight)

    11 years, 7 months ago

    Ok I found Lee’s plugin, not yours yet, please send me a link, I would like to test it too, as it might simplify some other products we have.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Too many variations?’ is closed to new replies.