CubeCart 6.7.0 added a full sales reporting suite. Before it, answering “what is actually selling” meant exporting orders and building a spreadsheet. Now there are seven reports built in, all exporting to .xlsx.
Sales Stats is the headline, with drill down so you can move from a period total into the orders behind it rather than staring at a number you cannot interrogate.
Best Selling Products does what it says. From 6.7.4 you can select the period by month, which makes seasonal comparison practical.
Search Terms is the one most people underuse. It records what shoppers typed into your search box. Two things come out of it: products you do not stock but people keep asking for, and products you do stock under a name nobody searches for. Both are directly actionable and neither is visible anywhere else.
Conversion shows the ratio of visitors to orders. From 6.7.4, bot and crawler traffic is separated out from genuine visitors, so this number became both lower-traffic and more honest overnight. If your conversion rate appeared to jump after upgrading, that is why.
Abandoned Carts quantifies what you are losing at checkout, and pairs with the abandoned cart recovery emails added in 6.6.0.
Sales by Country matters if you ship internationally, both for spotting markets worth targeting and for sanity checking your tax and shipping setup against where orders actually come from.
Users Online shows current activity. A bug where filtering by “Display Customers Only” produced a white screen was fixed in 6.7.6.
Every report exports to .xlsx through a new classes/xlsxwriter.class.php. This is native Excel output rather than a CSV with a misleading extension, which matters if you are handing files to an accountant.
You can show and hide columns before exporting, and the selection carries through to the file. So if your bookkeeper wants four columns and you want twelve, you are not post-processing the same export twice.
Added in 6.7.4 and easy to miss, this is the change that makes CubeCart’s reports usable for actual accounts. You can report by accounting reference date as well as order date.
The distinction matters at period boundaries. An order placed on 31 March and dispatched on 2 April sits in different periods depending on which date you count, and if your reports only ever offered order date, reconciling to your accounts meant manual adjustment every quarter. Being able to run the same report on either basis removes that.
Ordering was unstable on paginated reports until 6.7.6. If you ran a multi-page report on an earlier version, rows could appear on two pages or on none, because the sort had no stable tiebreaker. If you exported paginated statistics from 6.7.0 to 6.7.5 and the totals looked slightly off, this is a plausible cause. Re-run anything you relied on.
Chart sizing was fixed in 6.7.4, and the product stats date range picker in 6.6.3.
The dashboard gained “vs same period last month” comparisons in 6.7.6, which is the context a bare number never gives you.
Bestseller queries were optimised with composite indexes in 6.6.3. If you have a large catalogue and the old bestseller report was slow enough that you stopped running it, try it again.
Run Search Terms first and read it properly. It is the cheapest source of merchandising decisions you have, and unlike most analytics it tells you about demand you are not currently meeting rather than describing traffic you already got.
Then run Sales by Country and check it against where you actually intend to sell, and against your shipping and tax configuration. Mismatches here are common and quietly expensive.
Then set up the accounting reference date basis if you use one, before your next period end rather than during it.
If you host your CubeCart store with us and want a hand getting the reports lined up with how your accounts are actually kept, get in touch.