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
222134 2021-02-14 $34.69 Priority Mail 2-Day 1 1.05 lbs $9.70 $8.85 $0.85
222136 2021-02-14 $8.39 First-Class Mail Stamped Letter 1 0.10 lbs $3.40 $3.12 $0.28
222137 2021-02-14 $6.57 First-Class Package Service 1 0.20 lbs $4.08 $3.58 $0.50
222139 2021-02-15 $9.75 USPSFirstClass 1 0.06 lbs $4.42 $3.06 $1.36
222140 2021-02-15 $7.03 USPSFirstClass 1 0.10 lbs $4.14 $3.01 $1.13
222141 2021-02-15 $13.58 First-Class Mail Stamped Letter 2 0.15 lbs $3.40 $3.06 $0.34
222143 2021-02-15 $13.15 Priority Mail 3-Day Flat Rate Envelope 10 0.10 lbs $8.25 $7.90 $0.35
222144 2021-02-15 $4.99 First-Class Mail Stamped Letter 1 0.01 lbs $3.00 $3.03 $-0.03
222146 2021-02-15 $41.22 Priority Mail 2-Day Flat Rate Envelope 3 1.05 lbs $8.25 $8.00 $0.25
222147 2021-02-15 $12.99 First-Class Package Service 2 0.20 lbs $4.01 $3.06 $0.95
222149 2021-02-15 $8.39 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.35 $-0.15
222150 2021-02-15 $18.51 USPSFirstClass 1 0.25 lbs $5.12 $3.49 $1.63
222151 2021-02-15 $69.94 USPSPriority 1 1.19 lbs $16.57 $7.90 $8.67
222152 2021-02-15 $7.18 USPSFirstClass 1 0.06 lbs $4.39 $3.22 $1.17
222156 2021-02-15 $34.98 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $8.75 $7.90 $0.85
222158 2021-02-15 $20.44 First-Class Package Service 1 0.50 lbs $4.70 $4.20 $0.50
222162 2021-02-15 $20.59 First-Class Package Service 5 0.63 lbs $5.44 $5.19 $0.25
222163 2021-02-15 $12.39 First-Class Mail Stamped Letter 1 0.11 lbs $3.40 $3.22 $0.18
222165 2021-02-15 $30.89 First-Class Package Service 4 0.44 lbs $4.93 $4.68 $0.25
222166 2021-02-15 $89.19 Ground 4 3.62 lbs $27.23 $23.99 $3.24
222168 2021-02-15 $8.93 USPSFirstClass 1 0.40 lbs $5.14 $3.12 $2.02
222169 2021-02-15 $11.31 USPSFirstClass 1 0.05 lbs $4.54 $3.57 $0.97
222170 2021-02-15 $43.86 First-Class Package Service 6 0.71 lbs $5.92 $5.42 $0.50
222171 2021-02-15 $76.99 Priority Mail 2-Day Medium Flat Rate Box 1 4.39 lbs $15.00 $7.90 $7.10
222173 2021-02-15 $30.61 First-Class Package Service 1 0.40 lbs $4.62 $3.51 $1.11
222174 2021-02-15 $10.99 First-Class Mail Stamped Letter 1 0.04 lbs $3.20 $3.35 $-0.15
222175 2021-02-15 $23.04 First-Class Package Service 1 0.32 lbs $4.07 $3.57 $0.50
222179 2021-02-15 $88.18 Priority Mail 2-Day 3 2.85 lbs $19.81 $45.84 $-26.03
222184 2021-02-15 $46.71 First-Class Package Service 7 0.51 lbs $4.93 $5.98 $-1.05
222185 2021-02-16 $27.66 USPSFirstClass 1 0.40 lbs $6.27 $3.85 $2.42
222186 2021-02-16 $15.18 USPSFirstClass 2 0.12 lbs $4.52 $3.22 $1.30
222187 2021-02-16 $46.50 USPSFirstClass 6 0.78 lbs $12.96 $4.12 $8.84
222188 2021-02-16 $38.43 USPSFirstClass 1 0.10 lbs $6.07 $3.49 $2.58
222189 2021-02-16 $135.89 USPSPriority 1 3.00 lbs $25.90 $20.43 $5.47
222191 2021-02-16 $6.54 USPSFirstClass 1 0.08 lbs $4.55 $3.49 $1.06
222192 2021-02-16 $126.59 USPSPriority 1 3.00 lbs $16.60 $8.34 $8.26
222193 2021-02-16 $34.89 USPSPriority 1 1.70 lbs $14.90 $11.42 $3.48
222194 2021-02-16 $32.72 USPSFirstClass 6 1.50 lbs $15.38 $8.80 $6.58
222195 2021-02-16 $11.60 USPSFirstClass 2 0.05 lbs $4.62 $3.49 $1.13
222196 2021-02-16 $7.81 USPSFirstClass 1 0.07 lbs $4.42 $3.22 $1.20
222198 2021-02-16 $27.69 Priority Mail 2-Day Small Flat Rate Box 6 0.25 lbs $8.75 $7.90 $0.85
222199 2021-02-16 $29.97 First-Class Package Service 2 0.10 lbs $3.99 $3.49 $0.50
222200 2021-02-16 $11.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.06 $0.14
222201 2021-02-16 $100.97 USPSFirstClass 2 0.60 lbs $13.62 $5.66 $7.96
222202 2021-02-16 $14.17 USPSFirstClass 2 0.09 lbs $4.39 $3.06 $1.33
222204 2021-02-16 $11.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.06 $0.14
222205 2021-02-16 $124.47 Priority Mail 2-Day Medium Flat Rate Box 33 3.70 lbs $15.00 $13.75 $1.25
222206 2021-02-16 $19.11 First-Class Package Service - Retail 4 0.19 lbs $5.95 $3.69 $2.26
222207 2021-02-16 $19.07 First-Class Package Service 1 0.30 lbs $4.08 $3.58 $0.50
222211 2021-02-16 $35.33 Priority Mail 3-Day 1 0.95 lbs $12.54 $11.69 $0.85
222212 2021-02-16 $8.05 First-Class Package Service 1 0.20 lbs $3.82 $3.12 $0.70
222214 2021-02-16 $31.09 USPSPriority 1 1.70 lbs $11.10 $8.72 $2.38
222215 2021-02-16 $13.43 USPSFirstClass 1 0.04 lbs $4.64 $3.12 $1.52
222216 2021-02-16 $33.85 USPSPriority 1 4.54 lbs $15.56 $12.42 $3.14
222219 2021-02-16 $6.79 First-Class Package Service 6 0.06 lbs $3.85 $3.35 $0.50
222220 2021-02-16 $34.16 First-Class Package Service 4 0.46 lbs $4.37 $4.12 $0.25
222221 2021-02-16 $146.62 Priority Mail 3-Day 2 4.01 lbs $9.48 $8.63 $0.85
222222 2021-02-16 $531.70 Priority Mail 2-Day 15 39.88 lbs $106.89 $92.48 $14.41
222224 2021-02-16 $10.35 First-Class Package Service 1 0.03 lbs $3.56 $3.06 $0.50
222225 2021-02-16 $8.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.22 $-0.02
222229 2021-02-17 $32.94 USPSPriority 1 1.70 lbs $12.95 $10.82 $2.13
222230 2021-02-17 $11.18 USPSFirstClass 1 0.39 lbs $5.39 $4.53 $0.86
222231 2021-02-17 $11.41 USPSFirstClass 1 0.05 lbs $4.64 $3.69 $0.95
222232 2021-02-17 $10.70 USPSFirstClass 1 0.06 lbs $4.60 $3.35 $1.25
222233 2021-02-17 $204.07 FedExHomeDelivery 1 9.20 lbs $24.08 $12.65 $11.43
222235 2021-02-17 $14.44 USPSFirstClass 1 0.31 lbs $5.45 $3.58 $1.87
222236 2021-02-17 $203.14 USPSPriority 1 9.20 lbs $23.15 $19.30 $3.85
222237 2021-02-17 $19.21 USPSFirstClass 3 0.14 lbs $4.54 $3.35 $1.19
222238 2021-02-17 $34.31 First-Class Package Service 4 0.65 lbs $5.77 $5.27 $0.50
222239 2021-02-17 $10.18 First-Class Mail Stamped Letter 2 0.10 lbs $3.20 $3.22 $-0.02
222240 2021-02-17 $10.15 First-Class Package Service 4 0.20 lbs $4.19 $6.70 $-2.51
222241 2021-02-17 $38.76 Priority Mail 2-Day Medium Flat Rate Box 4 3.15 lbs $15.00 $13.75 $1.25
222243 2021-02-17 $46.66 First-Class Package Service 2 0.60 lbs $5.18 $4.68 $0.50
222245 2021-02-17 $16.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.49 $-0.29
222246 2021-02-17 $9.99 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $3.06 $0.14
222248 2021-02-17 $29.00 First-Class Package Service 2 0.40 lbs $4.62 $3.51 $1.11
222253 2021-02-17 $16.14 First-Class Package Service 1 0.30 lbs $4.35 $3.85 $0.50
222254 2021-02-17 $9.99 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $3.22 $-0.02
222255 2021-02-17 $30.12 Ground 1 2.00 lbs $14.13 $11.99 $2.14
222256 2021-02-17 $30.97 Priority Mail 2-Day 2 0.85 lbs $9.70 $8.85 $0.85
222257 2021-02-17 $6.76 USPSFirstClass 1 0.01 lbs $4.27 $3.06 $1.21
222258 2021-02-17 $11.30 USPSFirstClass 2 0.06 lbs $4.32 $3.06 $1.26
222259 2021-02-17 $15.23 USPSFirstClass 2 0.12 lbs $4.57 $3.35 $1.22
222260 2021-02-17 $9.18 First-Class Mail Stamped Letter 2 0.10 lbs $3.40 $3.06 $0.34
222261 2021-02-17 $20.88 First-Class Package Service 3 0.54 lbs $4.29 $4.04 $0.25
222262 2021-02-17 $10.64 First-Class Package Service 1 0.03 lbs $3.85 $3.35 $0.50
222263 2021-02-17 $35.33 Priority Mail 2-Day 1 0.95 lbs $12.54 $11.69 $0.85
222265 2021-02-17 $9.99 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $3.12 $0.08
222266 2021-02-17 $34.65 Priority Mail 3-Day 1 0.95 lbs $11.86 $11.01 $0.85
222268 2021-02-17 $38.09 First-Class Package Service 12 0.55 lbs $4.70 $4.20 $0.50
222269 2021-02-17 $15.67 Priority Mail 2-Day Medium Flat Rate Box 7 3.94 lbs $14.60 $10.89 $3.71
222270 2021-02-17 $16.20 Priority Mail 2-Day Small Flat Rate Box 5 0.24 lbs $8.75 $7.90 $0.85
222271 2021-02-17 $38.54 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.75 $8.25 $0.50
222276 2021-02-17 $7.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.06 $0.14
222279 2021-02-17 $35.27 Priority Mail 2-Day 2 1.02 lbs $9.09 $8.34 $0.75
222280 2021-02-17 $66.57 Ground 3 2.15 lbs $26.35 $23.39 $2.96
222281 2021-02-18 $6.39 USPSFirstClass 1 0.08 lbs $4.40 $3.35 $1.05
222282 2021-02-18 $33.57 USPSPriority 2 2.20 lbs $13.99 $10.82 $3.17
222284 2021-02-18 $8.51 First-Class Package Service 1 0.05 lbs $3.72 $3.22 $0.50
222287 2021-02-18 $27.24 First-Class Package Service 7 0.73 lbs $6.31 $4.53 $1.78
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56