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
234805 2026-01-11 $62.31 USPS Ground Advantage 1 5.15 lbs $16.12 $22.83 $-6.71
234806 2026-01-11 $37.63 USPS Ground Advantage 3 0.44 lbs $12.06 $6.06 $6.00
234807 2026-01-11 $27.48 USPS Ground Advantage 1 0.18 lbs $5.65 $4.65 $1.00
234808 2026-01-10 $41.76 USPS Ground Advantage 10 4.50 lbs $14.96 $13.96 $1.00
234809 2026-01-10 $24.62 USPS Ground Advantage 4 1.00 lbs $16.34 $9.31 $7.03
234810 2026-01-10 $19.08 USPS Ground Advantage 1 1.00 lbs $10.06 $10.00 $0.06
234811 2026-01-09 $9.17 USPS Ground Advantage 1 0.05 lbs $5.65 $4.65 $1.00
234812 2026-01-09 $18.45 USPS Ground Advantage 4 1.00 lbs $10.17 $9.17 $1.00
234813 2026-01-09 $48.75 USPS Ground Advantage 1 1.17 lbs $9.03 $8.08 $0.95
234814 2026-01-13 $11.31 USPS Ground Advantage 1 0.05 lbs $5.52 $4.52 $1.00
234816 2026-01-14 $24.71 USPS Ground Advantage 1 0.64 lbs $7.06 $6.06 $1.00
234817 2026-01-14 $16.54 USPS Ground Advantage 4 0.76 lbs $9.54 $9.31 $0.23
234818 2026-01-13 $44.83 USPS Ground Advantage 1 1.27 lbs $9.14 $8.14 $1.00
234819 2026-01-13 $40.53 USPS Ground Advantage 9 4.05 lbs $15.96 $14.96 $1.00
234820 2026-01-14 $23.29 USPS Ground Advantage 1 1.06 lbs $7.59 $6.73 $0.86
234821 2026-01-14 $31.20 USPS Ground Advantage 10 2.50 lbs $9.20 $7.16 $2.04
234822 2026-01-15 $46.65 USPS Ground Advantage 1 0.56 lbs $7.18 $6.18 $1.00
234823 2026-01-15 $16.22 USPS Ground Advantage 1 0.05 lbs $6.15 $5.37 $0.78
234824 2026-01-14 $7.99 USPS Ground Advantage 1 0.19 lbs $6.00 $5.41 $0.59
234825 2026-01-14 $88.46 USPS Ground Advantage 1 1.19 lbs $9.93 $10.12 $-0.19
234826 2026-01-15 $10.11 USPS Ground Advantage 1 0.05 lbs $5.92 $4.92 $1.00
234828 2026-01-15 $40.62 USPS Ground Advantage 1 1.20 lbs $9.14 $8.14 $1.00
234829 2026-01-16 $8.91 USPS Ground Advantage 1 0.25 lbs $6.15 $5.15 $1.00
234830 2026-01-17 $40.69 USPS Ground Advantage 1 1.20 lbs $9.14 $8.35 $0.79
234831 2026-01-17 $19.34 USPS Ground Advantage 3 1.35 lbs $10.31 $9.20 $1.11
234832 2026-01-17 $36.00 USPS Ground Advantage 3 0.60 lbs $7.05 $6.99 $0.06
234833 2026-01-17 $49.46 USPS Ground Advantage 1 2.20 lbs $20.07 $17.60 $2.47
234837 2026-01-18 $24.80 USPS Ground Advantage 3 0.15 lbs $6.68 $6.07 $0.61
234838 2026-01-18 $47.15 USPS Ground Advantage 1 1.25 lbs $9.82 $8.82 $1.00
234839 2026-01-18 $13.64 USPS Ground Advantage 1 0.05 lbs $6.68 $5.68 $1.00
234840 2026-01-18 $43.73 USPS Ground Advantage 3 1.11 lbs $11.00 $8.83 $2.17
234841 2026-01-17 $8.59 USPS Ground Advantage 1 0.25 lbs $6.24 $5.29 $0.95
234842 2026-01-17 $24.20 USPS Ground Advantage 5 0.31 lbs $12.30 $5.52 $6.78
234843 2026-01-20 $17.04 USPS Ground Advantage 2 0.40 lbs $12.82 $5.52 $7.30
234844 2026-01-20 $18.89 USPS Ground Advantage 1 0.29 lbs $6.30 $5.30 $1.00
234845 2026-01-20 $21.56 USPS Ground Advantage 4 1.80 lbs $11.00 $11.29 $-0.29
234846 2026-01-19 $17.43 USPS Ground Advantage 1 0.37 lbs $6.52 $5.52 $1.00
234847 2026-01-20 $19.58 USPS Ground Advantage 1 0.30 lbs $7.07 $6.07 $1.00
234849 2026-01-21 $112.32 USPS Ground Advantage 5 1.30 lbs $34.90 $10.00 $24.90
234850 2026-01-20 $13.15 USPS Ground Advantage 2 0.50 lbs $7.91 $5.92 $1.99
234851 2026-01-20 $12.19 USPS Ground Advantage 1 0.05 lbs $6.40 $5.40 $1.00
234852 2026-01-21 $14.91 USPS Ground Advantage 1 0.10 lbs $6.52 $5.52 $1.00
234853 2026-01-21 $12.83 USPS Ground Advantage 1 0.03 lbs $6.29 $5.29 $1.00
234854 2026-01-23 $42.98 USPS Ground Advantage 6 2.40 lbs $25.56 $12.07 $13.49
234855 2026-01-18 $19.19 Priority Mail 1 0.37 lbs $6.20 $5.62 $0.58
234856 2026-01-23 $24.19 USPS Ground Advantage 1 1.00 lbs $9.83 $9.65 $0.18
234857 2026-01-23 $57.98 USPS Ground Advantage 1 1.81 lbs $9.83 $8.83 $1.00
234858 2026-01-23 $39.37 USPS Ground Advantage 1 0.10 lbs $6.62 $5.52 $1.10
234861 2026-01-24 $24.62 USPS Ground Advantage 1 1.50 lbs $8.67 $7.72 $0.95
234862 2026-01-24 $24.62 USPS Ground Advantage 1 1.50 lbs $8.67 $7.72 $0.95
234863 2026-01-24 $11.67 USPS Ground Advantage 1 0.03 lbs $6.22 $5.22 $1.00
234864 2026-01-24 $43.18 USPS Ground Advantage 1 1.30 lbs $7.50 $6.50 $1.00
234865 2026-01-23 $16.34 USPS Ground Advantage 1 0.20 lbs $6.52 $5.77 $0.75
234866 2026-01-23 $15.14 USPS Ground Advantage 2 0.90 lbs $8.46 $7.52 $0.94
234867 2026-01-23 $29.04 USPS Ground Advantage 2 2.00 lbs $11.00 $12.07 $-1.07
234870 2026-01-24 $13.48 USPS Ground Advantage 1 0.10 lbs $6.52 $5.52 $1.00
234871 2026-01-24 $30.09 Priority Mail Flat Rate Envelope 1 0.30 lbs $11.40 $9.80 $1.60
234872 2026-01-25 $29.10 Priority Mail 9 0.14 lbs $15.19 $8.90 $6.29
234873 2026-01-25 $22.41 USPS Ground Advantage 5 1.25 lbs $11.41 $8.65 $2.76
234874 2026-01-25 $10.86 USPS Ground Advantage 1 0.05 lbs $6.00 $5.00 $1.00
234877 2026-01-26 $59.11 USPS Ground Advantage 1 2.25 lbs $12.92 $14.58 $-1.66
234878 2026-01-26 $12.99 USPS Ground Advantage 1 0.20 lbs $6.29 $5.29 $1.00
234879 2026-01-26 $46.09 Priority Mail Flat Rate Envelope 1 0.90 lbs $11.40 $11.20 $0.20
234880 2026-01-27 $27.41 USPS Ground Advantage 3 1.20 lbs $12.92 $11.92 $1.00
234881 2026-01-27 $18.76 USPS Ground Advantage 2 0.20 lbs $6.52 $5.77 $0.75
234882 2026-01-27 $13.82 USPS Ground Advantage 1 0.30 lbs $6.34 $5.39 $0.95
234883 2026-01-29 $16.27 USPS Ground Advantage 1 0.05 lbs $6.20 $5.20 $1.00
234884 2026-01-29 $14.27 USPS Ground Advantage 1 0.10 lbs $5.88 $4.88 $1.00
234885 2026-01-29 $13.25 USPS Ground Advantage 1 0.07 lbs $6.29 $5.29 $1.00
234886 2026-01-29 $26.38 USPS Ground Advantage 1 0.35 lbs $7.07 $6.07 $1.00
234887 2026-01-29 $58.91 USPS Ground Advantage 1 2.54 lbs $8.52 $7.52 $1.00
234888 2026-01-28 $16.96 USPS Ground Advantage 1 0.05 lbs $6.89 $5.89 $1.00
234889 2026-01-28 $41.34 USPS Ground Advantage 1 0.55 lbs $6.89 $5.89 $1.00
234890 2026-01-29 $13.10 USPS Ground Advantage 1 0.20 lbs $6.40 $5.40 $1.00
234891 2026-01-29 $12.47 USPS Ground Advantage 1 0.05 lbs $6.68 $5.68 $1.00
234892 2026-01-29 $28.39 USPS Ground Advantage 1 0.18 lbs $6.56 $5.56 $1.00
234893 2026-01-29 $17.30 USPS Ground Advantage 1 0.15 lbs $6.56 $5.56 $1.00
234894 2026-01-29 $11.20 USPS Ground Advantage 1 0.05 lbs $6.29 $5.29 $1.00
234895 2026-01-29 $10.73 USPS Ground Advantage 1 0.03 lbs $6.29 $5.29 $1.00
234896 2026-01-30 $9.41 USPS Ground Advantage 2 0.85 lbs $12.78 $6.51 $6.27
234897 2026-02-01 $10.93 USPS Ground Advantage 1 0.05 lbs $6.07 $5.07 $1.00
234898 2026-02-01 $29.19 USPS Ground Advantage 1 0.03 lbs $6.52 $5.52 $1.00
234900 2026-02-01 $18.98 USPS Ground Advantage 1 0.35 lbs $6.39 $5.39 $1.00
234901 2026-02-01 $19.79 USPS Ground Advantage 2 0.40 lbs $7.07 $6.07 $1.00
234902 2026-01-31 $10.06 USPS Ground Advantage 2 0.15 lbs $12.40 $5.20 $7.20
234904 2026-01-31 $23.11 USPS Ground Advantage 5 1.25 lbs $11.41 $8.81 $2.60
234905 2026-02-02 $22.96 USPS Ground Advantage 4 1.80 lbs $11.00 $10.00 $1.00
234906 2026-02-03 $12.19 USPS Ground Advantage 1 0.04 lbs $6.40 $5.40 $1.00
234907 2026-02-03 $50.18 USPS Ground Advantage 2 0.36 lbs $6.52 $5.52 $1.00
234908 2026-02-02 $9.62 USPS Ground Advantage 1 0.06 lbs $6.52 $5.52 $1.00
234909 2026-02-02 $57.28 USPS Ground Advantage 1 1.35 lbs $9.83 $8.83 $1.00
234910 2026-02-02 $41.93 USPS Ground Advantage 2 2.60 lbs $11.71 $11.51 $0.20
234911 2026-02-03 $22.40 Priority Mail Flat Rate Envelope 1 0.58 lbs $11.40 $10.20 $1.20
234912 2026-02-03 $29.73 USPS Ground Advantage 4 1.70 lbs $16.33 $7.57 $8.76
234913 2026-02-05 $48.67 USPS Ground Advantage 10 4.50 lbs $18.77 $17.77 $1.00
234914 2026-02-04 $13.04 USPS Ground Advantage 2 0.10 lbs $6.00 $5.00 $1.00
234915 2026-02-04 $15.43 USPS Ground Advantage 1 0.05 lbs $6.20 $5.20 $1.00
234916 2026-02-04 $57.40 USPS Ground Advantage 1 1.20 lbs $9.93 $8.83 $1.10
234917 2026-02-04 $23.58 USPS Ground Advantage 1 1.50 lbs $7.63 $6.83 $0.80
234919 2026-02-05 $16.47 USPS Ground Advantage 1 0.05 lbs $6.40 $5.40 $1.00
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56