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
208630 2019-12-01 $67.93 Priority Mail 2-Day 3 1.10 lbs $13.95 $10.53 $3.42
208631 2019-12-01 $51.26 Priority Mail 2-Day 1 1.70 lbs $12.65 $9.70 $2.95
208632 2019-12-01 $17.45 Priority Mail 3-Day 1 0.95 lbs $8.46 $7.28 $1.18
208635 2019-12-01 $4.71 First-Class Package Service 4 0.04 lbs $3.75 $2.70 $1.05
208636 2019-12-01 $37.93 Priority Mail 2-Day Flat Rate Envelope 2 1.40 lbs $7.80 $7.50 $0.30
208637 2019-12-01 $28.95 Priority Mail 3-Day 1 0.95 lbs $10.55 $9.70 $0.85
208639 2019-12-01 $29.16 Priority Mail 3-Day Flat Rate Envelope 2 1.60 lbs $7.80 $7.55 $0.25
208640 2019-12-01 $8.59 First-Class Package Service 3 0.48 lbs $5.11 $4.06 $1.05
208641 2019-12-01 $12.34 First-Class Package Service 1 0.28 lbs $4.33 $3.28 $1.05
208642 2019-12-01 $19.63 First-Class Package Service 2 0.50 lbs $5.38 $5.53 $-0.15
208643 2019-12-01 $43.51 Priority Mail 3-Day 6 2.00 lbs $9.19 $8.34 $0.85
208644 2019-12-01 $13.45 First-Class Package Service 3 0.30 lbs $4.54 $3.49 $1.05
208645 2019-12-01 $20.64 Priority Mail 2-Day 4 0.65 lbs $9.35 $8.50 $0.85
208647 2019-12-01 $24.36 First-Class Package Service 3 0.63 lbs $5.38 $5.53 $-0.15
208648 2019-12-01 $42.63 Priority Mail 2-Day 1 1.20 lbs $10.55 $9.70 $0.85
208649 2019-12-01 $6.15 First-Class Package Service 10 0.10 lbs $3.75 $2.70 $1.05
208651 2019-12-01 $46.13 Priority Mail 2-Day 6 1.31 lbs $10.55 $9.70 $0.85
208652 2019-12-01 $143.42 Priority Mail International Small Flat Rate Box 2 3.61 lbs $36.65 $35.80 $0.85
208656 2019-12-01 $149.94 Priority Mail 2-Day 2 4.40 lbs $22.16 $10.64 $11.52
208658 2019-12-01 $33.29 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $8.35 $7.50 $0.85
208659 2019-12-01 $153.56 Priority Mail 2-Day 7 5.80 lbs $18.78 $19.86 $-1.08
208660 2019-12-01 $8.11 First-Class Package Service 4 0.11 lbs $3.71 $2.66 $1.05
208661 2019-12-02 $25.43 Priority Mail 2-Day Flat Rate Envelope 17 1.73 lbs $7.80 $7.50 $0.30
208662 2019-12-02 $7.68 First-Class Package Service 1 0.05 lbs $3.89 $2.93 $0.96
208664 2019-12-02 $21.57 Priority Mail 2-Day Medium Flat Rate Box 8 3.00 lbs $13.65 $10.55 $3.10
208665 2019-12-02 $30.07 First-Class Package Service 12 0.59 lbs $5.11 $4.06 $1.05
208667 2019-12-02 $20.37 First-Class Package Service 4 0.44 lbs $4.54 $4.19 $0.35
208669 2019-12-02 $20.33 First-Class Package Service 1 0.25 lbs $4.91 $5.24 $-0.33
208670 2019-12-02 $50.17 First-Class Package International Service 1 1.20 lbs $24.64 $16.39 $8.25
208671 2019-12-02 $13.38 Priority Mail 3-Day 3 1.05 lbs $8.73 $7.88 $0.85
208672 2019-12-02 $10.19 First-Class Package Service 1 0.10 lbs $4.14 $3.09 $1.05
208674 2019-12-02 $17.43 First-Class Package Service 2 0.35 lbs $4.23 $3.82 $0.41
208676 2019-12-02 $19.12 Priority Mail 2-Day 4 1.30 lbs $11.08 $10.23 $0.85
208679 2019-12-02 $12.92 First-Class Package Service 1 0.16 lbs $3.81 $3.28 $0.53
208681 2019-12-02 $62.71 Priority Mail 2-Day 24 7.43 lbs $20.27 $23.46 $-3.19
208682 2019-12-02 $18.93 First-Class Package Service 9 0.56 lbs $5.97 $3.96 $2.01
208684 2019-12-03 $766.23 Ground 20 45.82 lbs $53.46 $35.00 $18.46
208686 2019-12-03 $23.04 Priority Mail 2-Day Flat Rate Envelope 6 1.14 lbs $7.80 $7.50 $0.30
208689 2019-12-03 $6.00 First-Class Package Service 1 0.19 lbs $4.01 $2.96 $1.05
208690 2019-12-03 $47.35 Priority Mail 3-Day Small Flat Rate Box 2 1.60 lbs $8.35 $7.50 $0.85
208691 2019-12-04 $57.81 Priority Mail 3-Day Padded Flat Rate Envelope 1 2.25 lbs $8.40 $7.50 $0.90
208692 2019-12-04 $16.28 First-Class Package Service 3 0.23 lbs $4.41 $2.84 $1.57
208693 2019-12-04 $50.16 Ground 11 6.69 lbs $19.47 $23.61 $-4.14
208701 2019-12-04 $25.38 Priority Mail 3-Day Flat Rate Envelope 2 0.52 lbs $7.80 $7.50 $0.30
208702 2019-12-04 $8.43 First-Class Package Service 1 0.35 lbs $4.54 $4.19 $0.35
208704 2019-12-04 $77.94 Priority Mail 2-Day 18 2.55 lbs $13.95 $12.80 $1.15
208708 2019-12-04 $11.47 First-Class Package Service 4 0.05 lbs $4.01 $2.96 $1.05
208710 2019-12-04 $42.53 Priority Mail 2-Day 2 1.50 lbs $13.95 $10.23 $3.72
208711 2019-12-04 $22.72 First-Class Package Service 7 0.83 lbs $6.29 $5.24 $1.05
208712 2019-12-04 $20.14 First-Class Package Service 3 0.46 lbs $4.27 $3.88 $0.39
208714 2019-12-05 $27.66 Priority Mail 3-Day 5 1.44 lbs $10.11 $8.50 $1.61
208715 2019-12-05 $18.96 First-Class Package Service 5 0.17 lbs $4.01 $2.96 $1.05
208719 2019-12-05 $22.56 First-Class Package Service 1 0.30 lbs $4.27 $3.88 $0.39
208721 2019-12-05 $19.59 Priority Mail 2-Day Flat Rate Envelope 1 0.30 lbs $7.80 $7.50 $0.30
208722 2019-12-05 $10.88 First-Class Package Service 1 0.10 lbs $3.89 $2.84 $1.05
208725 2019-12-05 $27.59 First-Class Package Service 1 0.48 lbs $5.99 $3.82 $2.17
208726 2019-12-05 $126.59 Priority Mail 2-Day 9 2.45 lbs $8.46 $7.65 $0.81
208728 2019-12-06 $140.48 Direct Link International 10 2.45 lbs $36.98 $29.88 $7.10
208731 2019-12-06 $43.64 Priority Mail 3-Day Flat Rate Envelope 2 1.45 lbs $7.80 $7.55 $0.25
208735 2019-12-06 $11.49 First-Class Package Service 15 0.15 lbs $4.14 $3.09 $1.05
208737 2019-12-06 $5.13 First-Class Package Service 1 0.02 lbs $4.14 $3.09 $1.05
208738 2019-12-06 $19.12 First-Class Package Service 2 0.73 lbs $6.09 $5.24 $0.85
208739 2019-12-06 $10.30 First-Class Package Service 1 0.13 lbs $3.71 $3.18 $0.53
208741 2019-12-06 $30.22 Priority Mail 2-Day 16 4.00 lbs $11.18 $10.33 $0.85
208744 2019-12-07 $10.29 First-Class Package Service 2 0.08 lbs $3.81 $3.28 $0.53
208746 2019-12-07 $11.78 First-Class Package Service 1 0.20 lbs $3.89 $3.36 $0.53
208748 2019-12-07 $30.02 First-Class Package International Service 1 0.30 lbs $18.23 $16.39 $1.84
208749 2019-12-07 $13.81 First-Class Package Service 20 0.20 lbs $4.01 $2.96 $1.05
208750 2019-12-07 $216.11 Ground 1 14.05 lbs $41.31 $23.78 $17.53
208752 2019-12-08 $36.34 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $8.35 $7.50 $0.85
208753 2019-12-08 $14.56 First-Class Package Service 5 0.20 lbs $3.81 $3.28 $0.53
208754 2019-12-08 $28.89 First-Class Package Service 2 0.45 lbs $4.41 $4.06 $0.35
208755 2019-12-08 $131.32 Priority Mail 2-Day 2 3.45 lbs $14.54 $9.50 $5.04
208756 2019-12-08 $47.19 Priority Mail 2-Day 5 1.92 lbs $12.65 $11.80 $0.85
208757 2019-12-08 $15.40 First-Class Package Service 1 0.30 lbs $4.41 $4.06 $0.35
208758 2019-12-08 $94.96 Priority Mail 2-Day Medium Flat Rate Box 8 3.08 lbs $14.05 $10.00 $4.05
208760 2019-12-08 $14.52 First-Class Package Service 2 0.14 lbs $4.54 $3.49 $1.05
208761 2019-12-08 $221.91 Priority Mail 2-Day 1 14.05 lbs $28.92 $26.74 $2.18
208762 2019-12-09 $14.77 First-Class Package Service 1 0.05 lbs $4.27 $3.22 $1.05
208763 2019-12-05 $21.23 First-Class Package Service 1 0.40 lbs $0.00 $3.82 $-3.82
208765 2019-12-09 $18.97 First-Class Package Service 1 0.08 lbs $3.81 $3.28 $0.53
208766 2019-12-09 $10.72 First-Class Package Service 3 0.04 lbs $3.75 $2.70 $1.05
208768 2019-12-10 $30.53 Priority Mail 3-Day 5 1.75 lbs $11.08 $10.55 $0.53
208769 2019-12-10 $36.59 Priority Mail 3-Day Flat Rate Envelope 1 1.10 lbs $7.80 $7.50 $0.30
208770 2019-12-10 $51.34 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.35 $7.50 $0.85
208771 2019-12-10 $8.19 First-Class Package Service 2 0.07 lbs $3.81 $3.28 $0.53
208772 2019-12-10 $21.39 First-Class Package Service 1 0.60 lbs $4.73 $5.02 $-0.29
208774 2019-12-10 $6.80 First-Class Package Service 1 0.05 lbs $3.81 $2.76 $1.05
208775 2019-12-10 $48.58 Priority Mail 3-Day Flat Rate Envelope 2 1.60 lbs $7.80 $7.50 $0.30
208778 2019-12-10 $8.64 First-Class Package Service 1 0.15 lbs $3.75 $3.22 $0.53
208780 2019-12-10 $7.80 First-Class Package Service 1 0.08 lbs $3.81 $2.76 $1.05
208781 2019-12-11 $9.87 First-Class Package Service 2 0.11 lbs $3.89 $2.84 $1.05
208782 2019-12-11 $27.71 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $7.80 $7.55 $0.25
208784 2019-12-11 $54.44 Priority Mail 3-Day Flat Rate Envelope 2 1.78 lbs $7.80 $7.50 $0.30
208787 2019-12-12 $11.70 First-Class Package Service 1 0.20 lbs $3.81 $3.28 $0.53
208788 2019-12-12 $26.19 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $7.80 $7.55 $0.25
208789 2019-12-12 $16.06 First-Class Package Service 5 0.50 lbs $5.11 $2.84 $2.27
208790 2019-12-12 $14.38 First-Class Package Service 6 0.16 lbs $3.81 $2.76 $1.05
208791 2019-12-12 $33.77 Priority Mail 2-Day 8 0.62 lbs $9.35 $8.50 $0.85
208797 2019-12-13 $26.19 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $7.80 $7.55 $0.25
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56