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
205973 2019-02-28 $6.64 First-Class Package Service 1 0.03 lbs $3.75 $2.70 $1.05
205974 2019-02-28 $31.79 Priority Mail 3-Day Flat Rate Envelope 1 0.85 lbs $7.80 $7.55 $0.25
205975 2019-02-28 $15.80 First-Class Package Service 1 0.20 lbs $4.01 $3.49 $0.52
205976 2019-02-28 $16.06 Priority Mail 3-Day 2 0.40 lbs $8.99 $7.99 $1.00
205979 2019-02-28 $55.99 Priority Mail 3-Day 16 0.87 lbs $10.55 $9.70 $0.85
205980 2019-02-28 $23.02 First-Class Package Service 8 0.32 lbs $5.79 $4.94 $0.85
205981 2019-02-28 $10.74 First-Class Package Service 1 0.06 lbs $3.75 $2.70 $1.05
205983 2019-02-28 $36.53 First-Class Package International Service 1 0.40 lbs $21.54 $22.33 $-0.79
205984 2019-02-28 $55.97 Priority Mail 2-Day Padded Flat Rate Envelope 3 1.10 lbs $8.40 $7.50 $0.90
205985 2019-02-28 $14.39 First-Class Package Service 2 0.40 lbs $4.41 $4.06 $0.35
205986 2019-03-01 $14.29 First-Class Package Service 4 0.32 lbs $4.33 $3.28 $1.05
205987 2019-03-01 $33.01 First-Class Package International Service 3 0.13 lbs $21.54 $13.54 $8.00
205988 2019-03-01 $23.41 First-Class Package Service 3 0.45 lbs $5.04 $4.19 $0.85
205989 2019-03-01 $50.05 Priority Mail 2-Day Flat Rate Envelope 65 1.56 lbs $7.80 $7.50 $0.30
205992 2019-03-01 $12.38 First-Class Package Service 1 0.18 lbs $3.89 $3.36 $0.53
205993 2019-03-01 $54.82 Priority Mail 3-Day 3 1.64 lbs $10.55 $10.00 $0.55
205994 2019-03-01 $132.96 Priority Mail 2-Day 54 2.60 lbs $8.00 $7.50 $0.50
205995 2019-03-01 $6.30 First-Class Package Service 1 0.01 lbs $3.81 $3.28 $0.53
205996 2019-03-01 $7.73 First-Class Package Service 2 0.06 lbs $3.75 $2.70 $1.05
205997 2019-03-01 $10.89 First-Class Package Service 4 0.20 lbs $3.73 $2.68 $1.05
205998 2019-03-01 $18.53 First-Class Package Service 4 0.45 lbs $5.01 $3.28 $1.73
205999 2019-03-01 $26.09 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $7.80 $5.24 $2.56
206001 2019-03-01 $37.84 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.35 $7.50 $0.85
206002 2019-03-02 $8.46 First-Class Package Service 5 0.13 lbs $4.01 $2.96 $1.05
206003 2019-03-02 $51.15 Priority Mail International 15 2.49 lbs $35.00 $55.10 $-20.10
206004 2019-03-02 $51.84 Priority Mail International 17 2.69 lbs $35.00 $55.10 $-20.10
206005 2019-03-02 $26.06 First-Class Package Service 1 1.05 lbs $6.07 $5.02 $1.05
206009 2019-03-02 $6.75 First-Class Package Service 1 0.05 lbs $3.75 $2.70 $1.05
206010 2019-03-02 $17.36 First-Class Package Service 2 0.72 lbs $6.38 $10.86 $-4.48
206012 2019-03-02 $5.73 First-Class Package Service 2 0.02 lbs $3.75 $2.70 $1.05
206018 2019-03-03 $506.93 Priority Mail International 13 19.29 lbs $161.68 $146.63 $15.05
206019 2019-03-03 $48.84 Priority Mail 3-Day Small Flat Rate Box 1 1.50 lbs $8.35 $7.50 $0.85
206020 2019-03-03 $13.88 First-Class Package Service 1 0.08 lbs $3.89 $2.84 $1.05
206022 2019-03-03 $46.94 Priority Mail 2-Day 2 1.10 lbs $10.55 $7.50 $3.05
206023 2019-03-03 $24.32 First-Class Package Service 1 0.40 lbs $4.33 $3.96 $0.37
206026 2019-03-03 $49.69 First-Class Package International Service 1 1.00 lbs $30.33 $22.33 $8.00
206030 2019-03-04 $459.97 Ground 5 43.85 lbs $90.74 $85.91 $4.83
206031 2019-03-04 $43.25 Priority Mail 2-Day 7 1.60 lbs $12.97 $10.03 $2.94
206032 2019-03-04 $20.56 Priority Mail 2-Day 4 1.00 lbs $11.08 $10.23 $0.85
206033 2019-03-04 $84.42 Priority Mail 2-Day 5 4.49 lbs $16.97 $17.93 $-0.96
206034 2019-03-04 $35.35 First-Class Package Service 2 0.75 lbs $6.07 $5.02 $1.05
206035 2019-03-04 $7.99 First-Class Package Service 2 0.06 lbs $4.01 $2.96 $1.05
206036 2019-03-04 $58.69 Priority Mail 2-Day 4 0.94 lbs $8.73 $7.88 $0.85
206040 2019-03-05 $48.84 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $8.35 $7.50 $0.85
206041 2019-03-05 $71.46 Priority Mail 3-Day Medium Flat Rate Box 3 2.15 lbs $13.80 $10.00 $3.80
206042 2019-03-05 $12.18 First-Class Package Service 3 0.18 lbs $3.81 $3.28 $0.53
206043 2019-03-05 $48.74 Priority Mail 3-Day Small Flat Rate Box 1 1.60 lbs $8.35 $7.50 $0.85
206044 2019-03-05 $36.26 First-Class Package Service 1 0.31 lbs $4.27 $3.22 $1.05
206046 2019-03-05 $41.14 Priority Mail 3-Day Small Flat Rate Box 1 1.15 lbs $8.35 $7.50 $0.85
206047 2019-03-05 $36.79 Priority Mail 3-Day Flat Rate Envelope 1 1.10 lbs $7.80 $7.50 $0.30
206048 2019-03-05 $11.88 First-Class Package Service 1 0.17 lbs $3.89 $2.84 $1.05
206050 2019-03-06 $198.50 Priority Mail 2-Day Large Flat Rate Box 25 13.25 lbs $31.25 $17.60 $13.65
206051 2019-03-06 $13.68 First-Class Package Service 7 0.13 lbs $3.75 $3.22 $0.53
206052 2019-03-06 $50.33 Priority Mail 3-Day 1 1.10 lbs $10.55 $9.70 $0.85
206053 2019-03-06 $8.12 First-Class Package Service 2 0.07 lbs $4.14 $3.63 $0.51
206054 2019-03-06 $19.87 First-Class Package Service 2 0.14 lbs $3.89 $3.36 $0.53
206055 2019-03-06 $17.58 Priority Mail 2-Day Flat Rate Envelope 2 1.00 lbs $7.80 $7.55 $0.25
206058 2019-03-06 $107.87 Priority Mail 2-Day Large Flat Rate Box 18 7.32 lbs $36.05 $33.40 $2.65
206060 2019-03-07 $14.03 First-Class Package Service 1 0.30 lbs $4.54 $3.49 $1.05
206061 2019-03-07 $28.59 First-Class Package Service 2 0.60 lbs $5.01 $3.96 $1.05
206062 2019-03-07 $42.07 Priority Mail 2-Day 4 2.60 lbs $10.11 $10.03 $0.08
206063 2019-03-07 $12.24 First-Class Package Service 3 0.22 lbs $4.27 $3.22 $1.05
206070 2019-03-07 $11.54 First-Class Package Service 4 0.44 lbs $5.38 $4.33 $1.05
206071 2019-03-07 $18.60 First-Class Package Service 1 0.05 lbs $3.81 $2.76 $1.05
206072 2019-03-07 $36.54 First-Class Package Service 2 0.15 lbs $3.75 $3.22 $0.53
206073 2019-03-07 $5.74 First-Class Package Service 1 0.07 lbs $3.75 $3.22 $0.53
206075 2019-03-07 $20.72 First-Class Package Service 7 0.80 lbs $6.09 $5.24 $0.85
206080 2019-03-06 $15.98 Priority Mail 2-Day Large Flat Rate Box 2 0.34 lbs $0.00 $76.42 $-76.42
206081 2019-03-08 $32.09 First-Class Package Service 15 0.51 lbs $5.24 $3.49 $1.75
206082 2019-03-08 $21.78 Priority Mail 3-Day Flat Rate Envelope 2 0.12 lbs $7.80 $6.95 $0.85
206084 2019-03-08 $71.67 Priority Mail 3-Day Medium Flat Rate Box 3 3.05 lbs $13.80 $10.00 $3.80
206085 2019-03-09 $37.34 Priority Mail 2-Day 1 1.05 lbs $9.35 $8.76 $0.59
206089 2019-03-10 $24.26 First-Class Package Service 1 0.40 lbs $4.27 $3.88 $0.39
206090 2019-03-10 $62.57 Priority Mail 3-Day 2 2.65 lbs $10.11 $9.26 $0.85
206091 2019-03-10 $5.88 First-Class Package Service 1 0.10 lbs $3.89 $2.84 $1.05
206092 2019-03-10 $10.10 First-Class Package Service 1 0.27 lbs $5.11 $5.24 $-0.13
206093 2019-03-10 $32.45 Priority Mail 2-Day 6 1.80 lbs $10.11 $9.26 $0.85
206094 2019-03-10 $11.88 First-Class Package Service 1 0.07 lbs $3.89 $2.84 $1.05
206095 2019-03-10 $86.89 Priority Mail 2-Day Small Flat Rate Box 2 9.40 lbs $8.35 $7.50 $0.85
206096 2019-03-10 $13.29 First-Class Package Service 4 0.50 lbs $4.73 $3.88 $0.85
206097 2019-03-10 $18.97 First-Class Package Service 4 0.21 lbs $4.01 $2.96 $1.05
206098 2019-03-10 $28.52 First-Class Package International Service 2 0.06 lbs $21.54 $13.54 $8.00
206100 2019-03-10 $21.75 First-Class Package Service 2 0.39 lbs $4.27 $3.88 $0.39
206101 2019-03-11 $85.28 Priority Mail 2-Day Medium Flat Rate Box 10 2.12 lbs $13.80 $10.55 $3.25
206103 2019-03-11 $7.64 First-Class Package Service 1 0.03 lbs $3.71 $2.66 $1.05
206104 2019-03-11 $27.69 Priority Mail 3-Day 2 1.90 lbs $10.11 $9.26 $0.85
206106 2019-03-11 $11.05 First-Class Package Service 4 0.20 lbs $3.89 $3.36 $0.53
206107 2019-03-12 $9.80 First-Class Package Service 1 0.13 lbs $3.81 $3.28 $0.53
206110 2019-03-12 $13.47 First-Class Package Service 4 0.50 lbs $4.91 $4.06 $0.85
206111 2019-03-12 $11.74 First-Class Package Service 1 0.05 lbs $3.75 $2.70 $1.05
206112 2019-03-12 $38.14 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.35 $7.50 $0.85
206115 2019-03-12 $10.59 Priority Mail 2-Day Flat Rate Envelope 1 0.06 lbs $7.80 $6.95 $0.85
206117 2019-03-12 $45.58 Priority Mail 3-Day Flat Rate Envelope 2 1.80 lbs $7.80 $7.55 $0.25
206118 2019-03-12 $36.49 Priority Mail 2-Day 5 1.64 lbs $8.46 $7.65 $0.81
206119 2019-03-12 $14.00 First-Class Package Service 1 0.08 lbs $4.01 $2.96 $1.05
206120 2019-03-13 $38.43 Priority Mail 3-Day Flat Rate Envelope 3 0.60 lbs $7.80 $7.50 $0.30
206121 2019-03-13 $46.35 Priority Mail 2-Day Flat Rate Envelope 5 1.20 lbs $7.80 $10.23 $-2.43
206123 2019-03-13 $15.32 First-Class Package Service 2 0.25 lbs $4.54 $3.49 $1.05
206124 2019-03-13 $7.79 First-Class Package Service 2 0.06 lbs $3.81 $2.76 $1.05
206126 2019-03-13 $10.47 First-Class Package Service 20 0.20 lbs $3.81 $2.76 $1.05
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56