Get fresh WordPress Content delivered in your inbox with warpspeed!

learn wordpress wplift wordpress rocket

Today we are looking at two plugins designed for WooCommerce shop owners: Product Sales Report and Export Order Items, these are both plugins designed to compliment and extend WooCommerce’s reporting capabilities and let you download the results in CSV, HTML and Excel formats. The plugins are built by Potent Plugins, a Canadian company who specialize in creating many different free and premium WordPress plugins.

Product Sales Report Pro allows you to export product sales figures (quantities, gross sales amounts, etc.) for each product in aggregate.

9

Export Order Items Pro exports each product-based order line item individually (and thus has the ability to include additional data specific to individual orders and customers).

10

Both plugins come with a number of pre-defined report fields and also include the ability to add custom fields by selecting from meta fields defined in the user’s WordPress/WooCommerce installation. Output formats are CSV, XLS, XLSX, and HTML, and report settings can be saved as presets for easy recall. Product Sales Report Pro additional includes the ability to directly email the report as an attachment, eliminating the need to download the file and attach to an email manually.

Both plugins offer a free version so you can test them out, and also offer pro versions which include extra functions, take a look at the features list below for comparison.

If you wish to upgrade to the pro versions of the plugins, you can use coupon code WPLIFT15 which will give you 15% off the purchase price.

Product Sales Report » Export Order Items »

Product Sales Report Features

Features (available in the free version):

  • Use a date range preset, or specify custom start and end dates.
  • Report on all products in your store, or limit the report to only include products within certain categories or only specific product IDs.
  • Limit the report to orders with certain statuses (e.g. Processing, Complete, or Refunded).
  • Customize the report sorting order (sort by Product ID, Quantity Sold, or Gross Sales).

Additional features in the Pro version only:

  • Report on product variations individually.
  • Optionally include products with no sales (note: does not report on individual product variations with no sales).
  • Report on shipping methods used (Product ID, Product Name, Quantity Sold, and Gross Sales fields only).
  • New! Limit the report to orders with a matching custom meta field (e.g. delivery date).
  • Change the names of fields in the report.
  • Change the order of the fields/columns in the report.
  • Include any custom field defined by WooCommerce or another plugin and associated with a product (note: custom fields associated with individual product variations are not supported at this time).
  • Save multiple report presets to save time when generating different reports.
  • Export in Excel (XLSX or XLS) format.
  • Send the report as an email attachment.

Export Order Items Features

Features (available in the free version):

  • Use a date range preset, or specify custom start and end dates.
  • Select from a variety of pre-defined data fields that can be included in the report.
  • Filter line items by order status (Pending Payment, Processing, Completed, Cancelled, etc.).

Additional features in the Pro version only:

  • Create multiple export presets to save time.
  • Include product variation details.
  • Include any custom field associated with an order, product order line item, product, or product variation.
  • Limit the export to only include certain product IDs or product categories.
  • Change the names and order of fields in the report.
  • Export in XLS, XLSX, or HTML format (in addition to CSV).

How to Product Sales Report Pro

Once you upload the plugin, you will need to enter your license code obtained when purchasing to activate them.

1

After which you will be taken to the plugin’s settings page where you can set the options for generating your report. You can choose a report period :

  • Today
  • Yesterday
  • Last 30 Days
  • All Time
  • Custom Date Range

You can also choose a category from the drop down, or choose all categories. Choose to group variations of a product together in one report or have them separate ( good for finding the most popular variations) and you can also choose to sort the results by Quantity sold, Gross Sales or Gross sales after discount.

2

Once that’s done, you can choose which fields you would like included in the report:

3

Finally, you can pick some options to include products with no sales, include shipping and choose a format for the report ( CSV, XLSX, XLS, HTML ) and if you wish you can enter a name for this report in the “Create New Preset” box which will allow you to save this report to run again in future. Once you are happy with all the chosen options, click the “Download Report” button or enter an email and have it emailed to you.

4

Here you can see a report that I ran on one of my eCommerce sites showing sales reports ordered by gross sales and including the current product price. This was from a .CSV file that I opened up in Excel – the blank lines are from products that have been deleted but their sales figures remain.

5

How to use Export Order Items Pro

Export Order Items is creating reports of which items were ordered, who ordered them and lets you include details like the buyers name and email etc. To get started with it, activate the plugin and enter your license code as before and you can then set your report options. The plugin lets you pick a period of time, an order status ie all completed orders or all cancelled orders, choose which products to include in the report – all products, by category or individual product IDs.

7

Then you can choose which fields should be included in your report, such as Product ID, customer name, customer email and so on.

8

Choose your export options and then you can download the report as before in CSV, XLSX, XLS, HTML format.

6

Pricing

As mentioned, there are free versions of these plugins for you to test them out and if you want to upgrade to the pro versions they cost $29.99 each which is valid for one WordPress installation and good for one year of support and updates – you can continue using the plugins after the year period but wont receive further updates.

The plugins are also available together as a bundle for $42.99 and WPLift readers can get a further 15% off using the code WPLIFT15.

Conclusion

These are both very handy plugins for eCommerce site owners which extend the reporting functionality of your site further than what WooCommerce provides out of the box. Both functioned very well and generated solid reports which can be used to identify your best customers, best selling products, top grossing items and so on which in turn should help you improve your business.

With the offer of free versions of each and 14 day money back guarantee on the pro versions you can easily test them out and make the decision to purchase them or not.

Check out these plugins if you require more advanced reports for your eCommerce site.

Product Sales Report » Export Order Items »

Published:

Last updated on:

Oliver Dale is the founder of Kooc Media, An Internet Company based in Manchester, UK. I founded WPLift and ThemeFurnace, find out more on my Personal Blog. Thanks!

One thought on “How To: Extend WooCommerce Reporting with Product Sales and Item Order Report Plugins

Comments are closed.

Join 40,000 WordPress Astronauts
AND GET OUR LATEST CONTENT IN YOUR INBOX WITH WARPSPEED

We will never spam you.
close-link
siteground coupon
Get 60% Off the No. 1 WordPress Hosting!