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
201453 2018-01-09 $62.72 First-Class Package International Service 1 1.50 lbs $22.23 $21.38 $0.85
201454 2018-01-09 $62.72 First-Class Package International Service 1 1.50 lbs $22.23 $21.38 $0.85
201455 2018-01-09 $68.17 First-Class Package International Service 1 2.20 lbs $32.68 $31.83 $0.85
201456 2018-01-09 $194.96 Priority Mail International 1 12.90 lbs $96.97 $89.97 $7.00
201457 2018-01-09 $62.72 First-Class Package International Service 1 1.50 lbs $22.23 $21.38 $0.85
201458 2018-01-09 $62.72 First-Class Package International Service 1 1.50 lbs $22.23 $22.33 $-0.10
201459 2018-01-09 $15.47 First-Class Mail Large Envelope 2 0.16 lbs $3.59 $2.61 $0.98
201461 2018-01-09 $51.72 First-Class Package International Service 1 1.20 lbs $22.23 $21.38 $0.85
201462 2018-01-09 $30.24 Priority Mail 3-Day 2 2.20 lbs $12.66 $9.19 $3.47
201463 2018-01-09 $51.72 First-Class Package International Service 1 1.20 lbs $22.23 $21.38 $0.85
201464 2018-01-09 $16.66 First-Class Package Service 1 0.45 lbs $4.17 $3.32 $0.85
201465 2018-01-09 $23.33 First-Class Package Service 2 0.51 lbs $4.45 $3.74 $0.71
201468 2018-01-10 $26.80 Priority Mail 2-Day 4 1.01 lbs $10.84 $9.69 $1.15
201470 2018-01-10 $108.03 Priority Mail 3-Day Medium Flat Rate Box 17 4.68 lbs $13.40 $12.05 $1.35
201472 2018-01-10 $68.17 First-Class Package International Service 1 2.20 lbs $32.68 $31.83 $0.85
201473 2018-01-10 $57.34 First-Class Package International Service 1 2.20 lbs $32.68 $31.83 $0.85
201475 2018-01-10 $11.60 First-Class Package Service 2 0.38 lbs $3.62 $2.77 $0.85
201476 2018-01-10 $17.80 First-Class Package Service 2 0.13 lbs $3.82 $2.61 $1.21
201480 2018-01-11 $258.25 Priority Mail International 27 6.14 lbs $72.56 $83.74 $-11.18
201482 2018-01-11 $67.57 First-Class Package International Service 1 2.20 lbs $32.68 $33.01 $-0.33
201484 2018-01-11 $36.05 Priority Mail 3-Day 7 2.11 lbs $13.62 $9.99 $3.63
201485 2018-01-11 $7.15 First-Class Package Service 1 0.05 lbs $3.66 $2.61 $1.05
201486 2018-01-11 $45.99 Priority Mail 2-Day 1 1.30 lbs $9.00 $7.91 $1.09
201488 2018-01-11 $72.98 Priority Mail 2-Day Medium Flat Rate Box 2 2.65 lbs $13.40 $9.99 $3.41
201490 2018-01-12 $10.13 First-Class Package Service 1 0.10 lbs $3.66 $2.77 $0.89
201493 2018-01-12 $815.32 Ground 44 50.80 lbs $40.48 $38.52 $1.96
201498 2018-01-12 $18.81 First-Class Package Service 1 0.23 lbs $3.82 $2.77 $1.05
201499 2018-01-12 $50.24 Priority Mail 2-Day Flat Rate Envelope 6 0.49 lbs $6.80 $6.25 $0.55
201500 2018-01-12 $62.72 First-Class Package International Service 1 1.55 lbs $22.23 $21.38 $0.85
201501 2018-01-12 $43.46 Priority Mail 3-Day 2 1.50 lbs $7.68 $6.63 $1.05
201502 2018-01-13 $47.90 First-Class Package International Service 4 0.33 lbs $13.44 $21.14 $-7.70
201504 2018-01-13 $68.12 First-Class Package International Service 11 1.29 lbs $22.23 $21.38 $0.85
201505 2018-01-13 $43.68 First-Class Package International Service 5 0.76 lbs $22.23 $21.38 $0.85
201506 2018-01-13 $30.87 Priority Mail 3-Day 9 1.76 lbs $12.66 $8.91 $3.75
201507 2018-01-13 $21.80 First-Class Mail Large Envelope 1 0.35 lbs $4.01 $3.32 $0.69
201508 2018-01-13 $48.72 First-Class Package International Service 1 1.15 lbs $19.73 $14.73 $5.00
201510 2018-01-13 $28.92 Priority Mail 3-Day Flat Rate Envelope 3 1.77 lbs $10.95 $6.25 $4.70
201512 2018-01-14 $135.74 Priority Mail 2-Day 8 3.59 lbs $20.68 $13.36 $7.32
201514 2018-01-14 $73.68 Priority Mail 3-Day 3 2.10 lbs $16.81 $11.46 $5.35
201515 2018-01-14 $25.51 First-Class Package Service 3 0.46 lbs $8.74 $3.88 $4.86
201517 2018-01-14 $56.86 Priority Mail 2-Day 19 3.61 lbs $15.95 $10.62 $5.33
201518 2018-01-15 $57.14 Priority Mail 2-Day Small Flat Rate Box 1 1.65 lbs $11.45 $6.25 $5.20
201519 2018-01-15 $66.87 First-Class Package International Service 1 1.45 lbs $26.38 $21.38 $5.00
201520 2018-01-15 $66.87 First-Class Package International Service 1 1.55 lbs $26.38 $21.38 $5.00
201521 2018-01-15 $45.24 Priority Mail 3-Day Small Flat Rate Box 1 1.50 lbs $11.45 $6.25 $5.20
201522 2018-01-15 $40.29 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.30 lbs $11.50 $6.25 $5.25
201524 2018-01-15 $5.65 First-Class Package Service 1 0.05 lbs $3.66 $2.61 $1.05
201525 2018-01-15 $165.82 Priority Mail 2-Day 4 5.85 lbs $22.26 $18.89 $3.37
201526 2018-01-15 $6.65 First-Class Package Service 1 0.05 lbs $3.66 $2.61 $1.05
201529 2018-01-16 $23.32 First-Class Package International Service 1 0.38 lbs $17.83 $21.38 $-3.55
201531 2018-01-16 $17.37 First-Class Package Service 2 0.40 lbs $4.59 $3.88 $0.71
201533 2018-01-16 $71.54 Priority Mail 2-Day 10 1.71 lbs $10.84 $9.69 $1.15
201535 2018-01-16 $25.99 Priority Mail 3-Day Flat Rate Envelope 1 1.00 lbs $6.80 $6.25 $0.55
201537 2018-01-16 $15.75 Priority Mail 3-Day Flat Rate Envelope 5 0.56 lbs $6.80 $6.25 $0.55
201538 2018-01-16 $6.11 First-Class Package Service 5 0.05 lbs $3.66 $2.61 $1.05
201540 2018-01-17 $68.63 Priority Mail 3-Day 2 2.00 lbs $10.35 $8.15 $2.20
201544 2018-01-17 $835.74 Ground 8 73.95 lbs $84.12 $82.47 $1.65
201545 2018-01-17 $11.57 First-Class Package Service 1 0.35 lbs $3.62 $2.77 $0.85
201547 2018-01-17 $28.21 First-Class Package International Service 2 0.14 lbs $17.83 $12.83 $5.00
201548 2018-01-17 $22.13 Priority Mail 2-Day Flat Rate Envelope 7 0.82 lbs $6.80 $6.25 $0.55
201549 2018-01-17 $113.76 Ground 10 4.70 lbs $28.16 $20.05 $8.11
201550 2018-01-17 $15.05 First-Class Package Service 2 0.60 lbs $5.07 $3.88 $1.19
201551 2018-01-17 $105.99 Worldwide Expedited 1 0.25 lbs $94.20 $87.26 $6.94
201552 2018-01-18 $110.29 Priority Mail International 1 3.95 lbs $59.07 $58.19 $0.88
201553 2018-01-18 $77.69 First-Class Package International Service 5 0.80 lbs $26.14 $21.14 $5.00
201554 2018-01-18 $72.72 Priority Mail 2-Day Flat Rate Envelope 8 1.17 lbs $6.80 $6.25 $0.55
201557 2018-01-19 $15.40 First-Class Mail Large Envelope 1 0.30 lbs $3.61 $2.77 $0.84
201558 2018-01-19 $37.17 Priority Mail 2-Day 6 2.70 lbs $15.03 $13.36 $1.67
201559 2018-01-19 $52.83 Priority Mail 2-Day Medium Flat Rate Box 2 1.75 lbs $13.85 $9.99 $3.86
201560 2018-01-19 $12.09 First-Class Package Service 1 0.20 lbs $4.10 $2.77 $1.33
201561 2018-01-19 $15.37 Priority Mail 3-Day Flat Rate Envelope 3 1.02 lbs $7.40 $6.25 $1.15
201564 2018-01-19 $53.09 Priority Mail 3-Day 10 2.27 lbs $11.19 $8.15 $3.04
201566 2018-01-19 $5.20 First-Class Package Service 1 0.05 lbs $3.71 $2.61 $1.10
201568 2018-01-20 $9.70 First-Class Package Service 1 0.04 lbs $3.71 $2.66 $1.05
201569 2018-01-21 $234.06 Standard 2 13.90 lbs $59.98 $51.73 $8.25
201571 2018-01-21 $17.87 Priority Mail 3-Day Small Flat Rate Box 3 0.97 lbs $7.90 $6.85 $1.05
201574 2018-01-21 $206.55 Priority Mail 2-Day 1 14.05 lbs $36.56 $33.35 $3.21
201575 2018-01-22 $24.02 First-Class Mail Large Envelope 1 0.40 lbs $4.03 $3.18 $0.85
201576 2018-01-22 $35.89 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $7.90 $6.85 $1.05
201577 2018-01-22 $36.89 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $7.40 $6.85 $0.55
201578 2018-01-22 $32.17 Priority Mail 2-Day Flat Rate Envelope 3 0.28 lbs $7.40 $6.85 $0.55
201579 2018-01-22 $188.51 Priority Mail 2-Day 19 6.26 lbs $22.90 $17.10 $5.80
201581 2018-01-22 $7.20 First-Class Package Service 1 0.04 lbs $3.71 $2.66 $1.05
201582 2018-01-22 $8.50 First-Class Mail Large Envelope 1 0.45 lbs $3.61 $3.50 $0.11
201584 2018-01-22 $16.77 First-Class Package Service 2 0.80 lbs $5.79 $4.94 $0.85
201586 2018-01-22 $32.14 Priority Mail 3-Day Medium Flat Rate Box 1 0.85 lbs $13.85 $9.98 $3.87
201587 2018-01-22 $69.77 Priority Mail 2-Day Flat Rate Envelope 3 1.87 lbs $7.40 $6.90 $0.50
201592 2018-01-23 $11.67 First-Class Package Service 4 0.12 lbs $3.71 $3.18 $0.53
201593 2018-01-23 $52.53 Priority Mail 2-Day Padded Flat Rate Envelope 2 1.50 lbs $7.95 $6.85 $1.10
201594 2018-01-23 $41.69 Priority Mail 3-Day Small Flat Rate Box 1 1.50 lbs $7.90 $6.85 $1.05
201599 2018-01-24 $56.61 First-Class Package International Service 2 0.65 lbs $27.33 $22.33 $5.00
201601 2018-01-24 $131.82 Priority Mail International 1 5.65 lbs $64.53 $63.79 $0.74
201603 2018-01-24 $62.68 Priority Mail 2-Day Small Flat Rate Box 2 1.75 lbs $7.90 $6.85 $1.05
201604 2018-01-24 $10.70 First-Class Package Service 1 0.19 lbs $3.71 $2.66 $1.05
201605 2018-01-24 $21.01 Priority Mail 3-Day 4 1.30 lbs $8.25 $7.18 $1.07
201608 2018-01-25 $10.70 First-Class Package Service 1 0.19 lbs $3.71 $2.66 $1.05
201609 2018-01-25 $51.63 Priority Mail 1-Day Flat Rate Envelope 2 1.45 lbs $7.40 $6.85 $0.55
201610 2018-01-25 $195.12 Priority Mail 2-Day 1 14.05 lbs $14.00 $13.19 $0.81
201612 2018-01-25 $26.89 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $7.40 $6.90 $0.50
201614 2018-01-25 $61.54 Priority Mail 3-Day Small Flat Rate Box 2 2.00 lbs $7.90 $6.85 $1.05
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56