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 |
|---|---|---|---|---|---|---|---|---|
| 214447 | 2020-08-12 | $11.70 | USPSFirstClass | 1 | 0.20 lbs | $4.24 | $2.78 | $1.46 |
| 214453 | 2020-08-11 | $20.39 | Priority Mail 2-Day Flat Rate Envelope | 21 | 0.36 lbs | $8.00 | $7.65 | $0.35 |
| 214454 | 2020-08-11 | $22.98 | Priority Mail 3-Day Flat Rate Envelope | 2 | 0.18 lbs | $8.00 | $7.56 | $0.44 |
| 214456 | 2020-08-12 | $9.08 | First-Class Mail Stamped Letter | 2 | 0.12 lbs | $3.50 | $2.78 | $0.72 |
| 214458 | 2020-08-12 | $6.49 | First-Class Mail Stamped Letter | 1 | 0.15 lbs | $3.50 | $2.84 | $0.66 |
| 214460 | 2020-08-12 | $13.37 | First-Class Package Service | 1 | 0.13 lbs | $3.38 | $2.93 | $0.45 |
| 214461 | 2020-08-12 | $93.94 | Direct Link International | 7 | 1.47 lbs | $27.21 | $28.93 | $-1.72 |
| 214462 | 2020-08-12 | $8.90 | USPSFirstClass | 1 | 0.15 lbs | $4.12 | $2.78 | $1.34 |
| 214463 | 2020-08-12 | $41.36 | Priority Mail 2-Day | 5 | 0.92 lbs | $9.61 | $8.76 | $0.85 |
| 214464 | 2020-08-12 | $22.24 | USPSFirstClass | 1 | 0.30 lbs | $5.50 | $3.31 | $2.19 |
| 214471 | 2020-08-12 | $20.59 | USPSFirstClass | 2 | 0.77 lbs | $8.29 | $8.12 | $0.17 |
| 214472 | 2020-08-12 | $47.68 | Priority Mail 2-Day Flat Rate Envelope | 32 | 0.32 lbs | $8.00 | $8.05 | $-0.05 |
| 214474 | 2020-08-12 | $6.33 | First-Class Mail Stamped Letter | 2 | 0.04 lbs | $3.35 | $3.18 | $0.17 |
| 214476 | 2020-08-12 | $25.79 | USPSFirstClass | 1 | 0.30 lbs | $5.91 | $4.46 | $1.45 |
| 214480 | 2020-08-12 | $19.79 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 214481 | 2020-08-12 | $42.98 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.60 lbs | $8.00 | $8.05 | $-0.05 |
| 214482 | 2020-08-12 | $24.53 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.00 | $7.75 | $0.25 |
| 214483 | 2020-08-12 | $6.34 | First-Class Mail Stamped Letter | 1 | 0.04 lbs | $3.35 | $3.05 | $0.30 |
| 214484 | 2020-08-12 | $48.08 | USPSFirstClass | 1 | 0.45 lbs | $6.65 | $4.00 | $2.65 |
| 214485 | 2020-08-12 | $30.19 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.45 lbs | $8.00 | $7.65 | $0.35 |
| 214486 | 2020-08-12 | $11.48 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.50 | $2.84 | $0.66 |
| 214487 | 2020-08-12 | $19.38 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 0.48 lbs | $8.60 | $7.75 | $0.85 |
| 214489 | 2020-08-12 | $20.46 | Priority Mail 2-Day Flat Rate Envelope | 4 | 0.12 lbs | $8.00 | $7.15 | $0.85 |
| 214492 | 2020-08-13 | $10.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 214493 | 2020-08-13 | $7.86 | USPSFirstClass | 1 | 0.03 lbs | $4.37 | $3.18 | $1.19 |
| 214494 | 2020-08-13 | $237.97 | Ground | 1 | 14.05 lbs | $44.98 | $29.23 | $15.75 |
| 214496 | 2020-08-13 | $79.02 | Priority Mail 2-Day | 1 | 5.80 lbs | $25.03 | $24.18 | $0.85 |
| 214497 | 2020-08-13 | $12.97 | Priority Mail 2-Day Flat Rate Envelope | 3 | 0.22 lbs | $8.00 | $7.65 | $0.35 |
| 214501 | 2020-08-13 | $64.21 | Priority Mail 2-Day | 15 | 3.85 lbs | $21.86 | $17.42 | $4.44 |
| 214502 | 2020-08-13 | $20.92 | Priority Mail 2-Day | 5 | 1.50 lbs | $8.97 | $8.12 | $0.85 |
| 214505 | 2020-08-13 | $21.79 | USPSPriority | 1 | 1.78 lbs | $10.44 | $8.59 | $1.85 |
| 214506 | 2020-08-13 | $177.48 | Priority Mail 2-Day | 4 | 11.60 lbs | $14.12 | $12.62 | $1.50 |
| 214511 | 2020-08-13 | $95.91 | Priority Mail International Padded Flat Rate Envelope | 9 | 0.51 lbs | $37.50 | $37.60 | $-0.10 |
| 214512 | 2020-08-13 | $37.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.10 lbs | $8.50 | $7.65 | $0.85 |
| 214516 | 2020-08-13 | $15.32 | First-Class Mail Stamped Letter | 3 | 0.07 lbs | $3.35 | $2.84 | $0.51 |
| 214518 | 2020-08-13 | $54.19 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.75 lbs | $8.50 | $7.65 | $0.85 |
| 214520 | 2020-08-14 | $43.39 | First-Class Package Service | 3 | 0.90 lbs | $5.49 | $7.65 | $-2.16 |
| 214521 | 2020-08-14 | $144.69 | Priority Mail 3-Day | 4 | 5.69 lbs | $10.59 | $9.74 | $0.85 |
| 214523 | 2020-08-14 | $147.81 | Ground Home Delivery | 1 | 12.88 lbs | $23.04 | $17.94 | $5.10 |
| 214524 | 2020-08-14 | $20.87 | USPSFirstClass | 1 | 0.03 lbs | $4.75 | $2.93 | $1.82 |
| 214525 | 2020-08-14 | $20.83 | Priority Mail 3-Day | 1 | 0.95 lbs | $10.84 | $9.99 | $0.85 |
| 214528 | 2020-08-14 | $13.89 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.20 | $3.05 | $0.15 |
| 214529 | 2020-08-14 | $6.99 | USPSFirstClass | 1 | 0.01 lbs | $4.32 | $3.18 | $1.14 |
| 214530 | 2020-08-14 | $11.21 | USPSFirstClass | 2 | 0.05 lbs | $4.16 | $2.93 | $1.23 |
| 214531 | 2020-08-14 | $28.05 | USPSFirstClass | 3 | 0.15 lbs | $12.42 | $2.78 | $9.64 |
| 214532 | 2020-08-14 | $19.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.25 lbs | $8.00 | $7.65 | $0.35 |
| 214533 | 2020-08-14 | $24.42 | Priority Mail 3-Day | 2 | 0.67 lbs | $10.84 | $9.99 | $0.85 |
| 214534 | 2020-08-14 | $10.60 | First-Class Mail Stamped Letter | 5 | 0.17 lbs | $3.65 | $3.39 | $0.26 |
| 214535 | 2020-08-14 | $8.48 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.50 | $2.84 | $0.66 |
| 214536 | 2020-08-14 | $11.34 | USPSFirstClass | 1 | 0.05 lbs | $4.35 | $2.93 | $1.42 |
| 214537 | 2020-08-14 | $25.21 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.00 lbs | $8.50 | $7.65 | $0.85 |
| 214538 | 2020-08-14 | $22.37 | Priority Mail 2-Day | 2 | 0.72 lbs | $11.39 | $10.54 | $0.85 |
| 214539 | 2020-08-15 | $13.97 | USPSFirstClass | 1 | 0.50 lbs | $5.37 | $5.70 | $-0.33 |
| 214540 | 2020-08-15 | $9.72 | USPSFirstClass | 1 | 0.05 lbs | $4.25 | $2.93 | $1.32 |
| 214544 | 2020-08-14 | $27.01 | Priority Mail 2-Day | 3 | 1.26 lbs | $12.04 | $11.19 | $0.85 |
| 214545 | 2020-08-15 | $57.68 | Priority Mail 2-Day Flat Rate Envelope | 2 | 2.87 lbs | $8.00 | $7.75 | $0.25 |
| 214547 | 2020-08-15 | $54.19 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.65 lbs | $8.50 | $8.05 | $0.45 |
| 214548 | 2020-08-15 | $12.02 | USPSFirstClass | 1 | 0.05 lbs | $4.39 | $3.05 | $1.34 |
| 214550 | 2020-08-15 | $24.81 | First-Class Package Service | 1 | 0.65 lbs | $5.52 | $3.31 | $2.21 |
| 214552 | 2020-08-15 | $42.56 | Priority Mail 2-Day | 13 | 3.75 lbs | $11.49 | $10.33 | $1.16 |
| 214553 | 2020-08-15 | $95.30 | Priority Mail 3-Day | 1 | 3.56 lbs | $19.31 | $16.06 | $3.25 |
| 214554 | 2020-08-15 | $42.01 | Priority Mail 2-Day | 3 | 1.05 lbs | $12.04 | $11.19 | $0.85 |
| 214555 | 2020-08-15 | $9.08 | USPSFirstClass | 2 | 0.30 lbs | $5.10 | $4.46 | $0.64 |
| 214556 | 2020-08-15 | $19.60 | Priority Mail 2-Day | 1 | 0.95 lbs | $9.61 | $8.76 | $0.85 |
| 214557 | 2020-08-15 | $25.54 | Priority Mail 2-Day Flat Rate Envelope | 6 | 0.28 lbs | $8.00 | $7.65 | $0.35 |
| 214558 | 2020-08-15 | $5.45 | USPSFirstClass | 1 | 0.03 lbs | $4.10 | $3.05 | $1.05 |
| 214559 | 2020-08-15 | $42.08 | Priority Mail 2-Day Small Flat Rate Box | 2 | 1.35 lbs | $8.50 | $7.65 | $0.85 |
| 214560 | 2020-08-15 | $33.05 | First-Class Package Service | 9 | 0.36 lbs | $3.84 | $3.39 | $0.45 |
| 214561 | 2020-08-15 | $13.62 | First-Class Package Service | 1 | 0.13 lbs | $3.63 | $3.67 | $-0.04 |
| 214562 | 2020-08-15 | $13.52 | USPSFirstClass | 1 | 0.04 lbs | $4.34 | $2.78 | $1.56 |
| 214563 | 2020-08-15 | $9.64 | First-Class Package Service | 1 | 0.50 lbs | $5.65 | $4.18 | $1.47 |
| 214565 | 2020-08-15 | $92.44 | Priority Mail 2-Day Medium Flat Rate Box | 1 | 7.15 lbs | $14.45 | $10.42 | $4.03 |
| 214566 | 2020-08-15 | $16.56 | First-Class Package Service | 1 | 0.55 lbs | $4.77 | $5.54 | $-0.77 |
| 214567 | 2020-08-15 | $5.18 | First-Class Mail Stamped Letter | 2 | 0.02 lbs | $3.20 | $3.05 | $0.15 |
| 214570 | 2020-08-15 | $23.02 | First-Class Package Service | 1 | 0.45 lbs | $4.53 | $4.08 | $0.45 |
| 214571 | 2020-08-15 | $6.17 | First-Class Mail Stamped Letter | 3 | 0.01 lbs | $3.20 | $3.18 | $0.02 |
| 214572 | 2020-08-15 | $5.19 | First-Class Package Service | 4 | 0.04 lbs | $3.23 | $2.78 | $0.45 |
| 214573 | 2020-08-16 | $7.07 | USPSFirstClass | 1 | 0.01 lbs | $4.17 | $3.05 | $1.12 |
| 214574 | 2020-08-15 | $38.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.50 | $7.65 | $0.85 |
| 214575 | 2020-08-15 | $26.74 | Priority Mail 2-Day | 10 | 1.50 lbs | $10.84 | $12.15 | $-1.31 |
| 214576 | 2020-08-16 | $14.60 | USPSFirstClass | 2 | 0.70 lbs | $5.69 | $5.40 | $0.29 |
| 214577 | 2020-08-15 | $24.94 | First-Class Package Service | 1 | 0.65 lbs | $5.65 | $5.40 | $0.25 |
| 214580 | 2020-08-16 | $268.77 | Ground Home Delivery | 3 | 22.60 lbs | $27.40 | $21.37 | $6.03 |
| 214581 | 2020-08-16 | $7.24 | First-Class Package Service | 2 | 0.03 lbs | $3.76 | $3.31 | $0.45 |
| 214582 | 2020-08-16 | $53.61 | Priority Mail 3-Day | 3 | 1.42 lbs | $10.84 | $9.99 | $0.85 |
| 214584 | 2020-08-16 | $5.19 | First-Class Mail Stamped Letter | 1 | 0.02 lbs | $3.20 | $2.93 | $0.27 |
| 214585 | 2020-08-16 | $28.78 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.75 lbs | $8.00 | $7.65 | $0.35 |
| 214586 | 2020-08-16 | $35.00 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.50 | $7.65 | $0.85 |
| 214587 | 2020-08-16 | $48.09 | Priority Mail 1-Day | 1 | 1.20 lbs | $8.49 | $7.64 | $0.85 |
| 214589 | 2020-08-16 | $10.15 | USPSFirstClass | 1 | 0.25 lbs | $4.32 | $5.54 | $-1.22 |
| 214590 | 2020-08-16 | $9.83 | First-Class Mail Stamped Letter | 2 | 0.05 lbs | $3.35 | $3.05 | $0.30 |
| 214591 | 2020-08-16 | $21.43 | First-Class Package Service | 2 | 0.45 lbs | $4.45 | $3.25 | $1.20 |
| 214592 | 2020-08-16 | $40.40 | Priority Mail 2-Day | 9 | 1.13 lbs | $11.39 | $11.13 | $0.26 |
| 214594 | 2020-08-16 | $84.97 | Priority Mail 2-Day Flat Rate Envelope | 3 | 2.15 lbs | $8.00 | $7.75 | $0.25 |
| 214595 | 2020-08-16 | $12.99 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.10 lbs | $8.00 | $7.75 | $0.25 |
| 214598 | 2020-08-16 | $20.59 | First-Class Package Service | 1 | 0.25 lbs | $3.70 | $2.78 | $0.92 |
| 214600 | 2020-08-16 | $65.52 | Priority Mail 3-Day | 2 | 1.80 lbs | $9.44 | $8.59 | $0.85 |
| 214602 | 2020-08-16 | $16.39 | Priority Mail 2-Day | 2 | 0.10 lbs | $8.41 | $7.65 | $0.76 |
| 214603 | 2020-08-17 | $17.71 | USPSFirstClass | 2 | 0.20 lbs | $4.21 | $3.25 | $0.96 |
| 214604 | 2020-08-17 | $8.87 | First-Class Package Service | 2 | 0.12 lbs | $3.29 | $2.84 | $0.45 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |