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.21025 matching order(s)
| Order ID ▲ | Date | Order Total | Shipping Method | # Products | Total Weight | Shipping Charged | Shipping Paid | Profit |
|---|---|---|---|---|---|---|---|---|
| 217360 | 2020-11-07 | $43.88 | Priority Mail 2-Day Small Flat Rate Box | 2 | 1.33 lbs | $8.90 | $8.05 | $0.85 |
| 217361 | 2020-11-07 | $45.49 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 1.35 lbs | $9.00 | $8.15 | $0.85 |
| 217362 | 2020-11-07 | $64.48 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 1.52 lbs | $9.00 | $8.05 | $0.95 |
| 217364 | 2020-11-07 | $10.88 | First-Class Mail Stamped Letter | 1 | 0.04 lbs | $3.35 | $3.09 | $0.26 |
| 217365 | 2020-11-07 | $21.10 | USPSFirstClass | 3 | 0.30 lbs | $4.95 | $3.03 | $1.92 |
| 217366 | 2020-11-07 | $38.69 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.25 lbs | $8.90 | $8.05 | $0.85 |
| 217368 | 2020-11-07 | $56.62 | Priority Mail 2-Day | 10 | 4.50 lbs | $19.72 | $16.54 | $3.18 |
| 217374 | 2020-11-07 | $225.46 | Priority Mail 1-Day | 1 | 21.00 lbs | $19.11 | $18.64 | $0.47 |
| 217376 | 2020-11-08 | $9.50 | USPSFirstClass | 1 | 0.05 lbs | $4.14 | $3.03 | $1.11 |
| 217377 | 2020-11-07 | $16.16 | First-Class Package Service | 1 | 0.30 lbs | $4.37 | $3.92 | $0.45 |
| 217379 | 2020-11-08 | $24.47 | USPSPriority | 1 | 1.50 lbs | $8.97 | $8.08 | $0.89 |
| 217380 | 2020-11-08 | $16.01 | First-Class Package Service | 1 | 0.30 lbs | $4.22 | $3.77 | $0.45 |
| 217381 | 2020-11-08 | $24.32 | USPSFirstClass | 2 | 0.10 lbs | $4.45 | $3.18 | $1.27 |
| 217384 | 2020-11-08 | $55.56 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 3.03 lbs | $9.00 | $8.15 | $0.85 |
| 217385 | 2020-11-08 | $29.63 | Priority Mail 3-Day | 1 | 0.90 lbs | $11.24 | $8.15 | $3.09 |
| 217386 | 2020-11-08 | $42.07 | Priority Mail 2-Day Flat Rate Envelope | 3 | 1.27 lbs | $8.40 | $8.05 | $0.35 |
| 217387 | 2020-11-08 | $217.98 | Priority Mail 2-Day | 1 | 14.05 lbs | $24.99 | $20.99 | $4.00 |
| 217388 | 2020-11-08 | $8.99 | USPSFirstClass | 1 | 0.05 lbs | $4.40 | $3.43 | $0.97 |
| 217389 | 2020-11-08 | $8.19 | First-Class Mail Stamped Letter | 1 | 0.02 lbs | $3.20 | $3.30 | $-0.10 |
| 217390 | 2020-11-08 | $12.98 | USPSFirstClass | 1 | 0.10 lbs | $4.30 | $3.03 | $1.27 |
| 217391 | 2020-11-08 | $61.57 | Priority Mail 3-Day | 4 | 1.20 lbs | $10.01 | $8.85 | $1.16 |
| 217392 | 2020-11-08 | $11.84 | First-Class Package Service | 1 | 0.20 lbs | $3.95 | $3.50 | $0.45 |
| 217394 | 2020-11-08 | $45.21 | First-Class Package Service | 1 | 0.45 lbs | $4.96 | $4.71 | $0.25 |
| 217397 | 2020-11-08 | $41.08 | Priority Mail 1-Day | 1 | 1.30 lbs | $8.89 | $8.05 | $0.84 |
| 217400 | 2020-11-08 | $4.84 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.09 | $0.26 |
| 217401 | 2020-11-08 | $37.29 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.40 lbs | $8.90 | $8.05 | $0.85 |
| 217402 | 2020-11-08 | $19.57 | Priority Mail 3-Day | 10 | 0.10 lbs | $9.67 | $8.82 | $0.85 |
| 217404 | 2020-11-08 | $11.52 | First-Class Package Service - Retail | 1 | 0.05 lbs | $4.75 | $3.03 | $1.72 |
| 217406 | 2020-11-08 | $4.19 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $3.20 | $3.43 | $-0.23 |
| 217407 | 2020-11-08 | $38.69 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.90 | $8.05 | $0.85 |
| 217408 | 2020-11-08 | $4.69 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.20 | $3.09 | $0.11 |
| 217409 | 2020-11-08 | $49.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.60 lbs | $8.90 | $8.05 | $0.85 |
| 217411 | 2020-11-08 | $25.43 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.40 | $8.15 | $0.25 |
| 217412 | 2020-11-09 | $38.69 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.40 lbs | $8.90 | $8.05 | $0.85 |
| 217413 | 2020-11-09 | $13.33 | First-Class Mail Stamped Letter | 2 | 0.06 lbs | $3.35 | $3.30 | $0.05 |
| 217417 | 2020-11-09 | $7.90 | USPSFirstClass | 1 | 0.03 lbs | $4.22 | $3.30 | $0.92 |
| 217419 | 2020-11-09 | $38.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.90 | $8.05 | $0.85 |
| 217420 | 2020-11-09 | $28.80 | Priority Mail 2-Day | 7 | 1.10 lbs | $9.37 | $8.34 | $1.03 |
| 217421 | 2020-11-09 | $11.85 | USPSFirstClass | 1 | 0.19 lbs | $4.35 | $3.18 | $1.17 |
| 217423 | 2020-11-09 | $62.84 | Priority Mail 2-Day Medium Flat Rate Box | 1 | 25.05 lbs | $14.85 | $13.60 | $1.25 |
| 217424 | 2020-11-09 | $38.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.90 | $8.05 | $0.85 |
| 217426 | 2020-11-09 | $10.83 | First-Class Package Service | 1 | 0.20 lbs | $3.91 | $2.99 | $0.92 |
| 217427 | 2020-11-09 | $10.03 | USPSFirstClass | 1 | 0.10 lbs | $4.45 | $3.43 | $1.02 |
| 217430 | 2020-11-09 | $8.91 | First-Class Package Service | 4 | 0.31 lbs | $3.95 | $3.50 | $0.45 |
| 217431 | 2020-10-31 | $5.97 | First-Class Package Service | 3 | 0.09 lbs | $0.00 | $3.03 | $-3.03 |
| 217432 | 2020-10-31 | $2.99 | First-Class Package Service | 1 | 0.03 lbs | $0.00 | $3.03 | $-3.03 |
| 217433 | 2020-11-09 | $85.33 | Priority Mail 2-Day Flat Rate Envelope | 7 | 2.00 lbs | $8.40 | $8.05 | $0.35 |
| 217434 | 2020-11-09 | $32.48 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.60 lbs | $8.90 | $8.05 | $0.85 |
| 217435 | 2020-11-09 | $15.81 | First-Class Package Service | 1 | 0.40 lbs | $4.82 | $3.77 | $1.05 |
| 217436 | 2020-11-09 | $67.98 | Priority Mail 3-Day Padded Flat Rate Envelope | 2 | 2.00 lbs | $9.00 | $8.15 | $0.85 |
| 217437 | 2020-11-09 | $5.16 | First-Class Mail Stamped Letter | 4 | 0.04 lbs | $3.20 | $3.30 | $-0.10 |
| 217438 | 2020-11-09 | $33.98 | Priority Mail 2-Day | 3 | 1.59 lbs | $10.01 | $9.32 | $0.69 |
| 217440 | 2020-11-10 | $19.70 | USPSFirstClass | 2 | 0.10 lbs | $8.38 | $8.20 | $0.18 |
| 217441 | 2020-11-09 | $347.14 | Priority Mail 2-Day | 4 | 22.70 lbs | $22.94 | $19.98 | $2.96 |
| 217443 | 2020-11-09 | $27.35 | First-Class Package Service | 1 | 0.40 lbs | $5.16 | $4.71 | $0.45 |
| 217445 | 2020-11-09 | $10.20 | First-Class Package Service | 2 | 0.30 lbs | $4.22 | $3.77 | $0.45 |
| 217446 | 2020-11-10 | $5.90 | USPSFirstClass | 1 | 0.19 lbs | $4.07 | $3.18 | $0.89 |
| 217447 | 2020-11-10 | $26.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.65 lbs | $8.90 | $8.05 | $0.85 |
| 217450 | 2020-11-10 | $21.33 | First-Class Package Service | 2 | 0.16 lbs | $3.75 | $3.30 | $0.45 |
| 217453 | 2020-11-10 | $20.13 | First-Class Package Service | 1 | 0.45 lbs | $5.02 | $4.53 | $0.49 |
| 217454 | 2020-11-10 | $11.09 | First-Class Package Service | 6 | 0.29 lbs | $3.95 | $3.50 | $0.45 |
| 217456 | 2020-11-10 | $181.99 | Ground | 2 | 13.85 lbs | $28.01 | $23.88 | $4.13 |
| 217457 | 2020-11-10 | $22.38 | First-Class Package Service | 1 | 0.30 lbs | $4.09 | $3.64 | $0.45 |
| 217458 | 2020-11-10 | $46.69 | USPSFirstClass | 1 | 0.10 lbs | $5.95 | $3.77 | $2.18 |
| 217459 | 2020-11-10 | $36.89 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.90 | $8.05 | $0.85 |
| 217460 | 2020-11-10 | $11.48 | USPSFirstClass | 2 | 0.50 lbs | $5.04 | $4.57 | $0.47 |
| 217461 | 2020-11-10 | $24.05 | First-Class Package Service | 4 | 0.29 lbs | $4.09 | $4.43 | $-0.34 |
| 217462 | 2020-11-10 | $38.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.90 | $8.05 | $0.85 |
| 217464 | 2020-11-10 | $78.38 | Priority Mail 2-Day Small Flat Rate Box | 2 | 1.85 lbs | $8.90 | $7.65 | $1.25 |
| 217465 | 2020-11-10 | $22.15 | First-Class Package Service | 1 | 0.35 lbs | $4.37 | $3.92 | $0.45 |
| 217466 | 2020-11-10 | $46.58 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 1.11 lbs | $9.00 | $8.15 | $0.85 |
| 217467 | 2020-11-10 | $111.82 | Ground | 2 | 3.25 lbs | $20.44 | $19.58 | $0.86 |
| 217471 | 2020-11-10 | $22.59 | Ground | 1 | 0.15 lbs | $17.10 | $14.60 | $2.50 |
| 217473 | 2020-11-10 | $21.87 | First-Class Package Service | 1 | 0.35 lbs | $4.09 | $3.64 | $0.45 |
| 217475 | 2020-11-10 | $43.27 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.70 lbs | $8.40 | $8.05 | $0.35 |
| 217476 | 2020-11-10 | $50.39 | Priority Mail 3-Day | 1 | 2.20 lbs | $13.40 | $10.89 | $2.51 |
| 217477 | 2020-11-10 | $15.58 | First-Class Package Service | 1 | 0.30 lbs | $4.09 | $3.39 | $0.70 |
| 217482 | 2020-11-10 | $9.02 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.30 | $0.05 |
| 217483 | 2020-11-11 | $41.49 | InternationalPriorityShipping | 1 | 0.08 lbs | $4.50 | $3.30 | $1.20 |
| 217485 | 2020-11-11 | $9.42 | First-Class Package Service | 1 | 0.05 lbs | $3.75 | $3.30 | $0.45 |
| 217486 | 2020-11-11 | $37.49 | First-Class Package Service | 1 | 0.75 lbs | $5.90 | $5.65 | $0.25 |
| 217488 | 2020-11-11 | $33.98 | Priority Mail 2-Day | 2 | 1.90 lbs | $13.40 | $9.99 | $3.41 |
| 217489 | 2020-11-11 | $9.36 | First-Class Package Service | 2 | 0.06 lbs | $3.88 | $3.43 | $0.45 |
| 217492 | 2020-11-11 | $63.18 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.50 lbs | $8.40 | $7.90 | $0.50 |
| 217497 | 2020-11-11 | $20.19 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.40 | $8.82 | $-0.42 |
| 217498 | 2020-11-11 | $16.67 | First-Class Package Service | 1 | 0.55 lbs | $4.88 | $4.43 | $0.45 |
| 217500 | 2020-11-11 | $38.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.90 | $8.05 | $0.85 |
| 217502 | 2020-11-11 | $43.79 | Priority Mail 2-Day | 2 | 1.30 lbs | $9.37 | $8.05 | $1.32 |
| 217503 | 2020-11-11 | $51.89 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.90 | $7.90 | $1.00 |
| 217505 | 2020-11-11 | $68.37 | Priority Mail 2-Day Flat Rate Envelope | 3 | 3.15 lbs | $8.40 | $8.15 | $0.25 |
| 217507 | 2020-11-11 | $9.52 | First-Class Package Service | 2 | 0.04 lbs | $3.54 | $3.09 | $0.45 |
| 217511 | 2020-11-11 | $261.12 | Priority Mail 2-Day | 1 | 13.15 lbs | $51.13 | $54.87 | $-3.74 |
| 217512 | 2020-11-11 | $47.59 | Priority Mail 2-Day | 2 | 0.90 lbs | $10.01 | $9.16 | $0.85 |
| 217513 | 2020-11-11 | $11.40 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.50 | $3.18 | $0.32 |
| 217515 | 2020-11-12 | $38.69 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.25 lbs | $8.90 | $8.05 | $0.85 |
| 217516 | 2020-11-12 | $15.44 | USPSFirstClass | 2 | 0.10 lbs | $4.28 | $3.18 | $1.10 |
| 217517 | 2020-11-12 | $46.16 | Priority Mail 2-Day | 1 | 1.20 lbs | $9.37 | $8.52 | $0.85 |
| 217518 | 2020-11-12 | $7.19 | First-Class Mail Stamped Letter | 1 | 0.02 lbs | $3.20 | $3.03 | $0.17 |
| 217521 | 2020-11-12 | $48.17 | First-Class Package Service | 5 | 0.40 lbs | $4.22 | $3.77 | $0.45 |
| 217523 | 2020-11-12 | $29.87 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.60 lbs | $8.40 | $8.15 | $0.25 |
| Total | 21025 order(s) | 59971 | 29292.14 lbs | $193562.51 | $270247.54 | $-76685.03 |