Product Sales Report for WooCommerce

Description

Setup a custom sales report for the products in your WooCommerce store with toggle sorting options. Including or excluding items based on date range, sale status, product category and id, define display order, choose what fields to include, and generate your report with a click.

Quickly create sale reports for smart decision making, monitoring sales, setting sales strategies, forecasting, inventory management, and accounting.

Reporting Features & Benefits

  • One-click generate and share – view or download your reports with a click
  • Sort by date range – built-in presets or custom start and end dates
  • Order status sorting – include or exclude based transaction status
  • Product-specific reporting – store-wide reports, by product, or a group of products
  • Group variations – show all variations for a product as a single line item
  • Set display order – based on product id, quantity of sales, or gross sales
  • Reporting fields – choose what fields to include in your report
  • Exclude free products – leave free products out of your report
  • Limit included products – set report to only include a set number of products
  • CSV exporter – export in versatile CSV format for universal spreadsheet compatibility

Get Pro Features

If you are a power user needing advanced options for fine-tuning, styling, and sharing reports, upgrade to pro:

  • Create report presets – save custom report settings, regenerate reports, and move preset to other sites
  • Email reports – send reports to any email address with a click
  • More formats – Save reports in XLSX, XLS, HTML, or Enhanced HTML
  • Sort by field – use conditional range selectors to include/exclude products with specific fields
  • User role sorting – generate reports by user roles (default and custom roles).
  • Expanded product sorting – adds tag, field, and product variation sorting
  • Group products – additional layer clustering products
  • Field ordering – add, remove, and drag and drop ordering
  • Advanced styling – dynamic titles, include a header row, and style with custom CSS
  • Want more? – check out our add-ons for expansion plugins

View, Download, and Share

Use the report builder to quickly create a custom report, view in your dashboard, or click “Download Report” and your custom report will be generated and downloaded as a CSV. Import to your favorite spreadsheet software or share it with members of your team.

⭐️⭐️⭐️⭐️⭐️

“I needed reports to help make informed decisions for ordering new stock from suppliers and the Product Sales Report for WooCommerce was perfect. It can create very granular reports for specific product categories or one grand report for all our products. Well done!” - @krooisant

⭐️⭐️⭐️⭐️⭐️

“I was looking for good frontend reports for my marketplace and I came across the winning trio, Products Sales Report Pro, Export Items Pro in combination with Frontend Reports. This trio was the best for the job.” - Yinon Tubi

Simple Sorting

Product Sales Reports gives you a ton of control for zeroing in on what’s important. See what products are performing best based on quantity or gross sales so you can refine your online sales strategy. Sort by date range, order status, item, category, and field.

Reporting Fields Include:

  • Product ID
  • Product SKU
  • Product Name
  • Quantity Sold
  • Gross Sales
  • Variation ID
  • Product Categories
  • Variation Attributes
  • Gross Sales (After Discounts)

If you like this plugin, please consider leaving a comment or review.

Work Faster With Presets (Pro)

Set up your reports and save them as templates you can use again and again. Product Sales Report Pro lets you store an unlimited number of presets that can be used for comparative growth analysis. Or export your presets and use them across all the WooCommerce stores you manage.

Addons & Integrations

Looking to automate your reports, share them on the frontend of your site, or export details about an individual sale for order fulfillment? Upgrade or become a member for access to these add-ons:

Scheduled Email Reports – email your reports as an attachment on a recurring schedule
Frontend Reports – embed a report or a download link in a post or a page
Export Order Items Pro – export order details for use in order fulfillment and data analysis

You may also like these plugins

