Title: Load Tested?
Last modified: August 30, 2016

---

# Load Tested?

 *  Resolved [JboyJW](https://wordpress.org/support/users/jboyjw/)
 * (@jboyjw)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/load-tested/)
 * I have been quite happy with this plugin for adding wholesale price ability. 
   But we recently added 8 products that need to have about 7000 variations each…
   After adding these products in, the Admin product list would no longer load, 
   we’d get a Page Not Found error (I’m assuming it’s trying to find an error page
   and can’t find it).
 * Anyway, I put the site in maintenance mode, deactivated all plugins except for
   WooCommerce and tested again. The Admin product list page would take a little
   while (30 seconds or so) but it would load (I also had to set the memory_limit
   to 768M). As soon as I then activate the WooCommerce Wholesale Prices plugin 
   again, the Admin product list no longer loads, even when I sent the memory_limit
   to 1024M.
 * I’m assuming that this is because the product list page shows the Price span 
   and shows the Wholesale span which means it has to read EVERY variation to do
   so… I just wanted to check if you guys had done crazy load testing on this plugin
   and if the queries you’ve patched in to bring back the Wholesale prices are as
   optimized as they can be.
 * Cheers!
 * [https://wordpress.org/plugins/woocommerce-wholesale-prices/](https://wordpress.org/plugins/woocommerce-wholesale-prices/)

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

 *  Plugin Author [Josh Kohlbach](https://wordpress.org/support/users/jkohlbach/)
 * (@jkohlbach)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/load-tested/#post-6617705)
 * Hi JboyJW,
 * Thanks for the message.
 * 7000 variations on a product is absolutely huge and beyond what WooCommerce itself
   recommends, are you sure this is the best setup for these products?
 * Can you provide a little more context as to what led you to use 7k variations
   on a single product?
 * The cause of this loading issue is likely the wholesale prices columns which 
   you can dequeue in your functions.php file by doing the following:
 * [https://wholesalesuiteplugin.com/kb/how-to-remove-the-pricing-column-from-your-product-list/](https://wholesalesuiteplugin.com/kb/how-to-remove-the-pricing-column-from-your-product-list/)
 *  Thread Starter [JboyJW](https://wordpress.org/support/users/jboyjw/)
 * (@jboyjw)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/load-tested/#post-6617712)
 * Aha! That’s very helpful, thank you!
 * Unfortunately the front end is also extremely slow so this is just not going 
   to work. We have are using a colorizer plugin that allows us to update the colours
   of the product with css but the colors need to be variations. And we have 25 
   colors that get applied to two places of the product. So 25×25 and then we also
   have sizes that affect price and shipping which is another 11 options so times
   11. Turns into just under 7000 variations…
 * Our client has approved some custom development to make the colorizer plugin 
   work with the addons plugin instead of variations so that we only have the 11
   size options that affect the price. That will solve all issues…
 * Thanks for the response.
 *  Plugin Author [Josh Kohlbach](https://wordpress.org/support/users/jkohlbach/)
 * (@jkohlbach)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/load-tested/#post-6617715)
 * No worries at all!
 * Best of luck on the project, sounds like an interesting one!
 * – Josh

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

The topic ‘Load Tested?’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce-wholesale-prices/assets/icon-256x256.jpg?rev
   =2547870)
 * [Wholesale Suite – B2B, Dynamic Pricing & WooCommerce Wholesale Prices](https://wordpress.org/plugins/woocommerce-wholesale-prices/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce-wholesale-prices/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce-wholesale-prices/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce-wholesale-prices/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce-wholesale-prices/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce-wholesale-prices/reviews/)

## Tags

 * [cpu](https://wordpress.org/support/topic-tag/cpu/)
 * [load](https://wordpress.org/support/topic-tag/load/)
 * [variations](https://wordpress.org/support/topic-tag/variations/)
 * [wholesale](https://wordpress.org/support/topic-tag/wholesale/)

 * 3 replies
 * 2 participants
 * Last reply from: [Josh Kohlbach](https://wordpress.org/support/users/jkohlbach/)
 * Last activity: [10 years, 8 months ago](https://wordpress.org/support/topic/load-tested/#post-6617715)
 * Status: resolved