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
226195 2021-07-13 $12.47 Priority Mail 2-Day Flat Rate Envelope 3 0.03 lbs $8.50 $7.90 $0.60
226196 2021-07-13 $27.74 Priority Mail 3-Day Flat Rate Envelope 1 1.00 lbs $7.95 $7.90 $0.05
226197 2021-07-13 $13.22 USPSFirstClass 1 0.06 lbs $4.63 $3.12 $1.51
226200 2021-07-13 $15.74 United States 1 0.30 lbs $3.75 $3.69 $0.06
226201 2021-07-13 $43.51 USPSFirstClass 2 0.25 lbs $10.07 $3.57 $6.50
226203 2021-07-13 $12.59 First-Class Mail Stamped Letter 1 0.04 lbs $3.80 $3.49 $0.31
226204 2021-07-13 $15.07 Priority Mail 2-Day 3 0.60 lbs $9.10 $8.52 $0.58
226206 2021-07-13 $30.90 United States 10 3.75 lbs $11.00 $10.89 $0.11
226207 2021-07-13 $16.99 Priority Mail 2-Day 1 0.50 lbs $9.10 $8.52 $0.58
226208 2021-07-14 $12.43 USPSFirstClass 1 0.20 lbs $4.54 $3.06 $1.48
226209 2021-07-13 $41.79 Priority Mail 3-Day 1 0.85 lbs $8.80 $8.00 $0.80
226211 2021-07-14 $27.29 United States 16 0.28 lbs $3.75 $3.35 $0.40
226213 2021-05-29 $61.16 Priority Mail 3-Day 2 2.88 lbs $10.03 $18.96 $-8.93
226221 2021-07-14 $77.45 First-Class Package Service 2 0.87 lbs $6.47 $8.24 $-1.77
226223 2021-07-15 $12.48 USPSFirstClass 1 0.04 lbs $4.69 $3.35 $1.34
226224 2021-07-14 $43.79 Priority Mail 2-Day 1 0.70 lbs $8.80 $7.90 $0.90
226227 2021-07-14 $125.12 United States 9 4.03 lbs $11.50 $12.13 $-0.63
226229 2021-07-14 $8.94 United States 3 0.11 lbs $3.75 $3.06 $0.69
226230 2021-07-15 $78.39 Priority Mail 3-Day Medium Flat Rate Box 11 2.37 lbs $15.50 $12.13 $3.37
226231 2021-07-15 $9.49 United States 1 0.05 lbs $3.75 $3.01 $0.74
226232 2021-07-15 $17.84 USPSFirstClass 1 0.05 lbs $4.85 $3.12 $1.73
226235 2021-07-15 $30.39 Priority Mail 2-Day 1 0.80 lbs $9.90 $8.80 $1.10
226236 2021-01-31 $104.86 Priority Mail 3-Day Medium Flat Rate Box 4 3.60 lbs $5.00 $8.00 $-3.00
226237 2021-07-15 $13.36 USPSFirstClass 1 0.07 lbs $4.87 $3.49 $1.38
226238 2021-07-15 $9.49 USPSFirstClass 1 0.07 lbs $4.50 $3.22 $1.28
226239 2021-07-15 $17.84 USPSFirstClass 1 0.05 lbs $4.85 $3.12 $1.73
226240 2021-07-15 $17.99 First-Class Mail Stamped Letter 1 0.15 lbs $4.00 $3.69 $0.31
226242 2021-07-15 $19.91 Priority Mail 2-Day Small Flat Rate Box 4 0.79 lbs $8.45 $8.52 $-0.07
226249 2021-07-15 $57.09 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.55 lbs $9.10 $8.25 $0.85
226255 2021-07-15 $12.04 United States 1 0.20 lbs $4.15 $3.58 $0.57
226260 2021-07-16 $17.57 USPSFirstClass 5 0.05 lbs $5.12 $3.22 $1.90
226261 2021-07-16 $11.01 USPSFirstClass 1 0.20 lbs $4.57 $3.22 $1.35
226262 2020-12-23 $133.17 Direct Link International 4 7.55 lbs $68.71 $62.69 $6.02
226264 2021-07-16 $178.69 Priority Mail 2-Day 1 14.30 lbs $19.70 $14.82 $4.88
226266 2021-07-16 $84.25 Priority Mail 2-Day 4 1.94 lbs $11.10 $9.64 $1.46
226267 2021-07-16 $46.09 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.10 lbs $9.10 $7.90 $1.20
226269 2021-07-16 $121.49 Ground 3 0.38 lbs $19.03 $14.33 $4.70
226271 2021-07-17 $12.38 USPSFirstClass 1 0.06 lbs $4.59 $3.12 $1.47
226272 2021-07-17 $6.54 USPSFirstClass 1 0.03 lbs $4.55 $3.49 $1.06
226274 2021-07-16 $40.04 United States 1 0.70 lbs $5.25 $5.81 $-0.56
226277 2021-07-16 $37.26 Priority Mail 2-Day Flat Rate Envelope 1 1.30 lbs $7.95 $7.90 $0.05
226280 2021-07-17 $12.63 USPSFirstClass 1 0.06 lbs $4.84 $3.49 $1.35
226281 2021-07-17 $28.09 USPSFirstClass 1 0.32 lbs $6.10 $3.58 $2.52
226284 2021-07-17 $111.49 Priority Mail 3-Day Flat Rate Envelope 1 3.90 lbs $8.50 $8.00 $0.50
226285 2021-07-17 $53.66 Priority Mail 2-Day 2 1.05 lbs $8.55 $8.00 $0.55
226286 2021-07-17 $15.49 Priority Mail 3-Day 1 0.09 lbs $8.50 $7.90 $0.60
226288 2021-07-17 $40.94 Priority Mail 2-Day Flat Rate Envelope 1 0.50 lbs $7.95 $7.90 $0.05
226289 2021-07-17 $27.08 Priority Mail 2-Day 2 0.31 lbs $8.80 $7.90 $0.90
226290 2021-07-18 $43.14 USPSFirstClass 4 1.36 lbs $11.98 $8.24 $3.74
226291 2021-07-18 $6.76 USPSFirstClass 1 0.01 lbs $4.27 $3.06 $1.21
226292 2021-07-17 $43.44 Priority Mail 3-Day Small Flat Rate Box 1 0.70 lbs $8.45 $7.90 $0.55
226293 2021-07-17 $20.59 Priority Mail 2-Day 1 0.40 lbs $9.10 $7.90 $1.20
226296 2021-07-17 $38.59 Ground 2 0.24 lbs $24.41 $19.71 $4.70
226297 2021-07-18 $16.38 First-Class Package Service 1 0.25 lbs $4.89 $3.35 $1.54
226298 2021-07-18 $9.30 USPSFirstClass 1 0.10 lbs $4.40 $3.06 $1.34
226299 2021-07-18 $31.44 USPSFirstClass 1 0.35 lbs $6.45 $4.68 $1.77
226300 2021-07-18 $20.49 Priority Mail 2-Day 1 0.95 lbs $8.50 $7.88 $0.62
226301 2021-07-19 $12.48 USPSFirstClass 1 0.04 lbs $4.69 $3.35 $1.34
226302 2021-07-19 $31.19 USPSFirstClass 1 0.35 lbs $6.20 $4.20 $2.00
226303 2021-07-18 $39.06 Priority Mail 2-Day 8 0.47 lbs $8.80 $7.90 $0.90
226304 2021-07-19 $45.83 Priority Mail 3-Day 2 0.90 lbs $8.25 $8.00 $0.25
226305 2021-07-19 $19.94 USPSFirstClass 1 0.03 lbs $4.95 $3.12 $1.83
226306 2021-07-19 $31.86 Priority Mail 2-Day 4 0.40 lbs $9.90 $7.90 $2.00
226308 2021-07-19 $10.96 USPSFirstClass 1 0.20 lbs $4.52 $3.12 $1.40
226310 2021-07-19 $39.93 Priority Mail 3-Day Flat Rate Envelope 2 1.72 lbs $7.95 $7.90 $0.05
226311 2021-07-19 $20.24 Priority Mail 2-Day 1 0.95 lbs $8.25 $7.67 $0.58
226316 2021-07-19 $28.99 Priority Mail 3-Day 1 0.95 lbs $8.50 $7.88 $0.62
226318 2021-07-19 $56.99 Priority Mail 2-Day Small Flat Rate Box 1 1.45 lbs $9.00 $7.90 $1.10
226320 2021-07-20 $18.75 First-Class Package Service 2 0.34 lbs $4.77 $4.20 $0.57
226321 2021-07-20 $13.57 USPSFirstClass 3 0.06 lbs $4.60 $3.49 $1.11
226322 2021-07-20 $9.58 USPSFirstClass 1 0.04 lbs $4.69 $3.49 $1.20
226323 2021-07-20 $12.69 USPSFirstClass 1 0.05 lbs $4.70 $3.35 $1.35
226324 2021-07-20 $42.89 Priority Mail 3-Day 1 1.20 lbs $10.10 $7.90 $2.20
226325 2021-07-20 $13.93 United States 3 0.10 lbs $4.15 $3.01 $1.14
226326 2021-07-20 $24.76 USPSFirstClass 4 0.16 lbs $8.80 $7.88 $0.92
226327 2021-07-20 $38.65 USPSFirstClass 1 0.13 lbs $5.89 $3.58 $2.31
226328 2021-07-20 $12.63 USPSFirstClass 1 0.03 lbs $4.84 $3.49 $1.35
226331 2021-07-20 $35.94 Priority Mail 2-Day Flat Rate Envelope 1 0.40 lbs $7.95 $7.90 $0.05
226332 2021-07-20 $37.68 Priority Mail 2-Day 12 2.40 lbs $13.80 $12.70 $1.10
226333 2021-07-20 $25.10 USPSFirstClass 3 0.30 lbs $5.33 $5.66 $-0.33
226334 2021-07-20 $32.02 First-Class Package Service 1 0.70 lbs $6.22 $5.27 $0.95
226335 2021-07-20 $48.29 United States 2 0.50 lbs $4.75 $4.53 $0.22
226336 2021-07-20 $31.36 Priority Mail 2-Day 14 2.00 lbs $13.50 $10.89 $2.61
226337 2021-07-21 $29.35 USPSFirstClass 1 0.15 lbs $5.40 $3.12 $2.28
226339 2021-07-21 $151.82 First-Class Package International Service 7 1.00 lbs $34.89 $26.84 $8.05
226340 2021-07-21 $10.74 USPSFirstClass 1 0.04 lbs $4.75 $3.49 $1.26
226341 2021-07-21 $279.37 Priority Mail 2-Day Medium Flat Rate Box 3 6.35 lbs $15.40 $13.75 $1.65
226342 2021-07-21 $19.08 Priority Mail 2-Day 2 0.18 lbs $9.10 $8.00 $1.10
226344 2021-07-21 $19.73 First-Class Package Service 5 0.25 lbs $4.78 $3.58 $1.20
226347 2021-07-21 $25.80 First-Class Mail Stamped Letter 2 0.12 lbs $4.00 $3.12 $0.88
226349 2021-07-22 $38.24 Priority Mail 3-Day Medium Flat Rate Box 6 2.08 lbs $15.50 $13.75 $1.75
226357 2021-07-22 $56.74 United States 1 1.50 lbs $8.75 $7.90 $0.85
226359 2021-07-22 $54.23 Priority Mail 3-Day Flat Rate Envelope 4 1.20 lbs $7.95 $8.45 $-0.50
226363 2021-07-23 $52.29 USPSPriority 3 3.45 lbs $14.82 $9.01 $5.81
226364 2021-07-22 $39.41 Priority Mail 3-Day 1 1.25 lbs $10.10 $7.90 $2.20
226366 2021-07-23 $43.78 Ground 3 0.17 lbs $20.11 $15.41 $4.70
226371 2021-07-23 $12.23 United States 2 0.65 lbs $5.25 $5.81 $-0.56
226372 2021-07-23 $46.19 Priority Mail 2-Day 1 1.20 lbs $15.20 $7.90 $7.30
226373 2021-07-23 $35.63 First-Class Package Service 3 0.50 lbs $5.32 $4.12 $1.20
226378 2021-07-24 $21.29 Priority Mail 2-Day 1 0.95 lbs $8.80 $8.34 $0.46
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56