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
215667 2020-09-16 $14.17 USPSFirstClass 1 0.05 lbs $4.40 $2.84 $1.56
215669 2020-09-16 $36.86 Priority Mail 2-Day 3 1.09 lbs $12.04 $7.75 $4.29
215670 2020-09-16 $14.05 First-Class Package Service 1 0.30 lbs $3.84 $3.39 $0.45
215671 2020-09-16 $13.97 First-Class Package Service 1 0.30 lbs $3.76 $3.31 $0.45
215672 2020-09-16 $25.23 Priority Mail 2-Day 4 0.28 lbs $9.27 $8.42 $0.85
215673 2020-09-16 $12.32 USPSFirstClass 1 0.50 lbs $5.31 $3.67 $1.64
215674 2020-09-16 $48.82 USPSFirstClass 1 0.45 lbs $6.95 $4.46 $2.49
215675 2020-09-16 $36.67 Priority Mail 2-Day Flat Rate Envelope 13 0.44 lbs $8.00 $7.65 $0.35
215676 2020-09-16 $21.49 Priority Mail 2-Day Flat Rate Envelope 1 1.00 lbs $8.00 $7.65 $0.35
215679 2020-09-17 $24.57 USPSFirstClass 2 0.10 lbs $4.37 $2.78 $1.59
215680 2020-09-17 $13.14 USPSFirstClass 2 0.10 lbs $4.20 $2.93 $1.27
215681 2020-09-17 $10.13 USPSFirstClass 1 0.05 lbs $4.24 $3.31 $0.93
215684 2020-09-17 $21.82 Priority Mail 2-Day 2 0.72 lbs $10.84 $9.99 $0.85
215687 2020-09-17 $26.79 Priority Mail 3-Day Flat Rate Envelope 1 0.25 lbs $8.00 $7.65 $0.35
215688 2020-09-17 $13.93 USPSFirstClass 1 0.18 lbs $4.62 $3.67 $0.95
215689 2020-09-17 $23.52 Priority Mail 2-Day 2 0.60 lbs $14.34 $8.15 $6.19
215690 2020-09-17 $13.63 First-Class Package Service 1 0.30 lbs $3.84 $4.18 $-0.34
215691 2020-09-17 $30.49 Priority Mail 2-Day Flat Rate Envelope 1 1.15 lbs $8.00 $7.65 $0.35
215692 2020-09-17 $4.43 First-Class Package Service 2 0.02 lbs $3.19 $2.74 $0.45
215693 2020-09-17 $23.70 Priority Mail 2-Day Padded Flat Rate Envelope 2 3.00 lbs $8.60 $7.75 $0.85
215696 2020-09-17 $8.75 First-Class Package Service 1 0.20 lbs $3.76 $3.31 $0.45
215697 2020-09-17 $37.68 Priority Mail 2-Day Small Flat Rate Box 1 0.94 lbs $8.50 $7.65 $0.85
215698 2020-09-17 $5.68 First-Class Package Service 5 0.05 lbs $3.23 $2.78 $0.45
215699 2020-09-17 $15.55 First-Class Package Service 1 0.30 lbs $3.76 $3.31 $0.45
215701 2020-09-17 $13.41 First-Class Package Service 9 0.10 lbs $3.50 $3.05 $0.45
215703 2020-09-17 $8.34 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $3.05 $0.30
215705 2020-09-17 $29.47 USPSFirstClass 1 0.20 lbs $5.02 $5.12 $-0.10
215707 2020-09-17 $13.61 First-Class Package Service 4 0.41 lbs $4.25 $4.00 $0.25
215708 2020-09-17 $13.88 USPSFirstClass 3 0.10 lbs $4.05 $2.78 $1.27
215710 2020-09-18 $9.31 USPSFirstClass 1 0.45 lbs $5.08 $4.32 $0.76
215711 2020-09-18 $20.67 USPSFirstClass 2 0.51 lbs $9.30 $7.75 $1.55
215713 2020-09-17 $83.61 Priority Mail 2-Day 4 2.65 lbs $14.34 $11.13 $3.21
215714 2020-09-17 $29.64 First-Class Package Service 5 0.47 lbs $4.53 $3.31 $1.22
215715 2020-09-18 $21.42 USPSFirstClass 2 0.20 lbs $4.34 $3.31 $1.03
215716 2020-09-18 $17.82 USPSFirstClass 1 0.16 lbs $4.61 $3.39 $1.22
215720 2020-09-18 $54.93 Priority Mail 2-Day 1 1.30 lbs $12.04 $11.19 $0.85
215721 2020-09-18 $14.91 USPSFirstClass 2 0.10 lbs $4.24 $2.93 $1.31
215722 2020-09-18 $143.13 Priority Mail 2-Day Large Flat Rate Box 2 13.00 lbs $19.15 $18.30 $0.85
215723 2020-09-18 $13.05 USPSFirstClass 3 0.18 lbs $4.04 $3.25 $0.79
215725 2020-09-18 $13.16 USPSFirstClass 1 0.05 lbs $4.34 $2.84 $1.50
215726 2020-09-18 $15.76 First-Class Package Service 1 0.30 lbs $3.97 $3.52 $0.45
215727 2020-09-18 $12.40 USPSFirstClass 1 0.10 lbs $4.28 $2.78 $1.50
215728 2020-09-18 $84.01 USPSFirstClass 9 1.65 lbs $28.63 $8.92 $19.71
215729 2020-09-18 $70.24 Priority Mail 2-Day Medium Flat Rate Box 1 6.50 lbs $14.45 $13.20 $1.25
215730 2020-09-18 $23.38 USPSPriority 1 1.00 lbs $8.68 $8.21 $0.47
215732 2020-09-18 $28.04 USPSFirstClass 4 0.12 lbs $8.48 $3.39 $5.09
215733 2020-09-18 $15.63 First-Class Package Service 1 0.30 lbs $3.84 $3.39 $0.45
215734 2020-09-18 $8.94 USPSFirstClass 1 0.50 lbs $4.95 $4.08 $0.87
215735 2020-09-18 $56.95 Priority Mail 2-Day 1 1.00 lbs $9.61 $8.76 $0.85
215736 2020-09-18 $31.38 Priority Mail 3-Day 1 1.10 lbs $11.39 $11.13 $0.26
215737 2020-09-18 $18.23 USPSFirstClass 1 0.40 lbs $5.57 $3.67 $1.90
215738 2020-09-18 $37.46 Priority Mail 2-Day Flat Rate Envelope 1 1.00 lbs $8.00 $7.65 $0.35
215739 2020-09-18 $5.49 First-Class Mail Stamped Letter 1 0.13 lbs $3.50 $3.05 $0.45
215740 2020-09-18 $9.78 USPSFirstClass 1 0.25 lbs $4.45 $3.67 $0.78
215741 2020-09-18 $18.26 USPSFirstClass 1 0.35 lbs $5.29 $3.25 $2.04
215744 2020-09-18 $47.59 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.44 lbs $8.60 $7.75 $0.85
215745 2020-09-18 $26.39 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $8.00 $7.75 $0.25
215747 2020-09-19 $20.57 USPSFirstClass 2 0.40 lbs $5.24 $5.54 $-0.30
215748 2020-09-19 $5.91 USPSFirstClass 1 0.03 lbs $4.07 $2.93 $1.14
215749 2020-09-19 $32.84 USPSFirstClass 3 1.16 lbs $13.28 $8.12 $5.16
215750 2020-09-18 $36.79 Priority Mail 2-Day Flat Rate Envelope 1 1.10 lbs $8.00 $7.75 $0.25
215751 2020-09-19 $12.33 USPSFirstClass 1 0.35 lbs $5.22 $3.52 $1.70
215752 2020-09-18 $275.62 Priority Mail 3-Day 1 14.40 lbs $21.63 $22.34 $-0.71
215753 2020-09-18 $20.28 First-Class Package Service 2 0.25 lbs $3.70 $3.25 $0.45
215755 2020-09-19 $183.89 Priority Mail 3-Day 6 7.45 lbs $19.45 $26.96 $-7.51
215756 2020-09-19 $24.80 First-Class Package Service 5 0.59 lbs $4.45 $5.12 $-0.67
215757 2020-09-19 $7.03 USPSFirstClass 1 0.25 lbs $4.17 $3.52 $0.65
215758 2020-09-19 $37.53 Priority Mail 2-Day 1 2.30 lbs $14.34 $13.49 $0.85
215760 2020-09-19 $6.78 First-Class Package Service 1 0.05 lbs $3.29 $2.84 $0.45
215761 2020-09-19 $10.36 USPSFirstClass 2 0.07 lbs $3.95 $2.74 $1.21
215763 2020-09-19 $8.33 USPSFirstClass 1 0.05 lbs $4.10 $2.78 $1.32
215764 2020-09-19 $80.84 Priority Mail 2-Day 2 4.03 lbs $21.86 $21.01 $0.85
215765 2020-09-19 $18.71 Priority Mail 3-Day Small Flat Rate Box 1 0.30 lbs $8.50 $7.65 $0.85
215766 2020-09-19 $9.90 USPSFirstClass 1 0.10 lbs $4.21 $2.84 $1.37
215768 2020-09-19 $104.32 Priority Mail 3-Day Flat Rate Envelope 4 1.80 lbs $8.00 $7.65 $0.35
215770 2020-09-19 $19.34 First-Class Package Service 7 0.22 lbs $3.97 $3.05 $0.92
215771 2020-09-19 $12.80 USPSFirstClass 1 0.31 lbs $5.14 $3.39 $1.75
215772 2020-09-19 $28.80 Priority Mail 2-Day 4 1.75 lbs $14.34 $10.54 $3.80
215773 2020-09-19 $35.00 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $8.50 $7.65 $0.85
215774 2020-09-20 $7.14 USPSFirstClass 1 0.07 lbs $4.14 $2.93 $1.21
215775 2020-09-19 $22.45 First-Class Package Service 1 0.35 lbs $3.70 $3.25 $0.45
215777 2020-09-20 $11.04 USPSFirstClass 1 0.05 lbs $4.29 $2.93 $1.36
215778 2020-09-20 $12.13 USPSFirstClass 1 0.05 lbs $4.34 $2.84 $1.50
215780 2020-09-20 $10.25 USPSFirstClass 1 0.25 lbs $4.45 $3.67 $0.78
215783 2020-09-20 $7.28 First-Class Package Service 1 0.05 lbs $3.29 $2.84 $0.45
215784 2020-09-20 $12.56 First-Class Package Service 7 0.08 lbs $3.63 $3.18 $0.45
215785 2020-09-20 $14.39 USPSFirstClass 1 0.05 lbs $4.40 $3.31 $1.09
215786 2020-09-20 $7.18 First-Class Mail Stamped Letter 2 0.04 lbs $3.20 $2.78 $0.42
215788 2020-09-20 $39.25 Priority Mail 3-Day Padded Flat Rate Envelope 2 1.18 lbs $8.60 $7.65 $0.95
215789 2020-09-20 $8.13 USPSFirstClass 1 0.03 lbs $4.17 $2.93 $1.24
215790 2020-09-20 $15.81 USPSFirstClass 2 0.15 lbs $4.17 $2.78 $1.39
215792 2020-09-20 $13.70 First-Class Package Service 3 0.15 lbs $3.23 $2.78 $0.45
215793 2020-09-20 $16.76 First-Class Package Service 1 0.57 lbs $4.77 $4.32 $0.45
215794 2020-09-20 $63.81 USPSPriority 1 5.00 lbs $16.65 $11.75 $4.90
215795 2020-09-20 $18.53 First-Class Mail Stamped Letter 1 0.15 lbs $3.50 $3.25 $0.25
215796 2020-09-20 $5.59 First-Class Package Service 4 0.04 lbs $3.63 $3.18 $0.45
215797 2020-09-20 $3.69 First-Class Mail Stamped Letter 1 0.01 lbs $3.20 $2.84 $0.36
215798 2020-09-20 $5.69 First-Class Mail Stamped Letter 1 0.01 lbs $3.20 $2.93 $0.27
215799 2020-09-20 $38.12 Priority Mail 3-Day 2 1.55 lbs $8.97 $8.21 $0.76
215801 2020-09-20 $24.66 First-Class Package Service 1 0.80 lbs $5.37 $5.12 $0.25
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56