Understanding Per Order Costs

Learn how Conjura's Per Order Costs import enhances contribution margin analysis by tracking commission rates, transaction fees, and other per-order expenses for accurate profitability insights in Retail Analytics.

Note: Accurate tracking of per-order costs is essential for calculating your true contribution margin.

When to Use a Custom Per Order Costs Import

Conjura's Per Order Costs import is essential for businesses aiming to understand their true profitability by accounting for all per-order expenses. This feature helps you accurately track additional costs tied to order processing, ensuring informed decision-making in pricing, marketplace optimization, and operational efficiency.

Common use cases include:

Commission rates for marketplaces (e.g., marketplace fees)
Transaction fees charged by payment processors
Order processing fees from your store or ERP system
Platform fees from sales channels

For example, you might apply a 3% commission rate to marketplace orders or a $0.50 transaction fee to all orders from a specific store.

Once uploaded, these costs seamlessly integrate into Conjura's Contribution Margin metrics across all dashboards, providing a complete view of profitability.

Important: We automatically pull commission fees for Amazon and eBay orders (when those connectors are enabled), so there's no need to add additional fees for these platforms.

How to Use a Custom Per Order Costs Import

Using the Form Interface

Navigate to 'Connect & Import' and select 'Per Order Costs'.
Complete the form with the following information:
- Store Name: Specify which store/channel these costs apply to. This corresponds to:
  - Linnworks: Subsource field
  - Brightpearl: Relevant store identifier field
  - Shopify/BigCommerce: Connected store names
- Start Date (optional, yyyy-mm-dd): When these costs begin applying. If left blank, costs apply across the entire store period.
- End Date (optional, yyyy-mm-dd): When these costs stop applying (if applicable).
- Currency: The currency for the cost amount (e.g., GBP, USD).
- Cost Amount per Order: Enter a fixed cost per order (leave blank if using percentage).
- Percentage of Revenue Cost per Order: Enter as decimal (e.g., 0.03 = 3%) for variable costs based on order value (leave blank if using fixed amount).
Select 'Submit Data'.
Your data will sync overnight and appear in your reports.

Using CSV for Bulk Uploads

For bulk uploads, download the CSV template from the Per Order Costs page. 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.

Managing Your Imports

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

Cost Structure Options

You can set up per-order costs using either:

Fixed Amount: A flat fee per order (e.g., $2.50 transaction fee)
Percentage of Revenue: A variable rate based on order value (e.g., 3% commission)

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