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
230174 2022-09-19 $21.04 First-Class Package Service 1 0.45 lbs $5.88 $4.68 $1.20
230175 2022-09-20 $12.64 USPS First Class 1 0.06 lbs $4.75 $3.58 $1.17
230176 2022-09-20 $28.23 First-Class Package Service 4 0.28 lbs $5.01 $3.81 $1.20
230177 2022-09-20 $9.82 First-Class Package Service 1 0.05 lbs $4.68 $3.48 $1.20
230178 2022-09-20 $19.56 First-Class Package Service 3 0.04 lbs $4.59 $3.39 $1.20
230180 2022-09-21 $12.79 USPS First Class 1 0.06 lbs $5.00 $3.86 $1.14
230181 2022-09-21 $116.69 USPS Priority Mail 1 3.20 lbs $13.70 $13.08 $0.62
230182 2022-09-21 $68.43 Priority Mail International Small Flat Rate Box 4 0.06 lbs $30.27 $29.17 $1.10
230186 2022-09-21 $12.95 USPS First Class 1 0.06 lbs $5.06 $3.58 $1.48
230187 2022-09-21 $12.89 USPS First Class 1 0.06 lbs $5.00 $3.86 $1.14
230188 2022-09-21 $8.05 First-Class Package Service 2 0.03 lbs $4.92 $3.72 $1.20
230189 2022-09-22 $74.13 Priority Mail Medium Flat Rate Box 2 2.20 lbs $15.90 $7.75 $8.15
230191 2022-09-22 $54.84 Priority Mail 4 1.10 lbs $16.72 $15.62 $1.10
230192 2022-09-22 $9.19 USPS First Class 1 0.03 lbs $4.70 $3.48 $1.22
230195 2022-09-04 $31.76 Priority Mail 1 0.65 lbs $6.77 $5.82 $0.95
230197 2022-09-22 $96.49 Priority Mail 10 2.23 lbs $10.33 $8.31 $2.02
230198 2022-09-22 $12.94 First-Class Package Service 4 0.04 lbs $4.78 $3.58 $1.20
230199 2022-09-22 $49.94 First-Class Package International Service 5 0.09 lbs $26.29 $18.24 $8.05
230200 2022-09-23 $8.14 USPS First Class 1 0.05 lbs $4.75 $3.58 $1.17
230201 2022-09-23 $22.78 First-Class Package Service 3 0.33 lbs $5.07 $3.87 $1.20
230202 2022-09-23 $10.05 First-Class Package Service 4 0.11 lbs $4.94 $3.72 $1.22
230204 2022-09-23 $9.79 USPS First Class 1 0.04 lbs $5.00 $3.86 $1.14
230205 2022-09-24 $14.99 USPS First Class 1 0.05 lbs $5.00 $3.86 $1.14
230206 2022-09-24 $19.27 First-Class Package Service 1 0.28 lbs $5.07 $3.87 $1.20
230207 2022-09-24 $61.20 Priority Mail 2 1.65 lbs $20.13 $15.03 $5.10
230208 2022-09-25 $45.23 Priority Mail Small Flat Rate Box 1 1.25 lbs $9.35 $8.25 $1.10
230209 2022-09-26 $6.91 First-Class Package Service 2 0.04 lbs $4.78 $3.58 $1.20
230210 2022-09-26 $31.74 USPS First Class 1 0.75 lbs $6.25 $4.98 $1.27
230211 2022-09-26 $12.64 USPS First Class 1 0.06 lbs $4.75 $3.58 $1.17
230212 2022-09-26 $14.74 USPS First Class 1 0.05 lbs $4.75 $3.58 $1.17
230213 2022-09-26 $8.14 USPS First Class 1 0.05 lbs $4.65 $3.81 $0.84
230214 2022-09-26 $8.99 USPS First Class 1 0.01 lbs $5.00 $4.15 $0.85
230215 2022-09-26 $8.99 USPS First Class 1 0.01 lbs $5.00 $3.86 $1.14
230217 2022-09-26 $21.36 USPS First Class 4 0.28 lbs $5.40 $3.99 $1.41
230218 2022-09-26 $15.30 First-Class Package Service 1 0.20 lbs $5.01 $3.81 $1.20
230219 2022-09-27 $62.29 USPS First Class 1 0.80 lbs $7.30 $5.72 $1.58
230220 2022-09-27 $12.04 USPS First Class 1 0.06 lbs $4.65 $3.42 $1.23
230222 2022-09-27 $9.72 First-Class Package Service 1 0.05 lbs $4.68 $3.48 $1.20
230223 2022-09-27 $11.30 USPS Shipping 1 0.25 lbs $5.51 $7.87 $-2.36
230224 2022-09-27 $8.99 USPS First Class 1 0.01 lbs $5.00 $3.86 $1.14
230226 2022-09-28 $10.55 First-Class Package Service 2 0.09 lbs $4.92 $3.72 $1.20
230227 2022-09-28 $12.09 USPS First Class 1 0.25 lbs $4.80 $3.99 $0.81
230228 2022-09-28 $14.79 USPS First Class 1 0.05 lbs $4.80 $3.72 $1.08
230229 2022-09-28 $11.39 USPS First Class 1 0.10 lbs $4.70 $3.48 $1.22
230230 2022-09-28 $30.64 USPS First-Class Mail or Priority Mail 1 1.30 lbs $14.94 $10.96 $3.98
230231 2022-09-28 $12.89 USPS First Class 1 0.06 lbs $5.00 $3.86 $1.14
230232 2022-09-28 $14.49 USPS First Class 1 0.04 lbs $4.70 $3.48 $1.22
230234 2022-09-28 $58.43 Priority Mail Medium Flat Rate Box 5 2.77 lbs $15.90 $8.30 $7.60
230236 2022-09-29 $35.19 USPS First Class 1 0.40 lbs $5.20 $4.42 $0.78
230237 2022-09-30 $9.49 USPS First Class 1 0.10 lbs $4.70 $3.48 $1.22
230238 2022-09-30 $9.49 USPS First Class 1 0.07 lbs $4.70 $3.48 $1.22
230240 2022-09-30 $12.09 USPS First Class 1 0.06 lbs $4.70 $3.48 $1.22
230241 2022-09-30 $13.35 First-Class Package Service 2 0.05 lbs $4.59 $3.64 $0.95
230242 2022-09-30 $11.32 First-Class Package Service 1 0.10 lbs $4.78 $3.98 $0.80
230244 2022-10-01 $14.67 First-Class Package Service 1 0.05 lbs $5.18 $3.98 $1.20
230246 2022-10-02 $16.04 First-Class Package Service 1 0.20 lbs $5.75 $4.26 $1.49
230247 2022-10-02 $25.44 First-Class Package Service 4 0.20 lbs $5.48 $5.08 $0.40
230252 2022-10-03 $9.39 USPS First Class 1 0.15 lbs $5.40 $4.39 $1.01
230253 2022-10-03 $13.24 USPS First Class 1 0.06 lbs $5.35 $3.98 $1.37
230254 2022-10-03 $14.69 USPS First Class 1 0.05 lbs $4.70 $3.88 $0.82
230255 2022-10-03 $9.39 USPS First Class 1 0.15 lbs $5.40 $4.39 $1.01
230256 2022-10-03 $24.42 USPS Shipping 1 0.91 lbs $7.93 $8.27 $-0.34
230257 2022-10-03 $48.78 Priority Mail Medium Flat Rate Box 5 7.10 lbs $16.65 $15.00 $1.65
230259 2022-10-03 $16.95 Priority Mail 2 0.06 lbs $10.02 $9.00 $1.02
230260 2022-10-03 $27.81 First-Class Package Service 5 0.06 lbs $5.46 $4.26 $1.20
230261 2022-10-04 $9.11 USPS First-Class Mail or Priority Mail 1 0.05 lbs $4.67 $3.67 $1.00
230263 2022-10-04 $54.49 USPS Priority Mail 1 2.30 lbs $14.70 $10.73 $3.97
230264 2022-10-04 $13.09 First-Class Package Service 2 0.10 lbs $5.46 $4.26 $1.20
230265 2022-10-04 $15.59 USPS First Class 1 0.05 lbs $5.60 $4.26 $1.34
230266 2022-10-04 $14.97 First-Class Package Service 4 0.18 lbs $5.21 $3.62 $1.59
230267 2022-10-05 $37.09 USPS First Class 1 0.85 lbs $12.60 $6.68 $5.92
230269 2022-10-05 $10.21 First-Class Package Service 2 0.06 lbs $5.08 $3.88 $1.20
230270 2022-10-05 $15.04 First-Class Package Service 4 0.49 lbs $6.43 $5.23 $1.20
230271 2022-10-06 $7.00 First-Class Package Service 2 0.02 lbs $4.87 $3.67 $1.20
230274 2022-10-07 $95.29 First-Class Package Service 2 0.66 lbs $7.31 $6.36 $0.95
230275 2022-10-07 $16.33 First-Class Package Service 3 0.15 lbs $5.46 $4.26 $1.20
230278 2022-10-07 $70.14 Priority Mail 1 3.90 lbs $11.17 $10.07 $1.10
230281 2022-10-08 $16.45 First-Class Package Service 2 0.20 lbs $5.47 $3.88 $1.59
230285 2022-10-08 $20.48 Priority Mail 1 0.19 lbs $10.49 $9.39 $1.10
230286 2022-10-08 $13.02 First-Class Package Service 1 0.07 lbs $5.18 $3.98 $1.20
230288 2022-10-09 $64.20 Ground Home Delivery 5 1.06 lbs $25.15 $8.12 $17.03
230289 2022-10-09 $7.48 First-Class Package Service 1 0.03 lbs $4.84 $3.64 $1.20
230290 2022-10-09 $44.65 First-Class Package Service 8 0.47 lbs $6.43 $4.39 $2.04
230291 2022-10-09 $14.17 First-Class Package Service 7 0.26 lbs $5.24 $4.04 $1.20
230292 2022-10-09 $28.76 First-Class Package Service 10 0.32 lbs $5.26 $4.06 $1.20
230293 2022-10-10 $24.84 Priority Mail Flat Rate Envelope 6 1.14 lbs $9.60 $9.00 $0.60
230296 2022-10-10 $25.92 USPS Shipping 1 0.91 lbs $9.43 $8.49 $0.94
230300 2022-10-09 $11.99 USPS First Class 1 0.10 lbs $5.30 $3.88 $1.42
230301 2022-10-08 $15.69 USPS First Class 1 0.07 lbs $5.40 $4.12 $1.28
230302 2022-10-10 $8.29 USPS First Class 1 0.06 lbs $5.40 $4.12 $1.28
230304 2022-10-10 $83.97 Priority Mail Flat Rate Envelope 6 1.98 lbs $9.60 $9.20 $0.40
230305 2022-10-10 $24.84 Priority Mail Flat Rate Envelope 6 1.14 lbs $9.60 $9.00 $0.60
230306 2022-10-10 $10.34 USPS First Class 1 0.23 lbs $4.95 $4.06 $0.89
230307 2022-10-11 $12.20 USPS Shipping 1 0.10 lbs $5.51 $3.67 $1.84
230308 2022-10-11 $9.75 First-Class Package Service 3 0.07 lbs $5.46 $4.26 $1.20
230309 2022-09-10 $8.19 First-Class Package Service 2 0.02 lbs $5.06 $4.26 $0.80
230311 2022-10-12 $27.86 Priority Mail Flat Rate Envelope 1 0.80 lbs $9.60 $9.20 $0.40
230312 2022-10-12 $15.47 First-Class Package Service 2 0.15 lbs $5.59 $4.12 $1.47
230313 2022-10-12 $14.95 First-Class Package Service 3 0.15 lbs $5.48 $3.98 $1.50
230314 2022-10-11 $7.84 USPS First Class 1 0.02 lbs $4.95 $3.67 $1.28
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56