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
219535 2021-01-02 $13.60 USPSFirstClass 1 0.06 lbs $4.41 $2.84 $1.57
219539 2021-01-02 $20.50 First-Class Package Service 3 0.33 lbs $4.53 $4.08 $0.45
219541 2021-01-02 $15.13 USPSFirstClass 2 0.12 lbs $4.47 $3.18 $1.29
219544 2021-01-02 $40.63 USPSPriority 1 0.00 lbs $9.98 $7.75 $2.23
219545 2021-01-02 $31.70 USPSFirstClass 4 0.94 lbs $8.54 $8.76 $-0.22
219546 2021-01-02 $41.22 USPSFirstClass 5 2.33 lbs $22.27 $12.15 $10.12
219547 2021-01-02 $35.00 USPSFirstClass 1 0.69 lbs $6.86 $16.82 $-9.96
219548 2021-01-02 $7.66 USPSFirstClass 1 0.03 lbs $4.17 $2.93 $1.24
219550 2021-01-02 $45.96 USPSFirstClass 1 0.31 lbs $6.95 $3.67 $3.28
219551 2021-01-02 $31.70 USPSFirstClass 3 1.16 lbs $14.33 $10.53 $3.80
219552 2021-01-02 $7.43 USPSFirstClass 1 0.06 lbs $4.16 $2.93 $1.23
219553 2021-01-02 $26.81 USPSFirstClass 1 0.12 lbs $5.28 $3.18 $2.10
219554 2021-01-02 $33.11 USPSPriority 1 1.00 lbs $9.62 $7.75 $1.87
219555 2021-01-02 $13.55 USPSFirstClass 1 0.06 lbs $4.36 $2.78 $1.58
219559 2021-01-02 $14.99 Priority Mail 2-Day Flat Rate Envelope 1 0.19 lbs $8.00 $7.65 $0.35
219560 2021-01-02 $7.22 First-Class Package Service 1 0.06 lbs $3.23 $2.78 $0.45
219561 2021-01-02 $9.40 First-Class Mail Stamped Letter 1 0.05 lbs $3.10 $3.18 $-0.08
219562 2021-01-02 $49.74 USPSFirstClass 1 0.56 lbs $7.75 $8.15 $-0.40
219564 2021-01-02 $19.10 First-Class Package Service 5 0.38 lbs $4.45 $3.51 $0.94
219567 2021-01-02 $67.79 USPSPriority 1 1.38 lbs $14.42 $7.65 $6.77
219568 2021-01-02 $26.81 USPSFirstClass 1 0.12 lbs $5.28 $3.18 $2.10
219569 2021-01-02 $6.04 USPSFirstClass 1 0.19 lbs $4.05 $2.84 $1.21
219571 2021-01-02 $10.06 First-Class Mail Stamped Letter 4 0.08 lbs $3.10 $3.05 $0.05
219573 2021-01-02 $13.98 First-Class Package Service 2 0.21 lbs $3.50 $3.25 $0.25
219574 2021-01-03 $49.74 USPSFirstClass 1 0.56 lbs $7.75 $8.15 $-0.40
219576 2021-01-02 $4.42 First-Class Mail Stamped Letter 3 0.03 lbs $2.95 $2.93 $0.02
219578 2021-01-03 $23.28 USPSFirstClass 2 0.12 lbs $9.11 $3.18 $5.93
219579 2021-01-03 $11.54 USPSFirstClass 1 0.19 lbs $4.55 $3.18 $1.37
219580 2021-01-02 $9.40 First-Class Mail Stamped Letter 1 0.05 lbs $3.10 $2.84 $0.26
219582 2021-01-03 $70.94 USPSPriority 1 1.31 lbs $17.57 $7.65 $9.92
219583 2021-01-03 $11.39 USPSFirstClass 1 0.19 lbs $4.40 $3.05 $1.35
219584 2021-01-02 $13.76 First-Class Package Service 1 0.19 lbs $3.77 $4.32 $-0.55
219585 2021-01-03 $34.03 USPSFirstClass 3 0.19 lbs $13.63 $3.18 $10.45
219586 2021-01-03 $34.85 USPSFirstClass 1 0.69 lbs $6.71 $3.93 $2.78
219587 2021-01-03 $19.70 USPSFirstClass 4 0.20 lbs $4.14 $3.31 $0.83
219589 2021-01-03 $17.64 USPSFirstClass 1 0.05 lbs $4.65 $2.93 $1.72
219590 2021-01-03 $13.70 USPSFirstClass 1 0.06 lbs $4.51 $3.05 $1.46
219591 2021-01-02 $6.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.10 $3.05 $0.05
219593 2021-01-02 $14.27 First-Class Package Service - Retail 1 0.35 lbs $5.60 $3.31 $2.29
219594 2021-01-03 $11.39 USPSFirstClass 1 0.19 lbs $4.40 $3.05 $1.35
219599 2021-01-03 $9.60 USPSFirstClass 1 0.06 lbs $4.27 $2.93 $1.34
219600 2021-01-03 $9.08 USPSFirstClass 1 0.05 lbs $4.19 $2.84 $1.35
219601 2021-01-03 $10.08 USPSFirstClass 1 0.23 lbs $4.29 $3.39 $0.90
219602 2021-01-02 $127.84 Priority Mail 2-Day 9 4.26 lbs $14.93 $11.70 $3.23
219603 2021-01-03 $13.60 USPSFirstClass 1 0.06 lbs $4.41 $2.84 $1.57
219605 2021-01-03 $24.67 First-Class Package Service 3 0.33 lbs $3.70 $3.25 $0.45
219606 2021-01-03 $10.76 First-Class Package Service 1 0.44 lbs $4.77 $3.52 $1.25
219607 2021-01-03 $47.59 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.44 lbs $8.60 $7.75 $0.85
219608 2021-01-03 $70.58 Priority Mail 2-Day Padded Flat Rate Envelope 2 1.40 lbs $8.60 $7.65 $0.95
219609 2021-01-03 $70.17 Priority Mail 2-Day 3 1.87 lbs $13.00 $12.70 $0.30
219610 2021-01-03 $8.39 USPSFirstClass 1 0.09 lbs $4.40 $3.18 $1.22
219611 2021-01-03 $30.57 USPSFirstClass 2 0.90 lbs $8.99 $5.40 $3.59
219613 2021-01-03 $9.80 USPSFirstClass 1 0.06 lbs $4.47 $3.18 $1.29
219615 2021-01-03 $14.47 Priority Mail 2-Day Flat Rate Envelope 3 0.29 lbs $8.00 $8.92 $-0.92
219617 2021-01-03 $47.59 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.44 lbs $8.60 $7.75 $0.85
219618 2021-01-03 $7.33 USPSFirstClass 1 0.06 lbs $4.06 $2.78 $1.28
219620 2021-01-03 $27.09 Priority Mail 3-Day Padded Flat Rate Envelope 1 0.45 lbs $8.60 $7.75 $0.85
219621 2021-01-03 $39.18 Priority Mail 2-Day Flat Rate Envelope 2 0.60 lbs $9.10 $7.90 $1.20
219624 2021-01-03 $17.68 First-Class Package Service 2 0.34 lbs $3.70 $4.00 $-0.30
219625 2021-01-03 $9.55 USPSFirstClass 1 0.06 lbs $4.22 $2.84 $1.38
219626 2021-01-03 $97.14 USPSPriority 1 1.56 lbs $17.63 $7.65 $9.98
219627 2021-01-03 $6.21 First-Class Package Service 1 0.19 lbs $4.12 $3.18 $0.94
219628 2021-01-03 $47.75 Priority Mail 2-Day Padded Flat Rate Envelope 1 2.00 lbs $8.60 $7.75 $0.85
219630 2021-01-03 $37.58 Priority Mail 3-Day Small Flat Rate Box 1 1.00 lbs $8.50 $7.65 $0.85
219631 2021-01-03 $12.38 USPSFirstClass 1 0.06 lbs $4.59 $3.18 $1.41
219632 2021-01-03 $67.79 USPSPriority 1 1.31 lbs $14.42 $7.65 $6.77
219634 2021-01-03 $21.12 USPSFirstClass 1 0.12 lbs $4.72 $2.78 $1.94
219636 2021-01-03 $6.35 First-Class Package Service 3 0.03 lbs $3.38 $2.93 $0.45
219637 2021-01-03 $12.68 First-Class Package Service 3 0.57 lbs $4.91 $3.18 $1.73
219638 2021-01-03 $27.49 USPSFirstClass 1 0.20 lbs $5.02 $3.25 $1.77
219639 2021-01-03 $13.85 USPSFirstClass 1 0.06 lbs $4.66 $3.18 $1.48
219640 2021-01-03 $29.99 Priority Mail 3-Day Flat Rate Envelope 1 1.00 lbs $8.00 $7.15 $0.85
219642 2021-01-03 $28.46 USPSFirstClass 2 0.12 lbs $8.98 $7.98 $1.00
219644 2021-01-03 $14.84 USPSFirstClass 3 0.18 lbs $4.37 $3.67 $0.70
219646 2021-01-03 $34.73 Priority Mail 3-Day Small Flat Rate Box 1 1.25 lbs $8.50 $7.65 $0.85
219648 2021-01-03 $18.90 First-Class Package Service 3 0.39 lbs $4.43 $4.18 $0.25
219649 2021-01-03 $51.44 Priority Mail 2-Day Medium Flat Rate Box 1 2.20 lbs $14.45 $12.64 $1.81
219650 2021-01-03 $15.63 First-Class Package Service 1 0.35 lbs $3.84 $3.39 $0.45
219651 2021-01-03 $13.39 USPSFirstClass 1 0.05 lbs $4.40 $3.31 $1.09
219652 2021-01-03 $10.69 USPSFirstClass 2 0.12 lbs $4.07 $2.78 $1.29
219653 2021-01-03 $11.34 USPSFirstClass 1 0.19 lbs $4.35 $2.93 $1.42
219654 2021-01-03 $45.17 Priority Mail 2-Day 1 3.32 lbs $11.18 $8.92 $2.26
219655 2021-01-03 $30.65 USPSFirstClass 3 1.16 lbs $13.28 $8.12 $5.16
219656 2021-01-03 $19.87 USPSFirstClass 2 0.12 lbs $4.29 $2.78 $1.51
219661 2021-01-03 $51.49 Priority Mail 2-Day Small Flat Rate Box 1 1.50 lbs $8.50 $7.90 $0.60
219663 2021-01-03 $14.16 USPSFirstClass 1 0.10 lbs $4.67 $3.18 $1.49
219664 2021-01-03 $75.54 Priority Mail 3-Day 5 2.43 lbs $10.39 $9.01 $1.38
219665 2021-01-03 $17.54 USPSFirstClass 1 0.05 lbs $4.55 $2.78 $1.77
219667 2021-01-04 $29.81 USPSFirstClass 3 0.00 lbs $6.05 $4.32 $1.73
219668 2021-01-03 $35.10 Priority Mail 2-Day Flat Rate Envelope 1 0.95 lbs $8.00 $7.65 $0.35
219670 2021-01-03 $11.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.10 $2.93 $0.17
219671 2021-01-04 $17.54 USPSFirstClass 1 0.05 lbs $4.55 $2.78 $1.77
219673 2021-01-04 $18.26 USPSFirstClass 1 0.25 lbs $4.87 $3.67 $1.20
219675 2021-01-03 $6.94 First-Class Mail Stamped Letter 1 0.04 lbs $2.95 $3.05 $-0.10
219676 2021-01-04 $13.76 USPSFirstClass 1 0.10 lbs $4.27 $2.74 $1.53
219677 2021-01-03 $20.22 First-Class Package Service 1 0.16 lbs $3.50 $3.25 $0.25
219678 2021-01-04 $49.49 USPSFirstClass 1 0.56 lbs $7.50 $7.56 $-0.06
219679 2021-01-04 $18.11 USPSFirstClass 1 0.25 lbs $4.72 $3.52 $1.20
219681 2021-01-03 $19.43 Priority Mail 2-Day 6 0.73 lbs $8.97 $8.21 $0.76
219682 2021-01-04 $17.54 USPSFirstClass 1 0.05 lbs $4.55 $2.78 $1.77
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56