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
233337 2024-09-19 $8.82 USPS Ground Advantage 1 0.06 lbs $4.51 $3.86 $0.65
233338 2024-09-19 $28.10 USPS Ground Advantage 6 2.46 lbs $8.96 $8.31 $0.65
233339 2024-09-19 $23.39 USPS Priority Mail 1 1.00 lbs $8.90 $8.97 $-0.07
233340 2024-09-20 $14.46 USPS Ground Advantage 2 0.12 lbs $4.76 $4.11 $0.65
233341 2024-09-22 $13.33 USPS Ground Advantage 1 0.05 lbs $4.84 $4.19 $0.65
233342 2024-09-22 $17.60 USPS Ground Advantage 1 0.05 lbs $4.61 $4.47 $0.14
233343 2024-09-22 $10.35 USPS Ground Advantage 1 0.05 lbs $4.76 $4.11 $0.65
233344 2024-09-21 $13.83 USPS Ground Advantage 1 0.06 lbs $4.84 $4.19 $0.65
233345 2024-09-21 $50.02 USPS Ground Advantage 1 0.29 lbs $5.03 $4.38 $0.65
233346 2024-09-21 $13.50 USPS Ground Advantage 1 0.21 lbs $5.01 $4.36 $0.65
233347 2024-09-21 $7.56 USPS Ground Advantage 1 0.02 lbs $4.67 $4.02 $0.65
233348 2024-09-21 $12.84 USPS Ground Advantage 2 0.06 lbs $4.76 $4.11 $0.65
233349 2024-09-21 $21.35 USPS Ground Advantage 1 0.03 lbs $6.36 $4.36 $2.00
233350 2024-09-20 $36.84 USPS Ground Advantage 4 1.20 lbs $8.08 $7.17 $0.91
233351 2024-09-20 $43.56 UPS Ground 1 1.23 lbs $10.57 $8.71 $1.86
233352 2024-09-23 $13.04 USPS Ground Parcel or Priority Mail 1 0.07 lbs $7.85 $4.11 $3.74
233353 2024-09-23 $24.89 USPS Ground Parcel or Priority Mail 1 0.19 lbs $6.70 $4.11 $2.59
233354 2024-09-23 $17.60 USPS Ground Advantage 1 0.05 lbs $4.61 $4.11 $0.50
233355 2024-09-23 $20.95 USPS Ground Advantage 1 0.19 lbs $5.96 $4.38 $1.58
233356 2024-09-23 $11.16 USPS Ground Advantage 4 0.80 lbs $0.00 $6.23 $-6.23
233357 2024-09-23 $7.65 USPS Ground Advantage 1 0.03 lbs $4.76 $4.11 $0.65
233359 2024-09-24 $13.18 USPS Ground Advantage 3 0.57 lbs $6.07 $6.23 $-0.16
233360 2024-09-24 $18.10 USPS Ground Advantage 1 0.19 lbs $4.61 $4.38 $0.23
233361 2024-09-24 $35.06 USPS Ground Advantage 2 0.74 lbs $6.10 $6.40 $-0.30
233362 2024-09-25 $14.70 USPS Ground Advantage 1 0.12 lbs $4.71 $3.96 $0.75
233363 2024-09-25 $15.76 USPS Ground Advantage 1 0.19 lbs $4.77 $4.43 $0.34
233364 2024-09-25 $19.67 USPS Ground Advantage 1 0.06 lbs $4.67 $4.02 $0.65
233365 2024-09-25 $16.67 USPS Ground Advantage 1 0.06 lbs $4.67 $4.02 $0.65
233366 2024-09-25 $31.01 USPS Ground Advantage 1 0.06 lbs $6.02 $4.02 $2.00
233367 2024-09-26 $38.75 USPS Priority Mail 1 3.40 lbs $10.76 $9.30 $1.46
233368 2024-09-26 $11.50 USPS Ground Advantage 1 0.05 lbs $4.61 $3.86 $0.75
233369 2024-09-26 $19.23 USPS Ground Advantage 7 0.21 lbs $5.30 $4.19 $1.11
233370 2024-09-26 $13.75 USPS Ground Advantage 2 0.06 lbs $4.77 $4.02 $0.75
233371 2024-09-26 $38.25 USPS Priority Mail 1 3.40 lbs $10.26 $9.30 $0.96
233372 2024-09-29 $28.11 USPS Ground Advantage 1 0.69 lbs $6.07 $6.79 $-0.72
233373 2024-09-29 $13.35 USPS Ground Advantage 1 0.21 lbs $4.86 $4.11 $0.75
233374 2024-09-28 $13.15 USPS Ground Advantage 1 0.10 lbs $4.86 $4.11 $0.75
233375 2024-09-28 $20.83 USPS Ground Advantage 2 0.12 lbs $9.68 $4.19 $5.49
233377 2024-10-02 $13.19 USPS Ground Advantage 2 0.06 lbs $5.11 $4.36 $0.75
233378 2024-10-02 $10.51 USPS Ground Advantage 1 0.03 lbs $4.94 $4.19 $0.75
233379 2024-10-02 $14.65 USPS Ground Advantage 2 0.15 lbs $4.77 $4.43 $0.34
233380 2024-10-02 $11.90 USPS Ground Advantage 1 0.03 lbs $4.61 $3.86 $0.75
233381 2024-10-04 $13.06 USPS Ground Advantage 1 0.08 lbs $4.77 $4.02 $0.75
233382 2024-10-04 $9.60 USPS Ground Advantage 1 0.03 lbs $5.11 $4.36 $0.75
233384 2024-10-04 $20.04 USPS Ground Advantage 7 0.21 lbs $9.54 $4.02 $5.52
233386 2024-10-05 $12.76 USPS Ground Advantage 1 0.21 lbs $4.77 $4.02 $0.75
233387 2024-10-06 $52.65 USPS Ground Advantage 4 2.50 lbs $11.09 $9.95 $1.14
233388 2024-10-05 $10.60 USPS Ground Advantage 1 0.06 lbs $4.71 $4.26 $0.45
233389 2024-10-05 $18.35 USPS Ground Advantage 3 0.19 lbs $4.61 $4.26 $0.35
233390 2024-10-07 $14.60 USPS Ground Advantage 1 0.06 lbs $4.71 $4.26 $0.45
233391 2024-10-07 $9.18 USPS Ground Advantage 1 0.05 lbs $4.94 $4.54 $0.40
233392 2024-10-07 $51.89 USPS Ground Advantage 1 2.30 lbs $12.10 $12.41 $-0.31
233393 2024-10-09 $21.81 USPS Ground Advantage 1 0.28 lbs $9.22 $5.32 $3.90
233394 2024-10-08 $14.10 USPS Ground Advantage 1 0.07 lbs $5.11 $4.36 $0.75
233395 2024-10-09 $9.01 USPS Ground Advantage 1 0.05 lbs $4.61 $3.96 $0.65
233396 2024-10-09 $27.62 USPS Ground Advantage 1 0.40 lbs $5.13 $5.07 $0.06
233397 2024-10-09 $13.61 USPS Ground Advantage 1 0.06 lbs $4.71 $3.96 $0.75
233398 2024-10-09 $18.02 USPS Ground Advantage 1 0.70 lbs $5.43 $7.50 $-2.07
233399 2024-10-10 $10.22 USPS Ground Parcel or Priority Mail 1 0.05 lbs $8.63 $4.36 $4.27
233400 2024-10-10 $22.70 USPS Ground Advantage 1 0.15 lbs $4.71 $3.96 $0.75
233401 2024-10-10 $24.34 USPS Ground Advantage 8 0.16 lbs $5.22 $4.11 $1.11
233402 2024-10-11 $13.67 USPS Ground Advantage 1 0.06 lbs $4.86 $4.11 $0.75
233404 2024-10-13 $100.72 Priority Mail 2 2.50 lbs $15.74 $9.30 $6.44
233405 2024-10-14 $10.46 USPS Ground Advantage 1 0.03 lbs $4.71 $3.96 $0.75
233406 2024-10-12 $13.91 USPS Ground Advantage 1 0.06 lbs $5.01 $4.36 $0.65
233407 2024-10-12 $59.65 USPS Ground Advantage 3 2.75 lbs $11.23 $10.99 $0.24
233408 2024-10-14 $18.17 USPS Ground Advantage 1 0.25 lbs $4.77 $4.43 $0.34
233409 2024-10-14 $99.99 USPS Priority Mail 1 1.40 lbs $7.30 $6.65 $0.65
233410 2024-10-14 $30.60 Priority Mail Flat Rate Envelope 8 0.28 lbs $10.10 $8.71 $1.39
233411 2024-10-14 $10.33 USPS Ground Advantage 1 0.04 lbs $4.94 $4.19 $0.75
233412 2024-10-14 $20.09 USPS Ground Advantage 4 0.24 lbs $4.77 $4.02 $0.75
233413 2024-10-18 $32.54 Priority Mail 1 0.35 lbs $9.65 $6.90 $2.75
233415 2024-10-20 $34.95 USPS Ground Advantage 1 0.80 lbs $7.15 $6.40 $0.75
233417 2024-10-23 $11.05 USPS Ground Advantage 1 0.18 lbs $4.94 $4.55 $0.39
233418 2024-10-22 $17.44 USPS Ground Advantage 2 0.36 lbs $5.22 $5.32 $-0.10
233419 2024-10-23 $53.93 Priority Mail 3 1.35 lbs $10.92 $8.97 $1.95
233420 2024-10-23 $47.85 USPS Ground Parcel or Priority Mail 1 4.75 lbs $25.86 $6.94 $18.92
233421 2024-10-23 $31.25 USPS Ground Advantage 1 0.06 lbs $4.71 $3.96 $0.75
233422 2024-10-23 $32.31 USPS First Class 4 0.75 lbs $5.15 $7.26 $-2.11
233423 2024-10-23 $13.61 USPS Ground Advantage 1 0.06 lbs $4.71 $3.96 $0.75
233424 2024-10-24 $31.31 USPS Ground Advantage 1 0.06 lbs $4.77 $4.02 $0.75
233425 2024-10-24 $10.22 USPS Ground Advantage 1 0.18 lbs $4.11 $4.47 $-0.36
233427 2024-10-25 $13.84 USPS Ground Advantage 1 0.06 lbs $4.94 $4.54 $0.40
233428 2024-10-27 $18.51 Priority Mail 6 0.08 lbs $9.65 $7.20 $2.45
233429 2024-10-28 $32.00 USPS Ground Advantage 1 0.06 lbs $5.46 $4.71 $0.75
233430 2024-10-28 $21.32 USPS Ground Advantage 1 1.10 lbs $10.53 $8.56 $1.97
233431 2024-10-28 $32.30 USPS Ground Parcel or Priority Mail 1 0.45 lbs $8.63 $5.09 $3.54
233432 2024-10-29 $16.90 USPS Ground Advantage 2 0.36 lbs $4.68 $5.37 $-0.69
233433 2024-10-28 $30.99 USPS Ground Advantage 2 2.20 lbs $9.41 $7.52 $1.89
233434 2024-10-30 $17.97 USPS Ground Advantage 4 0.04 lbs $5.21 $4.46 $0.75
233435 2024-10-31 $48.90 USPS Ground Advantage 1 1.17 lbs $9.31 $8.56 $0.75
233436 2024-10-31 $18.61 USPS Ground Advantage 1 0.05 lbs $5.12 $4.37 $0.75
233437 2024-10-31 $14.28 USPS Ground Advantage 1 0.06 lbs $5.46 $4.71 $0.75
233438 2024-11-01 $31.83 USPS Ground Advantage 1 0.06 lbs $5.29 $4.54 $0.75
233439 2024-11-04 $10.37 USPS Ground Advantage 1 0.18 lbs $4.26 $4.26 $0.00
233440 2024-11-04 $14.14 USPS Ground Advantage 1 0.06 lbs $5.33 $4.58 $0.75
233441 2024-11-03 $10.14 USPS Ground Advantage 1 0.06 lbs $5.29 $4.54 $0.75
233442 2024-11-03 $34.67 USPS Ground Advantage 1 0.44 lbs $5.43 $5.37 $0.06
233443 2024-11-03 $23.01 USPS Ground Advantage 2 0.12 lbs $5.21 $4.46 $0.75
233444 2024-11-03 $48.03 USPS Ground Advantage 1 1.17 lbs $8.44 $7.69 $0.75
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56