WooCommerce Integration: Cost of Goods (Profit Reports)

Metorik offers an integration with the official  WooCommerce Cost of Goods plugin. If you already have it set up, the integration is seamless and automatic. If you don't yet have it set up, simply install the plugin, configure the COGS for all your products, and Metorik will integrate automatically (contact us if it's taking a while for the profit report/data to show up).

If you update the COGS of past orders in Woo, you may need to reimport all your past orders into Metorik so the COGS for those orders shows up. More info can be found in this help doc.


Getting started

It's important that you follow the WooCommerce Cost of Goods plugin setup instructions found here. If you're setting up the plugin after already setting up Metorik, make sure you run the Apply Costs to Previous Orders tool in WooCommerce and then contact us so we can sync your previous order costs.

Profit Report

From the dashboard and navigation you'll find the  Profit Report. It lets you see profit over time for a given period, as well as the net revenue, total cost of goods, and margin, alongside the growth for each one. You can also see the average profit per order.

All orders with statuses excluded from your reports based on your store settings (usually failed, cancelled, and pending) will be ignored and excluded from this report, so you're only looking at stats for successful orders. Refunded orders are included, but refunds made in the report's date period are deducted when calculating net revenue.

You'll also find a profit breakdown table beneath the chart, letting you see the # of orders, net revenue, COGS, profit, and margin for each period of time. It will be split up into the same 'date groups' as your chart. You can change the date group on the top right of the chart.

The data from this report can also be exported into a CSV, that will have the same format/layout as the profit breakdown table.

Product / Variation / Category Reports

This applies to the following pages:

On all of these pages, you'll find the COGS, profit, and margin for each result. For example, here's the layout for the variations page:

You can order the table by the COGS and profit. Additionally, the COGS & Profit will be included in all product/variation/category exports.

If you click through to any single product, variation, or category, you can see the individual profit stats for it, including its total COGS, profit, and margin:

Multi-currency support

Most multi-currency solutions for WooCommerce do not support Cost of Goods, so our support is in-turn quite limited. But as long as you set the cost in your main currency, reports should be pretty accurate and useful as we don't convert it to any other currency. 

Shipping costs

The WooCommerce COGS plugin that we integrate with doesn't currently have any support for setting shipping costs.

As such, we can't easily include shipping costs in Metorik, besides for shipping revenue you collect and can be deducted from gross in calculating net.
If you'd like to bring the shipping cost into Metorik currently, the only solution is through adding custom code on your end to add it.
Technically the WooCommerce COGS plugin stores the total order cost in a custom meta field with the key _wc_cog_order_total_cost. So you'd have to add code that runs whenever an order is saved and adds the shipping cost to the number in that custom meta field. Then it would change the order's cost/profit in Metorik.

Note: While the integration currently requires the WooCommerce Cost of Goods plugin, we will likely add our own Cost of Goods functionality directly to Metorik in the future.

Still need help? Contact Us Contact Us