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
222870 2021-03-02 $71.83 Priority Mail 2-Day Padded Flat Rate Envelope 2 2.30 lbs $8.85 $8.00 $0.85
222871 2021-03-02 $16.17 First-Class Mail Stamped Letter 3 0.06 lbs $3.20 $3.12 $0.08
222873 2021-03-02 $12.17 First-Class Mail Stamped Letter 3 0.10 lbs $3.20 $3.22 $-0.02
222876 2021-03-02 $8.61 First-Class Package Service 1 0.05 lbs $3.62 $3.12 $0.50
222878 2021-03-02 $4.99 First-Class Mail Stamped Letter 1 0.01 lbs $3.00 $3.06 $-0.06
222879 2021-03-02 $9.43 USPSFirstClass 1 0.04 lbs $4.54 $3.35 $1.19
222880 2021-03-02 $13.38 First-Class Mail Stamped Letter 2 0.12 lbs $3.40 $3.22 $0.18
222881 2021-02-28 $36.06 First-Class Package Service 7 0.83 lbs $10.11 $8.00 $2.11
222882 2021-03-02 $49.69 Priority Mail 2-Day 1 1.20 lbs $9.70 $8.85 $0.85
222885 2021-03-02 $56.54 Priority Mail 2-Day 1 2.20 lbs $13.55 $10.89 $2.66
222887 2021-03-02 $7.28 USPSFirstClass 1 0.10 lbs $4.39 $3.22 $1.17
222889 2021-03-02 $6.61 USPSFirstClass 1 0.01 lbs $4.12 $3.01 $1.11
222890 2021-03-02 $27.15 First-Class Package Service 3 0.52 lbs $5.18 $4.68 $0.50
222892 2021-03-02 $56.54 Priority Mail 3-Day 1 2.20 lbs $13.55 $10.89 $2.66
222894 2021-03-02 $12.89 First-Class Package Service 2 0.20 lbs $4.19 $3.35 $0.84
222895 2021-03-02 $16.27 First-Class Package Service 2 0.20 lbs $4.35 $3.85 $0.50
222897 2021-03-02 $345.80 Ground 8 17.60 lbs $46.68 $108.32 $-61.64
222898 2021-03-02 $16.86 First-Class Package Service 2 0.52 lbs $4.88 $4.38 $0.50
222900 2021-03-02 $241.00 Priority Mail 3-Day Medium Flat Rate Box 8 16.02 lbs $15.00 $11.42 $3.58
222903 2021-03-02 $33.25 Priority Mail 3-Day 4 1.60 lbs $11.29 $10.44 $0.85
222906 2021-03-02 $7.99 First-Class Mail Stamped Letter 1 0.02 lbs $3.00 $3.35 $-0.35
222908 2021-03-02 $51.85 Priority Mail 3-Day 1 1.20 lbs $11.86 $11.63 $0.23
222910 2021-03-02 $13.24 Priority Mail 2-Day Flat Rate Envelope 1 0.05 lbs $8.25 $7.90 $0.35
222911 2021-03-02 $37.32 Priority Mail 2-Day Flat Rate Envelope 18 0.98 lbs $8.50 $7.90 $0.60
222912 2021-03-02 $100.31 Priority Mail 2-Day 24 2.94 lbs $19.81 $12.13 $7.68
222914 2021-03-03 $75.88 2-Day 1 1.70 lbs $32.89 $26.70 $6.19
222915 2021-03-03 $23.92 First-Class Package Service 3 0.20 lbs $4.35 $3.49 $0.86
222916 2021-03-03 $72.53 Priority Mail 2-Day Medium Flat Rate Box 3 4.64 lbs $15.00 $19.59 $-4.59
222917 2021-03-03 $93.24 Priority Mail 2-Day Small Flat Rate Box 1 2.30 lbs $8.75 $7.90 $0.85
222918 2021-03-03 $9.33 USPSFirstClass 1 0.05 lbs $4.44 $3.12 $1.32
222919 2021-03-03 $8.44 USPSFirstClass 1 0.09 lbs $4.45 $3.22 $1.23
222920 2021-03-03 $27.04 USPSFirstClass 1 0.35 lbs $6.05 $4.38 $1.67
222921 2021-03-03 $31.09 USPSPriority 1 1.70 lbs $11.10 $8.34 $2.76
222923 2021-03-03 $26.34 First-Class Package Service 19 0.52 lbs $5.03 $4.53 $0.50
222924 2021-03-03 $18.23 USPSFirstClass 1 0.17 lbs $4.92 $3.58 $1.34
222926 2021-03-03 $28.45 Priority Mail 2-Day Flat Rate Envelope 2 0.70 lbs $6.47 $5.27 $1.20
222928 2021-03-03 $46.84 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.40 lbs $8.85 $8.24 $0.61
222930 2021-03-03 $11.08 First-Class Package Service 4 0.65 lbs $4.62 $3.06 $1.56
222931 2021-03-03 $39.67 Priority Mail 2-Day Flat Rate Envelope 2 1.10 lbs $8.25 $7.90 $0.35
222934 2021-03-03 $36.81 First-Class Package Service 4 0.43 lbs $4.35 $3.85 $0.50
222935 2021-03-03 $6.19 First-Class Mail Stamped Letter 1 0.04 lbs $3.20 $3.22 $-0.02
222936 2021-03-03 $52.25 First-Class Package Service 2 0.30 lbs $4.35 $3.85 $0.50
222938 2021-03-04 $7.48 USPSFirstClass 1 0.10 lbs $4.59 $3.49 $1.10
222939 2021-03-03 $128.97 Priority Mail 2-Day 3 4.45 lbs $0.00 $8.88 $-8.88
222940 2021-03-03 $295.33 Ground 2 24.20 lbs $38.20 $26.62 $11.58
222943 2021-03-03 $84.03 Priority Mail 3-Day Flat Rate Envelope 2 2.40 lbs $8.25 $8.45 $-0.20
222945 2021-03-03 $16.14 First-Class Package Service 1 0.35 lbs $4.35 $3.85 $0.50
222946 2021-03-03 $15.24 Priority Mail 2-Day Flat Rate Envelope 1 0.05 lbs $8.25 $7.90 $0.35
222948 2021-03-03 $60.58 Priority Mail 2-Day 6 5.77 lbs $10.98 $8.24 $2.74
222949 2021-03-03 $28.53 Priority Mail 2-Day 1 0.70 lbs $12.54 $8.80 $3.74
222951 2021-03-04 $9.39 First-Class Mail Stamped Letter 1 0.10 lbs $3.40 $3.35 $0.05
222952 2021-03-04 $59.53 Priority Mail 3-Day 2 1.73 lbs $13.55 $12.70 $0.85
222956 2021-03-04 $59.08 USPSPriority 1 2.54 lbs $15.00 $23.90 $-8.90
222957 2021-03-04 $9.47 USPSFirstClass 1 0.25 lbs $4.45 $3.57 $0.88
222958 2021-03-04 $11.41 USPSFirstClass 1 0.05 lbs $4.64 $3.69 $0.95
222959 2021-03-04 $26.10 Priority Mail 2-Day 1 1.60 lbs $9.09 $8.00 $1.09
222960 2021-03-04 $11.38 First-Class Mail Stamped Letter 2 0.10 lbs $3.40 $3.06 $0.34
222961 2021-03-04 $6.18 USPSFirstClass 1 0.01 lbs $4.29 $3.12 $1.17
222962 2021-03-04 $15.38 First-Class Mail Stamped Letter 2 0.10 lbs $3.40 $3.49 $-0.09
222963 2021-03-04 $41.46 Priority Mail 2-Day 8 1.40 lbs $12.54 $12.64 $-0.10
222964 2021-03-04 $8.56 First-Class Mail Stamped Letter 4 0.12 lbs $3.40 $3.06 $0.34
222965 2021-03-04 $57.99 Priority Mail 2-Day Medium Flat Rate Box 1 2.20 lbs $15.00 $12.64 $2.36
222967 2021-03-04 $7.75 First-Class Mail Stamped Letter 1 0.09 lbs $3.40 $3.06 $0.34
222968 2021-03-04 $7.08 First-Class Package Service 2 0.44 lbs $6.06 $3.69 $2.37
222969 2021-03-04 $14.01 First-Class Package Service 2 0.23 lbs $4.07 $3.12 $0.95
222970 2021-03-04 $31.57 Priority Mail 3-Day 2 1.65 lbs $9.09 $8.24 $0.85
222971 2021-03-04 $60.29 Priority Mail 2-Day 1 2.20 lbs $17.30 $12.64 $4.66
222972 2021-03-04 $5.64 First-Class Package Service 1 0.20 lbs $4.63 $3.58 $1.05
222973 2021-03-04 $9.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.12 $0.08
222975 2021-03-04 $9.90 First-Class Package Service 1 0.50 lbs $5.91 $4.38 $1.53
222976 2021-03-04 $70.10 Priority Mail 2-Day Flat Rate Envelope 5 3.59 lbs $8.25 $7.90 $0.35
222977 2021-03-04 $20.78 First-Class Package Service 1 0.49 lbs $5.91 $3.58 $2.33
222981 2021-03-05 $42.63 Priority Mail 3-Day Flat Rate Envelope 2 1.35 lbs $8.25 $7.90 $0.35
222982 2021-03-05 $7.33 USPSFirstClass 1 0.10 lbs $4.44 $3.35 $1.09
222983 2021-03-05 $20.99 USPSFirstClass 9 0.45 lbs $5.69 $3.06 $2.63
222984 2021-03-05 $11.92 USPSFirstClass 3 0.45 lbs $5.95 $4.53 $1.42
222985 2021-03-05 $32.94 USPSPriority 1 1.70 lbs $12.95 $10.44 $2.51
222987 2021-03-05 $62.97 Priority Mail 3-Day 2 2.38 lbs $10.49 $9.01 $1.48
222988 2021-03-05 $58.44 First-Class Package Service 4 0.76 lbs $6.48 $4.68 $1.80
222989 2021-03-05 $84.23 Priority Mail 2-Day Flat Rate Envelope 2 2.16 lbs $8.25 $7.90 $0.35
222990 2021-03-05 $69.09 Priority Mail 3-Day 20 1.60 lbs $12.54 $16.45 $-3.91
222992 2021-03-05 $8.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.35 $-0.15
222993 2021-03-05 $12.13 First-Class Mail Stamped Letter 7 0.08 lbs $3.20 $3.49 $-0.29
222996 2021-03-05 $11.51 First-Class Package Service 1 0.04 lbs $3.72 $3.22 $0.50
222997 2021-03-05 $64.59 Ground 1 1.70 lbs $21.60 $14.32 $7.28
222998 2021-03-05 $8.64 First-Class Package Service 1 0.05 lbs $3.85 $3.35 $0.50
223000 2021-03-05 $82.46 Priority Mail 3-Day 1 5.65 lbs $15.17 $12.42 $2.75
223001 2021-03-05 $27.45 First-Class Package Service 11 0.37 lbs $3.96 $3.46 $0.50
223002 2021-03-05 $57.94 Priority Mail 2-Day 1 2.20 lbs $14.95 $11.63 $3.32
223003 2021-03-05 $8.73 First-Class Package Service 6 0.23 lbs $4.19 $3.69 $0.50
223006 2021-03-05 $5.83 First-Class Package Service 2 0.02 lbs $3.85 $3.35 $0.50
223007 2021-03-06 $56.58 USPSFirstClass 6 0.30 lbs $27.24 $3.69 $23.55
223008 2021-03-05 $24.41 Priority Mail 2-Day Padded Flat Rate Envelope 4 0.60 lbs $8.85 $7.90 $0.95
223009 2021-03-05 $22.19 Priority Mail 3-Day Flat Rate Envelope 6 0.08 lbs $8.25 $7.90 $0.35
223010 2021-03-05 $9.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.12 $0.08
223011 2021-03-05 $34.70 First-Class Package Service 1 0.30 lbs $4.62 $3.51 $1.11
223012 2021-03-05 $66.28 Priority Mail 2-Day 1 1.45 lbs $11.29 $10.44 $0.85
223013 2021-03-05 $25.28 Priority Mail 3-Day 1 1.12 lbs $11.29 $24.32 $-13.03
223015 2021-03-05 $35.00 First-Class Package Service 6 0.75 lbs $6.06 $11.01 $-4.95
223016 2021-03-06 $20.14 First-Class Package Service 3 0.69 lbs $5.67 $8.85 $-3.18
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56