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.

21025 matching order(s)

Order ID ▲DateOrder TotalShipping Method# ProductsTotal WeightShipping ChargedShipping PaidProfit
216998 2020-10-27 $14.01 USPSFirstClass 1 0.05 lbs $4.52 $3.30 $1.22
216999 2020-10-27 $9.59 First-Class Package Service 1 0.45 lbs $4.70 $4.25 $0.45
217000 2020-10-27 $7.83 First-Class Mail Stamped Letter 2 0.04 lbs $3.35 $3.03 $0.32
217001 2020-10-27 $25.34 Priority Mail 3-Day 6 0.42 lbs $9.40 $8.55 $0.85
217002 2020-10-27 $11.83 USPSFirstClass 1 0.19 lbs $4.35 $3.18 $1.17
217003 2020-10-27 $20.13 USPSFirstClass 2 0.38 lbs $5.15 $3.64 $1.51
217004 2020-10-27 $6.56 USPSFirstClass 1 0.19 lbs $4.05 $3.09 $0.96
217005 2020-10-27 $17.89 First-Class Package Service 1 0.35 lbs $4.58 $4.33 $0.25
217007 2020-10-27 $25.21 Priority Mail 2-Day 2 1.06 lbs $11.79 $10.88 $0.91
217008 2020-10-27 $7.92 USPSFirstClass 1 0.03 lbs $4.17 $3.18 $0.99
217009 2020-10-27 $6.00 First-Class Package Service 1 0.19 lbs $4.01 $3.09 $0.92
217012 2020-10-27 $12.30 First-Class Mail Stamped Letter 5 0.06 lbs $3.35 $3.30 $0.05
217015 2020-10-27 $23.09 First-Class Package Service 1 0.40 lbs $4.70 $4.25 $0.45
217016 2020-10-27 $7.34 First-Class Mail Stamped Letter 1 0.08 lbs $3.35 $3.03 $0.32
217017 2020-10-27 $11.07 First-Class Package Service 2 0.21 lbs $4.09 $3.39 $0.70
217018 2020-10-27 $13.44 Priority Mail 3-Day 1 0.05 lbs $9.05 $8.05 $1.00
217020 2020-10-27 $24.07 First-Class Package Service 2 0.24 lbs $4.09 $3.64 $0.45
217023 2020-10-27 $10.73 First-Class Package Service 2 0.06 lbs $3.75 $3.30 $0.45
217024 2020-10-27 $53.75 Ground 8 2.79 lbs $21.44 $16.21 $5.23
217025 2020-10-28 $8.25 USPSFirstClass 1 0.05 lbs $4.00 $2.99 $1.01
217027 2020-10-28 $23.69 USPSFirstClass 1 0.15 lbs $4.80 $3.03 $1.77
217029 2020-10-28 $139.05 Ground 5 15.96 lbs $0.00 $78.85 $-78.85
217030 2020-10-28 $51.89 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $8.90 $7.90 $1.00
217034 2020-10-28 $29.66 First-Class Package Service 2 0.56 lbs $4.68 $4.43 $0.25
217035 2020-10-28 $7.19 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $3.18 $0.02
217036 2020-10-28 $17.47 USPSFirstClass 1 0.30 lbs $5.36 $3.64 $1.72
217037 2020-10-28 $34.03 Priority Mail 2-Day 1 0.95 lbs $11.24 $10.82 $0.42
217038 2020-10-28 $9.14 First-Class Mail Stamped Letter 1 0.15 lbs $3.65 $3.18 $0.47
217041 2020-10-28 $4.19 First-Class Mail Stamped Letter 1 0.01 lbs $3.20 $3.03 $0.17
217045 2020-10-28 $29.93 USPSPriority 1 7.60 lbs $17.66 $12.37 $5.29
217047 2020-10-28 $30.67 Priority Mail 3-Day Flat Rate Envelope 3 1.15 lbs $8.40 $8.15 $0.25
217048 2020-10-28 $27.46 First-Class Package Service 2 0.60 lbs $4.88 $4.43 $0.45
217049 2020-10-28 $14.14 First-Class Package Service 1 0.20 lbs $3.95 $3.50 $0.45
217050 2020-10-28 $26.01 First-Class Package Service 1 0.40 lbs $5.02 $4.57 $0.45
217051 2020-10-28 $15.88 First-Class Package Service 1 0.30 lbs $4.09 $3.64 $0.45
217054 2020-10-29 $21.28 USPSFirstClass 4 0.20 lbs $4.20 $3.64 $0.56
217055 2020-10-29 $12.97 USPSFirstClass 1 0.15 lbs $4.39 $3.64 $0.75
217056 2020-10-29 $14.44 First-Class Package Service 1 0.30 lbs $4.22 $3.77 $0.45
217059 2020-10-29 $7.87 First-Class Package Service 1 0.06 lbs $3.88 $3.43 $0.45
217061 2020-10-29 $6.33 First-Class Mail Stamped Letter 2 0.05 lbs $3.35 $3.30 $0.05
217062 2020-10-29 $16.47 First-Class Package Service 4 0.24 lbs $4.01 $3.56 $0.45
217064 2020-10-29 $4.99 First-Class Mail Stamped Letter 1 0.14 lbs $3.50 $3.77 $-0.27
217066 2020-10-29 $23.42 First-Class Package Service 3 0.32 lbs $3.95 $3.50 $0.45
217068 2020-10-29 $18.95 USPSFirstClass 1 0.05 lbs $4.85 $3.43 $1.42
217069 2020-10-29 $97.83 Priority Mail 3-Day 6 8.64 lbs $13.41 $10.54 $2.87
217072 2020-10-29 $69.50 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.75 lbs $9.00 $8.15 $0.85
217073 2020-10-29 $12.72 USPSFirstClass 1 0.15 lbs $4.29 $3.50 $0.79
217074 2020-10-29 $11.65 USPSFirstClass 1 0.39 lbs $5.04 $4.33 $0.71
217081 2020-10-29 $42.30 Priority Mail 3-Day 10 2.50 lbs $13.40 $12.55 $0.85
217083 2020-10-29 $25.33 First-Class Mail Stamped Letter 2 0.04 lbs $3.35 $3.92 $-0.57
217087 2020-10-30 $63.99 Priority Mail 2-Day 2 1.60 lbs $10.01 $8.05 $1.96
217089 2020-10-30 $14.99 First-Class Package Service 3 0.39 lbs $4.82 $4.57 $0.25
217092 2020-10-30 $6.24 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $3.43 $-0.08
217095 2020-10-30 $11.67 First-Class Package Service 1 0.15 lbs $3.88 $3.92 $-0.04
217096 2020-10-30 $17.88 Priority Mail 3-Day Flat Rate Envelope 2 0.96 lbs $8.40 $8.05 $0.35
217097 2020-10-30 $12.93 USPSFirstClass 1 0.15 lbs $4.39 $3.64 $0.75
217098 2020-10-30 $28.38 Priority Mail 2-Day Flat Rate Envelope 2 1.26 lbs $8.40 $8.05 $0.35
217100 2020-10-30 $47.98 Priority Mail 3-Day Padded Flat Rate Envelope 2 1.70 lbs $9.00 $8.05 $0.95
217105 2020-10-30 $54.59 Priority Mail 2-Day Small Flat Rate Box 1 1.70 lbs $8.90 $8.05 $0.85
217114 2020-10-30 $18.83 First-Class Package Service 12 0.24 lbs $3.95 $3.03 $0.92
217124 2020-10-30 $7.53 First-Class Package Service 1 0.03 lbs $3.54 $3.09 $0.45
217127 2020-10-30 $10.29 First-Class Mail Stamped Letter 1 0.09 lbs $3.50 $3.09 $0.41
217128 2020-10-23 $11.39 First-Class Package Service 1 0.30 lbs $1.60 $3.64 $-2.04
217129 2020-10-30 $7.89 First-Class Mail Stamped Letter 1 0.10 lbs $3.50 $3.30 $0.20
217131 2020-10-30 $7.18 First-Class Mail Stamped Letter 2 0.02 lbs $3.20 $3.30 $-0.10
217132 2020-10-30 $21.97 USPSFirstClass 1 0.16 lbs $4.80 $3.64 $1.16
217133 2020-10-30 $43.27 Priority Mail 2-Day Flat Rate Envelope 2 1.80 lbs $8.40 $8.15 $0.25
217134 2020-10-30 $111.82 Priority Mail 3-Day Medium Flat Rate Box 3 3.08 lbs $14.85 $12.50 $2.35
217135 2020-10-30 $8.54 First-Class Mail Stamped Letter 1 0.07 lbs $3.35 $3.03 $0.32
217139 2020-10-30 $34.43 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.90 $8.05 $0.85
217142 2020-10-30 $5.94 First-Class Package Service 1 0.20 lbs $3.95 $3.50 $0.45
217143 2020-10-30 $34.56 First-Class Package International Service 8 0.32 lbs $24.64 $16.39 $8.25
217145 2020-10-31 $53.88 Priority Mail 2-Day Large Flat Rate Box 2 1.80 lbs $8.00 $8.00 $0.00
217148 2020-10-31 $9.62 First-Class Package Service 1 0.01 lbs $3.63 $3.18 $0.45
217149 2020-10-31 $28.82 Priority Mail 3-Day Flat Rate Envelope 2 1.05 lbs $8.40 $8.15 $0.25
217151 2020-10-31 $37.29 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $8.90 $8.05 $0.85
217152 2020-10-31 $11.34 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $3.18 $0.17
217154 2020-10-31 $62.04 Priority Mail 2-Day Padded Flat Rate Envelope 3 2.85 lbs $9.00 $8.05 $0.95
217157 2020-10-31 $11.48 First-Class Mail Stamped Letter 2 0.10 lbs $3.50 $3.43 $0.07
217158 2020-11-01 $22.94 USPSFirstClass 1 0.15 lbs $4.95 $3.77 $1.18
217160 2020-10-31 $11.28 First-Class Package Service 9 0.26 lbs $4.37 $3.43 $0.94
217161 2020-10-31 $11.29 First-Class Mail Stamped Letter 6 0.06 lbs $3.35 $3.03 $0.32
217163 2020-10-31 $24.25 First-Class Package Service 1 0.60 lbs $4.96 $4.71 $0.25
217164 2020-11-01 $19.94 USPSFirstClass 1 0.04 lbs $4.95 $3.43 $1.52
217166 2020-11-01 $39.32 USPSFirstClass 4 2.43 lbs $22.52 $9.94 $12.58
217169 2020-10-31 $8.47 First-Class Package Service 4 0.13 lbs $0.00 $3.03 $-3.03
217171 2020-11-01 $10.52 USPSFirstClass 1 0.10 lbs $4.46 $3.43 $1.03
217174 2020-11-01 $21.52 First-Class Mail Stamped Letter 2 0.12 lbs $3.50 $3.43 $0.07
217175 2020-11-01 $176.31 Priority Mail 2-Day Medium Flat Rate Box 4 5.65 lbs $14.85 $11.42 $3.43
217176 2020-11-01 $19.69 USPSFirstClass 1 0.02 lbs $4.70 $3.09 $1.61
217177 2020-11-01 $46.23 Priority Mail 3-Day 1 1.70 lbs $11.24 $10.38 $0.86
217180 2020-11-01 $38.69 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $8.90 $8.05 $0.85
217182 2020-11-01 $6.46 USPSFirstClass 1 0.20 lbs $4.14 $3.77 $0.37
217186 2020-11-01 $11.11 USPSFirstClass 1 0.10 lbs $4.31 $3.18 $1.13
217187 2020-11-01 $27.11 First-Class Package Service 1 0.15 lbs $4.17 $3.43 $0.74
217189 2020-11-01 $191.72 Direct Link International 21 6.90 lbs $58.43 $45.31 $13.12
217191 2020-11-01 $93.20 Priority Mail 2-Day Medium Flat Rate Box 65 4.82 lbs $14.85 $12.64 $2.21
217193 2020-11-01 $4.61 First-Class Package Service 2 0.02 lbs $3.63 $3.18 $0.45
217195 2020-11-01 $7.47 First-Class Package Service 1 0.06 lbs $3.48 $3.03 $0.45
217196 2020-11-01 $12.59 First-Class Package Service 3 0.54 lbs $5.62 $5.37 $0.25
Total 21025 order(s) 59971 29292.14 lbs $193562.51 $270247.54 $-76685.03