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
215077 2020-08-30 $21.56 First-Class Package Service 1 0.45 lbs $4.77 $4.57 $0.20
215078 2020-08-30 $11.66 USPSFirstClass 1 0.39 lbs $5.19 $4.32 $0.87
215079 2020-08-30 $127.15 Priority Mail 2-Day 2 4.70 lbs $25.37 $24.52 $0.85
215080 2020-08-30 $14.57 First-Class Package Service 4 0.47 lbs $4.71 $4.46 $0.25
215081 2020-08-30 $8.67 First-Class Package Service 3 0.22 lbs $3.70 $3.25 $0.45
215084 2020-08-30 $32.56 USPSFirstClass 4 0.57 lbs $13.28 $4.00 $9.28
215085 2020-08-30 $8.67 USPSFirstClass 1 0.05 lbs $4.38 $3.18 $1.20
215087 2020-08-30 $24.81 First-Class Package Service 1 0.65 lbs $5.52 $5.27 $0.25
215088 2020-08-30 $38.29 Priority Mail 3-Day Small Flat Rate Box 1 1.25 lbs $8.50 $7.65 $0.85
215089 2020-08-30 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.35 lbs $8.50 $7.65 $0.85
215090 2020-08-30 $22.53 USPSFirstClass 1 0.45 lbs $5.74 $4.32 $1.42
215093 2020-08-30 $100.47 Priority Mail 3-Day 4 3.70 lbs $10.24 $9.07 $1.17
215094 2020-08-30 $32.37 USPSPriority 1 1.90 lbs $11.92 $10.33 $1.59
215095 2020-08-30 $51.49 Priority Mail 2-Day Small Flat Rate Box 1 1.50 lbs $8.50 $7.65 $0.85
215096 2020-08-30 $133.03 Ground Home Delivery 1 12.90 lbs $23.04 $18.17 $4.87
215098 2020-08-30 $41.03 First-Class Package Service 2 0.60 lbs $4.45 $5.12 $-0.67
215099 2020-08-31 $17.52 USPSFirstClass 5 0.50 lbs $5.57 $3.31 $2.26
215100 2020-08-30 $25.21 Priority Mail 3-Day Small Flat Rate Box 1 1.00 lbs $8.50 $7.65 $0.85
215101 2020-08-30 $25.21 Priority Mail 3-Day Small Flat Rate Box 1 1.00 lbs $8.50 $7.90 $0.60
215104 2020-08-30 $105.35 Priority Mail 3-Day 8 2.27 lbs $18.53 $18.62 $-0.09
215105 2020-08-30 $8.55 First-Class Package Service 1 0.27 lbs $3.56 $4.08 $-0.52
215107 2020-08-30 $25.25 First-Class Package Service 1 0.35 lbs $3.76 $3.31 $0.45
215108 2020-08-31 $52.28 USPSFirstClass 6 1.80 lbs $16.54 $8.21 $8.33
215109 2020-08-30 $38.75 First-Class Package Service 2 0.75 lbs $5.57 $5.12 $0.45
215110 2020-08-30 $95.51 Priority Mail 2-Day 10 1.72 lbs $8.97 $8.12 $0.85
215113 2020-08-31 $83.65 Ground 3 1.86 lbs $22.38 $19.88 $2.50
215117 2020-08-31 $46.28 Priority Mail 2-Day Flat Rate Envelope 2 1.38 lbs $8.00 $7.65 $0.35
215119 2020-08-31 $10.98 First-Class Package Service 5 0.10 lbs $3.23 $2.78 $0.45
215121 2020-08-31 $32.79 First-Class Package Service 6 0.66 lbs $5.65 $5.40 $0.25
215122 2020-08-31 $9.32 First-Class Mail Stamped Letter 3 0.06 lbs $3.35 $3.05 $0.30
215125 2020-08-31 $20.99 USPSFirstClass 1 0.15 lbs $5.00 $3.18 $1.82
215127 2020-08-31 $10.68 USPSFirstClass 1 0.04 lbs $4.20 $2.78 $1.42
215128 2020-08-31 $34.07 USPSFirstClass 5 0.50 lbs $5.71 $4.08 $1.63
215129 2020-08-31 $18.56 USPSFirstClass 2 0.15 lbs $8.54 $3.05 $5.49
215130 2020-08-31 $35.96 First-Class Package Service 1 0.50 lbs $4.77 $4.32 $0.45
215132 2020-08-31 $9.28 USPSFirstClass 1 0.05 lbs $4.27 $3.05 $1.22
215133 2020-08-31 $126.68 Priority Mail 3-Day 5 5.85 lbs $25.03 $24.18 $0.85
215134 2020-08-31 $24.38 USPSFirstClass 1 0.15 lbs $4.90 $2.93 $1.97
215135 2020-08-31 $6.03 USPSFirstClass 1 0.01 lbs $3.99 $2.78 $1.21
215136 2020-08-31 $62.12 Priority Mail 2-Day 4 1.90 lbs $9.44 $7.75 $1.69
215137 2020-08-31 $7.08 First-Class Package Service 2 0.02 lbs $3.50 $3.05 $0.45
215138 2020-08-31 $6.37 First-Class Package Service 1 0.04 lbs $3.38 $2.93 $0.45
215139 2020-08-31 $3.69 First-Class Mail Stamped Letter 1 0.01 lbs $3.20 $3.18 $0.02
215140 2020-08-31 $88.61 Priority Mail 3-Day 2 3.25 lbs $15.01 $14.16 $0.85
215141 2020-08-31 $20.99 Priority Mail 2-Day Small Flat Rate Box 1 0.40 lbs $8.50 $7.65 $0.85
215142 2020-08-31 $8.21 First-Class Package Service 2 0.10 lbs $3.23 $2.78 $0.45
215147 2020-08-31 $12.29 First-Class Package Service 2 0.09 lbs $3.19 $2.74 $0.45
215148 2020-08-31 $37.29 Priority Mail 2-Day Small Flat Rate Box 1 1.10 lbs $8.50 $8.05 $0.45
215149 2020-08-31 $7.21 First-Class Package Service 8 0.08 lbs $3.29 $2.84 $0.45
215151 2020-08-31 $36.51 Priority Mail 3-Day 1 3.55 lbs $15.01 $7.75 $7.26
215152 2020-08-31 $60.07 Priority Mail 2-Day 2 2.35 lbs $16.59 $15.74 $0.85
215154 2020-08-31 $64.82 Priority Mail 3-Day 2 1.60 lbs $14.34 $13.49 $0.85
215155 2020-08-31 $123.47 Priority Mail 3-Day 3 3.55 lbs $16.91 $16.06 $0.85
215156 2020-08-31 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.50 $7.65 $0.85
215157 2020-08-31 $112.52 Priority Mail 2-Day 7 2.01 lbs $10.39 $8.92 $1.47
215158 2020-08-31 $7.80 First-Class Mail Stamped Letter 5 0.05 lbs $3.35 $2.93 $0.42
215159 2020-08-31 $32.45 Priority Mail 2-Day Small Flat Rate Box 1 0.15 lbs $8.50 $7.65 $0.85
215160 2020-08-31 $200.97 Priority Mail 2-Day 25 4.54 lbs $19.32 $14.56 $4.76
215161 2020-09-01 $154.30 Priority Mail 2-Day 5 5.45 lbs $10.35 $9.06 $1.29
215164 2020-09-01 $18.56 Priority Mail 3-Day 3 1.05 lbs $11.39 $11.13 $0.26
215166 2020-09-01 $50.42 Priority Mail 2-Day Medium Flat Rate Box 3 2.04 lbs $14.45 $12.50 $1.95
215167 2020-09-01 $7.78 USPSFirstClass 1 0.02 lbs $4.20 $3.52 $0.68
215168 2020-09-01 $17.38 Priority Mail 3-Day 3 0.03 lbs $8.41 $7.56 $0.85
215170 2020-09-01 $26.39 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $8.00 $8.15 $-0.15
215171 2020-09-01 $21.28 USPSFirstClass 1 0.03 lbs $4.75 $2.93 $1.82
215172 2020-09-01 $54.19 Priority Mail 3-Day Small Flat Rate Box 1 1.65 lbs $8.50 $8.05 $0.45
215173 2020-09-01 $8.87 USPSFirstClass 1 0.05 lbs $4.25 $3.05 $1.20
215174 2020-08-31 $65.12 Priority Mail 2-Day 7 2.53 lbs $17.63 $14.16 $3.47
215175 2020-09-01 $6.56 USPSFirstClass 1 0.01 lbs $4.29 $3.18 $1.11
215176 2020-09-01 $24.00 First-Class Package Service 1 0.60 lbs $4.71 $5.70 $-0.99
215177 2020-09-01 $6.56 USPSFirstClass 1 0.10 lbs $4.17 $3.05 $1.12
215178 2020-09-01 $39.21 First-Class Package Service 2 0.30 lbs $3.23 $3.25 $-0.02
215179 2020-09-01 $17.96 First-Class Package Service 1 0.27 lbs $3.97 $3.52 $0.45
215180 2020-09-01 $4.99 First-Class Package Service 1 0.02 lbs $3.50 $3.05 $0.45
215181 2020-09-01 $44.21 InternationalPriorityShipping 1 0.29 lbs $5.55 $4.32 $1.23
215185 2020-09-01 $16.96 First-Class Package Service 1 0.35 lbs $3.97 $3.52 $0.45
215186 2020-09-01 $10.59 First-Class Package Service 3 0.35 lbs $4.12 $4.46 $-0.34
215187 2020-09-01 $9.36 First-Class Package Service 2 0.07 lbs $3.38 $2.93 $0.45
215188 2020-09-02 $11.73 USPSFirstClass 1 0.20 lbs $4.24 $3.25 $0.99
215189 2020-09-02 $8.26 USPSFirstClass 1 0.40 lbs $4.87 $3.25 $1.62
215191 2020-09-02 $6.88 USPSFirstClass 1 0.07 lbs $4.09 $2.84 $1.25
215192 2020-09-02 $38.20 USPSFirstClass 1 0.64 lbs $6.85 $4.00 $2.85
215193 2020-09-02 $33.01 First-Class Package Service 15 0.30 lbs $3.76 $3.31 $0.45
215194 2020-09-02 $11.27 First-Class Package Service 2 0.10 lbs $3.29 $2.84 $0.45
215195 2020-09-02 $14.89 First-Class Package Service 1 0.50 lbs $5.65 $5.40 $0.25
215196 2020-09-02 $25.74 Priority Mail 2-Day Flat Rate Envelope 26 0.31 lbs $8.00 $7.65 $0.35
215197 2020-09-02 $26.89 First-Class Package Service 4 0.50 lbs $4.63 $4.18 $0.45
215199 2020-09-02 $38.34 USPSFirstClass 1 0.64 lbs $7.10 $4.32 $2.78
215202 2020-09-02 $23.63 USPSPriority 1 1.00 lbs $9.52 $7.65 $1.87
215203 2020-09-02 $30.34 Priority Mail 3-Day 5 1.62 lbs $11.39 $10.54 $0.85
215204 2020-09-02 $13.10 First-Class Package Service 3 0.12 lbs $3.23 $3.25 $-0.02
215205 2020-09-02 $31.56 First-Class Package Service 2 0.48 lbs $4.38 $3.93 $0.45
215207 2020-09-02 $11.21 First-Class Package Service 2 0.10 lbs $3.23 $2.78 $0.45
215208 2020-09-02 $15.59 First-Class Package Service 4 0.14 lbs $3.63 $3.18 $0.45
215209 2020-09-03 $12.03 USPSFirstClass 1 0.50 lbs $5.21 $3.52 $1.69
215210 2020-09-02 $20.42 Priority Mail 2-Day 5 1.14 lbs $8.97 $8.12 $0.85
215211 2020-09-02 $91.65 Priority Mail 2-Day 14 2.02 lbs $10.39 $7.65 $2.74
215213 2020-09-03 $6.46 USPSFirstClass 1 0.01 lbs $4.14 $3.05 $1.09
215214 2020-09-03 $7.51 USPSFirstClass 1 0.07 lbs $4.14 $2.93 $1.21
215215 2020-09-03 $9.11 USPSFirstClass 1 0.10 lbs $4.21 $3.39 $0.82
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56