devinsays

<?php

namespace UniversalYums\Admin\Performance;

class OrdersList {

	/**
	 * The single instance of the class.
	 */
	protected static $instance;

devinsays

<?php
/**
 * High volume modifications to Action Scheduler.
 *
 * Adapted from https://github.com/woocommerce/action-scheduler-high-volume/
 *
 * Increase Action Scheduler batch size, concurrency, timeout period, and claim action query
 * ORDER BY to process large queues of actions more quickly on servers with more server resources.
 *
 * @package UniversalYums\ActionScheduler

devinsays

<?php
namespace DevPress\Frontend;

/**
 * Class Performance
 *
 * @package DevPress\Performance
 */
class Performance {

devinsays

<?php
/**
 * Flag historical renewal orders.
 *
 * wp eval-file flag-renewal-orders.php
 */

global $wpdb;

$last_processed = (int) get_transient( 'uy_last_processed_for_flagging' );

devinsays

$cat_args = array(
    'orderby'    => 'name',
    'order'      => 'asc',
    'hide_empty' => false,
);

$product_categories = get_terms( 'product_cat', $cat_args );

foreach ( $product_categories as $key => $category ) {
    $range = reddit_get_category_price_range( $category->term_id );

devinsays

<?php
/**
 * Updates product prices.
 * More about WP CLI scripts:
 * https://wptheming.com/2021/05/wp-cli-scripts-and-woocommerce/
 *
 * wp eval-file update-product-prices.php
 */

$products = get_posts([

devinsays

<?php
/**
 * Exports product data.
 *
 * More about WP CLI scripts:
 * https://wptheming.com/2021/05/wp-cli-scripts-and-woocommerce/
 *
 * wp eval-file export-product-data.php
 */

devinsays

<?php
/**
 * This script will delete all `on-hold` subscriptions and their orders and users.
 * It will delete all subscriptions based on IP.
 *
 * wp eval-file delete-fraud-activity-by-ip.php 127.0.0.1
 *
 * Dry run:
 * wp eval-file delete-fraud-activity-by-ip 127.0.0.1 dry
 *

devinsays

Here's a couple MySQL challenges. No tricks or gotchas, just straightforward MySQL queries.

We generally use TablePlus when making SQL queries, but you can also use the command line or whatever you're most comfortable with.

Here's an example query to get all orders on WooCommerce site:

SELECT
	*
FROM

devinsays

<?php
/**
 * Some meta data should not be copied to subscriptions or renewal orders.
 */

namespace UniversalYums\Subscriptions;

class PreventMetaCopy {

	/**