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
201147 2017-12-14 $78.77 Ground 1 3.60 lbs $18.78 $16.87 $1.91
201149 2017-12-14 $86.56 Priority Mail 3-Day Medium Flat Rate Box 4 2.80 lbs $13.40 $12.05 $1.35
201152 2017-12-14 $14.03 First-Class Package Service 3 0.15 lbs $3.66 $2.61 $1.05
201154 2017-12-14 $26.79 Priority Mail 2-Day Flat Rate Envelope 1 2.00 lbs $6.80 $6.25 $0.55
201155 2017-12-14 $7.65 First-Class Package Service 1 0.05 lbs $3.66 $2.77 $0.89
201156 2017-12-14 $75.01 Priority Mail 3-Day 18 5.90 lbs $10.75 $9.60 $1.15
201157 2017-12-14 $24.30 First-Class Package Service 1 0.60 lbs $5.01 $3.88 $1.13
201158 2017-12-14 $8.38 First-Class Mail Large Envelope 1 0.25 lbs $3.59 $2.77 $0.82
201160 2017-12-15 $66.03 Priority Mail 2-Day 18 0.36 lbs $7.71 $6.66 $1.05
201162 2017-12-15 $35.79 Priority Mail 2-Day Flat Rate Envelope 1 1.15 lbs $6.80 $6.25 $0.55
201164 2017-12-15 $37.09 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $7.30 $6.25 $1.05
201166 2017-12-15 $53.16 Priority Mail 2-Day Flat Rate Envelope 4 1.61 lbs $6.80 $6.25 $0.55
201167 2017-12-15 $51.08 Priority Mail 2-Day Flat Rate Envelope 2 1.35 lbs $6.80 $6.30 $0.50
201168 2017-12-15 $337.49 Ground 9 15.86 lbs $32.79 $25.15 $7.64
201169 2017-12-16 $5.13 First-Class Package Service 3 0.03 lbs $3.66 $2.61 $1.05
201173 2017-12-16 $37.09 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $7.30 $6.25 $1.05
201174 2017-12-16 $10.64 First-Class Package Service 2 0.10 lbs $3.66 $2.61 $1.05
201176 2017-12-16 $43.74 Priority Mail 2-Day Small Flat Rate Box 1 1.50 lbs $7.30 $6.25 $1.05
201177 2017-12-16 $41.91 Ground 13 0.80 lbs $15.24 $12.74 $2.50
201180 2017-12-16 $54.08 Priority Mail 2-Day Flat Rate Envelope 2 1.70 lbs $6.80 $6.25 $0.55
201181 2017-12-16 $16.81 First-Class Package Service 1 0.27 lbs $3.82 $2.77 $1.05
201182 2017-12-16 $83.50 Priority Mail 3-Day 5 2.71 lbs $10.35 $9.22 $1.13
201183 2017-12-17 $9.81 First-Class Package Service 1 0.19 lbs $3.82 $2.61 $1.21
201184 2017-12-17 $80.98 Priority Mail International Medium Flat Rate Box 2 4.00 lbs $44.50 $45.41 $-0.91
201185 2017-12-17 $26.70 Priority Mail 3-Day 1 0.65 lbs $7.41 $6.37 $1.04
201186 2017-12-17 $15.94 First-Class Package Service 2 0.11 lbs $3.66 $2.61 $1.05
201187 2017-12-18 $37.09 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $7.30 $6.25 $1.05
201190 2017-12-18 $52.99 Priority Mail 2-Day Small Flat Rate Box 1 1.65 lbs $7.30 $6.25 $1.05
201192 2017-12-18 $30.14 Priority Mail 3-Day Medium Flat Rate Box 6 1.95 lbs $13.40 $12.05 $1.35
201193 2017-12-19 $42.19 First-Class Package International Service 4 0.80 lbs $22.23 $21.38 $0.85
201194 2017-12-19 $37.77 Priority Mail 2-Day Flat Rate Envelope 3 1.17 lbs $6.80 $6.25 $0.55
201197 2017-12-19 $58.67 First-Class Package International Service 1 1.50 lbs $22.23 $21.38 $0.85
201198 2017-12-19 $52.99 Priority Mail 2-Day Small Flat Rate Box 1 1.65 lbs $7.30 $6.25 $1.05
201199 2017-12-19 $39.09 Priority Mail 2-Day Small Flat Rate Box 1 1.50 lbs $7.30 $6.25 $1.05
201201 2017-12-19 $39.09 Priority Mail 2-Day Small Flat Rate Box 1 1.50 lbs $7.30 $6.25 $1.05
201202 2017-12-19 $11.64 First-Class Package Service 2 0.12 lbs $3.66 $2.61 $1.05
201203 2017-12-19 $14.41 First-Class Package Service 1 0.37 lbs $3.82 $2.77 $1.05
201204 2017-12-19 $21.50 First-Class Mail Large Envelope 1 0.45 lbs $4.01 $3.32 $0.69
201205 2017-12-20 $56.07 First-Class Package International Service 1 1.55 lbs $15.58 $14.73 $0.85
201206 2017-12-20 $8.79 Priority Mail 2-Day Flat Rate Envelope 1 0.01 lbs $6.80 $5.75 $1.05
201208 2017-12-20 $44.85 First-Class Package Service 2 0.75 lbs $4.87 $4.16 $0.71
201210 2017-12-20 $47.79 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $7.30 $6.25 $1.05
201212 2017-12-20 $41.09 Priority Mail 2-Day Small Flat Rate Box 1 1.50 lbs $7.30 $6.25 $1.05
201213 2017-12-20 $25.89 First-Class Package International Service 2 0.36 lbs $13.91 $21.61 $-7.70
201214 2017-12-21 $25.24 First-Class Package Service 2 0.10 lbs $3.66 $2.61 $1.05
201215 2017-12-21 $36.14 First-Class Package International Service 4 0.45 lbs $15.58 $14.73 $0.85
201216 2017-12-21 $44.02 Priority Mail 2-Day 2 1.40 lbs $10.84 $9.69 $1.15
201218 2017-12-21 $41.09 Priority Mail 2-Day Small Flat Rate Box 1 1.50 lbs $7.30 $6.25 $1.05
201219 2017-12-21 $67.49 First-Class Package International Service 1 2.20 lbs $32.68 $31.83 $0.85
201220 2017-12-22 $18.83 Priority Mail 3-Day 1 0.95 lbs $10.04 $8.91 $1.13
201222 2017-12-22 $42.33 Priority Mail 2-Day Padded Flat Rate Envelope 2 1.40 lbs $7.35 $6.25 $1.10
201226 2017-12-22 $16.27 Priority Mail 2-Day Small Flat Rate Box 3 0.87 lbs $7.30 $6.25 $1.05
201227 2017-12-22 $29.66 First-Class Package International Service 2 0.10 lbs $13.68 $12.83 $0.85
201229 2017-12-22 $52.44 Priority Mail 2-Day 4 1.14 lbs $7.68 $6.63 $1.05
201230 2017-12-22 $47.28 Priority Mail 3-Day Small Flat Rate Box 2 0.80 lbs $7.30 $6.25 $1.05
201231 2017-12-23 $466.51 Priority Mail International 54 16.46 lbs $141.78 $89.44 $52.34
201233 2017-12-23 $10.42 First-Class Package Service 4 0.12 lbs $3.66 $2.61 $1.05
201234 2017-12-23 $92.66 Priority Mail 2-Day Medium Flat Rate Box 4 2.35 lbs $13.40 $9.99 $3.41
201236 2017-12-23 $20.27 First-Class Package Service 4 0.42 lbs $4.51 $3.74 $0.77
201237 2017-12-23 $20.30 First-Class Package Service 2 0.33 lbs $3.82 $2.77 $1.05
201239 2017-12-23 $41.74 Priority Mail 2-Day Flat Rate Envelope 6 1.80 lbs $6.80 $6.25 $0.55
201240 2017-12-23 $41.02 Priority Mail 2-Day 3 1.47 lbs $10.04 $6.25 $3.79
201241 2017-12-23 $143.16 First-Class Package International Service 8 3.09 lbs $47.88 $47.03 $0.85
201242 2017-12-23 $24.21 First-Class Mail Large Envelope 1 0.35 lbs $4.22 $2.77 $1.45
201243 2017-12-23 $137.13 Priority Mail 2-Day 7 3.78 lbs $11.80 $8.15 $3.65
201244 2017-12-24 $6.55 First-Class Package Service 1 0.03 lbs $3.66 $2.61 $1.05
201246 2017-12-25 $26.00 First-Class Mail Large Envelope 1 0.45 lbs $4.01 $3.32 $0.69
201247 2017-12-25 $13.15 First-Class Package Service 1 0.05 lbs $3.66 $2.61 $1.05
201248 2017-12-25 $41.09 Priority Mail 3-Day Small Flat Rate Box 1 1.50 lbs $7.30 $6.25 $1.05
201250 2017-12-25 $47.31 Priority Mail 3-Day 19 0.60 lbs $9.00 $7.91 $1.09
201251 2017-12-25 $31.98 Priority Mail 1-Day 1 0.95 lbs $7.37 $6.52 $0.85
201252 2017-12-26 $60.09 Priority Mail 2-Day Flat Rate Envelope 14 0.94 lbs $6.80 $6.25 $0.55
201254 2017-12-26 $25.09 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $6.80 $6.30 $0.50
201255 2017-12-26 $103.39 Priority Mail 2-Day Medium Flat Rate Box 1 9.10 lbs $13.40 $8.15 $5.25
201257 2017-12-26 $7.64 First-Class Package Service 2 0.06 lbs $3.66 $2.61 $1.05
201259 2017-12-26 $35.79 Priority Mail 3-Day Flat Rate Envelope 1 1.00 lbs $6.80 $6.25 $0.55
201261 2017-12-26 $31.79 Priority Mail 3-Day 1 0.95 lbs $9.00 $7.91 $1.09
201262 2017-12-26 $3.82 First-Class Package Service 1 0.30 lbs $3.82 $2.77 $1.05
201263 2017-12-26 $55.88 Priority Mail 3-Day 12 1.59 lbs $9.00 $8.15 $0.85
201264 2017-12-27 $85.66 First-Class Package International Service 2 3.45 lbs $47.88 $47.03 $0.85
201265 2017-12-27 $62.72 First-Class Package International Service 1 1.45 lbs $22.23 $21.38 $0.85
201266 2017-12-27 $24.00 First-Class Mail Large Envelope 1 0.35 lbs $4.01 $2.77 $1.24
201267 2017-12-27 $110.18 Priority Mail 2-Day 3 6.00 lbs $17.21 $14.68 $2.53
201269 2017-12-27 $7.65 First-Class Package Service 1 0.05 lbs $3.66 $2.61 $1.05
201288 2017-12-27 $59.07 Priority Mail 2-Day Padded Flat Rate Envelope 1 0.60 lbs $7.35 $6.52 $0.83
201289 2017-12-27 $20.91 First-Class Package Service 2 0.65 lbs $5.01 $3.88 $1.13
201291 2017-12-27 $94.12 Priority Mail 2-Day 4 4.18 lbs $14.49 $8.15 $6.34
201293 2017-12-27 $55.47 Priority Mail 2-Day 3 1.50 lbs $9.00 $7.91 $1.09
201295 2017-12-27 $12.97 First-Class Package Service 4 0.12 lbs $5.01 $8.04 $-3.03
201297 2017-12-28 $168.81 Priority Mail International 9 3.73 lbs $56.26 $52.01 $4.25
201298 2017-12-28 $29.60 First-Class Package International Service 8 0.24 lbs $13.68 $12.83 $0.85
201301 2017-12-28 $25.65 Priority Mail 3-Day 2 1.80 lbs $12.66 $8.91 $3.75
201302 2017-12-28 $28.97 Priority Mail 3-Day 3 1.52 lbs $9.00 $7.91 $1.09
201303 2017-12-28 $9.01 First-Class Package Service 1 0.15 lbs $3.82 $2.61 $1.21
201304 2017-12-28 $48.56 Priority Mail 2-Day Flat Rate Envelope 4 1.50 lbs $6.80 $6.30 $0.50
201305 2017-12-28 $25.91 Priority Mail 3-Day 4 1.85 lbs $10.35 $8.15 $2.20
201307 2017-12-29 $12.94 First-Class Package Service 1 2.30 lbs $5.15 $4.16 $0.99
201308 2017-12-29 $6.58 First-Class Mail Large Envelope 1 0.29 lbs $3.59 $2.77 $0.82
201314 2017-12-29 $10.98 First-Class Mail Large Envelope 3 0.53 lbs $4.01 $3.74 $0.27
201315 2017-12-29 $69.65 Standard 1 1.60 lbs $30.66 $24.33 $6.33
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56