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
209552 2020-01-25 $37.46 First-Class Package Service 5 0.66 lbs $5.51 $4.33 $1.18
209554 2020-01-25 $77.48 Priority Mail 3-Day Medium Flat Rate Box 8 1.91 lbs $14.45 $11.18 $3.27
209555 2020-01-25 $25.56 First-Class Package Service 1 0.60 lbs $4.78 $5.04 $-0.26
209556 2020-01-25 $6.82 First-Class Package Service 1 0.03 lbs $3.83 $2.78 $1.05
209558 2020-01-25 $5.85 First-Class Package Service 4 0.04 lbs $3.89 $2.84 $1.05
209560 2020-01-25 $8.58 First-Class Package Service 2 0.04 lbs $4.10 $3.05 $1.05
209563 2020-01-25 $30.52 First-Class Package Service 5 0.44 lbs $4.57 $5.54 $-0.97
209564 2020-01-25 $30.72 First-Class Package Service 2 0.20 lbs $3.98 $3.39 $0.59
209565 2020-01-26 $24.48 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $8.00 $7.75 $0.25
209566 2020-01-26 $23.33 First-Class Package Service 1 0.49 lbs $6.39 $5.54 $0.85
209567 2020-01-26 $4.87 First-Class Package Service 2 0.02 lbs $3.89 $2.84 $1.05
209568 2020-01-26 $5.88 First-Class Package Service 1 0.19 lbs $3.89 $2.84 $1.05
209569 2020-01-26 $15.74 Priority Mail 2-Day Flat Rate Envelope 1 0.06 lbs $8.00 $7.65 $0.35
209570 2020-01-26 $15.29 First-Class Package Service 1 0.30 lbs $4.30 $4.00 $0.30
209572 2020-01-26 $10.08 First-Class Package Service 2 0.08 lbs $4.10 $3.52 $0.58
209573 2020-01-26 $28.86 Priority Mail 2-Day 3 0.72 lbs $11.39 $10.54 $0.85
209574 2020-01-26 $9.09 First-Class Package Service 1 0.10 lbs $4.10 $3.05 $1.05
209578 2020-01-26 $10.97 First-Class Package Service 1 0.05 lbs $3.98 $2.93 $1.05
209579 2020-01-26 $23.58 First-Class Package Service 1 0.85 lbs $6.59 $5.54 $1.05
209580 2020-01-26 $46.04 First-Class Package Service 3 0.95 lbs $5.97 $8.12 $-2.15
209582 2020-01-27 $25.99 First-Class Package International Service 4 0.10 lbs $22.03 $13.78 $8.25
209586 2020-01-27 $6.88 First-Class Package Service 1 0.03 lbs $3.89 $2.84 $1.05
209587 2020-01-27 $10.08 First-Class Package Service 2 0.20 lbs $4.10 $3.52 $0.58
209588 2020-01-27 $53.24 Priority Mail 3-Day 10 1.05 lbs $11.39 $13.49 $-2.10
209589 2020-01-27 $12.42 First-Class Package Service 2 0.38 lbs $4.44 $2.93 $1.51
209591 2020-01-27 $9.59 First-Class Package Service 1 0.15 lbs $4.10 $3.52 $0.58
209594 2020-01-27 $29.50 Priority Mail 2-Day 1 1.05 lbs $8.49 $7.65 $0.84
209596 2020-01-27 $81.56 Priority Mail 3-Day 10 1.48 lbs $11.39 $10.53 $0.86
209599 2020-01-27 $67.58 Priority Mail 2-Day Flat Rate Envelope 2 2.65 lbs $8.00 $7.75 $0.25
209603 2020-01-27 $42.68 Priority Mail 2-Day Flat Rate Envelope 2 1.10 lbs $8.00 $7.65 $0.35
209604 2020-01-28 $44.13 Priority Mail 2-Day 1 1.85 lbs $9.44 $8.21 $1.23
209605 2020-01-28 $92.64 First-Class Package International Service 9 2.20 lbs $48.73 $38.48 $10.25
209606 2020-01-28 $32.29 First-Class Package Service 7 0.39 lbs $4.36 $3.31 $1.05
209607 2020-01-28 $22.93 Priority Mail 2-Day Flat Rate Envelope 7 0.07 lbs $8.00 $7.65 $0.35
209608 2020-01-28 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $8.50 $7.65 $0.85
209609 2020-01-28 $7.09 First-Class Package Service 1 0.02 lbs $4.10 $3.05 $1.05
209610 2020-01-28 $8.06 First-Class Package Service 4 0.04 lbs $4.10 $3.05 $1.05
209611 2020-01-28 $11.21 First-Class Package Service 3 0.31 lbs $4.44 $4.18 $0.26
209612 2020-01-28 $8.61 First-Class Package Service 2 0.07 lbs $4.23 $3.67 $0.56
209613 2020-01-28 $21.64 First-Class Package Service 1 0.45 lbs $4.36 $4.08 $0.28
209614 2020-01-28 $9.09 First-Class Package Service 1 0.10 lbs $4.10 $3.05 $1.05
209616 2020-01-28 $96.16 Priority Mail 2-Day 2 5.00 lbs $19.32 $18.47 $0.85
209617 2020-01-28 $57.66 Priority Mail 3-Day Large Flat Rate Box 8 4.55 lbs $19.15 $17.42 $1.73
209618 2020-01-28 $19.09 First-Class Package Service 1 0.19 lbs $4.10 $3.05 $1.05
209621 2020-01-29 $21.30 First-Class Package Service 2 0.25 lbs $4.72 $3.67 $1.05
209622 2020-01-29 $42.27 Priority Mail 2-Day Flat Rate Envelope 2 1.38 lbs $8.00 $7.65 $0.35
209623 2020-01-29 $90.63 Priority Mail 2-Day 7 2.55 lbs $14.34 $10.53 $3.81
209626 2020-01-29 $64.24 Priority Mail International Small Flat Rate Box 1 1.30 lbs $34.45 $33.60 $0.85
209629 2020-01-29 $26.82 Priority Mail 2-Day 1 3.10 lbs $11.18 $8.92 $2.26
209630 2020-01-29 $36.49 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.50 $7.65 $0.85
209631 2020-01-29 $129.82 Priority Mail 3-Day 1 3.00 lbs $30.00 $12.15 $17.85
209632 2020-01-29 $9.29 First-Class Package Service 1 0.10 lbs $4.10 $3.05 $1.05
209633 2020-01-29 $44.13 Priority Mail 2-Day 1 1.85 lbs $9.44 $8.21 $1.23
209637 2020-01-30 $123.06 Direct Link International 8 3.54 lbs $33.14 $35.86 $-2.72
209639 2020-01-30 $9.08 First-Class Package Service 1 0.05 lbs $3.89 $2.84 $1.05
209640 2020-01-30 $111.23 Priority Mail 2-Day 11 1.72 lbs $9.44 $8.59 $0.85
209641 2020-01-30 $11.09 First-Class Package Service 1 0.19 lbs $4.10 $3.05 $1.05
209644 2020-01-30 $9.82 First-Class Package Service 1 0.10 lbs $3.83 $3.25 $0.58
209645 2020-01-30 $15.29 First-Class Package Service 1 0.30 lbs $4.30 $4.00 $0.30
209646 2020-01-30 $9.47 First-Class Package Service 1 0.15 lbs $3.98 $3.39 $0.59
209647 2020-01-30 $21.51 First-Class Package Service 2 0.40 lbs $5.37 $4.32 $1.05
209650 2020-01-31 $24.19 First-Class Package Service 5 0.25 lbs $4.44 $3.39 $1.05
209651 2020-01-31 $78.93 Priority Mail 3-Day Medium Flat Rate Box 2 2.00 lbs $9.45 $10.42 $-0.97
209652 2020-01-31 $12.59 First-Class Package Service 4 0.20 lbs $3.83 $2.78 $1.05
209653 2020-01-31 $37.99 Priority Mail 3-Day Small Flat Rate Box 1 1.10 lbs $8.50 $7.65 $0.85
209656 2020-02-01 $14.61 First-Class Package Service 1 0.25 lbs $4.30 $3.25 $1.05
209657 2020-02-01 $28.38 Priority Mail 3-Day 12 1.95 lbs $13.00 $9.98 $3.02
209658 2020-02-01 $19.11 First-Class Package Service 1 0.20 lbs $4.30 $3.25 $1.05
209659 2020-02-01 $6.88 First-Class Package Service 1 0.10 lbs $3.89 $2.84 $1.05
209660 2020-01-31 $18.19 Priority Mail 3-Day Medium Flat Rate Box 1 0.80 lbs $5.00 $7.15 $-2.15
209661 2020-02-01 $101.49 Direct Link International 12 1.95 lbs $27.55 $18.48 $9.07
209662 2020-02-01 $9.29 First-Class Package Service 1 0.15 lbs $4.10 $3.05 $1.05
209663 2020-02-01 $34.05 First-Class Mail Large Envelope 5 0.55 lbs $4.70 $4.00 $0.70
209664 2020-02-01 $7.20 First-Class Package Service 3 0.03 lbs $4.23 $3.18 $1.05
209665 2020-02-01 $10.48 First-Class Mail Large Envelope 2 0.50 lbs $4.70 $4.18 $0.52
209667 2020-02-01 $159.48 Priority Mail 3-Day 11 5.71 lbs $10.59 $8.21 $2.38
209668 2020-02-01 $43.37 Priority Mail 3-Day Flat Rate Envelope 3 0.90 lbs $8.00 $7.65 $0.35
209669 2020-02-01 $49.42 Priority Mail 2-Day 2 2.20 lbs $9.44 $8.21 $1.23
209670 2020-02-02 $23.64 First-Class Package Service 2 0.45 lbs $4.36 $4.08 $0.28
209672 2020-02-02 $24.20 First-Class Package Service 3 0.42 lbs $4.93 $4.08 $0.85
209674 2020-02-02 $21.02 First-Class Package Service 2 0.25 lbs $4.44 $3.39 $1.05
209675 2020-02-02 $8.88 First-Class Package Service 10 0.10 lbs $3.98 $2.93 $1.05
209679 2020-02-02 $8.61 First-Class Package Service 2 0.07 lbs $4.23 $3.67 $0.56
209681 2020-02-02 $42.68 Priority Mail 2-Day Flat Rate Envelope 2 1.35 lbs $8.00 $7.65 $0.35
209682 2020-02-02 $6.55 First-Class Package Service 5 0.05 lbs $4.10 $3.05 $1.05
209683 2020-02-02 $22.09 First-Class Package Service - Retail 6 0.34 lbs $5.65 $3.39 $2.26
209684 2020-02-03 $31.24 First-Class Package Service 2 0.70 lbs $6.25 $5.40 $0.85
209685 2020-02-03 $23.99 First-Class Mail Large Envelope 1 0.60 lbs $4.70 $5.40 $-0.70
209686 2020-02-03 $14.33 First-Class Package Service 4 0.80 lbs $5.97 $4.00 $1.97
209687 2020-02-03 $329.78 Direct Link International 9 10.50 lbs $91.79 $97.54 $-5.75
209688 2020-02-03 $6.77 First-Class Package Service 1 0.06 lbs $3.98 $2.93 $1.05
209689 2020-02-03 $302.84 Priority Mail 2-Day 6 15.88 lbs $0.00 $31.70 $-31.70
209690 2020-02-03 $9.30 First-Class Package Service 3 0.10 lbs $3.83 $2.78 $1.05
209691 2020-02-03 $17.04 First-Class Package Service 1 0.57 lbs $5.05 $5.12 $-0.07
209693 2020-02-03 $10.87 First-Class Package Service 2 0.04 lbs $3.89 $2.84 $1.05
209694 2020-02-03 $37.99 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $8.50 $7.65 $0.85
209697 2020-02-03 $42.40 First-Class Package Service 4 0.20 lbs $4.44 $3.39 $1.05
209698 2020-02-03 $26.39 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $8.00 $7.75 $0.25
209700 2020-02-03 $15.21 First-Class Package Service 2 0.12 lbs $3.83 $2.78 $1.05
209702 2020-02-04 $11.75 First-Class Package Service 2 0.80 lbs $5.97 $5.12 $0.85
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56