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
227087 2021-09-08 $12.69 USPSFirstClass 1 0.06 lbs $4.70 $3.35 $1.35
227088 2021-09-08 $38.28 Priority Mail 3-Day 1 0.70 lbs $12.79 $8.00 $4.79
227092 2021-09-09 $205.57 Priority Mail 3-Day 6 6.20 lbs $17.63 $12.63 $5.00
227094 2021-09-09 $26.71 First-Class Package Service 1 0.65 lbs $6.22 $4.12 $2.10
227095 2021-09-09 $28.82 USPSFirstClass 3 0.19 lbs $4.85 $4.68 $0.17
227097 2021-09-09 $45.74 United States 1 1.10 lbs $8.75 $7.90 $0.85
227098 2021-09-09 $19.64 USPSFirstClass 1 0.28 lbs $5.65 $3.57 $2.08
227102 2021-09-09 $9.91 First-Class Mail Stamped Letter 2 0.03 lbs $3.93 $3.22 $0.71
227103 2021-09-09 $38.34 Priority Mail 2-Day 2 1.72 lbs $12.79 $12.13 $0.66
227104 2021-09-09 $18.09 First-Class Mail Stamped Letter 4 0.17 lbs $4.13 $3.35 $0.78
227105 2021-09-09 $16.76 First-Class Package Service 1 0.30 lbs $4.77 $3.57 $1.20
227106 2021-09-10 $57.08 Priority Mail 2-Day Padded Flat Rate Envelope 1 2.50 lbs $9.10 $8.00 $1.10
227109 2021-09-10 $67.39 Priority Mail 2-Day Medium Flat Rate Box 1 25.00 lbs $15.40 $13.75 $1.65
227110 2021-09-10 $8.64 USPSFirstClass 1 0.05 lbs $4.65 $3.49 $1.16
227111 2021-09-10 $10.74 First-Class Package Service 4 0.20 lbs $4.78 $3.22 $1.56
227114 2021-09-11 $53.89 USPSFirstClass 1 0.58 lbs $7.90 $5.27 $2.63
227115 2021-09-11 $52.84 USPSPriority 1 2.30 lbs $13.05 $8.72 $4.33
227116 2021-09-11 $8.49 USPSFirstClass 1 0.03 lbs $4.50 $3.35 $1.15
227117 2021-09-11 $20.32 USPSFirstClass 2 0.06 lbs $4.54 $3.06 $1.48
227118 2021-09-11 $97.87 Priority Mail 3-Day Medium Flat Rate Box 3 6.30 lbs $15.40 $10.82 $4.58
227119 2021-09-11 $14.44 USPSFirstClass 1 0.34 lbs $5.45 $3.58 $1.87
227123 2021-09-12 $10.03 First-Class Package Service - Retail 2 0.06 lbs $7.05 $3.85 $3.20
227124 2021-09-12 $12.59 USPSFirstClass 1 0.06 lbs $4.60 $3.12 $1.48
227125 2021-09-12 $32.49 USPSFirstClass 1 0.40 lbs $6.50 $4.68 $1.82
227126 2021-09-12 $24.38 USPSFirstClass 2 0.68 lbs $6.40 $5.98 $0.42
227127 2021-09-12 $128.08 Priority Mail 2-Day Padded Flat Rate Envelope 2 4.25 lbs $9.10 $8.00 $1.10
227128 2021-09-12 $35.08 Priority Mail 2-Day 1 1.12 lbs $12.79 $11.69 $1.10
227129 2021-09-12 $14.68 First-Class Package Service 1 0.05 lbs $4.69 $3.49 $1.20
227131 2021-09-13 $295.38 Priority Mail 2-Day Medium Flat Rate Box 2 35.72 lbs $15.40 $13.75 $1.65
227132 2021-09-13 $295.38 Priority Mail 2-Day Medium Flat Rate Box 2 35.72 lbs $15.40 $13.75 $1.65
227135 2021-09-13 $21.49 Selected States in United States 1 0.95 lbs $8.50 $8.80 $-0.30
227142 2021-09-13 $14.93 First-Class Package Service 1 0.40 lbs $5.40 $3.57 $1.83
227143 2021-09-13 $295.38 Priority Mail 2-Day Medium Flat Rate Box 2 35.72 lbs $15.40 $13.75 $1.65
227144 2021-09-13 $11.11 First-Class Mail Stamped Letter 2 0.05 lbs $3.93 $3.35 $0.58
227146 2021-09-13 $13.76 First-Class Package Service 6 0.20 lbs $4.52 $3.57 $0.95
227149 2021-09-14 $63.87 Priority Mail 2-Day 4 1.36 lbs $12.11 $11.01 $1.10
227151 2021-09-14 $11.74 USPSFirstClass 1 0.25 lbs $4.65 $4.53 $0.12
227154 2021-09-14 $144.37 Priority Mail 2-Day 1 12.90 lbs $21.12 $11.76 $9.36
227156 2021-09-14 $19.66 USPSFirstClass 1 0.30 lbs $5.67 $3.69 $1.98
227157 2021-09-14 $12.58 USPSFirstClass 1 0.06 lbs $4.69 $3.35 $1.34
227158 2021-09-14 $31.31 First-Class Mail Stamped Letter 3 0.30 lbs $8.84 $3.51 $5.33
227159 2021-09-14 $26.53 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $8.50 $8.00 $0.50
227162 2021-09-14 $9.23 United States 2 0.07 lbs $3.95 $3.85 $0.10
227163 2021-09-15 $54.33 Priority Mail 2-Day 1 1.10 lbs $9.34 $8.24 $1.10
227164 2021-09-15 $150.37 Ground 5 16.00 lbs $26.64 $18.49 $8.15
227168 2021-09-15 $22.99 United States 1 0.45 lbs $5.00 $4.53 $0.47
227169 2021-09-16 $12.73 USPSFirstClass 1 0.04 lbs $4.84 $3.49 $1.35
227170 2021-09-16 $12.63 USPSFirstClass 1 0.05 lbs $4.84 $3.49 $1.35
227171 2021-09-16 $12.53 USPSFirstClass 1 0.06 lbs $4.64 $3.22 $1.42
227172 2021-09-16 $15.65 First-Class Package Service 8 0.46 lbs $5.73 $3.69 $2.04
227173 2021-09-16 $54.06 Priority Mail 2-Day 1 0.15 lbs $8.77 $7.90 $0.87
227174 2021-09-16 $14.64 USPSFirstClass 1 0.06 lbs $4.65 $3.06 $1.59
227180 2021-09-16 $41.93 First-Class Package Service 5 0.79 lbs $7.18 $5.98 $1.20
227182 2021-09-16 $140.40 Priority Mail 3-Day 4 4.70 lbs $26.85 $25.75 $1.10
227183 2021-09-16 $53.33 USPSFirstClass 1 0.13 lbs $6.54 $3.12 $3.42
227184 2021-09-16 $20.62 USPSFirstClass 2 0.12 lbs $4.84 $3.49 $1.35
227185 2021-09-16 $51.31 Priority Mail 3-Day 2 1.50 lbs $12.79 $11.69 $1.10
227195 2021-09-17 $24.04 First-Class Package Service 1 0.30 lbs $5.05 $3.85 $1.20
227196 2021-09-17 $8.91 First-Class Mail Stamped Letter 2 0.06 lbs $3.93 $3.35 $0.58
227197 2021-09-17 $9.92 First-Class Mail Stamped Letter 1 0.05 lbs $3.93 $3.49 $0.44
227198 2021-09-17 $229.38 Ground 4 4.60 lbs $29.42 $19.80 $9.62
227200 2021-09-17 $9.99 Selected States in United States 1 0.50 lbs $5.00 $5.42 $-0.42
227201 2021-09-17 $101.55 First-Class Package International Service 6 1.74 lbs $36.31 $45.60 $-9.29
227202 2021-09-18 $51.89 Priority Mail 2-Day 1 1.10 lbs $12.11 $11.01 $1.10
227203 2021-09-18 $20.74 USPSFirstClass 1 0.40 lbs $5.75 $3.58 $2.17
227204 2021-09-18 $10.75 USPSFirstClass 1 0.07 lbs $4.46 $3.06 $1.40
227205 2021-09-18 $19.69 USPSFirstClass 1 0.30 lbs $5.70 $3.58 $2.12
227206 2021-09-18 $14.79 USPSFirstClass 3 0.12 lbs $4.32 $3.51 $0.81
227207 2021-09-18 $49.12 Priority Mail 3-Day 1 1.10 lbs $9.34 $8.24 $1.10
227209 2021-09-19 $16.57 Selected States in United States 3 0.48 lbs $5.00 $3.85 $1.15
227210 2021-09-19 $10.22 Priority Mail 2-Day Medium Flat Rate Box 1 0.05 lbs $3.93 $3.22 $0.71
227211 2021-09-19 $62.98 Priority Mail 2-Day Flat Rate Envelope 2 1.60 lbs $8.50 $8.25 $0.25
227216 2021-09-19 $30.79 Priority Mail 2-Day Small Flat Rate Box 1 0.40 lbs $9.00 $7.90 $1.10
227218 2021-09-20 $75.09 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.80 lbs $9.10 $8.00 $1.10
227220 2021-09-20 $56.99 Priority Mail 2-Day Small Flat Rate Box 1 1.50 lbs $9.00 $8.25 $0.75
227221 2021-09-20 $76.48 Priority Mail 2-Day 2 1.95 lbs $15.20 $12.32 $2.88
227222 2021-09-20 $81.74 Priority Mail 3-Day 8 1.63 lbs $9.82 $8.24 $1.58
227223 2021-09-20 $51.49 United States 1 0.69 lbs $5.50 $5.66 $-0.16
227225 2021-09-20 $56.99 Priority Mail 2-Day Small Flat Rate Box 1 1.50 lbs $9.00 $8.25 $0.75
227227 2021-09-20 $14.12 Utah 9 0.17 lbs $4.66 $3.46 $1.20
227228 2021-09-21 $6.20 First-Class Mail Stamped Letter 3 0.03 lbs $3.73 $3.49 $0.24
227229 2021-09-21 $14.64 First-Class Package Service 1 0.34 lbs $5.65 $3.85 $1.80
227230 2021-09-21 $14.52 Ground 1 0.02 lbs $11.53 $7.87 $3.66
227231 2021-09-21 $19.59 First-Class Package Service 1 0.28 lbs $5.60 $3.51 $2.09
227233 2021-09-21 $24.93 First-Class Package Service 1 0.19 lbs $5.14 $3.51 $1.63
227234 2021-09-21 $9.87 First-Class Package Service 2 0.20 lbs $4.89 $3.35 $1.54
227235 2021-09-21 $37.14 Priority Mail 2-Day 1 0.70 lbs $7.15 $17.70 $-10.55
227236 2021-09-21 $17.49 First-Class Package Service 1 0.30 lbs $5.50 $3.51 $1.99
227237 2021-09-21 $12.48 First-Class Package Service 2 0.10 lbs $4.50 $3.69 $0.81
227238 2021-09-21 $11.74 First-Class Mail Stamped Letter 1 0.05 lbs $3.93 $3.12 $0.81
227240 2021-09-22 $36.83 Priority Mail 3-Day Small Flat Rate Box 1 1.00 lbs $9.00 $7.90 $1.10
227242 2021-09-22 $85.99 Ground 2 0.66 lbs $16.01 $11.51 $4.50
227245 2021-09-23 $8.49 USPS First Class 1 0.05 lbs $4.50 $3.35 $1.15
227246 2021-09-23 $9.39 USPS First Class 1 0.03 lbs $4.40 $3.06 $1.34
227253 2021-09-23 $98.95 United States 2 3.00 lbs $9.95 $8.45 $1.50
227256 2021-09-24 $27.49 USPS First Class 11 0.69 lbs $5.60 $4.04 $1.56
227258 2021-09-24 $13.04 USPS First Class 1 0.10 lbs $4.55 $3.22 $1.33
227259 2021-09-24 $14.16 USPS First Class 1 0.10 lbs $4.67 $3.12 $1.55
227260 2021-09-24 $12.73 USPS First Class 1 0.06 lbs $4.84 $4.84 $0.00
227261 2021-09-24 $12.53 USPS First Class 1 0.06 lbs $4.64 $3.22 $1.42
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56