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
220356 2021-01-15 $8.51 USPSFirstClass 1 0.05 lbs $4.12 $2.78 $1.34
220358 2021-01-15 $42.93 USPSFirstClass 10 1.90 lbs $21.03 $8.59 $12.44
220359 2021-01-15 $22.69 First-Class Mail Stamped Letter 1 0.18 lbs $3.40 $3.25 $0.15
220360 2021-01-15 $6.94 First-Class Mail Stamped Letter 1 0.03 lbs $2.95 $2.78 $0.17
220362 2021-01-15 $33.56 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $8.50 $7.65 $0.85
220363 2021-01-15 $14.56 First-Class Package Service 1 0.37 lbs $3.97 $3.52 $0.45
220366 2021-01-15 $46.76 First-Class Package Service 1 0.56 lbs $4.77 $4.32 $0.45
220367 2021-01-15 $16.34 USPSFirstClass 1 0.40 lbs $5.35 $4.18 $1.17
220369 2021-01-15 $67.91 Priority Mail 3-Day 10 3.12 lbs $15.01 $14.80 $0.21
220370 2021-01-15 $48.89 Priority Mail 3-Day Small Flat Rate Box 1 1.60 lbs $8.50 $7.65 $0.85
220371 2021-01-15 $36.55 Priority Mail 2-Day Flat Rate Envelope 2 1.23 lbs $8.00 $7.65 $0.35
220372 2021-01-15 $8.28 First-Class Package Service 1 0.05 lbs $3.29 $2.84 $0.45
220373 2021-01-15 $34.73 Priority Mail 3-Day Small Flat Rate Box 1 1.25 lbs $8.50 $7.65 $0.85
220376 2021-01-15 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.15 lbs $8.50 $7.65 $0.85
220378 2021-01-15 $37.59 Priority Mail 2-Day Padded Flat Rate Envelope 1 2.00 lbs $8.60 $7.65 $0.95
220379 2021-01-15 $8.47 USPSFirstClass 1 0.10 lbs $4.12 $2.78 $1.34
220380 2021-01-15 $45.09 Priority Mail 2-Day Padded Flat Rate Envelope 1 2.44 lbs $8.60 $7.75 $0.85
220381 2021-01-15 $49.91 Priority Mail 3-Day 2 1.15 lbs $10.84 $9.98 $0.86
220383 2021-01-15 $24.86 First-Class Package Service 1 0.65 lbs $5.37 $5.12 $0.25
220388 2021-01-15 $14.46 USPSFirstClass 3 0.75 lbs $5.79 $5.54 $0.25
220390 2021-01-15 $22.40 Priority Mail 2-Day Small Flat Rate Box 10 0.12 lbs $8.50 $7.65 $0.85
220391 2021-01-15 $27.33 First-Class Package Service 2 0.74 lbs $6.15 $5.98 $0.17
220392 2021-01-15 $34.73 First-Class Package Service 2 0.70 lbs $5.95 $5.70 $0.25
220393 2021-01-15 $25.53 USPSFirstClass 5 0.21 lbs $8.08 $3.25 $4.83
220394 2021-01-15 $7.22 First-Class Package Service 1 0.07 lbs $3.23 $2.78 $0.45
220395 2021-01-15 $7.82 USPSFirstClass 2 0.02 lbs $4.04 $2.84 $1.20
220396 2021-01-15 $11.79 USPSFirstClass 1 0.08 lbs $4.32 $3.31 $1.01
220397 2021-01-15 $12.13 USPSFirstClass 1 0.15 lbs $4.34 $3.31 $1.03
220398 2021-01-15 $35.57 First-Class Package Service 1 0.20 lbs $3.97 $3.52 $0.45
220399 2021-01-15 $19.23 USPSFirstClass 2 0.38 lbs $5.25 $3.52 $1.73
220400 2021-01-15 $13.49 USPSFirstClass 1 0.11 lbs $4.50 $3.52 $0.98
220403 2021-01-15 $27.76 USPSPriority 1 1.10 lbs $10.75 $8.21 $2.54
220404 2021-01-15 $12.67 First-Class Package Service 2 0.30 lbs $3.97 $3.05 $0.92
220405 2021-01-15 $16.62 Priority Mail 2-Day 1 0.04 lbs $8.83 $7.65 $1.18
220406 2021-01-15 $8.00 First-Class Mail Stamped Letter 10 0.10 lbs $3.10 $2.84 $0.26
220408 2021-01-16 $50.28 USPSFirstClass 10 2.00 lbs $24.58 $15.74 $8.84
220409 2021-01-15 $12.54 First-Class Package Service 2 0.30 lbs $3.84 $2.93 $0.91
220410 2021-01-15 $33.45 Priority Mail 3-Day Flat Rate Envelope 5 1.09 lbs $8.00 $8.00 $0.00
220411 2021-01-16 $14.69 USPSFirstClass 3 0.09 lbs $4.22 $3.05 $1.17
220413 2021-01-16 $36.26 USPSFirstClass 4 0.38 lbs $16.57 $3.25 $13.32
220415 2021-01-15 $13.09 First-Class Mail Stamped Letter 1 0.07 lbs $3.10 $3.05 $0.05
220416 2021-01-15 $148.31 Priority Mail 3-Day Medium Flat Rate Box 4 4.84 lbs $14.45 $9.55 $4.90
220420 2021-01-15 $15.02 First-Class Mail Stamped Letter 8 0.08 lbs $3.10 $2.84 $0.26
220421 2021-01-15 $7.60 First-Class Mail Stamped Letter 1 0.10 lbs $3.25 $2.84 $0.41
220422 2021-01-15 $51.49 Priority Mail 3-Day Small Flat Rate Box 1 1.55 lbs $8.50 $7.90 $0.60
220425 2021-01-15 $12.35 Priority Mail 2-Day Flat Rate Envelope 1 0.15 lbs $8.00 $8.15 $-0.15
220426 2021-01-15 $38.49 First-Class Package Service 1 0.25 lbs $3.50 $3.25 $0.25
220427 2021-01-16 $4.94 USPSFirstClass 1 0.03 lbs $3.95 $2.78 $1.17
220428 2021-01-16 $7.56 USPSFirstClass 1 0.05 lbs $4.07 $2.78 $1.29
220429 2021-01-16 $19.70 USPSFirstClass 4 1.00 lbs $8.14 $8.12 $0.02
220431 2021-01-16 $40.96 Priority Mail 3-Day 2 1.30 lbs $10.84 $7.65 $3.19
220432 2021-01-16 $7.59 First-Class Mail Stamped Letter 1 0.05 lbs $3.10 $2.93 $0.17
220433 2021-01-16 $11.87 USPSFirstClass 3 0.57 lbs $5.60 $4.18 $1.42
220435 2021-01-16 $47.98 Priority Mail 2-Day 6 1.54 lbs $13.00 $9.93 $3.07
220436 2021-01-16 $17.89 USPSFirstClass 1 0.95 lbs $8.90 $7.65 $1.25
220437 2021-01-16 $34.73 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.50 $7.65 $0.85
220439 2021-01-16 $10.89 First-Class Mail Stamped Letter 1 0.04 lbs $3.10 $2.78 $0.32
220440 2021-01-16 $186.78 Priority Mail 3-Day 9 5.66 lbs $21.31 $18.30 $3.01
220443 2021-01-16 $62.41 Priority Mail 2-Day 3 1.03 lbs $12.04 $11.13 $0.91
220444 2021-01-16 $16.28 USPSFirstClass 1 0.10 lbs $4.49 $5.12 $-0.63
220445 2021-01-16 $54.19 Priority Mail 2-Day Small Flat Rate Box 1 1.65 lbs $8.50 $7.90 $0.60
220446 2021-01-16 $7.56 USPSFirstClass 1 0.02 lbs $4.07 $2.78 $1.29
220447 2021-01-16 $29.05 Priority Mail 2-Day 1 1.10 lbs $12.04 $11.69 $0.35
220448 2021-01-16 $25.44 USPSFirstClass 6 1.20 lbs $12.90 $8.12 $4.78
220449 2021-01-16 $7.66 USPSFirstClass 1 0.05 lbs $4.17 $2.93 $1.24
220450 2021-01-16 $15.25 USPSFirstClass 1 0.17 lbs $4.54 $3.39 $1.15
220452 2021-01-16 $27.90 Priority Mail 3-Day 1 0.65 lbs $8.41 $8.21 $0.20
220453 2021-01-16 $53.84 USPSFirstClass 1 0.50 lbs $7.33 $4.46 $2.87
220456 2021-01-16 $14.23 First-Class Mail Stamped Letter 2 0.12 lbs $3.25 $2.93 $0.32
220457 2021-01-16 $8.24 USPSFirstClass 1 0.06 lbs $4.25 $3.05 $1.20
220458 2021-01-16 $9.18 USPSFirstClass 2 0.40 lbs $5.00 $3.52 $1.48
220461 2021-01-16 $7.34 USPSFirstClass 1 0.02 lbs $4.35 $3.18 $1.17
220462 2021-01-16 $7.85 USPSFirstClass 1 0.03 lbs $4.14 $2.84 $1.30
220463 2021-01-16 $7.53 USPSFirstClass 1 0.06 lbs $4.22 $3.05 $1.17
220464 2021-01-16 $60.29 Priority Mail 2-Day Medium Flat Rate Box 16 2.15 lbs $14.45 $13.20 $1.25
220465 2021-01-16 $42.58 Priority Mail 2-Day 1 2.40 lbs $16.59 $11.13 $5.46
220466 2021-01-16 $11.54 USPSFirstClass 1 0.19 lbs $4.55 $3.18 $1.37
220467 2021-01-16 $14.33 First-Class Package Service 1 0.30 lbs $4.12 $3.85 $0.27
220468 2021-01-16 $29.05 Priority Mail 3-Day 1 1.10 lbs $12.04 $11.69 $0.35
220469 2021-01-16 $39.92 Priority Mail 2-Day Padded Flat Rate Envelope 1 2.30 lbs $8.60 $7.15 $1.45
220470 2021-01-16 $11.03 First-Class Mail Stamped Letter 2 0.10 lbs $3.25 $3.18 $0.07
220471 2021-01-16 $47.17 Priority Mail 2-Day Flat Rate Envelope 3 1.08 lbs $8.00 $15.80 $-7.80
220473 2021-01-17 $32.76 USPSPriority 1 1.10 lbs $15.75 $11.18 $4.57
220474 2021-01-16 $59.35 Priority Mail 2-Day Flat Rate Envelope 5 1.79 lbs $8.00 $7.90 $0.10
220475 2021-01-17 $6.14 USPSFirstClass 1 0.03 lbs $4.15 $3.05 $1.10
220476 2021-01-16 $36.27 Priority Mail 2-Day Padded Flat Rate Envelope 1 7.50 lbs $8.60 $7.15 $1.45
220477 2021-01-17 $28.43 USPSFirstClass 6 0.30 lbs $5.09 $3.52 $1.57
220478 2021-01-17 $10.20 USPSFirstClass 1 0.06 lbs $4.10 $2.74 $1.36
220481 2021-01-16 $38.49 First-Class Package Service 1 0.25 lbs $3.50 $3.51 $-0.01
220483 2021-01-17 $8.19 USPSFirstClass 1 0.06 lbs $4.20 $2.93 $1.27
220484 2021-01-16 $38.02 First-Class Package Service 7 0.74 lbs $5.85 $4.18 $1.67
220485 2021-01-16 $4.92 First-Class Mail Stamped Letter 3 0.02 lbs $2.95 $2.93 $0.02
220486 2021-01-16 $52.58 Priority Mail 2-Day Flat Rate Envelope 2 1.35 lbs $8.00 $7.90 $0.10
220487 2021-01-17 $8.67 USPSFirstClass 1 0.05 lbs $4.27 $3.05 $1.22
220488 2021-01-16 $14.69 First-Class Package Service 1 0.35 lbs $3.70 $4.00 $-0.30
220489 2021-01-16 $40.17 Priority Mail 2-Day Flat Rate Envelope 3 1.09 lbs $8.00 $8.00 $0.00
220490 2021-01-16 $151.86 Priority Mail 3-Day Medium Flat Rate Box 6 6.72 lbs $14.45 $9.53 $4.92
220493 2021-01-17 $11.34 USPSFirstClass 1 0.19 lbs $4.35 $2.93 $1.42
220494 2021-01-16 $24.06 First-Class Package Service 1 0.60 lbs $4.57 $5.54 $-0.97
220496 2021-01-17 $21.09 First-Class Mail Stamped Letter 1 0.15 lbs $3.10 $3.05 $0.05
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56