Shipping Charges Analysis

Shipping Charges Analysis — Functional Description

Analyzes shipped OpenCart orders to compare customer shipping charges against actual carrier costs recorded in oc_order_shipping_cost. Profit is calculated as shipping charged minus shipping paid. Only orders with a non-zero recorded shipping paid value are included. Shipping method labels are normalized by trimming suffixes at an opening parenthesis, matching legacy grouping behavior.

Profit Status Row Legend (Section 3.4)

  • High Profit Profit greater than or equal to $2.00 — green row highlight (table-success)
  • Moderate Profit Profit between $1.00 and $1.99 inclusive — yellow row highlight (table-warning)
  • Low / Loss Profit strictly below $1.00 — red row highlight (table-danger)
  • Date range — optional Start Date and End Date boundaries filter on oc_order.date_added.
  • Weight range slider — dual-handle control auto-scales to the absolute minimum and maximum total product weight present in the active dataset (respecting the selected date range).
  • Profit range slider — dual-handle control auto-scales to the absolute minimum and maximum shipping profit (charged minus paid) present in the active dataset.
  • Shipping methods — multi-select narrows results to one or more normalized carrier methods; leave empty to include all methods.
  • Click any column header to sort; pagination retains all active filter and sort parameters.
Report Filters
Start End
Drag both handles to narrow total product weight (0–115 lbs).
Drag both handles to narrow shipping profit ($-103476.00–$126.00).
Leave unselected to include all shipping methods.

21021 matching order(s)

