Customer and order exports for any server environment

Today I am excited to share some improvements that have just been released for our CSV Export and XML Export plugins! The big ticket item for these releases is a refactor of the way that exports are stored. You won’t see any visible differences in these latest changes, but if you look under the hood, you’ll see that these plugins just got a major upgrade. 🍻 Disclaimer This post may get a bit technical, so go…

Read More

Get All WooCommerce Orders for a Customer

There are several reasons you might want to get all WooCommerce orders for a customer in your shop. For example, you may want to find out if they’ve ever purchased a product, or do something as simple as count the number of orders they’ve placed with you. Since orders are a custom post type, you can use get_posts to query orders, which is a pretty standard WP query that most developers are familiar with and…

Read More

Get a list of WooCommerce sale products

You can get lists of all simple products, variable products, or featured products easily with WooCommerce. It’s also easy to get things like “in-stock” products or “out of stock” products. However, getting a list of WooCommerce sale products can be a bit tougher because sale products use different meta keys to determine sale status depending on the product type. Let’s take a look at a couple of ways you can get sale products. Check sale…

Read More

Pagely staging site

How to create a Pagely staging site (for the non-developer)

Chances are that you’ve heard of Pagely, as they were the first company to offer managed WordPress hosting. They’re one of two hosts we recommend, and we migrated all of our own sites to Pagely early this year. One feature that many eCommerce sites need as part of their managed hosting services are staging sites, as these help you test updates and debug issues so you don’t have to deactivate plugins or try out new…

Read More

WordPress development tutorials

WordPress Get DB Table Column Names

To get the column names for a MySQL database table in WordPress, use the following: global $wpdb; $table_name = $wpdb->prefix . ‘posts’; foreach ( $wpdb->get_col( “DESC ” . $table_name, 0 ) as $column_name ) { error_log( $column_name ); } Which will result in something like the following being printed to your debug.log: ID post_author post_date post_date_gmt post_content … You get the idea 🙂

Read More

WooCommerce reviews + tutorials

WooCommerce Sample Data

A sometimes overlooked, but useful feature of WooCommerce 1.5.3 is the included dummy data file, which can be imported to create a number of products, and even attaches product images! This is useful when setting up test/development environments and you want a range of products available without having to manually create them. Step 1 – Locate the Dummy Data File The sample data file is included with the woocommerce plugin. To verify you do indeed…

Read More