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
215369 2020-09-07 $55.51 Priority Mail 2-Day 20 2.68 lbs $16.91 $14.53 $2.38
215370 2020-09-07 $44.08 First-Class Package Service 2 0.20 lbs $3.70 $2.78 $0.92
215372 2020-09-07 $35.00 Priority Mail 2-Day Small Flat Rate Box 1 1.10 lbs $8.50 $7.65 $0.85
215373 2020-09-07 $15.18 USPSFirstClass 1 0.05 lbs $4.42 $2.84 $1.58
215374 2020-09-07 $17.61 USPSFirstClass 2 0.60 lbs $5.67 $5.12 $0.55
215376 2020-09-07 $9.14 Priority Mail 3-Day Small Flat Rate Box 2 0.04 lbs $8.50 $7.65 $0.85
215378 2020-09-07 $9.18 USPSFirstClass 1 0.05 lbs $4.29 $3.05 $1.24
215380 2020-09-07 $7.84 First-Class Package Service 4 0.08 lbs $3.38 $2.93 $0.45
215381 2020-09-08 $38.44 USPSFirstClass 5 1.62 lbs $17.07 $11.19 $5.88
215383 2020-09-07 $51.49 Priority Mail 2-Day Small Flat Rate Box 1 1.45 lbs $8.50 $7.65 $0.85
215387 2020-09-07 $21.26 Priority Mail 2-Day Flat Rate Envelope 4 1.12 lbs $8.00 $7.65 $0.35
215391 2020-09-08 $10.06 USPSFirstClass 2 0.12 lbs $4.04 $2.78 $1.26
215392 2020-09-07 $22.46 Priority Mail 2-Day Flat Rate Envelope 4 0.19 lbs $8.00 $7.65 $0.35
215395 2020-09-07 $21.42 First-Class Package Service 1 0.45 lbs $4.63 $4.18 $0.45
215396 2020-09-08 $56.38 Priority Mail 3-Day 1 1.10 lbs $11.39 $11.01 $0.38
215399 2020-09-08 $43.38 Priority Mail 2-Day 1 0.75 lbs $11.39 $10.54 $0.85
215400 2020-09-08 $22.14 USPSFirstClass 1 0.15 lbs $4.85 $3.05 $1.80
215401 2020-09-08 $33.98 Direct Link International 1 0.68 lbs $21.99 $17.21 $4.78
215403 2020-09-08 $16.55 First-Class Package Service 1 0.25 lbs $3.76 $3.31 $0.45
215404 2020-09-08 $13.05 USPSFirstClass 3 0.18 lbs $4.04 $3.25 $0.79
215406 2020-09-08 $27.14 First-Class Package Service 1 0.50 lbs $5.65 $4.18 $1.47
215407 2020-09-08 $26.39 Priority Mail 2-Day Flat Rate Envelope 1 1.00 lbs $8.00 $7.75 $0.25
215408 2020-09-08 $21.02 USPSFirstClass 1 0.03 lbs $4.75 $2.93 $1.82
215409 2020-09-08 $92.48 Priority Mail 2-Day Small Flat Rate Box 2 21.16 lbs $8.50 $13.60 $-5.10
215410 2020-09-08 $24.09 First-Class Package Service 1 0.40 lbs $4.77 $4.32 $0.45
215411 2020-09-08 $40.74 Priority Mail 2-Day Medium Flat Rate Box 1 3.10 lbs $14.45 $9.98 $4.47
215412 2020-09-08 $31.92 First-Class Mail Stamped Letter 1 0.17 lbs $3.65 $3.25 $0.40
215413 2020-09-08 $32.65 USPSPriority 1 1.10 lbs $10.90 $8.21 $2.69
215414 2020-09-08 $48.43 Priority Mail 2-Day 1 1.80 lbs $9.44 $8.59 $0.85
215415 2020-09-08 $15.76 First-Class Package Service 1 0.25 lbs $3.97 $3.52 $0.45
215416 2020-09-08 $41.29 Priority Mail 2-Day Small Flat Rate Box 1 1.00 lbs $8.50 $7.90 $0.60
215417 2020-09-08 $10.33 First-Class Mail Stamped Letter 2 0.10 lbs $3.35 $3.18 $0.17
215420 2020-09-08 $19.95 Priority Mail 2-Day Flat Rate Envelope 5 0.18 lbs $8.00 $7.65 $0.35
215422 2020-09-08 $121.91 Priority Mail 2-Day Padded Flat Rate Envelope 2 2.52 lbs $8.60 $7.75 $0.85
215423 2020-09-08 $290.60 Ground 1 15.55 lbs $40.61 $31.84 $8.77
215425 2020-09-09 $9.79 USPSFirstClass 1 0.05 lbs $4.29 $3.05 $1.24
215426 2020-09-08 $7.74 First-Class Mail Stamped Letter 1 0.07 lbs $3.35 $3.18 $0.17
215432 2020-09-09 $6.56 USPSFirstClass 1 0.01 lbs $4.29 $3.18 $1.11
215433 2020-09-09 $8.81 USPSFirstClass 1 0.10 lbs $4.42 $3.18 $1.24
215434 2020-09-08 $9.82 First-Class Package Service 2 0.40 lbs $3.84 $4.18 $-0.34
215435 2020-09-08 $35.67 Priority Mail 3-Day 2 1.26 lbs $11.39 $10.54 $0.85
215436 2020-09-09 $22.97 USPSPriority 1 1.15 lbs $10.47 $7.75 $2.72
215438 2020-09-08 $27.56 Priority Mail 2-Day 4 1.34 lbs $4.00 $3.64 $0.36
215439 2020-09-08 $147.00 Priority Mail 3-Day Medium Flat Rate Box 5 9.60 lbs $14.45 $10.42 $4.03
215440 2020-09-09 $18.96 First-Class Package Service 1 0.19 lbs $3.97 $3.52 $0.45
215441 2020-09-09 $9.82 First-Class Package Service 1 0.10 lbs $4.63 $3.18 $1.45
215444 2020-09-09 $13.21 USPSFirstClass 2 0.07 lbs $8.11 $3.31 $4.80
215448 2020-09-09 $11.54 USPSFirstClass 1 0.19 lbs $4.55 $3.18 $1.37
215449 2020-09-09 $112.42 Priority Mail 2-Day Medium Flat Rate Box 3 4.66 lbs $14.45 $9.98 $4.47
215450 2020-09-09 $17.04 First-Class Package Service 3 0.55 lbs $4.57 $5.54 $-0.97
215452 2020-09-09 $28.10 Priority Mail 2-Day 1 0.70 lbs $9.61 $7.80 $1.81
215453 2020-09-09 $22.46 USPSFirstClass 1 0.15 lbs $4.80 $2.93 $1.87
215454 2020-09-09 $22.60 Priority Mail 2-Day 1 0.47 lbs $9.61 $7.80 $1.81
215455 2020-08-29 $38.99 Priority Mail 2-Day 1 1.30 lbs $0.00 $8.24 $-8.24
215456 2020-08-29 $92.21 Priority Mail 2-Day 7 6.13 lbs $11.78 $9.74 $2.04
215458 2020-09-09 $7.17 First-Class Package Service 2 0.06 lbs $3.19 $2.74 $0.45
215461 2020-09-09 $9.86 USPSFirstClass 1 0.50 lbs $5.00 $5.40 $-0.40
215464 2020-09-09 $26.80 First-Class Package Service - Retail 5 0.38 lbs $5.85 $4.46 $1.39
215465 2020-09-09 $32.79 Priority Mail 2-Day Padded Flat Rate Envelope 1 2.10 lbs $8.60 $7.75 $0.85
215466 2020-09-10 $6.50 USPSFirstClass 1 0.01 lbs $4.09 $2.93 $1.16
215467 2020-09-10 $29.90 USPSFirstClass 4 1.60 lbs $16.34 $8.12 $8.22
215469 2020-09-09 $37.45 First-Class Package Service 2 0.31 lbs $3.97 $3.52 $0.45
215470 2020-09-10 $12.13 USPSFirstClass 2 0.10 lbs $4.15 $2.84 $1.31
215471 2020-09-10 $21.61 USPSFirstClass 1 0.15 lbs $4.60 $3.21 $1.39
215473 2020-09-10 $56.27 Ground 4 4.80 lbs $23.11 $18.87 $4.24
215475 2020-09-10 $8.28 USPSFirstClass 1 0.03 lbs $4.22 $3.05 $1.17
215476 2020-09-10 $11.50 USPSFirstClass 1 0.50 lbs $5.21 $3.52 $1.69
215477 2020-09-10 $7.19 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $2.78 $0.42
215478 2020-09-10 $27.41 Priority Mail 3-Day 4 0.36 lbs $9.61 $7.75 $1.86
215479 2020-09-10 $58.72 Priority Mail 2-Day 2 2.20 lbs $9.44 $7.75 $1.69
215480 2020-09-10 $29.03 First-Class Package Service 2 0.65 lbs $5.85 $5.40 $0.45
215482 2020-09-10 $69.06 USPSFirstClass 3 0.40 lbs $10.18 $4.00 $6.18
215483 2020-09-10 $11.18 First-Class Package Service 5 0.06 lbs $3.23 $2.78 $0.45
215484 2020-09-10 $18.87 USPSFirstClass 2 0.40 lbs $5.09 $4.08 $1.01
215485 2020-09-10 $27.84 Priority Mail 2-Day Flat Rate Envelope 16 2.16 lbs $8.00 $7.65 $0.35
215487 2020-09-10 $21.82 USPSFirstClass 1 0.30 lbs $5.55 $3.39 $2.16
215488 2020-09-10 $8.14 USPSFirstClass 1 0.03 lbs $4.12 $2.84 $1.28
215489 2020-09-11 $20.13 USPSFirstClass 2 0.38 lbs $5.15 $2.93 $2.22
215493 2020-09-10 $17.81 First-Class Package Service 4 0.80 lbs $5.85 $5.40 $0.45
215494 2020-09-10 $28.23 First-Class Package Service 2 0.50 lbs $4.45 $4.00 $0.45
215495 2020-09-10 $5.68 First-Class Package Service 1 0.10 lbs $3.29 $2.84 $0.45
215496 2020-09-11 $8.08 USPSFirstClass 2 0.02 lbs $3.99 $2.78 $1.21
215499 2020-09-10 $34.81 Direct Link International 1 0.30 lbs $19.46 $11.58 $7.88
215500 2020-09-10 $61.52 Priority Mail 2-Day 2 1.65 lbs $12.04 $7.75 $4.29
215502 2020-09-11 $15.91 USPSFirstClass 1 0.40 lbs $5.38 $3.52 $1.86
215506 2020-09-11 $16.99 Priority Mail 2-Day Flat Rate Envelope 1 0.95 lbs $8.00 $7.65 $0.35
215507 2020-09-11 $9.86 USPSFirstClass 1 0.05 lbs $4.29 $3.05 $1.24
215508 2020-09-11 $51.59 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.55 lbs $8.60 $7.65 $0.95
215509 2020-09-11 $20.66 First-Class Package Service 13 0.15 lbs $3.29 $2.84 $0.45
215510 2020-09-11 $23.86 First-Class Package Service 1 0.60 lbs $4.57 $5.54 $-0.97
215513 2020-09-11 $23.95 First-Class Package Service 2 0.60 lbs $4.53 $5.27 $-0.74
215514 2020-09-11 $21.40 USPSFirstClass 1 0.30 lbs $5.45 $3.25 $2.20
215519 2020-09-11 $7.28 First-Class Package Service 1 0.10 lbs $3.29 $2.84 $0.45
215520 2020-09-11 $27.55 First-Class Package Service 2 0.70 lbs $5.57 $5.12 $0.45
215521 2020-09-11 $11.31 First-Class Mail Stamped Letter 4 0.08 lbs $3.35 $2.93 $0.42
215522 2020-09-11 $30.39 Priority Mail 2-Day Flat Rate Envelope 1 1.00 lbs $8.00 $7.75 $0.25
215523 2020-09-11 $10.07 USPSFirstClass 2 0.34 lbs $4.82 $4.00 $0.82
215524 2020-09-11 $62.56 Priority Mail 2-Day 5 1.85 lbs $9.61 $9.93 $-0.32
215525 2020-09-11 $28.46 USPSFirstClass 1 0.35 lbs $5.77 $3.25 $2.52
215527 2020-09-11 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.15 lbs $8.50 $7.65 $0.85
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56