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
230601 2022-12-08 $56.43 Priority Mail Small Flat Rate Box 1 1.50 lbs $10.10 $8.10 $2.00
230602 2022-12-08 $15.95 First-Class Package Service 3 0.13 lbs $5.08 $3.88 $1.20
230603 2022-12-08 $48.55 Priority Mail 1 1.15 lbs $14.56 $8.10 $6.46
230604 2022-12-09 $49.53 Priority Mail 1 1.25 lbs $9.84 $8.10 $1.74
230608 2022-12-10 $13.49 USPS First Class 1 0.06 lbs $5.60 $4.26 $1.34
230609 2022-12-10 $10.70 First-Class Package Service 1 0.10 lbs $5.46 $4.26 $1.20
230613 2022-12-11 $13.24 USPS First Class 1 0.06 lbs $5.35 $3.98 $1.37
230614 2022-12-12 $56.71 Priority Mail Small Flat Rate Box 1 1.65 lbs $10.10 $8.10 $2.00
230615 2022-12-12 $9.50 USPS Shipping 1 0.25 lbs $5.51 $4.55 $0.96
230616 2022-12-12 $137.02 Priority Mail Medium Flat Rate Box 17 2.18 lbs $16.65 $10.28 $6.37
230618 2022-12-12 $19.47 First-Class Package Service 1 0.10 lbs $5.08 $3.88 $1.20
230619 2022-12-12 $43.41 Priority Mail 1 3.20 lbs $22.67 $18.95 $3.72
230620 2022-12-12 $13.67 First-Class Package Service 1 0.05 lbs $5.18 $3.98 $1.20
230623 2022-12-13 $10.56 First-Class Package Service 1 0.07 lbs $5.32 $4.12 $1.20
230625 2022-12-13 $9.40 First-Class Package Service 3 0.08 lbs $5.18 $3.98 $1.20
230626 2022-12-13 $38.76 Priority Mail 6 1.33 lbs $13.52 $12.42 $1.10
230627 2022-12-13 $29.61 Priority Mail Small Flat Rate Box 1 1.00 lbs $10.10 $8.10 $2.00
230628 2022-12-13 $126.28 Priority Mail Padded Flat Rate Envelope 2 4.25 lbs $10.30 $8.30 $2.00
230629 2022-12-14 $14.17 First-Class Package Service 1 0.08 lbs $5.18 $3.98 $1.20
230632 2022-12-14 $13.08 First-Class Package Service - Retail 2 0.06 lbs $7.85 $4.26 $3.59
230633 2022-12-14 $13.49 USPS First Class 1 0.06 lbs $5.60 $4.26 $1.34
230634 2022-12-14 $39.78 Priority Mail Small Flat Rate Box 1 1.15 lbs $10.10 $8.10 $2.00
230635 2022-12-14 $10.49 First-Class Package Service 2 0.38 lbs $5.26 $3.67 $1.59
230636 2022-12-14 $16.93 First-Class Package Service 1 0.15 lbs $5.47 $3.88 $1.59
230642 2022-12-15 $15.90 First-Class Package Service 1 0.30 lbs $5.59 $4.39 $1.20
230643 2022-12-15 $14.84 First-Class Package Service 1 0.15 lbs $5.59 $4.12 $1.47
230644 2022-12-15 $11.39 USPS First Class 1 0.05 lbs $5.60 $4.26 $1.34
230645 2022-12-15 $10.14 USPS First Class 1 0.06 lbs $5.35 $3.98 $1.37
230646 2022-12-16 $13.30 USPS Shipping 1 0.12 lbs $5.51 $4.26 $1.25
230647 2022-12-16 $19.37 First-Class Package Service 2 0.23 lbs $5.59 $4.39 $1.20
230651 2022-12-17 $35.00 First-Class Package Service 3 0.68 lbs $7.63 $6.68 $0.95
230652 2022-12-18 $43.51 Priority Mail Medium Flat Rate Box 14 1.86 lbs $16.65 $12.42 $4.23
230661 2022-12-19 $15.89 USPS First Class 1 0.20 lbs $5.60 $4.55 $1.05
230662 2022-12-18 $8.84 USPS First Class 1 0.05 lbs $4.95 $3.67 $1.28
230663 2022-12-18 $13.19 USPS First Class 1 0.06 lbs $5.30 $3.88 $1.42
230664 2022-12-18 $14.74 USPS First Class 1 0.55 lbs $6.75 $6.51 $0.24
230665 2022-12-18 $10.34 USPS First Class 1 0.25 lbs $4.95 $3.49 $1.46
230666 2022-12-17 $9.29 USPS First Class 1 0.05 lbs $5.30 $3.88 $1.42
230667 2022-12-19 $13.30 USPS Shipping 1 0.12 lbs $5.51 $4.12 $1.39
230668 2022-12-19 $15.50 USPS Shipping 1 0.05 lbs $5.51 $3.67 $1.84
230669 2022-12-19 $17.06 First-Class Package Service 2 0.03 lbs $5.08 $3.88 $1.20
230671 2022-12-19 $25.99 First-Class Package Service 4 0.22 lbs $5.23 $4.28 $0.95
230674 2022-12-20 $15.45 First-Class Package Service 1 0.07 lbs $5.46 $4.55 $0.91
230675 2022-12-20 $26.36 USPS First-Class Mail or Priority Mail 1 0.25 lbs $5.51 $4.27 $1.24
230676 2022-12-20 $15.19 USPS First Class 1 0.07 lbs $4.90 $3.64 $1.26
230678 2022-12-20 $95.43 Priority Mail 13 1.72 lbs $13.59 $7.64 $5.95
230680 2022-12-21 $17.15 First-Class Package Service 3 0.15 lbs $5.18 $3.98 $1.20
230681 2022-12-21 $10.55 First-Class Package Service 2 0.02 lbs $5.32 $4.12 $1.20
230682 2022-12-21 $10.69 USPS First Class 1 0.23 lbs $5.30 $3.49 $1.81
230684 2022-12-22 $71.62 USPS Shipping 1 0.75 lbs $6.63 $6.36 $0.27
230686 2022-12-22 $322.70 Ground Home Delivery 1 21.06 lbs $51.98 $36.16 $15.82
230688 2022-12-22 $13.07 First-Class Package Service 1 0.06 lbs $5.18 $3.98 $1.20
230690 2022-12-22 $16.38 First-Class Package Service 1 0.30 lbs $5.47 $4.90 $0.57
230691 2022-12-22 $15.59 USPS First Class 1 0.15 lbs $5.30 $3.88 $1.42
230692 2022-12-22 $12.79 USPS First Class 1 0.05 lbs $5.30 $3.88 $1.42
230693 2022-12-22 $13.49 USPS First Class 1 0.06 lbs $5.60 $4.26 $1.34
230694 2022-12-23 $12.20 USPS Shipping 1 0.08 lbs $5.51 $3.88 $1.63
230695 2022-12-23 $14.87 First-Class Package Service 1 0.62 lbs $7.63 $6.68 $0.95
230697 2022-12-23 $83.75 Priority Mail 2 1.75 lbs $14.56 $13.47 $1.09
230701 2022-12-23 $19.00 USPS First Class 1 0.06 lbs $5.60 $4.26 $1.34
230702 2022-12-24 $7.56 First-Class Package Service 1 0.01 lbs $5.32 $4.12 $1.20
230703 2022-12-24 $30.60 First-Class Package Service 1 0.40 lbs $7.07 $4.90 $2.17
230704 2022-12-25 $33.86 First-Class Package Service 2 0.74 lbs $7.88 $6.68 $1.20
230706 2022-12-25 $8.42 First-Class Package Service 1 0.02 lbs $5.18 $3.98 $1.20
230709 2022-12-25 $9.74 USPS First Class 1 0.05 lbs $4.95 $3.67 $1.28
230710 2022-12-25 $14.09 USPS First Class 1 0.19 lbs $5.60 $4.55 $1.05
230711 2022-12-25 $13.29 USPS First Class 1 0.04 lbs $5.40 $4.12 $1.28
230712 2022-12-24 $15.39 USPS First Class 1 0.05 lbs $5.40 $4.39 $1.01
230713 2022-12-26 $10.50 USPS Shipping 1 0.20 lbs $5.51 $4.39 $1.12
230714 2022-12-26 $15.22 First-Class Package Service 1 0.09 lbs $5.23 $4.28 $0.95
230715 2022-12-26 $39.78 Priority Mail Small Flat Rate Box 1 1.10 lbs $10.10 $8.10 $2.00
230716 2022-12-27 $17.48 First-Class Package Service 2 0.32 lbs $5.50 $4.55 $0.95
230717 2022-12-26 $29.89 USPS First Class 1 0.15 lbs $5.60 $4.26 $1.34
230718 2022-12-26 $11.34 USPS First Class 1 0.07 lbs $5.35 $3.98 $1.37
230720 2022-12-27 $29.69 USPS First Class 1 0.15 lbs $5.40 $4.39 $1.01
230724 2022-12-28 $12.59 USPS First Class 1 0.03 lbs $5.60 $4.26 $1.34
230725 2022-12-27 $9.94 USPS First Class 1 0.02 lbs $4.95 $3.67 $1.28
230726 2022-12-28 $16.28 USPS Shipping 1 0.10 lbs $5.23 $4.55 $0.68
230727 2022-12-28 $28.79 USPS Shipping 1 0.50 lbs $5.80 $8.49 $-2.69
230728 2022-12-28 $13.30 USPS Shipping 1 0.12 lbs $5.51 $4.27 $1.24
230730 2022-12-28 $14.29 USPS First Class 1 0.20 lbs $5.30 $6.12 $-0.82
230732 2022-12-29 $52.92 Priority Mail 1 1.44 lbs $9.84 $8.30 $1.54
230734 2022-12-29 $153.50 Ground Home Delivery 1 3.38 lbs $26.01 $19.74 $6.27
230735 2022-12-28 $9.39 USPS First Class 1 0.20 lbs $5.40 $4.12 $1.28
230736 2022-12-28 $15.74 USPS First Class 1 0.05 lbs $4.95 $3.67 $1.28
230737 2022-12-29 $19.46 First-Class Package Service 2 0.20 lbs $5.48 $3.98 $1.50
230738 2022-12-29 $108.44 Priority Mail Medium Flat Rate Box 5 2.50 lbs $16.65 $8.30 $8.35
230747 2022-12-30 $46.07 USPS First Class 1 0.85 lbs $9.75 $5.82 $3.93
230751 2022-12-30 $21.41 Priority Mail 5 0.69 lbs $11.06 $8.10 $2.96
230753 2022-12-30 $25.61 First-Class Package Service 1 0.60 lbs $5.62 $5.82 $-0.20
230754 2022-12-30 $19.00 USPS First Class 1 0.06 lbs $5.60 $4.26 $1.34
230755 2022-12-31 $10.93 USPS Shipping 1 0.05 lbs $5.23 $3.67 $1.56
230756 2022-12-31 $45.71 Priority Mail Small Flat Rate Box 1 1.00 lbs $10.10 $8.10 $2.00
230757 2022-12-31 $10.82 First-Class Package Service 2 0.38 lbs $5.59 $4.12 $1.47
230758 2023-01-01 $59.80 Priority Mail 4 1.36 lbs $9.84 $8.10 $1.74
230759 2023-01-01 $11.42 First-Class Package Service 1 0.03 lbs $5.18 $3.98 $1.20
230761 2023-01-01 $16.70 First-Class Package Service 1 0.35 lbs $5.59 $4.39 $1.20
230763 2023-01-01 $9.44 USPS First Class 1 0.06 lbs $4.95 $3.67 $1.28
230764 2023-01-01 $12.29 USPS First Class 1 0.10 lbs $5.60 $4.26 $1.34
230765 2023-01-01 $20.42 USPS Parcel Select Ground 1 0.70 lbs $9.43 $9.43 $0.00
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56