Flavors Commerce Intelligence – Profit & Inventory Reports for WooCommerce

Description

See which products earn gross profit, which stock needs attention and which catalog issues need fixing. Flavors Commerce Intelligence brings WooCommerce profit reports, cost of goods, inventory checks and customer and refund reports into your WordPress dashboard.

Enter product costs manually, import a CSV or copy costs from supported cost plugins. Historical costs are stored on order lines so later cost changes do not rewrite recorded profit. Gross profit means product net revenue minus cost of goods; it does not deduct advertising, payment processing, shipping or operating expenses.

All reports are calculated inside your own WordPress site. No external account, subscription or service connection is required. Optional checkout-funnel tracking is off by default.

Overview

• Gross sales (order totals), net revenue (product line totals after discounts, excluding tax and shipping, minus product refunds), orders, average order value, units sold, customers, refunds and discounts for any date range.
• Date presets (last 7, 30 or 90 days, this month, last month) and a comparison with the previous period of the same length.
• A daily net revenue chart drawn inside the page (no external library), with the numbers available as a table.
• Average order value leaves out fully refunded orders. Only orders in the store currency are added up; orders in other currencies are counted and shown as excluded.
• A store health score combining catalog, inventory and feed-readiness scores, with the formula shown on screen. A part that cannot be measured yet (no full catalog scan, no stock-managed products) shows “Not yet measured” instead of a score.
• A setup checklist on the Overview tab (add costs, run a catalog scan, review inventory thresholds, and the optional tracking and privacy steps) with live progress. Each user can dismiss it.

Dashboard widget

• A “Commerce Intelligence” widget on the WordPress Dashboard for users who can view reports: net revenue, orders and average order value for yesterday and the last 7 days, gross profit, margin and cost coverage (only for users allowed to see profit), the store health score and open catalog issues by severity. Figures are cached for 15 minutes. The widget can be hidden per user through Screen Options, or turned off for everyone in Settings.

Catalog

• Checks every published product for an empty title, missing featured image, missing description, missing SKU and a missing or zero price. For variable products the variations are checked too (SKU, price and image), and a parent is not flagged when its variations are complete.
• Products are re-checked automatically whenever they are saved; issues are resolved automatically when a product is fixed, unpublished, trashed or deleted.
• A full scan runs in the background in batches of 100 products (Action Scheduler, with a WP-Cron fallback) and shows its progress and last run time.
• Catalog score normalized by product count and issue severity.

Inventory

• Stock-managed products, out-of-stock, low-stock (per-product or store threshold) and dead-stock counts and tables.
• Stock value at cost.

Profit

• Adds a “Cost price (Commerce Intelligence)” field to simple products and to every variation. Each change is kept in a cost history.
• Bulk cost entry: a Cost column plus Quick Edit and Bulk Edit (“change to”) on the Products list; a CSV import (by SKU or product ID, optional effective date) with a preview of matched, unmatched and invalid rows before anything changes, applied in background batches for large files; a CSV template and a “Download current costs” export for round trips.
• The CSV import reads costs written with either decimal separator (“1,234.56” or “1.234,56”). Choose Auto, Dot or Comma; the preview shows each cost as written next to the value that will be saved.
• The list of products missing a cost is paginated and lets you type costs directly into it.
• One-click import of costs already stored by WooCommerce’s Cost of Goods Sold feature, Cost of Goods for WooCommerce (SkyVerge or WPFactory) or ATUM Inventory Management, with counts shown before running. Existing costs are kept unless you choose to overwrite them.
• WooCommerce Cost of Goods Sold interop: when that WooCommerce feature is enabled, its Cost field is the cost source, the duplicate field is not shown, and orders use the cost WooCommerce recorded on each line.
• Bundles and composite products (WooCommerce Product Bundles, Composite Products, WPC Product Bundles) are costed once: the items inside carry the cost when they all have one, otherwise the bundle’s own cost is used.
• When an order is paid or completed, each line’s unit cost is frozen onto the order, so later cost changes never rewrite past profit.
• Net revenue (discounted product-line totals minus product refunds, including lump sums but excluding refunded tax, shipping and fees), cost of goods, gross profit, gross margin and cost coverage for any date range, compared with the previous period, plus a list of products still missing a cost.
• Gross profit and margin by product (top and bottom 20, sortable) and by category, using the costs frozen on each order line.
• A Profit column on the WooCommerce Orders list and a Profit box on the order screen (both HPOS and legacy order storage), shown only to users allowed to see profit. The box explains when a product’s cost has changed since the order.

