Thousands of variations per product causing failed backend queries.

  • Resolved garthroliver

    (@garthroliver)


    3 months, 3 weeks ago

    Some Context

    Our client has products that are provided by fire departments all over Washington and Oregon. There are only 12 products being offered, however these products have 300-9,000 variations – 50k+ in total.

    The department attribute is responsible for a majority of the variations and is quite important, as it allows users to know which products are available based on their location/jurisdiction.

    The Issues

    The store listings and product page on in the admin would often crash, so I custombuilt both views to avoid WooCommerce having to run through all variations to determine a price range. I couldn’t find a way around that without having to touch the plugin’s code itself.

    Outside of that, I continue to experience long load times when filtering the products on the product pages and see a ton of killed queries in our WPEngine Error Logs.

    Here’s an example:

    Any recommendations on how to get around this would be greatly appreciated! I can also provide a full error report if necessary.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello garthroliver,

    Thank you for contacting Woo support.

    I understand you facing a problem where queries are killed by your server.
    As you have already suggested, this could be caused by the huge number of variations.

    The best solution would be to reduce the number of variations.
    Since you have stock quantity based on locations I recommend using Multi Inventory Management for WooCommerce plugin.

    This plugin will allow you to remove the “department” attribute and use it as a location.
    The result will be the same, the customer will only be able to purchase if the stock is available in that location.

    For more details, check the plugin page and the documentation.
    Please note that this plugin has a 30-day money-back guarantee.

    Another idea is to remove the attributes that do not affect stock or price.
    For example, noticed that the Color attribute on this product does not change.
    It always remains Antique White.

    Looking forward to your response. ??

    Best regards.

    Thread Starter garthroliver

    (@garthroliver)

    Thanks so much for the reply Zubair!

    The above mentioned plugin seems like it would work. My only question is if this allows for a unique SKU for each variation within every department.

    These two variations, for example:

    These product variations are identical, with the exception of the department that offers them. Our client has a specific SKU for each variation that has to be shown.

    Thanks again!

    • This reply was modified 3 months, 3 weeks ago by garthroliver.
    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello garthroliver,

    Thank you for your reply.

    I am glad to hear that you are considering my suggestion. ??

    To ensure you receive the most effective support, I recommend creating a support ticket at Woo.com.
    By doing so, you’ll be in direct contact with our experts who specialize in resolving such problems.

    When you create a ticket mention this forum link in that ticket.
    Also, share your ticket number with me here so I can make sure you get a prompt follow-up.

    You may get an automated AI response to your ticket.
    Please ignore that and wait for our Happiness Engineer to contact you.

    Let me know if you have any questions.

    Best regards.

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.