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
227262 2021-09-24 $21.51 USPS First Class 1 0.19 lbs $5.02 $5.81 $-0.79
227263 2021-09-24 $41.79 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $9.00 $7.90 $1.10
227268 2021-09-24 $53.62 Ground 1 1.25 lbs $20.83 $16.13 $4.70
227270 2021-09-25 $47.47 Priority Mail 3-Day Flat Rate Envelope 3 1.11 lbs $8.50 $8.00 $0.50
227271 2021-09-25 $13.24 USPS First Class 1 0.10 lbs $4.75 $3.49 $1.26
227274 2021-09-25 $113.69 United States 1 3.20 lbs $9.75 $9.21 $0.54
227325 2021-09-29 $144.39 Ground 2 1.41 lbs $12.41 $14.35 $-1.94
227369 2021-10-04 $86.71 Priority Mail 2-Day 4 2.45 lbs $15.95 $12.32 $3.63
227423 2021-11-26 $69.51 Priority Mail 2-Day 18 2.79 lbs $27.05 $15.54 $11.51
227664 2021-10-31 $92.92 Priority Mail 2-Day Medium Flat Rate Box 3 2.87 lbs $16.15 $8.30 $7.85
227669 2021-10-31 $73.65 Priority Mail 3-Day 4 1.86 lbs $11.49 $13.34 $-1.85
227685 2021-11-01 $33.14 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $9.25 $8.45 $0.80
227774 2021-11-09 $37.71 Ground 1 0.30 lbs $25.72 $4.06 $21.66
227964 2021-11-25 $160.28 Priority Mail 2-Day 9 4.94 lbs $21.19 $13.63 $7.56
227966 2021-11-25 $99.41 Priority Mail 2-Day 10 3.26 lbs $13.55 $9.55 $4.00
227974 2021-11-26 $51.27 Priority Mail 2-Day 7 1.70 lbs $10.07 $8.49 $1.58
227978 2021-11-26 $45.99 Priority Mail 3-Day 6 1.38 lbs $12.29 $11.62 $0.67
227980 2021-11-26 $42.47 Priority Mail 3-Day 4 0.99 lbs $12.29 $11.62 $0.67
227987 2021-11-26 $102.10 Priority Mail 3-Day 4 3.46 lbs $12.28 $9.55 $2.73
227999 2021-11-26 $44.74 Priority Mail 2-Day 1 1.00 lbs $9.14 $8.38 $0.76
228057 2021-11-29 $46.58 Priority Mail 2-Day 1 1.20 lbs $9.59 $8.25 $1.34
228081 2021-11-26 $58.57 Priority Mail 2-Day 3 1.90 lbs $12.28 $9.55 $2.73
228122 2021-12-06 $116.16 Priority Mail 3-Day 6 4.55 lbs $11.48 $10.25 $1.23
228246 2021-12-19 $86.43 Priority Mail 2-Day 6 2.06 lbs $11.49 $9.55 $1.94
228277 2021-12-23 $63.23 Priority Mail 2-Day Flat Rate Envelope 2 1.80 lbs $9.25 $8.30 $0.95
228281 2021-12-24 $103.01 Priority Mail 2-Day 2 2.85 lbs $11.53 $8.45 $3.08
228320 2021-12-29 $81.48 Priority Mail 2-Day 6 4.83 lbs $10.74 $9.61 $1.13
228352 2022-01-02 $85.28 Priority Mail 2-Day Flat Rate Envelope 2 2.80 lbs $8.50 $8.30 $0.20
228365 2022-01-04 $5.72 First-Class Mail Stamped Letter 1 0.01 lbs $3.73 $3.86 $-0.13
228403 2022-01-09 $10.91 First-Class Package Service 4 0.30 lbs $5.45 $4.67 $0.78
228431 2022-01-14 $4.61 First-Class Mail Stamped Letter 2 0.06 lbs $1.63 $3.72 $-2.09
228450 2022-01-16 $20.34 Priority Mail 3-Day Flat Rate Envelope 1 0.25 lbs $8.85 $8.25 $0.60
228536 2022-01-23 $10.76 First-Class Package Service 2 0.12 lbs $4.78 $3.58 $1.20
228574 2022-01-29 $52.47 First-Class Package Service 1 0.73 lbs $7.48 $6.68 $0.80
228617 2022-02-02 $21.54 First-Class Package Service 3 0.30 lbs $5.07 $5.72 $-0.65
228753 2022-02-15 $42.14 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $9.35 $8.25 $1.10
228792 2022-02-20 $29.88 First-Class Package Service 6 0.31 lbs $4.94 $3.99 $0.95
228810 2022-02-21 $38.02 First-Class Package Service 14 0.85 lbs $7.16 $5.96 $1.20
228815 2020-12-21 $27.79 Priority Mail 3-Day Medium Flat Rate Box 1 0.90 lbs $9.40 $8.45 $0.95
228839 2022-02-25 $63.77 Priority Mail 2-Day 2 1.47 lbs $9.59 $8.49 $1.10
228864 2022-02-28 $15.42 First-Class Package Service 5 0.15 lbs $4.57 $3.64 $0.93
228865 2022-02-28 $36.42 Priority Mail 2-Day Flat Rate Envelope 3 0.63 lbs $8.85 $8.25 $0.60
228882 2022-03-02 $0.00 Priority Mail 3-Day 2 0.84 lbs $12.72 $12.42 $0.30
228891 2022-03-04 $16.31 First-Class Package Service 15 0.19 lbs $5.35 $3.86 $1.49
228925 2022-03-09 $11.68 First-Class Package Service 1 0.20 lbs $5.19 $3.99 $1.20
228945 2022-03-12 $17.06 First-Class Package Service 1 0.30 lbs $5.07 $4.27 $0.80
228951 2022-03-13 $32.43 First-Class Package Service 7 0.35 lbs $5.70 $3.87 $1.83
228965 2022-03-15 $26.39 USPS Priority Mail 1 2.30 lbs $15.40 $17.18 $-1.78
228966 2022-03-15 $57.27 USPS Priority Mail 3 0.17 lbs $34.80 $7.72 $27.08
228968 2022-03-15 $28.31 First-Class Package Service 1 0.40 lbs $5.62 $8.84 $-3.22
228970 2022-03-16 $34.34 USPS Priority Mail 1 0.85 lbs $9.85 $18.24 $-8.39
228972 2022-03-16 $15.39 First-Class Package Service 3 0.15 lbs $4.92 $7.44 $-2.52
228977 2022-03-16 $37.84 Priority Mail 3-Day Flat Rate Envelope 1 0.85 lbs $8.85 $8.45 $0.40
228978 2022-03-16 $29.07 First-Class Package Service 1 0.30 lbs $5.08 $4.68 $0.40
228979 2022-03-16 $13.27 First-Class Package Service 1 0.05 lbs $4.62 $3.42 $1.20
228980 2022-03-16 $16.56 First-Class Package Service 1 0.25 lbs $5.07 $3.87 $1.20
228981 2022-03-17 $17.65 First-Class Package Service 2 0.78 lbs $6.67 $5.72 $0.95
228984 2022-03-17 $175.59 Priority Mail 3-Day 1 6.05 lbs $15.60 $14.50 $1.10
228985 2022-03-17 $29.38 Priority Mail 2-Day 1 3.10 lbs $10.59 $8.88 $1.71
228987 2022-03-18 $9.75 First-Class Package Service 2 0.02 lbs $4.62 $3.42 $1.20
228988 2022-03-18 $14.07 First-Class Package Service 1 0.05 lbs $4.78 $3.58 $1.20
228989 2022-03-18 $15.25 First-Class Package Service 3 0.09 lbs $4.78 $3.58 $1.20
228993 2022-03-18 $22.04 Priority Mail 2-Day Flat Rate Envelope 1 0.30 lbs $8.85 $8.25 $0.60
228994 2022-03-18 $36.77 Priority Mail 2-Day Flat Rate Envelope 8 0.28 lbs $8.85 $7.75 $1.10
228996 2022-03-19 $80.00 Priority Mail 2-Day 3 2.12 lbs $11.03 $9.55 $1.48
228997 2022-03-19 $8.14 First-Class Package Service 2 0.07 lbs $5.01 $3.42 $1.59
228998 2022-03-19 $47.11 Priority Mail 3-Day Small Flat Rate Box 1 1.50 lbs $9.35 $8.25 $1.10
229002 2022-03-20 $24.96 First-Class Package Service 5 0.25 lbs $5.01 $3.42 $1.59
229005 2022-03-20 $38.95 First-Class Package Service 10 0.34 lbs $5.35 $4.15 $1.20
229006 2022-03-20 $24.57 First-Class Package Service 1 0.12 lbs $4.68 $3.87 $0.81
229007 2022-03-21 $29.05 First-Class Package Service 3 0.36 lbs $5.08 $4.68 $0.40
229008 2022-03-21 $14.24 USPS Priority Mail 1 0.10 lbs $9.45 $7.75 $1.70
229009 2022-03-21 $77.59 USPS Priority Mail 1 2.20 lbs $21.20 $13.54 $7.66
229012 2022-03-21 $11.76 First-Class Package Service 1 0.06 lbs $4.62 $3.42 $1.20
229017 2022-03-21 $133.56 Priority Mail 2-Day 20 1.20 lbs $13.76 $9.68 $4.08
229018 2022-03-21 $6.92 First-Class Package Service 1 0.06 lbs $4.78 $3.58 $1.20
229019 2022-03-21 $61.02 First-Class Package Service 1 0.56 lbs $6.03 $4.83 $1.20
229021 2022-03-22 $19.57 First-Class Package Service 5 0.05 lbs $4.62 $3.42 $1.20
229023 2022-03-22 $27.43 First-Class Package Service 2 0.43 lbs $5.45 $4.50 $0.95
229024 2022-03-22 $21.72 USPS Shipping 1 0.60 lbs $7.23 $4.83 $2.40
229025 2022-03-22 $49.34 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $9.35 $8.25 $1.10
229026 2022-03-23 $8.76 First-Class Package Service 1 0.04 lbs $4.62 $3.42 $1.20
229028 2022-03-23 $35.23 Priority Mail 2-Day Flat Rate Envelope 2 1.03 lbs $8.85 $8.25 $0.60
229030 2022-03-24 $34.19 USPS Shipping 1 3.10 lbs $14.60 $5.08 $9.52
229033 2022-03-24 $13.05 First-Class Package Service 2 0.38 lbs $5.07 $3.48 $1.59
229034 2022-03-24 $82.81 Priority Mail 3-Day Flat Rate Envelope 4 1.63 lbs $8.85 $8.25 $0.60
229035 2022-03-24 $66.22 First-Class Package International Service 1 1.20 lbs $37.41 $29.36 $8.05
229036 2022-03-25 $22.55 First-Class Package Service 3 0.41 lbs $5.08 $3.58 $1.50
229037 2022-03-25 $15.94 USPS Priority Mail 1 0.06 lbs $10.15 $8.25 $1.90
229039 2022-03-25 $57.64 Priority Mail 2-Day 3 1.15 lbs $13.76 $12.66 $1.10
229040 2022-03-25 $67.42 Priority Mail 2-Day 1 2.20 lbs $11.03 $9.55 $1.48
229043 2022-03-25 $19.06 First-Class Package Service 2 0.38 lbs $5.35 $3.86 $1.49
229044 2022-03-26 $15.24 USPS Priority Mail 1 0.06 lbs $9.45 $8.25 $1.20
229048 2022-03-27 $43.54 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $8.85 $8.25 $0.60
229049 2022-03-27 $18.80 First-Class Package Service 4 0.20 lbs $5.01 $3.42 $1.59
229051 2022-03-28 $19.72 First-Class Package Service 3 0.15 lbs $5.35 $3.86 $1.49
229055 2022-03-28 $12.35 USPS Shipping 1 0.05 lbs $5.06 $3.58 $1.48
229056 2022-03-28 $34.19 USPS Shipping 1 3.10 lbs $14.60 $5.08 $9.52
229057 2022-03-28 $8.87 USPS Shipping 1 0.03 lbs $4.08 $3.42 $0.66
229058 2022-03-28 $7.22 USPS Shipping 1 0.06 lbs $3.93 $3.42 $0.51
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56