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
216158 2020-10-03 $14.43 USPSFirstClass 1 0.05 lbs $4.40 $2.84 $1.56
216164 2020-10-03 $13.98 USPSFirstClass 2 0.20 lbs $4.27 $3.05 $1.22
216165 2020-10-03 $11.28 USPSFirstClass 1 0.20 lbs $4.39 $3.52 $0.87
216166 2020-10-03 $12.13 USPSFirstClass 1 0.30 lbs $5.24 $5.54 $-0.30
216169 2020-10-03 $14.18 USPSFirstClass 2 0.20 lbs $4.20 $2.84 $1.36
216170 2020-10-02 $40.94 Priority Mail 3-Day 1 0.90 lbs $8.83 $7.65 $1.18
216171 2020-10-02 $22.21 First-Class Package Service 2 0.10 lbs $3.23 $2.78 $0.45
216173 2020-10-02 $8.79 First-Class Package Service 1 0.25 lbs $3.77 $3.52 $0.25
216175 2020-10-02 $117.60 Priority Mail 2-Day 24 1.97 lbs $9.44 $9.07 $0.37
216176 2020-10-03 $29.68 First-Class Package Service 10 0.18 lbs $3.76 $3.31 $0.45
216177 2020-10-03 $39.40 InternationalPriorityShipping 1 0.16 lbs $4.66 $3.05 $1.61
216178 2020-10-03 $10.03 USPSFirstClass 1 0.20 lbs $4.45 $3.67 $0.78
216179 2020-10-03 $8.40 USPSFirstClass 2 0.02 lbs $4.14 $3.05 $1.09
216182 2020-10-03 $16.88 First-Class Package Service 3 0.57 lbs $4.91 $4.46 $0.45
216186 2020-10-03 $12.63 Priority Mail 2-Day 2 0.02 lbs $8.65 $7.80 $0.85
216188 2020-10-03 $49.62 Priority Mail 2-Day 1 1.31 lbs $8.49 $7.75 $0.74
216189 2020-10-03 $19.24 Priority Mail 3-Day Flat Rate Envelope 6 0.19 lbs $8.00 $7.65 $0.35
216190 2020-10-03 $10.32 First-Class Mail Stamped Letter 3 0.08 lbs $3.35 $3.05 $0.30
216193 2020-10-03 $9.99 Priority Mail 2-Day Flat Rate Envelope 1 0.05 lbs $8.00 $7.65 $0.35
216194 2020-10-03 $61.78 Priority Mail 3-Day Flat Rate Envelope 2 2.00 lbs $8.00 $8.15 $-0.15
216195 2020-10-03 $26.60 First-Class Package Service 16 0.26 lbs $3.76 $3.09 $0.67
216196 2020-10-03 $29.80 Priority Mail 2-Day Flat Rate Envelope 2 0.12 lbs $8.00 $7.65 $0.35
216201 2020-10-03 $19.84 Priority Mail 2-Day Flat Rate Envelope 2 0.10 lbs $8.00 $7.65 $0.35
216204 2020-10-03 $22.26 First-Class Package Service 1 0.65 lbs $4.77 $5.54 $-0.77
216210 2020-10-04 $51.26 USPSPriority 2 2.00 lbs $10.85 $3.25 $7.60
216211 2020-10-04 $39.44 USPSFirstClass 2 0.40 lbs $5.50 $3.25 $2.25
216212 2020-10-04 $7.37 USPSFirstClass 1 0.07 lbs $4.14 $2.93 $1.21
216213 2020-10-03 $16.68 Priority Mail 2-Day Flat Rate Envelope 2 0.10 lbs $8.00 $7.65 $0.35
216214 2020-10-03 $14.19 First-Class Package Service 1 0.06 lbs $3.29 $2.84 $0.45
216215 2020-10-03 $37.44 Priority Mail 2-Day Medium Flat Rate Box 11 2.14 lbs $14.45 $13.75 $0.70
216216 2020-10-04 $9.81 USPSFirstClass 1 0.20 lbs $4.25 $3.39 $0.86
216217 2020-10-04 $10.15 USPSFirstClass 1 0.08 lbs $4.21 $2.84 $1.37
216218 2020-10-04 $7.01 First-Class Package Service 2 0.02 lbs $3.23 $3.25 $-0.02
216220 2020-10-04 $13.29 First-Class Package Service 8 0.38 lbs $3.97 $4.32 $-0.35
216221 2020-10-04 $18.83 First-Class Mail Stamped Letter 2 0.07 lbs $3.35 $2.93 $0.42
216222 2020-10-04 $28.56 Priority Mail 3-Day 4 2.00 lbs $13.00 $10.42 $2.58
216226 2020-10-04 $44.25 First-Class Package Service 2 0.60 lbs $4.77 $5.54 $-0.77
216227 2020-10-04 $22.87 First-Class Package Service 1 0.35 lbs $4.12 $3.67 $0.45
216229 2020-10-04 $6.19 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $2.84 $0.36
216230 2020-10-04 $56.87 Priority Mail 3-Day Flat Rate Envelope 4 1.62 lbs $8.00 $8.05 $-0.05
216231 2020-10-04 $31.99 Priority Mail 3-Day Flat Rate Envelope 1 0.85 lbs $8.00 $7.75 $0.25
216233 2020-10-04 $9.27 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $2.93 $0.42
216235 2020-10-04 $35.00 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.50 $7.65 $0.85
216236 2020-10-04 $68.57 Priority Mail 3-Day 2 1.90 lbs $10.39 $9.64 $0.75
216237 2020-10-04 $9.16 First-Class Package Service 2 0.15 lbs $3.38 $2.93 $0.45
216238 2020-10-05 $16.05 USPSFirstClass 1 0.35 lbs $5.25 $4.08 $1.17
216239 2020-10-04 $37.01 Priority Mail 2-Day Flat Rate Envelope 1 1.10 lbs $8.00 $7.65 $0.35
216240 2020-10-05 $7.83 USPSFirstClass 1 0.03 lbs $4.07 $2.78 $1.29
216242 2020-10-05 $10.64 First-Class Mail Stamped Letter 1 0.19 lbs $3.65 $3.05 $0.60
216243 2020-10-05 $8.42 First-Class Package Service 1 0.09 lbs $3.23 $2.78 $0.45
216246 2020-10-05 $17.56 Priority Mail 2-Day Flat Rate Envelope 4 1.00 lbs $8.00 $7.75 $0.25
216247 2020-10-05 $5.34 First-Class Mail Stamped Letter 1 0.07 lbs $3.35 $3.18 $0.17
216248 2020-10-05 $4.18 First-Class Mail Stamped Letter 2 0.02 lbs $3.20 $3.18 $0.02
216249 2020-10-05 $152.62 Priority Mail 3-Day 3 9.42 lbs $15.35 $12.16 $3.19
216250 2020-10-05 $19.70 USPSFirstClass 1 0.29 lbs $5.55 $3.52 $2.03
216251 2020-10-05 $95.84 Priority Mail 2-Day 2 4.40 lbs $21.86 $19.30 $2.56
216256 2020-10-05 $215.46 Priority Mail 2-Day 3 11.25 lbs $18.53 $19.01 $-0.48
216257 2020-10-05 $8.39 USPSFirstClass 1 0.10 lbs $4.40 $3.18 $1.22
216259 2020-10-05 $8.63 USPSFirstClass 2 0.06 lbs $4.15 $3.05 $1.10
216262 2020-10-05 $59.60 First-Class Package Service 11 0.53 lbs $4.91 $4.46 $0.45
216263 2020-10-05 $51.49 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.50 $8.05 $0.45
216266 2020-10-06 $8.66 USPSFirstClass 1 0.10 lbs $4.27 $3.05 $1.22
216267 2020-10-05 $34.73 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.50 $7.65 $0.85
216270 2020-10-05 $6.17 First-Class Package Service 6 0.06 lbs $3.23 $2.78 $0.45
216271 2020-10-05 $6.12 First-Class Package Service 1 0.05 lbs $3.23 $2.78 $0.45
216272 2020-10-06 $7.53 USPSFirstClass 1 0.05 lbs $4.35 $3.18 $1.17
216274 2020-10-05 $40.19 Priority Mail 2-Day 1 3.30 lbs $10.24 $9.07 $1.17
216276 2020-10-05 $112.98 Priority Mail 2-Day Medium Flat Rate Box 7 2.80 lbs $14.45 $11.18 $3.27
216277 2020-10-06 $16.41 First-Class Package Service 1 0.30 lbs $3.66 $3.21 $0.45
216279 2020-10-06 $8.31 First-Class Mail Stamped Letter 4 0.08 lbs $3.35 $2.93 $0.42
216280 2020-10-06 $10.44 USPSFirstClass 1 0.08 lbs $4.46 $3.18 $1.28
216281 2020-10-06 $16.03 USPSFirstClass 5 0.15 lbs $4.85 $2.84 $2.01
216282 2020-10-06 $10.23 USPSFirstClass 1 0.45 lbs $4.94 $4.00 $0.94
216284 2020-10-06 $7.46 First-Class Mail Stamped Letter 4 0.16 lbs $3.50 $3.05 $0.45
216286 2020-10-06 $9.74 USPSFirstClass 1 0.02 lbs $4.19 $2.84 $1.35
216287 2020-10-06 $17.69 USPSFirstClass 1 0.16 lbs $4.51 $3.25 $1.26
216289 2020-10-06 $12.13 USPSFirstClass 1 0.30 lbs $5.24 $5.54 $-0.30
216292 2020-10-06 $9.34 First-Class Package Service 1 0.45 lbs $4.45 $4.00 $0.45
216295 2020-10-06 $23.54 First-Class Package Service 2 0.26 lbs $3.56 $3.31 $0.25
216299 2020-10-06 $6.75 First-Class Package Service 1 0.15 lbs $3.76 $2.84 $0.92
216300 2020-10-06 $57.79 USPSPriority 1 5.15 lbs $14.82 $14.50 $0.32
216302 2020-10-07 $47.31 USPSPriority 1 1.60 lbs $12.55 $8.76 $3.79
216304 2020-10-07 $9.19 USPSFirstClass 1 0.10 lbs $4.27 $3.05 $1.22
216305 2020-10-07 $46.43 First-Class Package Service 2 0.70 lbs $5.95 $5.70 $0.25
216306 2020-10-07 $15.33 USPSFirstClass 1 0.05 lbs $4.67 $3.18 $1.49
216307 2020-10-07 $19.79 Priority Mail 2-Day Flat Rate Envelope 1 0.20 lbs $8.00 $7.65 $0.35
216308 2020-10-07 $15.91 First-Class Package Service 1 0.30 lbs $4.12 $3.67 $0.45
216309 2020-10-07 $7.85 First-Class Mail Stamped Letter 1 0.15 lbs $3.50 $3.05 $0.45
216310 2020-10-07 $23.66 First-Class Package Service 4 0.40 lbs $3.70 $3.25 $0.45
216313 2020-10-07 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.50 $7.65 $0.85
216316 2020-10-07 $1113.21 Priority Mail 2-Day Large Flat Rate Box 25 29.31 lbs $54.30 $58.18 $-3.88
216317 2020-10-07 $15.76 First-Class Package Service 1 0.30 lbs $3.97 $3.52 $0.45
216319 2020-10-07 $24.45 Direct Link International 1 0.07 lbs $19.46 $9.90 $9.56
216320 2020-10-07 $37.43 Priority Mail 3-Day Flat Rate Envelope 7 0.95 lbs $8.00 $8.15 $-0.15
216321 2020-10-07 $10.45 Priority Mail 3-Day Flat Rate Envelope 5 0.05 lbs $8.00 $7.15 $0.85
216322 2020-10-08 $27.39 USPSFirstClass 1 0.40 lbs $5.88 $4.18 $1.70
216323 2020-10-07 $27.65 Priority Mail 2-Day Flat Rate Envelope 7 1.11 lbs $8.00 $7.65 $0.35
216326 2020-10-07 $92.99 Priority Mail 2-Day Small Flat Rate Box 1 2.15 lbs $8.50 $7.65 $0.85
216327 2020-10-08 $65.03 Priority Mail 3-Day 1 1.45 lbs $12.04 $11.18 $0.86
216329 2020-10-08 $9.50 USPSFirstClass 1 0.10 lbs $4.27 $3.05 $1.22
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56