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
209158 2020-01-05 $18.88 First-Class Package Service 1 0.19 lbs $3.89 $3.36 $0.53
209159 2020-01-05 $24.28 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $7.80 $7.55 $0.25
209166 2020-01-05 $30.06 First-Class Package Service 1 0.41 lbs $6.07 $3.88 $2.19
209167 2020-01-06 $31.93 Priority Mail 3-Day 2 1.90 lbs $13.95 $13.10 $0.85
209168 2020-01-06 $50.76 Priority Mail 3-Day Padded Flat Rate Envelope 4 1.48 lbs $8.40 $7.55 $0.85
209169 2020-01-06 $247.20 Priority Mail 3-Day 5 13.40 lbs $52.67 $51.82 $0.85
209172 2020-01-06 $4.48 First-Class Package Service 2 0.07 lbs $0.00 $2.84 $-2.84
209173 2020-01-06 $4.99 First-Class Package Service 1 0.31 lbs $0.00 $4.18 $-4.18
209174 2020-01-06 $8.39 First-Class Package Service 2 0.08 lbs $4.01 $2.96 $1.05
209175 2020-01-06 $7.00 First-Class Package Service 1 0.01 lbs $4.01 $2.96 $1.05
209176 2020-01-06 $7.97 First-Class Package Service 4 0.04 lbs $4.01 $2.96 $1.05
209177 2020-01-06 $35.05 First-Class Package Service 3 0.95 lbs $6.07 $7.50 $-1.43
209178 2020-01-06 $36.64 Priority Mail 2-Day 4 2.56 lbs $10.88 $10.03 $0.85
209179 2020-01-06 $17.12 First-Class Package Service 1 0.25 lbs $4.33 $3.28 $1.05
209181 2020-01-06 $11.00 First-Class Package Service 1 0.70 lbs $5.01 $5.12 $-0.11
209182 2020-01-06 $23.36 First-Class Package Service 5 0.20 lbs $4.01 $3.49 $0.52
209184 2020-01-06 $16.22 First-Class Package Service 1 1.00 lbs $6.43 $6.95 $-0.52
209185 2020-01-06 $66.44 Priority Mail 3-Day 1 2.40 lbs $12.65 $11.80 $0.85
209186 2020-01-06 $39.07 Priority Mail 2-Day 1 1.05 lbs $11.08 $10.23 $0.85
209189 2020-01-06 $30.42 First-Class Package Service 1 0.41 lbs $6.43 $4.19 $2.24
209191 2020-01-07 $7.75 First-Class Package Service 1 0.05 lbs $4.14 $3.09 $1.05
209194 2020-01-07 $18.63 Priority Mail 3-Day Small Flat Rate Box 2 0.20 lbs $8.35 $7.50 $0.85
209195 2020-01-07 $47.79 Priority Mail 2-Day Flat Rate Envelope 1 2.35 lbs $7.80 $7.50 $0.30
209196 2020-01-07 $28.10 First-Class Package Service 7 0.46 lbs $5.87 $3.88 $1.99
209197 2020-01-07 $101.26 Priority Mail 3-Day 1 1.90 lbs $9.19 $8.12 $1.07
209198 2020-01-07 $12.36 First-Class Package Service 3 0.15 lbs $3.89 $2.84 $1.05
209203 2020-01-07 $29.43 Priority Mail 2-Day Large Flat Rate Box 2 0.72 lbs $18.45 $7.88 $10.57
209204 2020-01-07 $32.40 Priority Mail 2-Day 5 2.25 lbs $13.95 $13.10 $0.85
209205 2020-01-07 $55.97 Priority Mail 3-Day Flat Rate Envelope 3 1.30 lbs $7.80 $7.50 $0.30
209207 2020-01-07 $12.48 First-Class Package Service 3 0.13 lbs $4.01 $3.49 $0.52
209208 2020-01-07 $8.65 First-Class Package Service 2 0.15 lbs $4.27 $3.22 $1.05
209209 2020-01-08 $29.53 Priority Mail 2-Day 6 2.40 lbs $9.19 $8.34 $0.85
209215 2020-01-08 $101.30 Priority Mail 3-Day 2 11.71 lbs $50.34 $49.49 $0.85
209216 2020-01-08 $162.14 Priority Mail 2-Day 2 4.40 lbs $34.36 $18.46 $15.90
209217 2020-01-08 $66.57 Priority Mail 3-Day Flat Rate Envelope 3 1.92 lbs $7.80 $7.75 $0.05
209218 2020-01-08 $76.18 Priority Mail 1-Day 3 2.75 lbs $8.56 $7.68 $0.88
209222 2020-01-08 $11.39 First-Class Package Service 2 0.10 lbs $3.81 $2.76 $1.05
209227 2020-01-08 $14.72 First-Class Package Service 1 0.25 lbs $4.41 $3.36 $1.05
209230 2020-01-08 $7.88 First-Class Package Service 1 0.08 lbs $3.89 $2.84 $1.05
209231 2020-01-08 $8.94 First-Class Package Service 1 0.05 lbs $3.75 $2.70 $1.05
209237 2020-01-09 $22.13 First-Class Package Service 4 0.76 lbs $6.17 $5.12 $1.05
209238 2020-01-09 $150.47 Priority Mail 3-Day 39 15.55 lbs $18.96 $21.12 $-2.16
209242 2020-01-09 $112.02 First-Class Package International Service 12 1.67 lbs $24.64 $16.39 $8.25
209243 2020-01-09 $22.03 First-Class Package Service 1 0.35 lbs $4.54 $3.49 $1.05
209245 2020-01-09 $6.69 First-Class Package Service 6 0.06 lbs $3.75 $2.70 $1.05
209246 2020-01-09 $20.81 Priority Mail 2-Day 3 0.07 lbs $8.84 $7.50 $1.34
209251 2020-01-09 $101.90 Priority Mail 2-Day Medium Flat Rate Box 5 3.60 lbs $14.05 $11.20 $2.85
209254 2020-01-10 $37.28 Priority Mail 2-Day Flat Rate Envelope 2 1.00 lbs $7.80 $7.55 $0.25
209255 2020-01-10 $7.50 First-Class Package Service 1 0.03 lbs $4.01 $2.96 $1.05
209263 2020-01-10 $8.40 First-Class Package Service 1 0.04 lbs $4.01 $2.96 $1.05
209264 2020-01-10 $211.29 Priority Mail 2-Day Medium Flat Rate Box 6 15.23 lbs $14.05 $13.20 $0.85
209265 2020-01-10 $42.09 First-Class Package Service 2 0.60 lbs $5.11 $5.24 $-0.13
209270 2020-01-10 $38.09 Priority Mail 3-Day 10 2.56 lbs $9.19 $8.34 $0.85
209271 2020-01-10 $46.08 Priority Mail 2-Day Flat Rate Envelope 2 1.43 lbs $7.80 $7.50 $0.30
209272 2020-01-10 $17.70 First-Class Package Service 3 0.23 lbs $4.33 $3.28 $1.05
209273 2020-01-10 $40.66 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $8.35 $7.50 $0.85
209275 2020-01-10 $30.31 Priority Mail 2-Day 8 2.00 lbs $9.19 $8.34 $0.85
209278 2020-01-10 $16.30 First-Class Package Service 3 0.19 lbs $4.33 $3.28 $1.05
209285 2020-01-11 $24.53 First-Class Package Service 1 0.40 lbs $4.54 $4.19 $0.35
209286 2020-01-11 $57.35 Priority Mail 2-Day Flat Rate Envelope 5 1.79 lbs $7.80 $7.65 $0.15
209287 2020-01-11 $24.28 Priority Mail 2-Day Flat Rate Envelope 2 1.12 lbs $7.80 $7.55 $0.25
209288 2020-01-11 $24.20 First-Class Package International Service 3 0.03 lbs $18.23 $9.98 $8.25
209291 2020-01-11 $54.50 Priority Mail 2-Day 3 1.46 lbs $8.73 $7.50 $1.23
209292 2020-01-11 $34.54 Priority Mail 3-Day Small Flat Rate Box 11 0.43 lbs $8.35 $7.50 $0.85
209293 2020-01-11 $6.78 First-Class Package Service 1 0.03 lbs $3.89 $2.84 $1.05
209297 2020-01-11 $40.25 Priority Mail 2-Day 10 0.82 lbs $9.35 $7.65 $1.70
209298 2020-01-11 $45.76 Priority Mail 2-Day Flat Rate Envelope 14 2.10 lbs $7.80 $7.50 $0.30
209299 2020-01-11 $42.13 Priority Mail 3-Day 2 1.29 lbs $9.35 $7.50 $1.85
209300 2020-01-11 $18.07 First-Class Package Service 1 0.16 lbs $4.68 $3.63 $1.05
209307 2020-01-12 $16.03 First-Class Package Service 1 0.35 lbs $4.54 $4.19 $0.35
209308 2020-01-12 $11.39 First-Class Package Service 2 0.10 lbs $3.81 $2.84 $0.97
209310 2020-01-12 $11.90 First-Class Package Service 1 0.20 lbs $4.01 $3.49 $0.52
209311 2020-01-12 $5.94 First-Class Package Service 1 0.05 lbs $3.75 $2.70 $1.05
209313 2020-01-12 $30.10 First-Class Package Service 1 0.65 lbs $5.11 $5.40 $-0.29
209315 2020-01-12 $48.74 Priority Mail 3-Day Small Flat Rate Box 1 1.75 lbs $8.35 $7.50 $0.85
209316 2020-01-12 $9.80 First-Class Package Service 1 0.35 lbs $5.01 $3.96 $1.05
209318 2020-01-12 $28.43 Priority Mail 2-Day Large Flat Rate Box 2 0.17 lbs $18.45 $7.49 $10.96
209320 2020-01-12 $81.46 First-Class Package International Service 3 1.92 lbs $33.19 $24.94 $8.25
209322 2020-01-12 $202.48 Priority Mail 3-Day 6 7.09 lbs $17.69 $12.80 $4.89
209331 2020-01-13 $47.35 Priority Mail 2-Day 2 1.50 lbs $8.27 $7.42 $0.85
209333 2020-01-13 $8.60 First-Class Package Service 1 0.10 lbs $3.81 $2.76 $1.05
209334 2020-01-13 $51.34 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.35 $7.50 $0.85
209335 2020-01-13 $22.29 First-Class Package Service 4 0.38 lbs $4.33 $3.31 $1.02
209336 2020-01-13 $27.07 First-Class Package Service 3 0.30 lbs $4.48 $4.33 $0.15
209337 2020-01-13 $59.81 Priority Mail 2-Day 4 1.85 lbs $13.95 $13.49 $0.46
209338 2020-01-13 $53.34 Priority Mail 2-Day Small Flat Rate Box 1 0.88 lbs $8.35 $7.50 $0.85
209339 2020-01-13 $51.34 Priority Mail 2-Day Small Flat Rate Box 1 1.50 lbs $8.35 $7.50 $0.85
209342 2020-01-13 $65.27 Priority Mail 3-Day 2 1.85 lbs $9.19 $8.34 $0.85
209343 2020-01-13 $29.92 First-Class Package Service 15 0.42 lbs $4.27 $3.88 $0.39
209350 2020-01-14 $50.76 Priority Mail 2-Day Padded Flat Rate Envelope 4 1.48 lbs $8.40 $7.55 $0.85
209351 2020-01-14 $9.49 First-Class Package Service - Retail 10 0.10 lbs $4.59 $2.70 $1.89
209352 2020-01-14 $41.71 Priority Mail 2-Day 2 1.25 lbs $8.73 $7.88 $0.85
209355 2020-01-14 $29.52 First-Class Package Service 2 0.40 lbs $4.54 $4.19 $0.35
209356 2020-01-14 $47.34 Priority Mail 2-Day 1 1.85 lbs $12.65 $10.00 $2.65
209358 2020-01-14 $5.74 First-Class Package Service 1 0.07 lbs $3.75 $2.70 $1.05
209359 2020-01-14 $49.30 Direct Link International 8 0.92 lbs $21.88 $17.61 $4.27
209362 2020-01-14 $51.94 Priority Mail 2-Day Flat Rate Envelope 5 0.91 lbs $7.80 $7.65 $0.15
209368 2020-01-14 $26.19 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $7.80 $7.55 $0.25
209369 2020-01-14 $26.36 Priority Mail 3-Day 2 1.51 lbs $11.08 $10.55 $0.53
209370 2020-01-14 $14.14 First-Class Package Service 2 0.25 lbs $4.23 $3.18 $1.05
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56