WP Zone has built a bunch of plugins, add-ons, and themes. Check out other favorites here on the repository and don’t forget to leave a 5-star review to help others in the community decide.

  • Export Order Items for WooCommerce – export the order details for each sale in your WooCommerce store. Simplify order fulfillment, generate accounting reports in a few clicks, and download into CSV format for readability and universal compatibility with Export Order Items.
  • Replace Image – keep the same URL when uploading to the WordPress media library
  • Force Update Check for Plugins and Themes -force Update Check for Plugins and Themes forces WordPress to run a theme and plugin update check whenever you visit the WordPress updates page
  • Connect SendGrid for Emails – connect SendGrid for Emails is a third-party fork of (and a drop-in replacement for) the official SendGrid plugin
  • Custom CSS and JavaScript – allows you to add custom site-wide CSS styles and JavaScript code to your WordPress site. Useful for overriding your theme’s styles and adding client-side functionality.
  • Disable User Registration Notification Emails – when this plugin is activated, it disables the notification sent to the admin email when a new user account is registered.
  • Inline Image Upload for BBPress – enables the TinyMCE WYSIWYG editor for BBPress forum topics and replies and adds a button to the editor’s “Insert/edit image” dialog that allows forum users to upload images from their computer and insert them inline into their posts.
  • Password Strength for WooCommerce – disables password strength enforcement in WooCommerce.
  • Potent Donations for WooCommerce – acceptance donations through your WooCommerce store
  • Shortcodes for Divi – allows to use Divi Library layouts as shortcodes everywhere where text comes.
  • Stock Export and Import for WooCommerce – generates reports on the stock status (in stock / out of stock) and quantity of individual WooCommerce products.
  • Random Quiz Generator for LifterLMS – pull a random set of questions from your quiz so users never get the same question twice when retaking or setting up a practice quiz.
  • WP and Divi Icons – adds over 660 custom outline SVG icons to your website. SVG icons are vector icons, so they are sharp and look good on any screen at any size.
  • WP Layouts – the best way to organize, import, and export your layouts, especially if you have multiple websites.
  • WP Squish – reduce the amount of storage space consumed by your WordPress installation through the application of user-definable JPEG compression levels and image resolution limits to uploaded images.

To view WP Zone’s premium WordPress plugins and themes, visit our WordPress products catalog page.

Enjoy!

Screenshots

  • Report options
  • Sample output (simulated)

Installation

  1. Click “Plugins” > “Add New” in the WordPress admin menu.
  2. Search for “Product Sales Report”.
  3. Click “Install Now”.
  4. Click “Activate Plugin”.

Alternatively, you can manually upload the plugin to your wp-content/plugins directory.

FAQ

Why I see additional decimal places in some fields?

In some cases output may be affected by the limited precision of PHP’s floating point numbers (see the warning in the PHP manual: https://www.php.net/manual/en/language.types.float.php). This may occur retrieving values from the database, when the plugin does calculations after retrieving values from the database, such as when a report field consists of two database fields added together, or when calculating the totals row. When this occurs, a tiny fractional error may be introduced each time a calculation is performed, typically less than 0.000000000000001 per calculation or retrieval. This is not likely to affect the accuracy of the output in normal usage where only a few decimal places are used, even if a value has been derived from many calculations such as the totals row in a very long report. However, if output rounding is not in effect, you may see unexpected additional decimal places in some fields in your output. In this case we recommend rounding the output values as needed.

What’s the difference between Product Sales Report and Export Order Items?

Product Sales Report is for creating a report about all your products or a group of products for comparison and sales performance. Export Order Items generates a report with the items from an individual order, specific purchase, or specific customer for order fulfillment or accounting.

What’s the difference between the free and pro version?

The free version is powerful and works well for 90% of store owners. If you need additional control the pro version includes the ability to report on product variations individually, report on products with no sales, report on shipping methods used, export in Excel formats, send the report as an attachment, save an unlimited number of presets, change the names of fields in the report, change the order of the fields/columns, limit the report to orders with a matching custom meta field (e.g. delivery date), and 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).
Or, you can upgrade to a membership to access all of our premium plugins and add-ons including Scheduled Email Reports for automating report generation.

Can I schedule my reports to send automatically?

We built Scheduled Email Reports for WooCommerce as a premium add-on that can be used to schedule reports from both Product Sales Report to and Export Order Items.

