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 |
|---|---|---|---|---|---|---|---|---|
| 231500 | 2023-04-06 | $13.80 | First-Class Package Service | 2 | 0.10 lbs | $5.17 | $3.97 | $1.20 |
| 231501 | 2023-04-06 | $9.24 | USPS First Class | 1 | 0.01 lbs | $5.25 | $4.13 | $1.12 |
| 231502 | 2023-04-05 | $9.09 | USPS First Class | 1 | 0.02 lbs | $5.10 | $3.90 | $1.20 |
| 231503 | 2023-04-05 | $8.54 | Standard Shipping | 1 | 0.05 lbs | $5.15 | $3.97 | $1.18 |
| 231504 | 2023-04-06 | $78.39 | Priority Mail Medium Flat Rate Box | 1 | 3.05 lbs | $16.40 | $8.30 | $8.10 |
| 231505 | 2023-04-06 | $9.24 | USPS First Class | 1 | 0.01 lbs | $5.25 | $4.13 | $1.12 |
| 231510 | 2023-04-08 | $21.06 | First-Class Package Service | 4 | 0.10 lbs | $5.10 | $4.24 | $0.86 |
| 231512 | 2023-04-09 | $51.47 | First-Class Package International Service | 1 | 0.80 lbs | $30.28 | $22.23 | $8.05 |
| 231513 | 2023-04-10 | $24.99 | First-Class Package Service | 1 | 0.35 lbs | $5.40 | $4.20 | $1.20 |
| 231514 | 2023-04-08 | $14.82 | USPS Parcel Select Ground | 1 | 0.10 lbs | $9.03 | $8.56 | $0.47 |
| 231515 | 2023-04-10 | $134.54 | Priority Mail | 3 | 6.67 lbs | $12.07 | $12.07 | $0.00 |
| 231516 | 2023-04-10 | $50.83 | Priority Mail | 1 | 1.25 lbs | $9.84 | $8.10 | $1.74 |
| 231517 | 2023-04-10 | $31.15 | Priority Mail | 2 | 4.60 lbs | $11.37 | $8.05 | $3.32 |
| 231518 | 2023-04-10 | $11.34 | USPS First Class | 1 | 0.10 lbs | $5.15 | $3.97 | $1.18 |
| 231519 | 2023-04-11 | $78.40 | Ground | 8 | 0.88 lbs | $22.69 | $17.99 | $4.70 |
| 231520 | 2023-04-11 | $37.46 | Priority Mail | 3 | 1.20 lbs | $10.49 | $8.30 | $2.19 |
| 231521 | 2023-04-11 | $18.34 | USPS First Class | 1 | 0.30 lbs | $5.75 | $4.31 | $1.44 |
| 231523 | 2023-04-13 | $18.60 | USPS Parcel Select Ground | 1 | 0.50 lbs | $8.61 | $8.61 | $0.00 |
| 231524 | 2023-04-12 | $9.24 | USPS First Class | 1 | 0.07 lbs | $5.25 | $4.13 | $1.12 |
| 231525 | 2023-04-12 | $9.24 | USPS First Class | 1 | 0.07 lbs | $5.25 | $4.13 | $1.12 |
| 231526 | 2023-04-12 | $9.64 | USPS Shipping | 1 | 0.12 lbs | $5.15 | $4.13 | $1.02 |
| 231527 | 2023-04-13 | $18.65 | First-Class Package Service | 6 | 0.27 lbs | $5.51 | $4.31 | $1.20 |
| 231528 | 2023-04-13 | $10.29 | USPS First Class | 1 | 0.03 lbs | $5.00 | $3.75 | $1.25 |
| 231529 | 2023-04-13 | $28.64 | Priority Mail Flat Rate Envelope | 1 | 0.80 lbs | $9.15 | $8.30 | $0.85 |
| 231531 | 2023-04-13 | $9.32 | First-Class Package Service | 3 | 0.03 lbs | $5.10 | $3.90 | $1.20 |
| 231535 | 2023-04-16 | $16.60 | First-Class Package Service | 1 | 0.35 lbs | $5.64 | $5.33 | $0.31 |
| 231536 | 2023-04-16 | $21.00 | Priority Mail | 6 | 0.07 lbs | $10.06 | $8.10 | $1.96 |
| 231537 | 2023-04-16 | $27.02 | First-Class Package Service | 1 | 0.60 lbs | $5.83 | $4.88 | $0.95 |
| 231538 | 2023-04-16 | $8.34 | First-Class Package Service | 1 | 0.07 lbs | $5.10 | $3.90 | $1.20 |
| 231539 | 2023-04-16 | $15.24 | USPS First Class | 1 | 0.05 lbs | $5.25 | $4.13 | $1.12 |
| 231540 | 2023-04-16 | $11.84 | USPS First Class | 1 | 0.10 lbs | $5.15 | $3.97 | $1.18 |
| 231541 | 2023-04-15 | $10.04 | USPS First Class | 1 | 0.05 lbs | $5.25 | $4.13 | $1.12 |
| 231542 | 2023-04-15 | $11.94 | USPS First Class | 1 | 0.10 lbs | $5.25 | $4.13 | $1.12 |
| 231543 | 2023-04-14 | $11.84 | USPS First Class | 1 | 0.07 lbs | $5.15 | $3.97 | $1.18 |
| 231544 | 2023-04-17 | $14.99 | USPS First Class | 1 | 0.05 lbs | $5.00 | $4.15 | $0.85 |
| 231545 | 2023-04-17 | $13.08 | First-Class Package Service | 1 | 0.15 lbs | $5.29 | $4.09 | $1.20 |
| 231546 | 2023-04-17 | $18.71 | First-Class Package Service | 2 | 0.15 lbs | $5.33 | $4.13 | $1.20 |
| 231549 | 2023-04-18 | $22.94 | USPS Priority Mail | 1 | 1.00 lbs | $10.95 | $9.94 | $1.01 |
| 231550 | 2023-04-18 | $24.74 | USPS Shipping | 1 | 0.35 lbs | $5.75 | $5.04 | $0.71 |
| 231551 | 2023-04-18 | $23.32 | First-Class Package Service - Retail | 2 | 0.60 lbs | $7.40 | $7.21 | $0.19 |
| 231552 | 2023-04-18 | $13.56 | First-Class Package Service | 2 | 0.08 lbs | $5.33 | $4.13 | $1.20 |
| 231553 | 2023-04-19 | $75.80 | Ground | 8 | 0.08 lbs | $27.88 | $19.32 | $8.56 |
| 231554 | 2023-04-19 | $21.85 | Priority Mail | 4 | 0.91 lbs | $12.39 | $9.94 | $2.45 |
| 231556 | 2023-04-20 | $17.22 | First-Class Package Service | 1 | 0.02 lbs | $5.17 | $4.31 | $0.86 |
| 231557 | 2023-04-20 | $15.24 | USPS First Class | 1 | 0.05 lbs | $5.25 | $4.44 | $0.81 |
| 231558 | 2023-04-20 | $10.29 | USPS First Class | 1 | 0.03 lbs | $5.00 | $3.75 | $1.25 |
| 231559 | 2023-04-19 | $14.39 | USPS First Class | 1 | 0.55 lbs | $6.40 | $4.88 | $1.52 |
| 231561 | 2023-04-20 | $13.34 | USPS Shipping | 1 | 0.08 lbs | $5.15 | $4.13 | $1.02 |
| 231562 | 2023-04-21 | $28.06 | First-Class Package Service | 3 | 0.72 lbs | $7.39 | $7.74 | $-0.35 |
| 231565 | 2023-04-23 | $15.24 | USPS First Class | 1 | 0.05 lbs | $5.25 | $4.13 | $1.12 |
| 231566 | 2023-04-22 | $10.64 | USPS First Class | 1 | 0.23 lbs | $5.25 | $4.44 | $0.81 |
| 231572 | 2023-04-25 | $29.09 | First-Class Package Service | 4 | 0.80 lbs | $7.55 | $8.61 | $-1.06 |
| 231573 | 2023-04-24 | $15.24 | USPS First Class | 1 | 0.05 lbs | $5.25 | $4.13 | $1.12 |
| 231574 | 2023-04-25 | $29.88 | USPS Shipping | 2 | 0.10 lbs | $10.30 | $3.81 | $6.49 |
| 231576 | 2023-04-25 | $53.89 | First-Class Package Service | 1 | 0.56 lbs | $6.01 | $4.81 | $1.20 |
| 231577 | 2023-04-25 | $85.79 | Priority Mail Medium Flat Rate Box | 3 | 3.94 lbs | $16.40 | $10.85 | $5.55 |
| 231578 | 2023-04-26 | $13.74 | USPS First Class | 1 | 0.21 lbs | $5.25 | $4.13 | $1.12 |
| 231579 | 2023-04-25 | $11.34 | USPS First Class | 1 | 0.10 lbs | $5.15 | $3.97 | $1.18 |
| 231580 | 2023-04-25 | $11.79 | USPS First Class | 1 | 0.05 lbs | $5.10 | $3.90 | $1.20 |
| 231581 | 2023-04-25 | $15.14 | USPS First Class | 1 | 0.05 lbs | $5.15 | $3.97 | $1.18 |
| 231582 | 2023-04-26 | $8.88 | USPS Shipping | 1 | 0.06 lbs | $5.15 | $3.75 | $1.40 |
| 231583 | 2023-04-25 | $10.14 | USPS Shipping | 1 | 0.20 lbs | $5.15 | $4.44 | $0.71 |
| 231585 | 2023-04-26 | $10.51 | First-Class Package Service | 3 | 0.23 lbs | $5.40 | $4.20 | $1.20 |
| 231587 | 2023-04-26 | $11.80 | First-Class Package Service | 5 | 0.05 lbs | $5.10 | $4.24 | $0.86 |
| 231588 | 2023-04-26 | $11.74 | USPS First Class | 1 | 0.15 lbs | $5.05 | $3.81 | $1.24 |
| 231589 | 2023-04-27 | $14.32 | First-Class Package Service | 1 | 0.07 lbs | $5.33 | $4.13 | $1.20 |
| 231590 | 2023-04-27 | $15.00 | First-Class Package Service | 1 | 0.30 lbs | $5.51 | $4.31 | $1.20 |
| 231591 | 2023-04-27 | $9.75 | First-Class Package Service | 1 | 0.03 lbs | $5.01 | $3.81 | $1.20 |
| 231592 | 2023-04-28 | $9.04 | USPS First Class | 1 | 0.08 lbs | $5.05 | $3.81 | $1.24 |
| 231593 | 2023-04-27 | $18.94 | USPS First Class | 1 | 0.30 lbs | $5.75 | $4.31 | $1.44 |
| 231595 | 2023-04-28 | $18.34 | Standard Shipping | 1 | 0.25 lbs | $5.15 | $6.07 | $-0.92 |
| 231596 | 2023-04-28 | $16.20 | First-Class Package Service | 2 | 0.47 lbs | $6.12 | $5.17 | $0.95 |
| 231597 | 2023-04-29 | $17.51 | First-Class Package Service | 1 | 0.44 lbs | $5.76 | $4.81 | $0.95 |
| 231599 | 2023-04-29 | $89.21 | Priority Mail Medium Flat Rate Box | 1 | 2.10 lbs | $16.40 | $8.10 | $8.30 |
| 231600 | 2023-04-28 | $14.99 | USPS First Class | 1 | 0.05 lbs | $5.00 | $3.75 | $1.25 |
| 231601 | 2023-04-29 | $12.36 | USPS Shipping | 1 | 0.10 lbs | $5.15 | $3.97 | $1.18 |
| 231602 | 2023-04-30 | $16.78 | First-Class Package Service | 5 | 0.12 lbs | $5.33 | $4.13 | $1.20 |
| 231604 | 2023-04-30 | $13.83 | First-Class Package Service | 3 | 0.15 lbs | $4.86 | $3.66 | $1.20 |
| 231606 | 2023-04-30 | $10.94 | USPS First Class | 1 | 0.05 lbs | $5.15 | $3.97 | $1.18 |
| 231607 | 2023-04-29 | $15.29 | USPS First Class | 1 | 0.20 lbs | $5.00 | $4.15 | $0.85 |
| 231608 | 2023-05-01 | $7.94 | USPS Shipping | 1 | 0.06 lbs | $5.15 | $3.97 | $1.18 |
| 231609 | 2023-05-01 | $15.09 | USPS First Class | 1 | 0.05 lbs | $5.10 | $4.24 | $0.86 |
| 231610 | 2023-05-01 | $15.93 | First-Class Package Service - Retail | 2 | 0.30 lbs | $6.50 | $6.75 | $-0.25 |
| 231612 | 2023-05-01 | $77.26 | Priority Mail Medium Flat Rate Box | 4 | 5.97 lbs | $16.40 | $8.30 | $8.10 |
| 231613 | 2023-05-01 | $19.93 | First-Class Package Service | 3 | 0.22 lbs | $5.29 | $4.09 | $1.20 |
| 231617 | 2023-05-03 | $49.64 | Priority Mail Small Flat Rate Box | 1 | 1.20 lbs | $9.65 | $8.10 | $1.55 |
| 231618 | 2023-05-03 | $7.19 | USPS First Class | 1 | 0.05 lbs | $5.00 | $3.75 | $1.25 |
| 231619 | 2023-05-02 | $8.99 | USPS First Class | 1 | 0.02 lbs | $5.00 | $3.75 | $1.25 |
| 231620 | 2023-05-03 | $23.34 | USPS Shipping | 1 | 0.19 lbs | $5.15 | $4.44 | $0.71 |
| 231621 | 2023-05-02 | $9.44 | USPS Shipping | 1 | 0.07 lbs | $5.15 | $3.90 | $1.25 |
| 231624 | 2023-05-04 | $86.63 | Priority Mail | 1 | 3.95 lbs | $18.64 | $17.54 | $1.10 |
| 231627 | 2023-05-04 | $31.43 | First-Class Package Service | 2 | 0.45 lbs | $6.37 | $5.17 | $1.20 |
| 231628 | 2023-05-04 | $10.64 | USPS First Class | 1 | 0.23 lbs | $5.25 | $4.13 | $1.12 |
| 231629 | 2023-05-04 | $112.15 | Priority Mail Flat Rate Envelope | 4 | 1.00 lbs | $9.15 | $8.10 | $1.05 |
| 231631 | 2023-05-04 | $7.76 | First-Class Package Service | 1 | 0.20 lbs | $5.44 | $4.24 | $1.20 |
| 231632 | 2023-05-05 | $52.55 | First-Class Package International Service | 1 | 0.17 lbs | $23.01 | $14.96 | $8.05 |
| 231633 | 2023-05-05 | $27.30 | USPS Shipping | 1 | 1.60 lbs | $6.45 | $4.35 | $2.10 |
| 231634 | 2023-05-04 | $71.39 | USPS Shipping | 1 | 1.20 lbs | $16.40 | $7.59 | $8.81 |
| 231635 | 2023-05-05 | $86.63 | Priority Mail | 1 | 3.95 lbs | $18.64 | $17.54 | $1.10 |
| 231637 | 2023-05-05 | $14.52 | USPS Parcel Select Ground | 1 | 0.50 lbs | $7.53 | $6.50 | $1.03 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |