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
220497 2021-01-17 $15.91 USPSFirstClass 3 0.15 lbs $4.24 $3.52 $0.72
220499 2021-01-17 $16.42 First-Class Package Service 5 0.21 lbs $3.97 $3.05 $0.92
220500 2021-01-17 $150.41 Ground Home Delivery 2 7.75 lbs $36.43 $27.31 $9.12
220502 2021-01-17 $25.48 First-Class Package Service 22 0.24 lbs $3.70 $2.78 $0.92
220504 2021-01-17 $21.05 First-Class Package Service 2 0.40 lbs $4.91 $3.67 $1.24
220505 2021-01-17 $15.63 First-Class Package Service 1 0.30 lbs $3.84 $3.39 $0.45
220506 2021-01-17 $18.43 First-Class Package Service 2 0.25 lbs $3.76 $3.57 $0.19
220507 2021-01-17 $14.04 USPSFirstClass 1 0.31 lbs $5.05 $3.21 $1.84
220511 2021-01-17 $7.49 First-Class Package Service 1 0.10 lbs $3.50 $3.05 $0.45
220513 2021-01-17 $5.09 First-Class Mail Stamped Letter 1 0.03 lbs $3.10 $2.84 $0.26
220514 2021-01-17 $23.09 USPSFirstClass 1 0.15 lbs $5.10 $3.18 $1.92
220515 2021-01-17 $8.93 First-Class Mail Stamped Letter 2 0.02 lbs $2.95 $2.84 $0.11
220516 2021-01-17 $85.58 Priority Mail 2-Day Padded Flat Rate Envelope 2 2.80 lbs $8.60 $7.75 $0.85
220518 2021-01-17 $21.61 First-Class Package Service - Retail 4 0.18 lbs $5.65 $2.93 $2.72
220519 2021-01-17 $12.08 USPSFirstClass 1 0.06 lbs $4.29 $2.78 $1.51
220520 2021-01-17 $13.49 USPSFirstClass 1 0.05 lbs $4.50 $3.05 $1.45
220522 2021-01-17 $51.49 Priority Mail 3-Day Small Flat Rate Box 1 1.50 lbs $8.50 $7.90 $0.60
220523 2021-01-17 $51.49 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.50 $7.90 $0.60
220524 2021-01-17 $77.11 USPSPriority 1 1.19 lbs $14.05 $7.65 $6.40
220525 2021-01-17 $12.08 USPSFirstClass 1 0.06 lbs $4.29 $2.78 $1.51
220526 2021-01-17 $10.45 USPSFirstClass 1 0.06 lbs $4.35 $3.05 $1.30
220529 2021-01-17 $52.65 Ground 2 1.50 lbs $20.40 $15.76 $4.64
220530 2021-01-17 $16.06 First-Class Package Service 6 0.18 lbs $4.12 $3.18 $0.94
220532 2021-01-18 $5.98 USPSFirstClass 1 0.01 lbs $4.09 $2.93 $1.16
220534 2021-01-17 $47.78 Priority Mail 3-Day Flat Rate Envelope 2 1.50 lbs $8.00 $7.90 $0.10
220536 2021-01-17 $51.49 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.50 $7.90 $0.60
220537 2021-01-17 $28.71 Priority Mail 3-Day 1 3.10 lbs $9.92 $8.00 $1.92
220538 2021-01-17 $17.74 First-Class Package Service 5 0.62 lbs $5.79 $5.54 $0.25
220539 2021-01-17 $27.03 First-Class Package Service 2 0.74 lbs $5.85 $5.66 $0.19
220542 2021-01-17 $45.31 Priority Mail 2-Day Small Flat Rate Box 19 0.91 lbs $8.50 $7.65 $0.85
220544 2021-01-17 $25.28 First-Class Package Service 1 0.65 lbs $5.79 $5.81 $-0.02
220545 2021-01-17 $81.58 Priority Mail 3-Day Padded Flat Rate Envelope 2 4.88 lbs $8.60 $7.75 $0.85
220547 2021-01-18 $16.18 USPSFirstClass 1 0.10 lbs $4.39 $2.74 $1.65
220548 2021-01-18 $14.91 USPSFirstClass 1 0.50 lbs $5.47 $5.70 $-0.23
220549 2021-01-18 $16.18 USPSFirstClass 1 0.10 lbs $4.39 $2.74 $1.65
220550 2021-01-17 $6.62 First-Class Package Service 1 0.01 lbs $3.63 $3.18 $0.45
220551 2021-01-18 $8.88 USPSFirstClass 1 0.47 lbs $5.09 $4.32 $0.77
220552 2021-01-18 $15.44 First-Class Package Service 1 0.40 lbs $4.45 $3.25 $1.20
220553 2021-01-18 $14.75 First-Class Package Service 2 0.25 lbs $3.97 $3.52 $0.45
220554 2021-01-18 $51.49 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.50 $7.90 $0.60
220556 2021-01-18 $8.44 First-Class Mail Stamped Letter 1 0.10 lbs $3.25 $3.18 $0.07
220557 2021-01-18 $18.95 Priority Mail 2-Day Flat Rate Envelope 5 0.08 lbs $8.00 $7.65 $0.35
220558 2021-01-18 $38.29 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $8.50 $7.65 $0.85
220560 2021-01-18 $30.67 Priority Mail 2-Day Flat Rate Envelope 13 0.35 lbs $8.00 $7.65 $0.35
220561 2021-01-18 $19.77 USPSFirstClass 2 0.12 lbs $4.19 $2.74 $1.45
220562 2021-01-18 $88.11 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.44 lbs $8.60 $7.65 $0.95
220564 2021-01-18 $29.36 Ground 2 0.31 lbs $13.02 $10.52 $2.50
220565 2021-01-18 $53.64 USPSFirstClass 1 0.50 lbs $7.13 $4.18 $2.95
220566 2021-01-18 $13.09 First-Class Mail Stamped Letter 1 0.07 lbs $3.10 $3.05 $0.05
220567 2021-01-18 $9.40 USPSFirstClass 1 0.10 lbs $4.21 $2.84 $1.37
220568 2021-01-18 $36.49 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.50 $7.65 $0.85
220569 2021-01-18 $10.87 First-Class Package Service - Retail 3 0.12 lbs $4.90 $3.05 $1.85
220571 2021-01-18 $17.16 USPSFirstClass 2 0.90 lbs $9.78 $5.70 $4.08
220572 2021-01-18 $8.09 USPSFirstClass 1 0.06 lbs $4.10 $2.78 $1.32
220576 2021-01-18 $10.95 Priority Mail 2-Day Flat Rate Envelope 5 0.05 lbs $8.00 $8.42 $-0.42
220577 2021-01-18 $12.37 First-Class Package Service 6 0.44 lbs $4.43 $2.93 $1.50
220579 2021-01-18 $8.42 First-Class Package Service 1 0.08 lbs $3.23 $2.78 $0.45
220581 2021-01-18 $6.44 First-Class Mail Stamped Letter 1 0.05 lbs $2.95 $3.18 $-0.23
220582 2021-01-18 $5.19 First-Class Package Service 1 0.10 lbs $0.00 $3.35 $-3.35
220587 2021-01-18 $29.35 First-Class Package Service 2 0.40 lbs $4.77 $4.32 $0.45
220590 2021-01-18 $12.37 First-Class Package Service 1 0.30 lbs $3.70 $3.25 $0.45
220591 2021-01-18 $5.40 First-Class Mail Stamped Letter 5 0.05 lbs $2.95 $2.93 $0.02
220592 2021-01-18 $16.68 First-Class Mail Stamped Letter 2 0.04 lbs $3.10 $3.05 $0.05
220593 2021-01-18 $22.91 First-Class Package Service 1 0.35 lbs $3.92 $4.68 $-0.76
220594 2021-01-18 $22.41 Priority Mail 2-Day 3 0.58 lbs $9.27 $8.42 $0.85
220595 2021-01-18 $8.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.10 $3.18 $-0.08
220596 2021-01-18 $23.47 Priority Mail 2-Day 4 1.65 lbs $9.61 $8.85 $0.76
220598 2021-01-19 $53.44 USPSFirstClass 1 0.50 lbs $6.93 $3.21 $3.72
220599 2021-01-19 $10.18 USPSFirstClass 1 0.05 lbs $4.29 $2.93 $1.36
220600 2021-01-18 $24.02 Priority Mail 2-Day 2 1.00 lbs $10.84 $9.99 $0.85
220602 2021-01-18 $35.56 Priority Mail 2-Day 5 0.44 lbs $9.61 $8.76 $0.85
220603 2021-01-18 $33.58 Priority Mail 2-Day 2 1.90 lbs $13.00 $12.15 $0.85
220604 2021-01-19 $21.68 Priority Mail 3-Day 1 0.95 lbs $11.39 $10.54 $0.85
220605 2021-01-19 $23.74 USPSFirstClass 4 0.83 lbs $13.78 $11.18 $2.60
220606 2021-01-19 $21.68 Priority Mail 2-Day 1 0.95 lbs $11.39 $10.54 $0.85
220607 2021-01-19 $51.49 Priority Mail 2-Day Small Flat Rate Box 1 1.50 lbs $8.50 $7.90 $0.60
220608 2021-01-19 $116.13 USPSPriority 1 1.19 lbs $18.53 $7.65 $10.88
220609 2021-01-19 $15.91 First-Class Package Service 1 0.30 lbs $4.12 $3.85 $0.27
220610 2021-01-19 $20.95 First-Class Package Service 2 0.20 lbs $3.97 $3.69 $0.28
220611 2021-01-19 $85.36 Priority Mail 2-Day 3 2.20 lbs $10.39 $9.64 $0.75
220612 2021-01-19 $54.19 Priority Mail 2-Day Small Flat Rate Box 1 1.65 lbs $8.50 $8.25 $0.25
220613 2021-01-19 $237.26 Priority Mail 3-Day 4 16.75 lbs $48.60 $35.97 $12.63
220615 2021-01-19 $9.47 USPSFirstClass 1 0.22 lbs $4.45 $3.18 $1.27
220617 2021-01-19 $15.44 First-Class Package Service 1 0.40 lbs $4.45 $3.51 $0.94
220618 2021-01-19 $6.09 First-Class Mail Stamped Letter 1 0.03 lbs $3.10 $3.06 $0.04
220619 2021-01-19 $9.33 USPSFirstClass 1 0.05 lbs $4.44 $3.18 $1.26
220620 2021-01-19 $45.64 First-Class Package Service 2 0.48 lbs $4.63 $4.38 $0.25
220621 2021-01-19 $10.99 Priority Mail 3-Day Flat Rate Envelope 1 0.03 lbs $8.00 $7.15 $0.85
220622 2021-01-19 $50.57 USPSFirstClass 10 2.50 lbs $21.67 $9.54 $12.13
220623 2021-01-19 $10.13 USPSFirstClass 1 0.05 lbs $4.24 $2.84 $1.40
220625 2021-01-19 $23.89 First-Class Package Service 37 0.37 lbs $3.76 $3.12 $0.64
220626 2021-01-19 $32.04 USPSFirstClass 4 1.60 lbs $16.88 $8.76 $8.12
220627 2021-01-19 $14.16 USPSFirstClass 1 0.05 lbs $4.67 $3.18 $1.49
220628 2021-01-19 $6.98 USPSFirstClass 1 0.10 lbs $4.09 $2.84 $1.25
220629 2021-01-19 $11.34 USPSFirstClass 1 0.06 lbs $4.35 $2.93 $1.42
220631 2021-01-19 $9.09 First-Class Mail Stamped Letter 1 0.03 lbs $3.10 $3.49 $-0.39
220632 2021-01-19 $53.20 Priority Mail 3-Day 4 1.48 lbs $10.84 $8.00 $2.84
220633 2021-01-19 $21.35 First-Class Mail Stamped Letter 5 0.16 lbs $3.40 $3.06 $0.34
220634 2021-01-19 $45.09 Priority Mail 2-Day Padded Flat Rate Envelope 1 2.44 lbs $8.60 $8.00 $0.60
220636 2021-01-19 $35.95 Priority Mail 2-Day 2 1.62 lbs $8.97 $4.00 $4.97
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56