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
207783 2019-09-18 $13.61 First-Class Package Service 1 0.45 lbs $5.38 $3.63 $1.75
207784 2019-09-18 $176.06 Priority Mail 2-Day 5 10.56 lbs $16.78 $17.57 $-0.79
207786 2019-09-18 $131.23 Ground 8 3.07 lbs $26.51 $20.24 $6.27
207787 2019-09-18 $5.73 First-Class Package Service 2 0.03 lbs $3.75 $2.70 $1.05
207788 2019-09-18 $88.27 Priority Mail 2-Day Flat Rate Envelope 3 2.25 lbs $7.80 $7.55 $0.25
207790 2019-09-18 $33.52 Priority Mail 2-Day 3 0.94 lbs $10.55 $9.70 $0.85
207791 2019-09-19 $39.03 Ground 3 20.75 lbs $29.00 $21.53 $7.47
207792 2019-09-19 $62.22 Priority Mail 2-Day 4 0.95 lbs $11.08 $10.23 $0.85
207793 2019-09-19 $28.25 First-Class Package Service 8 0.28 lbs $4.33 $3.28 $1.05
207794 2019-09-19 $6.90 First-Class Package Service 1 0.03 lbs $4.01 $2.96 $1.05
207797 2019-09-19 $7.85 Ground 1 0.25 lbs $3.25 $3.18 $0.07
207800 2019-09-20 $33.51 First-Class Package Service 3 0.55 lbs $5.24 $5.38 $-0.14
207801 2019-09-20 $85.38 Priority Mail 3-Day Padded Flat Rate Envelope 2 2.70 lbs $8.40 $7.55 $0.85
207803 2019-09-20 $133.99 Priority Mail 2-Day 2 4.01 lbs $11.18 $10.33 $0.85
207804 2019-09-20 $24.79 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $7.80 $7.50 $0.30
207805 2019-09-20 $236.95 Ground 5 17.22 lbs $33.90 $23.38 $10.52
207806 2019-09-21 $9.12 First-Class Package Service 2 0.10 lbs $4.14 $3.09 $1.05
207807 2019-09-21 $20.83 Priority Mail 2-Day 1 0.35 lbs $8.84 $7.50 $1.34
207808 2019-09-21 $11.84 First-Class Package Service 5 0.06 lbs $3.89 $2.84 $1.05
207810 2019-09-22 $37.14 Priority Mail 3-Day Small Flat Rate Box 1 1.15 lbs $8.35 $7.50 $0.85
207813 2019-09-22 $8.72 First-Class Package Service 2 0.38 lbs $4.54 $5.38 $-0.84
207815 2019-09-22 $216.43 Priority Mail 2-Day 34 4.89 lbs $10.07 $8.12 $1.95
207818 2019-09-22 $48.34 Priority Mail 3-Day Small Flat Rate Box 1 1.25 lbs $8.35 $7.50 $0.85
207819 2019-09-22 $42.34 Priority Mail 2-Day 1 1.35 lbs $9.35 $8.50 $0.85
207824 2019-09-22 $5.71 First-Class Package Service 4 0.04 lbs $3.75 $2.70 $1.05
207825 2019-09-22 $131.63 Priority Mail 2-Day 7 5.34 lbs $10.31 $9.46 $0.85
207826 2019-09-23 $58.88 Priority Mail 2-Day Flat Rate Envelope 2 1.92 lbs $7.80 $7.55 $0.25
207827 2019-09-23 $40.32 Direct Link International 10 0.82 lbs $15.22 $17.31 $-2.09
207833 2019-09-23 $7.61 First-Class Package Service - Retail 6 0.06 lbs $4.67 $2.84 $1.83
207835 2019-09-23 $75.87 Priority Mail 3-Day 4 2.29 lbs $10.11 $9.26 $0.85
207837 2019-09-23 $6.86 First-Class Package Service 3 0.13 lbs $3.89 $3.36 $0.53
207839 2019-09-23 $27.69 Priority Mail 3-Day 2 1.90 lbs $10.11 $9.26 $0.85
207842 2019-09-24 $9.99 First-Class Package Service 2 0.06 lbs $4.01 $2.96 $1.05
207844 2019-09-24 $54.10 Direct Link International 1 2.40 lbs $28.11 $24.23 $3.88
207846 2019-09-24 $82.49 Priority Mail 2-Day 4 1.75 lbs $11.08 $10.55 $0.53
207847 2019-09-24 $51.09 Priority Mail 2-Day 6 1.07 lbs $10.55 $9.70 $0.85
207855 2019-09-24 $17.01 First-Class Package Service 1 0.30 lbs $4.23 $3.18 $1.05
207856 2019-09-24 $40.27 First-Class Package Service 10 0.66 lbs $6.07 $3.88 $2.19
207857 2019-09-24 $14.39 First-Class Package Service 2 0.15 lbs $4.01 $2.96 $1.05
207858 2019-09-24 $18.37 First-Class Package Service 4 0.39 lbs $4.23 $3.82 $0.41
207859 2019-09-24 $47.30 2nd Day Air 4 0.16 lbs $36.84 $34.34 $2.50
207862 2019-09-25 $18.78 First-Class Package Service 3 0.15 lbs $3.81 $3.28 $0.53
207863 2019-09-25 $12.08 First-Class Package Service 4 0.27 lbs $5.11 $4.06 $1.05
207864 2019-09-25 $24.40 First-Class Package Service 1 0.45 lbs $4.41 $4.06 $0.35
207865 2019-09-25 $26.40 First-Class Package Service 1 0.40 lbs $4.41 $4.06 $0.35
207866 2019-09-25 $13.61 First-Class Package Service 1 0.45 lbs $5.38 $3.63 $1.75
207868 2019-09-25 $90.68 Priority Mail 2-Day 4 3.03 lbs $10.88 $10.03 $0.85
207870 2019-09-26 $83.73 Priority Mail 2-Day Medium Flat Rate Box 32 3.12 lbs $14.05 $11.20 $2.85
207871 2019-09-26 $66.81 Priority Mail 2-Day Medium Flat Rate Box 44 2.67 lbs $14.05 $12.80 $1.25
207872 2019-09-26 $87.75 Priority Mail 2-Day Medium Flat Rate Box 30 2.52 lbs $14.05 $11.20 $2.85
207873 2019-09-26 $78.78 Priority Mail 2-Day Medium Flat Rate Box 27 3.21 lbs $14.05 $11.20 $2.85
207874 2019-09-26 $49.44 Priority Mail 2-Day Flat Rate Envelope 36 2.56 lbs $7.80 $7.55 $0.25
207875 2019-09-26 $37.60 Priority Mail 2-Day Flat Rate Envelope 20 1.76 lbs $7.80 $7.55 $0.25
207876 2019-09-26 $6.00 First-Class Package Service 1 0.03 lbs $4.01 $2.96 $1.05
207877 2019-09-26 $25.34 First-Class Package Service 4 0.56 lbs $5.38 $4.33 $1.05
207878 2019-09-26 $10.74 First-Class Package Service 1 0.07 lbs $3.75 $2.70 $1.05
207879 2019-09-26 $57.50 Priority Mail 3-Day 14 3.39 lbs $16.44 $15.59 $0.85
207880 2019-09-26 $60.37 Priority Mail 2-Day Medium Flat Rate Box 18 2.19 lbs $14.05 $11.20 $2.85
207881 2019-09-26 $45.78 Priority Mail 2-Day Medium Flat Rate Box 7 2.14 lbs $14.05 $11.20 $2.85
207882 2019-09-26 $51.67 Priority Mail 2-Day 4 1.40 lbs $11.71 $10.86 $0.85
207884 2019-09-26 $14.08 First-Class Package Service 1 0.65 lbs $6.09 $5.24 $0.85
207885 2019-09-27 $71.47 Priority Mail 2-Day 11 3.06 lbs $10.88 $8.76 $2.12
207886 2019-09-27 $9.00 First-Class Package Service 1 0.05 lbs $4.01 $2.96 $1.05
207889 2019-09-27 $36.19 Priority Mail 2-Day Flat Rate Envelope 1 1.27 lbs $7.80 $7.50 $0.30
207890 2019-09-27 $34.58 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $8.35 $7.50 $0.85
207894 2019-09-27 $12.70 Priority Mail 2-Day Flat Rate Envelope 10 0.10 lbs $7.80 $6.95 $0.85
207895 2019-09-27 $56.08 Priority Mail 2-Day Flat Rate Envelope 2 1.70 lbs $7.80 $7.50 $0.30
207896 2019-09-28 $38.14 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $8.35 $7.50 $0.85
207898 2019-09-28 $7.38 First-Class Package Service 1 0.03 lbs $3.89 $2.84 $1.05
207899 2019-09-28 $24.32 First-Class Package Service 1 0.40 lbs $4.33 $3.96 $0.37
207902 2019-09-28 $50.42 Direct Link International 1 1.05 lbs $22.43 $19.83 $2.60
207905 2019-09-28 $50.23 Direct Link International 12 2.28 lbs $31.75 $26.23 $5.52
207907 2019-09-29 $10.88 First-Class Package Service 1 0.07 lbs $3.89 $2.84 $1.05
207908 2019-09-29 $20.71 First-Class Package Service 2 0.40 lbs $4.93 $3.88 $1.05
207909 2019-09-29 $38.92 Priority Mail Express 2-Day 3 0.09 lbs $29.95 $29.10 $0.85
207911 2019-09-29 $24.00 First-Class Package Service 11 0.34 lbs $4.81 $3.96 $0.85
207914 2019-09-29 $19.77 Priority Mail 2-Day Flat Rate Envelope 3 0.07 lbs $7.80 $7.50 $0.30
207916 2019-09-29 $33.47 First-Class Package Service 7 0.28 lbs $4.54 $3.49 $1.05
207918 2019-09-29 $106.44 Priority Mail 2-Day 14 3.00 lbs $10.88 $10.33 $0.55
207920 2019-09-29 $59.13 Priority Mail 2-Day 12 3.20 lbs $10.88 $10.03 $0.85
207921 2019-09-29 $16.31 First-Class Package Service 3 0.11 lbs $4.14 $3.63 $0.51
207923 2019-09-29 $6.23 First-Class Package Service 2 0.02 lbs $3.75 $2.70 $1.05
207924 2019-09-29 $23.04 Priority Mail 2-Day Flat Rate Envelope 6 1.14 lbs $7.80 $7.50 $0.30
207926 2019-09-29 $6.87 First-Class Package Service 2 0.20 lbs $3.89 $2.84 $1.05
207929 2019-09-30 $75.00 Priority Mail 2-Day 1 5.65 lbs $14.62 $15.43 $-0.81
207930 2019-09-30 $11.28 First-Class Package Service 3 0.57 lbs $5.01 $3.96 $1.05
207932 2019-09-30 $85.47 Priority Mail 2-Day 8 3.03 lbs $9.66 $8.12 $1.54
207933 2019-10-01 $29.22 Priority Mail 3-Day Flat Rate Envelope 8 1.27 lbs $7.80 $7.50 $0.30
207934 2019-10-01 $9.49 First-Class Package Service 2 0.21 lbs $4.01 $3.49 $0.52
207935 2019-10-01 $34.56 Priority Mail 3-Day Flat Rate Envelope 4 0.55 lbs $7.80 $7.50 $0.30
207936 2019-10-01 $32.81 First-Class Package Service 2 0.65 lbs $6.23 $5.38 $0.85
207937 2019-10-01 $36.27 Priority Mail 2-Day 4 2.40 lbs $10.11 $8.76 $1.35
207938 2019-10-01 $6.74 First-Class Package Service 1 0.05 lbs $3.75 $2.70 $1.05
207939 2019-10-02 $14.91 First-Class Package Service 2 0.40 lbs $4.93 $3.22 $1.71
207941 2019-10-02 $218.91 Priority Mail 3-Day 1 14.05 lbs $28.92 $28.07 $0.85
207944 2019-10-02 $10.96 First-Class Package Service 1 0.55 lbs $6.07 $5.02 $1.05
207945 2019-10-02 $24.14 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.40 lbs $8.40 $7.55 $0.85
207947 2019-10-02 $5.87 First-Class Package Service 2 0.01 lbs $3.89 $2.84 $1.05
207949 2019-10-02 $3.48 First-Class Package Service 6 0.49 lbs $5.11 $4.06 $1.05
207950 2019-10-02 $39.45 First-Class Package Service 9 0.67 lbs $5.24 $4.19 $1.05
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56