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
230315 2022-10-12 $14.59 USPS First Class 1 0.20 lbs $5.60 $4.55 $1.05
230316 2022-10-12 $15.77 First-Class Package Service 1 0.20 lbs $5.48 $3.98 $1.50
230320 2022-10-13 $19.38 Priority Mail Flat Rate Envelope 2 0.90 lbs $9.60 $9.00 $0.60
230321 2022-10-13 $7.15 First-Class Package Service 1 0.03 lbs $5.01 $4.06 $0.95
230322 2022-10-13 $15.97 First-Class Package Service 1 0.05 lbs $5.18 $3.98 $1.20
230323 2022-10-13 $13.24 USPS First Class 1 0.04 lbs $5.35 $3.98 $1.37
230324 2022-10-14 $9.10 USPS Shipping 1 0.02 lbs $5.51 $3.88 $1.63
230325 2022-10-14 $24.08 First-Class Package Service 3 0.15 lbs $5.21 $4.01 $1.20
230326 2022-10-14 $16.35 USPS First Class 1 0.02 lbs $5.35 $3.98 $1.37
230328 2022-10-16 $8.98 First-Class Package Service 3 0.03 lbs $5.46 $4.26 $1.20
230329 2022-10-15 $12.84 USPS First Class 1 0.06 lbs $4.95 $3.67 $1.28
230330 2022-10-15 $12.84 USPS First Class 1 0.06 lbs $4.95 $3.67 $1.28
230331 2022-10-15 $12.69 USPS First Class 1 0.06 lbs $5.30 $3.88 $1.42
230332 2022-10-17 $9.36 USPS Shipping 1 0.03 lbs $5.23 $4.26 $0.97
230333 2022-10-17 $9.53 USPS Shipping 1 0.03 lbs $5.23 $3.67 $1.56
230334 2022-10-17 $9.19 USPS First Class 1 0.01 lbs $5.60 $4.26 $1.34
230335 2022-10-17 $13.31 First-Class Package Service 1 0.05 lbs $5.32 $4.12 $1.20
230336 2022-10-17 $25.48 USPS First-Class Mail or Priority Mail 2 0.16 lbs $11.02 $3.67 $7.35
230337 2022-10-18 $14.59 USPS First Class 1 0.08 lbs $5.60 $4.26 $1.34
230338 2022-10-17 $13.49 USPS First Class 1 0.06 lbs $5.60 $4.26 $1.34
230340 2022-10-19 $18.48 USPS Parcel Select Ground 1 0.50 lbs $8.49 $8.49 $0.00
230341 2022-10-18 $26.09 USPS First Class 1 0.45 lbs $6.10 $4.55 $1.55
230343 2022-10-20 $28.45 First-Class Package Service 11 0.12 lbs $5.46 $4.26 $1.20
230344 2022-10-20 $10.09 USPS First Class 1 0.05 lbs $5.30 $3.88 $1.42
230345 2022-10-20 $9.48 USPS Shipping 1 0.03 lbs $5.23 $3.88 $1.35
230346 2022-10-20 $11.29 USPS Shipping 1 0.30 lbs $5.80 $6.68 $-0.88
230347 2022-10-20 $10.09 USPS First Class 1 0.06 lbs $5.60 $4.26 $1.34
230348 2022-10-20 $41.80 Priority Mail 6 1.11 lbs $12.86 $9.94 $2.92
230349 2022-10-20 $10.69 USPS First Class 1 0.23 lbs $5.30 $4.27 $1.03
230350 2022-10-21 $24.17 First-Class Package Service 1 0.45 lbs $6.28 $5.08 $1.20
230351 2022-10-21 $25.35 First-Class Package Service 1 0.25 lbs $5.48 $4.28 $1.20
230352 2022-10-22 $25.49 First-Class Package Service 10 0.20 lbs $5.59 $3.97 $1.62
230353 2022-10-24 $17.74 First-Class Package Service 1 0.30 lbs $5.75 $5.38 $0.37
230355 2022-10-22 $9.79 USPS First Class 1 0.06 lbs $5.30 $3.88 $1.42
230356 2022-10-24 $10.19 USPS First Class 1 0.05 lbs $5.40 $4.12 $1.28
230357 2022-10-24 $19.03 USPS First-Class Mail or Priority Mail 1 0.93 lbs $-11.99 $6.68 $-18.67
230358 2022-10-24 $15.40 USPS Shipping 1 0.10 lbs $5.51 $4.26 $1.25
230359 2022-10-24 $12.20 USPS Shipping 1 0.08 lbs $5.51 $4.26 $1.25
230360 2022-10-24 $17.74 USPS First-Class Mail or Priority Mail 2 0.10 lbs $11.02 $4.26 $6.76
230361 2022-10-25 $11.74 First-Class Package Service 1 0.08 lbs $5.08 $3.88 $1.20
230362 2022-10-24 $16.49 USPS First Class 1 0.50 lbs $5.50 $4.06 $1.44
230363 2022-10-26 $100.79 USPS Priority Mail 1 1.65 lbs $11.00 $8.27 $2.73
230364 2022-10-25 $33.20 UPS Ground 1 5.44 lbs $13.71 $9.79 $3.92
230365 2022-10-25 $10.14 USPS First Class 1 0.05 lbs $5.35 $3.98 $1.37
230366 2022-10-27 $14.55 USPS Shipping 1 0.06 lbs $5.23 $3.67 $1.56
230367 2022-10-27 $25.92 USPS Shipping 1 0.91 lbs $9.43 $9.01 $0.42
230368 2022-10-27 $10.32 First-Class Package Service 1 0.03 lbs $5.18 $3.98 $1.20
230372 2022-10-27 $13.20 First-Class Package Service 3 0.25 lbs $5.50 $4.55 $0.95
230373 2022-10-27 $13.80 First-Class Package Service 1 0.20 lbs $5.26 $3.67 $1.59
230375 2022-10-27 $65.85 Priority Mail 1 1.60 lbs $14.56 $8.30 $6.26
230376 2022-10-28 $9.72 First-Class Package Service 2 0.20 lbs $5.59 $4.39 $1.20
230377 2022-10-28 $46.95 Priority Mail Flat Rate Envelope 2 1.33 lbs $9.60 $8.10 $1.50
230378 2022-10-27 $12.84 USPS First Class 1 0.06 lbs $4.95 $3.67 $1.28
230382 2022-10-29 $12.31 First-Class Package Service 2 0.07 lbs $5.18 $3.98 $1.20
230384 2022-10-29 $13.71 First-Class Package Service 2 0.08 lbs $5.18 $3.98 $1.20
230386 2022-10-30 $11.42 First-Class Package Service 5 0.05 lbs $5.32 $4.12 $1.20
230389 2022-10-30 $12.84 USPS First Class 1 0.04 lbs $4.95 $3.67 $1.28
230390 2022-10-31 $5.79 USPS Shipping 1 0.25 lbs $0.00 $8.00 $-8.00
230391 2022-10-31 $11.32 First-Class Package Service 1 0.05 lbs $5.18 $3.98 $1.20
230392 2022-10-31 $12.34 USPS First Class 1 0.06 lbs $4.95 $3.67 $1.28
230393 2022-10-31 $17.37 First-Class Package Service 1 0.10 lbs $5.32 $4.39 $0.93
230394 2022-10-31 $7.49 First-Class Package Service 1 0.24 lbs $6.33 $5.38 $0.95
230395 2022-10-31 $21.39 USPS First Class 1 0.06 lbs $5.40 $4.12 $1.28
230396 2022-10-31 $12.84 USPS First Class 1 0.04 lbs $4.95 $3.67 $1.28
230397 2022-10-31 $12.84 USPS First Class 1 0.06 lbs $4.95 $3.67 $1.28
230398 2022-11-01 $23.36 Priority Mail Small Flat Rate Box 4 1.12 lbs $10.10 $8.10 $2.00
230400 2022-11-01 $16.16 First-Class Package Service 3 0.14 lbs $6.49 $4.28 $2.21
230401 2022-11-01 $13.24 USPS First Class 1 0.06 lbs $5.35 $3.98 $1.37
230402 2022-11-02 $19.41 First-Class Package Service 11 0.14 lbs $5.32 $4.12 $1.20
230403 2022-11-03 $25.44 First-Class Package Service 2 0.16 lbs $5.46 $4.55 $0.91
230404 2022-11-03 $25.18 USPS First Class 2 0.10 lbs $11.20 $4.26 $6.94
230405 2022-11-04 $99.20 Priority Mail Medium Flat Rate Box 3 2.80 lbs $16.65 $8.30 $8.35
230406 2022-11-05 $76.33 UPS Ground 2 0.38 lbs $26.42 $18.10 $8.32
230407 2022-11-05 $21.74 USPS Priority Mail 1 1.00 lbs $9.75 $8.27 $1.48
230408 2022-11-05 $13.19 USPS First Class 1 0.06 lbs $5.30 $3.88 $1.42
230409 2022-11-05 $19.00 USPS Parcel Select Ground 1 0.50 lbs $9.01 $9.01 $0.00
230410 2022-11-05 $10.70 First-Class Package Service 3 0.06 lbs $5.08 $4.27 $0.81
230411 2022-11-05 $14.47 First-Class Package Service 6 0.15 lbs $4.87 $3.67 $1.20
230412 2022-11-06 $11.99 USPS First Class 1 0.07 lbs $5.30 $3.88 $1.42
230413 2022-11-05 $23.74 USPS Priority Mail 1 1.10 lbs $12.75 $8.82 $3.93
230414 2022-11-07 $100.46 Priority Mail Padded Flat Rate Envelope 2 4.25 lbs $10.30 $8.30 $2.00
230415 2022-11-07 $110.59 Priority Mail 6 1.17 lbs $13.52 $12.42 $1.10
230416 2022-11-07 $28.74 First-Class Package Service 1 0.35 lbs $5.75 $4.55 $1.20
230417 2022-11-08 $26.39 USPS First Class 1 0.45 lbs $5.90 $5.08 $0.82
230418 2022-11-08 $13.91 USPS Shipping 1 0.06 lbs $5.23 $3.88 $1.35
230419 2022-11-08 $71.19 Priority Mail 1 3.95 lbs $18.93 $17.83 $1.10
230420 2022-11-08 $88.89 Priority Mail 13 1.53 lbs $11.02 $8.30 $2.72
230421 2022-11-08 $30.84 First-Class Package Service 1 0.22 lbs $5.47 $4.27 $1.20
230422 2022-11-08 $53.46 Priority Mail 2 2.10 lbs $9.95 $8.06 $1.89
230423 2022-11-09 $43.47 First-Class Package Service 7 0.53 lbs $6.43 $4.39 $2.04
230424 2022-11-09 $81.53 First-Class Package International Service 4 0.54 lbs $36.03 $27.98 $8.05
230428 2022-11-09 $34.74 USPS First Class 1 0.75 lbs $6.55 $6.12 $0.43
230430 2022-11-09 $35.25 First-Class Package Service 2 0.65 lbs $6.98 $5.78 $1.20
230431 2022-11-09 $10.97 First-Class Package Service 4 0.04 lbs $5.46 $4.26 $1.20
230434 2022-11-10 $12.89 First-Class Package Service 1 0.14 lbs $5.75 $4.55 $1.20
230435 2022-11-09 $12.84 USPS First Class 1 0.06 lbs $4.95 $3.67 $1.28
230436 2022-11-09 $14.59 USPS First Class 1 0.20 lbs $5.60 $4.55 $1.05
230437 2022-11-10 $11.94 First-Class Package Service 3 0.09 lbs $4.82 $3.62 $1.20
230440 2022-11-11 $43.36 Priority Mail Flat Rate Envelope 4 0.64 lbs $9.60 $8.10 $1.50
230441 2022-11-10 $71.89 USPS Priority Mail 1 2.15 lbs $31.40 $29.14 $2.26
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56