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
230022 2022-08-25 $15.04 USPS First Class 1 0.10 lbs $4.75 $3.58 $1.17
230023 2022-08-25 $26.79 USPS First Class 1 0.80 lbs $7.30 $5.72 $1.58
230024 2022-08-25 $19.80 Priority Mail Flat Rate Envelope 5 0.23 lbs $8.85 $8.25 $0.60
230026 2022-08-25 $18.63 Priority Mail Flat Rate Envelope 2 0.90 lbs $8.85 $8.25 $0.60
230027 2022-08-26 $7.54 First-Class Package Service 3 0.03 lbs $4.92 $3.72 $1.20
230028 2022-08-26 $29.86 USPS Parcel Select Ground 1 0.69 lbs $7.87 $7.42 $0.45
230034 2022-08-26 $13.93 USPS First Class 1 0.04 lbs $5.06 $3.86 $1.20
230035 2022-08-26 $28.20 Priority Mail 2 0.84 lbs $9.59 $7.90 $1.69
230037 2022-08-26 $47.83 Priority Mail Small Flat Rate Box 1 1.25 lbs $9.35 $8.25 $1.10
230040 2022-08-27 $20.04 Priority Mail 2 1.00 lbs $12.06 $10.96 $1.10
230041 2022-08-27 $43.94 Priority Mail Small Flat Rate Box 1 1.30 lbs $9.35 $8.25 $1.10
230048 2022-08-27 $9.79 USPS First Class 1 0.06 lbs $5.00 $3.86 $1.14
230049 2022-08-27 $8.89 USPS First Class 1 0.15 lbs $4.60 $3.79 $0.81
230050 2022-08-27 $17.57 Priority Mail 2 1.00 lbs $9.59 $8.49 $1.10
230051 2022-08-27 $50.20 Priority Mail 2 1.30 lbs $10.22 $9.12 $1.10
230054 2022-08-28 $69.11 Priority Mail Padded Flat Rate Envelope 5 1.70 lbs $9.55 $8.25 $1.30
230055 2022-08-28 $44.24 First-Class Package Service 2 0.75 lbs $7.06 $6.51 $0.55
230056 2022-08-28 $12.95 First-Class Package Service 1 0.06 lbs $5.06 $3.86 $1.20
230057 2022-08-28 $39.06 Priority Mail Small Flat Rate Box 1 1.30 lbs $9.35 $8.25 $1.10
230059 2022-08-28 $67.16 Ground 4 1.65 lbs $19.41 $7.42 $11.99
230060 2022-08-29 $12.74 USPS First Class 1 0.12 lbs $4.75 $3.58 $1.17
230061 2022-08-29 $11.74 USPS First Class 1 0.05 lbs $4.65 $3.42 $1.23
230062 2022-08-29 $12.54 USPS First Class 1 0.04 lbs $4.65 $3.42 $1.23
230063 2022-08-29 $36.00 First-Class Package Service 3 0.75 lbs $6.91 $5.96 $0.95
230064 2022-08-29 $90.00 Priority Mail Small Flat Rate Box 1 2.60 lbs $9.35 $8.25 $1.10
230065 2022-08-29 $53.80 Priority Mail 1 4.10 lbs $13.81 $50.84 $-37.03
230066 2022-08-29 $7.96 First-Class Package Service 1 0.16 lbs $4.62 $15.24 $-10.62
230068 2022-08-29 $57.72 First-Class Package Service 1 0.85 lbs $6.73 $22.12 $-15.39
230069 2022-08-30 $12.29 First-Class Package Service 8 0.08 lbs $4.92 $14.88 $-9.96
230071 2022-08-30 $11.80 First-Class Package Service 3 0.22 lbs $4.99 $15.16 $-10.17
230072 2022-08-30 $10.84 USPS First Class 1 0.10 lbs $4.65 $13.68 $-9.03
230073 2022-08-30 $8.42 USPS Shipping 1 0.15 lbs $0.00 $30.56 $-30.56
230075 2022-08-30 $6.63 Selected States in United States 1 0.01 lbs $3.99 $3.72 $0.27
230076 2022-08-31 $14.91 First-Class Package Service 1 0.05 lbs $4.92 $3.72 $1.20
230079 2022-08-31 $64.17 UPS Ground 1 2.54 lbs $14.18 $12.16 $2.02
230082 2022-08-31 $26.86 Priority Mail Flat Rate Envelope 6 0.72 lbs $6.92 $8.10 $-1.18
230083 2022-08-31 $241.44 Priority Mail 1 14.05 lbs $24.94 $17.09 $7.85
230084 2022-08-31 $9.56 First-Class Package Service 1 0.03 lbs $4.92 $3.72 $1.20
230085 2022-09-01 $15.04 USPS First Class 1 0.20 lbs $4.75 $3.58 $1.17
230086 2022-09-01 $60.84 USPS First Class 1 0.55 lbs $5.85 $4.39 $1.46
230087 2022-09-01 $40.84 First-Class Package Service 5 0.15 lbs $5.19 $3.99 $1.20
230092 2022-09-01 $14.57 First-Class Package Service 5 0.15 lbs $4.62 $3.42 $1.20
230093 2022-09-02 $8.14 USPS First Class 1 0.05 lbs $4.75 $3.58 $1.17
230094 2022-09-02 $8.72 USPS Shipping 1 0.15 lbs $0.00 $4.15 $-4.15
230095 2022-09-02 $37.76 First-Class Package Service 2 0.12 lbs $4.78 $3.88 $0.90
230096 2022-09-03 $20.08 First-Class Package Service 1 0.30 lbs $5.08 $3.88 $1.20
230097 2022-09-03 $8.54 USPS First Class 1 0.10 lbs $4.65 $3.42 $1.23
230098 2022-09-03 $16.39 USPS First Class 1 0.14 lbs $4.70 $3.48 $1.22
230099 2022-09-03 $27.16 First-Class Package Service 2 0.55 lbs $5.88 $4.68 $1.20
230100 2022-09-03 $11.59 First-Class Package Service 2 0.06 lbs $5.06 $3.86 $1.20
230101 2022-09-03 $25.40 First-Class Package Service 3 0.47 lbs $6.03 $4.83 $1.20
230104 2022-09-04 $11.72 First-Class Package Service 1 0.10 lbs $5.06 $3.86 $1.20
230106 2022-09-04 $31.76 Priority Mail 1 0.65 lbs $6.77 $8.25 $-1.48
230107 2022-09-04 $28.11 First-Class Package Service 5 0.33 lbs $5.19 $3.99 $1.20
230109 2022-09-04 $16.98 Priority Mail Flat Rate Envelope 2 0.06 lbs $8.85 $7.75 $1.10
230111 2022-09-05 $71.09 USPS Priority Mail 1 1.20 lbs $16.10 $8.45 $7.65
230112 2022-09-05 $9.79 USPS First Class 1 0.04 lbs $5.00 $3.86 $1.14
230113 2022-09-05 $11.49 USPS First Class 1 0.06 lbs $4.60 $3.39 $1.21
230114 2022-09-05 $17.94 First-Class Package Service 4 0.25 lbs $5.08 $3.88 $1.20
230115 2022-09-05 $9.34 USPS Shipping 1 0.25 lbs $5.35 $3.88 $1.47
230116 2022-09-05 $10.31 First-Class Package Service 2 0.09 lbs $4.78 $3.58 $1.20
230119 2022-09-06 $8.11 First-Class Package Service 2 0.02 lbs $4.78 $3.58 $1.20
230120 2022-09-06 $25.03 Priority Mail Medium Flat Rate Box 2 0.25 lbs $15.35 $8.25 $7.10
230121 2022-09-06 $33.33 USPS First-Class Mail or Priority Mail 1 1.30 lbs $17.66 $8.45 $9.21
230122 2022-09-06 $9.56 First-Class Package Service 1 0.03 lbs $4.92 $3.72 $1.20
230123 2022-09-06 $14.06 First-Class Package Service 2 0.22 lbs $5.08 $3.58 $1.50
230124 2022-09-06 $11.09 USPS First Class 1 0.03 lbs $4.60 $3.39 $1.21
230126 2022-09-07 $24.09 Priority Mail Flat Rate Envelope 6 1.14 lbs $8.85 $8.45 $0.40
230127 2022-09-07 $7.76 First-Class Package Service 1 0.01 lbs $4.62 $3.42 $1.20
230129 2022-09-07 $9.79 USPS First Class 1 0.04 lbs $5.00 $3.86 $1.14
230130 2022-09-07 $15.29 USPS First Class 1 0.10 lbs $5.00 $3.86 $1.14
230132 2022-09-08 $12.54 USPS First Class 1 0.06 lbs $4.65 $3.42 $1.23
230133 2022-09-08 $13.11 USPS First-Class Mail or Priority Mail 1 0.27 lbs $4.81 $3.81 $1.00
230135 2022-09-08 $58.44 Priority Mail Small Flat Rate Box 1 1.50 lbs $9.35 $8.25 $1.10
230136 2022-09-09 $8.64 USPS First Class 1 0.05 lbs $4.65 $3.42 $1.23
230137 2022-09-09 $7.89 USPS First Class 1 0.06 lbs $5.00 $3.86 $1.14
230139 2022-09-09 $15.09 First-Class Package Service 3 0.12 lbs $4.62 $3.42 $1.20
230140 2022-09-09 $10.19 First-Class Package Service 2 0.06 lbs $5.06 $3.86 $1.20
230141 2022-09-10 $12.54 USPS First Class 1 0.06 lbs $4.65 $3.42 $1.23
230142 2022-09-10 $9.59 USPS First Class 1 0.04 lbs $4.80 $3.72 $1.08
230143 2022-09-10 $14.69 USPS First Class 1 0.05 lbs $4.70 $3.48 $1.22
230144 2022-09-10 $18.96 USPS First-Class Mail or Priority Mail 1 0.08 lbs $4.86 $3.86 $1.00
230149 2022-09-10 $2.99 First-Class Package Service 1 0.02 lbs $0.00 $3.86 $-3.86
230151 2022-09-11 $44.58 Priority Mail Small Flat Rate Box 1 1.25 lbs $9.35 $8.25 $1.10
230153 2022-09-11 $38.93 Priority Mail Small Flat Rate Box 1 1.30 lbs $9.35 $8.25 $1.10
230155 2022-09-12 $9.44 USPS First Class 1 0.10 lbs $4.65 $3.42 $1.23
230156 2022-09-12 $19.57 Priority Mail 2 0.66 lbs $9.59 $7.90 $1.69
230157 2022-09-12 $26.97 First-Class Package Service 1 0.60 lbs $5.78 $4.83 $0.95
230159 2022-09-13 $10.32 First-Class Package Service 1 0.05 lbs $4.68 $3.48 $1.20
230161 2022-09-13 $19.80 Priority Mail Flat Rate Envelope 5 0.23 lbs $8.85 $8.25 $0.60
230162 2022-08-31 $9.66 Priority Mail Flat Rate Envelope 2 0.16 lbs $4.68 $4.27 $0.41
230163 2022-09-14 $12.45 Priority Mail Flat Rate Envelope 5 5.00 lbs $8.85 $7.75 $1.10
230164 2022-09-14 $12.59 USPS First Class 1 0.06 lbs $4.70 $3.48 $1.22
230165 2022-09-16 $12.19 USPS First Class 1 0.05 lbs $4.70 $3.48 $1.22
230166 2022-09-17 $16.08 USPS Parcel Select Ground 1 0.83 lbs $8.09 $8.09 $0.00
230167 2022-09-17 $19.19 USPS First Class 1 0.45 lbs $5.20 $3.81 $1.39
230168 2022-09-17 $25.45 Priority Mail 3 1.20 lbs $10.22 $9.12 $1.10
230169 2022-09-18 $19.00 First-Class Package Service 1 0.31 lbs $5.01 $3.81 $1.20
230172 2022-09-19 $25.19 USPS First Class 1 0.45 lbs $5.20 $3.81 $1.39
230173 2022-09-19 $24.00 First-Class Package Service 2 0.03 lbs $4.92 $3.72 $1.20
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56