Custom Data Import: Shipping Costs

Understanding Shipping Costs

Learn how Conjura's Shipping Costs import enhances profitability analysis by tracking shipping expenses tied to your orders for accurate contribution margin insights.
​

Note: Shipping revenue (amount paid by customers) is included in Contribution Profit, so it's essential to add corresponding shipping costs to avoid inflating your margins.
​

Use this import when you know the standard cost of each shipping method and

want to apply that cost to all orders using that method. This is ideal for:

For example, you might apply 3.50 GBP to all "Standard Delivery" orders

shipping to the UK, 8.99 GBP for parcels over 5kg, or 2% of order revenue as

insurance for "Express International" shipments.

Costs are matched to orders by their shipping method, which is determined from:

Note: If your shipping methods vary based on weight/dimensions, ensure your OMS (such as Linnworks rules engines) assigns the correct shipping method so Conjura can accurately identify and apply the corresponding costs.
​

Note: This import applies costs by shipping method. For importing the

actual shipping cost of specific individual orders, use the "Order Shipping

Costs" import instead.

Note: Only fill in one cost type per row - either the fixed amount or the percentage, not both.

Using the Form Interface

Your data will sync overnight and appear in your reports.

Using CSV for Bulk Uploads

For bulk uploads, download the CSV template from the Shipping Costs page. The template will include all your available shipping methods. Fill in your data offline and upload by dragging and dropping the completed file onto the editor. Remember to delete all template rows before uploading your data.
​

You can define different costs for the same shipping method based on order

weight. The system calculates the total weight of all products in an order and

matches it to the appropriate weight band.

For example, for "Standard Delivery" to the UK:

An order weighing 7kg would match the 5–10kg band and be assigned a 5.00 cost.

If no weight bands are provided (Shipping Minimum Weight and Shipping Maximum

Weight left blank), the cost is treated as a flat rate and applied to all

orders using that shipping method, regardless of weight.

Priority: If an order matches both a weight-banded cost and a flat-rate cost

for the same shipping method, the weight-banded cost takes priority.

Shipping costs are allocated across line items within each order:

When multiple cost rows could apply to an order, the system uses priority

matching:

1. Specific country (highest priority)

2. All Countries (fallback) - applies if no specific country match exists

This allows you to set a general default shipping cost and override it for specific countries.

This import is one of several sources of shipping cost data. The system uses the following priority order:

1. Order Shipping Costs import: Per-order actual costs (highest priority)

2. This import (weight-banded): Matched by shipping method + order weight

3. This import (flat-rate): Matched by shipping method, split across line items

4. This import (% of revenue): Applied as a percentage of line item revenue

5. System shipping costs: Pulled from your connected platform (e.g. Brightpearl, Linnworks)

If multiple cost entries for the same shipping method, country, and weight band have overlapping date ranges, the entry with the latest end date takes priority for the overlapping days.

To remove shipping costs, locate the file under 'My Imported Data' in the custom data import tab and select the delete button.