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
203503 2018-07-16 $113.03 Priority Mail International 3 8.60 lbs $63.06 $61.70 $1.36
203504 2018-07-17 $9.69 First-Class Package Service 2 0.20 lbs $3.71 $2.66 $1.05
203505 2018-07-17 $38.29 First-Class Package International Service 1 0.40 lbs $18.30 $22.33 $-4.03
203506 2018-07-17 $6.70 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
203507 2018-07-17 $8.70 First-Class Package Service 1 0.10 lbs $3.71 $2.66 $1.05
203509 2018-07-17 $15.39 Priority Mail 2-Day Flat Rate Envelope 1 0.17 lbs $7.40 $6.85 $0.55
203510 2018-07-17 $19.19 First-Class Package Service 4 0.46 lbs $4.23 $2.79 $1.44
203513 2018-07-18 $42.09 Priority Mail 2-Day Flat Rate Envelope 1 1.85 lbs $7.40 $10.29 $-2.89
203514 2018-07-18 $38.14 Priority Mail 3-Day 1 0.57 lbs $11.65 $7.53 $4.12
203516 2018-07-18 $103.84 Priority Mail 2-Day Medium Flat Rate Box 1 9.10 lbs $13.85 $9.47 $4.38
203518 2018-07-18 $14.09 First-Class Package Service 2 0.50 lbs $4.51 $4.38 $0.13
203520 2018-07-19 $77.16 Standard 1 0.60 lbs $28.81 $23.08 $5.73
203522 2018-07-19 $192.33 Direct Link International 2 14.30 lbs $71.85 $15.00 $56.85
203530 2018-07-19 $66.13 Priority Mail 3-Day 3 2.75 lbs $9.32 $8.43 $0.89
203532 2018-07-19 $19.11 Priority Mail 2-Day 1 0.95 lbs $10.32 $9.19 $1.13
203533 2018-07-19 $21.11 First-Class Package Service 4 0.08 lbs $3.71 $2.66 $1.05
203534 2018-07-20 $25.66 First-Class Package Service 5 0.43 lbs $4.71 $3.18 $1.53
203535 2018-07-20 $27.24 Priority Mail 1-Day Flat Rate Envelope 1 0.90 lbs $7.40 $6.90 $0.50
203540 2018-07-20 $121.47 Priority Mail 2-Day Large Flat Rate Box 4 11.97 lbs $18.50 $17.10 $1.40
203541 2018-07-20 $50.30 Priority Mail 2-Day 2 1.73 lbs $9.32 $8.22 $1.10
203543 2018-07-21 $9.69 First-Class Package Service 2 0.06 lbs $3.71 $2.66 $1.05
203544 2018-07-21 $10.70 First-Class Package Service 1 0.19 lbs $3.71 $2.66 $1.05
203545 2018-07-21 $14.25 First-Class Package Service 2 0.54 lbs $4.67 $4.10 $0.57
203546 2018-07-21 $23.88 Priority Mail 2-Day 4 1.60 lbs $10.32 $9.19 $1.13
203547 2018-07-22 $195.54 Priority Mail International 3 3.50 lbs $62.63 $55.67 $6.96
203548 2018-07-22 $26.33 First-Class Package Service 2 0.74 lbs $5.15 $4.38 $0.77
203552 2018-07-22 $23.38 First-Class Mail Large Envelope 3 0.30 lbs $3.61 $3.05 $0.56
203553 2018-07-22 $8.70 First-Class Package Service 1 0.06 lbs $3.71 $2.66 $1.05
203555 2018-07-22 $30.22 Priority Mail 2-Day 10 1.90 lbs $9.32 $7.40 $1.92
203556 2018-07-22 $14.76 First-Class Package Service 1 0.30 lbs $3.97 $3.18 $0.79
203559 2018-07-22 $61.03 Priority Mail 3-Day Medium Flat Rate Box 2 2.25 lbs $13.85 $12.45 $1.40
203563 2018-07-22 $30.43 Priority Mail 2-Day Padded Flat Rate Envelope 2 1.30 lbs $7.95 $6.85 $1.10
203565 2018-07-23 $115.54 First-Class Package International Service 2 2.35 lbs $41.96 $48.93 $-6.97
203566 2018-07-23 $5.69 First-Class Package Service 2 0.10 lbs $3.71 $2.92 $0.79
203567 2018-07-23 $20.37 First-Class Package Service 2 0.40 lbs $4.39 $3.66 $0.73
203568 2018-07-23 $22.64 Priority Mail 2-Day Flat Rate Envelope 6 1.14 lbs $7.40 $6.90 $0.50
203570 2018-07-23 $24.85 First-Class Package Service 2 0.70 lbs $4.87 $4.38 $0.49
203571 2018-07-23 $9.59 First-Class Package Service 1 0.38 lbs $4.10 $3.05 $1.05
203577 2018-07-25 $165.33 Priority Mail International 1 8.55 lbs $81.34 $70.82 $10.52
203579 2018-07-25 $52.18 Priority Mail 2-Day Flat Rate Envelope 2 1.80 lbs $7.40 $6.85 $0.55
203581 2018-07-25 $30.33 First-Class Package International Service 3 0.75 lbs $30.33 $22.33 $8.00
203584 2018-07-25 $9.70 First-Class Package Service 1 0.02 lbs $3.71 $2.66 $1.05
203585 2018-07-25 $8.70 First-Class Package Service 1 0.10 lbs $3.71 $2.66 $1.05
203586 2018-07-25 $26.36 First-Class Mail Large Envelope 1 0.50 lbs $4.87 $3.82 $1.05
203587 2018-07-25 $57.89 Priority Mail 3-Day 16 1.27 lbs $9.00 $7.91 $1.09
203589 2018-07-26 $138.52 Direct Link International 6 3.30 lbs $36.71 $8.43 $28.28
203590 2018-07-26 $47.89 Priority Mail 3-Day Small Flat Rate Box 1 1.25 lbs $7.90 $6.85 $1.05
203593 2018-07-26 $67.18 Priority Mail 2-Day Small Flat Rate Box 2 2.25 lbs $7.90 $6.90 $1.00
203594 2018-07-26 $17.75 Priority Mail 2-Day 1 0.95 lbs $7.95 $6.89 $1.06
203596 2018-07-27 $49.62 First-Class Package International Service 1 0.65 lbs $30.33 $22.33 $8.00
203597 2018-07-27 $5.69 First-Class Package Service 2 0.02 lbs $3.71 $2.66 $1.05
203598 2018-07-28 $103.76 Ground 6 5.20 lbs $19.82 $18.44 $1.38
203602 2018-07-29 $107.45 First-Class Package International Service 6 2.24 lbs $41.01 $33.01 $8.00
203603 2018-07-29 $98.13 First-Class Package International Service 3 1.82 lbs $41.01 $33.01 $8.00
203604 2018-07-29 $95.49 First-Class Package International Service 2 1.95 lbs $41.01 $33.01 $8.00
203605 2018-07-29 $96.78 First-Class Package International Service 3 2.58 lbs $41.01 $48.93 $-7.92
203606 2018-07-29 $78.81 First-Class Package International Service 2 1.70 lbs $30.33 $22.33 $8.00
203607 2018-07-29 $78.81 First-Class Package International Service 2 1.70 lbs $30.33 $22.33 $8.00
203608 2018-07-29 $9.69 First-Class Package Service 2 0.07 lbs $3.71 $2.66 $1.05
203609 2018-07-29 $107.68 First-Class Package International Service 3 2.37 lbs $41.01 $48.93 $-7.92
203610 2018-07-29 $33.69 First-Class Package Service 4 0.54 lbs $5.23 $4.10 $1.13
203613 2018-07-29 $3.97 First-Class Package Service 1 0.30 lbs $3.97 $2.79 $1.18
203614 2018-07-29 $47.03 Priority Mail 2-Day Small Flat Rate Box 2 1.57 lbs $7.90 $6.85 $1.05
203616 2018-07-29 $6.68 First-Class Package Service 3 0.01 lbs $3.71 $2.66 $1.05
203618 2018-07-30 $47.17 Priority Mail 2-Day Medium Flat Rate Box 8 3.55 lbs $13.85 $12.45 $1.40
203619 2018-07-30 $42.63 Priority Mail 2-Day Padded Flat Rate Envelope 2 1.35 lbs $7.95 $6.85 $1.10
203620 2018-07-30 $53.93 Priority Mail 3-Day 14 3.11 lbs $15.03 $13.75 $1.28
203621 2018-07-30 $8.61 First-Class Package Service 10 0.10 lbs $3.71 $2.66 $1.05
203622 2018-07-30 $38.35 First-Class Package Service 2 0.65 lbs $4.71 $3.82 $0.89
203625 2018-07-30 $22.63 First-Class Package Service 1 0.25 lbs $3.84 $2.92 $0.92
203626 2018-07-30 $54.75 Priority Mail 3-Day 19 1.04 lbs $11.14 $7.28 $3.86
203627 2018-07-30 $22.64 Priority Mail 3-Day Flat Rate Envelope 6 1.14 lbs $7.40 $6.85 $0.55
203628 2018-07-30 $56.17 Priority Mail 2-Day Flat Rate Envelope 3 1.90 lbs $7.40 $6.85 $0.55
203631 2018-07-30 $115.00 Priority Mail International 1 3.95 lbs $61.01 $56.76 $4.25
203634 2018-07-31 $96.90 First-Class Package International Service 3 1.75 lbs $30.33 $33.01 $-2.68
203635 2018-07-31 $83.66 First-Class Package International Service 3 1.73 lbs $30.33 $22.33 $8.00
203636 2018-07-31 $9.49 First-Class Package Service 2 0.06 lbs $3.71 $2.66 $1.05
203637 2018-07-31 $88.59 First-Class Package International Service 4 1.80 lbs $30.33 $66.99 $-36.66
203639 2018-07-31 $95.51 Direct Link International 2 2.70 lbs $29.53 $8.43 $21.10
203644 2018-07-31 $9.18 First-Class Package Service 3 0.09 lbs $3.71 $2.66 $1.05
203646 2018-08-01 $20.45 First-Class Package Service 2 0.30 lbs $3.97 $3.18 $0.79
203648 2018-08-01 $45.52 Priority Mail 2-Day Padded Flat Rate Envelope 3 1.40 lbs $7.95 $6.85 $1.10
203650 2018-08-01 $20.37 First-Class Package Service 2 0.40 lbs $4.39 $3.66 $0.73
203653 2018-08-01 $11.70 First-Class Package Service 1 0.20 lbs $3.71 $3.18 $0.53
203654 2018-08-02 $48.39 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $7.90 $6.85 $1.05
203656 2018-08-02 $382.12 Priority Mail 3-Day 7 21.65 lbs $31.89 $24.89 $7.00
203657 2018-08-02 $38.22 Priority Mail 3-Day 10 2.50 lbs $9.32 $8.22 $1.10
203658 2018-08-02 $72.55 Priority Mail 2-Day 7 2.14 lbs $9.32 $7.40 $1.92
203659 2018-08-03 $16.55 First-Class Package Service 2 0.30 lbs $3.97 $3.18 $0.79
203663 2018-08-03 $46.68 Priority Mail 2-Day Flat Rate Envelope 2 1.55 lbs $7.40 $6.85 $0.55
203665 2018-08-03 $24.09 First-Class Package Service 1 0.35 lbs $4.10 $3.18 $0.92
203666 2018-08-03 $23.56 Priority Mail 2-Day 9 0.62 lbs $8.25 $7.40 $0.85
203667 2018-08-04 $57.18 Priority Mail 2-Day Flat Rate Envelope 2 1.70 lbs $7.40 $6.85 $0.55
203668 2018-08-04 $39.76 Direct Link International 10 0.16 lbs $20.36 $2.79 $17.57
203669 2018-08-04 $23.38 Priority Mail 2-Day Flat Rate Envelope 2 0.10 lbs $7.40 $6.85 $0.55
203671 2018-08-04 $11.70 First-Class Package Service 1 0.17 lbs $3.71 $2.79 $0.92
203675 2018-08-04 $9.69 First-Class Package Service 2 0.07 lbs $3.71 $2.66 $1.05
203677 2018-08-04 $19.70 Priority Mail 3-Day Flat Rate Envelope 6 0.21 lbs $7.40 $7.13 $0.27
203678 2018-08-05 $13.95 First-Class Package Service 2 0.29 lbs $3.97 $2.79 $1.18
203679 2018-08-05 $17.69 First-Class Package Service 2 0.07 lbs $3.71 $2.66 $1.05
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56