WooCommerce for large variations

  • Adnan

    (@hiddenpearls)


    8 years, 5 months ago

    I have 4k Product Variations in total and When I try to load all Products page at wp-admin backend. It takes forever and throws me Memory Exhausted and Maximum execution errors. What is the best way to handle such a case when you have thousands of variations. I know each Variation is a Post. but why It is being called on all products page load ?

    Product variation should be called only when you switch to Variations tab and there should be limit as well. It sucks really.

    https://www.ads-software.com/plugins/woocommerce/

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Contributor Mike Jolley (a11n)

    (@mikejolley)

    Since some of the parent props are based on the children, this is why they are loaded. Most data is however cached to transients. If you’re using 50+ variations per product, I’d seriously reconsider what you’re doing.

    To add, this is things like price, stock, availability. All are determined by the children. Please feel free to contribute if you see a way to optimise the code.

    Thread Starter Adnan

    (@hiddenpearls)

    @mikejolly

    I am building a Car parts website in which One Product has multiple variations. Infact thousands of variations ??

    Plugin Contributor Mike Jolley (a11n)

    (@mikejolley)

    Example? Why would it have to be in one product?

    Thread Starter Adnan

    (@hiddenpearls)

    My client have excel sheets like the example below.

    https://www.evernote.com/l/AMrVoniA_BFB7o70c2EriOwbyqIHKKCbeJEB/image.png

    and I added all of these columns as attributes i.e Variations.

    Plugin Contributor Mike Jolley (a11n)

    (@mikejolley)

    Does each of those items on the right have a different price/SKU?

    It could be managed as simple products and filtered via categories/in the archive. Would be a different store layout but its an option.

    Thread Starter Adnan

    (@hiddenpearls)

    Yes they (right columns) have different prices.

    There are actually more than 10 Product Database files though I think filtering via Categories would make sense but what about the situation now. I have imported Thousands of variations ??

    Plugin Contributor Mike Jolley (a11n)

    (@mikejolley)

    I guess its up to you if you want to look at improving performance with code tweaks, or reimport ??

    Thread Starter Adnan

    (@hiddenpearls)

    Code tweaks, lol, I will have to change in WooCommerce core ??

    or is there any better way that children assets are not access at all Products page ?

    Plugin Contributor Mike Jolley (a11n)

    (@mikejolley)

    Code tweaks, lol, I will have to change in WooCommerce core ??

    I did mention if you find ways to improve core you can suggest changes ?? Happy to review. But afaik no, they need to be loaded for prices, stock etc.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘WooCommerce for large variations’ is closed to new replies.