Is your store making a profit? Or what is the profit percentage? Is it higher than your costs or not?
To give me an answer to all these questions, you must definitely calculate what is called the Cost of Goods Sold to determine the profit. So, what is the Cost of Goods Sold (COGS)?
The Cost of Goods Sold represents the direct costs of producing goods sold by your store, including materials, labor, shipping cost, and overhead cost. When you are calculating the cost of goods sold you can determine whether your eCommerce store is making a profit or not.
But we all know that calculating the cost of goods sold manually takes a lot of time and requires a high level of accuracy, that’s why the WooCommerce Cost of Goods: Product Cost & Profit Calculator plugin exists, which makes the process easier and efficient.
Here’s how you can calculate (COGS) using the appropriate plugin
Step1:
-
Download The Plugin
Download the “WooCommerce Cost of Goods: Product Cost & Profit Calculator” plugin from your WPFactory account, and upload it to your WordPress site.
Step2:
-
Access The Plugin
As the plugin is installed, you can customize it for your business requirements.
Go to WooCommerce > Settings > Cost of Goods Sold.
Here, you can:
- Enter default cost for products.
- Configure how costs should be calculated for variable products.
- Enable automatic COGS tracking for orders.
Step3:
-
Assign Cost to Products
Go to the product page, you can add costs for each product individually or for the bulk products.
-
Edit Individual Product Costs
From here, as shown in the image below, you can add costs for a single product by going to the product page > Product data section > General > Cost
Here, you can input the Regular price, Sale price, and product cost, and then the profit will be automatically calculated and displayed.
-
Edit Bulk Product Costs
If you sell multiple products, this plugin makes it easy for you to add the costs of these products via the Bulk Edit Cost option
Go to your WordPress dashboard > navigate to Tools > Bulk Edit Cost
As shown in the image below, this page allows you to edit the cost, price, and stock of all your products in your store, making it easier and faster to manage these details from a single page.
Step4:
-
Access the Plugin Setting
There are general settings related to the plugin that you can customize by going to Plugin setting > General product options
The first option expresses profit HTML template, which means customizing the template that will display the profit in the interface. For example, the %profit% option shows you the profit amount, and the %profit_percent% shows the profit percentage, while %profit_margin% is used for the profit margin.
So, you can display the profit in the way that suits you.
Step5:
-
Get Price method
This option helps you determine how the product price will be calculated, either:
- Calculating the price including tax.
- Calculating the price excluding tax.
Step6:
-
Cost Field Options
With the Cost Field Label option, you can customize the label on the cost field that appears in the control panel
You can also control where the cost field appears on the product page, for example, you can show it on the products editing page under the general section under prices.
Step7:
-
Admin Products List Columns
This section allows you to add custom columns that appear in the product list. You can add columns that show:
- Product Cost: which shows you the cost of each product in the product list.
- Product Profit: Which shows the amount of profit for each product based on the cost and price.
This is a good way because it gives you a quick overview at the costs and profits of tour products in one look and from one place, allowing you to easily compare products with each other and see which one is more profitable.
Step8:
-
Add Stock
This feature enables you to update the product’s cost and stock by adding a meta box to the product edit page. It helps you to calculate the new average cost of products when adding new inventory.
Step9:
-
Admin Orders List Columns
From the Order tab, you can add order cost and order profit columns, which will appear on the order page.
-
Admin Order Edit
This option will make it easier for you to edit costs from the order edit page
Step10:
-
Refunds
This section allows you to control how the refund affects the cost of the product and profits, simply, enabling one of these options:
- Ignore refunded item cost
- Ignore item refund amount
The refunds will not affect profit or cost calculations. Hence, if you want to ignore the refunds in the profit and cost calculation, activating these two options will suffice.
You can also determine the method of calculating profits through the three existing methods:
- Use default profit calculation mechanism
- Subtract total refunded from profit
- Calculate profit by the difference between Net Payment and Cost
Step11:
-
Extra Payment Gateway Cost
From the Payment Gateways tab, you can add extra costs to orders according to the payment gateways used.
Step12:
-
Extra Shipping Method Costs
And the same thing here, by enabling this section you can add extra costs for your orders based on order’s shipping method
Step13:
-
Multicurrency
If you deal with multiple currencies in your store, this may change the cost of the product from one currency to another. Through this section, you can add the currencies you deal with to be tracked by the plugin and calculate their costs.
Step14:
-
Reports
The final step is “Reports”, this plugin provides you with many reports, which provide you with reports on the product sold, the profit percentage, and costs for each period.
You can access it by navigating to WooCommerce > Reports > Cost of Goods.
Also from here, you can get reports related to your stock.
Final Words
As we always say: correct numbers = correct analysis, which means clarity. While accurate numbers and correct analysis don’t necessarily guarantee profit, they are essential for understanding your business’s financial health and making informed decisions.
So, calculating the cost of goods sold accurately is a fundamental step toward achieving this clarity. It allows you to track your costs, and identify areas for improvement to make your profits.