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
205170 2019-01-08 $17.97 First-Class Package Service 4 0.67 lbs $5.51 $4.94 $0.57
205171 2019-01-08 $37.39 Priority Mail 2-Day Small Flat Rate Box 1 1.15 lbs $7.90 $6.85 $1.05
205181 2019-01-08 $95.81 Direct Link International 4 2.65 lbs $32.15 $27.22 $4.93
205182 2019-01-08 $95.81 Direct Link International 4 2.65 lbs $32.15 $25.90 $6.25
205183 2019-01-08 $30.90 First-Class Package Service 5 0.48 lbs $4.55 $3.18 $1.37
205184 2019-01-08 $95.81 Direct Link International 4 2.65 lbs $32.15 $28.45 $3.70
205187 2019-01-08 $14.80 First-Class Package Service 4 0.23 lbs $3.84 $2.92 $0.92
205192 2019-01-08 $20.36 First-Class Package Service 3 1.01 lbs $5.99 $6.85 $-0.86
205194 2019-01-08 $74.67 Priority Mail 2-Day 9 3.06 lbs $10.22 $8.43 $1.79
205201 2019-01-09 $134.85 Direct Link International 5 3.18 lbs $38.30 $36.63 $1.67
205202 2019-01-09 $8.17 First-Class Package Service 2 0.34 lbs $4.19 $3.50 $0.69
205208 2019-01-09 $265.24 Priority Mail International 3 11.57 lbs $111.07 $104.07 $7.00
205218 2019-01-09 $17.14 First-Class Package Service 7 0.11 lbs $3.71 $2.66 $1.05
205219 2019-01-09 $4.70 First-Class Package Service 1 0.01 lbs $3.71 $2.79 $0.92
205222 2019-01-09 $13.69 First-Class Package Service 2 0.20 lbs $3.71 $2.66 $1.05
205225 2019-01-09 $75.93 Priority Mail 2-Day 4 2.95 lbs $10.11 $15.11 $-5.00
205237 2019-01-09 $32.74 Priority Mail 3-Day Flat Rate Envelope 10 1.26 lbs $7.40 $6.90 $0.50
205238 2019-01-09 $5.71 First-Class Package Service 4 0.20 lbs $4.54 $3.22 $1.32
205242 2019-01-10 $115.60 Priority Mail 2-Day 28 4.19 lbs $21.88 $23.35 $-1.47
205243 2019-01-10 $85.53 Priority Mail 2-Day Medium Flat Rate Box 32 2.66 lbs $13.85 $12.45 $1.40
205244 2019-01-10 $6.68 First-Class Package Service 3 0.04 lbs $3.71 $2.79 $0.92
205247 2019-01-10 $51.84 Priority Mail 3-Day Medium Flat Rate Box 1 1.70 lbs $4.54 $10.23 $-5.69
205253 2019-01-10 $20.78 First-Class Package Service 2 0.35 lbs $4.10 $3.18 $0.92
205254 2019-01-10 $59.60 Priority Mail 2-Day 4 1.90 lbs $14.00 $10.55 $3.45
205260 2019-01-10 $12.57 First-Class Package Service 2 0.80 lbs $5.79 $9.98 $-4.19
205262 2019-01-10 $135.18 First-Class Package International Service 15 1.00 lbs $30.33 $22.33 $8.00
205263 2019-01-10 $14.18 First-Class Package Service 1 0.30 lbs $3.97 $3.18 $0.79
205266 2019-01-10 $13.70 First-Class Package Service 1 0.08 lbs $3.71 $2.66 $1.05
205269 2019-01-10 $21.59 First-Class Package Service 1 0.40 lbs $4.10 $3.18 $0.92
205272 2019-01-11 $24.09 First-Class Package Service 1 0.40 lbs $4.10 $3.50 $0.60
205273 2019-01-11 $72.81 First-Class Package International Service 2 1.65 lbs $30.33 $22.33 $8.00
205274 2019-01-11 $49.60 Priority Mail 3-Day Flat Rate Envelope 4 1.55 lbs $7.40 $6.85 $0.55
205275 2019-01-11 $6.70 First-Class Package Service 1 0.03 lbs $3.71 $2.66 $1.05
205276 2019-01-11 $34.67 Priority Mail 2-Day Flat Rate Envelope 1 1.15 lbs $7.40 $6.85 $0.55
205278 2019-01-11 $29.77 First-Class Package Service 10 0.29 lbs $3.97 $3.05 $0.92
205280 2019-01-11 $31.27 Priority Mail 2-Day 5 0.39 lbs $10.32 $7.82 $2.50
205281 2019-01-11 $95.88 Direct Link International 2 2.70 lbs $29.90 $27.82 $2.08
205282 2019-01-11 $80.66 Direct Link International 2 2.50 lbs $29.88 $25.94 $3.94
205284 2019-01-11 $99.64 Direct Link International 4 2.52 lbs $28.68 $24.62 $4.06
205285 2019-01-11 $35.20 First-Class Package Service 1 1.05 lbs $5.71 $4.66 $1.05
205287 2019-01-12 $79.26 First-Class Package International Service 27 1.45 lbs $30.33 $33.01 $-2.68
205289 2019-01-12 $106.16 Direct Link International 5 2.56 lbs $30.11 $26.37 $3.74
205290 2019-01-12 $38.75 Priority Mail 3-Day 5 1.37 lbs $9.00 $6.98 $2.02
205291 2019-01-12 $37.69 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $7.90 $6.85 $1.05
205295 2019-01-12 $13.69 First-Class Package Service 2 0.20 lbs $3.71 $2.66 $1.05
205297 2019-01-12 $15.59 First-Class Package Service 12 0.12 lbs $3.71 $2.66 $1.05
205299 2019-01-12 $46.37 Priority Mail 2-Day Small Flat Rate Box 3 0.66 lbs $7.90 $6.85 $1.05
205300 2019-01-12 $248.48 Priority Mail International 2 15.65 lbs $129.50 $122.50 $7.00
205303 2019-01-12 $17.11 First-Class Package Service 4 0.12 lbs $3.71 $2.79 $0.92
205304 2019-01-12 $130.14 Priority Mail 3-Day 4 8.55 lbs $23.28 $15.62 $7.66
205305 2019-01-12 $15.18 Priority Mail 2-Day Flat Rate Envelope 2 0.10 lbs $7.40 $6.90 $0.50
205311 2019-01-13 $5.18 First-Class Package Service 3 0.03 lbs $3.71 $2.66 $1.05
205312 2019-01-13 $54.13 Priority Mail 3-Day 8 2.45 lbs $10.11 $10.03 $0.08
205314 2019-01-13 $17.90 First-Class Package Service 3 0.39 lbs $4.10 $2.92 $1.18
205317 2019-01-13 $52.75 Priority Mail 3-Day Medium Flat Rate Box 10 5.00 lbs $13.85 $12.45 $1.40
205318 2019-01-13 $58.25 Priority Mail 3-Day 4 2.42 lbs $16.19 $14.88 $1.31
205319 2019-01-13 $27.89 Priority Mail 3-Day Small Flat Rate Box 1 1.05 lbs $7.90 $6.85 $1.05
205322 2019-01-14 $44.02 Direct Link International 4 0.39 lbs $19.85 $13.34 $6.51
205330 2019-01-14 $13.47 First-Class Package Service 4 0.20 lbs $5.51 $5.53 $-0.02
205331 2019-01-14 $32.57 Standard 2 0.25 lbs $29.58 $9.98 $19.60
205335 2019-01-14 $7.70 First-Class Package Service 1 0.04 lbs $3.71 $2.66 $1.05
205336 2019-01-14 $15.76 First-Class Package Service 1 0.30 lbs $3.97 $3.05 $0.92
205337 2019-01-14 $34.65 First-Class Package Service 6 0.60 lbs $4.71 $3.18 $1.53
205338 2019-01-14 $10.70 First-Class Package Service 1 0.19 lbs $3.71 $2.66 $1.05
205339 2019-01-14 $0.00 Priority Mail 2-Day 11 25.92 lbs $31.88 $31.88 $0.00
205355 2019-01-14 $5.70 First-Class Package Service 1 0.07 lbs $3.71 $2.66 $1.05
205360 2019-01-14 $5.67 First-Class Package Service 4 0.04 lbs $3.71 $2.66 $1.05
205365 2019-01-15 $239.59 Direct Link International 71 13.09 lbs $78.77 $73.96 $4.81
205366 2019-01-15 $108.12 First-Class Package International Service 3 2.65 lbs $42.91 $56.53 $-13.62
205369 2019-01-15 $390.26 Direct Link International 29 9.31 lbs $80.91 $15.93 $64.98
205370 2019-01-15 $21.52 First-Class Package Service 3 0.53 lbs $4.54 $5.38 $-0.84
205371 2019-01-15 $28.21 First-Class Package Service 2 0.41 lbs $4.23 $2.66 $1.57
205372 2019-01-15 $178.11 Ground 1 30.00 lbs $43.12 $36.87 $6.25
205374 2019-01-15 $17.01 First-Class Package Service 2 0.35 lbs $4.23 $3.18 $1.05
205375 2019-01-15 $48.08 First-Class Package Service 3 0.85 lbs $5.71 $3.82 $1.89
205376 2019-01-15 $17.82 First-Class Package Service 2 0.26 lbs $3.84 $2.66 $1.18
205379 2019-01-15 $16.88 First-Class Package Service 3 0.75 lbs $5.51 $3.82 $1.69
205391 2019-01-15 $176.61 Priority Mail 2-Day 3 16.45 lbs $31.94 $30.16 $1.78
205393 2019-01-16 $8.70 First-Class Package Service 1 0.02 lbs $3.71 $2.66 $1.05
205394 2019-01-16 $26.32 Priority Mail 2-Day 3 0.60 lbs $8.35 $7.28 $1.07
205395 2019-01-16 $6.20 First-Class Package Service 1 0.19 lbs $3.84 $2.66 $1.18
205397 2019-01-16 $240.98 Ground 2 14.25 lbs $30.85 $27.13 $3.72
205398 2019-01-16 $8.55 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
205401 2019-01-16 $30.12 Priority Mail 2-Day 2 1.52 lbs $11.14 $9.98 $1.16
205402 2019-01-16 $24.09 First-Class Package Service 1 0.35 lbs $4.10 $3.18 $0.92
205403 2019-01-17 $82.77 Priority Mail 2-Day Medium Flat Rate Box 28 3.12 lbs $13.85 $10.80 $3.05
205404 2019-01-17 $100.40 Priority Mail 2-Day 28 3.28 lbs $21.88 $12.45 $9.43
205407 2019-01-17 $54.68 Priority Mail 3-Day Flat Rate Envelope 2 1.65 lbs $7.40 $6.85 $0.55
205409 2019-01-17 $17.98 First-Class Package Service 3 0.14 lbs $3.71 $2.79 $0.92
205410 2019-01-17 $32.77 Priority Mail 2-Day 3 1.35 lbs $4.54 $13.10 $-8.56
205411 2019-01-17 $7.67 First-Class Package Service 4 0.04 lbs $3.71 $2.66 $1.05
205412 2019-01-17 $22.78 First-Class Package Service 1 0.40 lbs $4.39 $3.66 $0.73
205413 2019-01-17 $19.27 First-Class Package Service 4 0.20 lbs $3.71 $3.05 $0.66
205415 2019-01-17 $156.39 USPS Priority Mail 3 3.60 lbs $4.54 $10.33 $-5.79
205417 2019-01-17 $22.38 First-Class Package Service 9 0.28 lbs $3.97 $2.92 $1.05
205422 2019-01-17 $73.31 Priority Mail 3-Day 19 1.03 lbs $9.00 $7.91 $1.09
205423 2019-01-17 $14.41 First-Class Package Service 6 0.26 lbs $3.97 $2.66 $1.31
205426 2019-01-17 $22.81 Priority Mail 3-Day 3 1.50 lbs $11.14 $6.90 $4.24
205427 2019-01-17 $5.69 First-Class Package Service 2 0.02 lbs $3.71 $2.66 $1.05
205429 2019-01-17 $13.35 Priority Mail 2-Day 1 0.10 lbs $7.40 $2.66 $4.74
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56