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 |
|---|---|---|---|---|---|---|---|---|
| 212640 | 2020-06-03 | $16.12 | First-Class Package Service | 1 | 0.40 lbs | $4.33 | $4.00 | $0.33 |
| 212643 | 2020-06-03 | $3.69 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $3.20 | $3.05 | $0.15 |
| 212644 | 2020-06-03 | $55.41 | First-Class Package Service | 1 | 0.75 lbs | $4.91 | $7.75 | $-2.84 |
| 212645 | 2020-06-04 | $13.15 | USPSFirstClass | 1 | 0.10 lbs | $4.59 | $3.18 | $1.41 |
| 212647 | 2020-06-03 | $44.15 | Priority Mail 2-Day | 5 | 2.33 lbs | $13.00 | $9.98 | $3.02 |
| 212648 | 2020-06-04 | $7.03 | USPSFirstClass | 1 | 0.20 lbs | $4.14 | $2.93 | $1.21 |
| 212649 | 2020-06-04 | $44.15 | Priority Mail 2-Day | 3 | 1.05 lbs | $9.61 | $8.76 | $0.85 |
| 212650 | 2020-06-04 | $9.52 | USPSFirstClass | 2 | 0.32 lbs | $4.81 | $3.25 | $1.56 |
| 212651 | 2020-06-04 | $24.35 | First-Class Package Service | 2 | 0.30 lbs | $3.97 | $4.32 | $-0.35 |
| 212652 | 2020-06-04 | $37.70 | USPSFirstClass | 1 | 0.70 lbs | $6.87 | $8.76 | $-1.89 |
| 212654 | 2020-06-04 | $8.44 | USPSFirstClass | 1 | 0.05 lbs | $4.24 | $3.05 | $1.19 |
| 212655 | 2020-06-04 | $7.28 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.50 | $3.05 | $0.45 |
| 212656 | 2020-06-04 | $20.12 | USPSFirstClass | 2 | 0.38 lbs | $5.10 | $2.84 | $2.26 |
| 212657 | 2020-06-04 | $30.19 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.40 lbs | $8.00 | $7.65 | $0.35 |
| 212658 | 2020-06-05 | $23.41 | USPSFirstClass | 2 | 0.16 lbs | $4.34 | $2.78 | $1.56 |
| 212659 | 2020-06-04 | $18.93 | First-Class Package Service | 3 | 0.34 lbs | $3.76 | $3.31 | $0.45 |
| 212660 | 2020-06-05 | $28.01 | USPSPriority | 1 | 1.00 lbs | $8.95 | $7.65 | $1.30 |
| 212661 | 2020-06-04 | $49.84 | Priority Mail 2-Day | 5 | 7.70 lbs | $9.30 | $7.65 | $1.65 |
| 212662 | 2020-06-04 | $7.89 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $3.18 | $0.32 |
| 212663 | 2020-06-05 | $5.40 | USPSFirstClass | 1 | 0.01 lbs | $4.10 | $3.05 | $1.05 |
| 212664 | 2020-06-05 | $24.99 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.00 | $7.65 | $0.35 |
| 212665 | 2020-06-05 | $204.16 | Ground | 2 | 16.85 lbs | $40.18 | $27.86 | $12.32 |
| 212666 | 2020-06-05 | $13.28 | USPSFirstClass | 1 | 0.08 lbs | $4.49 | $3.05 | $1.44 |
| 212667 | 2020-06-05 | $10.04 | USPSFirstClass | 1 | 0.05 lbs | $4.34 | $3.52 | $0.82 |
| 212668 | 2020-06-05 | $6.29 | First-Class Mail Stamped Letter | 6 | 0.06 lbs | $3.35 | $3.05 | $0.30 |
| 212669 | 2020-06-05 | $32.75 | First-Class Package Service | 2 | 0.50 lbs | $4.77 | $4.32 | $0.45 |
| 212670 | 2020-06-05 | $35.96 | Priority Mail 2-Day Flat Rate Envelope | 4 | 0.24 lbs | $8.00 | $7.65 | $0.35 |
| 212671 | 2020-06-05 | $6.69 | First-Class Mail Stamped Letter | 1 | 0.04 lbs | $3.20 | $2.93 | $0.27 |
| 212672 | 2020-06-06 | $11.60 | USPSFirstClass | 2 | 0.08 lbs | $4.07 | $2.78 | $1.29 |
| 212673 | 2020-06-05 | $26.29 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.35 lbs | $8.00 | $7.65 | $0.35 |
| 212674 | 2020-06-05 | $9.14 | First-Class Mail Stamped Letter | 1 | 0.15 lbs | $3.65 | $3.67 | $-0.02 |
| 212675 | 2020-06-05 | $17.98 | Priority Mail 3-Day Small Flat Rate Box | 2 | 0.96 lbs | $8.50 | $7.65 | $0.85 |
| 212676 | 2020-06-05 | $16.44 | Priority Mail 2-Day Flat Rate Envelope | 6 | 0.07 lbs | $8.00 | $7.65 | $0.35 |
| 212677 | 2020-06-05 | $28.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.40 lbs | $8.00 | $7.65 | $0.35 |
| 212678 | 2020-06-05 | $7.16 | First-Class Mail Stamped Letter | 4 | 0.02 lbs | $3.20 | $2.78 | $0.42 |
| 212679 | 2020-06-05 | $26.11 | First-Class Package Service | 2 | 0.47 lbs | $4.63 | $2.93 | $1.70 |
| 212680 | 2020-06-06 | $13.73 | USPSFirstClass | 1 | 0.05 lbs | $4.65 | $4.46 | $0.19 |
| 212682 | 2020-06-06 | $6.34 | USPSFirstClass | 1 | 0.01 lbs | $4.09 | $2.93 | $1.16 |
| 212684 | 2020-06-06 | $56.08 | Priority Mail 2-Day | 2 | 1.70 lbs | $13.00 | $12.15 | $0.85 |
| 212685 | 2020-06-06 | $9.15 | USPSFirstClass | 1 | 0.10 lbs | $4.17 | $2.84 | $1.33 |
| 212686 | 2020-06-06 | $43.38 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.40 lbs | $8.00 | $7.65 | $0.35 |
| 212687 | 2020-06-06 | $25.45 | Priority Mail 2-Day Flat Rate Envelope | 5 | 0.25 lbs | $8.00 | $7.15 | $0.85 |
| 212688 | 2020-06-06 | $51.49 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.50 lbs | $8.50 | $7.65 | $0.85 |
| 212689 | 2020-06-06 | $9.30 | USPSFirstClass | 1 | 0.20 lbs | $4.29 | $3.52 | $0.77 |
| 212690 | 2020-06-06 | $38.60 | Priority Mail 3-Day | 9 | 2.26 lbs | $10.39 | $7.75 | $2.64 |
| 212691 | 2020-06-06 | $23.70 | USPSFirstClass | 1 | 0.45 lbs | $5.54 | $4.00 | $1.54 |
| 212692 | 2020-06-06 | $53.93 | Priority Mail 2-Day Flat Rate Envelope | 7 | 0.42 lbs | $8.00 | $7.65 | $0.35 |
| 212694 | 2020-06-06 | $31.29 | Priority Mail 2-Day | 10 | 2.00 lbs | $10.39 | $8.76 | $1.63 |
| 212695 | 2020-06-06 | $4.98 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.50 | $2.84 | $0.66 |
| 212696 | 2020-06-07 | $12.43 | USPSFirstClass | 1 | 0.34 lbs | $5.09 | $4.08 | $1.01 |
| 212697 | 2020-06-06 | $147.30 | Direct Link International | 10 | 3.33 lbs | $37.30 | $9.07 | $28.23 |
| 212698 | 2020-06-07 | $19.95 | USPSFirstClass | 4 | 1.08 lbs | $8.39 | $8.92 | $-0.53 |
| 212699 | 2020-06-07 | $8.67 | USPSFirstClass | 1 | 0.45 lbs | $4.98 | $4.18 | $0.80 |
| 212700 | 2020-06-06 | $8.69 | First-Class Mail Stamped Letter | 1 | 0.15 lbs | $3.50 | $3.05 | $0.45 |
| 212701 | 2020-06-06 | $10.75 | First-Class Mail Stamped Letter | 1 | 0.09 lbs | $3.35 | $2.74 | $0.61 |
| 212702 | 2020-06-07 | $9.28 | USPSFirstClass | 1 | 0.10 lbs | $4.21 | $3.39 | $0.82 |
| 212703 | 2020-06-07 | $212.82 | Priority Mail International | 3 | 4.07 lbs | $74.25 | $70.30 | $3.95 |
| 212704 | 2020-06-07 | $6.14 | First-Class Mail Stamped Letter | 1 | 0.06 lbs | $3.35 | $2.93 | $0.42 |
| 212705 | 2020-06-07 | $30.37 | Priority Mail 3-Day | 2 | 1.90 lbs | $10.39 | $9.54 | $0.85 |
| 212706 | 2020-06-07 | $21.33 | USPSFirstClass | 1 | 0.95 lbs | $10.10 | $11.19 | $-1.09 |
| 212707 | 2020-06-07 | $50.48 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.70 lbs | $8.50 | $7.65 | $0.85 |
| 212708 | 2020-06-07 | $14.49 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $3.05 | $0.45 |
| 212709 | 2020-06-07 | $9.96 | First-Class Mail Stamped Letter | 4 | 0.13 lbs | $3.50 | $3.05 | $0.45 |
| 212710 | 2020-06-07 | $20.09 | USPSFirstClass | 1 | 0.95 lbs | $10.10 | $11.19 | $-1.09 |
| 212711 | 2020-06-07 | $44.41 | First-Class Package Service | 2 | 0.46 lbs | $4.63 | $4.18 | $0.45 |
| 212712 | 2020-06-07 | $7.33 | First-Class Mail Stamped Letter | 2 | 0.06 lbs | $3.35 | $3.05 | $0.30 |
| 212713 | 2020-06-07 | $4.82 | First-Class Mail Stamped Letter | 3 | 0.04 lbs | $3.35 | $2.84 | $0.51 |
| 212715 | 2020-06-07 | $15.20 | USPSFirstClass | 2 | 0.10 lbs | $4.22 | $3.31 | $0.91 |
| 212716 | 2020-06-07 | $47.38 | Priority Mail 2-Day | 1 | 2.35 lbs | $10.39 | $8.92 | $1.47 |
| 212717 | 2020-06-07 | $13.88 | First-Class Mail Stamped Letter | 2 | 0.15 lbs | $3.50 | $2.84 | $0.66 |
| 212718 | 2020-06-07 | $27.29 | Priority Mail 3-Day | 5 | 0.97 lbs | $10.84 | $9.99 | $0.85 |
| 212721 | 2020-06-07 | $29.91 | First-Class Package Service | 6 | 0.59 lbs | $4.77 | $4.32 | $0.45 |
| 212724 | 2020-06-08 | $193.83 | Ground | 19 | 26.57 lbs | $55.22 | $47.75 | $7.47 |
| 212725 | 2020-06-08 | $42.97 | Priority Mail 3-Day Flat Rate Envelope | 3 | 1.24 lbs | $8.00 | $7.65 | $0.35 |
| 212726 | 2020-06-08 | $5.34 | First-Class Mail Stamped Letter | 1 | 0.06 lbs | $3.35 | $2.84 | $0.51 |
| 212727 | 2020-06-08 | $11.44 | First-Class Package Service | 1 | 0.08 lbs | $3.97 | $3.52 | $0.45 |
| 212729 | 2020-06-08 | $14.63 | USPSFirstClass | 1 | 0.05 lbs | $4.40 | $3.31 | $1.09 |
| 212730 | 2020-06-08 | $35.15 | Direct Link International | 2 | 0.20 lbs | $21.17 | $9.35 | $11.82 |
| 212731 | 2020-06-08 | $12.32 | First-Class Mail Stamped Letter | 3 | 0.09 lbs | $3.35 | $2.84 | $0.51 |
| 212733 | 2020-06-08 | $33.99 | USPSFirstClass | 3 | 0.20 lbs | $12.40 | $7.02 | $5.38 |
| 212736 | 2020-06-08 | $38.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.15 lbs | $8.50 | $7.65 | $0.85 |
| 212737 | 2020-06-08 | $31.78 | Priority Mail 2-Day | 2 | 0.68 lbs | $9.00 | $8.15 | $0.85 |
| 212738 | 2020-06-08 | $48.09 | Priority Mail 1-Day | 1 | 1.10 lbs | $8.49 | $7.64 | $0.85 |
| 212739 | 2020-06-09 | $11.34 | USPSFirstClass | 1 | 0.19 lbs | $4.35 | $2.93 | $1.42 |
| 212741 | 2020-06-08 | $36.10 | Priority Mail 2-Day | 1 | 0.57 lbs | $9.61 | $7.80 | $1.81 |
| 212742 | 2020-06-08 | $24.48 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.00 | $7.75 | $0.25 |
| 212743 | 2020-06-08 | $6.33 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.35 | $2.84 | $0.51 |
| 212744 | 2020-06-09 | $4.19 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $3.20 | $2.78 | $0.42 |
| 212745 | 2020-06-09 | $7.64 | First-Class Mail Stamped Letter | 1 | 0.02 lbs | $3.20 | $2.74 | $0.46 |
| 212746 | 2020-06-09 | $28.12 | Priority Mail 3-Day | 1 | 0.60 lbs | $8.83 | $7.98 | $0.85 |
| 212747 | 2020-06-09 | $39.99 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.20 lbs | $8.50 | $7.65 | $0.85 |
| 212750 | 2020-06-09 | $19.32 | USPSFirstClass | 1 | 0.95 lbs | $8.50 | $8.12 | $0.38 |
| 212751 | 2020-06-09 | $51.59 | Priority Mail 3-Day Padded Flat Rate Envelope | 1 | 1.15 lbs | $8.60 | $8.12 | $0.48 |
| 212752 | 2020-06-09 | $24.48 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.00 | $7.75 | $0.25 |
| 212757 | 2020-06-09 | $24.59 | First-Class Mail Stamped Letter | 6 | 0.27 lbs | $7.15 | $2.84 | $4.31 |
| 212759 | 2020-06-09 | $23.72 | First-Class Package Service | 1 | 0.60 lbs | $4.43 | $5.40 | $-0.97 |
| 212760 | 2020-06-10 | $12.06 | USPSFirstClass | 1 | 0.20 lbs | $4.39 | $4.32 | $0.07 |
| 212762 | 2020-06-09 | $30.36 | Priority Mail 2-Day | 3 | 1.61 lbs | $10.39 | $9.54 | $0.85 |
| 212763 | 2020-06-09 | $5.31 | First-Class Mail Stamped Letter | 4 | 0.04 lbs | $3.35 | $3.25 | $0.10 |
| 212764 | 2020-06-10 | $11.24 | USPSFirstClass | 1 | 0.19 lbs | $4.25 | $2.78 | $1.47 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |