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
234457 2025-09-22 $27.90 USPS Ground Advantage 1 0.35 lbs $5.91 $5.34 $0.57
234458 2025-09-22 $46.93 USPS Ground Advantage 1 1.30 lbs $9.54 $8.24 $1.30
234459 2025-09-24 $17.14 USPS Ground Advantage 2 0.04 lbs $6.10 $4.80 $1.30
234460 2025-09-23 $18.11 USPS Ground Advantage 2 0.73 lbs $6.83 $4.28 $2.55
234461 2025-09-25 $30.32 USPS Ground Advantage 1 0.35 lbs $6.19 $4.89 $1.30
234462 2025-09-24 $31.38 USPS Ground Advantage 4 3.32 lbs $14.58 $13.28 $1.30
234463 2025-09-24 $21.77 USPS Ground Advantage 1 0.55 lbs $6.99 $7.06 $-0.07
234464 2025-09-24 $9.51 USPS Ground Advantage 1 0.05 lbs $5.95 $4.65 $1.30
234465 2025-09-25 $40.49 USPS Ground Advantage 3 0.85 lbs $17.97 $6.53 $11.44
234466 2025-09-25 $18.90 USPS Ground Advantage 1 0.35 lbs $5.90 $4.89 $1.01
234467 2025-09-25 $24.93 USPS Ground Advantage 1 0.15 lbs $6.27 $4.57 $1.70
234468 2025-09-26 $24.46 USPS Ground Advantage 1 0.45 lbs $6.19 $4.89 $1.30
234469 2025-09-26 $49.61 USPS Ground Advantage 1 0.73 lbs $7.54 $7.35 $0.19
234470 2025-09-29 $42.29 USPS Ground Advantage 1 1.10 lbs $7.45 $6.15 $1.30
234471 2025-09-28 $15.83 USPS Ground Advantage 3 0.09 lbs $5.54 $4.24 $1.30
234472 2025-09-28 $18.78 USPS Ground Advantage 1 0.35 lbs $6.04 $4.74 $1.30
234473 2025-09-28 $9.04 USPS Ground Advantage 1 0.15 lbs $5.65 $4.35 $1.30
234474 2025-09-27 $30.24 USPS Ground Advantage 1 0.80 lbs $7.98 $6.88 $1.10
234475 2025-09-27 $33.74 USPS Ground Advantage 1 0.90 lbs $0.00 $7.06 $-7.06
234476 2025-09-27 $14.59 USPS Ground Advantage 1 0.08 lbs $6.10 $4.80 $1.30
234477 2025-09-27 $82.34 USPS Ground Advantage 1 5.69 lbs $13.50 $12.20 $1.30
234478 2025-09-26 $11.34 USPS Ground Advantage 1 0.05 lbs $5.65 $4.35 $1.30
234479 2025-09-26 $19.34 USPS Ground Advantage 1 0.31 lbs $5.75 $4.52 $1.23
234480 2025-09-29 $11.04 USPS Ground Advantage 1 0.10 lbs $5.95 $4.65 $1.30
234481 2025-09-29 $15.09 USPS Ground Advantage 2 0.80 lbs $8.65 $9.35 $-0.70
234482 2025-09-29 $27.97 USPS Ground Advantage 1 0.90 lbs $8.40 $7.10 $1.30
234483 2025-10-01 $46.57 USPS Ground Advantage 1 1.10 lbs $9.09 $7.79 $1.30
234484 2025-10-01 $19.94 USPS Ground Advantage 3 1.35 lbs $11.30 $9.39 $1.91
234485 2025-10-01 $17.14 USPS Ground Advantage 1 0.09 lbs $5.65 $4.35 $1.30
234486 2025-10-01 $54.01 USPS Ground Advantage 1 2.54 lbs $8.12 $7.36 $0.76
234487 2025-10-01 $15.88 USPS Ground Advantage 1 0.05 lbs $5.69 $4.86 $0.83
234488 2025-10-02 $9.93 USPS Ground Advantage 1 0.05 lbs $5.69 $4.39 $1.30
234489 2025-10-03 $12.05 USPS Ground Advantage 1 0.08 lbs $5.71 $4.41 $1.30
234490 2025-10-03 $9.66 USPS Ground Advantage 1 0.45 lbs $18.81 $6.25 $12.56
234491 2025-10-03 $35.65 USPS Ground Advantage 2 1.16 lbs $8.97 $7.67 $1.30
234492 2025-10-03 $8.56 USPS Ground Advantage 1 0.02 lbs $6.10 $5.15 $0.95
234493 2025-10-03 $11.85 USPS Ground Advantage 1 0.36 lbs $6.50 $5.20 $1.30
234494 2025-10-03 $46.48 USPS Ground Advantage 1 0.75 lbs $7.13 $8.54 $-1.41
234495 2025-10-02 $15.49 USPS Ground Advantage 1 0.05 lbs $5.71 $4.41 $1.30
234496 2025-10-02 $10.94 USPS Ground Advantage 1 0.05 lbs $5.82 $4.52 $1.30
234497 2025-10-04 $190.46 USPS Ground Advantage 1 2.19 lbs $11.97 $10.32 $1.65
234498 2025-10-04 $39.46 USPS Ground Advantage 1 0.58 lbs $7.34 $6.59 $0.75
234499 2025-10-03 $8.47 USPS Ground Advantage 1 0.19 lbs $6.10 $5.37 $0.73
234500 2025-10-03 $41.23 USPS Ground Advantage 1 1.20 lbs $9.03 $8.08 $0.95
234501 2025-10-03 $9.37 USPS Ground Advantage 1 0.40 lbs $6.32 $5.37 $0.95
234502 2025-10-03 $56.92 USPS Ground Advantage 1 1.20 lbs $8.89 $8.14 $0.75
234503 2025-10-04 $11.34 USPS Ground Advantage 1 0.05 lbs $5.65 $4.65 $1.00
234505 2025-10-04 $11.85 USPS Ground Advantage 1 0.10 lbs $5.65 $4.65 $1.00
234506 2025-10-04 $9.66 USPS Ground Advantage 2 0.85 lbs $12.54 $10.12 $2.42
234508 2025-10-04 $12.89 USPS Ground Advantage 1 0.05 lbs $6.10 $5.15 $0.95
234509 2025-10-06 $16.46 USPS Ground Advantage 2 0.90 lbs $10.36 $10.00 $0.36
234511 2025-10-05 $10.41 USPS Ground Advantage 1 0.05 lbs $6.17 $4.87 $1.30
234513 2025-10-06 $11.81 USPS Ground Advantage 1 0.05 lbs $5.95 $4.65 $1.30
234514 2025-10-07 $107.96 USPS Ground Advantage 2 2.50 lbs $19.78 $8.59 $11.19
234515 2025-10-08 $22.81 USPS Ground Advantage 1 0.45 lbs $6.62 $5.32 $1.30
234516 2025-10-08 $21.56 USPS Ground Advantage 1 0.30 lbs $6.67 $5.37 $1.30
234517 2025-10-07 $12.19 USPS Ground Advantage 3 0.18 lbs $6.22 $4.92 $1.30
234518 2025-10-09 $16.24 USPS Ground Advantage 1 0.08 lbs $6.25 $4.95 $1.30
234519 2025-10-08 $17.56 USPS Ground Advantage 1 0.10 lbs $6.05 $4.95 $1.10
234525 2025-10-13 $9.15 USPS Ground Advantage 1 0.03 lbs $6.25 $4.95 $1.30
234526 2025-10-11 $11.55 USPS Ground Advantage 1 0.10 lbs $6.10 $4.80 $1.30
234527 2025-10-10 $17.34 USPS Ground Advantage 1 0.04 lbs $6.45 $5.15 $1.30
234528 2025-10-10 $24.52 USPS Ground Advantage 1 0.55 lbs $7.13 $7.17 $-0.04
234529 2025-10-12 $47.24 USPS Ground Parcel or Priority Mail 1 2.20 lbs $12.25 $18.40 $-6.15
234530 2025-10-13 $62.09 USPS Ground Advantage 1 11.50 lbs $14.84 $13.54 $1.30
234531 2025-10-13 $32.29 USPS Ground Advantage 5 0.25 lbs $6.54 $5.24 $1.30
234532 2025-10-13 $28.41 USPS Ground Advantage 6 0.42 lbs $7.35 $6.05 $1.30
234533 2025-10-14 $11.71 USPS Ground Advantage 2 0.04 lbs $6.45 $5.15 $1.30
234534 2025-10-15 $18.45 USPS Ground Advantage 2 0.90 lbs $11.07 $9.77 $1.30
234535 2025-10-14 $13.97 USPS Ground Advantage 1 0.05 lbs $6.06 $4.76 $1.30
234536 2025-10-14 $10.55 USPS Ground Advantage 1 0.05 lbs $6.17 $4.87 $1.30
234537 2025-10-14 $14.29 USPS Ground Advantage 2 0.10 lbs $5.95 $4.65 $1.30
234538 2025-10-14 $13.43 USPS Ground Advantage 3 0.57 lbs $7.16 $5.09 $2.07
234539 2025-10-14 $14.51 USPS Ground Advantage 2 0.16 lbs $6.17 $5.15 $1.02
234540 2025-10-16 $10.62 USPS Ground Advantage 1 0.10 lbs $5.88 $4.58 $1.30
234541 2025-10-16 $10.52 USPS Ground Advantage 1 0.05 lbs $5.95 $4.65 $1.30
234542 2025-10-16 $80.39 USPS Ground Advantage 20 9.00 lbs $20.79 $23.96 $-3.17
234544 2025-10-19 $29.85 USPS Ground Advantage 1 0.38 lbs $6.45 $6.05 $0.40
234545 2025-10-19 $54.35 USPS Ground Advantage 2 0.50 lbs $13.01 $7.41 $5.60
234546 2025-10-17 $20.28 USPS Ground Advantage 3 0.09 lbs $6.06 $4.76 $1.30
234547 2025-10-21 $16.61 USPS Ground Advantage 1 0.05 lbs $6.06 $4.76 $1.30
234548 2025-10-20 $12.06 USPS Ground Advantage 1 0.05 lbs $6.17 $4.87 $1.30
234550 2025-10-20 $234.23 USPS Ground Advantage 2 6.90 lbs $16.89 $28.32 $-11.43
234552 2025-10-22 $123.10 USPS Ground Advantage 5 0.90 lbs $8.75 $8.59 $0.16
234553 2025-10-21 $18.94 USPS Ground Advantage 1 1.69 lbs $10.15 $5.15 $5.00
234554 2025-10-21 $10.08 USPS Ground Advantage 1 0.40 lbs $6.39 $5.86 $0.53
234555 2025-10-21 $15.77 USPS Ground Advantage 1 0.05 lbs $6.10 $4.80 $1.30
234556 2025-10-21 $11.90 USPS Ground Advantage 1 0.06 lbs $6.45 $5.15 $1.30
234557 2025-10-22 $13.01 USPS Ground Advantage 1 0.20 lbs $5.99 $5.16 $0.83
234558 2025-10-22 $33.67 USPS Ground Advantage 1 0.62 lbs $7.28 $7.17 $0.11
234559 2025-10-23 $12.56 USPS Ground Advantage 1 0.05 lbs $6.50 $5.20 $1.30
234560 2025-10-23 $40.28 USPS Ground Advantage 1 0.10 lbs $5.97 $4.87 $1.10
234561 2025-10-22 $11.52 USPS Ground Advantage 1 0.05 lbs $6.25 $4.95 $1.30
234562 2025-10-22 $30.74 USPS Ground Advantage 1 0.60 lbs $7.69 $7.41 $0.28
234563 2025-10-22 $15.70 UPS Ground 1 0.08 lbs $11.21 $8.70 $2.51
234564 2025-10-22 $46.77 USPS Ground Advantage 1 2.40 lbs $16.86 $15.56 $1.30
234567 2025-10-23 $14.62 USPS Ground Parcel or Priority Mail 1 0.10 lbs $0.00 $4.92 $-4.92
234568 2025-10-23 $12.23 USPS Ground Advantage 1 0.04 lbs $6.17 $4.87 $1.30
234569 2025-10-23 $28.10 USPS Ground Advantage 1 0.60 lbs $7.35 $6.99 $0.36
234572 2025-10-25 $36.59 USPS Ground Advantage 5 0.21 lbs $17.46 $4.88 $12.58
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56