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 |
|---|---|---|---|---|---|---|---|---|
| 212233 | 2020-05-17 | $37.47 | Priority Mail 3-Day Flat Rate Envelope | 3 | 0.62 lbs | $8.00 | $7.65 | $0.35 |
| 212234 | 2020-05-17 | $15.92 | Priority Mail 2-Day Flat Rate Envelope | 8 | 0.40 lbs | $8.00 | $7.15 | $0.85 |
| 212235 | 2020-05-18 | $12.16 | USPSFirstClass | 1 | 0.07 lbs | $4.35 | $2.93 | $1.42 |
| 212236 | 2020-05-18 | $9.66 | USPSFirstClass | 1 | 0.07 lbs | $4.25 | $2.93 | $1.32 |
| 212237 | 2020-05-18 | $12.63 | USPSFirstClass | 1 | 0.50 lbs | $5.17 | $5.40 | $-0.23 |
| 212238 | 2020-05-17 | $210.70 | Priority Mail 1-Day | 11 | 9.21 lbs | $10.61 | $8.39 | $2.22 |
| 212239 | 2020-05-18 | $8.08 | USPSFirstClass | 1 | 0.07 lbs | $4.22 | $3.05 | $1.17 |
| 212241 | 2020-05-18 | $226.05 | Priority Mail 2-Day | 2 | 15.30 lbs | $22.62 | $20.78 | $1.84 |
| 212242 | 2020-05-18 | $13.74 | USPSFirstClass | 2 | 0.67 lbs | $5.82 | $5.54 | $0.28 |
| 212243 | 2020-05-18 | $70.97 | Priority Mail 3-Day Flat Rate Envelope | 3 | 1.23 lbs | $8.00 | $7.65 | $0.35 |
| 212245 | 2020-05-18 | $24.02 | InternationalPriorityShipping | 1 | 0.20 lbs | $4.09 | $3.39 | $0.70 |
| 212246 | 2020-05-18 | $11.85 | USPSFirstClass | 1 | 0.19 lbs | $4.25 | $2.78 | $1.47 |
| 212247 | 2020-05-18 | $19.31 | USPSFirstClass | 1 | 0.05 lbs | $4.92 | $3.67 | $1.25 |
| 212248 | 2020-05-18 | $26.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.00 | $7.75 | $0.25 |
| 212249 | 2020-05-18 | $6.34 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.84 | $0.51 |
| 212250 | 2020-05-18 | $4.18 | First-Class Mail Stamped Letter | 2 | 0.02 lbs | $3.20 | $2.93 | $0.27 |
| 212251 | 2020-05-18 | $49.20 | USPSFirstClass | 1 | 0.45 lbs | $6.75 | $4.18 | $2.57 |
| 212252 | 2020-05-18 | $10.34 | USPSFirstClass | 1 | 0.05 lbs | $4.24 | $2.84 | $1.40 |
| 212253 | 2020-05-18 | $33.96 | Priority Mail 2-Day | 1 | 1.30 lbs | $8.97 | $8.12 | $0.85 |
| 212254 | 2020-05-18 | $199.10 | Ground | 2 | 11.85 lbs | $26.12 | $20.47 | $5.65 |
| 212255 | 2020-05-18 | $17.34 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.78 | $0.57 |
| 212256 | 2020-05-18 | $32.95 | Priority Mail 2-Day Small Flat Rate Box | 5 | 2.25 lbs | $8.50 | $7.65 | $0.85 |
| 212257 | 2020-05-18 | $10.00 | USPSFirstClass | 1 | 0.61 lbs | $5.63 | $5.27 | $0.36 |
| 212263 | 2020-05-18 | $44.92 | Direct Link International | 5 | 0.33 lbs | $19.67 | $3.25 | $16.42 |
| 212264 | 2020-05-18 | $15.77 | First-Class Package Service | 2 | 0.71 lbs | $5.79 | $5.54 | $0.25 |
| 212265 | 2020-05-18 | $64.25 | Priority Mail 3-Day | 9 | 1.18 lbs | $12.04 | $11.18 | $0.86 |
| 212266 | 2020-05-16 | $31.03 | Priority Mail 2-Day | 6 | 0.96 lbs | $14.59 | $10.53 | $4.06 |
| 212269 | 2020-05-19 | $9.06 | USPSFirstClass | 1 | 0.33 lbs | $4.99 | $5.40 | $-0.41 |
| 212270 | 2020-05-19 | $12.65 | USPSFirstClass | 2 | 0.67 lbs | $5.67 | $5.40 | $0.27 |
| 212271 | 2020-05-19 | $11.65 | USPSFirstClass | 1 | 0.06 lbs | $4.25 | $2.78 | $1.47 |
| 212272 | 2020-05-19 | $9.73 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.93 | $0.42 |
| 212274 | 2020-05-19 | $26.29 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.25 lbs | $8.00 | $7.65 | $0.35 |
| 212275 | 2020-05-14 | $35.99 | Priority Mail 2-Day | 1 | 1.20 lbs | $8.00 | $7.65 | $0.35 |
| 212276 | 2020-05-19 | $7.34 | First-Class Mail Stamped Letter | 1 | 0.06 lbs | $3.35 | $3.05 | $0.30 |
| 212277 | 2020-05-19 | $25.53 | USPSFirstClass | 5 | 0.95 lbs | $13.12 | $10.53 | $2.59 |
| 212278 | 2020-05-19 | $8.77 | USPSFirstClass | 1 | 0.10 lbs | $4.12 | $2.78 | $1.34 |
| 212279 | 2020-05-19 | $23.20 | USPSFirstClass | 4 | 1.00 lbs | $9.74 | $11.18 | $-1.44 |
| 212280 | 2020-05-19 | $341.64 | Ground | 6 | 25.49 lbs | $37.90 | $26.29 | $11.61 |
| 212281 | 2020-05-19 | $24.41 | USPSFirstClass | 5 | 1.00 lbs | $13.30 | $10.53 | $2.77 |
| 212282 | 2020-05-19 | $10.34 | First-Class Mail Stamped Letter | 1 | 0.07 lbs | $3.35 | $2.84 | $0.51 |
| 212283 | 2020-05-19 | $38.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.50 | $7.65 | $0.85 |
| 212284 | 2020-05-19 | $8.33 | First-Class Mail Stamped Letter | 2 | 0.07 lbs | $3.35 | $3.25 | $0.10 |
| 212285 | 2020-05-20 | $7.51 | USPSFirstClass | 1 | 0.07 lbs | $4.12 | $2.84 | $1.28 |
| 212286 | 2020-05-19 | $11.46 | First-Class Mail Stamped Letter | 4 | 0.14 lbs | $3.50 | $2.84 | $0.66 |
| 212287 | 2020-05-19 | $42.64 | Priority Mail 3-Day Small Flat Rate Box | 2 | 1.25 lbs | $8.50 | $7.65 | $0.85 |
| 212291 | 2020-05-20 | $30.91 | Priority Mail 2-Day | 8 | 1.48 lbs | $11.39 | $10.53 | $0.86 |
| 212292 | 2020-05-20 | $58.38 | Priority Mail 2-Day | 1 | 1.70 lbs | $10.39 | $8.92 | $1.47 |
| 212294 | 2020-05-20 | $7.16 | USPSFirstClass | 1 | 0.06 lbs | $4.14 | $2.93 | $1.21 |
| 212295 | 2020-05-20 | $13.70 | USPSFirstClass | 1 | 0.31 lbs | $5.10 | $4.00 | $1.10 |
| 212297 | 2020-05-20 | $19.73 | First-Class Package Service | 2 | 0.48 lbs | $5.95 | $5.70 | $0.25 |
| 212298 | 2020-05-20 | $9.47 | First-Class Mail Stamped Letter | 3 | 0.09 lbs | $3.50 | $2.84 | $0.66 |
| 212301 | 2020-05-20 | $14.57 | USPSFirstClass | 1 | 0.45 lbs | $5.12 | $8.12 | $-3.00 |
| 212303 | 2020-05-20 | $19.04 | Priority Mail 2-Day Small Flat Rate Box | 6 | 0.16 lbs | $8.50 | $7.65 | $0.85 |
| 212305 | 2020-05-20 | $35.00 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.50 | $7.65 | $0.85 |
| 212306 | 2020-05-20 | $145.77 | Priority Mail 2-Day Flat Rate Envelope | 5 | 4.75 lbs | $8.00 | $7.65 | $0.35 |
| 212310 | 2020-05-20 | $31.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 3.55 lbs | $8.00 | $7.75 | $0.25 |
| 212312 | 2020-05-20 | $66.03 | Priority Mail 2-Day | 1 | 1.00 lbs | $12.04 | $11.19 | $0.85 |
| 212313 | 2020-05-21 | $10.88 | USPSFirstClass | 1 | 0.05 lbs | $4.24 | $3.31 | $0.93 |
| 212314 | 2020-05-20 | $24.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.45 lbs | $8.00 | $7.65 | $0.35 |
| 212315 | 2020-05-20 | $11.58 | First-Class Mail Stamped Letter | 2 | 0.15 lbs | $3.50 | $2.84 | $0.66 |
| 212316 | 2020-05-21 | $8.52 | USPSFirstClass | 1 | 0.05 lbs | $4.17 | $2.84 | $1.33 |
| 212317 | 2020-05-21 | $12.88 | USPSFirstClass | 1 | 0.30 lbs | $5.24 | $4.32 | $0.92 |
| 212318 | 2020-05-20 | $22.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.40 lbs | $8.00 | $7.65 | $0.35 |
| 212319 | 2020-05-21 | $7.61 | USPSFirstClass | 1 | 0.07 lbs | $3.97 | $2.74 | $1.23 |
| 212320 | 2020-05-21 | $5.99 | USPSFirstClass | 1 | 0.20 lbs | $3.99 | $3.25 | $0.74 |
| 212321 | 2020-05-21 | $11.65 | USPSFirstClass | 1 | 0.05 lbs | $4.25 | $2.78 | $1.47 |
| 212325 | 2020-05-21 | $6.88 | USPSFirstClass | 1 | 0.07 lbs | $4.09 | $2.84 | $1.25 |
| 212326 | 2020-05-21 | $314.01 | Priority Mail 2-Day Large Flat Rate Box | 13 | 17.90 lbs | $0.00 | $18.30 | $-18.30 |
| 212328 | 2020-05-21 | $101.22 | USPSPriority | 1 | 3.20 lbs | $12.81 | $8.07 | $4.74 |
| 212329 | 2020-05-21 | $55.78 | Priority Mail 3-Day Flat Rate Envelope | 2 | 0.95 lbs | $8.00 | $7.65 | $0.35 |
| 212331 | 2020-05-21 | $9.14 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.05 | $0.30 |
| 212332 | 2020-05-21 | $39.99 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.20 lbs | $8.50 | $7.65 | $0.85 |
| 212333 | 2020-05-21 | $104.88 | Priority Mail 2-Day Large Flat Rate Box | 3 | 1.35 lbs | $0.00 | $11.18 | $-11.18 |
| 212335 | 2020-05-22 | $14.90 | USPSFirstClass | 1 | 0.10 lbs | $4.42 | $2.84 | $1.58 |
| 212336 | 2020-05-22 | $9.40 | USPSFirstClass | 1 | 0.45 lbs | $5.08 | $4.32 | $0.76 |
| 212337 | 2020-05-21 | $42.48 | Priority Mail 3-Day | 2 | 2.02 lbs | $13.00 | $10.42 | $2.58 |
| 212339 | 2020-05-21 | $71.17 | Priority Mail 2-Day | 1 | 3.50 lbs | $11.18 | $10.64 | $0.54 |
| 212340 | 2020-05-22 | $9.41 | USPSFirstClass | 1 | 0.05 lbs | $4.42 | $3.18 | $1.24 |
| 212344 | 2020-05-21 | $51.85 | Priority Mail 3-Day Flat Rate Envelope | 7 | 0.96 lbs | $8.00 | $7.65 | $0.35 |
| 212347 | 2020-05-22 | $34.38 | Priority Mail 2-Day | 9 | 1.34 lbs | $8.97 | $8.12 | $0.85 |
| 212348 | 2020-05-22 | $38.67 | InternationalPriorityShipping | 1 | 0.04 lbs | $4.62 | $2.93 | $1.69 |
| 212351 | 2020-05-22 | $20.09 | Priority Mail 2-Day | 2 | 0.73 lbs | $9.61 | $8.76 | $0.85 |
| 212353 | 2020-05-22 | $76.92 | Priority Mail 2-Day Flat Rate Envelope | 8 | 3.80 lbs | $8.00 | $7.75 | $0.25 |
| 212354 | 2020-05-22 | $12.80 | USPSFirstClass | 2 | 0.67 lbs | $5.82 | $5.54 | $0.28 |
| 212356 | 2020-05-22 | $39.51 | Standard | 2 | 0.08 lbs | $30.73 | $28.23 | $2.50 |
| 212357 | 2020-05-22 | $14.63 | USPSFirstClass | 1 | 0.05 lbs | $4.40 | $3.31 | $1.09 |
| 212359 | 2020-05-22 | $50.37 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.40 lbs | $8.00 | $7.75 | $0.25 |
| 212360 | 2020-05-22 | $88.51 | Priority Mail 2-Day | 2 | 4.55 lbs | $15.03 | $10.64 | $4.39 |
| 212361 | 2020-05-22 | $7.74 | First-Class Mail Stamped Letter | 1 | 0.07 lbs | $3.35 | $2.84 | $0.51 |
| 212362 | 2020-05-22 | $8.48 | USPSFirstClass | 1 | 0.06 lbs | $4.15 | $2.84 | $1.31 |
| 212363 | 2020-05-22 | $19.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 212366 | 2020-05-22 | $5.34 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.35 | $2.93 | $0.42 |
| 212367 | 2020-05-22 | $5.69 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $3.20 | $3.05 | $0.15 |
| 212369 | 2020-05-22 | $26.54 | First-Class Package Service | 3 | 0.30 lbs | $3.77 | $4.32 | $-0.55 |
| 212370 | 2020-05-22 | $18.28 | Priority Mail 3-Day Small Flat Rate Box | 2 | 0.35 lbs | $8.50 | $7.65 | $0.85 |
| 212372 | 2020-05-22 | $13.25 | First-Class Package Service | 4 | 0.08 lbs | $3.29 | $3.31 | $-0.02 |
| 212375 | 2020-05-22 | $9.56 | First-Class Package Service | 1 | 0.42 lbs | $4.57 | $4.32 | $0.25 |
| 212377 | 2020-05-22 | $54.19 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.60 lbs | $8.50 | $7.65 | $0.85 |
| 212379 | 2020-05-22 | $10.33 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.35 | $3.05 | $0.30 |
| 212382 | 2020-05-22 | $15.13 | First-Class Mail Stamped Letter | 2 | 0.06 lbs | $3.35 | $3.05 | $0.30 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |