Profit Reports for OpenCart

Overview

Code: kv_profit_reports · Version: 1.0.0 · Works with: OpenCart 4.x and 3.0.x

OpenCart knows what you sold, not what you earned. It has no cost price, so every report stops at revenue. Profit Reports adds the cost of your products and turns your orders into profit figures: per order, product, category, brand, customer, coupon, payment method and shipping method.

The cost of each order is frozen when the order is placed. A new supplier price never rewrites last month.

• Cost price on the product form, in a cost book for the whole catalogue and by CSV. Option values can add their own cost.
• Frozen on the order: every order line keeps the cost it had. Older orders can get an estimated snapshot, and they stay marked as estimated.
• The real costs of an order: shipping cost, payment fee rules per method, a fixed cost per order, and fields on the order page for the courier's real invoice.
• Overview: revenue, gross profit, margin, net profit, orders and average order, compared with the period before or last year; a chart; and a line-by-line view of where the money went.
• Nine reports: orders, products, categories, brands, customers, payment methods, shipping methods, coupons and points, tax lines per country. CSV, Excel and print.
• Operating expenses: rent, advertising, software. An amount spread over several dates counts per day.
• Returns in a finished status take their revenue and profit back out.
• Warnings: orders with missing costs, estimated orders, and orders that lost money. A product without a cost shows "no cost", never a flattering 100 %.
• Panel on the order page, margin in the order list.

Customers see nothing. The extension adds no storefront output, no outside service and no OCMOD.

Tested on

Figures, in one place

Tax is not part of any profit figure. Store credit and gift vouchers are ways to pay, so they do not reduce sales. Amounts are in the store currency, as OpenCart stores them. These are operational figures, not accounts or tax advice.

Installation

Requirements

• OpenCart 4.1.0.4 or 3.0.5.1 (tested versions, see Tested on)
• PHP 8.1 or newer, MySQL or MariaDB
• PHP ZipArchive for Excel files (OpenCart's installer needs it too)

OpenCart 4

1. Go to Extensions > Installer and upload kv_profit_reports.ocmod.zip.
2. Press the green install button in the installer list.
3. Go to Extensions > Extensions, choose Modules and install Profit Reports.
4. Open Profit Reports in the admin menu.

OpenCart 3

1. Go to Extensions > Installer and upload kv_profit_reports-oc3.ocmod.zip.
2. Go to Extensions > Extensions, choose Modules and install Profit Reports.
3. Open Profit Reports in the admin menu.

There is nothing to refresh under Modifications: the extension uses events only.

First steps

1. Open Cost book. Export the CSV, fill in the cost column, import it. Or type the costs in the list.
2. No costs at hand? Fill missing costs gives products a percentage of their price as a first estimate.
3. Open Settings, check the counted statuses, and enter your payment fees.
4. On Cost book, press Create snapshots to include orders from before the installation. They use today's costs and are marked as estimated.
5. Open Overview.

Updating

Upload the new package the same way. Costs, snapshots and expenses stay.

Removing

Uninstalling the module removes its tables: costs, snapshots and expenses. Export the cost book first. Orders and products are not touched.

Configuration

All settings are in Profit Reports > Settings.

General

Costs per order

Payment fees

For each payment method: a percentage of what the customer paid, plus a fixed amount. A change applies to new orders and to any order whose status changes later, unless you typed its fee on the order page.

Permissions

Users without access to Profit Reports do not see the cost field on the product form, the panel on the order page or the margin in the order list. Set this under System > Users > User Groups.

License

Enter the key from your Kavio Labs account in Settings > License. A 14-day trial runs without a key. Without a valid license new orders get no snapshot. Reports, costs and your data stay available, and the store is not affected. Orders placed in that time can get an estimated snapshot later.

Usage

Entering costs

• Product form: the field Cost price sits above the tax class on the Data tab.
• Cost book: every product in one list. Type a cost and leave the field, it saves by itself. Options opens the option values.
• CSV: the export has product_id, model, sku, name, price, cost. For import a file needs a cost column and one of product_id, model or sku. A product the file does not mention keeps its cost, and an empty cost cell changes nothing. Comma decimals work.

The cost of an option value is added to the product cost. A variant product without its own cost uses the cost of its master product.

When a cost is frozen

A line gets its cost when the order first receives a status. After that the line keeps it, also when you change the product's cost or edit the order. A line without a cost stays "no cost": add the cost later and new orders use it; for the order itself, the figures stay as they were.

Overview

Pick a period and a comparison. The cards show the change against the period before or the same dates last year. Where the money went walks from sales to net profit. Check these lists what makes the figures less reliable, with a link to the orders.

Reports

A product in several categories counts once, in its first category. In the product, category and brand reports, revenue includes the product's share of order discounts and excludes shipping and order costs.

CSV and Excel export the whole report for the period, not only the page. Print gives a clean page.

On the order page

The panel shows revenue, costs and profit. Under Actual costs of this order you can type the real shipping cost, the fee or an extra cost. An empty field goes back to your rule. Typed values survive later status changes.

Expenses

Add rent, advertising or software with a date range. A one-year invoice over 365 days counts 1/365 per day, so each period carries its share. Expenses reduce net profit only, not the profit of single orders.

Returns and refunds

A return request in a finished return status reduces gross profit by the profit of the returned units, on the date of the return. The goods are assumed to go back to stock. An order moved to a refund or cancelled status simply stops counting, and comes back if you move it back.

FAQ

Do customers see the cost?

No. The extension adds nothing to the storefront. It only stores figures when an order gets a status.

Do I have to enter every cost first?

No. Orders work without costs. Lines without a cost are marked, so you know the profit shown is too high. Filling costs in later helps new orders.

I changed a cost. Why did last month not change?

That is the point of the snapshot: an order keeps the cost it had.

Can I correct the cost of an old order?

Not line by line. Use the extra cost field on the order page. Orders from before the installation get today's cost when you create snapshots, and stay marked as estimated.

Why do the product report and the overview differ?

The overview includes shipping and order costs. The product report looks at goods only: revenue and cost of goods of each line.

Are multi-currency orders handled?

Yes. OpenCart stores order amounts in the store currency, and the reports use those. Costs are in the store currency too.

Does it work with several stores?

There is a store filter in the reports, and costs are shared because products are. Multi-store is not part of our tests.

Does it replace my accountant?

No. These are operational figures for running the shop. Tax lines are shown as charged on orders.

Does it change my orders or products?

No. It keeps its own tables and never writes to OpenCart's order or product tables.