Where can I get your other add-ons for WooCommerce?

After you install and activate the Product Sales Report for WooCommerce, from the Product Sales Report tab located in the WooCommerce menu, select add-ons to install free and premium feature upgrades for your ecommerce store.

Reviews

Ogwekkuminebiri (Ntenvu) 28, 2023 1 reply
It seems to treat all currencies the same. So it does not convert them all into the same currency, so the numbers are rubbish. Sell a $100 item for 14,000 japanese yen, and it will report sales of $14,000!
Ogwekkuminogumu (Museenene) 16, 2020
Very light and useful. A graphic interface could be better but it works what it’s made for. Kudos.
Ogwomunaana (Muwakanya) 13, 2020
Easy to use and saves time. The big orange banner of “Potent Plugins” displayed under the report is annoying 😉 Other than this, all good. :thumbs_up:
Kasambula 16, 2020 1 reply
Good day. I recommend this plugin to all of those who are looking to generate each product sales on a single click. from the morning I was doing collection manually. later I came across this plugin. In short, I love it.. Thanks a lot to all developers of this plugin. Good DAY. God Bless you all.
Read all 55 reviews

Contributors & Developers

“Product Sales Report for WooCommerce” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

1.5.6

  • Revert: “Limit Gross Sales and Gross Sales (After Discounts) fields to 10 decimal places (amounts are rounded if more than 10 decimal places)”

1.5.5

April 26, 2023
* Add High Performance Order Tables support (beta)

1.5.4

April 17, 2023
* Security update
* Limit Gross Sales and Gross Sales (After Discounts) fields to 10 decimal places (amounts are rounded if more than 10 decimal places)

1.5.3

March 12, 2023
* Fix: The option to use the report preset’s date range settings wasn’t working in Scheduled Email Reports

1.5.2

September 23, 2022
* Display reporting presets list in alphabetical order

1.5.1

  • Fix: Removed incorrect/outdated note regarding line item refund creation when the order status is changed to Refunded (WooCommerce 2.4+ should automatically create line-item refunds when the status of an order is set to Refunded)
  • Feature: Added intermediate rounding option
  • Feature: Added debug mode option

1.5.0

  • Security fix: Improve browser caching disabling headers
  • Load styles and js only on the plugin admin page
  • Updated WP and WooCommerce tested up to
  • Rebranded admin page
  • Added a link to plugin settings page
  • Updated links
  • Added addons tab
  • Updated readme and assets

1.4.10

  • Added messaging on admin page about line item refunds

1.4.9

  • Updated license (GPLv3+)
  • Removed social media embeds from admin page

1.4.8

  • Fixed review/donate notification not being hidden

1.4.7

  • Fixed incorrect date ranges when using the “Last 7 days”, “Last 30 days”, “Next 7 days”, or “Next 30 days” options
  • Added calendar month date range options
  • Fixed conflict with Product Sales Report Pro

1.4.6

  • Fixed potential incompatibility with order status plugin(s)

1.4.5

  • Fixed potential incompatibility with custom order statuses

1.4

  • Added the ability to select multiple product categories
  • Added an option to limit the report to specified product IDs
  • Added an option to limit the report to orders with specified statuses

1.3.2

  • Added an option to exclude free products

1.3

  • Added a View Report option

1.2.4

  • Added a date picker for browsers without support for the HTML5 date input

1.2.2

  • Removed anonymous function to improve compatibility with old versions of PHP

1.2.1

  • Fixed bug affecting products with no categories

1.2

  • Added Product Categories field

1.1.7

  • Added Variation SKU field

1.1.6

  • Added Gross Sales (After Discounts) as sort field

1.1.5

  • Added field for gross sales after discounts

1.1.4

  • Added Pro version info

1.1.2

  • Made report settings persistent (options are saved when a report is generated)

1.1.1

  • Fixed timezone issue affecting the report period

1.1

  • Added checkboxes to select which fields to include in the report
  • Added the Product SKU field

1.0

  • Initial release