Sales Archives - Business Bloomer

WooCommerce: Custom Product Sales CSV Report

office work, work, office, folder, files, file folder, balance sheet, accounting, invoice, management, organization, folder, files, files, files, files, files, accounting, accounting, accounting, invoice

In a recent Business Bloomer Club Slack thread, a community member shared a custom solution to generate a product sales report in WooCommerce. This solution allows administrators to export the total quantity of each product sold over a specified period.

The export is in CSV format, which is easily accessible for analysis or record-keeping. This functionality is particularly valuable for store owners who need detailed insights into their product sales performance. By leveraging this custom solution, you can streamline your reporting process and stay on top of product performance.

This post includes a legacy version and also an updated snippet for WooCommerce with High-Performance Order Storage (HPOS) compatibility, which improves the handling of orders and metadata. Keep reading to explore the full solution and how it works in both the standard and HPOS versions.

WooCommerce: “Last Chance” Category with Expiring Sale Products

When managing a WooCommerce store, your sales strategy can be a powerful way to engage customers and drive urgency.

One cool trick is featuring products with sale prices about to expire (“sale price end date“) in a custom product category. We’ve already seen how to populate a “Sale” category, but this time I’d like to get only the sale products with a sale end date!

Highlighting expiring sale items allows store owners to showcase time-sensitive deals, enticing shoppers to act fast before discounts disappear. This approach not only enhances the shopping experience but can also boost conversions during critical sales periods.

In this tutorial, we’ll explore how to dynamically populate a custom WooCommerce category with products whose sale end dates are approaching. Using a PHP code snippet, you’ll learn how to identify expiring sale items and assign them to a dedicated category automatically.

Whether you’re a store owner looking to create a “Last Chance” section or a developer helping clients achieve similar functionality, this guide will walk you through the steps. Let’s dive in!

WooCommerce: Decrease Product ‘Total Sales’ Upon Refund

Every time an order is placed on your WooCommerce website, the purchased products’ total_sales counter increases thanks to a core function. It’s then easy to retrieve the value and maybe show the number of sales on the single product page, which is great for social proof and sales conversion rate optimization.

The big problem – and don’t ask me why this is not into core – is that if you need to refund an order (or cancel it), the total_sales counter will not reset / decrease, which is odd.

Today we’ll fix this, so that your products are always up to date with their sales counter and you can be more confident in showing the correct values. Enjoy!

WooCommerce: Get “Trending” Products

There is a way to display the WooCommerce bestsellers via shortcode / block, but there is no way to calculate the bestsellers – say – from the last 7 days i.e. a list of “trending” products over the last N days.

The function below gives you a way to loop through the latest orders and fill an array with the top 10 products – you can then pass this list of IDs to a shortcode to display them wherever you wish. Enjoy!

WooCommerce: Count Variation Sales (Shortcode)

We’ve already studied how to display the number of sales for a given product ID via a shortcode – however that solution won’t work for a variation ID, because WooCommerce only counts the “parent product” sales.

We need a different workaround in this case. This will require we either query the orders that contain such variation ID, and then calculate the sum – or that we install a snippet on day 0 so that we can count variation sales from that moment onwards, without having to query and calculate anything.

We will study the latter, and then display the result via a shortcode, so that you can use it anywhere, even inside the variation description.

Enjoy!

WooCommerce: Limit Sales Of A Product Per Day

Yes, “manage stock” is a nice feature to make sure you don’t oversell a given product based on the stock you have in your warehouse. However, what if you also need to have a “daily sales limit” – say you can’t sell more than 3 of a given product ID in a given day?

This is an interesting functionality that is also helpful for you to learn how to get today’s orders, how to loop through the orders to find a specific product ID and sum its quantities, and finally how to use the woocommerce_is_purchasable filter to set if a product can be purchased or not (which means, the add to cart may or may not show). Enjoy!

WooCommerce: Calculate Sales by State

You’re filing your tax returns and need to know how much you earned in each state… but then find out WooCommerce doesn’t give you this calculation by default within its reports!

Don’t worry – today I’ll share a quick snippet so that you can calculate the amount you need in a second. Feel free to change the year, the country and the states in the snippet.

Tag: Sales