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
234346 2025-08-15 $13.04 USPS Ground Parcel or Priority Mail 1 0.25 lbs $0.00 $4.47 $-4.47
234347 2025-08-15 $38.85 USPS Ground Advantage 1 0.13 lbs $5.71 $4.74 $0.97
234348 2025-08-15 $11.28 USPS Ground Advantage 1 0.27 lbs $6.19 $4.89 $1.30
234349 2025-08-16 $8.65 USPS Ground Advantage 1 0.05 lbs $5.75 $4.45 $1.30
234350 2025-08-16 $18.57 USPS Ground Advantage 1 0.30 lbs $5.91 $4.61 $1.30
234351 2025-08-16 $16.24 USPS Ground Advantage 1 1.69 lbs $7.75 $6.29 $1.46
234352 2025-08-16 $13.46 USPS Ground Advantage 1 0.04 lbs $5.82 $4.52 $1.30
234353 2025-08-16 $10.06 USPS Ground Advantage 1 0.05 lbs $5.82 $4.52 $1.30
234354 2025-08-16 $15.10 USPS Ground Advantage 1 0.30 lbs $6.10 $5.70 $0.40
234355 2025-08-17 $33.29 USPS Ground Advantage 1 0.85 lbs $8.65 $6.24 $2.41
234356 2025-08-17 $11.76 USPS Ground Advantage 1 0.10 lbs $5.82 $4.52 $1.30
234357 2025-08-18 $15.27 USPS Ground Advantage 1 0.30 lbs $6.27 $5.90 $0.37
234358 2025-08-18 $14.72 USPS Ground Advantage 3 0.07 lbs $5.87 $4.57 $1.30
234359 2025-08-19 $12.30 USPS Ground Advantage 1 0.36 lbs $6.36 $5.06 $1.30
234360 2025-08-21 $21.43 USPS Ground Advantage 1 0.55 lbs $6.65 $6.64 $0.01
234361 2025-08-21 $19.55 USPS Ground Advantage 3 0.43 lbs $17.25 $4.91 $12.34
234364 2025-08-24 $77.51 Priority Mail 14 3.92 lbs $26.41 $23.03 $3.38
234365 2025-08-25 $44.64 USPS Ground Advantage 1 1.30 lbs $0.00 $8.83 $-8.83
234366 2025-08-24 $10.93 USPS Ground Advantage 1 0.10 lbs $5.58 $4.28 $1.30
234367 2025-08-23 $27.21 USPS Ground Advantage 1 0.40 lbs $6.19 $5.83 $0.36
234368 2025-08-25 $19.32 USPS Ground Advantage 2 0.10 lbs $11.54 $4.57 $6.97
234369 2025-08-26 $54.06 USPS Ground Advantage 1 0.73 lbs $7.32 $7.10 $0.22
234370 2025-08-26 $11.93 USPS Ground Advantage 2 0.41 lbs $11.64 $4.69 $6.95
234372 2025-08-26 $10.91 USPS Ground Advantage 1 0.10 lbs $5.82 $4.52 $1.30
234373 2025-08-28 $20.80 USPS Ground Advantage 2 0.10 lbs $5.82 $4.52 $1.30
234374 2025-08-28 $11.13 USPS Ground Advantage 2 0.12 lbs $5.95 $5.06 $0.89
234375 2025-08-28 $14.25 USPS Ground Advantage 1 0.30 lbs $5.84 $4.89 $0.95
234377 2025-08-31 $49.52 USPS Ground Advantage 1 1.30 lbs $9.03 $7.73 $1.30
234378 2025-08-31 $15.29 USPS Ground Advantage 1 0.10 lbs $5.51 $4.41 $1.10
234379 2025-08-30 $11.04 USPS Ground Advantage 1 0.05 lbs $5.95 $4.65 $1.30
234380 2025-08-30 $13.19 USPS Ground Advantage 2 0.24 lbs $5.71 $4.74 $0.97
234381 2025-08-30 $10.99 USPS Ground Advantage 1 0.05 lbs $5.90 $4.60 $1.30
234382 2025-08-30 $24.54 USPS Ground Advantage 1 0.45 lbs $6.27 $5.90 $0.37
234383 2025-08-30 $11.04 USPS Ground Advantage 1 0.04 lbs $5.95 $4.65 $1.30
234384 2025-09-01 $23.72 USPS Ground Advantage 1 0.25 lbs $5.75 $4.91 $0.84
234385 2025-09-01 $15.31 USPS Ground Advantage 4 0.08 lbs $5.75 $4.91 $0.84
234386 2025-09-02 $59.73 USPS Ground Advantage 2 0.26 lbs $6.21 $5.71 $0.50
234387 2025-09-02 $14.05 USPS Ground Advantage 1 0.04 lbs $6.15 $4.85 $1.30
234389 2025-09-03 $22.85 USPS Ground Advantage 1 0.35 lbs $5.86 $5.71 $0.15
234390 2025-09-04 $76.56 USPS Ground Advantage 16 5.60 lbs $35.88 $10.30 $25.58
234392 2025-09-05 $32.50 USPS Ground Advantage 8 2.00 lbs $14.58 $11.71 $2.87
234393 2025-09-05 $9.75 USPS Ground Advantage 1 0.45 lbs $6.19 $5.83 $0.36
234394 2025-09-04 $119.95 USPS Ground Advantage 1 1.35 lbs $10.65 $9.35 $1.30
234395 2025-09-04 $11.96 USPS Ground Advantage 1 0.05 lbs $6.10 $4.80 $1.30
234396 2025-09-04 $19.32 USPS Ground Advantage 2 0.15 lbs $11.54 $4.57 $6.97
234397 2025-09-04 $21.33 USPS Ground Advantage 1 0.45 lbs $6.04 $5.51 $0.53
234399 2025-09-04 $40.47 USPS Ground Advantage 1 1.20 lbs $9.54 $8.24 $1.30
234400 2025-09-05 $30.58 USPS Ground Advantage 1 0.85 lbs $8.40 $7.10 $1.30
234401 2025-09-06 $81.82 USPS Ground Advantage 1 5.30 lbs $12.98 $11.68 $1.30
234402 2025-09-06 $14.00 USPS Ground Advantage 1 0.05 lbs $6.10 $4.80 $1.30
234403 2025-09-06 $10.40 USPS Ground Advantage 1 0.03 lbs $5.90 $4.60 $1.30
234404 2025-09-06 $18.61 USPS Ground Advantage 1 0.20 lbs $5.87 $4.97 $0.90
234405 2025-09-05 $9.93 USPS Ground Advantage 1 0.05 lbs $5.69 $4.39 $1.30
234406 2025-09-05 $29.61 USPS Ground Advantage 8 2.00 lbs $10.57 $7.67 $2.90
234407 2025-09-07 $9.61 USPS Ground Advantage 1 0.05 lbs $5.54 $4.24 $1.30
234408 2025-09-07 $43.89 USPS Ground Advantage 1 1.05 lbs $9.09 $7.79 $1.30
234409 2025-09-07 $12.26 USPS Ground Advantage 1 0.36 lbs $6.32 $4.80 $1.52
234410 2025-09-06 $56.12 USPS Ground Advantage 4 0.30 lbs $22.16 $4.61 $17.55
234411 2025-09-06 $24.80 USPS Ground Advantage 1 5.44 lbs $8.23 $6.93 $1.30
234412 2025-09-08 $11.81 USPS Ground Advantage 1 0.05 lbs $5.87 $4.57 $1.30
234413 2025-09-08 $11.94 USPS Ground Advantage 1 0.31 lbs $5.91 $4.61 $1.30
234415 2025-09-09 $10.91 USPS Ground Advantage 1 0.07 lbs $5.90 $4.60 $1.30
234416 2025-09-09 $39.71 USPS Ground Advantage 1 1.10 lbs $7.59 $4.35 $3.24
234417 2025-09-10 $74.27 USPS Ground Advantage 16 6.40 lbs $28.51 $10.88 $17.63
234418 2025-09-12 $19.51 USPS Ground Advantage 1 0.31 lbs $5.92 $4.97 $0.95
234419 2025-09-11 $17.64 USPS Priority Mail 1 0.05 lbs $10.42 $9.12 $1.30
234420 2025-09-11 $18.44 USPS Ground Advantage 1 0.22 lbs $5.70 $4.89 $0.81
234421 2025-09-11 $12.64 USPS Ground Advantage 1 0.64 lbs $7.12 $5.02 $2.10
234422 2025-09-12 $23.11 USPS Ground Advantage 1 0.15 lbs $6.32 $4.80 $1.52
234423 2025-09-13 $24.45 USPS Ground Advantage 9 0.27 lbs $6.36 $4.69 $1.67
234424 2025-09-13 $137.27 USPS Ground Advantage 45 11.25 lbs $30.17 $25.76 $4.41
234425 2025-09-13 $30.12 USPS Ground Advantage 1 0.85 lbs $7.94 $6.64 $1.30
234426 2025-09-12 $21.03 USPS Ground Advantage 2 0.09 lbs $5.75 $4.45 $1.30
234427 2025-09-13 $14.67 USPS Ground Advantage 2 0.10 lbs $5.65 $4.35 $1.30
234428 2025-09-13 $8.87 USPS Ground Advantage 1 0.04 lbs $5.82 $4.52 $1.30
234429 2025-09-15 $11.55 USPS Ground Advantage 1 0.05 lbs $5.69 $4.39 $1.30
234430 2025-09-15 $12.64 USPS Ground Advantage 1 0.10 lbs $6.10 $4.80 $1.30
234431 2025-09-15 $25.43 USPS Ground Advantage 3 0.60 lbs $10.28 $6.64 $3.64
234432 2025-09-15 $12.84 USPS Ground Advantage 1 0.09 lbs $5.71 $4.41 $1.30
234433 2025-09-15 $12.95 USPS Ground Advantage 1 0.08 lbs $5.90 $4.60 $1.30
234434 2025-09-15 $19.32 USPS Ground Advantage 1 0.30 lbs $6.32 $5.02 $1.30
234435 2025-09-17 $13.99 USPS Ground Advantage 1 0.15 lbs $5.75 $4.45 $1.30
234436 2025-09-17 $45.82 USPS Ground Advantage 1 1.10 lbs $10.13 $8.83 $1.30
234437 2025-09-18 $9.27 USPS Ground Advantage 1 0.05 lbs $5.71 $4.41 $1.30
234438 2025-09-17 $230.76 USPS Ground Advantage 1 19.62 lbs $35.27 $36.15 $-0.88
234439 2025-09-17 $12.70 USPS Ground Advantage 1 0.15 lbs $5.65 $4.35 $1.30
234440 2025-09-17 $17.02 USPS Ground Advantage 8 0.36 lbs $23.60 $4.89 $18.71
234444 2025-09-18 $122.66 USPS Ground Advantage 1 3.45 lbs $12.17 $11.07 $1.10
234445 2025-09-18 $9.27 USPS Ground Advantage 1 0.05 lbs $5.71 $4.41 $1.30
234446 2025-09-19 $34.27 USPS Ground Advantage 1 0.13 lbs $6.10 $4.80 $1.30
234447 2025-09-18 $11.93 USPS Ground Advantage 1 0.36 lbs $5.99 $4.35 $1.64
234448 2025-09-22 $23.22 USPS Ground Advantage 2 0.08 lbs $11.50 $4.45 $7.05
234449 2025-09-21 $22.13 USPS Ground Advantage 4 1.60 lbs $10.61 $9.31 $1.30
234450 2025-09-21 $20.76 UPS Ground 1 0.60 lbs $10.57 $5.83 $4.74
234451 2025-09-21 $39.24 USPS Ground Advantage 1 0.58 lbs $7.12 $6.02 $1.10
234452 2025-09-21 $23.14 USPS Ground Advantage 1 0.40 lbs $6.32 $6.02 $0.30
234453 2025-09-20 $11.23 USPS Ground Advantage 1 0.01 lbs $5.71 $4.41 $1.30
234454 2025-09-20 $97.12 USPS Ground Advantage 1 3.20 lbs $12.98 $11.68 $1.30
234455 2025-09-19 $28.76 USPS Ground Advantage 1 0.32 lbs $6.16 $4.86 $1.30
234456 2025-09-19 $11.73 USPS Ground Advantage 1 0.05 lbs $5.87 $4.57 $1.30
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56