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
222588 2021-02-24 $21.38 USPSPriority 1 1.10 lbs $11.59 $8.85 $2.74
222589 2021-02-24 $9.58 USPSFirstClass 1 0.03 lbs $4.69 $3.49 $1.20
222590 2021-02-24 $8.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.12 $0.08
222593 2021-02-24 $12.18 USPSFirstClass 1 0.30 lbs $5.29 $3.57 $1.72
222594 2021-02-24 $10.70 USPSFirstClass 1 0.06 lbs $4.60 $3.35 $1.25
222595 2021-02-24 $9.47 USPSFirstClass 1 0.23 lbs $4.45 $3.57 $0.88
222598 2021-02-24 $69.67 Priority Mail 3-Day 11 4.99 lbs $16.98 $8.67 $8.31
222599 2021-02-24 $13.99 First-Class Package Service 1 0.30 lbs $3.00 $3.57 $-0.57
222600 2021-02-25 $7.29 USPSFirstClass 1 0.03 lbs $4.30 $3.06 $1.24
222601 2021-02-24 $8.59 First-Class Mail Stamped Letter 1 0.10 lbs $3.40 $3.35 $0.05
222603 2021-02-24 $24.12 First-Class Package Service 1 0.60 lbs $4.63 $4.38 $0.25
222604 2021-02-25 $68.09 USPSPriority 1 5.80 lbs $14.10 $8.73 $5.37
222605 2021-02-24 $17.52 First-Class Package Service 1 0.45 lbs $5.03 $3.69 $1.34
222607 2021-02-24 $15.98 First-Class Package Service 1 0.30 lbs $4.19 $3.69 $0.50
222609 2021-02-24 $13.70 First-Class Package Service 2 0.10 lbs $3.72 $3.22 $0.50
222612 2021-02-24 $38.54 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $8.75 $7.90 $0.85
222613 2021-02-24 $39.35 First-Class Package Service 4 0.32 lbs $4.19 $3.69 $0.50
222614 2021-02-24 $8.98 First-Class Package Service 1 0.05 lbs $3.99 $3.49 $0.50
222615 2021-02-25 $8.90 First-Class Package Service 1 0.20 lbs $4.01 $3.51 $0.50
222617 2021-02-25 $120.73 Ground 1 19.40 lbs $37.06 $34.63 $2.43
222619 2021-02-25 $13.21 First-Class Package Service 2 0.18 lbs $3.96 $3.01 $0.95
222620 2021-02-25 $7.23 USPSFirstClass 1 0.10 lbs $4.34 $3.12 $1.22
222621 2021-02-25 $24.86 USPSFirstClass 2 0.12 lbs $9.28 $3.22 $6.06
222622 2021-02-25 $15.23 USPSFirstClass 2 0.12 lbs $4.57 $3.35 $1.22
222623 2021-02-25 $25.06 First-Class Package Service 1 0.35 lbs $4.07 $4.20 $-0.13
222625 2021-02-25 $28.03 Priority Mail 2-Day Flat Rate Envelope 2 0.38 lbs $8.25 $7.90 $0.35
222626 2021-02-25 $27.27 Priority Mail 2-Day Flat Rate Envelope 1 3.55 lbs $8.25 $8.00 $0.25
222628 2021-02-25 $14.17 First-Class Mail Stamped Letter 3 0.15 lbs $3.40 $3.12 $0.28
222629 2021-02-25 $11.99 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.22 $-0.02
222630 2021-02-25 $7.18 First-Class Mail Stamped Letter 2 0.06 lbs $3.20 $3.49 $-0.29
222631 2021-02-25 $12.68 First-Class Package Service 1 0.30 lbs $4.01 $3.51 $0.50
222632 2021-02-25 $10.34 First-Class Package Service 1 0.19 lbs $4.35 $3.49 $0.86
222634 2021-02-25 $54.44 Priority Mail 3-Day Small Flat Rate Box 1 1.75 lbs $8.75 $7.90 $0.85
222635 2021-02-25 $156.81 Priority Mail 3-Day Padded Flat Rate Envelope 4 3.25 lbs $8.85 $8.00 $0.85
222636 2021-02-25 $14.40 First-Class Package Service 1 0.25 lbs $4.19 $3.69 $0.50
222639 2021-02-25 $38.54 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $8.75 $7.90 $0.85
222641 2021-02-25 $43.84 Priority Mail 3-Day Padded Flat Rate Envelope 1 0.70 lbs $8.85 $8.00 $0.85
222643 2021-02-25 $40.91 First-Class Package Service 1 0.70 lbs $5.92 $4.20 $1.72
222644 2021-02-26 $45.09 USPSFirstClass 1 0.25 lbs $6.10 $3.51 $2.59
222645 2021-02-25 $41.30 First-Class Package Service 1 0.70 lbs $6.31 $4.53 $1.78
222646 2021-02-25 $7.49 First-Class Mail Stamped Letter 1 0.01 lbs $3.00 $3.35 $-0.35
222647 2021-02-25 $41.30 First-Class Package Service 1 0.70 lbs $6.31 $4.53 $1.78
222648 2021-02-26 $14.44 USPSFirstClass 1 0.50 lbs $5.45 $5.66 $-0.21
222649 2021-02-25 $11.18 First-Class Package Service 1 0.10 lbs $3.99 $3.49 $0.50
222651 2021-02-25 $15.80 First-Class Package Service 1 0.30 lbs $4.01 $3.51 $0.50
222652 2021-02-25 $28.85 Priority Mail 2-Day 1 3.10 lbs $10.06 $8.34 $1.72
222654 2021-02-25 $15.98 First-Class Package Service 1 0.30 lbs $4.19 $3.69 $0.50
222656 2021-02-25 $24.08 First-Class Package Service - Retail 2 0.10 lbs $5.10 $3.22 $1.88
222659 2021-02-25 $25.77 First-Class Package Service 3 0.50 lbs $5.03 $4.53 $0.50
222660 2021-02-25 $25.18 First-Class Package Service 1 0.35 lbs $4.19 $3.69 $0.50
222662 2021-02-25 $66.28 Ground 1 1.31 lbs $26.02 $22.40 $3.62
222663 2021-02-25 $38.54 Priority Mail 3-Day Small Flat Rate Box 1 1.00 lbs $8.75 $8.00 $0.75
222665 2021-02-25 $42.04 Priority Mail 2-Day Flat Rate Envelope 3 1.05 lbs $8.25 $8.00 $0.25
222666 2021-02-25 $51.74 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $8.75 $7.90 $0.85
222667 2021-02-26 $8.59 First-Class Mail Stamped Letter 1 0.10 lbs $3.40 $3.35 $0.05
222668 2021-02-26 $34.28 Priority Mail 3-Day 1 0.85 lbs $11.29 $8.34 $2.95
222670 2021-02-26 $82.80 Priority Mail 3-Day 1 3.85 lbs $22.81 $21.96 $0.85
222672 2021-02-26 $14.29 First-Class Package Service 1 0.25 lbs $4.08 $3.22 $0.86
222673 2021-02-26 $6.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.35 $-0.15
222674 2021-02-26 $27.27 Priority Mail 2-Day 2 1.54 lbs $11.29 $10.44 $0.85
222675 2021-02-26 $14.11 USPSFirstClass 1 0.10 lbs $4.62 $3.06 $1.56
222676 2021-02-26 $9.58 USPSFirstClass 1 0.05 lbs $4.69 $3.49 $1.20
222677 2021-02-26 $28.34 USPSFirstClass 1 0.15 lbs $5.40 $3.22 $2.18
222678 2021-02-26 $9.90 USPSFirstClass 1 0.06 lbs $4.57 $3.35 $1.22
222679 2021-02-26 $21.16 USPSFirstClass 1 0.40 lbs $5.67 $3.51 $2.16
222680 2021-02-26 $36.67 USPSPriority 1 1.90 lbs $16.22 $16.45 $-0.23
222681 2021-02-26 $9.59 USPSFirstClass 2 0.38 lbs $5.21 $4.53 $0.68
222684 2021-02-26 $8.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.35 $-0.15
222685 2021-02-26 $7.48 USPSFirstClass 1 0.10 lbs $4.59 $3.49 $1.10
222686 2021-02-26 $9.39 USPSFirstClass 1 0.10 lbs $4.40 $3.51 $0.89
222687 2021-02-26 $33.69 USPSFirstClass 1 0.89 lbs $9.99 $10.44 $-0.45
222688 2021-02-26 $12.45 First-Class Package Service 2 0.80 lbs $5.67 $5.42 $0.25
222690 2021-02-26 $22.83 Priority Mail 3-Day Small Flat Rate Box 1 0.41 lbs $8.75 $8.34 $0.41
222691 2021-02-26 $23.03 First-Class Package Service 1 0.35 lbs $4.19 $3.69 $0.50
222696 2021-02-26 $38.54 Priority Mail 3-Day Small Flat Rate Box 1 1.25 lbs $8.75 $8.00 $0.75
222697 2021-02-26 $65.07 Priority Mail 2-Day Small Flat Rate Box 4 1.64 lbs $8.75 $7.90 $0.85
222698 2021-02-26 $23.03 First-Class Package Service 1 0.35 lbs $4.19 $3.69 $0.50
222700 2021-02-26 $49.56 Priority Mail 3-Day 1 1.80 lbs $14.95 $14.10 $0.85
222701 2021-02-26 $7.75 First-Class Mail Stamped Letter 1 0.10 lbs $3.40 $3.35 $0.05
222702 2021-02-26 $20.17 Priority Mail 3-Day 2 0.80 lbs $9.19 $10.44 $-1.25
222706 2021-02-26 $23.68 Ground 1 0.05 lbs $18.89 $15.35 $3.54
222709 2021-02-26 $59.78 Priority Mail 2-Day Medium Flat Rate Box 2 5.67 lbs $15.00 $12.64 $2.36
222711 2021-02-26 $41.04 Priority Mail 3-Day Flat Rate Envelope 1 1.15 lbs $8.25 $8.10 $0.15
222712 2021-02-27 $51.52 First-Class Package International Service 2 0.70 lbs $27.94 $20.19 $7.75
222715 2021-02-27 $21.54 First-Class Package Service 1 0.60 lbs $4.78 $5.81 $-1.03
222718 2021-02-27 $23.24 Priority Mail 3-Day Flat Rate Envelope 1 0.18 lbs $8.25 $7.67 $0.58
222720 2021-02-27 $23.49 First-Class Package Service 1 0.56 lbs $4.70 $4.20 $0.50
222721 2021-02-27 $34.94 Priority Mail 2-Day 1 2.30 lbs $14.95 $22.44 $-7.49
222723 2021-02-27 $47.33 Priority Mail 2-Day 12 1.78 lbs $14.95 $11.63 $3.32
222724 2021-02-27 $32.71 Priority Mail 3-Day Small Flat Rate Box 4 1.04 lbs $8.75 $8.00 $0.75
222725 2021-02-27 $18.54 First-Class Package Service 3 0.32 lbs $4.35 $3.85 $0.50
222726 2021-02-27 $6.28 USPSFirstClass 1 0.01 lbs $4.39 $3.35 $1.04
222727 2021-02-27 $24.18 USPSPriority 1 1.10 lbs $14.39 $11.01 $3.38
222728 2021-02-27 $8.53 USPSFirstClass 2 0.16 lbs $4.55 $3.85 $0.70
222729 2021-02-27 $6.91 USPSFirstClass 1 0.01 lbs $4.42 $3.35 $1.07
222730 2021-02-27 $62.84 USPSFirstClass 1 0.50 lbs $7.85 $4.53 $3.32
222731 2021-02-27 $32.58 First-Class Package Service 4 0.42 lbs $4.62 $4.12 $0.50
222732 2021-02-27 $24.99 First-Class Mail Stamped Letter 11 0.18 lbs $3.60 $3.22 $0.38
222733 2021-02-27 $34.98 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $8.75 $8.00 $0.75
222734 2021-02-27 $8.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.49 $-0.29
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56