Knowledge Base

WooCommerce High-Performance Order Storage (HPOS) – What You Need to Know and Why

WooCommerce has historically stored orders data as specially formatted entries in the standard WordPress post system. Although it sounds odd that order data would be stored alongside your blog posts, everything tied to WordPress core on a structural level is considered a post. It’s important to note that the HPOS change is not related to security; rather, it will allow WooCommerce to store order data more efficiently. WooCommerce began the project in 2022, as a way to separate the data in the site database into more streamlined and performant custom database tables. What is HPOS? Basically, HPOS how WooCommerce will now store orders data – in dedicated tables. Orders in their own tables allows your shop to scale more easily, simplifies your orders data storage, and increases relatability. According to WooCommerce, HPOS will greatly improve […]

WooCommerce High-Performance Order Storage (HPOS) – What You Need to Know and Why Read More »

Retrieving a Google Workspace Transfer Token

To transfer the management of your account to a reseller, Google needs a transfer token. The token associates your account with the reseller console. To get the transfer token, you must follow these instructions: 1. Go to Google’s Transfer Token Request Form at admin.google.com/TransferToken 2. Sign in with your domain’s administrator username and password. 3. Enter the Public Identifier provided in the transfer request form: 4. Take note of the subscriptions listed under the Transfer to sprucely.net heading. Ensure that the Google Workspace plan matches what you enter in the Transfer Request Form. 4. Check the box after reviewing the policies and click Generate Transfer Token. 4. The page automatically generates a transfer token (valid for 30 days). Copy this code and submit it in your Transfer Request Form. All done! Return to the Transfer

Retrieving a Google Workspace Transfer Token Read More »

Transferring File Ownership within Google Workspace: A Simple Guide

Before we delve into the specifics of transferring file ownership within your Google Workspace, if you’re still in the process of migrating your files from disparate Gmail accounts to your new Workspace, you might want to check out our previous article: Transferring Google Drive files to A New Google Workspace Account. It’s filled with helpful information to make your migration process smoother. Now, let’s get back to the matter at hand. Transitioning to Google Workspace brings numerous advantages to your business, one of which is the ability to collaborate more efficiently. However, with this transition, there’s an important consideration that is often overlooked: file ownership. It’s crucial to ensure that the right people have control over the right documents within your organization. This guide will walk you through the process of transferring file ownership within

Transferring File Ownership within Google Workspace: A Simple Guide Read More »

Transferring Google Drive files to A New Google Workspace Account

Congratulations! Your small business is growing, and you’re ready to take it to the next level by migrating from individual Gmail accounts to a Google Workspace account. This will undoubtedly streamline your business operations and enhance your team’s collaboration. However, one key challenge you might be facing is how to transfer your team’s Google Drive files from the old Gmail accounts to your new Workspace. As it currently stands, Google Drive does not directly support transferring ownership between different domains (from @gmail.com to @yourcompany.com). This presents a unique problem, especially if your business relies heavily on shared documents, data on Google Sheets, Slides for presentations, or any other Drive-stored files. The need to maintain access to these essential files is paramount as you transition into your Workspace account. Here’s the good news: we have a

Transferring Google Drive files to A New Google Workspace Account Read More »

How to resolve “WooCommerce is updating product data in the background” taking longer than expected

If you’re running WooCommerce 3.6 or later (and I truly hope you are), and have a large product catalog, you might have ran into the issue where this admin notice is lingering longer than you think it should. This can cause issues with filters on the front end of a shop being inaccurate or non-functional, as well as the noted sorting and reporting discrepancies. As the message indicates, for this install, we’ve disabled the default WP cron and run a scheduled server cron via wp-cli. This helps offload these sorts of processor intensive tasks from happening when users load your website, but it can sometimes mean queues such as this one get a little backed up. I’ve often found this issue on sites that use bulk editing plugins to make thousands of product updates at

How to resolve “WooCommerce is updating product data in the background” taking longer than expected Read More »

Why & How to Create a Ranch Website

Originally given as a presentation at the 2023 Texas Bison Association Spring Conference, today’s blog posts covers why your ranch needs a website and the basics of creating a site. While this post specifically refers to ranches, the information below is applicable to many other verticals including farms, producers, creators, and manufacturers! The Importance of Having a Ranch Website Local, Regional, & Global Reach So, why might you want a website at all? Most fundamentally, a website is a channel of communication and it’s unlike any other when it comes to reach.A website has local, regional, even global reach. No matter how narrow or broad your target market is, your website can reach them on any scale. Accessible 24/7 Your website is accessible 24/7. We’re not sure what sort of hours you keep, but I

Why & How to Create a Ranch Website Read More »

Add Judge.me Featured Reviews to Your Klaviyo Email Campaigns

You work hard to cultivate reviews for your products, so get the most out of your five star customer reviews by adding them to your Klaviyo email campaigns. Read on to discover how to add Judge.me reviews to your Klaviyo campaigns today. Why You Should Utilize Customer Reviews Did you know that as much as 92% of customers read online reviews? Product reviews not only build confidence in your brand, they are an essential part of the conversion process. Utilizing customer reviews in your email campaigns can make the difference between a casual reader and a completed sale! How it Works Utilizing a Klaviyo API key, you are able to create a review testimonials feed in Judge.me. This feed URL can then be added to Klaviyo, along with a few blocks of code, to retrieve

Add Judge.me Featured Reviews to Your Klaviyo Email Campaigns Read More »

5 star reviews

Monitoring WordPress Cron via heartbeat checks

Part of my onboarding process and performance optimization for new sites is setting up proper server-level scheduled cron jobs using wp-cli. I use Kinsta hosting for clients and internal sites here at Sprucely Designed and, while they have an excellent hosting stack preconfigured out of the box, they don’t disable the stock WP-Cron or configure a system cron to my liking. So, based on Kinsta’s own knowledgebase recommendations, this is one of the first optimizations I make for new sites. First, I disable the default WP Cron, by adding this line to the site’s wp-config.php. On Kinsta hosting, this won’t completely disable the cron because Kinsta has a default server cron setup within crontab that performs a curl request to wp-cron.php?server_triggered_cronjob every 15 minutes. They do this as a backup to the default WP cron

Monitoring WordPress Cron via heartbeat checks Read More »

NASA Adds Leap Second to Master Clock
Scroll to Top