WordPress Database Archives - Business Bloomer

WooCommerce: Stripe Payment Form Not Showing?

Close-up of a credit card payment being processed at a POS terminal.

In a recent Business Bloomer Club Slack thread, a member reported that the Stripe payment form was not showing at checkout, regardless of which Stripe plugin they used.

They tested both the “WooCommerce Stripe Gateway” and “Payment Plugins for Stripe WooCommerce,” but neither displayed the form.

Even after disabling all other plugins and switching to the default Twenty Twenty-Five theme, the issue persisted. They also tried both the shortcode (“Classic Checkout”) and the Gutenberg block (“Checkout Block”) — still no luck.

SPOILER ALERT: The problem seemed unrelated to any particular plugin or theme conflict. The member then checked the browser console for JavaScript errors and found a very strange message: a currency-related error where “cloudways” appeared in place of an expected currency code like USD.

This unexpected value turned out to be the root cause. After locating and correcting it, the Stripe payment form displayed correctly. Let’s take a look at what caused this, how to detect similar issues, and what steps you can take to fix them.

WooCommerce Customer Lookup Table and Slow Admin Orders

A person organizing wooden drawers in an archive room with a focus on storage.

In a recent Business Bloomer Club Slack thread, a developer encountered a frustrating issue while editing WooCommerce orders from the WordPress admin.

The website, recently migrated from an outdated version and updated with all the latest plugins, was running fine—until it came to editing orders.

The admin page would hang indefinitely unless the wc_customer_lookup table was cleared. With over 500,000 orders in the system, this prompted a deeper look into WooCommerce lookup tables and how they affect performance.

Staging Large WooCommerce Stores

High-speed close-up of CNC drill bit in action with water splash for lubrication.

Setting up a staging environment is absolutely essential for any serious WooCommerce store. It’s the safe space where developers can test new features, updates, and design changes without risking the live site and its precious customer data.

However, when dealing with WooCommerce stores that have grown significantly, with databases reaching gigabytes in size, the process of creating a staging environment can become a real challenge.

Traditional one-click staging solutions offered by hosting providers might not be equipped to handle such massive amounts of data, and even popular migration plugins can buckle under the strain.

This post explores the strategies and techniques shared by developers who have tackled this very problem, offering practical advice and proven methods for creating a manageable and effective staging environment for large WooCommerce stores.

The discussion highlights the common pitfalls and offers solutions ranging from database optimization and cloud storage integration to leveraging command-line tools for efficient data transfer.

The goal is to provide a comprehensive guide for anyone wrestling with the complexities of staging a large WooCommerce site, enabling them to create a safe and reliable testing ground for continued growth and development.

Optimizing a 25GB Order Item Meta Table in WooCommerce

Construction site with a 'Slow Down' sign amid scaffolding in Kuwait.

In a recent Business Bloomer Club Slack thread, a member asked for suggestions on optimizing a 25GB order_itemmeta table in WooCommerce.

This large table was causing slow order creation and search issues, and the user was exploring options, including switching to HPOS (High-Performance Order Storage). Here are some insights from the discussion.

WooCommerce: Bulk Delete Pending / Failed Scheduled Actions

In a recent project, I needed a quick way to bulk delete pending and failed Action Scheduler jobs directly from the WordPress dashboard—so I built a custom tool for it.

The WooCommerce > Status > Tools section is packed with useful features for debugging and maintenance, but did you know you can add your own custom tools there?

This is especially useful when your site has thousands of queued actions that are no longer needed, or if a plugin malfunction leaves behind a large number of stuck jobs. Instead of running manual SQL queries or using WP CLI, this approach gives you a simple one-click button inside your WooCommerce admin.

In this tutorial, I’ll show you how to register your own custom tool using WooCommerce’s built-in API, and how to trigger and delete all pending or failed actions.

Here’s the full snippet to get you started!

WooCommerce: The Need For Custom Order Tables

Scaling WooCommerce stores while ensuring optimum performance and pushing a store live from staging while keeping all the orders and customers intact are significant problems stores face, even today.

Each time a consumer places an order on a WooCommerce store, it adds dozens of order data and entries to the WordPress postmeta database table – which creates a major problem for stores that handle huge volumes of orders and eventually results in performance degradation.

Hence, WooCommerce received several requests over the years to resolve this issue and make separate and custom tables for each WooCommerce entity – without affecting the site and existing extensions.

And finally, WooCommerce is now working on the custom order tables implementation to solve the bottleneck issues and ensure more store stability.

In this article, we introduce you to the WooCommerce custom order tables – what is it, the new tables added to the structure, and how they can benefit your WooCommerce store. Let’s begin!

WooCommerce: 10 Crucial Issues That Should Be Fixed Right Now

I just spent the last 3 days in Porto with another 2,300 WordPressers at the first in-person WordCamp Europe since Berlin 2019. I had a blast, held a nice (yet long) workshop, spoke to many, but got tired too soon.

Later on, I realized that that tiredness was something more serious – in fact I tested positive against COVID for the first time in my life, and I’m now in self-isolation hoping it won’t last long… Another 7 days without my kid – send help!

Anyhow, what really struck me at WCEU 2022, and based on various chats and some data that I’ll share below, is that the WooCommerce ecosystem is in trouble.

A nicer way to put that? WooCommerce is not moving forward as fast as it should, and unless some key issues are addressed right now, in a few years time we all may pay the consequences.

Please note, this is not a rant. It’s a proper analysis, full of actionable information.

@ WooCommerce team - if you're reading this - my plan is to give you constructive feedback and tell you what the community (really) thinks, needs and wants, so that you can get a better picture of the current situation. I know you've already started working on this, so this is just a recap/reminder and a way to get the whole community realigned.

In this post, I will share my worries, my fears, the current WooCommerce issues, some data I collected at WCEU 2022 and then a list of actionable solutions that may be implemented in order to clear the backlog and get back on track – asap. Enjoy!

WooCommerce: Search Orders By SKU @ Admin

Exactly. By default, when you search for orders in the WordPress > WooCommerce > Orders backend, using a SKU will give you 0 results. Which is pretty poor for a store manager.

Let’s change this. Despite the code is a little complex, all you need is a simple copy & paste. Enjoy!

WooCommerce: Bulk Delete Orders / Products Super Fast

There are times when you have thousands of WooCommerce orders, products, categories, tags, coupons, customers or custom fields and the “Bulk Edit > Delete” option in the WordPress dashboard is simply not cost- and time-effective.

Maybe because your website goes down as it can’t process that much information at the same time, or maybe because you’re on a low budget and can’t afford to hit “delete” 100 or 1000 times by hand.

Thankfully, WooCommerce information is stored in the WordPress database, which means we can access it, write a “SQL DELETE statement”, and bulk delete anything you like, in seconds. Of course, and you will find warnings below, NEVER DO THIS on a live website as I can’t guarantee this won’t have any side effects.

So, have fun!

WooCommerce Database Explained: How It Works and Where To Find Data

The term “database” is widely used and known to millions of people, but the proportion of people who have it in their vocabulary without understanding what it describes is sizable.

Databases are at the core of so many digital services today that it is easy to overlook them entirely, but whether you run a shopping site or a business server, building an understanding of them is worthwhile regardless of whether or not you are directly responsible for administration duties.

Having a grasp of the underpinnings of what a database is and how it works is sensible, especially if you run a WooCommerce site and you want to make optimal use of all that this platform has to offer.

To that end, here is an overview of the database fundamentals to bring you up to speed.

Tag: WordPress Database