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 |
|---|---|---|---|---|---|---|---|---|
| 203111 | 2018-06-02 | $40.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $7.90 | $6.85 | $1.05 |
| 203113 | 2018-06-02 | $15.88 | First-Class Package Service | 5 | 0.42 lbs | $5.43 | $3.18 | $2.25 |
| 203114 | 2018-06-03 | $198.57 | Priority Mail International | 1 | 12.90 lbs | $100.58 | $74.34 | $26.24 |
| 203115 | 2018-06-03 | $67.82 | First-Class Package International Service | 1 | 1.55 lbs | $27.33 | $22.33 | $5.00 |
| 203116 | 2018-06-03 | $67.82 | First-Class Package International Service | 1 | 1.55 lbs | $27.33 | $22.33 | $5.00 |
| 203117 | 2018-06-03 | $67.82 | First-Class Package International Service | 1 | 1.50 lbs | $27.33 | $22.33 | $5.00 |
| 203118 | 2018-06-03 | $75.11 | First-Class Package International Service | 2 | 1.55 lbs | $27.33 | $22.33 | $5.00 |
| 203119 | 2018-06-03 | $93.78 | First-Class Package International Service | 3 | 2.58 lbs | $38.01 | $33.01 | $5.00 |
| 203120 | 2018-06-03 | $93.78 | First-Class Package International Service | 3 | 2.58 lbs | $38.01 | $48.93 | $-10.92 |
| 203121 | 2018-06-03 | $108.97 | First-Class Package International Service | 4 | 2.52 lbs | $38.01 | $33.01 | $5.00 |
| 203122 | 2018-06-03 | $99.30 | Direct Link International | 2 | 2.70 lbs | $33.32 | $9.42 | $23.90 |
| 203123 | 2018-06-03 | $98.71 | Direct Link International | 2 | 2.65 lbs | $33.43 | $119.40 | $-85.97 |
| 203124 | 2018-06-03 | $109.29 | First-Class Package International Service | 7 | 2.50 lbs | $38.96 | $33.96 | $5.00 |
| 203125 | 2018-06-03 | $35.89 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.20 lbs | $7.90 | $6.85 | $1.05 |
| 203126 | 2018-06-03 | $6.70 | First-Class Package Service | 1 | 0.05 lbs | $3.71 | $2.66 | $1.05 |
| 203127 | 2018-06-03 | $57.18 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.65 lbs | $7.40 | $6.90 | $0.50 |
| 203128 | 2018-06-03 | $72.88 | Priority Mail 2-Day | 5 | 1.38 lbs | $11.14 | $9.98 | $1.16 |
| 203129 | 2018-06-03 | $5.18 | First-Class Package Service | 3 | 0.03 lbs | $3.71 | $2.66 | $1.05 |
| 203131 | 2018-06-04 | $216.66 | Direct Link International | 9 | 9.18 lbs | $57.73 | $11.12 | $46.61 |
| 203132 | 2018-06-04 | $19.93 | Priority Mail 3-Day | 1 | 0.95 lbs | $11.14 | $9.98 | $1.16 |
| 203133 | 2018-06-04 | $15.89 | First-Class Package Service | 1 | 0.25 lbs | $4.10 | $3.18 | $0.92 |
| 203135 | 2018-06-04 | $35.89 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.20 lbs | $7.90 | $6.85 | $1.05 |
| 203136 | 2018-06-04 | $53.59 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.65 lbs | $7.90 | $6.85 | $1.05 |
| 203137 | 2018-06-04 | $57.18 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.65 lbs | $7.40 | $6.85 | $0.55 |
| 203138 | 2018-06-04 | $70.95 | Priority Mail 2-Day | 11 | 2.44 lbs | $13.01 | $13.75 | $-0.74 |
| 203139 | 2018-06-05 | $23.20 | First-Class Package International Service | 10 | 0.10 lbs | $18.30 | $13.30 | $5.00 |
| 203141 | 2018-06-05 | $18.36 | Priority Mail 3-Day Flat Rate Envelope | 4 | 0.06 lbs | $7.40 | $6.85 | $0.55 |
| 203142 | 2018-06-05 | $9.29 | First-Class Package Service | 1 | 0.25 lbs | $3.97 | $3.18 | $0.79 |
| 203143 | 2018-06-05 | $15.07 | First-Class Package Service | 4 | 0.22 lbs | $3.71 | $2.66 | $1.05 |
| 203145 | 2018-06-06 | $67.21 | First-Class Package International Service | 2 | 1.49 lbs | $27.33 | $22.33 | $5.00 |
| 203147 | 2018-06-06 | $121.00 | Priority Mail International | 1 | 3.85 lbs | $61.01 | $56.76 | $4.25 |
| 203148 | 2018-06-06 | $5.70 | First-Class Package Service | 1 | 0.07 lbs | $3.71 | $2.66 | $1.05 |
| 203149 | 2018-06-06 | $30.10 | Priority Mail 2-Day | 10 | 0.74 lbs | $9.00 | $7.91 | $1.09 |
| 203153 | 2018-06-03 | $155.91 | Priority Mail 2-Day | 10 | 4.61 lbs | $0.00 | $9.42 | $-9.42 |
| 203154 | 2018-06-03 | $19.19 | Priority Mail 2-Day | 1 | 1.00 lbs | $0.00 | $6.85 | $-6.85 |
| 203158 | 2018-06-07 | $348.47 | Priority Mail International | 7 | 12.95 lbs | $125.74 | $113.29 | $12.45 |
| 203162 | 2018-06-07 | $27.37 | Priority Mail 3-Day | 6 | 1.95 lbs | $8.53 | $7.45 | $1.08 |
| 203164 | 2018-06-07 | $23.71 | First-Class Package Service | 2 | 0.37 lbs | $4.23 | $3.18 | $1.05 |
| 203165 | 2018-06-07 | $28.45 | First-Class Package Service | 2 | 0.60 lbs | $4.87 | $3.82 | $1.05 |
| 203170 | 2018-06-08 | $237.07 | Priority Mail 3-Day | 27 | 4.99 lbs | $15.05 | $8.15 | $6.90 |
| 203171 | 2018-06-08 | $9.49 | Priority Mail 3-Day | 1 | 0.35 lbs | $0.00 | $6.85 | $-6.85 |
| 203181 | 2018-06-09 | $19.34 | Priority Mail 3-Day Flat Rate Envelope | 6 | 0.17 lbs | $7.40 | $2.66 | $4.74 |
| 203183 | 2018-06-09 | $83.84 | Priority Mail 3-Day Flat Rate Envelope | 6 | 2.31 lbs | $7.40 | $6.90 | $0.50 |
| 203185 | 2018-06-10 | $18.89 | First-Class Package Service | 8 | 0.26 lbs | $3.97 | $2.66 | $1.31 |
| 203190 | 2018-06-10 | $36.29 | Priority Mail 2-Day | 6 | 0.90 lbs | $11.65 | $7.53 | $4.12 |
| 203192 | 2018-06-11 | $64.23 | Priority Mail 2-Day | 6 | 2.27 lbs | $16.19 | $12.45 | $3.74 |
| 203193 | 2018-06-11 | $27.09 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.00 lbs | $7.90 | $6.85 | $1.05 |
| 203195 | 2018-06-09 | $80.98 | Ground | 2 | 3.05 lbs | $0.00 | $7.40 | $-7.40 |
| 203200 | 2018-06-11 | $84.55 | Priority Mail 3-Day | 7 | 2.42 lbs | $9.32 | $7.40 | $1.92 |
| 203204 | 2018-06-12 | $53.59 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.70 lbs | $7.90 | $6.85 | $1.05 |
| 203205 | 2018-06-12 | $8.66 | First-Class Package Service | 5 | 0.05 lbs | $3.71 | $2.66 | $1.05 |
| 203206 | 2018-06-13 | $5.71 | First-Class Package Service | 2 | 0.02 lbs | $3.71 | $2.66 | $1.05 |
| 203207 | 2018-06-13 | $48.70 | Priority Mail 3-Day Padded Flat Rate Envelope | 5 | 1.46 lbs | $7.95 | $6.90 | $1.05 |
| 203208 | 2018-06-13 | $8.70 | First-Class Package Service | 1 | 0.10 lbs | $3.71 | $2.66 | $1.05 |
| 203210 | 2018-06-13 | $81.98 | First-Class Package International Service | 5 | 1.54 lbs | $27.33 | $22.33 | $5.00 |
| 203211 | 2018-06-13 | $10.69 | First-Class Package Service | 2 | 0.08 lbs | $3.71 | $2.66 | $1.05 |
| 203234 | 2018-06-14 | $36.42 | Ground | 31 | 8.07 lbs | $24.97 | $23.46 | $1.51 |
| 203236 | 2018-06-14 | $20.81 | First-Class Package Service | 2 | 0.90 lbs | $5.23 | $4.94 | $0.29 |
| 203237 | 2018-06-14 | $6.16 | First-Class Package Service | 5 | 0.05 lbs | $3.71 | $2.66 | $1.05 |
| 203238 | 2018-06-14 | $163.43 | Priority Mail International | 1 | 8.55 lbs | $81.34 | $74.34 | $7.00 |
| 203244 | 2018-06-15 | $54.56 | Priority Mail 3-Day Flat Rate Envelope | 4 | 1.20 lbs | $7.40 | $6.85 | $0.55 |
| 203245 | 2018-06-15 | $122.85 | Priority Mail International Medium Flat Rate Box | 5 | 2.74 lbs | $46.20 | $44.32 | $1.88 |
| 203246 | 2018-06-15 | $11.14 | First-Class Package Service | 3 | 0.57 lbs | $4.87 | $3.34 | $1.53 |
| 203247 | 2018-06-15 | $117.14 | Priority Mail 2-Day Flat Rate Envelope | 6 | 1.90 lbs | $7.40 | $6.90 | $0.50 |
| 203248 | 2018-06-16 | $7.69 | First-Class Package Service | 2 | 0.20 lbs | $3.71 | $2.66 | $1.05 |
| 203249 | 2018-06-16 | $27.29 | First-Class Package Service | 2 | 0.55 lbs | $4.71 | $3.82 | $0.89 |
| 203250 | 2018-06-16 | $76.08 | Priority Mail 2-Day | 4 | 2.55 lbs | $9.32 | $14.80 | $-5.48 |
| 203253 | 2018-06-16 | $94.22 | Priority Mail 2-Day Medium Flat Rate Box | 7 | 2.15 lbs | $13.85 | $12.45 | $1.40 |
| 203254 | 2018-06-16 | $58.11 | Priority Mail 3-Day | 12 | 2.64 lbs | $15.03 | $13.75 | $1.28 |
| 203256 | 2018-06-17 | $16.88 | First-Class Package Service | 2 | 0.30 lbs | $4.10 | $3.05 | $1.05 |
| 203257 | 2018-06-17 | $5.70 | First-Class Package Service | 1 | 0.03 lbs | $3.71 | $2.66 | $1.05 |
| 203259 | 2018-06-17 | $5.67 | First-Class Package Service | 4 | 0.20 lbs | $3.71 | $2.66 | $1.05 |
| 203260 | 2018-06-18 | $59.98 | Priority Mail 2-Day | 4 | 1.49 lbs | $9.32 | $8.22 | $1.10 |
| 203261 | 2018-06-18 | $5.70 | First-Class Package Service | 1 | 0.01 lbs | $3.71 | $2.66 | $1.05 |
| 203263 | 2018-06-18 | $6.69 | First-Class Package Service | 2 | 0.02 lbs | $3.71 | $2.66 | $1.05 |
| 203264 | 2018-06-18 | $3.97 | First-Class Package Service | 1 | 0.30 lbs | $3.97 | $2.66 | $1.31 |
| 203268 | 2018-06-19 | $11.70 | First-Class Package Service | 1 | 0.05 lbs | $3.71 | $2.66 | $1.05 |
| 203269 | 2018-06-19 | $38.57 | Priority Mail 2-Day | 5 | 1.16 lbs | $11.14 | $7.28 | $3.86 |
| 203270 | 2018-06-19 | $93.42 | Priority Mail 2-Day Medium Flat Rate Box | 3 | 2.95 lbs | $13.85 | $10.29 | $3.56 |
| 203272 | 2018-06-19 | $8.70 | First-Class Package Service | 1 | 0.02 lbs | $3.71 | $2.66 | $1.05 |
| 203274 | 2018-06-19 | $198.57 | Priority Mail International | 1 | 12.90 lbs | $100.58 | $93.58 | $7.00 |
| 203277 | 2018-06-19 | $703.91 | Direct Link International | 26 | 25.96 lbs | $80.47 | $19.01 | $61.46 |
| 203279 | 2018-06-19 | $37.39 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.30 lbs | $7.90 | $6.85 | $1.05 |
| 203280 | 2018-06-19 | $9.70 | First-Class Package Service | 1 | 0.15 lbs | $3.71 | $2.66 | $1.05 |
| 203282 | 2018-06-19 | $39.17 | Priority Mail 3-Day Flat Rate Envelope | 3 | 1.11 lbs | $7.40 | $6.90 | $0.50 |
| 203285 | 2018-06-20 | $34.24 | Priority Mail 3-Day Small Flat Rate Box | 6 | 1.20 lbs | $7.90 | $6.85 | $1.05 |
| 203286 | 2018-06-20 | $40.19 | Priority Mail 3-Day Flat Rate Envelope | 1 | 1.00 lbs | $7.40 | $6.85 | $0.55 |
| 203288 | 2018-06-20 | $8.12 | First-Class Package Service | 9 | 0.09 lbs | $3.71 | $2.66 | $1.05 |
| 203291 | 2018-06-20 | $17.79 | Priority Mail 3-Day | 1 | 0.95 lbs | $9.00 | $7.91 | $1.09 |
| 203292 | 2018-06-20 | $34.92 | First-Class Package Service | 1 | 1.00 lbs | $5.43 | $6.85 | $-1.42 |
| 203293 | 2018-06-20 | $7.96 | First-Class Package Service | 1 | 0.17 lbs | $3.97 | $2.79 | $1.18 |
| 203294 | 2018-06-20 | $21.73 | First-Class Package Service - Retail | 2 | 0.62 lbs | $6.35 | $4.66 | $1.69 |
| 203295 | 2018-06-21 | $50.64 | Priority Mail 2-Day Medium Flat Rate Box | 1 | 1.10 lbs | $13.85 | $10.48 | $3.37 |
| 203297 | 2018-06-21 | $202.44 | Priority Mail International | 14 | 5.53 lbs | $78.82 | $76.43 | $2.39 |
| 203300 | 2018-06-21 | $7.18 | First-Class Package Service | 3 | 0.11 lbs | $3.71 | $2.66 | $1.05 |
| 203301 | 2018-06-21 | $6.70 | First-Class Package Service | 1 | 0.05 lbs | $3.71 | $2.66 | $1.05 |
| 203306 | 2018-06-22 | $42.15 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.70 lbs | $7.40 | $6.90 | $0.50 |
| 203307 | 2018-06-22 | $15.63 | First-Class Package Service | 1 | 0.25 lbs | $3.84 | $3.18 | $0.66 |
| 203311 | 2018-06-23 | $25.69 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $7.40 | $6.90 | $0.50 |
| 203312 | 2018-06-23 | $64.50 | Priority Mail 2-Day | 4 | 1.25 lbs | $11.14 | $9.98 | $1.16 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |