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
208106 2019-10-18 $33.20 Direct Link International 1 0.45 lbs $13.21 $14.20 $-0.99
208109 2019-10-18 $61.41 Direct Link International 2 1.50 lbs $23.73 $103499.62 $-103475.89
208110 2019-10-18 $22.76 Priority Mail 3-Day Flat Rate Envelope 4 0.33 lbs $7.80 $7.50 $0.30
208111 2019-10-18 $71.29 Priority Mail 3-Day 2 5.75 lbs $10.31 $9.46 $0.85
208112 2019-10-18 $10.00 First-Class Package Service 1 0.01 lbs $4.01 $2.96 $1.05
208113 2019-10-18 $34.99 Priority Mail 2-Day 6 1.80 lbs $12.65 $10.00 $2.65
208114 2019-10-18 $5.87 First-Class Package Service 2 0.02 lbs $3.89 $2.84 $1.05
208115 2019-10-18 $20.53 First-Class Package Service 1 0.35 lbs $4.54 $4.19 $0.35
208117 2019-10-18 $111.72 Direct Link International 14 3.75 lbs $33.49 $42.95 $-9.46
208118 2019-10-19 $36.70 Priority Mail 2-Day 1 0.64 lbs $11.71 $8.25 $3.46
208120 2019-10-19 $8.99 First-Class Package Service 2 0.16 lbs $4.01 $3.49 $0.52
208121 2019-10-19 $5.88 First-Class Package Service 1 0.06 lbs $3.89 $2.84 $1.05
208123 2019-10-19 $51.15 Priority Mail 3-Day 2 4.10 lbs $9.97 $8.12 $1.85
208124 2019-10-19 $8.74 First-Class Package Service 1 0.20 lbs $3.75 $2.70 $1.05
208127 2019-10-19 $36.16 Priority Mail 3-Day 5 1.75 lbs $11.71 $11.20 $0.51
208129 2019-10-20 $7.80 First-Class Package Service 1 0.05 lbs $3.81 $2.76 $1.05
208130 2019-10-20 $7.63 First-Class Package Service 1 0.07 lbs $3.89 $2.84 $1.05
208131 2019-10-20 $15.74 First-Class Package Service 3 0.15 lbs $4.27 $3.22 $1.05
208132 2019-10-20 $62.41 Priority Mail 2-Day Large Flat Rate Box 12 2.91 lbs $18.45 $17.61 $0.84
208133 2019-10-20 $49.51 Priority Mail 3-Day 2 1.50 lbs $8.73 $7.88 $0.85
208134 2019-10-20 $9.82 First-Class Package Service 1 0.60 lbs $4.93 $5.02 $-0.09
208135 2019-10-20 $31.53 Priority Mail 3-Day 2 1.90 lbs $13.95 $13.10 $0.85
208136 2019-10-20 $8.13 First-Class Package Service 2 0.12 lbs $3.75 $3.22 $0.53
208138 2019-10-20 $28.16 Priority Mail 2-Day 4 0.72 lbs $9.35 $8.50 $0.85
208139 2019-10-20 $122.58 Direct Link International 3 3.58 lbs $39.61 $28.34 $11.27
208140 2019-10-20 $11.96 First-Class Package Service 5 0.06 lbs $4.01 $2.96 $1.05
208142 2019-10-21 $28.69 First-Class Package Service 3 0.76 lbs $6.43 $5.38 $1.05
208144 2019-10-21 $15.67 First-Class Package Service 1 0.30 lbs $4.68 $3.63 $1.05
208146 2019-10-21 $4.95 Flat Shipping Rate 5 0.95 lbs $0.00 $5.38 $-5.38
208147 2019-10-21 $89.55 Priority Mail 2-Day 15 2.97 lbs $14.60 $15.67 $-1.07
208148 2019-10-21 $128.57 Priority Mail 2-Day Medium Flat Rate Box 4 11.90 lbs $14.05 $8.12 $5.93
208149 2019-10-21 $73.82 Priority Mail 2-Day 20 4.00 lbs $11.18 $13.77 $-2.59
208151 2019-10-21 $24.67 First-Class Package Service 1 0.00 lbs $4.68 $4.33 $0.35
208152 2019-10-21 $37.84 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.35 $7.50 $0.85
208153 2019-10-21 $21.68 Priority Mail 3-Day 5 0.95 lbs $8.73 $7.88 $0.85
208154 2019-10-21 $60.43 Priority Mail 2-Day 2 1.70 lbs $12.65 $11.80 $0.85
208157 2019-10-22 $18.14 Priority Mail 3-Day 1 0.95 lbs $9.35 $9.26 $0.09
208158 2019-10-22 $28.85 First-Class Package Service 3 0.55 lbs $6.38 $4.33 $2.05
208159 2019-10-22 $17.52 Priority Mail 2-Day 1 0.95 lbs $8.73 $8.34 $0.39
208161 2019-10-23 $28.23 First-Class Package Service 4 0.63 lbs $4.93 $5.02 $-0.09
208167 2019-10-23 $18.97 First-Class Package Service 4 0.14 lbs $4.01 $2.96 $1.05
208171 2019-10-23 $21.33 First-Class Package Service 2 0.45 lbs $4.27 $3.88 $0.39
208172 2019-10-23 $25.11 First-Class Package Service 3 0.20 lbs $4.14 $3.09 $1.05
208173 2019-10-24 $24.02 Priority Mail 3-Day 6 0.84 lbs $11.08 $10.23 $0.85
208174 2019-10-24 $142.95 Direct Link International 25 9.95 lbs $66.45 $65.47 $0.98
208178 2019-10-24 $42.37 First-Class Package Service 4 0.54 lbs $5.01 $3.96 $1.05
208179 2019-10-24 $8.39 First-Class Package Service 2 0.20 lbs $4.01 $2.96 $1.05
208180 2019-10-24 $90.42 Priority Mail 1-Day 9 1.62 lbs $8.27 $7.42 $0.85
208181 2019-10-24 $100.58 First-Class Package International Service 10 2.55 lbs $33.19 $24.94 $8.25
208182 2019-10-24 $38.14 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.35 $7.50 $0.85
208183 2019-10-25 $38.14 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.35 $7.50 $0.85
208185 2019-10-25 $37.84 Priority Mail 3-Day Small Flat Rate Box 1 1.15 lbs $8.35 $7.50 $0.85
208186 2019-10-25 $118.73 Priority Mail 2-Day 4 1.60 lbs $10.11 $8.50 $1.61
208187 2019-10-25 $5.88 First-Class Package Service 1 0.02 lbs $3.89 $2.84 $1.05
208188 2019-10-26 $23.15 First-Class Package Service 1 0.45 lbs $4.33 $3.96 $0.37
208189 2019-10-26 $7.00 First-Class Package Service 1 0.00 lbs $4.01 $2.96 $1.05
208190 2019-10-09 $34.55 Priority Mail 3-Day 3 0.63 lbs $3.08 $5.38 $-2.30
208191 2019-10-26 $18.50 First-Class Package Service 3 0.23 lbs $4.33 $3.28 $1.05
208197 2019-10-26 $6.69 First-Class Package Service 6 0.06 lbs $3.75 $2.70 $1.05
208201 2019-10-26 $68.52 Priority Mail 2-Day 11 0.95 lbs $9.35 $9.26 $0.09
208202 2019-10-27 $20.17 First-Class Package Service 1 0.35 lbs $4.68 $4.33 $0.35
208209 2019-10-27 $9.20 First-Class Package Service 1 0.07 lbs $4.01 $2.96 $1.05
208210 2019-10-27 $9.87 First-Class Package Service 2 0.10 lbs $3.89 $2.84 $1.05
208211 2019-10-27 $29.22 Priority Mail 3-Day 3 1.61 lbs $12.65 $11.80 $0.85
208213 2019-10-27 $14.39 First-Class Package Service 2 0.12 lbs $4.01 $2.96 $1.05
208215 2019-10-27 $12.86 First-Class Package Service 3 0.09 lbs $3.89 $2.84 $1.05
208217 2019-10-27 $42.67 Priority Mail 3-Day Flat Rate Envelope 2 1.75 lbs $7.80 $7.55 $0.25
208220 2019-10-27 $25.32 First-Class Package Service 2 0.26 lbs $4.54 $4.19 $0.35
208221 2019-10-27 $16.06 First-Class Package Service 1 0.30 lbs $4.27 $3.22 $1.05
208223 2019-10-27 $13.79 First-Class Package Service 10 0.04 lbs $3.89 $2.84 $1.05
208224 2019-10-27 $135.18 Ground 4 5.55 lbs $26.92 $20.55 $6.37
208227 2019-10-28 $7.00 First-Class Package Service 1 0.04 lbs $4.01 $2.96 $1.05
208228 2019-10-27 $75.98 Priority Mail 2-Day Small Flat Rate Box 2 2.50 lbs $16.70 $8.76 $7.94
208229 2019-10-28 $16.47 First-Class Package Service 1 0.30 lbs $4.68 $3.63 $1.05
208230 2019-10-28 $14.13 First-Class Package Service 1 0.07 lbs $4.14 $3.09 $1.05
208231 2019-10-29 $16.17 First-Class Package Service 1 0.35 lbs $4.68 $4.33 $0.35
208232 2019-10-29 $90.14 Priority Mail 2-Day 6 2.69 lbs $16.44 $10.55 $5.89
208233 2019-10-29 $43.98 First-Class Package International Service 5 0.20 lbs $22.03 $13.78 $8.25
208234 2019-10-29 $18.71 First-Class Package Service 4 0.20 lbs $4.27 $3.22 $1.05
208235 2019-10-30 $23.20 First-Class Package Service 1 0.25 lbs $4.41 $3.36 $1.05
208236 2019-10-30 $16.47 First-Class Package Service 1 0.30 lbs $4.68 $3.63 $1.05
208237 2019-10-30 $23.15 Priority Mail 3-Day Flat Rate Envelope 1 0.30 lbs $7.80 $7.50 $0.30
208238 2019-10-30 $31.44 Priority Mail 2-Day Flat Rate Envelope 2 1.08 lbs $7.80 $7.50 $0.30
208239 2019-10-30 $13.79 First-Class Package Service 2 0.20 lbs $3.81 $2.76 $1.05
208243 2019-10-30 $20.83 First-Class Package Service 1 0.41 lbs $4.54 $4.19 $0.35
208247 2019-10-30 $30.02 First-Class Package International Service 1 0.30 lbs $18.23 $16.39 $1.84
208248 2019-10-30 $14.36 First-Class Package Service 3 0.13 lbs $3.89 $2.84 $1.05
208251 2019-10-31 $21.46 First-Class Package Service 5 0.15 lbs $4.01 $2.96 $1.05
208252 2019-10-31 $31.64 First-Class Package Service 4 0.22 lbs $4.68 $3.63 $1.05
208255 2019-10-31 $48.57 Priority Mail 2-Day Flat Rate Envelope 12 1.05 lbs $7.80 $7.50 $0.30
208257 2019-10-31 $37.17 Priority Mail 3-Day Flat Rate Envelope 3 0.95 lbs $7.80 $7.50 $0.30
208259 2019-10-31 $5.00 First-Class Package Service 1 0.02 lbs $4.01 $2.96 $1.05
208260 2019-10-31 $24.32 First-Class Package Service 1 0.40 lbs $4.33 $3.96 $0.37
208262 2019-10-31 $17.72 Priority Mail 2-Day 1 0.95 lbs $8.73 $7.88 $0.85
208264 2019-10-31 $59.26 Priority Mail 2-Day 3 2.10 lbs $12.65 $7.55 $5.10
208266 2019-11-01 $7.74 First-Class Package Service 1 0.10 lbs $3.75 $2.70 $1.05
208271 2019-11-01 $16.33 First-Class Package Service 1 0.30 lbs $4.54 $3.49 $1.05
208272 2019-11-01 $10.80 First-Class Package Service 1 0.19 lbs $3.81 $2.76 $1.05
208273 2019-11-01 $134.20 Priority Mail 3-Day Large Flat Rate Box 15 4.27 lbs $18.45 $10.55 $7.90
208275 2019-11-02 $36.47 Priority Mail 3-Day 6 2.40 lbs $16.13 $15.28 $0.85
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56