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
233559 2024-12-17 $16.69 USPS Ground Advantage 1 0.70 lbs $5.50 $6.40 $-0.90
233560 2024-12-18 $20.66 USPS Ground Advantage 1 0.25 lbs $5.41 $4.82 $0.59
233562 2024-12-17 $17.72 USPS Ground Advantage 1 0.20 lbs $5.49 $4.90 $0.59
233563 2024-12-17 $11.55 USPS Ground Advantage 1 0.15 lbs $5.32 $4.37 $0.95
233564 2024-12-17 $12.33 USPS Ground Advantage 1 0.03 lbs $5.21 $4.26 $0.95
233565 2024-12-18 $18.73 USPS Ground Advantage 1 0.55 lbs $6.21 $6.23 $-0.02
233566 2024-12-18 $16.70 USPS Ground Advantage 1 0.30 lbs $5.98 $5.03 $0.95
233567 2024-12-18 $36.99 USPS Ground Advantage 1 1.00 lbs $8.56 $7.61 $0.95
233568 2024-12-18 $23.89 USPS Ground Advantage 1 0.35 lbs $5.50 $4.55 $0.95
233569 2024-12-18 $21.48 USPS Ground Advantage 1 0.15 lbs $5.49 $4.54 $0.95
233570 2024-12-18 $53.29 USPS Ground Advantage 1 1.27 lbs $9.30 $8.35 $0.95
233571 2024-12-18 $36.40 USPS Ground Advantage 1 0.13 lbs $5.21 $4.38 $0.83
233572 2024-12-19 $26.91 USPS Ground Advantage 2 0.38 lbs $5.33 $4.38 $0.95
233573 2024-12-20 $45.92 USPS Ground Advantage 1 1.30 lbs $9.77 $8.82 $0.95
233574 2024-12-19 $9.73 USPS Ground Advantage 1 0.45 lbs $5.06 $4.94 $0.12
233575 2024-12-19 $15.72 USPS Ground Advantage 1 0.10 lbs $5.33 $4.58 $0.75
233576 2024-12-20 $12.51 USPS Ground Advantage 1 0.06 lbs $5.32 $4.37 $0.95
233577 2024-12-20 $45.76 USPS Ground Advantage 1 1.23 lbs $19.37 $18.42 $0.95
233578 2024-12-20 $9.97 USPS Ground Advantage 1 0.23 lbs $5.66 $4.63 $1.03
233579 2024-12-20 $282.19 FedEx Ground or FedEx Home Delivery 1 21.06 lbs $26.20 $29.03 $-2.83
233580 2024-12-20 $45.30 USPS Ground Advantage 1 1.30 lbs $9.31 $8.36 $0.95
233581 2024-12-20 $9.34 USPS Ground Advantage 1 0.03 lbs $5.11 $4.16 $0.95
233582 2024-12-21 $15.90 USPS Ground Advantage 1 0.19 lbs $5.11 $4.47 $0.64
233584 2024-12-23 $9.83 USPS Ground Advantage 2 0.04 lbs $5.53 $4.58 $0.95
233585 2024-12-23 $19.01 USPS Ground Advantage 2 0.12 lbs $5.49 $4.54 $0.95
233586 2024-12-22 $17.89 USPS Ground Advantage 1 0.30 lbs $5.42 $4.47 $0.95
233587 2024-12-22 $15.81 USPS Ground Advantage 1 0.19 lbs $5.02 $4.43 $0.59
233588 2024-12-22 $65.64 USPS Ground Advantage 1 0.56 lbs $6.21 $5.26 $0.95
233589 2024-12-22 $45.93 USPS Ground Advantage 1 0.73 lbs $6.34 $6.40 $-0.06
233590 2024-12-22 $10.72 USPS Ground Advantage 1 0.03 lbs $5.53 $4.58 $0.95
233591 2024-12-22 $8.44 USPS Ground Advantage 1 0.05 lbs $5.41 $4.46 $0.95
233592 2024-12-22 $19.60 USPS Ground Advantage 1 0.05 lbs $5.21 $4.26 $0.95
233593 2024-12-22 $20.27 USPS Ground Advantage 2 0.08 lbs $10.64 $4.37 $6.27
233594 2024-12-22 $294.11 USPS Ground Advantage 1 21.06 lbs $38.12 $35.02 $3.10
233595 2024-12-21 $12.68 USPS Ground Advantage 1 0.04 lbs $5.49 $4.54 $0.95
233596 2024-12-21 $17.89 USPS Ground Advantage 1 0.30 lbs $5.42 $4.47 $0.95
233597 2024-12-23 $13.12 USPS Ground Advantage 1 0.19 lbs $5.53 $4.58 $0.95
233598 2024-12-23 $53.50 USPS Ground Advantage 1 1.25 lbs $9.51 $8.56 $0.95
233599 2024-12-24 $14.31 USPS Ground Advantage 2 0.36 lbs $4.55 $5.39 $-0.84
233600 2024-12-24 $25.62 USPS Ground Advantage 1 0.40 lbs $5.63 $5.37 $0.26
233601 2024-12-23 $26.62 USPS Priority Mail 2 1.00 lbs $12.24 $10.77 $1.47
233602 2024-12-23 $27.04 USPS Ground Advantage 1 0.19 lbs $5.53 $4.62 $0.91
233603 2024-12-23 $46.75 USPS Ground Advantage 3 1.64 lbs $11.29 $11.24 $0.05
233604 2024-12-25 $45.48 USPS Ground Advantage 2 4.60 lbs $13.68 $13.37 $0.31
233605 2024-12-24 $52.85 USPS Ground Advantage 1 1.25 lbs $8.86 $5.39 $3.47
233606 2024-12-24 $34.11 USPS Ground Advantage 10 0.30 lbs $6.21 $4.47 $1.74
233607 2024-12-24 $31.70 USPS Ground Advantage 3 0.45 lbs $16.63 $5.56 $11.07
233608 2024-12-25 $18.21 USPS Ground Advantage 1 0.30 lbs $5.50 $4.55 $0.95
233609 2024-12-25 $18.84 USPS Ground Advantage 1 0.15 lbs $5.41 $4.46 $0.95
233610 2024-12-25 $28.21 USPS Ground Advantage 1 0.35 lbs $5.50 $4.55 $0.95
233611 2024-12-25 $25.65 USPS Ground Advantage 1 0.03 lbs $5.66 $4.71 $0.95
233612 2024-12-25 $11.95 USPS Ground Advantage 1 0.07 lbs $5.32 $4.37 $0.95
233613 2024-12-25 $22.04 USPS Ground Advantage 1 0.40 lbs $5.73 $5.50 $0.23
233614 2024-12-25 $9.00 USPS Ground Advantage 1 0.03 lbs $5.41 $4.46 $0.95
233615 2024-12-26 $24.21 USPS Ground Parcel or Priority Mail 2 0.38 lbs $17.26 $5.56 $11.70
233616 2024-12-26 $20.20 USPS Ground Advantage 1 0.19 lbs $5.21 $4.38 $0.83
233617 2024-12-27 $11.37 USPS Ground Advantage 1 0.18 lbs $4.58 $4.62 $-0.04
233618 2024-12-27 $21.29 USPS Ground Parcel or Priority Mail 1 0.05 lbs $8.63 $4.46 $4.17
233619 2024-12-27 $23.75 USPS Ground Advantage 4 1.10 lbs $10.99 $4.62 $6.37
233620 2024-12-27 $18.20 USPS Ground Advantage 1 0.07 lbs $5.41 $4.46 $0.95
233621 2024-12-28 $13.70 USPS Ground Advantage 1 0.05 lbs $5.21 $4.26 $0.95
233622 2024-12-27 $11.37 USPS Ground Advantage 1 0.18 lbs $4.58 $4.58 $0.00
233623 2024-12-28 $28.13 USPS Ground Advantage 3 0.12 lbs $5.21 $4.26 $0.95
233624 2024-12-28 $15.28 USPS Ground Advantage 3 0.03 lbs $5.11 $4.16 $0.95
233625 2024-12-29 $14.47 USPS Ground Advantage 2 0.12 lbs $5.49 $4.54 $0.95
233627 2024-12-29 $43.95 USPS Ground Advantage 1 0.70 lbs $5.96 $6.63 $-0.67
233628 2024-12-29 $13.25 USPS Ground Advantage 2 0.01 lbs $5.53 $4.58 $0.95
233629 2024-12-28 $61.72 USPS Ground Advantage 1 1.31 lbs $6.73 $5.98 $0.75
233630 2024-12-28 $23.73 USPS Ground Advantage 1 1.00 lbs $9.24 $9.37 $-0.13
233631 2024-12-31 $43.95 USPS Ground Advantage 1 0.70 lbs $5.96 $6.56 $-0.60
233632 2024-12-30 $116.55 USPS Ground Advantage 1 1.35 lbs $8.56 $7.61 $0.95
233633 2024-12-30 $8.39 USPS Ground Advantage 1 0.05 lbs $5.32 $4.37 $0.95
233634 2024-12-30 $33.77 USPS Ground Advantage 1 0.35 lbs $5.38 $4.43 $0.95
233635 2024-12-30 $20.40 USPS Ground Advantage 1 0.19 lbs $5.41 $4.47 $0.94
233636 2024-12-30 $12.32 USPS Ground Advantage 2 0.10 lbs $5.32 $4.37 $0.95
233637 2024-12-31 $44.31 USPS Ground Advantage 1 0.13 lbs $5.32 $4.43 $0.89
233638 2024-12-31 $49.75 Priority Mail Medium Flat Rate Box 14 2.63 lbs $18.50 $16.04 $2.46
233640 2024-12-31 $12.30 USPS Ground Advantage 1 0.05 lbs $5.41 $4.46 $0.95
233641 2024-12-31 $17.04 USPS Ground Advantage 2 0.36 lbs $4.82 $5.67 $-0.85
233642 2025-01-01 $15.66 USPS Ground Advantage 2 0.05 lbs $10.82 $4.46 $6.36
233644 2025-01-02 $18.51 USPS Ground Advantage 1 0.19 lbs $5.02 $4.43 $0.59
233645 2025-01-02 $15.20 USPS Ground Advantage 1 0.20 lbs $5.21 $4.38 $0.83
233647 2025-01-02 $13.21 USPS Ground Advantage 1 0.06 lbs $5.32 $4.37 $0.95
233648 2025-01-02 $48.72 USPS Ground Advantage 6 2.30 lbs $23.98 $10.69 $13.29
233649 2025-01-03 $14.61 USPS Ground Advantage 1 0.05 lbs $5.32 $4.37 $0.95
233650 2025-01-03 $20.52 USPS Ground Advantage 1 0.05 lbs $5.53 $4.58 $0.95
233651 2025-01-03 $14.90 USPS Ground Advantage 1 0.03 lbs $5.21 $4.26 $0.95
233654 2025-01-06 $12.04 USPS Ground Advantage 1 0.25 lbs $5.66 $5.97 $-0.31
233655 2025-01-06 $20.07 USPS Ground Advantage 1 0.35 lbs $5.77 $5.67 $0.10
233656 2025-01-05 $144.95 USPS Ground Advantage 1 6.50 lbs $9.96 $12.33 $-2.37
233657 2025-01-05 $10.60 USPS Ground Advantage 1 0.18 lbs $5.41 $4.46 $0.95
233658 2025-01-05 $43.76 USPS Ground Advantage 2 1.43 lbs $9.58 $8.30 $1.28
233660 2025-01-04 $15.16 USPS Ground Advantage 3 0.01 lbs $5.32 $4.37 $0.95
233661 2025-01-04 $29.90 USPS Ground Advantage 8 0.04 lbs $5.26 $4.16 $1.10
233662 2025-01-04 $11.24 USPS Ground Advantage 1 0.35 lbs $5.42 $5.26 $0.16
233663 2025-01-04 $13.42 USPS Ground Advantage 1 0.06 lbs $5.53 $4.58 $0.95
233664 2025-01-04 $27.81 USPS Ground Advantage 1 0.03 lbs $5.32 $4.37 $0.95
233665 2025-01-07 $48.45 USPS Ground Advantage 1 1.17 lbs $8.86 $7.91 $0.95
233666 2025-01-07 $47.51 USPS Ground Advantage 1 1.17 lbs $7.92 $6.97 $0.95
233667 2025-01-06 $21.96 USPS Ground Advantage 2 0.09 lbs $10.64 $4.37 $6.27
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56