WooCommerce Optimisations

The indexes and query options in Scalability Pro help every WordPress site, WooCommerce included. On top of those, several options target specific pieces of WooCommerce that get slow on stores with many products, orders or users. Each one is a separate switch, so turn on the ones that match a problem you have.

Checkout

• Checkout purge shield (Miscellaneous tab, on by default). Many cache-purge plugins react to order activity as if an order were a published page, and send purge requests while the customer is waiting for their order to go through. The shield skips purges for order notes and for content with no public URL, so placing an order does not wait on them. It works through filters only and never changes your purge plugin’s settings. See Checkout Purge Shield.
• Purge timeout cap (Miscellaneous tab, off by default). Shortens the timeout on the site’s own purge requests. It is separate from the shield because it also affects legitimate purges.

Store administration

• Optimise WooCommerce Updates (Miscellaneous tab). WooCommerce deletes rows from wp_options in a way that cannot use an index, which can lock the table on a store with many options or transients. This rewrites those deletes so they use the index. See Optimise WooCommerce Updates.
• Remove Woo order summary and Disable WooCommerce Marketplace Suggestion (WP Admin tab) remove two dashboard queries that run on admin page loads. See Remove WooCommerce Dashboard Bloat.
• Fix WooCommerce onboarding code (Miscellaneous tab) caches the “does this store have products?” check behind the onboarding wizard.
• Ajax attribute editing (Miscellaneous tab) loads attribute terms on the product editor when you need them, rather than all at once. See Ajax Attribute Editing.

Catalogue pages

• Cache [sale_products] shortcode, Cache [best_selling_products] shortcode and Cache Flatsome [uxproducts] shortcode (Miscellaneous tab) serve those product grids from cache, per language on WPML sites. See Cache WooCommerce Shortcodes.
• Remove Woo Ajax variations calculations (Miscellaneous tab) skips the variation counting WooCommerce runs on product pages with many variations. See Speeding Up Single Product and Post Pages.

Product updates and imports

• Optimize Product Attributes Lookup and Optimize Action Scheduler (Imports tab) keep WooCommerce’s attribute lookup and background job tables fast during product updates. See Faster Imports.

Further reading

Related products

Scalability ProSpeed up your whole site – big catalogues, big databases, no re-architecture