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
202782 2018-04-26 $115.00 Priority Mail International 1 3.95 lbs $61.01 $60.28 $0.73
202785 2018-04-26 $114.44 Priority Mail 2-Day Medium Flat Rate Box 11 2.35 lbs $13.85 $10.29 $3.56
202786 2018-04-26 $26.16 Ground 2 0.07 lbs $20.18 $6.85 $13.33
202788 2018-04-26 $109.66 Ground 3 5.90 lbs $23.09 $19.93 $3.16
202789 2018-04-26 $16.33 First-Class Mail Large Envelope 1 0.30 lbs $3.61 $3.18 $0.43
202791 2018-04-27 $73.45 First-Class Package International Service 3 1.62 lbs $27.33 $22.33 $5.00
202792 2018-04-27 $73.60 First-Class Package International Service 3 1.85 lbs $27.33 $33.01 $-5.68
202794 2018-04-27 $76.08 First-Class Package International Service 5 1.47 lbs $27.33 $22.33 $5.00
202795 2018-04-27 $158.09 Priority Mail 3-Day 2 9.80 lbs $28.66 $31.58 $-2.92
202796 2018-04-27 $115.00 Priority Mail International 1 3.95 lbs $61.01 $56.76 $4.25
202797 2018-04-27 $11.83 First-Class Package Service 1 0.17 lbs $3.84 $2.79 $1.05
202798 2018-04-27 $25.69 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $7.40 $6.90 $0.50
202799 2018-04-27 $154.77 Direct Link International 10 3.41 lbs $36.57 $8.43 $28.14
202802 2018-04-27 $24.02 First-Class Mail Large Envelope 1 0.40 lbs $4.03 $3.34 $0.69
202803 2018-04-27 $6.68 First-Class Package Service 3 0.03 lbs $3.71 $2.66 $1.05
202804 2018-04-27 $25.77 Priority Mail 2-Day 8 1.52 lbs $8.25 $7.40 $0.85
202805 2018-04-28 $85.29 First-Class Package International Service 2 2.40 lbs $38.01 $33.01 $5.00
202806 2018-04-28 $42.31 Priority Mail 2-Day 1 0.75 lbs $10.32 $9.19 $1.13
202807 2018-04-28 $146.78 Priority Mail 2-Day 8 4.90 lbs $10.56 $7.40 $3.16
202808 2018-04-28 $31.42 First-Class Mail Large Envelope 2 0.45 lbs $4.24 $3.66 $0.58
202810 2018-04-28 $24.57 First-Class Package Service 14 0.16 lbs $3.71 $2.66 $1.05
202811 2018-04-28 $17.04 Priority Mail 3-Day 1 0.95 lbs $8.25 $7.18 $1.07
202812 2018-04-28 $23.62 First-Class Package Service 1 0.90 lbs $5.23 $4.66 $0.57
202813 2018-04-28 $65.71 Priority Mail 2-Day 3 1.45 lbs $11.14 $9.98 $1.16
202815 2018-04-29 $6.70 First-Class Package Service 1 0.02 lbs $3.71 $2.66 $1.05
202816 2018-04-29 $32.63 First-Class Package Service 8 0.56 lbs $4.71 $3.50 $1.21
202821 2018-04-29 $10.68 First-Class Package Service 3 0.04 lbs $3.71 $2.66 $1.05
202822 2018-04-29 $41.24 Priority Mail 2-Day 1 1.35 lbs $8.25 $7.40 $0.85
202823 2018-04-29 $45.77 First-Class Package Service 2 0.85 lbs $5.79 $4.94 $0.85
202825 2018-04-30 $17.33 First-Class Package Service 3 0.57 lbs $5.71 $4.94 $0.77
202827 2018-04-30 $11.50 First-Class Package Service 1 0.10 lbs $3.71 $2.66 $1.05
202830 2018-04-30 $72.48 Priority Mail 3-Day 6 2.83 lbs $9.54 $7.40 $2.14
202831 2018-04-30 $56.82 First-Class Package International Service 1 1.20 lbs $27.33 $22.33 $5.00
202832 2018-04-30 $7.22 First-Class Package Service 1 0.03 lbs $5.23 $3.82 $1.41
202833 2018-04-30 $54.88 Priority Mail 2-Day Flat Rate Envelope 2 1.60 lbs $7.40 $6.85 $0.55
202834 2018-04-30 $9.70 First-Class Package Service 1 0.13 lbs $3.71 $2.92 $0.79
202835 2018-04-30 $262.35 Priority Mail International 16 4.77 lbs $59.81 $45.35 $14.46
202837 2018-04-30 $7.20 First-Class Package Service 1 0.03 lbs $3.71 $2.66 $1.05
202838 2018-04-30 $371.04 Priority Mail International 10 15.91 lbs $139.04 $126.59 $12.45
202841 2018-04-30 $236.67 Ground 9 19.45 lbs $23.26 $14.22 $9.04
202843 2018-05-01 $25.65 Priority Mail 2-Day 7 1.33 lbs $10.32 $9.19 $1.13
202844 2018-05-01 $128.70 Priority Mail International 1 5.65 lbs $64.53 $60.28 $4.25
202846 2018-05-01 $7.70 First-Class Package Service 1 0.07 lbs $3.71 $2.66 $1.05
202847 2018-05-01 $12.68 First-Class Package Service 3 0.03 lbs $3.71 $2.66 $1.05
202849 2018-05-01 $38.06 First-Class Package Service 17 0.93 lbs $5.23 $4.38 $0.85
202850 2018-05-01 $26.87 Priority Mail 2-Day Small Flat Rate Box 3 2.29 lbs $7.90 $6.85 $1.05
202851 2018-05-02 $69.55 First-Class Package International Service 4 0.43 lbs $27.09 $22.09 $5.00
202853 2018-05-02 $12.86 First-Class Package Service 3 0.34 lbs $4.39 $2.92 $1.47
202854 2018-05-02 $24.18 First-Class Package Service 1 0.40 lbs $4.19 $3.05 $1.14
202857 2018-05-02 $33.95 First-Class Package Service 60 0.60 lbs $4.55 $2.66 $1.89
202859 2018-05-03 $16.82 First-Class Mail Large Envelope 2 0.40 lbs $4.24 $3.18 $1.06
202860 2018-05-03 $36.69 Priority Mail 2-Day Small Flat Rate Box 1 1.15 lbs $7.90 $6.85 $1.05
202861 2018-05-03 $131.82 Priority Mail International 1 5.65 lbs $64.53 $60.28 $4.25
202862 2018-05-03 $41.57 Priority Mail 2-Day Small Flat Rate Box 3 0.75 lbs $7.90 $6.85 $1.05
202864 2018-05-03 $73.95 Priority Mail 2-Day 5 4.00 lbs $11.50 $8.15 $3.35
202866 2018-05-03 $25.20 First-Class Package Service 1 0.85 lbs $5.71 $4.66 $1.05
202869 2018-05-03 $8.89 First-Class Package Service 1 0.27 lbs $4.10 $3.18 $0.92
202870 2018-05-03 $38.31 Priority Mail 3-Day 1 1.20 lbs $9.32 $7.18 $2.14
202872 2018-05-04 $5.70 First-Class Package Service 1 0.04 lbs $3.71 $2.66 $1.05
202874 2018-05-04 $93.92 First-Class Package International Service 4 2.60 lbs $38.01 $48.93 $-10.92
202875 2018-05-04 $90.62 First-Class Package International Service 4 2.58 lbs $38.01 $48.93 $-10.92
202876 2018-05-04 $270.57 Priority Mail International 1 14.05 lbs $100.58 $157.08 $-56.50
202877 2018-05-04 $107.98 First-Class Package International Service 3 2.13 lbs $38.01 $33.01 $5.00
202879 2018-05-04 $44.13 Priority Mail 2-Day 1 1.35 lbs $11.14 $9.98 $1.16
202880 2018-05-04 $8.13 First-Class Package Service 4 0.02 lbs $3.71 $2.66 $1.05
202881 2018-05-04 $121.00 Priority Mail International 1 3.85 lbs $61.01 $56.76 $4.25
202883 2018-05-05 $20.02 First-Class Mail Large Envelope 1 0.41 lbs $4.03 $3.34 $0.69
202887 2018-05-05 $12.64 First-Class Package Service 7 0.07 lbs $3.71 $2.66 $1.05
202891 2018-05-06 $35.40 Priority Mail 2-Day 11 2.17 lbs $13.01 $11.80 $1.21
202892 2018-05-07 $5.20 First-Class Package Service 1 0.01 lbs $3.71 $2.66 $1.05
202893 2018-05-07 $5.20 First-Class Package Service 1 0.01 lbs $3.71 $2.66 $1.05
202894 2018-05-07 $92.73 Priority Mail 2-Day 2 3.60 lbs $21.88 $17.61 $4.27
202899 2018-05-07 $20.84 Priority Mail 3-Day Flat Rate Envelope 6 0.13 lbs $7.40 $6.85 $0.55
202900 2018-05-07 $35.28 Priority Mail 2-Day Flat Rate Envelope 2 1.15 lbs $7.40 $6.85 $0.55
202901 2018-05-07 $3.97 First-Class Package Service 1 0.30 lbs $3.97 $2.79 $1.18
202902 2018-05-07 $36.37 Priority Mail 3-Day Flat Rate Envelope 3 0.89 lbs $7.40 $6.85 $0.55
202905 2018-05-07 $8.70 First-Class Package Service 1 0.10 lbs $3.71 $2.66 $1.05
202907 2018-05-08 $27.43 First-Class Package Service 1 0.49 lbs $5.23 $4.10 $1.13
202908 2018-05-08 $100.34 Priority Mail 3-Day 5 2.95 lbs $11.19 $10.03 $1.16
202909 2018-05-08 $5.83 First-Class Package Service 1 0.19 lbs $3.84 $2.66 $1.18
202912 2018-05-08 $189.98 Ground 1 14.05 lbs $19.99 $13.53 $6.46
202916 2018-04-24 $6.14 Priority Mail 2-Day 2 0.40 lbs $1.96 $6.98 $-5.02
202917 2018-05-08 $156.69 First-Class Package International Service 6 2.85 lbs $38.25 $50.11 $-11.86
202919 2018-05-08 $25.95 Priority Mail 2-Day Flat Rate Envelope 5 0.25 lbs $7.40 $6.85 $0.55
202921 2018-05-08 $15.40 First-Class Mail Large Envelope 1 0.25 lbs $3.61 $3.05 $0.56
202922 2018-05-08 $5.67 First-Class Package Service 4 0.04 lbs $3.71 $2.66 $1.05
202924 2018-05-09 $218.15 Priority Mail International 18 4.10 lbs $62.63 $58.38 $4.25
202925 2018-05-09 $88.81 First-Class Package International Service 2 1.85 lbs $27.33 $22.33 $5.00
202929 2018-05-09 $18.83 First-Class Package Service 1 0.35 lbs $3.84 $3.18 $0.66
202930 2018-05-09 $95.34 Direct Link International 8 2.98 lbs $34.92 $8.43 $26.49
202931 2018-05-09 $14.15 First-Class Package Service 4 0.80 lbs $5.79 $4.94 $0.85
202932 2018-05-09 $10.68 First-Class Package Service 3 0.31 lbs $4.71 $2.92 $1.79
202933 2018-05-09 $70.89 First-Class Package International Service 1 1.65 lbs $27.33 $22.33 $5.00
202934 2018-05-09 $73.02 First-Class Package International Service 1 1.75 lbs $27.33 $22.33 $5.00
202935 2018-05-09 $67.82 First-Class Package International Service 1 1.45 lbs $27.33 $22.33 $5.00
202936 2018-05-09 $12.33 First-Class Package Service 1 0.18 lbs $3.84 $2.79 $1.05
202939 2018-05-09 $6.70 First-Class Package Service 1 0.03 lbs $3.71 $2.66 $1.05
202940 2018-05-10 $11.05 First-Class Package Service 6 0.12 lbs $3.71 $2.66 $1.05
202941 2018-05-10 $87.91 Priority Mail 3-Day Medium Flat Rate Box 4 2.10 lbs $13.85 $12.76 $1.09
202942 2018-05-10 $7.69 First-Class Package Service 2 0.08 lbs $3.71 $2.66 $1.05
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56