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.

21025 matching order(s)

Order ID ▲DateOrder TotalShipping Method# ProductsTotal WeightShipping ChargedShipping PaidProfit
216684 2020-10-19 $86.18 Priority Mail 2-Day Flat Rate Envelope 2 2.65 lbs $8.40 $7.75 $0.65
216685 2020-10-19 $15.36 First-Class Package Service 1 0.30 lbs $4.37 $3.92 $0.45
216686 2020-10-19 $19.71 First-Class Package Service 1 0.35 lbs $4.22 $4.32 $-0.10
216687 2020-10-19 $26.79 Priority Mail 3-Day Flat Rate Envelope 1 0.85 lbs $8.40 $15.40 $-7.00
216689 2020-10-19 $23.97 First-Class Package Service 1 0.60 lbs $4.68 $5.65 $-0.97
216691 2020-10-19 $16.18 First-Class Package Service 2 0.35 lbs $3.50 $3.30 $0.20
216692 2020-10-19 $17.16 First-Class Package Service 1 0.20 lbs $4.37 $3.92 $0.45
216694 2020-10-19 $26.79 Priority Mail 3-Day Flat Rate Envelope 1 0.85 lbs $8.40 $8.15 $0.25
216696 2020-10-19 $38.69 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $8.90 $8.05 $0.85
216698 2020-10-19 $11.29 First-Class Mail Stamped Letter 1 0.15 lbs $3.50 $3.64 $-0.14
216706 2020-10-19 $18.95 First-Class Package Service 10 0.23 lbs $4.01 $3.09 $0.92
216711 2020-10-19 $14.79 First-Class Package Service 2 0.24 lbs $4.01 $3.56 $0.45
216713 2020-10-19 $13.46 Priority Mail 2-Day 3 2.05 lbs $10.79 $7.65 $3.14
216715 2020-10-19 $48.15 Priority Mail 2-Day Padded Flat Rate Envelope 1 2.00 lbs $9.00 $8.15 $0.85
216718 2020-10-19 $37.34 Priority Mail 3-Day Flat Rate Envelope 6 1.00 lbs $8.40 $8.05 $0.35
216719 2020-10-19 $77.26 Ground 8 1.45 lbs $21.34 $16.67 $4.67
216720 2020-10-19 $187.90 Ground 2 10.80 lbs $31.68 $24.40 $7.28
216723 2020-10-20 $17.58 USPSFirstClass 1 0.60 lbs $6.01 $5.65 $0.36
216724 2020-10-20 $7.41 USPSFirstClass 1 0.05 lbs $4.34 $3.43 $0.91
216725 2020-10-20 $7.85 USPSFirstClass 1 0.03 lbs $4.14 $3.09 $1.05
216726 2020-10-20 $14.25 USPSFirstClass 1 0.05 lbs $4.50 $3.30 $1.20
216727 2020-10-20 $9.87 USPSFirstClass 1 0.23 lbs $4.25 $3.64 $0.61
216728 2020-10-20 $13.81 USPSFirstClass 4 0.60 lbs $5.85 $5.95 $-0.10
216731 2020-10-20 $9.14 First-Class Mail Stamped Letter 1 0.15 lbs $3.65 $3.43 $0.22
216732 2020-10-20 $228.91 Ground 1 21.00 lbs $35.72 $31.58 $4.14
216734 2020-10-20 $33.86 Priority Mail 3-Day Flat Rate Envelope 1 1.10 lbs $8.40 $8.05 $0.35
216735 2020-10-20 $14.68 First-Class Package Service 1 0.37 lbs $4.09 $4.43 $-0.34
216736 2020-10-20 $26.79 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $8.40 $8.15 $0.25
216737 2020-10-20 $37.19 Priority Mail 2-Day Flat Rate Envelope 1 1.05 lbs $8.40 $8.05 $0.35
216741 2020-10-20 $7.16 First-Class Mail Stamped Letter 4 0.04 lbs $3.20 $3.09 $0.11
216742 2020-10-20 $22.30 First-Class Package Service 1 0.30 lbs $4.01 $4.08 $-0.07
216745 2020-10-20 $15.35 Priority Mail 2-Day Flat Rate Envelope 5 0.06 lbs $8.40 $8.05 $0.35
216746 2020-10-20 $6.93 First-Class Package Service 2 0.20 lbs $3.95 $3.03 $0.92
216747 2020-10-20 $24.39 Ground 1 0.30 lbs $18.40 $21.53 $-3.13
216750 2020-10-20 $57.98 Priority Mail 2-Day 2 1.55 lbs $13.40 $10.39 $3.01
216751 2020-10-20 $22.36 Priority Mail 2-Day Flat Rate Envelope 4 0.20 lbs $8.40 $3.18 $5.22
216753 2020-10-20 $80.49 Priority Mail 1-Day 10 1.26 lbs $8.89 $8.04 $0.85
216754 2020-10-20 $98.38 Priority Mail 2-Day Flat Rate Envelope 2 2.21 lbs $8.40 $8.15 $0.25
216757 2020-10-21 $12.48 USPSFirstClass 1 0.19 lbs $4.35 $3.18 $1.17
216758 2020-10-21 $9.46 USPSFirstClass 1 0.04 lbs $4.14 $3.03 $1.11
216759 2020-10-21 $14.47 USPSFirstClass 1 0.10 lbs $4.37 $3.03 $1.34
216760 2020-10-21 $9.30 USPSFirstClass 1 0.05 lbs $4.44 $3.43 $1.01
216761 2020-10-21 $21.79 USPSFirstClass 1 0.16 lbs $4.70 $3.50 $1.20
216762 2020-10-21 $10.93 USPSFirstClass 1 0.10 lbs $4.21 $3.50 $0.71
216764 2020-10-21 $69.47 Priority Mail 2-Day Flat Rate Envelope 3 1.88 lbs $8.40 $7.65 $0.75
216765 2020-10-21 $59.80 First-Class Package Service 2 0.90 lbs $5.82 $5.37 $0.45
216769 2020-10-21 $33.58 First-Class Package Service 1 0.45 lbs $4.63 $4.18 $0.45
216771 2020-10-21 $23.19 First-Class Package Service 1 0.45 lbs $4.70 $4.25 $0.45
216773 2020-10-21 $25.32 First-Class Package Service - Retail 1 0.65 lbs $7.35 $5.95 $1.40
216774 2020-10-21 $19.98 First-Class Package Service 3 0.28 lbs $4.01 $3.56 $0.45
216777 2020-10-21 $142.38 Priority Mail 2-Day Padded Flat Rate Envelope 4 4.98 lbs $9.00 $8.15 $0.85
216778 2020-10-21 $12.32 First-Class Mail Stamped Letter 3 0.06 lbs $3.35 $3.18 $0.17
216783 2020-10-21 $24.08 Priority Mail 2-Day 3 0.51 lbs $8.81 $7.96 $0.85
216790 2020-10-21 $3.69 First-Class Mail Stamped Letter 1 0.01 lbs $3.20 $3.30 $-0.10
216795 2020-10-21 $25.33 First-Class Package Service 1 0.65 lbs $6.04 $5.79 $0.25
216796 2020-10-21 $37.39 Priority Mail 2-Day Flat Rate Envelope 1 1.00 lbs $8.40 $8.05 $0.35
216797 2020-10-22 $16.47 USPSFirstClass 2 1.00 lbs $8.19 $8.15 $0.04
216798 2020-10-22 $13.14 USPSFirstClass 1 0.15 lbs $4.44 $3.77 $0.67
216799 2020-10-22 $9.86 USPSFirstClass 1 0.06 lbs $4.30 $3.30 $1.00
216800 2020-10-22 $26.34 USPSPriority 1 1.50 lbs $10.62 $8.61 $2.01
216802 2020-10-22 $228.40 Ground 1 14.05 lbs $35.41 $23.88 $11.53
216805 2020-10-22 $24.70 First-Class Package Service 1 0.85 lbs $6.24 $5.79 $0.45
216806 2020-10-22 $14.79 First-Class Package Service 2 0.20 lbs $4.01 $3.56 $0.45
216807 2020-10-22 $16.01 First-Class Package Service 1 0.35 lbs $4.22 $4.57 $-0.35
216808 2020-08-28 $98.46 Ground 4 11.67 lbs $20.00 $19.78 $0.22
216811 2020-10-22 $10.36 First-Class Mail Stamped Letter 4 0.12 lbs $3.50 $3.18 $0.32
216812 2020-10-22 $5.18 First-Class Mail Stamped Letter 2 0.02 lbs $3.20 $3.30 $-0.10
216813 2020-10-22 $51.93 Ground 4 4.80 lbs $18.77 $15.99 $2.78
216814 2020-10-22 $72.24 Priority Mail 2-Day Flat Rate Envelope 16 0.92 lbs $8.40 $8.05 $0.35
216815 2020-10-22 $37.19 Priority Mail 3-Day Flat Rate Envelope 1 1.10 lbs $8.40 $7.90 $0.50
216817 2020-10-22 $12.32 First-Class Package Service 18 0.18 lbs $3.50 $3.18 $0.32
216822 2020-07-15 $393.04 Priority Mail 2-Day 11 15.05 lbs $23.20 $17.82 $5.38
216823 2020-10-22 $5.16 First-Class Mail Stamped Letter 4 0.04 lbs $3.20 $3.18 $0.02
216824 2020-10-22 $36.89 First-Class Package Service 1 0.50 lbs $4.70 $4.25 $0.45
216825 2020-10-22 $352.19 Ground Home Delivery 2 33.75 lbs $74.21 $55.57 $18.64
216826 2020-10-22 $8.25 First-Class Mail Stamped Letter 10 0.10 lbs $3.35 $3.09 $0.26
216827 2020-10-23 $15.77 First-Class Package Service 4 0.26 lbs $4.01 $3.56 $0.45
216828 2020-10-23 $7.53 USPSFirstClass 1 0.02 lbs $4.35 $3.92 $0.43
216829 2020-10-23 $15.21 USPSFirstClass 2 0.07 lbs $4.29 $3.30 $0.99
216830 2020-10-23 $10.59 USPSFirstClass 1 0.05 lbs $4.29 $3.18 $1.11
216831 2020-10-23 $9.55 USPSFirstClass 1 0.02 lbs $4.15 $3.03 $1.12
216832 2020-10-23 $9.93 USPSFirstClass 1 0.10 lbs $4.21 $3.09 $1.12
216833 2020-10-23 $10.69 USPSFirstClass 1 0.35 lbs $4.99 $4.33 $0.66
216834 2020-10-23 $22.84 USPSFirstClass 1 0.15 lbs $4.85 $3.09 $1.76
216835 2020-10-23 $9.02 USPSFirstClass 2 0.06 lbs $4.30 $3.43 $0.87
216836 2020-10-23 $8.84 USPSFirstClass 1 0.10 lbs $4.12 $3.03 $1.09
216837 2020-10-23 $5.51 USPSFirstClass 1 0.01 lbs $4.05 $3.18 $0.87
216838 2020-10-23 $54.68 Priority Mail 2-Day Flat Rate Envelope 4 1.10 lbs $8.40 $8.05 $0.35
216839 2020-10-23 $10.33 First-Class Mail Stamped Letter 2 0.06 lbs $3.35 $3.43 $-0.08
216842 2020-10-23 $32.51 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.90 $8.05 $0.85
216844 2020-10-23 $32.01 First-Class Package Service 6 0.73 lbs $5.77 $5.52 $0.25
216845 2020-10-23 $32.16 Priority Mail 3-Day 1 0.95 lbs $9.37 $8.61 $0.76
216846 2020-10-22 $12.57 First-Class Package Service 2 0.04 lbs $0.59 $3.18 $-2.59
216847 2020-10-23 $7.74 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $3.18 $0.17
216848 2020-10-23 $20.74 First-Class Package Service 2 0.40 lbs $4.96 $4.71 $0.25
216850 2020-10-23 $8.72 First-Class Package Service - Retail 3 0.07 lbs $6.25 $3.50 $2.75
216851 2020-10-23 $17.99 First-Class Package Service 2 0.38 lbs $4.01 $3.09 $0.92
216852 2020-10-23 $7.70 USPSFirstClass 1 0.02 lbs $4.20 $3.77 $0.43
216853 2020-10-23 $8.54 First-Class Mail Stamped Letter 1 0.07 lbs $3.35 $3.30 $0.05
216856 2020-10-23 $4.19 First-Class Mail Stamped Letter 1 0.02 lbs $3.20 $3.09 $0.11
Total 21025 order(s) 59971 29292.14 lbs $193562.51 $270247.54 $-76685.03