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
206308 2019-03-30 $30.64 Priority Mail 3-Day 11 1.04 lbs $9.35 $8.50 $0.85
206311 2019-03-30 $34.70 Priority Mail 2-Day Small Flat Rate Box 1 1.15 lbs $8.35 $7.50 $0.85
206312 2019-03-30 $9.02 First-Class Package Service 2 0.34 lbs $5.04 $4.19 $0.85
206313 2019-03-30 $14.43 First-Class Package Service 8 0.09 lbs $4.01 $2.96 $1.05
206314 2019-03-30 $7.79 First-Class Package Service 2 0.07 lbs $3.81 $3.28 $0.53
206319 2019-03-31 $40.34 Priority Mail 3-Day 1 1.20 lbs $10.55 $7.50 $3.05
206321 2019-03-31 $68.87 Priority Mail 2-Day 4 1.77 lbs $10.11 $9.26 $0.85
206324 2019-03-31 $28.17 First-Class Package Service 10 0.44 lbs $4.27 $5.02 $-0.75
206325 2019-03-31 $48.50 Priority Mail 2-Day 1 1.30 lbs $11.71 $10.86 $0.85
206326 2019-03-31 $19.71 First-Class Package Service 3 0.15 lbs $4.14 $3.63 $0.51
206330 2019-03-31 $13.90 First-Class Package Service 1 0.40 lbs $4.41 $4.06 $0.35
206332 2019-04-01 $60.43 Priority Mail 2-Day 2 1.70 lbs $12.65 $11.80 $0.85
206335 2019-04-01 $14.94 Priority Mail 2-Day 3 0.42 lbs $8.67 $7.82 $0.85
206337 2019-04-02 $63.69 Priority Mail 2-Day 4 1.05 lbs $8.73 $7.88 $0.85
206340 2019-04-02 $36.34 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $8.35 $7.50 $0.85
206342 2019-04-02 $22.62 First-Class Package Service 1 0.30 lbs $4.33 $3.28 $1.05
206343 2019-04-02 $7.59 First-Class Package Service 2 0.07 lbs $3.81 $2.76 $1.05
206346 2019-04-03 $24.72 First-Class Package Service 11 0.18 lbs $6.43 $3.49 $2.94
206347 2019-04-03 $36.34 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.35 $7.50 $0.85
206348 2019-04-03 $33.32 First-Class Package Service 1 0.40 lbs $4.33 $3.96 $0.37
206349 2019-04-03 $11.18 First-Class Package Service 3 0.59 lbs $4.81 $3.96 $0.85
206350 2019-04-03 $19.59 First-Class Package Service 6 0.22 lbs $4.25 $2.68 $1.57
206351 2019-04-04 $117.54 First-Class Package International Service 4 2.52 lbs $46.58 $36.58 $10.00
206352 2019-04-04 $108.44 First-Class Package International Service 4 1.37 lbs $46.58 $36.58 $10.00
206354 2019-04-04 $58.63 Priority Mail 2-Day 10 0.88 lbs $8.73 $7.88 $0.85
206355 2019-04-04 $6.88 First-Class Package Service 1 0.03 lbs $3.89 $2.84 $1.05
206357 2019-04-04 $27.35 First-Class Package Service 2 0.74 lbs $6.17 $5.12 $1.05
206358 2019-04-04 $49.28 Priority Mail 2-Day 10 3.25 lbs $10.88 $10.03 $0.85
206359 2019-04-05 $7.87 First-Class Package Service 2 0.20 lbs $3.89 $2.84 $1.05
206360 2019-04-05 $116.96 Priority Mail 2-Day Large Flat Rate Box 29 4.70 lbs $18.45 $17.60 $0.85
206362 2019-04-05 $82.18 Priority Mail 2-Day Flat Rate Envelope 2 2.72 lbs $7.80 $7.50 $0.30
206363 2019-04-05 $32.99 Priority Mail 2-Day 6 2.40 lbs $12.65 $11.80 $0.85
206364 2019-04-05 $38.16 Priority Mail 2-Day 1 1.15 lbs $8.67 $7.50 $1.17
206365 2019-04-05 $36.34 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.35 $7.50 $0.85
206366 2019-04-05 $90.03 First-Class Package International Service 7 0.95 lbs $30.80 $35.63 $-4.83
206367 2019-04-05 $35.33 Priority Mail 2-Day 5 3.00 lbs $10.88 $8.76 $2.12
206368 2019-04-05 $128.42 Priority Mail 2-Day 16 4.54 lbs $21.68 $17.60 $4.08
206370 2019-04-05 $54.09 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.65 lbs $8.40 $7.50 $0.90
206371 2019-04-06 $24.32 First-Class Package Service 1 0.40 lbs $4.33 $3.96 $0.37
206372 2019-04-06 $22.97 First-Class Package Service 1 0.30 lbs $4.68 $3.63 $1.05
206374 2019-04-06 $14.39 First-Class Package Service 4 0.76 lbs $6.43 $2.96 $3.47
206376 2019-04-06 $17.74 First-Class Package Service 1 0.05 lbs $3.75 $2.70 $1.05
206377 2019-04-06 $56.24 Priority Mail 2-Day Medium Flat Rate Box 6 2.30 lbs $13.80 $7.99 $5.81
206380 2019-04-06 $52.18 Priority Mail 2-Day Flat Rate Envelope 2 1.77 lbs $7.80 $7.55 $0.25
206381 2019-04-06 $13.88 First-Class Package Service 1 0.07 lbs $3.89 $2.84 $1.05
206382 2019-04-06 $10.99 First-Class Package Service 2 0.08 lbs $4.01 $2.96 $1.05
206383 2019-04-07 $45.83 Priority Mail 2-Day 2 1.70 lbs $10.11 $8.76 $1.35
206385 2019-04-07 $16.96 First-Class Package Service 5 0.41 lbs $4.41 $4.06 $0.35
206387 2019-04-07 $38.94 Priority Mail 2-Day 2 7.95 lbs $20.36 $21.31 $-0.95
206388 2019-04-07 $14.35 First-Class Package Service 2 0.80 lbs $5.97 $5.12 $0.85
206389 2019-04-07 $92.93 Priority Mail 2-Day 12 1.77 lbs $12.65 $11.80 $0.85
206390 2019-04-07 $180.80 Priority Mail International 11 3.50 lbs $63.01 $58.76 $4.25
206392 2019-04-07 $6.80 First-Class Package Service 1 0.03 lbs $3.81 $2.76 $1.05
206393 2019-04-07 $8.79 First-Class Package Service 2 0.34 lbs $4.81 $3.96 $0.85
206395 2019-04-08 $5.88 First-Class Package Service 1 0.01 lbs $3.89 $2.84 $1.05
206396 2019-04-08 $23.99 First-Class Package Service 2 0.10 lbs $3.81 $2.76 $1.05
206397 2019-04-08 $107.43 Priority Mail 3-Day 5 4.50 lbs $11.18 $8.76 $2.42
206399 2019-04-08 $43.72 Priority Mail 3-Day Flat Rate Envelope 2 1.80 lbs $7.80 $9.70 $-1.90
206400 2019-03-25 $167.80 Priority Mail 2-Day 20 60.00 lbs $10.00 $13.45 $-3.45
206403 2019-04-08 $28.14 Priority Mail 3-Day 9 1.45 lbs $8.73 $8.34 $0.39
206407 2019-04-09 $8.70 First-Class Package Service 1 0.15 lbs $3.81 $2.76 $1.05
206408 2019-03-01 $20.09 Priority Mail 2-Day 2 0.06 lbs $2.11 $7.50 $-5.39
206411 2019-04-09 $6.00 First-Class Package Service 1 0.10 lbs $4.01 $2.96 $1.05
206412 2019-04-09 $25.92 First-Class Package Service 9 0.47 lbs $5.01 $3.96 $1.05
206415 2019-04-10 $10.23 First-Class Package Service 2 0.05 lbs $3.75 $2.70 $1.05
206417 2019-04-10 $6.13 First-Class Package Service 1 0.10 lbs $4.14 $3.09 $1.05
206423 2019-04-10 $5.99 First-Class Package Service 2 0.02 lbs $4.01 $2.96 $1.05
206424 2019-04-10 $46.78 Priority Mail 2-Day Flat Rate Envelope 2 1.75 lbs $7.80 $7.55 $0.25
206426 2019-04-11 $21.70 First-Class Package Service 1 0.60 lbs $5.04 $4.19 $0.85
206433 2019-04-11 $38.64 Priority Mail 2-Day 1 2.40 lbs $12.65 $13.75 $-1.10
206438 2019-04-11 $77.75 First-Class Package International Service 3 1.14 lbs $31.28 $23.28 $8.00
206439 2019-04-11 $5.97 First-Class Package Service 4 0.04 lbs $4.01 $2.96 $1.05
206440 2019-04-11 $24.40 First-Class Package Service 1 0.40 lbs $4.41 $4.06 $0.35
206441 2019-04-12 $71.01 Priority Mail 2-Day 7 0.98 lbs $11.08 $10.23 $0.85
206442 2019-04-12 $9.74 First-Class Package Service 1 0.15 lbs $3.75 $3.22 $0.53
206443 2019-04-12 $6.78 First-Class Package Service 3 0.03 lbs $3.81 $2.76 $1.05
206445 2019-04-12 $20.22 First-Class Package Service 1 0.49 lbs $6.23 $2.96 $3.27
206449 2019-04-12 $97.23 Priority Mail 2-Day 8 6.10 lbs $10.31 $9.46 $0.85
206451 2019-04-12 $6.23 First-Class Package Service 2 0.11 lbs $3.75 $3.22 $0.53
206452 2019-04-13 $7.87 First-Class Package Service 2 0.10 lbs $3.89 $3.36 $0.53
206453 2019-04-13 $94.86 Direct Link International 24 4.44 lbs $50.14 $46.19 $3.95
206454 2019-04-13 $158.30 Direct Link International 20 9.38 lbs $50.15 $62.99 $-12.84
206455 2019-04-14 $67.41 Priority Mail 2-Day 5 1.29 lbs $11.08 $10.23 $0.85
206456 2019-04-14 $44.36 Priority Mail 2-Day 8 2.58 lbs $16.44 $13.10 $3.34
206460 2019-04-14 $24.32 First-Class Package Service 1 0.40 lbs $4.33 $3.96 $0.37
206462 2019-04-14 $58.52 Priority Mail 2-Day Flat Rate Envelope 4 1.15 lbs $7.80 $7.50 $0.30
206464 2019-04-14 $25.38 First-Class Package Service 1 0.65 lbs $6.09 $5.24 $0.85
206466 2019-04-15 $29.77 First-Class Package International Service 1 0.30 lbs $17.98 $9.98 $8.00
206467 2019-04-15 $25.52 Direct Link International 2 0.02 lbs $21.54 $14.75 $6.79
206468 2019-04-15 $67.89 Priority Mail 2-Day 2 2.50 lbs $10.11 $8.76 $1.35
206470 2019-04-15 $12.59 First-Class Package Service 2 0.20 lbs $3.89 $3.36 $0.53
206471 2019-04-15 $48.84 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.35 $7.50 $0.85
206473 2019-04-16 $20.28 Priority Mail 2-Day Flat Rate Envelope 2 0.21 lbs $7.80 $7.55 $0.25
206474 2019-04-16 $34.70 Priority Mail 2-Day Medium Flat Rate Box 10 1.90 lbs $13.80 $10.23 $3.57
206475 2019-04-17 $199.25 Priority Mail 2-Day 2 14.40 lbs $19.27 $19.42 $-0.15
206477 2019-04-17 $79.48 Priority Mail 2-Day 20 5.40 lbs $21.68 $20.83 $0.85
206478 2019-04-17 $36.49 Priority Mail 2-Day 3 1.49 lbs $10.11 $9.26 $0.85
206479 2019-04-17 $28.09 Priority Mail 2-Day 10 2.00 lbs $9.19 $8.34 $0.85
206480 2019-04-17 $37.34 Priority Mail 3-Day Small Flat Rate Box 1 1.10 lbs $8.35 $7.50 $0.85
206483 2019-04-17 $54.04 Priority Mail 2-Day Small Flat Rate Box 1 1.65 lbs $8.35 $7.50 $0.85
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56