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
229269 2022-04-25 $37.32 Priority Mail 2-Day Flat Rate Envelope 3 0.70 lbs $8.85 $8.45 $0.40
229270 2022-04-25 $85.24 FedEx Ground or FedEx Home Delivery 1 5.30 lbs $12.25 $17.47 $-5.22
229271 2022-04-25 $14.19 USPS First Class 1 0.06 lbs $4.70 $3.48 $1.22
229272 2022-04-25 $38.10 USPS Priority Mail 1 0.40 lbs $10.22 $8.12 $2.10
229273 2022-04-25 $34.87 First-Class Package Service 1 0.22 lbs $5.08 $3.88 $1.20
229274 2022-04-26 $11.73 USPS First-Class Mail or Priority Mail 1 0.08 lbs $4.48 $3.48 $1.00
229275 2022-04-26 $6.79 USPS Shipping 1 0.02 lbs $4.00 $3.48 $0.52
229277 2022-04-26 $59.33 Ground 1 0.44 lbs $14.34 $11.02 $3.32
229281 2022-04-27 $29.42 First-Class Package Service 3 0.13 lbs $5.35 $3.86 $1.49
229282 2022-04-27 $31.97 Priority Mail 2-Day 6 1.62 lbs $13.76 $12.66 $1.10
229284 2022-04-28 $12.29 USPS First Class 1 0.25 lbs $5.00 $4.98 $0.02
229286 2022-04-28 $36.96 Priority Mail 2-Day 1 1.20 lbs $13.76 $12.66 $1.10
229287 2022-04-28 $13.92 Priority Mail 3-Day 1 0.07 lbs $10.78 $7.75 $3.03
229288 2022-04-29 $12.35 USPS Shipping 1 0.05 lbs $5.06 $3.42 $1.64
229289 2022-04-29 $19.18 First-Class Package Service 1 0.26 lbs $5.19 $3.99 $1.20
229290 2022-04-30 $13.71 First-Class Package Service 1 0.10 lbs $5.06 $3.86 $1.20
229291 2022-04-30 $19.93 USPS First-Class Mail or Priority Mail 1 0.12 lbs $4.86 $3.86 $1.00
229292 2022-04-30 $10.21 First-Class Package Service 1 0.18 lbs $5.07 $3.48 $1.59
229293 2022-04-30 $37.07 First-Class Package Service 1 0.31 lbs $5.08 $3.88 $1.20
229294 2022-04-30 $19.04 First-Class Package Service 2 0.12 lbs $5.06 $4.15 $0.91
229295 2022-04-30 $13.99 Priority Mail 3-Day Flat Rate Envelope 1 0.19 lbs $8.85 $8.25 $0.60
229296 2022-05-01 $11.91 First-Class Package Service 2 0.06 lbs $4.78 $3.58 $1.20
229299 2022-05-03 $47.11 Priority Mail 2-Day 1 0.40 lbs $13.76 $9.68 $4.08
229300 2022-05-03 $42.14 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $9.35 $8.25 $1.10
229306 2022-05-03 $7.26 First-Class Package Service 1 0.03 lbs $4.62 $3.42 $1.20
229309 2022-05-04 $10.59 USPS First Class 1 0.04 lbs $4.80 $3.72 $1.08
229310 2022-05-04 $41.72 First-Class Package Service 6 0.56 lbs $5.88 $4.68 $1.20
229311 2022-05-04 $14.91 First-Class Package Service 1 0.07 lbs $4.92 $3.72 $1.20
229313 2022-05-04 $9.76 First-Class Package Service 1 0.05 lbs $4.62 $3.42 $1.20
229317 2022-05-06 $8.55 First-Class Package Service 2 0.08 lbs $4.92 $3.72 $1.20
229318 2022-05-06 $9.48 First-Class Package Service 3 0.03 lbs $5.06 $3.86 $1.20
229319 2022-05-07 $16.82 FedEx Ground or FedEx Home Delivery 1 0.03 lbs $12.03 $15.89 $-3.86
229321 2022-05-07 $9.40 First-Class Package Service 1 0.03 lbs $5.06 $3.86 $1.20
229322 2022-05-07 $14.38 First-Class Package Service 4 0.63 lbs $5.62 $4.42 $1.20
229325 2022-05-08 $31.75 First-Class Package Service 3 0.06 lbs $4.78 $3.88 $0.90
229326 2022-05-09 $14.21 First-Class Package Service 1 0.05 lbs $4.92 $3.72 $1.20
229327 2022-05-09 $17.62 USPS Shipping 1 0.12 lbs $4.13 $3.58 $0.55
229328 2022-05-09 $10.42 USPS Shipping 1 0.10 lbs $3.73 $3.48 $0.25
229329 2022-05-09 $20.84 USPS Shipping 2 0.20 lbs $0.00 $3.48 $-3.48
229330 2022-05-09 $8.07 First-Class Package Service 1 0.19 lbs $4.96 $3.37 $1.59
229331 2022-05-10 $58.30 Pickup From Store 10 1.00 lbs $0.00 $4.59 $-4.59
229332 2022-05-10 $119.54 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.35 lbs $9.55 $8.45 $1.10
229341 2022-05-10 $56.14 Priority Mail 3-Day 5 1.44 lbs $9.59 $8.49 $1.10
229343 2022-05-11 $13.43 First-Class Package Service 2 0.20 lbs $5.35 $3.86 $1.49
229344 2022-05-11 $29.19 First-Class Package Service 1 0.40 lbs $5.70 $3.87 $1.83
229346 2022-05-11 $64.44 USPS Priority Mail 1 0.56 lbs $9.45 $8.25 $1.20
229351 2022-05-12 $10.61 First-Class Package Service 2 0.32 lbs $5.08 $3.88 $1.20
229352 2022-05-12 $32.54 First-Class Package International Service 2 0.16 lbs $22.16 $14.11 $8.05
229353 2022-02-02 $20.85 First-Class Package Service 2 0.30 lbs $5.07 $3.87 $1.20
229354 2022-05-12 $42.34 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $9.35 $8.25 $1.10
229357 2022-05-12 $20.97 First-Class Package Service 1 0.35 lbs $5.08 $3.88 $1.20
229358 2022-05-12 $12.21 First-Class Package Service 1 0.19 lbs $5.07 $3.48 $1.59
229362 2022-05-13 $19.99 USPS First Class 1 0.19 lbs $5.00 $4.15 $0.85
229363 2022-05-13 $11.99 USPS First Class 1 0.03 lbs $4.70 $3.48 $1.22
229365 2022-05-14 $8.64 USPS First Class 1 0.15 lbs $4.65 $3.81 $0.84
229371 2022-05-15 $34.24 First-Class Package Service 4 0.66 lbs $5.62 $3.81 $1.81
229372 2022-05-15 $20.98 First-Class Package Service 3 0.19 lbs $5.01 $3.81 $1.20
229373 2022-05-15 $18.99 First-Class Package Service 3 0.03 lbs $4.62 $3.42 $1.20
229374 2022-05-16 $29.59 USPS First Class 1 0.26 lbs $5.20 $3.81 $1.39
229375 2022-05-16 $63.15 UPS Ground 1 2.54 lbs $13.16 $8.88 $4.28
229376 2022-05-16 $7.89 USPS First Class 1 0.10 lbs $4.70 $3.48 $1.22
229377 2022-05-16 $16.34 USPS First Class 1 0.14 lbs $4.65 $3.42 $1.23
229378 2022-05-16 $99.74 USPS Priority Mail 1 1.19 lbs $14.75 $11.62 $3.13
229379 2022-05-16 $9.44 USPS First Class 1 0.10 lbs $4.65 $3.42 $1.23
229380 2022-05-16 $12.09 USPS First-Class Mail or Priority Mail 1 0.08 lbs $4.86 $3.86 $1.00
229381 2022-05-16 $7.85 USPS First-Class Mail or Priority Mail 1 0.05 lbs $4.58 $3.58 $1.00
229383 2022-05-16 $42.97 United States 12 1.23 lbs $9.79 $8.25 $1.54
229389 2022-05-17 $13.77 USPS First-Class Mail or Priority Mail 1 0.10 lbs $4.48 $3.48 $1.00
229390 2022-05-17 $180.87 Priority Mail 2-Day Medium Flat Rate Box 3 4.45 lbs $15.90 $13.86 $2.04
229392 2022-05-17 $41.17 Priority Mail 2-Day 3 0.58 lbs $9.00 $8.25 $0.75
229394 2022-05-17 $25.81 Priority Mail 3-Day Flat Rate Envelope 4 0.21 lbs $8.85 $8.25 $0.60
229395 2022-05-17 $26.34 Priority Mail 2-Day Small Flat Rate Box 3 0.28 lbs $9.35 $7.75 $1.60
229396 2022-05-18 $6.64 USPS First Class 1 0.06 lbs $4.75 $3.58 $1.17
229397 2022-05-18 $7.84 USPS First Class 1 0.10 lbs $4.65 $3.42 $1.23
229398 2022-05-18 $11.84 First-Class Package Service 1 0.45 lbs $5.70 $4.50 $1.20
229400 2022-05-18 $275.88 Priority Mail 3-Day Medium Flat Rate Box 2 18.70 lbs $15.90 $12.13 $3.77
229403 2022-05-18 $9.81 First-Class Package Service 2 0.06 lbs $4.68 $3.48 $1.20
229405 2022-05-19 $61.24 USPS First Class 1 0.56 lbs $6.25 $4.98 $1.27
229406 2022-05-19 $7.59 USPS First Class 1 0.03 lbs $4.80 $3.72 $1.08
229407 2022-05-19 $8.20 First-Class Package Service 2 0.05 lbs $4.57 $3.37 $1.20
229410 2022-05-19 $83.79 Priority Mail 2-Day 13 1.24 lbs $12.72 $11.62 $1.10
229412 2022-05-19 $10.80 First-Class Package Service 1 0.06 lbs $5.06 $3.86 $1.20
229414 2022-05-20 $32.58 USPS First-Class Mail or Priority Mail 1 1.78 lbs $11.96 $10.96 $1.00
229417 2022-05-20 $39.68 First-Class Package Service 5 0.61 lbs $6.03 $6.11 $-0.08
229419 2022-05-21 $12.29 USPS First Class 1 0.06 lbs $4.80 $3.72 $1.08
229420 2022-05-21 $10.79 USPS First Class 1 0.04 lbs $5.00 $3.86 $1.14
229421 2022-05-21 $71.24 USPS First Class 1 0.75 lbs $6.25 $6.28 $-0.03
229424 2022-05-21 $12.26 First-Class Package Service 1 0.05 lbs $4.68 $3.48 $1.20
229425 2022-05-21 $8.10 First-Class Package Service 1 0.19 lbs $4.96 $3.37 $1.59
229426 2022-05-21 $40.89 USPS First Class 1 0.55 lbs $5.90 $4.42 $1.48
229427 2022-05-21 $24.13 First-Class Package Service 6 0.20 lbs $5.19 $3.72 $1.47
229431 2022-05-23 $10.79 USPS First Class 1 0.06 lbs $5.00 $3.86 $1.14
229432 2022-05-23 $26.06 First-Class Package Service 2 0.16 lbs $5.08 $3.88 $1.20
229435 2022-05-24 $21.99 USPS First Class 1 0.15 lbs $4.70 $3.48 $1.22
229436 2022-05-24 $9.14 USPS First Class 1 0.06 lbs $4.65 $3.42 $1.23
229437 2022-05-24 $9.56 First-Class Package Service 1 0.04 lbs $4.92 $3.72 $1.20
229439 2022-05-25 $9.19 USPS First Class 1 0.06 lbs $4.70 $3.48 $1.22
229440 2022-05-25 $44.99 USPS First Class 1 0.73 lbs $6.00 $5.96 $0.04
229441 2022-05-25 $12.09 USPS First Class 1 0.03 lbs $4.80 $3.72 $1.08
229442 2022-05-25 $82.56 Priority Mail 2-Day 2 1.89 lbs $10.08 $8.88 $1.20
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56