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
234920 2026-02-05 $21.86 USPS Ground Advantage 1 1.00 lbs $7.50 $6.68 $0.82
234921 2026-02-06 $18.44 USPS Ground Advantage 2 0.20 lbs $6.20 $5.52 $0.68
234922 2026-02-06 $106.74 USPS Ground Advantage 2 23.56 lbs $23.85 $21.64 $2.21
234923 2026-02-06 $61.93 USPS Ground Advantage 2 11.00 lbs $33.08 $14.06 $19.02
234930 2026-02-07 $26.94 USPS Ground Advantage 1 0.38 lbs $6.83 $5.92 $0.91
234931 2026-02-06 $10.34 USPS Ground Advantage 1 0.05 lbs $5.73 $4.78 $0.95
234932 2026-02-06 $10.98 USPS Ground Advantage 1 0.04 lbs $5.78 $4.78 $1.00
234933 2026-02-06 $10.75 USPS Ground Advantage 1 0.05 lbs $6.89 $5.89 $1.00
234934 2026-02-06 $12.00 USPS Ground Advantage 1 0.05 lbs $5.88 $4.88 $1.00
234936 2026-02-09 $49.61 USPS Ground Advantage 10 4.00 lbs $15.71 $14.71 $1.00
234937 2026-02-08 $14.05 USPS Ground Advantage 1 0.05 lbs $6.56 $5.56 $1.00
234938 2026-02-08 $42.70 USPS Ground Advantage 1 1.10 lbs $8.31 $7.31 $1.00
234939 2026-02-09 $45.59 USPS Ground Advantage 1 1.20 lbs $9.20 $7.03 $2.17
234940 2026-02-09 $12.55 USPS Ground Advantage 5 0.25 lbs $6.30 $4.88 $1.42
234941 2026-02-10 $14.59 USPS Ground Advantage 1 0.08 lbs $6.30 $5.30 $1.00
234942 2026-02-11 $20.35 USPS Ground Advantage 2 0.10 lbs $7.07 $5.68 $1.39
234943 2026-02-10 $24.03 USPS Ground Advantage 6 1.20 lbs $9.81 $8.65 $1.16
234944 2026-02-11 $10.84 USPS Ground Advantage 1 0.45 lbs $7.07 $6.39 $0.68
234945 2026-02-11 $23.19 USPS Ground Advantage 1 0.03 lbs $6.20 $5.20 $1.00
234946 2026-02-11 $51.91 USPS Ground Advantage 2 10.88 lbs $14.89 $10.21 $4.68
234947 2026-02-11 $22.16 USPS Ground Advantage 2 0.10 lbs $12.58 $5.29 $7.29
234948 2026-02-11 $10.76 USPS Ground Advantage 1 0.45 lbs $6.77 $6.43 $0.34
234949 2026-02-12 $12.49 USPS Ground Advantage 1 0.22 lbs $6.00 $5.39 $0.61
234950 2026-02-12 $35.52 USPS Ground Advantage 7 1.75 lbs $15.99 $11.11 $4.88
234951 2026-02-16 $9.58 USPS Ground Advantage 1 0.25 lbs $6.62 $5.62 $1.00
234952 2026-02-16 $11.63 USPS Ground Advantage 1 0.20 lbs $6.15 $5.20 $0.95
234953 2026-02-15 $16.29 USPS Ground Advantage 1 0.08 lbs $6.30 $5.30 $1.00
234954 2026-02-15 $25.96 USPS Ground Advantage 4 1.80 lbs $11.72 $10.72 $1.00
234955 2026-02-15 $18.53 USPS Ground Advantage 4 1.00 lbs $7.37 $6.29 $1.08
234956 2026-02-14 $14.11 USPS Ground Advantage 2 0.50 lbs $7.87 $5.89 $1.98
234957 2026-02-13 $18.47 USPS Ground Advantage 2 0.44 lbs $12.39 $5.78 $6.61
234958 2026-02-16 $11.75 USPS Ground Advantage 2 0.40 lbs $6.45 $5.89 $0.56
234959 2026-02-17 $18.49 USPS Ground Advantage 1 0.12 lbs $6.00 $5.39 $0.61
234960 2026-02-16 $12.78 USPS Ground Advantage 1 0.03 lbs $6.29 $5.29 $1.00
234961 2026-02-18 $19.14 USPS Ground Advantage 3 1.35 lbs $7.83 $6.83 $1.00
234962 2026-02-18 $10.66 USPS Ground Advantage 1 0.05 lbs $6.07 $5.07 $1.00
234963 2026-02-18 $52.67 USPS Ground Advantage 10 4.50 lbs $18.77 $17.77 $1.00
234964 2026-02-18 $11.99 USPS Ground Advantage 1 0.05 lbs $6.20 $5.20 $1.00
234965 2026-02-17 $46.31 USPS Ground Advantage 1 9.25 lbs $8.92 $7.92 $1.00
234966 2026-02-18 $31.25 USPS Ground Advantage 5 2.00 lbs $14.30 $12.48 $1.82
234967 2026-02-19 $17.39 USPS Ground Advantage 1 0.05 lbs $6.40 $5.40 $1.00
234968 2026-02-19 $19.88 USPS Ground Advantage 3 0.75 lbs $11.00 $7.52 $3.48
234969 2026-02-21 $15.47 USPS Ground Advantage 1 0.06 lbs $6.78 $5.68 $1.10
234970 2026-02-21 $10.71 USPS Ground Advantage 1 0.05 lbs $6.52 $5.52 $1.00
234971 2026-02-24 $22.80 USPS Ground Advantage 1 0.10 lbs $6.40 $5.40 $1.00
234972 2026-02-24 $12.46 USPS Ground Advantage 1 0.05 lbs $6.52 $5.52 $1.00
234973 2026-02-24 $15.62 USPS Ground Advantage 1 0.30 lbs $6.62 $6.22 $0.40
234974 2026-02-23 $12.20 USPS Ground Advantage 1 0.05 lbs $6.00 $5.00 $1.00
234975 2026-02-23 $13.84 USPS Ground Advantage 2 0.50 lbs $8.52 $6.43 $2.09
234976 2026-02-23 $16.48 USPS Ground Advantage 1 0.06 lbs $6.29 $5.29 $1.00
234977 2026-02-23 $11.56 USPS Ground Advantage 1 0.03 lbs $6.89 $5.89 $1.00
234979 2026-02-25 $30.12 USPS Ground Advantage 1 0.08 lbs $6.07 $5.07 $1.00
234980 2026-02-24 $71.45 USPS Ground Advantage 20 6.00 lbs $21.15 $10.69 $10.46
234981 2026-02-24 $8.75 USPS Ground Advantage 1 0.02 lbs $6.29 $5.29 $1.00
234983 2026-02-27 $10.76 USPS Ground Advantage 1 0.05 lbs $6.52 $5.52 $1.00
234984 2026-02-26 $23.55 USPS Ground Advantage 4 0.20 lbs $6.83 $5.30 $1.53
234985 2026-02-27 $9.25 USPS Ground Advantage 1 0.25 lbs $6.45 $5.45 $1.00
234986 2026-02-27 $12.57 USPS Ground Advantage 2 0.12 lbs $6.29 $5.29 $1.00
234987 2026-03-02 $19.43 USPS Ground Advantage 1 0.35 lbs $6.77 $5.77 $1.00
234988 2026-03-01 $20.60 USPS Ground Advantage 3 1.35 lbs $11.00 $10.00 $1.00
234989 2026-03-01 $16.48 USPS Ground Advantage 2 0.90 lbs $9.72 $8.97 $0.75
234990 2026-03-01 $11.59 USPS Ground Advantage 1 0.22 lbs $6.07 $5.45 $0.62
234991 2026-02-28 $82.06 USPS Ground Advantage 20 9.00 lbs $24.46 $27.88 $-3.42
234992 2026-02-28 $47.53 USPS Ground Advantage 1 1.00 lbs $8.86 $7.86 $1.00
234993 2026-02-28 $16.71 USPS Ground Advantage 1 0.10 lbs $6.52 $5.77 $0.75
234996 2026-03-02 $10.92 USPS Ground Advantage 1 0.05 lbs $6.68 $5.68 $1.00
234997 2026-03-02 $14.29 USPS Ground Advantage 1 0.30 lbs $6.72 $5.77 $0.95
234998 2026-03-03 $10.33 USPS Ground Advantage 1 0.45 lbs $6.77 $6.43 $0.34
234999 2026-03-03 $33.16 USPS Ground Advantage 1 0.50 lbs $6.39 $5.78 $0.61
235000 2026-03-02 $28.99 USPS Ground Advantage 6 2.40 lbs $11.71 $10.71 $1.00
235001 2026-03-02 $24.03 USPS Ground Advantage 1 0.62 lbs $7.04 $7.03 $0.01
235002 2026-03-03 $28.49 USPS Ground Advantage 1 0.18 lbs $6.40 $5.40 $1.00
235005 2026-03-04 $20.52 USPS Ground Advantage 4 1.00 lbs $11.00 $10.00 $1.00
235006 2026-03-04 $11.27 USPS Ground Advantage 1 0.05 lbs $6.52 $5.52 $1.00
235007 2026-03-03 $15.26 USPS Ground Advantage 2 0.08 lbs $6.40 $5.40 $1.00
235008 2026-03-03 $12.66 USPS Ground Advantage 1 0.20 lbs $6.56 $5.56 $1.00
235009 2026-03-03 $58.81 USPS Ground Advantage 1 5.15 lbs $16.74 $21.44 $-4.70
235010 2026-03-03 $13.47 USPS Ground Advantage 2 0.10 lbs $6.07 $5.07 $1.00
235011 2026-03-04 $24.61 USPS Ground Advantage 1 1.50 lbs $8.47 $7.52 $0.95
235012 2026-03-04 $25.88 USPS Ground Advantage 1 0.18 lbs $6.00 $5.00 $1.00
235015 2026-03-05 $93.97 USPS Ground Advantage 1 1.19 lbs $9.83 $9.65 $0.18
235016 2026-03-06 $12.38 USPS Ground Advantage 1 0.05 lbs $6.52 $5.52 $1.00
235017 2026-03-05 $30.28 USPS Ground Advantage 1 1.70 lbs $7.68 $6.50 $1.18
235018 2026-03-05 $19.30 USPS Ground Advantage 1 0.03 lbs $6.30 $5.30 $1.00
235019 2026-03-06 $12.93 USPS Ground Parcel or Priority Mail 1 0.01 lbs $8.63 $5.40 $3.23
235020 2026-03-08 $28.61 USPS Ground Advantage 1 0.18 lbs $6.52 $5.52 $1.00
235021 2026-03-08 $19.80 USPS Ground Advantage 3 1.35 lbs $10.20 $8.97 $1.23
235022 2026-03-08 $11.22 USPS Ground Advantage 1 0.05 lbs $6.30 $5.30 $1.00
235023 2026-03-08 $113.12 USPS Ground Advantage 16 3.65 lbs $47.79 $11.89 $35.90
235024 2026-03-08 $15.96 USPS Ground Advantage 1 0.05 lbs $6.40 $5.40 $1.00
235025 2026-03-07 $15.78 USPS Ground Advantage 1 0.15 lbs $6.00 $5.00 $1.00
235026 2026-03-07 $44.25 USPS Ground Advantage 1 1.20 lbs $9.83 $8.83 $1.00
235027 2026-03-09 $61.97 USPS Ground Advantage 1 0.56 lbs $7.24 $6.24 $1.00
235028 2026-03-09 $27.98 USPS Ground Advantage 5 2.00 lbs $13.58 $12.58 $1.00
235029 2026-03-09 $13.21 USPS Ground Advantage 1 0.20 lbs $6.71 $4.88 $1.83
235030 2026-03-10 $23.59 USPS Ground Advantage 1 0.40 lbs $6.77 $5.77 $1.00
235032 2026-03-11 $22.29 USPS Ground Advantage 4 1.80 lbs $10.21 $10.71 $-0.50
235033 2026-03-11 $17.02 USPS Ground Advantage 2 0.90 lbs $10.26 $9.65 $0.61
235034 2026-03-10 $44.74 USPS Ground Advantage 1 9.25 lbs $12.96 $11.96 $1.00
235036 2026-03-11 $22.44 USPS Ground Advantage 4 1.00 lbs $12.92 $11.92 $1.00
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56