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
223754 2021-03-30 $7.29 USPSFirstClass 1 0.10 lbs $4.30 $3.06 $1.24
223755 2021-03-30 $12.33 USPSFirstClass 2 0.10 lbs $4.35 $3.06 $1.29
223756 2021-03-30 $12.39 First-Class Mail Stamped Letter 1 0.12 lbs $3.40 $3.22 $0.18
223757 2021-03-30 $33.81 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.75 $7.90 $0.85
223758 2021-03-30 $14.18 First-Class Package Service 1 0.76 lbs $6.06 $5.81 $0.25
223759 2021-03-30 $133.24 Priority Mail 2-Day Medium Flat Rate Box 16 4.80 lbs $15.00 $39.67 $-24.67
223760 2021-03-30 $38.54 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.75 $7.90 $0.85
223766 2021-03-30 $34.58 USPSMedia 1 3.15 lbs $6.00 $4.57 $1.43
223767 2021-03-30 $10.99 First-Class Mail Stamped Letter 1 0.04 lbs $3.20 $3.01 $0.19
223769 2021-03-30 $13.90 First-Class Package Service 1 0.65 lbs $5.91 $4.38 $1.53
223770 2021-03-30 $45.88 Priority Mail 2-Day 1 1.40 lbs $9.09 $8.24 $0.85
223773 2021-03-30 $15.80 First-Class Package Service 1 0.30 lbs $4.01 $4.12 $-0.11
223774 2021-03-30 $158.22 Priority Mail 3-Day 1 9.60 lbs $28.23 $21.11 $7.12
223775 2021-03-30 $38.48 First-Class Package International Service 3 0.07 lbs $26.51 $18.76 $7.75
223776 2021-03-31 $9.03 USPSFirstClass 2 0.30 lbs $5.05 $4.20 $0.85
223778 2021-03-30 $27.41 First-Class Package Service 2 0.60 lbs $5.03 $4.53 $0.50
223780 2021-03-30 $15.28 First-Class Package Service 1 0.10 lbs $3.56 $3.51 $0.05
223781 2021-03-30 $7.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.06 $0.14
223782 2021-03-31 $71.24 Priority Mail 2-Day 5 1.14 lbs $11.86 $11.01 $0.85
223784 2021-03-31 $12.43 USPSFirstClass 1 0.06 lbs $4.64 $3.22 $1.42
223785 2021-03-31 $7.86 USPSFirstClass 1 0.05 lbs $4.37 $3.12 $1.25
223786 2021-03-31 $25.29 USPSFirstClass 1 0.03 lbs $5.30 $3.35 $1.95
223787 2021-03-31 $11.30 USPSFirstClass 2 0.06 lbs $4.32 $3.06 $1.26
223788 2021-03-31 $9.63 USPSFirstClass 1 0.61 lbs $5.84 $5.42 $0.42
223790 2021-03-31 $35.47 Priority Mail 2-Day Flat Rate Envelope 2 1.33 lbs $8.25 $7.90 $0.35
223792 2021-03-31 $54.87 First-Class Package Service 1 0.56 lbs $4.88 $4.38 $0.50
223793 2021-03-31 $143.82 Ground 10 3.67 lbs $27.95 $20.37 $7.58
223794 2021-03-31 $9.19 First-Class Mail Stamped Letter 1 0.07 lbs $3.20 $3.22 $-0.02
223795 2021-03-31 $38.08 Priority Mail 2-Day 1 0.70 lbs $9.70 $8.85 $0.85
223796 2021-03-31 $9.75 First-Class Mail Stamped Letter 2 0.10 lbs $3.20 $4.04 $-0.84
223797 2021-03-31 $34.98 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.75 $7.90 $0.85
223798 2021-03-31 $38.54 Priority Mail 3-Day Small Flat Rate Box 1 1.15 lbs $8.75 $7.90 $0.85
223799 2021-03-31 $15.36 First-Class Package Service 1 0.50 lbs $4.37 $4.12 $0.25
223800 2021-03-31 $80.24 Priority Mail 2-Day 1 3.60 lbs $20.14 $19.29 $0.85
223801 2021-03-31 $83.76 USPSFirstClass 10 2.70 lbs $35.86 $18.50 $17.36
223802 2021-03-31 $36.98 Priority Mail 2-Day Medium Flat Rate Box 2 5.35 lbs $15.00 $13.75 $1.25
223803 2021-03-31 $7.99 First-Class Mail Stamped Letter 1 0.04 lbs $3.00 $3.06 $-0.06
223804 2021-03-31 $13.38 First-Class Mail Stamped Letter 2 0.12 lbs $3.40 $3.35 $0.05
223806 2021-03-31 $34.98 Priority Mail 2-Day Small Flat Rate Box 1 1.00 lbs $8.75 $7.90 $0.85
223807 2021-03-31 $19.38 First-Class Mail Stamped Letter 2 0.13 lbs $3.40 $3.51 $-0.11
223809 2021-03-31 $21.21 First-Class Package Service 1 0.60 lbs $4.45 $5.42 $-0.97
223810 2021-03-31 $25.53 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $8.25 $8.00 $0.25
223812 2021-03-31 $62.92 Priority Mail 2-Day 18 1.51 lbs $9.70 $9.01 $0.69
223813 2021-04-01 $22.89 First-Class Mail Stamped Letter 1 0.18 lbs $3.60 $3.49 $0.11
223814 2021-04-01 $15.12 First-Class Mail Stamped Letter 1 0.10 lbs $3.40 $3.35 $0.05
223815 2021-04-01 $9.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.35 $-0.15
223816 2021-04-01 $11.99 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.35 $-0.15
223818 2021-04-01 $318.23 Priority Mail 2-Day Flat Rate Envelope 2 10.22 lbs $8.25 $8.00 $0.25
223819 2021-04-01 $19.16 USPSFirstClass 2 0.07 lbs $9.38 $3.49 $5.89
223820 2021-04-01 $7.29 USPSFirstClass 1 0.10 lbs $4.30 $3.06 $1.24
223821 2021-04-01 $67.14 USPSPriority 1 1.25 lbs $13.77 $7.90 $5.87
223824 2021-04-01 $12.43 USPSFirstClass 1 0.06 lbs $4.64 $3.22 $1.42
223825 2021-04-01 $12.98 First-Class Mail Stamped Letter 2 0.10 lbs $3.40 $3.35 $0.05
223827 2021-04-01 $9.49 First-Class Mail Stamped Letter 1 0.08 lbs $3.20 $3.06 $0.14
223828 2021-04-01 $13.67 First-Class Mail Stamped Letter 3 0.09 lbs $3.20 $3.22 $-0.02
223830 2021-04-01 $12.15 First-Class Mail Stamped Letter 5 0.08 lbs $3.20 $3.35 $-0.15
223831 2021-04-01 $58.49 Priority Mail 2-Day 5 1.05 lbs $12.54 $11.69 $0.85
223832 2021-04-01 $101.76 Priority Mail 2-Day 5 2.67 lbs $14.95 $11.42 $3.53
223833 2021-04-01 $18.63 First-Class Package Service 6 0.17 lbs $4.19 $3.35 $0.84
223834 2021-04-01 $232.63 Priority Mail 2-Day 2 13.16 lbs $42.05 $39.67 $2.38
223836 2021-04-01 $20.47 Priority Mail 3-Day Small Flat Rate Box 1 0.10 lbs $8.75 $7.90 $0.85
223837 2021-04-01 $8.99 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.06 $0.14
223838 2021-04-02 $9.49 USPSFirstClass 2 0.38 lbs $5.11 $3.58 $1.53
223840 2021-04-02 $7.39 USPSFirstClass 1 0.10 lbs $4.40 $3.22 $1.18
223841 2021-04-02 $6.60 USPSFirstClass 1 0.01 lbs $4.41 $3.35 $1.06
223842 2021-04-02 $12.43 USPSFirstClass 1 0.03 lbs $4.64 $3.22 $1.42
223843 2021-04-02 $9.69 First-Class Mail Stamped Letter 1 0.10 lbs $3.40 $3.01 $0.39
223844 2021-04-02 $41.72 First-Class Package Service 2 0.70 lbs $6.16 $5.66 $0.50
223845 2021-04-02 $11.24 First-Class Package Service 1 0.34 lbs $4.35 $3.85 $0.50
223846 2021-04-02 $67.21 Priority Mail 2-Day Small Flat Rate Box 2 2.45 lbs $14.75 $8.00 $6.75
223847 2021-04-02 $45.59 Priority Mail 2-Day 2 1.60 lbs $11.86 $7.90 $3.96
223848 2021-04-02 $16.96 First-Class Package Service 1 0.30 lbs $4.07 $3.57 $0.50
223852 2021-04-02 $227.37 Ground 1 13.15 lbs $38.68 $27.79 $10.89
223853 2021-04-02 $25.13 First-Class Package Service 3 0.40 lbs $5.03 $3.69 $1.34
223857 2021-04-03 $9.84 First-Class Package Service 1 0.03 lbs $3.85 $3.35 $0.50
223858 2021-04-03 $8.16 USPSMedia 1 0.25 lbs $3.14 $2.89 $0.25
223859 2021-04-03 $25.75 USPSMedia 1 1.78 lbs $4.51 $3.45 $1.06
223860 2021-04-03 $12.63 USPSFirstClass 1 0.06 lbs $4.84 $3.49 $1.35
223861 2021-04-03 $8.68 First-Class Mail Stamped Letter 2 0.08 lbs $3.20 $3.35 $-0.15
223862 2021-04-03 $7.39 USPSFirstClass 1 0.10 lbs $4.40 $3.22 $1.18
223863 2021-04-03 $12.18 USPSFirstClass 1 0.34 lbs $5.29 $3.57 $1.72
223864 2021-04-03 $12.90 First-Class Mail Stamped Letter 10 0.04 lbs $3.00 $3.06 $-0.06
223865 2021-04-03 $27.02 Priority Mail 3-Day 1 0.30 lbs $8.73 $7.90 $0.83
223866 2021-04-03 $14.92 First-Class Package Service 4 0.56 lbs $6.06 $5.81 $0.25
223867 2021-04-03 $26.50 Priority Mail 3-Day Flat Rate Envelope 5 0.24 lbs $8.25 $7.90 $0.35
223868 2021-04-03 $32.24 Priority Mail 2-Day Flat Rate Envelope 1 3.55 lbs $8.25 $8.00 $0.25
223871 2021-04-03 $47.16 Priority Mail 2-Day 16 0.85 lbs $9.70 $9.01 $0.69
223872 2021-04-03 $49.11 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.31 lbs $8.85 $10.44 $-1.59
223875 2021-04-04 $15.62 First-Class Package Service 1 0.55 lbs $5.18 $4.68 $0.50
223877 2021-04-04 $12.33 USPSFirstClass 1 0.06 lbs $4.54 $4.12 $0.42
223878 2021-04-04 $7.76 USPSFirstClass 1 0.07 lbs $4.37 $3.12 $1.25
223879 2021-04-04 $9.90 USPSFirstClass 1 0.06 lbs $4.57 $3.69 $0.88
223885 2021-04-04 $33.42 Priority Mail 2-Day 2 1.10 lbs $12.54 $8.00 $4.54
223886 2021-04-04 $9.08 USPSFirstClass 2 0.30 lbs $5.10 $4.38 $0.72
223887 2021-04-04 $5.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.35 $-0.15
223888 2021-04-04 $7.59 USPSFirstClass 1 0.10 lbs $4.60 $3.49 $1.11
223889 2021-04-04 $54.88 USPSPriority 2 14.00 lbs $28.90 $23.40 $5.50
223890 2021-04-04 $5.47 First-Class Mail Stamped Letter 3 0.03 lbs $3.00 $3.35 $-0.35
223891 2021-04-04 $10.90 USPSFirstClass 1 0.10 lbs $4.61 $3.35 $1.26
223893 2021-04-05 $12.48 USPSFirstClass 1 0.06 lbs $4.69 $3.35 $1.34
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56