Customers

• Customers, repeat customers and repeat rate for any date range, and the top customers by net spend.

Checkout funnel (optional, off by default)

• Cart, checkout and purchase sessions and checkout conversion (capped at 100% by definition), next to the number of orders in the period.

Returns

• Refunded amount, refund rate, orders with refunds, units refunded and the most refunded products, with each rate’s definition shown on screen.

Feeds

• Local feed-readiness check (title, image, price, stock). The plugin does not generate or submit feeds.

CSV export

• Every report tab (Overview, Catalog, Inventory, Profit and missing costs, Customers, Checkout, Returns, Feeds) has an “Export CSV” button that honours the current filters. Exports are streamed, never stored on the server, require the same permission as the tab, and neutralise spreadsheet formulas.

REST API

• Read-only report endpoints (including profit by product and by category) and a cost endpoint under ciowc/v1, protected by the plugin’s own capabilities (ciowc_view, ciowc_manage, ciowc_view_profit, ciowc_view_customers, ciowc_view_tracking), granted to Administrators and Shop Managers. Checkout-funnel data needs ciowc_view_tracking, like tracking health.

Performance

• Sales reports are added up in SQL from WooCommerce’s own Analytics tables when they exist and hold the same orders as WooCommerce. Otherwise the plugin reads orders in pages, capped at 20,000 orders per report, and the screen says when a report was capped.
• Inventory and feed checks read WooCommerce’s product lookup table instead of loading every product.
• Reports are cached per kind of data: a sale refreshes sales and stock reports without discarding catalog and cost reports.

Optional paid Pro add-on — distributed separately

Every feature described above is included in this free plugin. Flavors Commerce Intelligence Pro is a separate paid add-on for stores that need deeper analysis and operational workflows:

• Contribution profit after payment, shipping, advertising and other selling costs, plus profit and loss with operating expenses.
• Inventory forecasts, reorder recommendations, suppliers, purchase orders and receiving with landed costs.
• Customer segments, cohorts and lifetime value, plus consent-aware abandoned-cart recovery emails.
• Marketing attribution and configured ad-platform integrations, plus payment reconciliation for supported providers.
• Custom dashboards, scheduled reports, recommendations and automation with explicit approval for supported actions.
• Scoped MCP access for AI assistants and an optional AI advisor using your own provider credentials.

Pro requires this free plugin. WooCommerce Subscriptions analytics requires the separate WooCommerce Subscriptions extension. External integrations require merchant credentials and provider access; available functions depend on the provider. Pro is not included in the WordPress.org download. This free plugin remains complete on its own, with no locked features or trial limits, and its only in-plugin Pro information appears on its own “Pro add-on” tab.

Privacy

This plugin does not send any data to external services and includes no telemetry.

Checkout-funnel tracking is disabled by default. When a store administrator enables it:

• The tracker runs only on the cart, checkout and order-received pages.
• By default it requires statistics consent through a configured consent manager using the WP Consent API. Until consent is given, nothing runs and nothing is written to the visitor’s browser storage. Installing the API alone does not count as consent; if consent is required and no compatible consent manager has configured it, no visitor is tracked. An explicit statistics denial is respected even if the optional consent requirement is turned off.
• A random identifier is stored in the visitor’s browser (localStorage key ciowc_sid). Only an HMAC-hashed version of it is stored in the site database, together with the event type, the time and, for purchases, the order ID (so each order is counted once).
• Whenever the WP Consent API is installed, nothing is written to browser storage until a consent manager has recorded the visitor’s choice, even when the store does not require consent.
• Each event must carry the security token (nonce) printed on the page, so events cannot be sent without loading a page of your store. Pages served from a full-page cache older than about a day send expired tokens, and those events are not recorded.
• No IP address, name or email address is stored in the events table. IP addresses are used only transiently, hashed, for rate limiting.
• Events are deleted after the retention period chosen in Settings (default 90 days).
• Purchase events linked to a customer’s orders are included in WordPress’s personal data export and erasure tools.
• When Flavors Commerce Intelligence Pro is active this plugin stays dormant, but it still deletes its own old events on schedule and keeps them in the export and erasure tools.

Suggested privacy policy text is added to Settings > Privacy.