Setting Costs in Metorik
Metorik offers a robust solution for managing your product and other costs directly within Metorik. This allows you to see your COGS on a product/variation level, on all your orders, and of course, see your profit.
To get started, head to the costs section.
In this article
Part 1: Set Product Costs
Importing costs from WooCommerce/Shopify:
If you're setting up Metorik's costs system for the first time, and you already have products costs set in your WooCommerce or Shopify store, you can click the 'Import from WooCommerce/Shopify' button to import your costs:
You can only import from WooCommerce if you're using the official WooCommerce COGS Plugin.
We get the costs that you have set on products and variants directly in Shopify.
This will automatically begin the import. We will send you an email when it's done:
Going forward, you can update costs inside of Metorik (as described below). However, if you'd like to automatically import costs from WooCommerce or Shopify, that's possible too by enabling the auto-sync option.
Setting products costs manually:
If you don't already have products costs set (or want to set them manually), you can click the 'Set Products Costs' button to set them manually.
You have a few tools at your disposal to make setting the costs simple and easy:
1. Metorik's segmenting system — if you want to only see a subset of your products, you can segment to only display those specific products.
2. Simple search — just enter in the name of a product and it will show below.
3. Show products without a cost — this will filter the list to only show products without a cost set. This is handy down the line when you have some products that have a cost already set and some without.
4. Bulk import costs — click the "Bulk Import Costs" button to upload a CSV containing all your products and costs. Optionally you can export a CSV template to enter the costs into.
The CSV does not need to contain all products. We will just try to match and update any included products in the uploaded CSV (products not included in the CSV or those that can't be matched will be ignored).
By default we'll try to match the imported costs to your products by the product ID (and variation ID for variation costs). But optionally you can choose to match by SKU.
Part 2: Set Other Costs
Of course, an order might consist of some additional costs such as shipping costs, transaction costs, and another extra cost that might be specific to your store. You can add these in this section. These are completely optional.
Manage shipping costs here.
You can set 3 different types of shipping costs:
- Based on the shipping country (or billing country, if the order has no shipping country).
- Based on the shipping method.
- A blanket cost applied to all orders with shipping.
These rules are applied in a hierarchical order. Metorik will look to apply a country rule — if this doesn't exist, it will then look for a method rule — and if there is no method rule, it will apply a backup rule.
For a country rule, simply select the country and then add the shipping cost associated:
You can select a shipping method from the dropdown of possible shipping method titles:
Then you can add a cost for orders with that method:
WooCommerce: If you have the real cost stored in a custom field, you can click the 'get cost' button and enter it in the field:
With this setting, you need to get the real cost stored in your custom fields/meta for the order. Perhaps the shipping plugin you are using can do this, or if you use a fulfillment provider like ShipStation they may be setting it on an order.
Backup rules are designed as a catch-all in case there are no country or method rules set. You can use this method if you just want to apply a global shipping cost to all orders that contain shipping. You can choose either a fixed cost or a percentage cost:
Manage transaction costs here.
Next, you can set a cost for all the different transaction methods you offer your customers:
WooCommerce: You can set a custom field to get the true transaction cost from, rather than estimating it with a $ and % cost. For some transaction methods, we already will provide a recommended field to use, so you can just click the set recommended button to etner it.
Please note that for the enabled mayment methods to show there needs to be a least one Order that has used that method, as otherwise we don't know which payment methods exist.
Manage extra costs here.
If you have an additional cost that should be applied to all orders, you can add this here too. For example, maybe an order handling cost or an estimated advertising cost.
Your extra cost can also vary depending on how many items are in the order. This is handy if you want to add a handling fee for every item in the order. So for example, add 50c for every item in the order:
WooCommerce: You can set a custom field to get the 'extra cost' from instead.
Manage advertising costs here.
Advertising costs are different to other costs, such as product/shipping costs, as advertising costs are stored and calculated on an overall basis, while product costs are stored and calculated on each order individually.
More info about syncing advertising costs can be found in this help doc.
Part 3: Externally Calculated Costs
For WooCommerce stores only: If you prefer to calculate costs on your end and store them in custom fields, you can configure Metorik to use these instead.
This is different from the custom fields settings above, as with this method, all your costs including product costs are calculated and stored externally in your WooCommerce store, and then we will sync those costs to our reports.
For more information, check out this help doc.
Part 4: Calculate for Existing Orders
Metorik will automatically apply the costs you have just set to all future orders. However, all of your existing orders won't have these costs applied yet.
Click the Calculate button to apply these new costs to all previous orders:
You can run this tool at any time from the cost tools page. You'll be given the choice between calculating costs only on orders that are missing a cost or on all orders, overriding previous costs:
Metorik will send you an email when it is done calculating order costs.
And that's it, all your costs are now set. You can head to the costs page at any point to update any of the costs.
Now you will have access to Metorik's Profit Reports.