Envia Admin

Appearance

Pricing & Costs ​

Configure operational costs and selling prices for a shipping service. Both sections use a matrix of zones × weight ranges, with support for CSV upload, bulk actions, and margin tracking.

Overview ​

Every shipping service has two cost/price layers:

  • Operational Costs — What the carrier charges Envia (the base cost).
  • Pricing — What Envia charges customers, organized into 4 tariff types (basic, pro, enterprise, corporate).

The Pricing section shows the margin between cost and price, helping operators ensure profitability across all zones and weight ranges.

What You Can Do ​

  • View and edit the cost matrix (zone × weight range)
  • Upload costs from a CSV/Excel file
  • Download the current cost matrix as Excel
  • Apply bulk operations to cost cells (add, subtract, replace by fixed amount or percentage)
  • View and edit pricing for each tariff type (basic, pro, enterprise, corporate)
  • Switch between Markup and Margin views to analyze profitability
  • Upload pricing from a CSV file (supports partial updates per tariff type)
  • Apply Upgrade Pricing to recalculate all prices based on a percentage over costs
  • Save pricing per individual tab or all tabs at once

Getting There ​

  1. Open any service detail page (/services/:id)
  2. Scroll to the Operational Costs section (second card) or the Pricing section (third card)

Common Tasks ​

Viewing Operational Costs ​

  1. Scroll to the Operational Costs section
  2. The top form shows: Locale, Currency (auto-filled), Weight Unit (KG/LB), Fuel Type (flat/dynamic), and Fuel Percentage
  3. The main matrix shows costs per zone (columns) and weight range (rows)
  4. Below the main matrix, the Extra Weight Cost row shows the per-unit cost for weight exceeding the maximum range

Editing a Cost Cell ​

  1. Click on any cell in the cost matrix
  2. Type the new value
  3. The cell updates immediately (in-memory)
  4. Click Save at the bottom to persist all changes

TIP

Changes are held in memory until you save. You can edit multiple cells and save once.

Uploading Costs via CSV ​

  1. Click the Upload button in the Costs section header
  2. In the modal, download the template if needed (link provided)
  3. Upload your CSV/Excel file with columns: service_id, zone, weight_extra_cost, weight_max, cost
  4. The system validates the structure and loads the data into the matrix
  5. Review the loaded data in the matrix
  6. Click Save to persist

Downloading Costs to Excel ​

  1. Click the dropdown arrow next to the Upload button
  2. Click Download Costs
  3. An Excel file is generated with the current cost matrix (zones as columns, weight ranges as rows)

Using Bulk Actions on Costs ​

  1. Select cells in the cost matrix (click and drag, or use Shift+Click)
  2. A bulk action modal appears with options:
    • Operation: Add, Subtract, or Replace
    • Type: Fixed amount or Percentage
    • Value: The amount or percentage to apply
    • Decimal Config: Round or Truncate
    • Decimal Places: Number of decimal places
  3. Click Apply to update all selected cells

Viewing Service Pricing ​

  1. Scroll to the Pricing section
  2. Select a tariff tab: Basic, Pro, Enterprise, or Corporate
  3. The matrix shows prices per zone and weight range for the selected tariff
  4. Each cell displays:
    • The selling price (with change indicator if modified)
    • The margin/markup percentage (color-coded)

Understanding Margin Indicators ​

ColorMargin RangeMeaning
🔴 RedBelow 15%Danger — price is too close to cost
🟡 Yellow15% – 25%Warning — acceptable but low margin
🟢 GreenAbove 25%Safe — healthy margin

WARNING

A red banner appears at the top of the matrix when any cell in the current tab has a margin below 15%.

Switching Between Markup and Margin Views ​

In the Pricing section, use the toggle above the matrix:

  • Markup: Shows the percentage increase over cost: (price - cost) / cost × 100
  • Margin: Shows the percentage of price that is profit: (price - cost) / price × 100

Both views show the same data — only the percentage indicator changes.

Understanding Pricing Operators ​

The Pricing form has an Operator field with two options:

OperatorCell Value RepresentsHow Price is Calculated
FlatSelling price directlyThe value you enter IS the price
MarginMarkup percentage over costPrice = graduated cost × (1 + markup/100)

Graduated cost = base cost + taxes + fuel surcharge.

Uploading Pricing via CSV ​

  1. Click the Upload button in the Pricing section header
  2. Upload a CSV with columns: service_id, zone, weight_extra_cost, weight_max, and optionally basic_plan, pro_plan, enterprise_plan, corporate_plan
  3. Only tariff columns present in the CSV are updated — missing columns are left unchanged
  4. Review and save

TIP

You can upload pricing for just one tariff type (e.g., only basic_plan column) without affecting the others.

Using Upgrade Pricing ​

Upgrade Pricing recalculates all pricing tariffs based on a percentage applied to the cost matrix. This is useful when costs change and you need to adjust all prices proportionally.

  1. In the Costs section, click the dropdown and select Upgrade Pricing
  2. Configure global settings: operator (flat/margin), decimal config, decimal places
  3. For each tariff type (basic, pro, enterprise, corporate):
    • Enable/disable the tariff
    • Set a global percentage, or configure per-zone percentages
  4. Click Apply — all pricing matrices update in-memory
  5. Switch to the Pricing section to review the changes (cells show previous → new values)
  6. Save in the Pricing section to persist

Saving Pricing ​

You have two save options:

  • Save Current Tab: Saves only the active tariff tab (e.g., only "basic")
  • Save All Tabs: Saves all four tariff types at once

Frequently Asked Questions ​

What is the "Extended Zone" field in Pricing? ​

Extended Zone is a flat surcharge (in the service currency) added to shipments in extended delivery areas. It's configured once and applies across all tariff types.

Why does my margin show as negative? ​

A negative margin means the selling price is below the graduated cost (base cost + taxes + fuel). Review the cost matrix and adjust pricing upward, or use Upgrade Pricing to recalculate.

Can I upload costs and pricing from the same CSV? ​

No. Costs and Pricing have different CSV structures and are uploaded separately. Costs require a cost column; Pricing requires plan columns (basic_plan, etc.).

What happens if I change the locale? ​

Changing the locale updates the currency for all cost and pricing values. The zones and weight ranges remain the same — only the monetary unit changes.

How does fuel percentage affect pricing margins? ​

Fuel is factored into the "graduated cost" used for margin calculation: graduated cost = base cost + (cost × tax%) + (cost × fuel%). Higher fuel percentages raise the effective cost, reducing margins.

Envia Admin