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 |
|---|---|---|---|---|---|---|---|---|
| 212099 | 2020-05-11 | $36.98 | Priority Mail 2-Day | 3 | 9.00 lbs | $13.01 | $8.59 | $4.42 |
| 212101 | 2020-05-11 | $17.18 | First-Class Mail Stamped Letter | 3 | 0.17 lbs | $3.65 | $3.67 | $-0.02 |
| 212102 | 2020-05-12 | $5.41 | USPSFirstClass | 1 | 0.01 lbs | $4.00 | $2.84 | $1.16 |
| 212103 | 2020-05-11 | $31.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 1.00 lbs | $8.00 | $7.75 | $0.25 |
| 212104 | 2020-05-11 | $16.63 | First-Class Package Service | 2 | 0.70 lbs | $5.65 | $5.40 | $0.25 |
| 212106 | 2020-05-12 | $8.95 | USPSFirstClass | 1 | 0.23 lbs | $4.24 | $2.93 | $1.31 |
| 212107 | 2020-05-11 | $17.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.10 lbs | $8.00 | $7.65 | $0.35 |
| 212108 | 2020-05-11 | $26.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $7.75 | $0.25 |
| 212109 | 2020-05-12 | $9.49 | USPSFirstClass | 1 | 0.05 lbs | $4.24 | $2.93 | $1.31 |
| 212110 | 2020-05-11 | $43.20 | Ground | 1 | 0.50 lbs | $13.43 | $11.72 | $1.71 |
| 212113 | 2020-05-12 | $25.90 | Priority Mail 2-Day Flat Rate Envelope | 10 | 0.87 lbs | $8.00 | $7.65 | $0.35 |
| 212114 | 2020-05-12 | $9.76 | First-Class Package Service | 1 | 0.27 lbs | $4.77 | $4.32 | $0.45 |
| 212115 | 2020-05-12 | $68.71 | Priority Mail 2-Day | 18 | 0.89 lbs | $11.39 | $10.53 | $0.86 |
| 212116 | 2020-05-12 | $6.00 | USPSFirstClass | 1 | 0.01 lbs | $3.99 | $2.78 | $1.21 |
| 212117 | 2020-05-12 | $22.68 | USPSFirstClass | 2 | 0.15 lbs | $8.70 | $2.93 | $5.77 |
| 212118 | 2020-05-12 | $38.29 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.50 | $7.65 | $0.85 |
| 212119 | 2020-05-12 | $17.98 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.90 lbs | $8.00 | $7.65 | $0.35 |
| 212120 | 2020-05-12 | $214.43 | Priority Mail 3-Day Medium Flat Rate Box | 2 | 21.40 lbs | $14.45 | $13.20 | $1.25 |
| 212121 | 2020-05-12 | $27.04 | USPSFirstClass | 4 | 1.30 lbs | $11.88 | $11.18 | $0.70 |
| 212122 | 2020-05-12 | $8.49 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $2.78 | $0.72 |
| 212123 | 2020-05-12 | $46.03 | Priority Mail 2-Day | 4 | 0.85 lbs | $9.61 | $8.76 | $0.85 |
| 212124 | 2020-05-12 | $305.00 | Ground | 5 | 23.20 lbs | $36.45 | $26.11 | $10.34 |
| 212125 | 2020-05-12 | $46.54 | Priority Mail 2-Day Small Flat Rate Box | 4 | 1.30 lbs | $8.50 | $7.65 | $0.85 |
| 212126 | 2020-05-12 | $7.90 | USPSFirstClass | 1 | 0.03 lbs | $4.19 | $2.93 | $1.26 |
| 212127 | 2020-05-12 | $39.36 | Priority Mail 3-Day | 3 | 1.65 lbs | $11.39 | $10.53 | $0.86 |
| 212128 | 2020-05-12 | $16.33 | USPSFirstClass | 1 | 0.05 lbs | $4.45 | $2.78 | $1.67 |
| 212131 | 2020-05-13 | $10.32 | USPSFirstClass | 1 | 0.05 lbs | $4.19 | $3.25 | $0.94 |
| 212132 | 2020-05-13 | $13.94 | USPSFirstClass | 2 | 0.65 lbs | $5.64 | $5.27 | $0.37 |
| 212133 | 2020-05-12 | $121.16 | Ground | 1 | 3.00 lbs | $21.17 | $17.10 | $4.07 |
| 212134 | 2020-05-12 | $29.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.25 lbs | $8.00 | $7.65 | $0.35 |
| 212135 | 2020-05-12 | $4.19 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $3.20 | $2.78 | $0.42 |
| 212136 | 2020-05-13 | $20.48 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.21 lbs | $8.00 | $7.65 | $0.35 |
| 212137 | 2020-05-13 | $6.47 | USPSFirstClass | 1 | 0.10 lbs | $0.95 | $3.18 | $-2.23 |
| 212138 | 2020-05-13 | $21.64 | USPSFirstClass | 3 | 0.30 lbs | $5.05 | $2.93 | $2.12 |
| 212139 | 2020-05-13 | $31.29 | Priority Mail 3-Day | 10 | 1.41 lbs | $11.39 | $10.53 | $0.86 |
| 212140 | 2020-05-13 | $93.69 | Priority Mail 2-Day | 9 | 2.94 lbs | $11.18 | $10.33 | $0.85 |
| 212142 | 2020-05-13 | $19.62 | First-Class Mail Stamped Letter | 3 | 0.18 lbs | $3.65 | $3.25 | $0.40 |
| 212144 | 2020-05-13 | $38.45 | Priority Mail 3-Day | 2 | 1.05 lbs | $8.97 | $8.12 | $0.85 |
| 212145 | 2020-05-14 | $18.88 | USPSFirstClass | 3 | 0.30 lbs | $5.21 | $4.46 | $0.75 |
| 212146 | 2020-05-14 | $4.74 | USPSFirstClass | 1 | 0.05 lbs | $0.75 | $2.84 | $-2.09 |
| 212147 | 2020-05-13 | $19.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 212148 | 2020-05-14 | $20.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 212150 | 2020-05-14 | $24.62 | First-Class Mail Stamped Letter | 3 | 0.18 lbs | $3.65 | $3.52 | $0.13 |
| 212151 | 2020-05-14 | $48.18 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.70 lbs | $8.00 | $7.65 | $0.35 |
| 212156 | 2020-05-14 | $25.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 3.50 lbs | $8.00 | $7.65 | $0.35 |
| 212157 | 2020-05-14 | $56.72 | FedExHomeDelivery | 1 | 1.15 lbs | $14.50 | $15.63 | $-1.13 |
| 212158 | 2020-05-14 | $34.18 | Priority Mail 3-Day | 1 | 0.95 lbs | $11.39 | $10.54 | $0.85 |
| 212159 | 2020-05-14 | $15.31 | USPSFirstClass | 2 | 0.20 lbs | $4.20 | $2.84 | $1.36 |
| 212160 | 2020-05-14 | $23.30 | First-Class Package Service | 1 | 0.40 lbs | $4.91 | $4.46 | $0.45 |
| 212161 | 2020-05-14 | $41.23 | Priority Mail 2-Day Flat Rate Envelope | 27 | 0.48 lbs | $8.00 | $7.65 | $0.35 |
| 212162 | 2020-05-14 | $39.37 | Priority Mail 3-Day | 2 | 1.05 lbs | $11.39 | $10.54 | $0.85 |
| 212163 | 2020-05-15 | $7.46 | USPSFirstClass | 1 | 0.07 lbs | $4.19 | $3.05 | $1.14 |
| 212165 | 2020-05-14 | $22.50 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.50 | $3.05 | $0.45 |
| 212166 | 2020-05-14 | $7.70 | First-Class Mail Stamped Letter | 1 | 0.07 lbs | $3.35 | $2.78 | $0.57 |
| 212170 | 2020-05-14 | $21.92 | Priority Mail 3-Day Flat Rate Envelope | 8 | 0.18 lbs | $8.00 | $7.65 | $0.35 |
| 212172 | 2020-05-15 | $24.94 | First-Class Package Service | 1 | 0.65 lbs | $5.65 | $5.40 | $0.25 |
| 212173 | 2020-05-15 | $69.08 | Priority Mail 2-Day | 2 | 1.85 lbs | $13.00 | $12.15 | $0.85 |
| 212174 | 2020-05-15 | $31.04 | Priority Mail 2-Day Small Flat Rate Box | 6 | 0.66 lbs | $8.50 | $7.65 | $0.85 |
| 212175 | 2020-05-15 | $18.36 | USPSFirstClass | 1 | 0.29 lbs | $5.49 | $3.05 | $2.44 |
| 212176 | 2020-05-15 | $36.51 | Priority Mail 3-Day Padded Flat Rate Envelope | 9 | 0.72 lbs | $8.60 | $7.65 | $0.95 |
| 212177 | 2020-05-15 | $17.53 | USPSFirstClass | 1 | 0.60 lbs | $6.26 | $5.70 | $0.56 |
| 212178 | 2020-05-15 | $23.89 | USPSFirstClass | 5 | 1.00 lbs | $13.08 | $10.53 | $2.55 |
| 212180 | 2020-05-15 | $80.76 | Priority Mail 3-Day | 11 | 5.39 lbs | $21.31 | $13.20 | $8.11 |
| 212181 | 2020-05-16 | $20.18 | USPSFirstClass | 2 | 1.22 lbs | $11.66 | $10.54 | $1.12 |
| 212182 | 2020-05-15 | $38.78 | Priority Mail 3-Day Padded Flat Rate Envelope | 2 | 1.30 lbs | $8.60 | $7.65 | $0.95 |
| 212183 | 2020-05-16 | $18.76 | USPSFirstClass | 1 | 0.27 lbs | $5.50 | $4.32 | $1.18 |
| 212184 | 2020-05-16 | $41.29 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.50 lbs | $8.50 | $7.65 | $0.85 |
| 212185 | 2020-05-16 | $20.57 | Priority Mail 3-Day Padded Flat Rate Envelope | 3 | 0.36 lbs | $8.60 | $7.65 | $0.95 |
| 212186 | 2020-05-16 | $38.29 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.15 lbs | $8.50 | $7.65 | $0.85 |
| 212187 | 2020-05-16 | $22.58 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 2.04 lbs | $8.60 | $7.75 | $0.85 |
| 212188 | 2020-05-16 | $41.18 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.28 lbs | $8.00 | $7.65 | $0.35 |
| 212192 | 2020-05-16 | $17.89 | Priority Mail 2-Day Flat Rate Envelope | 11 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 212194 | 2020-05-16 | $47.58 | InternationalPriorityShipping | 2 | 0.10 lbs | $8.50 | $3.39 | $5.11 |
| 212196 | 2020-05-16 | $31.44 | Priority Mail 2-Day Flat Rate Envelope | 6 | 0.25 lbs | $8.00 | $7.65 | $0.35 |
| 212199 | 2020-05-16 | $8.73 | USPSFirstClass | 1 | 0.34 lbs | $4.87 | $4.00 | $0.87 |
| 212202 | 2020-05-16 | $11.85 | USPSFirstClass | 1 | 0.19 lbs | $4.25 | $2.78 | $1.47 |
| 212204 | 2020-05-16 | $38.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.15 lbs | $8.50 | $7.65 | $0.85 |
| 212205 | 2020-05-16 | $6.62 | USPSFirstClass | 1 | 0.05 lbs | $4.02 | $2.78 | $1.24 |
| 212206 | 2020-05-16 | $29.26 | Priority Mail 2-Day | 8 | 2.23 lbs | $9.44 | $8.59 | $0.85 |
| 212208 | 2020-05-16 | $16.31 | First-Class Mail Stamped Letter | 4 | 0.06 lbs | $3.35 | $3.18 | $0.17 |
| 212209 | 2020-05-17 | $10.84 | USPSFirstClass | 1 | 0.10 lbs | $4.24 | $2.84 | $1.40 |
| 212211 | 2020-05-16 | $10.76 | First-Class Mail Stamped Letter | 9 | 0.09 lbs | $3.35 | $2.84 | $0.51 |
| 212212 | 2020-05-17 | $48.33 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.70 lbs | $8.00 | $7.65 | $0.35 |
| 212214 | 2020-05-17 | $416.31 | Ground | 8 | 18.05 lbs | $47.19 | $27.86 | $19.33 |
| 212215 | 2020-05-17 | $17.09 | USPSFirstClass | 1 | 0.60 lbs | $6.26 | $5.70 | $0.56 |
| 212216 | 2020-05-17 | $16.33 | USPSFirstClass | 1 | 0.05 lbs | $4.45 | $2.78 | $1.67 |
| 212217 | 2020-05-17 | $43.52 | First-Class Package Service | 1 | 0.45 lbs | $4.53 | $4.08 | $0.45 |
| 212218 | 2020-05-17 | $78.51 | Priority Mail 2-Day | 3 | 2.24 lbs | $14.34 | $10.53 | $3.81 |
| 212219 | 2020-05-17 | $12.04 | USPSFirstClass | 1 | 0.19 lbs | $4.35 | $2.93 | $1.42 |
| 212220 | 2020-05-17 | $23.26 | First-Class Package Service | 1 | 0.45 lbs | $4.77 | $4.32 | $0.45 |
| 212222 | 2020-05-17 | $11.09 | First-Class Mail Stamped Letter | 6 | 0.17 lbs | $3.65 | $3.67 | $-0.02 |
| 212223 | 2020-05-17 | $236.88 | Priority Mail 2-Day | 4 | 17.64 lbs | $24.12 | $22.75 | $1.37 |
| 212224 | 2020-05-17 | $23.84 | Priority Mail 2-Day Flat Rate Envelope | 6 | 0.40 lbs | $8.00 | $7.65 | $0.35 |
| 212225 | 2020-05-17 | $20.28 | Priority Mail 3-Day Small Flat Rate Box | 2 | 0.20 lbs | $8.50 | $7.65 | $0.85 |
| 212227 | 2020-05-17 | $114.44 | Priority Mail 3-Day Medium Flat Rate Box | 1 | 10.70 lbs | $14.45 | $13.20 | $1.25 |
| 212228 | 2020-05-17 | $51.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.50 | $7.65 | $0.85 |
| 212229 | 2020-05-17 | $14.30 | USPSFirstClass | 1 | 0.31 lbs | $5.40 | $4.46 | $0.94 |
| 212230 | 2020-05-17 | $45.19 | Priority Mail 2-Day | 5 | 1.15 lbs | $10.84 | $9.99 | $0.85 |
| 212231 | 2020-05-17 | $9.62 | USPSFirstClass | 1 | 0.10 lbs | $4.46 | $3.18 | $1.28 |
| 212232 | 2020-05-17 | $25.24 | First-Class Package Service | 1 | 0.65 lbs | $5.95 | $5.70 | $0.25 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |