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
200134 2017-08-29 $49.92 Priority Mail 2-Day 2 1.50 lbs $10.94 $9.69 $1.25
200136 2017-08-29 $17.51 Priority Mail 3-Day 3 0.73 lbs $10.12 $8.91 $1.21
200138 2017-08-30 $5.39 First-Class Mail Parcel 1 0.04 lbs $3.40 $2.61 $0.79
200139 2017-08-30 $9.92 First-Class Mail Parcel 4 0.05 lbs $3.96 $2.77 $1.19
200146 2017-08-30 $8.78 First-Class Mail Parcel 1 0.25 lbs $3.59 $2.77 $0.82
200147 2017-08-30 $21.35 First-Class Mail Large Envelope 1 0.30 lbs $2.96 $2.77 $0.19
200149 2017-08-31 $22.55 First-Class Mail Parcel 2 0.20 lbs $3.77 $2.77 $1.00
200151 2017-08-31 $58.82 Priority Mail 2-Day 2 1.45 lbs $10.94 $6.25 $4.69
200152 2017-08-31 $37.79 First-Class Mail Parcel 4 0.35 lbs $4.33 $2.77 $1.56
200157 2017-08-31 $416.46 Priority Mail International 10 13.05 lbs $99.96 $61.56 $38.40
200158 2017-08-31 $270.26 Priority Mail International 2 13.55 lbs $97.08 $93.62 $3.46
200166 2017-09-01 $35.28 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $7.29 $6.25 $1.04
200167 2017-09-01 $78.60 Priority Mail 2-Day 4 1.45 lbs $9.04 $7.91 $1.13
200168 2017-09-02 $5.94 First-Class Mail Large Envelope 2 0.28 lbs $2.96 $2.77 $0.19
200171 2017-09-02 $18.38 First-Class Mail Large Envelope 1 0.40 lbs $3.39 $2.77 $0.62
200172 2017-09-02 $26.97 Priority Mail 2-Day 1 0.60 lbs $7.68 $6.63 $1.05
200177 2017-09-02 $39.28 Priority Mail 3-Day Small Flat Rate Box 1 1.15 lbs $7.29 $6.25 $1.04
200182 2017-09-03 $32.84 First-Class Package International Service 2 0.10 lbs $13.86 $12.83 $1.03
200185 2017-09-04 $19.74 First-Class Mail Large Envelope 2 0.43 lbs $4.26 $3.32 $0.94
200186 2017-09-04 $26.48 Priority Mail 2-Day Small Flat Rate Box 1 1.00 lbs $7.29 $6.25 $1.04
200189 2017-09-04 $42.50 Priority Mail 3-Day Medium Flat Rate Box 2 2.00 lbs $13.42 $14.45 $-1.03
200196 2017-09-05 $329.72 Ground 8 31.13 lbs $51.80 $41.73 $10.07
200200 2017-09-05 $19.26 Priority Mail 3-Day Small Flat Rate Box 3 0.28 lbs $7.29 $6.25 $1.04
200201 2017-09-05 $25.74 Priority Mail 3-Day Padded Flat Rate Envelope 1 0.40 lbs $7.35 $6.25 $1.10
200205 2017-09-06 $39.07 Priority Mail 3-Day Small Flat Rate Box 2 0.65 lbs $7.29 $6.25 $1.04
200211 2017-09-06 $47.25 Priority Mail 1-Day 3 0.75 lbs $6.78 $6.25 $0.53
200212 2017-09-07 $170.11 Priority Mail 3-Day 8 8.85 lbs $22.67 $12.05 $10.62
200220 2017-09-08 $16.28 Priority Mail 3-Day Small Flat Rate Box 1 0.05 lbs $7.29 $6.25 $1.04
200224 2017-09-08 $18.18 First-Class Mail Large Envelope 1 0.35 lbs $3.39 $3.60 $-0.21
200225 2017-09-08 $181.09 Priority Mail 2-Day 2 11.35 lbs $16.21 $15.31 $0.90
200226 2017-09-08 $17.62 Priority Mail 2-Day Padded Flat Rate Envelope 3 0.23 lbs $7.35 $6.25 $1.10
200228 2017-09-08 $52.98 Priority Mail 3-Day Small Flat Rate Box 1 1.60 lbs $7.29 $6.25 $1.04
200231 2017-09-08 $37.14 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $21.35 $7.35 $14.00
200232 2017-09-09 $8.84 Priority Mail 3-Day Padded Flat Rate Envelope 1 0.01 lbs $7.35 $5.75 $1.60
200234 2017-09-09 $7.35 Priority Mail 3-Day Small Flat Rate Box 1 1.25 lbs $7.35 $6.25 $1.10
200235 2017-09-09 $11.82 Priority Mail 2-Day Flat Rate Envelope 1 0.20 lbs $6.83 $5.75 $1.08
200237 2017-09-09 $55.49 First-Class Package International Service 1 1.30 lbs $22.50 $21.14 $1.36
200238 2017-09-09 $12.20 First-Class Mail Large Envelope 3 0.18 lbs $3.23 $2.61 $0.62
200239 2017-09-10 $92.14 Priority Mail 3-Day Small Flat Rate Box 1 2.00 lbs $7.35 $6.25 $1.10
200240 2017-09-10 $77.54 First-Class Package International Service 4 1.10 lbs $22.98 $21.61 $1.37
200241 2017-09-10 $142.51 Priority Mail 2-Day Flat Rate Envelope 32 1.84 lbs $6.83 $6.25 $0.58
200243 2017-09-10 $98.63 Priority Mail 2-Day Medium Flat Rate Box 5 2.27 lbs $13.48 $9.99 $3.49
200245 2017-09-10 $38.73 Priority Mail 2-Day 4 0.76 lbs $7.77 $6.25 $1.52
200251 2017-09-10 $18.02 First-Class Mail Large Envelope 2 0.32 lbs $3.01 $2.77 $0.24
200252 2017-09-10 $48.78 Priority Mail 1-Day 2 1.45 lbs $7.42 $6.33 $1.09
200253 2017-09-11 $18.48 First-Class Package International Service 3 0.11 lbs $10.01 $9.03 $0.98
200254 2017-09-11 $15.30 Priority Mail 2-Day Small Flat Rate Box 5 0.06 lbs $7.35 $6.25 $1.10
200260 2017-09-11 $59.29 Priority Mail 2-Day Flat Rate Envelope 4 1.44 lbs $6.83 $6.25 $0.58
200261 2017-09-11 $514.96 (Estimated Delivery: 3 — 5 business days) 8 21.22 lbs $201.04 $135.47 $65.57
200262 2017-09-11 $75.26 Ground 2 2.55 lbs $12.68 $6.25 $6.43
200263 2017-09-12 $78.31 Priority Mail 2-Day 3 2.30 lbs $12.88 $9.19 $3.69
200265 2017-09-12 $10.33 Priority Mail 2-Day Flat Rate Envelope 1 0.03 lbs $6.84 $5.75 $1.09
200266 2017-09-12 $26.67 First-Class Mail Large Envelope 2 0.50 lbs $3.66 $3.60 $0.06
200267 2017-09-12 $24.66 Priority Mail 2-Day 2 0.97 lbs $10.18 $8.91 $1.27
200269 2017-09-13 $585.28 (Estimated Delivery: 6 — 10 business days) 9 35.12 lbs $191.57 $216.51 $-24.94
200278 2017-09-14 $18.61 First-Class Package Service 4 0.15 lbs $3.65 $2.61 $1.04
200279 2017-09-14 $26.97 First-Class Mail Large Envelope 4 0.45 lbs $3.71 $3.32 $0.39
200281 2017-09-14 $7.14 First-Class Package Service 1 0.03 lbs $3.65 $2.61 $1.04
200282 2017-09-14 $14.88 Priority Mail 2-Day Flat Rate Envelope 2 0.06 lbs $6.90 $5.75 $1.15
200284 2017-09-15 $37.55 Priority Mail 2-Day Medium Flat Rate Box 1 3.55 lbs $13.56 $9.19 $4.37
200289 2017-09-15 $11.63 First-Class Package Service 2 0.05 lbs $3.65 $2.61 $1.04
200290 2017-09-15 $26.43 First-Class Package Service 2 0.74 lbs $5.25 $4.16 $1.09
200300 2017-09-16 $26.09 Priority Mail 2-Day Flat Rate Envelope 1 1.00 lbs $6.90 $6.25 $0.65
200355 2017-09-21 $82.99 First-Class Package International Service 2 2.00 lbs $33.71 $31.83 $1.88
200356 2017-09-22 $37.26 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $7.47 $6.25 $1.22
200360 2017-09-22 $19.76 First-Class Mail Large Envelope 1 0.41 lbs $3.77 $3.46 $0.31
200361 2017-09-22 $22.73 Priority Mail 2-Day 2 0.52 lbs $6.95 $5.75 $1.20
200364 2017-09-23 $62.64 First-Class Package Service 2 0.60 lbs $5.16 $4.30 $0.86
200365 2017-09-23 $4.51 First-Class Mail Stamped Letter 1 0.03 lbs $1.52 $2.61 $-1.09
200367 2017-09-24 $12.38 First-Class Package Service 3 0.15 lbs $3.71 $2.61 $1.10
200370 2017-09-24 $8.15 First-Class Mail Stamped Letter 3 0.03 lbs $2.18 $2.61 $-0.43
200371 2017-09-24 $47.91 Priority Mail 2-Day Flat Rate Envelope 4 1.33 lbs $6.95 $6.25 $0.70
200373 2017-09-25 $91.59 Priority Mail 3-Day Medium Flat Rate Box 3 14.10 lbs $13.62 $6.25 $7.37
200374 2017-09-25 $88.12 Priority Mail 3-Day 4 2.84 lbs $11.66 $10.19 $1.47
200377 2017-09-25 $92.26 Priority Mail 2-Day Small Flat Rate Box 1 2.85 lbs $7.47 $6.25 $1.22
200378 2017-09-26 $127.41 First-Class Package International Service 5 3.02 lbs $36.66 $34.68 $1.98
200379 2017-09-26 $11.59 First-Class Mail Stamped Letter 3 0.10 lbs $1.96 $2.61 $-0.65
200380 2017-09-26 $49.50 Priority Mail 3-Day 4 1.40 lbs $7.86 $6.63 $1.23
200381 2017-09-26 $84.65 First-Class Package International Service 6 2.19 lbs $33.71 $31.83 $1.88
200382 2017-09-26 $79.29 First-Class Package International Service 2 1.90 lbs $33.71 $31.83 $1.88
200383 2017-09-26 $54.89 First-Class Package International Service 2 0.82 lbs $22.91 $21.38 $1.53
200386 2017-09-26 $66.29 First-Class Package International Service 12 1.17 lbs $22.91 $21.38 $1.53
200387 2017-09-26 $97.28 Priority Mail 2-Day 4 3.18 lbs $9.82 $10.19 $-0.37
200388 2017-09-27 $38.20 Priority Mail 3-Day 3 1.15 lbs $9.23 $7.91 $1.32
200389 2017-09-27 $45.36 Ground 2 0.57 lbs $18.02 $6.25 $11.77
200390 2017-09-27 $24.39 First-Class Package Service 1 0.60 lbs $5.10 $4.16 $0.94
200392 2017-09-27 $21.11 First-Class Mail Large Envelope 1 0.30 lbs $3.12 $2.77 $0.35
200393 2017-09-27 $24.02 First-Class Mail Large Envelope 3 0.39 lbs $3.55 $2.77 $0.78
200395 2017-09-27 $59.50 Priority Mail 2-Day Padded Flat Rate Envelope 2 1.87 lbs $7.52 $6.83 $0.69
200397 2017-09-28 $44.31 Priority Mail 2-Day 2 1.25 lbs $11.13 $9.69 $1.44
200399 2017-09-28 $40.13 Priority Mail 2-Day 3 1.25 lbs $7.86 $37.10 $-29.24
200400 2017-09-28 $79.08 Priority Mail International Small Flat Rate Box 2 1.55 lbs $31.20 $29.40 $1.80
200401 2017-09-28 $10.70 First-Class Package Service 1 0.19 lbs $3.71 $2.61 $1.10
200402 2017-09-28 $82.89 Priority Mail 2-Day 1 4.40 lbs $14.90 $10.62 $4.28
200403 2017-09-28 $40.95 First-Class Package International Service 1 0.90 lbs $22.66 $21.14 $1.52
200404 2017-09-28 $36.94 Priority Mail 2-Day 8 3.20 lbs $9.82 $8.46 $1.36
200407 2017-09-29 $36.41 Priority Mail 2-Day 2 1.60 lbs $11.43 $9.97 $1.46
200408 2017-09-29 $25.14 First-Class Package Service 3 0.30 lbs $3.87 $2.77 $1.10
200409 2017-09-29 $107.46 Priority Mail International 10 3.64 lbs $59.56 $54.82 $4.74
200411 2017-09-29 $49.37 First-Class Package International Service 4 1.05 lbs $22.91 $21.38 $1.53
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56