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
207460 2019-08-17 $40.72 Priority Mail 2-Day 1 0.75 lbs $8.73 $7.88 $0.85
207461 2019-08-17 $17.52 Priority Mail 2-Day 1 0.95 lbs $8.73 $7.88 $0.85
207462 2019-08-18 $14.20 First-Class Package Service 1 0.35 lbs $4.41 $4.06 $0.35
207463 2019-08-18 $8.27 First-Class Package Service 2 0.10 lbs $3.89 $2.84 $1.05
207464 2019-08-18 $146.81 Priority Mail 2-Day 3 10.25 lbs $14.54 $15.93 $-1.39
207467 2019-08-18 $36.71 Priority Mail 2-Day 4 1.00 lbs $10.55 $9.70 $0.85
207469 2019-08-18 $27.65 Priority Mail 2-Day 2 1.90 lbs $8.46 $7.61 $0.85
207470 2019-08-18 $7.24 First-Class Package Service 1 0.05 lbs $3.75 $2.70 $1.05
207471 2019-08-18 $28.93 First-Class Package Service 20 0.30 lbs $4.33 $3.28 $1.05
207472 2019-08-18 $303.99 Ground 1 29.80 lbs $39.00 $32.23 $6.77
207474 2019-08-19 $26.78 First-Class Package International Service 1 0.10 lbs $21.79 $13.54 $8.25
207475 2019-08-19 $14.87 First-Class Package Service 1 0.55 lbs $4.93 $5.02 $-0.09
207476 2019-08-19 $12.88 Priority Mail 2-Day 2 0.34 lbs $8.50 $7.65 $0.85
207478 2019-08-19 $15.39 First-Class Package Service 2 0.18 lbs $4.41 $3.36 $1.05
207479 2019-08-20 $37.84 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.35 $7.50 $0.85
207480 2019-08-20 $29.29 Priority Mail 3-Day 6 0.32 lbs $10.55 $7.82 $2.73
207481 2019-08-20 $7.38 First-Class Package Service 1 0.03 lbs $3.89 $2.84 $1.05
207482 2019-08-20 $117.27 Priority Mail 2-Day 24 1.51 lbs $11.71 $10.86 $0.85
207483 2019-08-20 $60.62 Priority Mail 2-Day 3 2.08 lbs $13.95 $10.55 $3.40
207484 2019-08-20 $11.60 First-Class Package Service 3 0.42 lbs $4.73 $3.88 $0.85
207485 2019-08-20 $78.06 Priority Mail 3-Day 1 4.40 lbs $10.07 $9.22 $0.85
207486 2019-08-21 $101.00 Direct Link International 13 1.72 lbs $28.23 $24.69 $3.54
207487 2019-08-21 $36.59 Priority Mail 2-Day Flat Rate Envelope 1 1.10 lbs $7.80 $7.50 $0.30
207488 2019-08-21 $112.42 Priority Mail 2-Day Medium Flat Rate Box 11 5.24 lbs $14.05 $10.55 $3.50
207496 2019-08-21 $23.36 First-Class Package Service 5 0.39 lbs $4.81 $3.96 $0.85
207497 2019-08-21 $13.73 First-Class Package Service 2 0.20 lbs $3.75 $2.70 $1.05
207502 2019-08-21 $19.13 First-Class Package Service 1 0.18 lbs $4.14 $3.63 $0.51
207503 2019-08-21 $15.43 First-Class Package Service 1 0.30 lbs $4.54 $3.49 $1.05
207504 2019-08-21 $24.24 First-Class Package Service 1 0.40 lbs $4.25 $3.85 $0.40
207506 2019-08-21 $67.42 Priority Mail 2-Day Medium Flat Rate Box 13 1.78 lbs $14.05 $10.86 $3.19
207507 2019-08-21 $87.65 Priority Mail 2-Day Medium Flat Rate Box 40 3.16 lbs $14.05 $12.80 $1.25
207508 2019-08-21 $78.64 Priority Mail 2-Day Medium Flat Rate Box 41 3.07 lbs $14.05 $12.80 $1.25
207510 2019-08-21 $28.63 Priority Mail 2-Day 1 0.13 lbs $9.66 $7.49 $2.17
207517 2019-08-23 $60.96 Priority Mail 3-Day 10 4.40 lbs $24.66 $20.40 $4.26
207518 2019-08-23 $24.40 First-Class Package Service 1 0.40 lbs $4.41 $5.24 $-0.83
207521 2019-08-23 $6.00 First-Class Package Service 1 0.03 lbs $4.01 $2.96 $1.05
207522 2019-08-23 $24.01 First-Class Package International Service 2 0.11 lbs $18.23 $9.98 $8.25
207524 2019-08-24 $7.50 First-Class Package Service 4 0.40 lbs $4.54 $3.49 $1.05
207525 2019-08-24 $64.78 Ground 3 14.95 lbs $30.87 $32.83 $-1.96
207526 2019-08-24 $19.87 Priority Mail 2-Day 1 0.95 lbs $11.08 $10.23 $0.85
207527 2019-08-24 $21.82 First-Class Package Service 1 0.45 lbs $4.33 $3.96 $0.37
207528 2019-08-25 $64.76 Priority Mail 3-Day 4 15.94 lbs $30.29 $31.57 $-1.28
207529 2019-08-25 $65.98 Priority Mail 3-Day 3 2.07 lbs $10.11 $8.76 $1.35
207535 2019-08-25 $22.51 Priority Mail 2-Day 2 1.15 lbs $8.73 $7.88 $0.85
207537 2019-08-25 $18.46 Priority Mail 3-Day 2 0.90 lbs $11.08 $10.23 $0.85
207540 2019-08-26 $27.29 Priority Mail 3-Day Flat Rate Envelope 1 0.85 lbs $7.80 $7.55 $0.25
207542 2019-08-26 $86.62 Priority Mail 3-Day 23 2.28 lbs $12.65 $10.00 $2.65
207544 2019-08-26 $12.57 First-Class Package Service 4 0.20 lbs $3.81 $3.28 $0.53
207545 2019-08-26 $105.84 First-Class Package International Service 1 0.82 lbs $31.05 $22.80 $8.25
207546 2019-08-26 $19.00 First-Class Package Service 1 0.19 lbs $4.01 $3.49 $0.52
207547 2019-08-26 $12.23 First-Class Package Service 2 0.46 lbs $4.25 $3.85 $0.40
207548 2019-08-26 $18.31 First-Class Package Service 2 0.38 lbs $4.33 $2.76 $1.57
207549 2019-08-26 $19.94 First-Class Package Service 3 0.85 lbs $5.97 $8.50 $-2.53
207550 2019-08-26 $18.52 First-Class Package Service 2 0.38 lbs $4.54 $2.96 $1.58
207551 2019-08-26 $8.80 First-Class Package Service 1 0.10 lbs $3.81 $3.28 $0.53
207552 2019-08-26 $58.88 Priority Mail 3-Day Flat Rate Envelope 2 1.87 lbs $7.80 $7.55 $0.25
207553 2019-08-27 $5.38 First-Class Package Service 1 0.05 lbs $3.89 $2.84 $1.05
207554 2019-08-27 $20.99 Priority Mail 2-Day Flat Rate Envelope 1 0.80 lbs $7.80 $7.55 $0.25
207555 2019-08-27 $11.84 First-Class Package Service 5 0.13 lbs $3.89 $2.84 $1.05
207557 2019-08-27 $20.31 First-Class Package Service 2 0.20 lbs $4.33 $3.28 $1.05
207558 2019-08-28 $8.99 First-Class Package Service 2 0.13 lbs $4.01 $2.96 $1.05
207561 2019-08-28 $19.23 First-Class Package Service 4 0.23 lbs $4.27 $3.22 $1.05
207563 2019-08-28 $38.14 Priority Mail 3-Day Small Flat Rate Box 1 1.25 lbs $8.35 $7.50 $0.85
207565 2019-08-29 $8.70 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
207567 2019-08-29 $30.19 Priority Mail 2-Day Flat Rate Envelope 1 1.00 lbs $7.80 $7.55 $0.25
207569 2019-08-29 $22.17 First-Class Package Service 1 0.45 lbs $4.68 $4.33 $0.35
207570 2019-08-29 $23.83 First-Class Package Service 6 0.09 lbs $3.89 $2.84 $1.05
207571 2019-08-29 $29.93 First-Class Package Service 4 0.61 lbs $5.97 $5.12 $0.85
207573 2019-08-29 $11.60 First-Class Package Service 3 0.42 lbs $4.73 $3.88 $0.85
207574 2019-08-30 $33.33 Priority Mail 2-Day 2 0.60 lbs $7.80 $7.50 $0.30
207579 2019-08-30 $31.42 First-Class Package Service 19 0.24 lbs $4.81 $5.12 $-0.31
207580 2019-08-30 $19.32 First-Class Package Service 1 0.40 lbs $4.33 $3.96 $0.37
207582 2019-08-30 $5.80 First-Class Package Service 1 0.05 lbs $3.81 $2.76 $1.05
207584 2019-08-30 $98.23 Priority Mail 2-Day 5 3.04 lbs $10.88 $8.76 $2.12
207585 2019-08-30 $9.23 First-Class Package Service 2 0.11 lbs $3.75 $3.22 $0.53
207588 2019-08-31 $56.92 First-Class Package International Service 2 0.65 lbs $30.34 $22.09 $8.25
207590 2019-08-31 $17.37 First-Class Package Service 1 0.57 lbs $5.38 $4.33 $1.05
207591 2019-08-31 $45.29 Priority Mail 3-Day Flat Rate Envelope 1 1.02 lbs $7.80 $7.50 $0.30
207592 2019-08-31 $32.84 Priority Mail 2-Day Medium Flat Rate Box 1 3.10 lbs $14.05 $10.00 $4.05
207593 2019-08-31 $9.12 First-Class Package Service 2 0.08 lbs $4.14 $3.09 $1.05
207594 2019-08-31 $37.84 Priority Mail 3-Day Small Flat Rate Box 1 1.15 lbs $8.35 $7.50 $0.85
207595 2019-08-31 $59.81 Priority Mail 3-Day 2 1.82 lbs $8.73 $7.55 $1.18
207597 2019-09-01 $40.47 Priority Mail 2-Day Flat Rate Envelope 3 1.29 lbs $7.80 $7.55 $0.25
207598 2019-09-01 $24.32 First-Class Package Service 1 0.00 lbs $4.33 $3.96 $0.37
207599 2019-09-01 $17.79 Priority Mail 3-Day Flat Rate Envelope 1 0.63 lbs $7.80 $7.50 $0.30
207600 2019-09-01 $47.08 Priority Mail 3-Day 3 1.67 lbs $10.11 $9.26 $0.85
207601 2019-09-01 $19.51 First-Class Package Service 3 0.30 lbs $4.54 $3.49 $1.05
207603 2019-09-01 $47.60 Priority Mail 3-Day 5 0.86 lbs $10.55 $9.70 $0.85
207605 2019-09-01 $37.84 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $8.35 $7.50 $0.85
207607 2019-09-01 $46.14 Priority Mail 2-Day 1 1.15 lbs $9.35 $8.76 $0.59
207609 2019-09-02 $12.51 First-Class Package Service 3 0.18 lbs $4.14 $3.09 $1.05
207610 2019-09-02 $24.09 Priority Mail 2-Day 6 1.06 lbs $10.55 $9.70 $0.85
207612 2019-09-02 $6.75 First-Class Package Service 6 0.06 lbs $3.81 $2.76 $1.05
207615 2019-09-02 $60.20 Priority Mail 2-Day 3 1.80 lbs $16.13 $15.28 $0.85
207616 2019-09-02 $70.60 Priority Mail 2-Day 11 1.71 lbs $11.71 $10.86 $0.85
207617 2019-09-02 $118.15 Priority Mail 2-Day Medium Flat Rate Box 70 4.40 lbs $14.05 $11.20 $2.85
207618 2019-09-03 $17.77 Priority Mail 3-Day Flat Rate Envelope 3 0.19 lbs $7.80 $7.50 $0.30
207619 2019-09-03 $15.46 First-Class Package Service 2 0.25 lbs $4.68 $3.63 $1.05
207621 2019-09-03 $17.22 First-Class Package Service 5 0.64 lbs $5.97 $5.12 $0.85
207622 2019-09-03 $14.88 First-Class Package Service 2 0.30 lbs $4.54 $3.49 $1.05
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56