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.
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
Shipping surcharges that vary by country or platform
For example, you might apply a 3% commission rate to marketplace orders, a $0.50 transaction fee to all orders from a specific store, or a flat shipping cost for orders to a particular country.
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 Per Order Costs Work
Per order costs are applied at the order level and split proportionally across line items within each order. There are two categories of per-order cost:
Shipping Costs (Is Shipping Cost = true): Costs related to shipping and delivery. If you import shipping costs, they replace any shipping cost data from your connected platform for matching orders. Only one cost is used, in priority order:
1. Cost Amount per Order (if provided)
2. Percentage of Revenue (if Cost Amount is blank)
3. Percentage of COGS (if both above are blank)
Non-Shipping Costs (Is Shipping Cost = false): All other per-order costs such as transaction fees, commission rates, and platform fees. These are additive - all matching cost types are summed together.
How to Use a Custom Per Order Costs Import
Navigate to 'Connect & Import' and select 'Per Order Costs'.
Complete the form with the following information:
Store Name (pre-populated, read only): Specify which store/channel these costs apply to. This corresponds to:
Linnworks: Subsource field
Brightpearl: Relevant store identifier field
Shopify/BigCommerce: Connected store names
Store URL (pre-populated, read only)
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). If left blank, these costs continue indefinitely.
Shipping Country: The country these costs apply to. Select 'All Countries' to apply costs to orders shipping to any country. If a specific country is also provided, the specific country cost takes priority.
Sales Platform: The sales platform these costs apply to. Select 'All Sales Platforms' to apply to all platforms. If a specific platform is also provided, the specific platform cost takes priority.
Is Shipping Cost: Set to
trueif this is a shipping cost, false for all other per-order costs. Determines how the cost is applied (see above).Currency: The currency for the cost amount (e.g., GBP, USD). Costs are automatically converted to the order's currency if they differ.
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).
Percentage of COGS Cost per Order: A percentage of order COGS (Cost of Goods Sold) to apply as a cost. Enter as a decimal (e.g. 0.10 for 10%). Requires product COGS data to be available (via Product Costs import or your connected platform).
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.
Examples
Marketplace Commission Rates:
Store: "B&Q Store"
Is Shipping Cost: false
Percentage of Revenue: 0.10 (10% commission)
Shipping Country: All Countries
Sales Platform: All Sales Platforms
Cost Amount: [leave blank]
Transaction Fees:
Store: "Main Website"
Is Shipping Cost: false
Cost Amount: 0.30 (30p per transaction)
Currency: GBP
Shipping Country: All Countries
Sales Platform: All Sales Platforms
Percentage of Revenue: [leave blank]
Country-Specific Shipping Cost:
Store: "Main Website"
Is Shipping Cost: true
Cost Amount: 5.00
Currency: GBP
Shipping Country: United Kingdom
Sales Platform: All Sales Platforms
Override for a Specific Platform:
Row 1: Store: "B&Q Store", Is Shipping Cost: false, Percentage of Revenue: 0.10, Sales Platform: All Sales Platforms (default 10% for all platforms)
Row 2: Store: "B&Q Store", Is Shipping Cost: false, Percentage of Revenue: 0.15, Sales Platform: Amazon (override to 15% for Amazon only)