In the legacy OrderMetrics, users had a variety of options to configure shipping costs. These include:
Import shipping costs at the order level from shipping integrations such as ShipStation
Import shipping costs at the order level using spreadsheet data
Manually enter shipping costs at the product level in Data Warehouse
Create dynamic shipping cost rules at the product level (quantity breaks and country based costs)
Import shipping costs per order from AliExpress
With the launch of the all-new OrderMetrics, we have sunset all of the above options. This is mainly because we are no longer supporting shipping costs at the product or order level. Users can now enter their aggregate shipping costs for a given time period.
Shifting from shipping costs per order to an aggregate value removes potential error in linking expenses to each order. More importantly, decisions made on shipping costs and their effect on financial performance, are typically done on an average order basis (not on an order-by-order basis) to help you make sure you are marking up your products with enough margin - which is what we have done.
Head over to Data > Shipping Costs. To Add a Shipping Cost, enter the Payee, Cost and Date.
Please note that Shipping costs are not attributed to an individual order. We suggest adding your total shipping cost each day.
Additionally, in the all-new OrderMetrics, newly created shipping costs are automatically split across each day of the month. For example, if you create a shipping cost of $1,000 on Jan 17, we will split this $1,000 across each of the 31 days in January. So your shipping cost for Jan 17 will be $32.25, not $1,000.
Also, new shipping costs you create will be adjusted in your metrics at the next daily sync. For example, if you create a shipping cost at 5 pm. local time, it will be factored into your metrics at 12:00 am. local time next day (when the daily sync occurs).
What happens to my historical shipping costs from the legacy OrderMetrics?
If you had shipping data in the legacy OrderMetrics, we will bring it over to the all-new OrderMetrics as an aggregate for each day. Just like the new shipping costs you may create in the all-new OrderMetrics, the historical shipping costs from the legacy OrderMetrics will not be attributed at the order level. Instead, when you migrate, we take the daily shipping costs total from the legacy OrderMetrics and create a new shipping expense in the all-new OrderMetrics for each date.
This data will show up under Data > Shipping Costs, automatically sorted by most recent date. See example below.
Please note that we only migrate shipping data from the legacy OrderMetrics up until the date you migrate. So if you migrated on Feb 25, we will import the legacy OrderMetrics shipping costs up until Feb 25. Moving forward, you would need to manually add shipping costs in the all-new OrderMetrics as described above.