Order ID ▲DateOrder TotalShipping Method# ProductsTotal WeightShipping ChargedShipping PaidProfit
208984 2019-12-26 $24.28 Priority Mail 3-Day Flat Rate Envelope 1 0.85 lbs $7.80 $7.55 $0.25
208985 2019-12-26 $14.17 First-Class Package Service 4 0.50 lbs $4.81 $3.96 $0.85
208986 2019-12-26 $49.36 Priority Mail 3-Day Flat Rate Envelope 4 1.41 lbs $7.80 $7.55 $0.25
208987 2019-12-26 $21.06 First-Class Package Service 1 0.45 lbs $4.27 $3.88 $0.39
208989 2019-12-26 $105.88 Priority Mail 3-Day Medium Flat Rate Box 7 2.95 lbs $14.05 $10.55 $3.50
208990 2019-12-27 $38.14 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $8.35 $7.50 $0.85
208991 2019-12-27 $14.13 First-Class Package Service 1 0.07 lbs $4.14 $3.09 $1.05
208992 2019-12-27 $101.55 Priority Mail 2-Day 11 3.32 lbs $9.97 $8.81 $1.16
208993 2019-12-27 $38.78 First-Class Package International Service 1 0.40 lbs $21.79 $22.80 $-1.01
208994 2019-12-27 $34.70 Priority Mail 2-Day Small Flat Rate Box 1 1.15 lbs $8.35 $7.50 $0.85
208995 2019-12-27 $42.72 Ground 6 0.74 lbs $17.12 $16.51 $0.61
208996 2019-12-27 $24.53 First-Class Package Service 1 0.40 lbs $4.54 $4.19 $0.35
208997 2019-12-27 $37.14 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $8.35 $7.50 $0.85
209003 2019-12-27 $123.02 Priority Mail 3-Day 5 4.40 lbs $9.97 $9.12 $0.85
209005 2019-12-27 $26.46 First-Class Package Service 1 0.40 lbs $4.27 $3.88 $0.39
209007 2019-12-27 $9.99 First-Class Package Service 2 0.07 lbs $4.01 $2.96 $1.05
209008 2019-12-27 $17.66 First-Class Package Service 1 0.16 lbs $4.27 $3.22 $1.05
209010 2019-12-28 $37.14 Priority Mail 3-Day Small Flat Rate Box 1 1.15 lbs $8.35 $7.50 $0.85
209012 2019-12-28 $6.50 First-Class Package Service 1 0.20 lbs $4.01 $3.49 $0.52
209013 2019-12-28 $34.70 Priority Mail 2-Day Flat Rate Envelope 10 0.72 lbs $7.80 $7.82 $-0.02
209014 2019-12-28 $49.91 First-Class Package Service 6 0.82 lbs $5.97 $5.12 $0.85
209015 2019-12-28 $8.52 First-Class Package Service 2 0.10 lbs $4.14 $3.63 $0.51
209016 2019-12-28 $60.95 Priority Mail 2-Day 2 2.50 lbs $10.11 $9.26 $0.85
209017 2019-12-28 $6.70 First-Class Package Service 1 0.03 lbs $3.81 $2.76 $1.05
209018 2019-12-28 $15.13 First-Class Package Service 1 0.16 lbs $4.68 $3.63 $1.05
209020 2019-12-29 $31.95 Priority Mail 2-Day 4 1.85 lbs $9.19 $8.34 $0.85
209021 2019-12-29 $155.80 Priority Mail 2-Day 1 10.30 lbs $37.08 $36.23 $0.85
209023 2019-12-29 $6.80 First-Class Package Service 1 0.06 lbs $4.01 $2.96 $1.05
209024 2019-12-29 $24.33 First-Class Package Service 1 0.60 lbs $5.04 $5.38 $-0.34
209025 2019-12-29 $25.45 Priority Mail 2-Day 3 1.05 lbs $11.08 $10.23 $0.85
209026 2019-12-29 $115.22 Priority Mail 1-Day 17 3.13 lbs $8.56 $7.71 $0.85
209028 2019-12-29 $19.38 First-Class Package Service 3 0.30 lbs $4.41 $2.84 $1.57
209030 2019-12-29 $6.50 First-Class Package Service 1 0.01 lbs $4.01 $2.96 $1.05
209031 2019-12-29 $25.22 First-Class Package Service 1 0.75 lbs $6.43 $5.38 $1.05
209033 2019-12-29 $225.43 Priority Mail 2-Day 4 11.47 lbs $38.54 $36.23 $2.31
209035 2019-12-29 $38.47 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.35 $7.50 $0.85
209039 2019-12-29 $21.76 First-Class Package Service 1 0.35 lbs $4.27 $3.22 $1.05
209042 2019-12-29 $20.99 Priority Mail 2-Day Flat Rate Envelope 1 0.80 lbs $7.80 $7.55 $0.25
209044 2019-12-30 $51.63 Priority Mail 3-Day Medium Flat Rate Box 2 1.90 lbs $14.05 $11.20 $2.85
209046 2019-12-30 $41.14 First-Class Package Service 3 0.92 lbs $5.97 $7.50 $-1.53
209047 2019-12-30 $46.85 Priority Mail 3-Day Small Flat Rate Box 1 1.45 lbs $8.35 $7.50 $0.85
209050 2019-12-30 $7.88 First-Class Package Service 1 0.08 lbs $3.89 $2.84 $1.05
209051 2019-12-30 $28.09 Priority Mail 3-Day 2 1.90 lbs $10.11 $9.26 $0.85
209055 2019-12-30 $43.88 Priority Mail 3-Day 1 1.85 lbs $9.19 $8.12 $1.07
209056 2019-12-30 $19.71 First-Class Package Service 4 0.20 lbs $3.75 $2.70 $1.05
209058 2019-12-30 $5.30 First-Class Package Service 1 0.03 lbs $3.81 $2.76 $1.05
209061 2019-12-31 $25.88 First-Class Package Service 1 0.60 lbs $6.09 $5.24 $0.85
209065 2019-12-31 $27.43 Priority Mail 2-Day 4 1.00 lbs $8.27 $7.42 $0.85
209068 2019-12-31 $30.97 Priority Mail 2-Day 1 0.80 lbs $9.35 $8.50 $0.85
209069 2019-12-31 $22.36 First-Class Package Service 2 0.40 lbs $4.87 $3.93 $0.94
209071 2019-12-31 $57.18 Priority Mail 2-Day 9 1.81 lbs $16.13 $12.10 $4.03
209072 2019-12-31 $27.09 First-Class Package Service 2 0.46 lbs $4.23 $3.82 $0.41
209073 2019-12-31 $35.18 Priority Mail 2-Day 7 2.05 lbs $13.95 $13.10 $0.85
209076 2020-01-01 $173.30 Priority Mail 3-Day 2 4.40 lbs $17.53 $9.07 $8.46
209077 2020-01-01 $24.47 First-Class Package Service 1 0.60 lbs $5.18 $5.53 $-0.35
209078 2020-01-01 $33.76 Priority Mail 2-Day Flat Rate Envelope 1 3.55 lbs $7.80 $7.55 $0.25
209081 2020-01-01 $36.10 Priority Mail 3-Day 1 2.40 lbs $10.11 $10.03 $0.08
209082 2020-01-01 $24.51 First-Class Package Service 2 0.65 lbs $4.93 $5.02 $-0.09
209087 2020-01-01 $175.99 Priority Mail International 4 4.12 lbs $64.83 $64.22 $0.61
209089 2020-01-02 $42.14 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.35 $7.50 $0.85
209091 2020-01-01 $191.02 Priority Mail 3-Day 15 6.05 lbs $15.00 $9.46 $5.54
209092 2020-01-02 $48.64 Priority Mail 2-Day 1 1.85 lbs $13.95 $10.55 $3.40
209093 2020-01-02 $41.12 Priority Mail 2-Day Flat Rate Envelope 2 2.05 lbs $7.80 $7.55 $0.25
209094 2020-01-02 $57.78 Priority Mail 3-Day 6 1.80 lbs $13.95 $10.55 $3.40
209095 2020-01-02 $157.68 Priority Mail 2-Day 6 5.68 lbs $20.71 $20.46 $0.25
209096 2020-01-02 $18.66 First-Class Package Service 5 0.28 lbs $4.41 $3.36 $1.05
209097 2020-01-02 $20.07 Priority Mail 3-Day 1 0.95 lbs $11.08 $10.23 $0.85
209098 2020-01-02 $61.87 Priority Mail 3-Day 5 1.30 lbs $11.08 $10.23 $0.85
209100 2020-01-02 $23.29 First-Class Package Service 4 0.27 lbs $4.33 $3.28 $1.05
209102 2020-01-02 $23.04 Priority Mail 2-Day Flat Rate Envelope 6 1.14 lbs $7.80 $7.65 $0.15
209103 2020-01-02 $6.38 First-Class Package Service 1 0.20 lbs $3.89 $3.36 $0.53
209106 2020-01-02 $18.80 First-Class Package Service 1 0.20 lbs $4.01 $3.49 $0.52
209107 2020-01-02 $20.23 First-Class Package Service 4 0.32 lbs $4.27 $3.22 $1.05
209108 2020-01-02 $16.20 First-Class Package Service 1 0.30 lbs $4.41 $3.36 $1.05
209111 2020-01-02 $7.13 First-Class Package Service 1 0.05 lbs $4.14 $3.09 $1.05
209112 2020-01-02 $7.00 First-Class Package Service 1 0.03 lbs $4.01 $2.96 $1.05
209113 2020-01-02 $131.22 Priority Mail 2-Day 3 4.00 lbs $21.25 $20.40 $0.85
209114 2020-01-02 $27.21 First-Class Package Service 4 0.57 lbs $4.73 $5.02 $-0.29
209116 2020-01-03 $29.37 First-Class Package Service 1 0.45 lbs $4.67 $4.94 $-0.27
209117 2020-01-03 $52.96 Priority Mail 3-Day 9 1.18 lbs $10.55 $7.82 $2.73
209118 2020-01-03 $6.70 First-Class Package Service 1 0.03 lbs $3.81 $2.76 $1.05
209120 2020-01-03 $19.21 First-Class Package Service 3 0.35 lbs $5.04 $4.19 $0.85
209121 2020-01-03 $12.79 Priority Mail 2-Day Flat Rate Envelope 1 0.07 lbs $7.80 $7.50 $0.30
209125 2020-01-03 $16.02 First-Class Package Service 1 0.16 lbs $4.41 $3.36 $1.05
209129 2020-01-04 $10.99 First-Class Package Service 2 0.10 lbs $4.01 $2.96 $1.05
209130 2020-01-04 $6.80 First-Class Package Service 1 0.05 lbs $3.81 $2.76 $1.05
209131 2020-01-04 $10.99 First-Class Package Service 2 0.08 lbs $4.01 $2.96 $1.05
209133 2020-01-04 $15.69 Priority Mail 2-Day Flat Rate Envelope 1 0.07 lbs $7.80 $7.50 $0.30
209136 2020-01-04 $40.67 Priority Mail 2-Day 4 0.89 lbs $11.71 $10.86 $0.85
209138 2020-01-04 $18.76 First-Class Package Service 5 0.22 lbs $4.33 $3.28 $1.05
209142 2020-01-04 $77.27 Priority Mail 2-Day Medium Flat Rate Box 10 1.71 lbs $14.05 $11.19 $2.86
209146 2020-01-05 $30.42 Priority Mail 2-Day Large Flat Rate Box 3 0.90 lbs $18.45 $9.99 $8.46
209147 2020-01-05 $24.53 First-Class Package Service 1 0.40 lbs $4.54 $4.32 $0.22
209148 2020-01-05 $7.38 First-Class Package Service 1 0.05 lbs $3.89 $2.84 $1.05
209151 2020-01-05 $21.70 First-Class Package Service 2 0.15 lbs $5.24 $5.38 $-0.14
209153 2020-01-05 $35.22 Priority Mail 2-Day 4 2.90 lbs $9.66 $8.81 $0.85
209154 2020-01-05 $39.57 First-Class Package Service 4 0.32 lbs $4.41 $3.39 $1.02
209155 2020-01-05 $20.70 First-Class Package Service 1 0.41 lbs $4.41 $4.06 $0.35
209156 2020-01-05 $20.99 Priority Mail 3-Day Flat Rate Envelope 1 0.80 lbs $7.80 $7.55 $0.25
209157 2020-01-05 $18.91 Priority Mail 2-Day 4 1.30 lbs $9.35 $8.50 $0.85
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56