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
229827 2022-07-31 $23.97 First-Class Package Service 2 0.28 lbs $4.99 $3.76 $1.23
229828 2022-08-01 $8.09 USPS First Class 1 0.05 lbs $4.70 $3.48 $1.22
229829 2022-08-01 $14.99 USPS First Class 1 0.05 lbs $5.00 $3.72 $1.28
229830 2022-08-01 $12.00 USPS First-Class Mail or Priority Mail 1 0.08 lbs $4.86 $3.86 $1.00
229831 2022-08-01 $14.99 USPS First Class 1 0.07 lbs $4.70 $3.48 $1.22
229833 2022-08-02 $46.36 Priority Mail 1 3.20 lbs $21.87 $18.03 $3.84
229834 2022-08-02 $27.24 USPS Shipping 1 0.30 lbs $0.00 $3.81 $-3.81
229838 2022-08-02 $7.76 First-Class Package Service 1 0.07 lbs $4.62 $3.42 $1.20
229839 2022-08-03 $10.79 USPS First Class 1 0.04 lbs $5.00 $3.86 $1.14
229840 2022-08-03 $10.29 First-Class Package Service 4 0.04 lbs $4.78 $3.58 $1.20
229841 2022-08-04 $9.56 First-Class Package Service 1 0.03 lbs $4.92 $3.58 $1.34
229842 2022-08-04 $13.50 First-Class Package Service 8 0.08 lbs $4.78 $3.58 $1.20
229843 2022-08-04 $12.21 First-Class Package Service 1 0.19 lbs $5.07 $3.48 $1.59
229845 2022-08-05 $23.08 First-Class Package Service 11 0.31 lbs $5.19 $3.99 $1.20
229846 2022-08-05 $9.06 First-Class Package Service 1 0.01 lbs $4.92 $3.72 $1.20
229847 2022-08-05 $10.94 USPS First Class 1 0.08 lbs $4.65 $3.42 $1.23
229848 2022-08-05 $22.67 First-Class Package Service 1 0.40 lbs $6.18 $3.99 $2.19
229849 2022-08-05 $25.16 First-Class Package Service 2 0.48 lbs $6.18 $5.38 $0.80
229850 2022-08-05 $23.18 Priority Mail 4 0.73 lbs $10.22 $9.12 $1.10
229851 2022-08-06 $15.64 First-Class Package Service 1 0.20 lbs $5.35 $4.15 $1.20
229853 2022-08-06 $34.59 First-Class Package Service 2 0.80 lbs $7.31 $6.11 $1.20
229855 2022-08-06 $29.59 First-Class Package Service 7 0.08 lbs $5.06 $4.15 $0.91
229856 2022-08-07 $20.05 First-Class Package Service 1 0.10 lbs $5.06 $3.86 $1.20
229857 2022-08-07 $12.90 First-Class Package Service 2 0.10 lbs $4.92 $3.72 $1.20
229859 2022-08-08 $7.92 First-Class Package Service 1 0.02 lbs $4.78 $3.58 $1.20
229860 2022-08-08 $16.66 First-Class Package Service - Retail 4 0.12 lbs $5.90 $3.99 $1.91
229861 2022-08-08 $9.54 USPS First Class 1 0.04 lbs $4.75 $3.58 $1.17
229862 2022-08-08 $18.39 USPS First Class 1 0.40 lbs $5.20 $4.42 $0.78
229863 2022-08-08 $9.44 USPS First Class 1 0.05 lbs $4.65 $3.42 $1.23
229864 2022-08-08 $12.64 USPS First Class 1 0.06 lbs $4.65 $3.42 $1.23
229865 2022-08-08 $41.75 Priority Mail Small Flat Rate Box 2 1.53 lbs $9.35 $8.25 $1.10
229866 2022-08-08 $23.59 First-Class Package Service 3 0.48 lbs $5.62 $3.81 $1.81
229868 2022-08-09 $7.64 USPS First Class 1 0.03 lbs $4.65 $3.42 $1.23
229869 2022-08-09 $16.44 USPS First Class 1 0.14 lbs $4.75 $3.58 $1.17
229870 2022-08-09 $19.57 First-Class Package Service 5 0.10 lbs $4.62 $3.42 $1.20
229872 2022-08-10 $20.14 USPS Shipping 1 0.17 lbs $0.00 $3.99 $-3.99
229873 2022-08-10 $9.32 First-Class Package Service 1 0.03 lbs $4.68 $3.48 $1.20
229874 2022-08-11 $9.44 USPS First Class 1 0.06 lbs $4.65 $3.42 $1.23
229875 2022-08-11 $43.49 Priority Mail 1 0.60 lbs $9.00 $7.90 $1.10
229877 2022-08-11 $13.75 First-Class Package Service 3 0.05 lbs $4.78 $3.58 $1.20
229878 2022-08-11 $15.85 First-Class Package Service 1 0.05 lbs $5.06 $3.86 $1.20
229880 2022-08-11 $10.31 First-Class Package Service 2 0.09 lbs $4.78 $3.58 $1.20
229882 2022-08-12 $6.94 USPS First Class 1 0.05 lbs $4.75 $3.58 $1.17
229884 2022-08-12 $7.15 First-Class Package Service 1 0.00 lbs $4.59 $3.39 $1.20
229885 2022-08-13 $8.42 USPS Shipping 2 0.30 lbs $0.00 $4.42 $-4.42
229886 2022-08-14 $25.04 First-Class Package Service 2 0.16 lbs $5.06 $4.15 $0.91
229889 2022-08-14 $9.79 First-Class Package Service 4 0.04 lbs $4.68 $3.48 $1.20
229892 2022-08-15 $33.24 USPS Priority Mail 1 4.75 lbs $11.25 $8.34 $2.91
229893 2022-08-15 $14.94 USPS First Class 1 0.20 lbs $4.65 $3.81 $0.84
229894 2022-08-15 $16.25 First-Class Package Service 1 0.30 lbs $4.99 $3.79 $1.20
229895 2022-08-15 $13.27 First-Class Package Service 1 0.10 lbs $4.62 $3.42 $1.20
229900 2022-08-16 $25.34 First-Class Package Service 1 0.30 lbs $5.35 $4.15 $1.20
229901 2022-08-16 $49.82 Priority Mail 1 1.55 lbs $9.12 $8.25 $0.87
229902 2022-08-16 $7.49 First-Class Package Service 2 0.02 lbs $5.06 $3.86 $1.20
229903 2022-08-16 $42.60 First-Class Package Service 11 0.62 lbs $7.31 $4.83 $2.48
229906 2022-08-17 $160.50 Priority Mail 1 12.90 lbs $16.81 $16.40 $0.41
229907 2022-08-17 $31.74 USPS First Class 1 0.75 lbs $6.25 $6.28 $-0.03
229908 2022-08-17 $12.54 USPS First Class 1 0.04 lbs $4.65 $3.42 $1.23
229910 2022-08-17 $14.34 First-Class Package Service 1 0.10 lbs $4.92 $3.72 $1.20
229911 2022-08-17 $13.41 First-Class Package Service 2 0.06 lbs $4.78 $3.58 $1.20
229913 2022-08-17 $8.87 First-Class Package Service 6 0.12 lbs $4.78 $3.58 $1.20
229916 2022-08-18 $12.20 First-Class Package Service 1 0.50 lbs $7.06 $4.83 $2.23
229917 2022-08-18 $76.67 Priority Mail 1 3.90 lbs $10.92 $9.82 $1.10
229940 2022-08-18 $12.41 First-Class Package Service 2 0.11 lbs $4.78 $3.98 $0.80
229955 2022-08-19 $8.69 USPS First Class 1 0.05 lbs $4.70 $3.48 $1.22
229956 2022-08-19 $27.75 USPS Shipping 1 1.19 lbs $0.00 $8.49 $-8.49
229957 2022-08-19 $65.61 Priority Mail Padded Flat Rate Envelope 2 2.20 lbs $9.55 $8.45 $1.10
229958 2022-08-19 $13.89 First-Class Package Service 3 0.15 lbs $4.62 $3.42 $1.20
229975 2022-08-20 $11.06 First-Class Package Service 1 0.10 lbs $4.92 $3.72 $1.20
229976 2022-08-20 $11.69 USPS First Class 1 0.10 lbs $5.00 $3.86 $1.14
229977 2022-08-20 $11.19 USPS First Class 1 0.02 lbs $4.70 $3.48 $1.22
229980 2022-08-20 $59.20 Selected States in United States 5 0.39 lbs $5.09 $4.39 $0.70
229982 2022-08-21 $10.92 First-Class Package Service 1 0.04 lbs $4.78 $3.58 $1.20
229983 2022-08-21 $17.56 First-Class Package Service 2 0.10 lbs $5.06 $3.86 $1.20
229984 2022-08-21 $48.63 Priority Mail 3 1.32 lbs $12.06 $10.96 $1.10
229987 2022-08-21 $8.76 First-Class Package Service 1 0.05 lbs $4.62 $3.42 $1.20
229988 2022-08-22 $39.69 USPS First Class 1 0.13 lbs $4.70 $3.48 $1.22
229989 2022-08-22 $12.54 USPS First Class 1 0.06 lbs $4.65 $3.42 $1.23
229990 2022-08-22 $7.91 First-Class Package Service 2 0.06 lbs $4.78 $3.58 $1.20
229991 2022-08-22 $17.87 First-Class Package Service 1 0.35 lbs $5.88 $4.68 $1.20
229992 2022-08-22 $60.08 Priority Mail Small Flat Rate Box 1 1.45 lbs $9.35 $8.25 $1.10
229993 2022-08-22 $33.78 Priority Mail 1 0.95 lbs $12.72 $11.62 $1.10
229994 2022-08-22 $25.00 First-Class Package Service 1 0.30 lbs $5.01 $3.81 $1.20
229995 2022-08-22 $13.20 First-Class Package Service 1 0.07 lbs $5.06 $3.86 $1.20
229999 2022-08-23 $7.76 First-Class Package Service 1 0.02 lbs $4.62 $3.42 $1.20
230000 2022-08-23 $12.79 USPS First Class 1 0.06 lbs $4.80 $3.72 $1.08
230001 2022-08-23 $9.59 USPS First Class 1 0.04 lbs $4.80 $3.72 $1.08
230002 2022-08-23 $8.19 USPS First Class 1 0.05 lbs $4.80 $3.72 $1.08
230003 2022-08-23 $36.30 Priority Mail 8 1.86 lbs $10.08 $8.88 $1.20
230005 2022-08-23 $9.24 Priority Mail 1 1.15 lbs $9.59 $8.49 $1.10
230006 2022-08-23 $17.06 First-Class Package Service 1 0.15 lbs $5.01 $3.81 $1.20
230007 2022-08-23 $9.82 First-Class Package Service 1 0.10 lbs $4.68 $3.48 $1.20
230008 2022-08-23 $44.94 Priority Mail Flat Rate Envelope 1 3.55 lbs $8.85 $8.45 $0.40
230012 2022-08-24 $91.05 Priority Mail Padded Flat Rate Envelope 1 2.10 lbs $9.55 $8.45 $1.10
230013 2022-08-24 $8.56 First-Class Package Service 1 0.04 lbs $4.92 $3.72 $1.20
230015 2022-08-24 $6.16 USPS First-Class Mail or Priority Mail 1 0.05 lbs $4.42 $3.42 $1.00
230016 2022-08-24 $18.90 First-Class Package Service 1 0.68 lbs $6.91 $6.36 $0.55
230017 2022-08-24 $11.65 First-Class Package Service 2 0.08 lbs $4.62 $3.42 $1.20
230018 2022-08-24 $52.34 Priority Mail Small Flat Rate Box 1 1.40 lbs $9.35 $8.10 $1.25
230021 2022-08-25 $11.72 First-Class Package Service 1 0.05 lbs $5.06 $3.86 $1.20
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56