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
226919 2021-08-26 $246.78 Ground Home Delivery 11 9.41 lbs $31.61 $24.32 $7.29
226922 2021-08-26 $51.64 Priority Mail 3-Day 2 0.30 lbs $9.95 $7.88 $2.07
226924 2021-08-26 $24.71 First-Class Package Service 2 0.60 lbs $5.73 $4.53 $1.20
226927 2021-08-27 $33.34 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $9.00 $7.90 $1.10
226930 2021-08-27 $14.32 First-Class Package Service 2 0.10 lbs $4.42 $3.22 $1.20
226931 2021-08-27 $23.75 USPSFirstClass 2 0.20 lbs $4.77 $3.69 $1.08
226932 2021-08-27 $5.04 USPSFirstClass 1 0.01 lbs $4.05 $3.01 $1.04
226933 2021-08-27 $12.73 USPSFirstClass 1 0.06 lbs $4.84 $3.49 $1.35
226934 2021-08-27 $12.59 USPSFirstClass 1 0.06 lbs $4.60 $3.12 $1.48
226935 2021-08-27 $12.84 USPSFirstClass 1 0.06 lbs $4.85 $3.49 $1.36
226937 2021-08-27 $22.94 Priority Mail 3-Day 1 0.95 lbs $9.95 $7.88 $2.07
226945 2021-08-28 $9.70 USPSFirstClass 1 0.10 lbs $4.51 $3.22 $1.29
226946 2021-08-28 $52.68 USPSFirstClass 6 0.38 lbs $5.34 $3.57 $1.77
226947 2021-08-27 $27.75 Ground Home Delivery 1 0.45 lbs $14.68 $14.32 $0.36
226948 2021-08-27 $17.12 Priority Mail 2-Day 1 0.30 lbs $8.80 $7.90 $0.90
226950 2021-08-27 $21.24 Priority Mail 3-Day 1 0.95 lbs $8.25 $7.67 $0.58
226951 2021-08-28 $12.54 USPSFirstClass 1 0.06 lbs $4.55 $3.06 $1.49
226952 2021-08-28 $12.48 USPSFirstClass 1 0.06 lbs $4.59 $3.12 $1.47
226953 2021-08-28 $8.23 USPSFirstClass 1 0.25 lbs $4.34 $3.51 $0.83
226956 2021-08-28 $19.96 First-Class Package Service 2 0.25 lbs $4.89 $3.35 $1.54
226959 2021-08-28 $16.75 First-Class Package Service 2 0.30 lbs $4.77 $3.57 $1.20
226960 2021-08-28 $10.71 First-Class Mail Stamped Letter 1 0.05 lbs $3.93 $3.12 $0.81
226964 2021-08-29 $11.13 USPSFirstClass 3 0.03 lbs $4.56 $3.49 $1.07
226965 2021-08-29 $12.87 USPSFirstClass 2 0.50 lbs $5.09 $4.12 $0.97
226966 2021-08-29 $12.48 USPSFirstClass 1 0.06 lbs $4.59 $3.12 $1.47
226967 2021-08-29 $24.28 USPSFirstClass 2 0.68 lbs $6.30 $5.81 $0.49
226968 2021-08-29 $20.68 USPSFirstClass 2 0.12 lbs $4.70 $3.35 $1.35
226970 2021-08-29 $34.04 First-Class Package Service 8 0.55 lbs $6.22 $5.27 $0.95
226971 2021-08-29 $138.05 United States 8 5.10 lbs $13.95 $12.13 $1.82
226974 2021-08-30 $12.73 USPSFirstClass 1 0.04 lbs $4.84 $3.49 $1.35
226975 2021-08-29 $9.75 First-Class Mail Stamped Letter 1 0.09 lbs $4.13 $3.35 $0.78
226977 2021-08-30 $8.56 First-Class Package Service 1 0.20 lbs $4.77 $3.57 $1.20
226978 2021-08-30 $11.05 USPSFirstClass 1 0.08 lbs $4.76 $3.49 $1.27
226979 2021-08-30 $7.23 USPSFirstClass 1 0.05 lbs $4.44 $3.35 $1.09
226980 2021-08-30 $10.33 USPSFirstClass 2 0.07 lbs $4.35 $3.12 $1.23
226981 2021-08-30 $8.79 First-Class Mail Stamped Letter 1 0.05 lbs $3.93 $3.49 $0.44
226983 2021-08-30 $25.78 Priority Mail 2-Day 1 0.95 lbs $12.79 $8.80 $3.99
226985 2021-08-30 $11.64 USPSFirstClass 1 0.10 lbs $4.65 $3.35 $1.30
226986 2021-08-30 $44.77 First-Class Package Service 2 0.73 lbs $7.18 $5.98 $1.20
226988 2021-08-30 $7.92 First-Class Mail Stamped Letter 1 0.08 lbs $3.93 $3.35 $0.58
226990 2021-08-30 $72.41 Priority Mail 2-Day Medium Flat Rate Box 1 5.30 lbs $15.40 $13.75 $1.65
226995 2021-08-31 $9.70 USPSFirstClass 1 0.10 lbs $4.51 $3.22 $1.29
226996 2021-08-31 $43.17 Priority Mail 3-Day Flat Rate Envelope 3 0.90 lbs $8.50 $7.90 $0.60
226999 2021-08-31 $40.94 United States 6 0.44 lbs $5.00 $3.85 $1.15
227003 2021-08-31 $38.43 United States 3 0.85 lbs $6.00 $7.90 $-1.90
227004 2021-08-31 $92.98 Priority Mail 2-Day 2 2.44 lbs $13.80 $10.89 $2.91
227006 2021-09-01 $38.79 USPSFirstClass 1 0.20 lbs $5.80 $3.06 $2.74
227007 2021-09-01 $12.58 USPSFirstClass 1 0.06 lbs $4.69 $3.35 $1.34
227008 2021-09-01 $9.28 USPSFirstClass 1 0.05 lbs $4.39 $3.06 $1.33
227009 2021-09-01 $14.43 USPSFirstClass 2 0.12 lbs $4.45 $3.12 $1.33
227010 2020-12-10 $175.45 Priority Mail 2-Day Medium Flat Rate Box 5 4.81 lbs $10.00 $10.89 $-0.89
227013 2021-09-01 $113.97 Next Day Air Saver 1 0.85 lbs $53.98 $43.29 $10.69
227017 2021-09-02 $16.54 USPSFirstClass 1 0.40 lbs $5.55 $3.58 $1.97
227018 2021-09-02 $7.44 USPSFirstClass 1 0.02 lbs $4.45 $3.35 $1.10
227019 2021-09-02 $14.12 USPSFirstClass 2 0.12 lbs $4.54 $3.35 $1.19
227020 2021-09-02 $19.32 Priority Mail 3-Day 2 0.66 lbs $9.34 $8.24 $1.10
227021 2021-09-03 $11.40 USPSFirstClass 2 0.04 lbs $4.42 $3.22 $1.20
227022 2021-09-03 $15.53 USPSFirstClass 1 0.14 lbs $4.74 $3.12 $1.62
227023 2021-09-03 $7.92 First-Class Mail Stamped Letter 1 0.03 lbs $3.93 $3.35 $0.58
227026 2021-09-03 $25.64 First-Class Package Service 1 0.60 lbs $5.15 $4.20 $0.95
227028 2021-09-03 $5.93 United States 2 0.02 lbs $3.95 $3.35 $0.60
227030 2021-09-03 $28.31 USPSFirstClass 3 0.12 lbs $4.64 $3.22 $1.42
227031 2021-09-03 $27.10 First-Class Package Service 1 0.65 lbs $6.61 $4.38 $2.23
227032 2021-09-03 $50.24 United States 1 1.20 lbs $8.75 $11.69 $-2.94
227033 2021-09-03 $41.54 Selected States in United States 1 1.40 lbs $8.75 $7.90 $0.85
227034 2021-09-03 $98.86 Priority Mail 1-Day 1 2.60 lbs $9.10 $7.83 $1.27
227037 2021-09-04 $15.58 USPSFirstClass 1 0.14 lbs $4.79 $3.22 $1.57
227038 2021-09-04 $7.38 USPSFirstClass 1 0.05 lbs $4.39 $3.35 $1.04
227039 2021-09-04 $14.69 USPSFirstClass 1 0.05 lbs $4.70 $3.12 $1.58
227040 2021-09-04 $97.08 Priority Mail 2-Day Padded Flat Rate Envelope 2 5.00 lbs $9.10 $8.00 $1.10
227041 2021-09-04 $21.70 USPSFirstClass 2 0.14 lbs $4.72 $3.35 $1.37
227042 2021-09-04 $130.09 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.42 lbs $9.10 $8.00 $1.10
227044 2021-09-04 $96.31 Ground 10 2.69 lbs $24.36 $19.12 $5.24
227046 2021-09-04 $10.91 First-Class Mail Stamped Letter 2 0.08 lbs $3.93 $3.49 $0.44
227049 2021-09-05 $12.58 USPSFirstClass 1 0.06 lbs $4.69 $3.35 $1.34
227050 2021-09-05 $8.28 USPSFirstClass 2 0.12 lbs $4.30 $3.12 $1.18
227051 2021-09-05 $20.83 USPSFirstClass 2 0.12 lbs $4.85 $3.49 $1.36
227052 2021-09-05 $21.84 USPSFirstClass 1 0.05 lbs $4.85 $3.01 $1.84
227053 2021-09-05 $11.41 First-Class Mail Stamped Letter 2 0.06 lbs $3.93 $3.35 $0.58
227055 2021-09-05 $30.61 USPSPriority 1 0.95 lbs $10.12 $11.01 $-0.89
227056 2021-09-05 $12.58 USPSFirstClass 1 0.04 lbs $4.69 $3.35 $1.34
227057 2021-09-05 $11.10 USPSFirstClass 2 0.12 lbs $4.32 $3.06 $1.26
227058 2021-09-05 $22.09 USPSFirstClass 1 0.05 lbs $5.10 $3.22 $1.88
227059 2021-09-05 $39.28 Priority Mail 3-Day 1 0.57 lbs $12.79 $8.80 $3.99
227060 2021-09-06 $23.57 First-Class Package Service 1 0.45 lbs $5.58 $3.58 $2.00
227061 2021-09-06 $14.34 USPSFirstClass 1 0.34 lbs $5.35 $3.51 $1.84
227062 2021-09-06 $12.43 USPSFirstClass 1 0.06 lbs $4.54 $3.06 $1.48
227063 2021-09-06 $18.76 First-Class Package Service 2 0.34 lbs $4.78 $4.38 $0.40
227064 2021-09-06 $21.49 Selected States in United States 1 0.95 lbs $8.50 $8.34 $0.16
227068 2021-09-06 $65.81 Ground 10 0.96 lbs $26.91 $21.07 $5.84
227069 2021-09-07 $266.58 USPSFirstClass 60 11.93 lbs $135.18 $48.62 $86.56
227070 2021-09-07 $24.84 USPSFirstClass 1 0.28 lbs $5.85 $3.51 $2.34
227071 2021-09-07 $16.03 Selected States in United States 12 0.20 lbs $4.15 $3.49 $0.66
227073 2021-09-07 $6.91 USPSFirstClass 1 0.01 lbs $4.42 $3.35 $1.07
227075 2021-09-07 $21.15 Priority Mail 3-Day 2 0.15 lbs $8.77 $7.67 $1.10
227076 2021-09-08 $13.37 USPSFirstClass 1 0.08 lbs $4.68 $3.58 $1.10
227077 2021-09-08 $45.54 Priority Mail 2-Day 1 1.30 lbs $8.89 $7.90 $0.99
227078 2021-09-08 $98.31 First-Class Package Service 13 0.76 lbs $7.01 $3.69 $3.32
227079 2021-09-08 $216.37 Priority Mail 2-Day Medium Flat Rate Box 3 4.12 lbs $15.40 $11.42 $3.98
227083 2021-09-08 $41.49 United States 1 1.00 lbs $8.50 $8.25 $0.25
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56