One of the major costs for any ecommerce business is shipping costs. This guide walks you through the different ways you can configure shipping costs in OrderMetrics. If shipping costs are not configured in any of the following ways, we will assume the shipping cost for all orders as equal to the amount your customer paid for shipping (i.e Shipping Charged).
- Sync shipping costs directly from fulfilment software such as ShipStation
- Sync shipping costs from AliExpress (for dropshipping businesses)
- Manually upload shipping costs at the order level
- Configure shipping cost rules at the product level
- Configure fixed shipping costs for all orders
1. Sync shipping costs directly from services such as ShipStation
OrderMetrics offers integrations with popular third party fulfilment software such as ShipStation. When you connect your OrderMetrics account with one of these services, we fetch shipping costs from the connected service at the order level. You can head over to Data Warehouse > Integrations to connect with a supported provider
This is the best scenario for configuring shipping costs in OrderMetrics. Once a shipping service has been connected, no further configuration steps are required. We will automatically fetch shipping costs from your connected provider.
2. Sync shipping costs from AliExpress
OrderMetrics allows you to import your product and shipping costs for orders that are dropshipped from AliExpress. This integration is only available in the Pro plan.
Learn more about setting up AliExpress in our guide here
3. Manually upload shipping costs at the order level
Another option is to manually upload shipping costs at the order level. This option works best if you have access to the shipping cost information in spreadsheet format. For example, an Excel file from your supplier or an export from an unsupported shipping service such as DHL or FedEx.
The source file must have at least two pieces of information:
- A unique identifier for each order. This could be either the tracking number or the order number itself. In case of the order number, it should be in the same format as displayed in OrderMetrics.
- The total shipping cost for the order
Here’s how this would look like in a spreadsheet. Notice there are no currency symbols in the shipping costs column.
Once you have the shipping costs in the format shown above, you can copy/paste the data into OrderMetrics. To do this, head over to Data Warehouse > Shipping Data and paste the rows in the given table. Next, click on the “Import” button to import the costs.
4. Configure shipping cost rules at the product level
If none of the above options apply to you, you can create rules in OrderMetrics and we will calculate shipping costs at the order level. These are called “Product-based rules” and they can be configured under Data Warehouse > Shipping Data
These rules allow you to configure shipping costs in one of the following ways:
- Default shipping costs for individual products
- Shipping costs based on country (for individual products)
- Shipping costs based on country (universal rules for all products)
- Shipping costs based on the quantity purchased (for individual products)
- Shipping costs based on the quantity purchased (universal rules for all products)
Additionally, this section offers general rules around how we should calculate shipping costs for orders with multiple items and where the same product is purchased more than once. Note that we will only use one rule at a time, even if you have configured multiple types of rules for a single product. Let’s take a closer look at the options.
Default shipping costs for individual products
This is the most simple option whereby you can nominate a shipping cost for each product and we will use this value to calculate the shipping cost for every order where this product was purchased.
In the above screenshot, we have configured a default shipping cost of $5 for the product “Wool Sweater” and $7 for “Burgundy Wool”. To clarify how OrderMetrics will calculate the shipping costs for these items in various scenarios, please refer to the table below
Explanation for example order 1004
Whether we calculate $12 or $7 as the shipping cost for this order depends on the selection you’ve made in the below section:
If the first option is selected, we will sum the shipping costs from both items, which means the shipping cost for this order will be calculated as $12. If the second option is selected, we will assume the highest shipping cost among the items as the shipping cost for the order, which means the shipping cost for this order will be calculated as $7.
Shipping costs based on country
This option allows you to create shipping rules based on the destination country/region of the order. These rules can be created separately for each product, or as universal rules that apply to all products.
To create a country based rule for an individual product, click on “Manage” under the “Shipping Costs by Country” column for the desired product:
Next, select a country/region and enter a shipping cost.
In the above screenshot, we have configured country based shipping rules for the product “Wool Sweater”. To clarify how OrderMetrics will calculate the shipping costs for this product in various scenarios, please refer to the table below
Explanation for example order 2004
We can see that 2 wool sweaters were purchased in this order. Whether OrderMetrics multiplies the shipping cost by 2 depends on whether you have opted to multiply shipping costs per quantity for country based rules. To enable or disable this option, click on “Manage Country Rules” under “Default Country Based Rules”.
Next, you can enable/disable the multiplication by checking or unchecking the following box
So far we have gone through the process of creating country based shipping rules for individual products. However you can create a universal set of country based shipping rules which will apply to all products. This is useful if the rates you’ve negotiated with your supplier don’t vary from product to product.
To create universal country based shipping cost rules, click on “Manage Country Rules” under “Default Country Based Rules”
Configure shipping costs based on the quantity purchased (Quantity Break Rules)
The Quantity Breaks feature allows you to configure increasing/decreasing shipping costs for the same product based on the quantity purchased.
For example, let’s assume that my supplier charges me the following rates based on quantity shipped for Wool Sweater:
- Qty: 1 → Shipping Cost for the order: $3
- Qty: 2 → Shipping Cost for the order: $5
- Qty: 3 → Shipping Cost for the order: $7
- Qty: 4 to 10 → Shipping Cost for the order: $15
To configure these rules in OrderMetrics, I would click on “Manage” under the “Quantity Breaks” column for Wool Sweater:
Note: Quantity break rules become more complex to configure if you have checked the following checkbox:
We suggest leaving this checkbox unchecked for simplicity with creating quantity break rules. Assuming that this option is unchecked, here’s how you would create quantity break rules based on the example above
So far we have gone through the process of creating quantity based shipping rules for individual products. However you can create a universal set of quantity based shipping rules which will apply to all products. This is useful if the rates you’ve negotiated with your supplier do not vary from product to product.
Please note that the ranges for quantity breaks are not inclusive. For example, if you create a range from 1 to 5, it would apply to 1, 2, 3 and 4. The next range should start with 5.
If the ranges overlap, you will get an error.
The creation of these ranges can take from seconds to minutes, depending on the number of orders that will get their shipping cost recalculated based on the changes made.
To create universal quantity based shipping cost rules, click on “Manage” under “Default Quantity Breaks”.
5. Configure fixed shipping costs for all orders
If you have a fixed shipping cost that must apply to all orders regardless of the product, quantity, or country, you can configure this under Priority 3 of the shipping rules area:
What is the difference between “Shipping Cost” and “Shipping Charged”?
Shipping Charged is what your customer paid for shipping at checkout. This is considered revenue and it is not subtracted out when calculating profits. Shipping Cost is what it actually cost you to ship the order. This is considered as an expense and subtracted out when calculating profit.
How can I view shipping costs for individual orders?
You can scroll down on the main dashboard to see the Order Data section. Here we show shipping costs for individual orders.