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
222735 2021-02-27 $10.79 First-Class Mail Stamped Letter 1 0.08 lbs $3.40 $3.35 $0.05
222738 2021-02-27 $8.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.35 $-0.15
222739 2021-02-27 $57.94 Priority Mail 2-Day 1 1.70 lbs $14.95 $11.01 $3.94
222740 2021-02-27 $8.11 First-Class Package Service 1 0.05 lbs $3.62 $3.12 $0.50
222741 2021-02-27 $15.18 USPSFirstClass 2 0.12 lbs $4.52 $3.22 $1.30
222742 2021-02-27 $7.75 First-Class Mail Stamped Letter 1 0.10 lbs $3.40 $3.12 $0.28
222743 2021-02-27 $29.80 Priority Mail 2-Day 4 1.25 lbs $8.64 $7.79 $0.85
222744 2021-02-27 $10.38 USPSFirstClass 1 0.04 lbs $4.59 $3.35 $1.24
222745 2021-02-27 $7.71 USPSFirstClass 1 0.07 lbs $4.32 $3.06 $1.26
222747 2021-02-27 $35.43 Priority Mail 3-Day 4 1.34 lbs $10.49 $9.64 $0.85
222748 2021-02-27 $13.38 First-Class Mail Stamped Letter 2 0.12 lbs $3.40 $3.35 $0.05
222749 2021-02-28 $31.94 USPSFirstClass 1 0.69 lbs $6.95 $23.74 $-16.79
222750 2021-02-27 $17.07 First-Class Package Service 2 0.34 lbs $4.19 $3.69 $0.50
222751 2021-02-28 $15.38 USPSFirstClass 2 0.12 lbs $4.72 $3.49 $1.23
222752 2021-02-27 $116.75 Priority Mail 2-Day 14 1.44 lbs $9.09 $8.24 $0.85
222754 2021-02-27 $32.80 First-Class Package Service 1 0.70 lbs $6.31 $5.81 $0.50
222755 2021-02-27 $8.98 First-Class Package Service 1 0.07 lbs $3.99 $3.49 $0.50
222756 2021-02-28 $5.89 First-Class Mail Stamped Letter 1 0.02 lbs $3.00 $3.35 $-0.35
222757 2021-02-28 $13.86 First-Class Mail Stamped Letter 4 0.15 lbs $3.40 $3.49 $-0.09
222758 2021-02-28 $13.00 USPSFirstClass 2 0.38 lbs $8.62 $4.20 $4.42
222759 2021-02-28 $9.85 USPSFirstClass 1 0.06 lbs $4.52 $3.22 $1.30
222760 2021-02-28 $26.68 USPSFirstClass 2 1.00 lbs $8.70 $8.34 $0.36
222761 2021-02-28 $9.90 USPSFirstClass 1 0.06 lbs $4.57 $3.35 $1.22
222762 2021-02-28 $75.72 USPSFirstClass 4 3.22 lbs $28.56 $16.87 $11.69
222763 2021-02-28 $19.07 First-Class Package Service 1 0.28 lbs $4.08 $3.58 $0.50
222765 2021-02-28 $46.53 Priority Mail 2-Day 2 1.10 lbs $9.09 $8.72 $0.37
222766 2021-02-28 $10.99 First-Class Mail Stamped Letter 1 0.04 lbs $3.20 $3.49 $-0.29
222770 2021-02-28 $28.38 Priority Mail 3-Day 1 0.74 lbs $9.09 $8.24 $0.85
222771 2021-02-28 $24.00 First-Class Package Service 4 0.30 lbs $4.08 $3.58 $0.50
222773 2021-02-28 $20.71 First-Class Package Service 2 0.40 lbs $4.93 $4.68 $0.25
222774 2021-02-28 $31.89 USPSFirstClass 1 0.69 lbs $6.90 $16.10 $-9.20
222775 2021-02-28 $51.74 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.75 $8.25 $0.50
222776 2021-02-28 $137.55 Ground 9 6.02 lbs $30.41 $20.47 $9.94
222778 2021-02-28 $27.15 USPSFirstClass 1 0.60 lbs $6.96 $5.98 $0.98
222780 2021-02-28 $62.99 Priority Mail 3-Day Medium Flat Rate Box 1 25.05 lbs $15.00 $13.75 $1.25
222781 2021-02-28 $21.17 First-Class Package Service 2 0.43 lbs $5.03 $4.53 $0.50
222784 2021-02-28 $13.99 First-Class Mail Stamped Letter 1 0.02 lbs $3.00 $3.35 $-0.35
222786 2021-02-28 $13.60 First-Class Package Service 2 0.04 lbs $3.62 $3.12 $0.50
222787 2021-02-28 $25.79 First-Class Package Service 3 0.80 lbs $6.23 $23.54 $-17.31
222789 2021-02-28 $62.94 USPSFirstClass 1 0.50 lbs $7.95 $4.68 $3.27
222790 2021-02-28 $6.86 USPSFirstClass 1 0.01 lbs $4.37 $3.22 $1.15
222793 2021-02-28 $8.39 First-Class Mail Stamped Letter 1 0.08 lbs $3.20 $3.22 $-0.02
222794 2021-02-28 $29.38 First-Class Mail Stamped Letter 2 0.10 lbs $3.40 $3.22 $0.18
222795 2021-02-28 $32.02 Priority Mail 3-Day 7 0.80 lbs $9.09 $9.56 $-0.47
222797 2021-02-28 $7.48 USPSFirstClass 1 0.10 lbs $4.59 $3.49 $1.10
222798 2021-02-28 $27.27 Priority Mail 2-Day Flat Rate Envelope 1 3.55 lbs $8.25 $8.00 $0.25
222799 2021-02-28 $7.99 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.22 $-0.02
222800 2021-02-28 $5.69 First-Class Mail Stamped Letter 1 0.04 lbs $3.20 $3.22 $-0.02
222801 2021-03-01 $7.71 USPSFirstClass 1 0.07 lbs $4.32 $3.06 $1.26
222805 2021-02-28 $38.54 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.75 $7.90 $0.85
222806 2021-02-28 $14.20 First-Class Package Service 3 0.20 lbs $4.07 $3.12 $0.95
222808 2021-02-28 $21.39 First-Class Package Service 1 0.60 lbs $4.63 $5.66 $-1.03
222811 2021-03-01 $16.69 First-Class Package Service 1 0.57 lbs $4.70 $4.20 $0.50
222814 2021-03-01 $19.76 First-Class Package Service 3 0.15 lbs $4.08 $3.58 $0.50
222817 2021-03-01 $31.94 USPSFirstClass 1 0.69 lbs $6.95 $23.74 $-16.79
222818 2021-03-01 $9.42 USPSFirstClass 1 0.25 lbs $4.40 $3.06 $1.34
222819 2021-03-01 $7.18 USPSFirstClass 1 0.10 lbs $4.29 $3.06 $1.23
222820 2021-03-01 $88.34 USPSPriority 1 1.69 lbs $14.78 $8.85 $5.93
222821 2021-03-01 $12.63 USPSFirstClass 1 0.06 lbs $4.84 $3.49 $1.35
222822 2021-03-01 $9.10 USPSFirstClass 2 0.02 lbs $4.12 $3.01 $1.11
222823 2021-03-01 $11.64 USPSFirstClass 1 0.06 lbs $4.65 $3.35 $1.30
222824 2021-03-01 $10.59 USPSFirstClass 1 0.04 lbs $4.60 $3.35 $1.25
222825 2021-03-01 $9.54 USPSFirstClass 1 0.05 lbs $4.55 $3.35 $1.20
222826 2021-03-01 $5.89 First-Class Mail Stamped Letter 1 0.05 lbs $3.00 $3.06 $-0.06
222827 2021-03-01 $24.05 First-Class Package Service 4 0.37 lbs $4.19 $3.69 $0.50
222828 2021-03-01 $33.16 First-Class Package Service 2 0.54 lbs $5.18 $4.68 $0.50
222829 2021-03-01 $7.33 USPSFirstClass 1 0.10 lbs $4.44 $3.35 $1.09
222830 2021-03-01 $7.48 USPSFirstClass 1 0.10 lbs $4.59 $3.49 $1.10
222831 2021-03-01 $4.99 First-Class Mail Stamped Letter 1 0.01 lbs $3.00 $3.35 $-0.35
222835 2021-03-01 $14.58 First-Class Package Service 1 0.14 lbs $4.19 $3.35 $0.84
222836 2021-03-01 $38.54 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $8.75 $7.90 $0.85
222837 2021-03-01 $62.45 Priority Mail 2-Day 4 1.80 lbs $10.49 $9.01 $1.48
222838 2021-03-01 $31.28 Priority Mail 3-Day 1 0.95 lbs $11.29 $10.44 $0.85
222839 2021-03-01 $8.07 First-Class Package Service 1 0.09 lbs $3.72 $3.22 $0.50
222841 2021-03-01 $37.33 USPSPriority 1 3.10 lbs $18.54 $8.00 $10.54
222842 2021-03-01 $29.54 USPSPriority 1 1.70 lbs $9.55 $7.79 $1.76
222843 2021-03-01 $4.98 First-Class Mail Stamped Letter 2 0.02 lbs $3.00 $3.22 $-0.22
222844 2021-03-01 $58.37 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.40 lbs $8.85 $8.00 $0.85
222845 2021-03-01 $12.43 USPSFirstClass 1 0.06 lbs $4.64 $3.22 $1.42
222846 2021-03-01 $9.75 USPSFirstClass 1 0.06 lbs $4.42 $3.06 $1.36
222847 2021-03-01 $31.84 USPSFirstClass 1 0.69 lbs $6.85 $16.90 $-10.05
222848 2021-03-01 $9.90 USPSFirstClass 1 0.06 lbs $4.57 $3.35 $1.22
222849 2021-03-01 $8.39 First-Class Mail Stamped Letter 1 0.08 lbs $3.20 $3.35 $-0.15
222850 2021-03-01 $27.40 First-Class Package Service 1 0.50 lbs $5.91 $4.38 $1.53
222851 2021-03-01 $19.29 First-Class Package Service 3 0.23 lbs $3.82 $3.57 $0.25
222852 2021-03-01 $8.98 First-Class Package Service 1 0.07 lbs $3.99 $3.49 $0.50
222853 2021-03-01 $44.99 First-Class Package Service 3 0.49 lbs $4.78 $4.53 $0.25
222854 2021-03-01 $19.00 First-Class Package Service 1 0.22 lbs $4.01 $3.51 $0.50
222855 2021-03-01 $9.65 First-Class Package Service 4 0.24 lbs $4.19 $3.69 $0.50
222856 2021-03-01 $32.91 First-Class Package Service 10 0.40 lbs $4.01 $3.51 $0.50
222860 2021-03-02 $31.62 First-Class Package Service 11 0.68 lbs $6.23 $3.49 $2.74
222861 2021-03-02 $137.04 Priority Mail 2-Day 1 3.95 lbs $9.05 $8.20 $0.85
222862 2021-03-02 $15.99 First-Class Package Service 2 0.34 lbs $4.01 $3.51 $0.50
222863 2021-03-02 $15.23 USPSFirstClass 2 0.12 lbs $4.57 $3.35 $1.22
222864 2021-03-02 $31.94 USPSFirstClass 1 0.69 lbs $6.95 $22.02 $-15.07
222865 2021-03-02 $63.76 USPSFirstClass 3 0.60 lbs $6.55 $4.12 $2.43
222866 2021-03-02 $14.47 USPSFirstClass 2 0.10 lbs $4.69 $3.49 $1.20
222867 2021-03-02 $32.09 USPSPriority 1 2.30 lbs $12.10 $16.43 $-4.33
222868 2021-03-02 $15.87 First-Class Package Service 1 0.25 lbs $4.08 $3.58 $0.50
222869 2021-03-02 $23.79 First-Class Package Service 3 0.50 lbs $4.88 $4.38 $0.50
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56