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
225660 2021-06-13 $47.69 First-Class Package Service 2 0.04 lbs $5.33 $3.58 $1.75
225664 2021-06-13 $25.78 Priority Mail 3-Day Flat Rate Envelope 1 0.85 lbs $8.50 $8.00 $0.50
225665 2021-06-13 $9.81 First-Class Package Service 1 0.10 lbs $4.32 $3.12 $1.20
225666 2021-06-13 $10.79 First-Class Mail Stamped Letter 1 0.09 lbs $4.00 $3.06 $0.94
225667 2021-06-13 $121.20 Ground Home Delivery 3 6.10 lbs $32.34 $26.36 $5.98
225668 2021-06-13 $17.67 First-Class Package Service 1 0.25 lbs $4.78 $3.58 $1.20
225670 2021-06-13 $28.49 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $8.50 $8.00 $0.50
225674 2021-06-13 $6.64 First-Class Package Service 1 0.24 lbs $5.63 $3.85 $1.78
225678 2021-06-14 $27.67 First-Class Package Service 1 0.35 lbs $4.78 $3.58 $1.20
225679 2020-12-17 $56.46 Priority Mail 2-Day 2 1.20 lbs $8.94 $11.69 $-2.75
225680 2021-06-14 $26.74 First-Class Package Service 4 0.40 lbs $4.78 $3.58 $1.20
225681 2021-06-14 $12.59 First-Class Mail Stamped Letter 1 0.05 lbs $3.80 $3.12 $0.68
225682 2021-06-14 $16.54 First-Class Package Service 1 0.30 lbs $5.05 $3.85 $1.20
225683 2021-06-14 $45.54 Priority Mail 2-Day 6 1.88 lbs $13.80 $10.89 $2.91
225684 2021-06-14 $54.48 Priority Mail 2-Day Flat Rate Envelope 2 1.35 lbs $8.50 $7.90 $0.60
225688 2021-06-14 $22.03 Priority Mail 2-Day 1 0.95 lbs $11.54 $10.44 $1.10
225692 2021-06-14 $122.07 Priority Mail 2-Day Padded Flat Rate Envelope 3 0.93 lbs $9.10 $8.00 $1.10
225699 2021-06-14 $48.84 Priority Mail 3-Day 4 2.56 lbs $17.88 $16.78 $1.10
225705 2021-06-14 $43.12 Priority Mail 2-Day Flat Rate Envelope 3 1.21 lbs $8.50 $8.45 $0.05
225706 2021-06-14 $8.99 First-Class Mail Stamped Letter 1 0.05 lbs $3.80 $3.49 $0.31
225707 2021-06-14 $15.49 First-Class Mail Stamped Letter 1 0.10 lbs $4.00 $3.22 $0.78
225713 2021-06-15 $90.35 Priority Mail 2-Day Medium Flat Rate Box 5 4.00 lbs $15.40 $12.64 $2.76
225714 2021-06-15 $268.43 Priority Mail 3-Day 22 4.61 lbs $10.63 $9.52 $1.11
225715 2021-06-15 $12.38 USPSFirstClass 2 0.10 lbs $4.40 $3.12 $1.28
225717 2021-06-15 $10.29 First-Class Mail Stamped Letter 1 0.10 lbs $4.00 $3.22 $0.78
225718 2021-06-15 $10.11 USPSFirstClass 1 0.06 lbs $4.72 $3.49 $1.23
225721 2021-06-15 $22.40 First-Class Package Service 2 0.60 lbs $6.62 $4.20 $2.42
225724 2021-06-15 $51.54 First-Class Package Service - Retail 3 0.55 lbs $6.60 $4.04 $2.56
225727 2021-06-15 $30.81 First-Class Package Service 3 0.68 lbs $6.47 $5.27 $1.20
225728 2021-06-15 $19.83 Priority Mail 3-Day 1 0.95 lbs $9.34 $8.24 $1.10
225730 2021-06-15 $416.59 Ground 14 16.09 lbs $27.74 $30.09 $-2.35
225731 2021-06-16 $16.53 First-Class Mail Stamped Letter 1 0.03 lbs $3.80 $3.12 $0.68
225732 2021-06-16 $25.82 First-Class Package Service 1 0.60 lbs $5.33 $5.66 $-0.33
225733 2021-06-16 $9.38 USPSFirstClass 1 0.04 lbs $4.49 $3.22 $1.27
225735 2021-06-16 $82.85 USPSFirstClass 10 0.00 lbs $44.95 $16.87 $28.08
225739 2021-06-16 $22.04 First-Class Package Service 1 0.35 lbs $4.66 $3.46 $1.20
225741 2021-06-16 $25.78 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $8.50 $8.00 $0.50
225742 2021-06-16 $53.60 Priority Mail 3-Day 1 1.15 lbs $12.11 $11.01 $1.10
225744 2021-06-16 $9.73 First-Class Package Service 4 0.22 lbs $4.77 $3.12 $1.65
225745 2021-06-16 $12.37 First-Class Package Service 5 0.09 lbs $4.42 $3.22 $1.20
225749 2021-06-16 $19.13 USPSFirstClass 1 0.81 lbs $7.34 $8.00 $-0.66
225752 2021-06-16 $10.48 First-Class Mail Stamped Letter 2 0.15 lbs $4.00 $3.35 $0.65
225754 2021-06-16 $13.29 First-Class Mail Stamped Letter 1 0.05 lbs $3.80 $3.35 $0.45
225758 2021-06-16 $31.53 Priority Mail 2-Day 1 1.70 lbs $11.54 $10.44 $1.10
225762 2021-06-16 $219.07 Priority Mail 2-Day 2 21.35 lbs $28.73 $26.98 $1.75
225763 2021-06-17 $9.78 First-Class Mail Stamped Letter 2 0.03 lbs $3.80 $3.12 $0.68
225764 2021-06-17 $103.02 Priority Mail 2-Day 2 5.20 lbs $26.85 $25.75 $1.10
225765 2021-06-17 $10.11 USPSFirstClass 1 0.06 lbs $4.72 $3.49 $1.23
225766 2021-06-17 $17.14 USPSFirstClass 1 0.05 lbs $4.86 $3.22 $1.64
225767 2021-06-17 $9.75 First-Class Package Service 1 0.20 lbs $4.77 $3.57 $1.20
225768 2021-06-17 $34.36 First-Class Package Service 1 0.62 lbs $6.37 $10.84 $-4.47
225769 2021-06-17 $293.47 Ground 1 14.05 lbs $53.48 $30.04 $23.44
225770 2021-06-17 $209.03 Priority Mail 3-Day 1 21.00 lbs $28.73 $26.98 $1.75
225771 2021-06-17 $26.53 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $8.50 $8.00 $0.50
225774 2021-06-17 $253.70 Ground Home Delivery 5 22.30 lbs $29.46 $18.45 $11.01
225775 2021-06-18 $209.03 Priority Mail 2-Day 1 21.00 lbs $28.73 $26.98 $1.75
225776 2021-06-18 $25.16 First-Class Package Service 2 0.50 lbs $5.88 $3.85 $2.03
225777 2021-06-18 $209.21 Ground Home Delivery 1 21.00 lbs $28.91 $22.63 $6.28
225778 2021-06-18 $7.81 USPSFirstClass 1 0.03 lbs $4.32 $3.06 $1.26
225782 2021-06-18 $39.99 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $9.00 $7.90 $1.10
225785 2021-06-18 $234.57 Priority Mail 2-Day 1 21.00 lbs $54.27 $52.53 $1.74
225786 2021-06-18 $209.03 Priority Mail 2-Day 1 21.00 lbs $28.73 $26.11 $2.62
225787 2021-06-18 $9.69 USPSFirstClass 1 0.02 lbs $4.70 $3.49 $1.21
225788 2021-06-18 $13.18 USPSFirstClass 1 0.34 lbs $5.39 $3.58 $1.81
225789 2021-06-18 $8.55 USPSMedia 1 0.23 lbs $3.16 $2.89 $0.27
225790 2021-06-18 $11.59 First-Class Mail Stamped Letter 1 0.04 lbs $3.80 $3.49 $0.31
225792 2021-06-18 $26.12 First-Class Package Service 1 0.60 lbs $5.63 $4.68 $0.95
225794 2021-06-18 $15.11 USPSFirstClass 1 0.25 lbs $4.67 $3.51 $1.16
225795 2021-06-19 $11.59 First-Class Mail Stamped Letter 1 0.04 lbs $3.80 $3.22 $0.58
225797 2021-06-19 $8.39 USPSFirstClass 1 0.08 lbs $4.40 $3.12 $1.28
225799 2021-06-19 $19.70 First-Class Package Service 1 0.19 lbs $4.71 $3.51 $1.20
225802 2021-06-19 $6.79 First-Class Mail Stamped Letter 1 0.04 lbs $3.80 $3.12 $0.68
225809 2021-06-19 $309.99 Ground 5 22.19 lbs $62.66 $35.89 $26.77
225810 2021-06-19 $6.58 First-Class Mail Stamped Letter 2 0.02 lbs $3.60 $3.49 $0.11
225814 2021-06-20 $39.74 First-Class Package Service 15 0.20 lbs $4.89 $3.35 $1.54
225817 2021-06-20 $21.67 USPSFirstClass 2 0.68 lbs $6.09 $5.66 $0.43
225821 2021-06-20 $15.02 First-Class Package Service 1 0.30 lbs $4.71 $3.51 $1.20
225822 2021-06-20 $54.83 Priority Mail 2-Day 1 1.15 lbs $9.34 $8.49 $0.85
225823 2021-06-20 $103.66 USPSPriority 2 5.08 lbs $15.50 $34.98 $-19.48
225824 2021-06-20 $220.49 Priority Mail 3-Day 1 21.00 lbs $40.19 $37.64 $2.55
225825 2021-06-20 $7.29 USPSFirstClass 1 0.20 lbs $4.30 $3.06 $1.24
225827 2021-06-20 $16.26 First-Class Package Service 1 0.30 lbs $4.77 $3.57 $1.20
225830 2021-06-21 $9.44 USPSFirstClass 2 0.40 lbs $5.06 $3.57 $1.49
225831 2021-06-21 $7.97 First-Class Mail Stamped Letter 3 0.12 lbs $4.00 $3.06 $0.94
225832 2021-06-21 $9.03 Priority Mail 1-Day 1 0.57 lbs $8.89 $7.16 $1.73
225834 2021-06-21 $16.88 First-Class Package Service 1 0.30 lbs $4.89 $3.69 $1.20
225836 2021-06-21 $30.59 Priority Mail 2-Day Padded Flat Rate Envelope 1 2.00 lbs $9.10 $10.44 $-1.34
225839 2021-06-21 $11.59 First-Class Mail Stamped Letter 1 0.04 lbs $3.80 $3.06 $0.74
225840 2021-06-21 $33.87 Priority Mail 3-Day 2 0.85 lbs $12.11 $8.00 $4.11
225841 2021-06-21 $25.78 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $8.50 $8.00 $0.50
225842 2021-06-21 $22.03 Priority Mail 2-Day 1 0.95 lbs $11.54 $8.34 $3.20
225845 2021-06-22 $29.99 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $8.50 $8.45 $0.05
225847 2021-06-22 $13.14 First-Class Package Service - Retail 1 0.04 lbs $5.35 $3.22 $2.13
225848 2021-06-22 $68.67 Priority Mail 2-Day 1 3.90 lbs $20.39 $16.78 $3.61
225849 2021-06-22 $5.98 First-Class Mail Stamped Letter 2 0.10 lbs $0.00 $3.12 $-3.12
225850 2021-06-22 $16.66 First-Class Package Service 2 0.30 lbs $4.78 $3.58 $1.20
225852 2021-06-22 $13.18 USPSFirstClass 1 0.34 lbs $5.39 $3.58 $1.81
225853 2021-06-22 $23.22 First-Class Package Service 1 0.41 lbs $5.73 $3.69 $2.04
225856 2021-06-22 $38.10 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $9.00 $7.90 $1.10
225857 2021-06-22 $16.62 First-Class Package Service 2 0.32 lbs $4.64 $3.69 $0.95
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56