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)
table-success)
table-warning)
table-danger)
oc_order.date_added.21021 matching order(s)
| Order ID ▲ | Date | Order Total | Shipping Method | # Products | Total Weight | Shipping Charged | Shipping Paid | Profit |
|---|---|---|---|---|---|---|---|---|
| 214605 | 2020-08-17 | $7.79 | First-Class Mail Stamped Letter | 6 | 0.06 lbs | $3.35 | $3.05 | $0.30 |
| 214606 | 2020-08-17 | $21.09 | First-Class Package Service | 1 | 0.60 lbs | $4.43 | $4.18 | $0.25 |
| 214607 | 2020-08-17 | $13.92 | USPSFirstClass | 2 | 0.20 lbs | $4.17 | $2.84 | $1.33 |
| 214608 | 2020-08-17 | $49.33 | Ground | 3 | 1.10 lbs | $19.56 | $15.92 | $3.64 |
| 214609 | 2020-08-17 | $48.55 | First-Class Package Service | 2 | 0.70 lbs | $5.57 | $4.00 | $1.57 |
| 214610 | 2020-08-17 | $22.96 | First-Class Package Service | 16 | 0.18 lbs | $4.12 | $3.18 | $0.94 |
| 214611 | 2020-08-17 | $22.46 | USPSFirstClass | 1 | 0.40 lbs | $5.69 | $4.32 | $1.37 |
| 214612 | 2020-08-17 | $70.98 | Priority Mail 2-Day | 1 | 3.90 lbs | $16.99 | $18.47 | $-1.48 |
| 214613 | 2020-08-17 | $6.52 | First-Class Package Service | 1 | 0.05 lbs | $3.63 | $3.18 | $0.45 |
| 214614 | 2020-08-17 | $22.13 | First-Class Package Service | 1 | 0.30 lbs | $3.84 | $3.39 | $0.45 |
| 214615 | 2020-08-17 | $13.09 | USPSFirstClass | 1 | 0.05 lbs | $4.29 | $2.78 | $1.51 |
| 214616 | 2020-08-17 | $23.70 | USPSFirstClass | 2 | 0.15 lbs | $8.50 | $2.78 | $5.72 |
| 214619 | 2020-08-17 | $115.07 | Priority Mail 2-Day | 70 | 5.08 lbs | $25.37 | $12.10 | $13.27 |
| 214620 | 2020-08-17 | $38.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.50 | $7.65 | $0.85 |
| 214623 | 2020-08-17 | $7.18 | First-Class Mail Stamped Letter | 2 | 0.04 lbs | $3.20 | $2.93 | $0.27 |
| 214624 | 2020-08-17 | $43.49 | Priority Mail 2-Day | 6 | 1.32 lbs | $8.97 | $8.12 | $0.85 |
| 214625 | 2020-08-17 | $9.36 | First-Class Package Service | 2 | 0.06 lbs | $3.38 | $2.93 | $0.45 |
| 214626 | 2020-08-17 | $9.21 | First-Class Package Service | 2 | 0.09 lbs | $3.23 | $2.78 | $0.45 |
| 214627 | 2020-08-17 | $8.84 | USPSFirstClass | 1 | 0.05 lbs | $4.15 | $2.84 | $1.31 |
| 214628 | 2020-08-17 | $275.62 | Priority Mail 2-Day | 1 | 14.40 lbs | $21.63 | $20.78 | $0.85 |
| 214630 | 2020-08-17 | $7.84 | First-Class Package Service | 4 | 0.04 lbs | $3.38 | $2.93 | $0.45 |
| 214631 | 2020-08-17 | $36.79 | Priority Mail 3-Day Flat Rate Envelope | 1 | 1.10 lbs | $8.00 | $8.05 | $-0.05 |
| 214632 | 2020-08-17 | $23.74 | First-Class Package Service | 2 | 0.35 lbs | $3.76 | $3.31 | $0.45 |
| 214633 | 2020-08-17 | $36.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.50 | $7.65 | $0.85 |
| 214634 | 2020-08-18 | $7.08 | USPSFirstClass | 1 | 0.01 lbs | $4.07 | $2.84 | $1.23 |
| 214635 | 2020-08-18 | $67.02 | Priority Mail 3-Day Flat Rate Envelope | 2 | 2.60 lbs | $8.00 | $7.75 | $0.25 |
| 214637 | 2020-08-18 | $100.54 | Priority Mail 2-Day | 5 | 2.80 lbs | $10.39 | $7.75 | $2.64 |
| 214638 | 2020-08-18 | $13.49 | First-Class Package Service | 1 | 0.13 lbs | $3.50 | $3.52 | $-0.02 |
| 214639 | 2020-08-18 | $23.26 | USPSFirstClass | 1 | 0.40 lbs | $5.54 | $4.08 | $1.46 |
| 214640 | 2020-08-18 | $14.65 | USPSFirstClass | 1 | 0.10 lbs | $4.51 | $3.05 | $1.46 |
| 214644 | 2020-08-18 | $34.03 | Priority Mail 3-Day | 1 | 0.75 lbs | $8.41 | $7.56 | $0.85 |
| 214645 | 2020-08-18 | $10.25 | USPSFirstClass | 1 | 0.10 lbs | $4.26 | $2.93 | $1.33 |
| 214646 | 2020-08-18 | $69.91 | Priority Mail 2-Day | 1 | 3.50 lbs | $9.92 | $9.39 | $0.53 |
| 214648 | 2020-08-18 | $25.24 | First-Class Package Service | 1 | 0.65 lbs | $5.95 | $5.70 | $0.25 |
| 214650 | 2020-08-18 | $44.01 | Priority Mail 2-Day | 1 | 1.85 lbs | $9.44 | $8.21 | $1.23 |
| 214655 | 2020-08-18 | $18.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.07 lbs | $8.50 | $7.65 | $0.85 |
| 214657 | 2020-08-18 | $17.79 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.35 lbs | $8.00 | $7.65 | $0.35 |
| 214664 | 2020-08-18 | $11.93 | Priority Mail 3-Day Small Flat Rate Box | 7 | 0.07 lbs | $8.50 | $7.15 | $1.35 |
| 214665 | 2020-08-19 | $10.02 | USPSFirstClass | 1 | 0.05 lbs | $4.24 | $2.93 | $1.31 |
| 214667 | 2020-08-18 | $48.17 | Priority Mail 2-Day | 2 | 1.35 lbs | $10.39 | $8.76 | $1.63 |
| 214668 | 2020-08-19 | $13.22 | USPSFirstClass | 1 | 0.05 lbs | $4.39 | $2.93 | $1.46 |
| 214669 | 2020-08-19 | $29.46 | Priority Mail 2-Day Flat Rate Envelope | 4 | 1.08 lbs | $8.00 | $7.65 | $0.35 |
| 214674 | 2020-08-19 | $23.32 | USPSFirstClass | 1 | 0.40 lbs | $5.59 | $4.18 | $1.41 |
| 214678 | 2020-08-19 | $28.50 | USPSFirstClass | 4 | 0.08 lbs | $16.55 | $3.39 | $13.16 |
| 214679 | 2020-08-19 | $22.31 | First-Class Package Service | 1 | 0.65 lbs | $5.65 | $5.40 | $0.25 |
| 214681 | 2020-08-19 | $31.64 | First-Class Package Service | 1 | 0.70 lbs | $5.57 | $5.12 | $0.45 |
| 214682 | 2020-08-19 | $9.33 | USPSFirstClass | 1 | 0.05 lbs | $4.44 | $3.18 | $1.26 |
| 214683 | 2020-08-19 | $29.61 | USPSFirstClass | 1 | 0.80 lbs | $7.60 | $7.75 | $-0.15 |
| 214684 | 2020-08-19 | $64.75 | Priority Mail 2-Day | 15 | 1.64 lbs | $12.04 | $7.75 | $4.29 |
| 214688 | 2020-08-19 | $8.36 | First-Class Package Service | 2 | 0.10 lbs | $3.38 | $2.93 | $0.45 |
| 214691 | 2020-08-19 | $6.24 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.18 | $0.17 |
| 214692 | 2020-08-19 | $22.03 | Priority Mail 3-Day | 1 | 0.95 lbs | $12.04 | $11.19 | $0.85 |
| 214693 | 2020-08-19 | $6.83 | First-Class Mail Stamped Letter | 2 | 0.04 lbs | $3.35 | $3.05 | $0.30 |
| 214694 | 2020-08-19 | $217.58 | Priority Mail 2-Day | 1 | 14.05 lbs | $24.59 | $22.34 | $2.25 |
| 214696 | 2020-08-19 | $21.70 | First-Class Package Service | 1 | 0.45 lbs | $4.91 | $4.46 | $0.45 |
| 214697 | 2020-08-19 | $13.47 | First-Class Package Service | 3 | 0.18 lbs | $3.70 | $3.25 | $0.45 |
| 214699 | 2020-08-19 | $29.35 | First-Class Package Service | 10 | 0.50 lbs | $4.45 | $3.25 | $1.20 |
| 214701 | 2020-08-20 | $22.41 | USPSPriority | 1 | 1.78 lbs | $10.44 | $8.59 | $1.85 |
| 214702 | 2020-08-20 | $20.65 | USPSFirstClass | 2 | 1.10 lbs | $11.68 | $11.13 | $0.55 |
| 214705 | 2020-08-20 | $68.47 | Priority Mail 2-Day | 2 | 4.26 lbs | $11.49 | $8.92 | $2.57 |
| 214706 | 2020-08-20 | $43.24 | First-Class Package Service | 1 | 0.45 lbs | $4.25 | $4.00 | $0.25 |
| 214707 | 2020-08-20 | $14.54 | First-Class Package Service | 2 | 0.20 lbs | $3.76 | $2.84 | $0.92 |
| 214708 | 2020-08-20 | $39.92 | Priority Mail 2-Day | 16 | 2.58 lbs | $11.18 | $10.33 | $0.85 |
| 214710 | 2020-08-20 | $145.75 | Priority Mail 2-Day | 4 | 4.45 lbs | $16.99 | $13.60 | $3.39 |
| 214711 | 2020-08-20 | $18.11 | USPSFirstClass | 1 | 0.15 lbs | $4.62 | $3.39 | $1.23 |
| 214712 | 2020-08-20 | $15.76 | First-Class Package Service | 1 | 0.35 lbs | $3.97 | $3.52 | $0.45 |
| 214713 | 2020-08-20 | $20.83 | Priority Mail 2-Day | 1 | 0.95 lbs | $10.84 | $9.99 | $0.85 |
| 214714 | 2020-08-20 | $19.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.45 lbs | $8.00 | $8.05 | $-0.05 |
| 214715 | 2020-08-20 | $4.68 | First-Class Package Service | 1 | 0.03 lbs | $3.19 | $2.74 | $0.45 |
| 214717 | 2020-08-20 | $48.58 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 2.10 lbs | $8.60 | $7.65 | $0.95 |
| 214719 | 2020-08-20 | $41.28 | Priority Mail 2-Day | 1 | 1.20 lbs | $8.49 | $7.65 | $0.84 |
| 214720 | 2020-08-21 | $49.17 | USPSFirstClass | 1 | 0.45 lbs | $6.95 | $3.18 | $3.77 |
| 214721 | 2020-08-20 | $54.69 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.42 lbs | $8.00 | $7.75 | $0.25 |
| 214723 | 2020-08-20 | $68.61 | Priority Mail 3-Day | 4 | 1.60 lbs | $10.84 | $10.42 | $0.42 |
| 214724 | 2020-08-20 | $18.96 | Priority Mail 2-Day | 1 | 0.95 lbs | $8.97 | $8.12 | $0.85 |
| 214725 | 2020-08-20 | $15.55 | First-Class Package Service | 1 | 0.30 lbs | $3.76 | $3.31 | $0.45 |
| 214726 | 2020-08-20 | $237.58 | Ground | 1 | 13.15 lbs | $27.59 | $19.36 | $8.23 |
| 214727 | 2020-08-21 | $12.48 | USPSFirstClass | 1 | 0.20 lbs | $4.59 | $3.18 | $1.41 |
| 214728 | 2020-08-21 | $6.24 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.05 | $0.30 |
| 214729 | 2020-08-21 | $71.02 | Priority Mail 3-Day Medium Flat Rate Box | 3 | 1.90 lbs | $14.45 | $7.65 | $6.80 |
| 214734 | 2020-08-21 | $87.98 | Priority Mail 2-Day | 2 | 2.79 lbs | $13.00 | $7.75 | $5.25 |
| 214735 | 2020-08-21 | $70.18 | Priority Mail 2-Day Small Flat Rate Box | 4 | 2.60 lbs | $8.50 | $7.65 | $0.85 |
| 214737 | 2020-08-21 | $237.08 | Priority Mail 2-Day | 7 | 8.50 lbs | $38.63 | $37.78 | $0.85 |
| 214738 | 2020-08-21 | $13.73 | Priority Mail 2-Day | 10 | 0.10 lbs | $8.83 | $2.93 | $5.90 |
| 214739 | 2020-08-21 | $14.97 | First-Class Package Service | 1 | 0.25 lbs | $3.97 | $3.52 | $0.45 |
| 214740 | 2020-08-21 | $14.33 | First-Class Package Service | 1 | 0.30 lbs | $4.12 | $4.46 | $-0.34 |
| 214742 | 2020-08-21 | $22.03 | Priority Mail 3-Day | 1 | 0.95 lbs | $12.04 | $11.19 | $0.85 |
| 214744 | 2020-08-21 | $12.26 | First-Class Package Service | 4 | 0.14 lbs | $3.70 | $3.25 | $0.45 |
| 214746 | 2020-08-21 | $15.41 | First-Class Package Service | 3 | 0.19 lbs | $3.84 | $2.93 | $0.91 |
| 214747 | 2020-08-21 | $19.61 | First-Class Package Service | 1 | 0.35 lbs | $4.12 | $4.71 | $-0.59 |
| 214748 | 2020-08-21 | $11.54 | USPSFirstClass | 1 | 0.05 lbs | $4.55 | $3.18 | $1.37 |
| 214750 | 2020-08-21 | $49.97 | Priority Mail 3-Day | 2 | 1.20 lbs | $11.39 | $10.53 | $0.86 |
| 214751 | 2020-08-21 | $15.98 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.10 lbs | $8.00 | $7.65 | $0.35 |
| 214752 | 2020-08-21 | $19.41 | First-Class Package Service | 2 | 0.17 lbs | $3.64 | $2.93 | $0.71 |
| 214753 | 2020-08-22 | $9.44 | USPSFirstClass | 1 | 0.45 lbs | $5.08 | $4.32 | $0.76 |
| 214754 | 2020-08-21 | $38.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.40 lbs | $8.50 | $7.65 | $0.85 |
| 214755 | 2020-08-22 | $6.19 | USPSFirstClass | 1 | 0.01 lbs | $3.99 | $2.78 | $1.21 |
| 214756 | 2020-08-21 | $9.01 | First-Class Package Service | 3 | 0.13 lbs | $3.64 | $3.39 | $0.25 |
| 214757 | 2020-08-22 | $6.03 | USPSFirstClass | 1 | 0.01 lbs | $4.14 | $3.05 | $1.09 |
| 214758 | 2020-08-22 | $11.86 | USPSFirstClass | 2 | 0.06 lbs | $4.17 | $2.93 | $1.24 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |