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
210400 2020-03-21 $8.62 Priority Mail 2-Day Padded Flat Rate Envelope 2 0.40 lbs $8.60 $7.75 $0.85
210402 2020-03-21 $4.67 First-Class Mail Stamped Letter 3 0.03 lbs $3.20 $3.05 $0.15
210403 2020-03-21 $31.99 Priority Mail 2-Day Flat Rate Envelope 1 3.55 lbs $8.00 $7.75 $0.25
210404 2020-03-21 $45.35 Priority Mail 3-Day Flat Rate Envelope 15 0.45 lbs $8.00 $7.65 $0.35
210405 2020-03-21 $35.68 Priority Mail 3-Day Small Flat Rate Box 2 0.45 lbs $8.50 $7.65 $0.85
210406 2020-03-21 $24.79 Priority Mail 3-Day Flat Rate Envelope 1 0.45 lbs $8.00 $7.56 $0.44
210407 2020-03-21 $37.86 Priority Mail 2-Day Flat Rate Envelope 14 0.22 lbs $8.00 $7.65 $0.35
210408 2020-03-21 $13.47 Priority Mail 2-Day Small Flat Rate Box 3 0.22 lbs $8.50 $7.65 $0.85
210409 2020-03-21 $12.97 Priority Mail 3-Day Flat Rate Envelope 3 0.22 lbs $8.00 $7.65 $0.35
210411 2020-03-21 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $8.50 $7.65 $0.85
210412 2020-03-21 $38.29 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $8.50 $7.65 $0.85
210413 2020-03-21 $108.01 Priority Mail 2-Day Medium Flat Rate Box 4 3.15 lbs $14.45 $12.10 $2.35
210414 2020-02-06 $67.05 First-Class Package Service 4 1.43 lbs $13.50 $8.76 $4.74
210417 2020-03-21 $13.47 Priority Mail 2-Day Flat Rate Envelope 2 0.25 lbs $8.00 $7.65 $0.35
210418 2020-03-21 $15.46 First-Class Mail Stamped Letter 4 0.12 lbs $3.50 $3.05 $0.45
210422 2020-03-21 $22.21 First-Class Package Service 2 0.10 lbs $3.23 $2.78 $0.45
210423 2020-03-21 $9.33 First-Class Mail Stamped Letter 2 0.06 lbs $3.35 $3.18 $0.17
210424 2020-03-21 $26.39 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $8.00 $7.75 $0.25
210426 2020-03-21 $5.19 First-Class Mail Stamped Letter 1 0.02 lbs $3.20 $2.84 $0.36
210428 2020-03-21 $17.21 First-Class Mail Stamped Letter 4 0.15 lbs $3.65 $3.05 $0.60
210429 2020-03-21 $176.52 Priority Mail 2-Day 9 5.35 lbs $21.31 $13.20 $8.11
210433 2020-03-21 $56.87 Priority Mail 2-Day 2 2.05 lbs $10.39 $8.92 $1.47
210435 2020-03-22 $8.69 First-Class Mail Stamped Letter 1 0.15 lbs $3.50 $2.93 $0.57
210436 2020-03-22 $33.83 Priority Mail 2-Day Flat Rate Envelope 7 0.23 lbs $8.00 $7.65 $0.35
210437 2020-03-22 $12.57 First-Class Mail Stamped Letter 8 0.20 lbs $3.65 $2.93 $0.72
210438 2020-03-22 $11.02 First-Class Mail Stamped Letter 1 0.15 lbs $3.50 $2.93 $0.57
210439 2020-03-22 $12.72 First-Class Package Service 4 0.14 lbs $3.76 $3.31 $0.45
210440 2020-03-22 $48.85 Priority Mail 2-Day 2 1.25 lbs $8.97 $8.12 $0.85
210441 2020-03-22 $22.30 First-Class Package Service 3 0.39 lbs $4.33 $4.08 $0.25
210442 2020-03-22 $6.34 First-Class Mail Stamped Letter 1 0.03 lbs $3.35 $2.93 $0.42
210443 2020-03-22 $25.91 Priority Mail 2-Day Flat Rate Envelope 9 0.25 lbs $8.00 $3.31 $4.69
210444 2020-03-22 $49.07 Priority Mail 3-Day 2 1.50 lbs $11.39 $10.54 $0.85
210445 2020-03-22 $40.35 Priority Mail 2-Day Flat Rate Envelope 5 0.33 lbs $8.00 $7.65 $0.35
210446 2020-03-22 $37.88 Priority Mail 3-Day Small Flat Rate Box 2 1.20 lbs $8.50 $7.65 $0.85
210447 2020-03-22 $17.96 Priority Mail 2-Day 1 0.95 lbs $8.97 $8.12 $0.85
210449 2020-03-22 $10.33 First-Class Mail Stamped Letter 2 0.10 lbs $3.35 $3.18 $0.17
210450 2020-03-22 $8.49 First-Class Mail Stamped Letter 1 0.10 lbs $3.50 $3.05 $0.45
210451 2020-03-22 $19.79 Priority Mail 3-Day Flat Rate Envelope 1 0.30 lbs $8.00 $7.65 $0.35
210453 2020-03-22 $223.87 Priority Mail 2-Day 1 14.05 lbs $30.88 $30.03 $0.85
210456 2020-03-22 $19.73 Priority Mail 3-Day 4 0.84 lbs $8.97 $8.12 $0.85
210457 2020-03-22 $11.30 First-Class Mail Stamped Letter 5 0.06 lbs $3.35 $2.84 $0.51
210459 2020-03-22 $21.96 Priority Mail 2-Day Flat Rate Envelope 4 0.90 lbs $8.00 $7.65 $0.35
210463 2020-03-22 $108.69 Priority Mail 3-Day 3 3.20 lbs $9.92 $8.21 $1.71
210464 2020-03-22 $25.17 Priority Mail 2-Day Small Flat Rate Box 4 0.28 lbs $8.50 $7.80 $0.70
210466 2020-03-23 $300.68 Priority Mail 3-Day 1 14.40 lbs $46.69 $48.22 $-1.53
210467 2020-03-22 $53.44 Priority Mail 3-Day Flat Rate Envelope 6 0.37 lbs $11.50 $7.65 $3.85
210469 2020-03-23 $298.66 Ground 4 19.60 lbs $42.80 $54.93 $-12.13
210470 2020-03-23 $21.97 Priority Mail 2-Day Flat Rate Envelope 3 0.39 lbs $8.00 $7.65 $0.35
210471 2020-03-23 $53.36 Priority Mail 2-Day Flat Rate Envelope 4 1.57 lbs $8.00 $7.65 $0.35
210472 2020-03-23 $51.49 Priority Mail 2-Day Small Flat Rate Box 1 1.45 lbs $8.50 $7.65 $0.85
210474 2020-03-23 $40.97 Priority Mail 2-Day Flat Rate Envelope 3 0.48 lbs $8.00 $7.80 $0.20
210475 2020-03-23 $8.49 First-Class Mail Stamped Letter 1 0.10 lbs $3.50 $2.78 $0.72
210476 2020-03-23 $23.24 Priority Mail 3-Day Flat Rate Envelope 6 1.14 lbs $8.00 $7.65 $0.35
210478 2020-03-23 $71.79 Priority Mail 2-Day 2 4.09 lbs $21.86 $21.01 $0.85
210479 2020-03-23 $10.31 First-Class Mail Stamped Letter 4 0.08 lbs $3.35 $2.84 $0.51
210480 2020-03-23 $9.33 First-Class Mail Stamped Letter 2 0.07 lbs $3.35 $3.18 $0.17
210481 2020-03-23 $8.99 First-Class Mail Stamped Letter 1 0.10 lbs $3.50 $2.78 $0.72
210483 2020-03-23 $32.35 Priority Mail 2-Day Flat Rate Envelope 5 1.04 lbs $8.00 $7.75 $0.25
210486 2020-03-23 $47.13 Priority Mail 3-Day Medium Flat Rate Box 2 1.25 lbs $14.45 $7.65 $6.80
210489 2020-03-23 $11.08 First-Class Mail Stamped Letter 2 0.10 lbs $3.50 $3.05 $0.45
210491 2020-03-23 $10.99 Priority Mail 2-Day Flat Rate Envelope 1 0.29 lbs $8.00 $7.15 $0.85
210492 2020-03-23 $8.99 First-Class Mail Stamped Letter 1 0.10 lbs $3.50 $2.84 $0.66
210493 2020-03-23 $8.54 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $2.84 $0.51
210495 2020-03-23 $30.56 Priority Mail 3-Day Padded Flat Rate Envelope 4 0.40 lbs $8.60 $7.65 $0.95
210496 2020-03-23 $10.64 First-Class Mail Stamped Letter 1 0.19 lbs $3.65 $2.84 $0.81
210498 2020-03-23 $51.49 Priority Mail 3-Day Small Flat Rate Box 1 1.50 lbs $8.50 $7.65 $0.85
210499 2020-03-23 $10.99 Priority Mail 3-Day Flat Rate Envelope 1 0.03 lbs $8.00 $7.80 $0.20
210500 2020-03-23 $109.46 Priority Mail 2-Day Medium Flat Rate Box 4 2.75 lbs $14.45 $11.13 $3.32
210505 2020-03-24 $51.33 Priority Mail 3-Day 1 2.20 lbs $14.34 $11.13 $3.21
210506 2020-03-24 $18.98 Priority Mail 2-Day Flat Rate Envelope 2 0.20 lbs $8.00 $7.65 $0.35
210507 2020-03-24 $10.64 First-Class Mail Stamped Letter 1 0.19 lbs $3.65 $3.05 $0.60
210508 2020-03-24 $17.69 First-Class Package Service 6 0.47 lbs $4.25 $4.00 $0.25
210509 2020-03-24 $51.49 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.50 $7.65 $0.85
210510 2020-03-24 $57.72 Priority Mail 2-Day 2 1.15 lbs $13.94 $9.54 $4.40
210512 2020-03-24 $41.29 Priority Mail 3-Day Small Flat Rate Box 1 1.15 lbs $8.50 $7.65 $0.85
210515 2020-03-24 $31.29 Priority Mail 3-Day 5 0.32 lbs $10.84 $7.98 $2.86
210516 2020-03-24 $5.69 First-Class Mail Stamped Letter 1 0.10 lbs $3.50 $3.05 $0.45
210517 2020-03-24 $34.66 2nd Day Air 1 0.05 lbs $25.17 $22.67 $2.50
210519 2020-03-23 $132.64 Priority Mail 3-Day 16 5.16 lbs $21.10 $14.18 $6.92
210520 2020-03-24 $16.73 First-Class Mail Stamped Letter 7 0.12 lbs $3.50 $2.84 $0.66
210521 2020-03-17 $16.29 First-Class Package Service 1 0.41 lbs $0.00 $4.18 $-4.18
210524 2020-03-24 $17.61 First-Class Mail Stamped Letter 4 0.20 lbs $3.65 $2.93 $0.72
210528 2020-03-24 $18.60 Priority Mail 2-Day 1 0.95 lbs $9.61 $8.76 $0.85
210529 2020-03-24 $8.54 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $3.05 $0.30
210530 2020-03-24 $59.36 Priority Mail 1-Day 2 2.15 lbs $8.69 $7.84 $0.85
210531 2020-03-24 $24.29 First-Class Package Service 1 0.45 lbs $4.38 $5.04 $-0.66
210532 2020-03-24 $64.95 Priority Mail 1-Day 3 1.95 lbs $8.69 $7.84 $0.85
210534 2020-03-24 $40.19 Priority Mail 2-Day Flat Rate Envelope 1 0.50 lbs $8.00 $7.75 $0.25
210537 2020-03-25 $12.69 Priority Mail 2-Day Small Flat Rate Box 1 0.22 lbs $8.50 $7.65 $0.85
210538 2020-03-25 $316.62 Priority Mail 2-Day 3 15.15 lbs $32.35 $32.91 $-0.56
210541 2020-03-25 $40.06 Priority Mail 3-Day Flat Rate Envelope 3 1.17 lbs $8.00 $7.65 $0.35
210542 2020-03-25 $26.29 Priority Mail 2-Day Flat Rate Envelope 1 0.30 lbs $8.00 $7.65 $0.35
210543 2020-03-25 $46.62 Priority Mail 3-Day Padded Flat Rate Envelope 1 0.55 lbs $8.60 $7.75 $0.85
210545 2020-03-25 $7.96 First-Class Mail Stamped Letter 4 0.11 lbs $3.50 $3.52 $-0.02
210546 2020-03-25 $20.38 Priority Mail 2-Day 1 0.95 lbs $11.39 $10.54 $0.85
210551 2020-03-25 $223.38 Ground 22 9.98 lbs $24.45 $18.06 $6.39
210552 2020-03-25 $8.34 First-Class Mail Stamped Letter 1 0.06 lbs $3.35 $2.78 $0.57
210555 2020-03-25 $31.67 Priority Mail 2-Day 10 0.43 lbs $9.27 $11.19 $-1.92
210558 2020-03-25 $5.84 First-Class Mail Stamped Letter 1 0.08 lbs $3.35 $3.05 $0.30
210559 2020-03-25 $13.82 First-Class Mail Stamped Letter 3 0.10 lbs $3.35 $2.93 $0.42
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56