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 |
|---|---|---|---|---|---|---|---|---|
| 211061 | 2020-04-10 | $112.27 | Priority Mail 2-Day | 7 | 3.74 lbs | $10.24 | $9.07 | $1.17 |
| 211062 | 2020-04-10 | $9.47 | First-Class Mail Stamped Letter | 3 | 0.09 lbs | $3.50 | $2.84 | $0.66 |
| 211066 | 2020-04-10 | $132.42 | Priority Mail 3-Day Large Flat Rate Box | 1 | 12.88 lbs | $19.15 | $13.20 | $5.95 |
| 211067 | 2020-04-10 | $31.92 | First-Class Package Service | 5 | 0.47 lbs | $4.57 | $4.32 | $0.25 |
| 211068 | 2020-04-10 | $58.97 | Priority Mail 2-Day Padded Flat Rate Envelope | 3 | 1.20 lbs | $8.60 | $7.65 | $0.95 |
| 211071 | 2020-04-11 | $6.24 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.35 | $3.05 | $0.30 |
| 211072 | 2020-04-11 | $117.75 | Priority Mail 2-Day Flat Rate Envelope | 4 | 5.85 lbs | $8.00 | $7.75 | $0.25 |
| 211073 | 2020-04-11 | $25.07 | First-Class Mail Stamped Letter | 8 | 0.15 lbs | $3.65 | $2.84 | $0.81 |
| 211075 | 2020-04-11 | $37.59 | Priority Mail 2-Day | 5 | 0.85 lbs | $10.84 | $10.42 | $0.42 |
| 211076 | 2020-04-11 | $20.42 | Priority Mail 3-Day Flat Rate Envelope | 8 | 0.73 lbs | $8.00 | $7.65 | $0.35 |
| 211083 | 2020-04-11 | $38.58 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.45 lbs | $8.00 | $7.65 | $0.35 |
| 211085 | 2020-04-11 | $23.93 | Priority Mail 2-Day Flat Rate Envelope | 7 | 0.44 lbs | $8.00 | $7.75 | $0.25 |
| 211086 | 2020-04-11 | $3.54 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.84 | $0.51 |
| 211087 | 2020-04-11 | $16.78 | First-Class Package Service | 5 | 0.55 lbs | $4.33 | $4.08 | $0.25 |
| 211090 | 2020-04-11 | $47.86 | Priority Mail 2-Day Flat Rate Envelope | 14 | 0.54 lbs | $8.00 | $7.65 | $0.35 |
| 211091 | 2020-04-11 | $24.26 | Priority Mail 2-Day Small Flat Rate Box | 6 | 0.30 lbs | $8.50 | $7.65 | $0.85 |
| 211093 | 2020-04-12 | $51.30 | Priority Mail 2-Day | 7 | 1.27 lbs | $8.97 | $8.12 | $0.85 |
| 211096 | 2020-04-12 | $36.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.50 | $7.65 | $0.85 |
| 211100 | 2020-04-12 | $19.79 | First-Class Package Service | 1 | 0.40 lbs | $4.33 | $4.08 | $0.25 |
| 211103 | 2020-04-12 | $6.69 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.20 | $2.78 | $0.42 |
| 211105 | 2020-04-12 | $95.74 | Priority Mail 2-Day Medium Flat Rate Box | 20 | 1.88 lbs | $14.45 | $13.20 | $1.25 |
| 211106 | 2020-04-12 | $84.59 | Direct Link International | 2 | 1.85 lbs | $28.51 | $23.53 | $4.98 |
| 211109 | 2020-04-12 | $18.96 | Priority Mail 3-Day | 1 | 0.95 lbs | $8.97 | $8.12 | $0.85 |
| 211110 | 2020-04-12 | $49.83 | Priority Mail 2-Day | 1 | 1.60 lbs | $10.84 | $9.99 | $0.85 |
| 211112 | 2020-04-12 | $7.76 | First-Class Mail Stamped Letter | 9 | 0.09 lbs | $3.35 | $2.78 | $0.57 |
| 211113 | 2020-04-12 | $37.33 | Priority Mail 2-Day | 6 | 0.89 lbs | $11.39 | $10.53 | $0.86 |
| 211115 | 2020-04-12 | $21.38 | Priority Mail 2-Day | 1 | 0.95 lbs | $11.39 | $10.54 | $0.85 |
| 211116 | 2020-04-12 | $6.47 | First-Class Mail Stamped Letter | 3 | 0.12 lbs | $3.50 | $2.93 | $0.57 |
| 211117 | 2020-04-12 | $23.34 | Priority Mail 1-Day Flat Rate Envelope | 2 | 0.34 lbs | $8.00 | $7.65 | $0.35 |
| 211119 | 2020-04-12 | $6.69 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.20 | $2.78 | $0.42 |
| 211121 | 2020-04-12 | $73.68 | Priority Mail 2-Day | 6 | 1.85 lbs | $9.44 | $7.65 | $1.79 |
| 211123 | 2020-04-12 | $24.48 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.00 | $7.15 | $0.85 |
| 211125 | 2020-04-13 | $36.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.50 | $7.65 | $0.85 |
| 211127 | 2020-04-13 | $11.97 | First-Class Mail Stamped Letter | 3 | 0.09 lbs | $3.50 | $2.78 | $0.72 |
| 211128 | 2020-04-13 | $30.82 | Priority Mail 2-Day | 2 | 2.20 lbs | $9.44 | $8.21 | $1.23 |
| 211129 | 2020-04-13 | $6.69 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.20 | $3.39 | $-0.19 |
| 211132 | 2020-04-13 | $14.29 | First-Class Package Service | 2 | 0.54 lbs | $4.71 | $4.46 | $0.25 |
| 211134 | 2020-04-13 | $14.66 | Priority Mail 3-Day Small Flat Rate Box | 4 | 0.27 lbs | $8.50 | $7.65 | $0.85 |
| 211136 | 2020-04-13 | $214.62 | Priority Mail 3-Day | 1 | 14.05 lbs | $21.63 | $21.77 | $-0.14 |
| 211137 | 2020-04-13 | $24.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $7.65 | $0.35 |
| 211141 | 2020-04-13 | $29.50 | First-Class Package Service | 2 | 0.60 lbs | $5.72 | $5.27 | $0.45 |
| 211142 | 2020-04-13 | $17.48 | First-Class Mail Stamped Letter | 2 | 0.12 lbs | $3.50 | $2.74 | $0.76 |
| 211145 | 2020-04-13 | $15.49 | First-Class Package Service | 4 | 0.40 lbs | $4.43 | $4.18 | $0.25 |
| 211148 | 2020-04-13 | $26.39 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $7.75 | $0.25 |
| 211150 | 2020-04-13 | $35.79 | Priority Mail 2-Day | 5 | 0.44 lbs | $10.84 | $7.98 | $2.86 |
| 211151 | 2020-04-13 | $15.47 | First-Class Mail Stamped Letter | 3 | 0.12 lbs | $3.50 | $3.05 | $0.45 |
| 211154 | 2020-04-13 | $8.71 | First-Class Mail Stamped Letter | 4 | 0.20 lbs | $3.35 | $3.05 | $0.30 |
| 211156 | 2020-04-13 | $14.13 | First-Class Package Service | 4 | 0.44 lbs | $4.57 | $4.32 | $0.25 |
| 211158 | 2020-04-13 | $44.60 | Priority Mail 2-Day | 1 | 1.35 lbs | $9.61 | $8.92 | $0.69 |
| 211159 | 2020-04-13 | $8.54 | First-Class Mail Stamped Letter | 1 | 0.08 lbs | $3.35 | $2.74 | $0.61 |
| 211160 | 2020-04-13 | $6.19 | First-Class Mail Stamped Letter | 1 | 0.02 lbs | $3.20 | $3.05 | $0.15 |
| 211161 | 2020-04-13 | $20.15 | First-Class Package Service | 1 | 0.35 lbs | $4.18 | $3.21 | $0.97 |
| 211163 | 2020-04-13 | $4.19 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $3.20 | $3.18 | $0.02 |
| 211164 | 2020-04-13 | $17.48 | First-Class Mail Stamped Letter | 2 | 0.12 lbs | $3.50 | $3.31 | $0.19 |
| 211165 | 2020-04-13 | $124.24 | Priority Mail 3-Day | 6 | 3.70 lbs | $11.49 | $8.92 | $2.57 |
| 211166 | 2020-04-13 | $97.41 | Priority Mail 3-Day | 3 | 2.51 lbs | $14.34 | $11.13 | $3.21 |
| 211169 | 2020-04-13 | $8.33 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.35 | $2.78 | $0.57 |
| 211170 | 2020-04-13 | $48.38 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.62 lbs | $8.00 | $7.65 | $0.35 |
| 211171 | 2020-04-14 | $31.88 | Priority Mail 2-Day Flat Rate Envelope | 6 | 1.15 lbs | $8.00 | $7.75 | $0.25 |
| 211172 | 2020-04-14 | $88.38 | Priority Mail International Flat Rate Envelope | 2 | 1.84 lbs | $37.50 | $37.60 | $-0.10 |
| 211174 | 2020-04-14 | $79.70 | Priority Mail 2-Day | 4 | 2.00 lbs | $14.34 | $13.20 | $1.14 |
| 211176 | 2020-04-14 | $62.83 | Priority Mail 2-Day | 21 | 1.13 lbs | $12.04 | $8.42 | $3.62 |
| 211177 | 2020-04-14 | $6.14 | First-Class Mail Stamped Letter | 1 | 0.07 lbs | $3.35 | $2.78 | $0.57 |
| 211179 | 2020-04-14 | $33.20 | Priority Mail 3-Day | 1 | 1.30 lbs | $10.84 | $9.99 | $0.85 |
| 211181 | 2020-04-14 | $23.62 | First-Class Package Service | 1 | 0.60 lbs | $4.33 | $4.08 | $0.25 |
| 211185 | 2020-04-14 | $148.52 | Priority Mail 2-Day | 1 | 9.60 lbs | $18.53 | $16.89 | $1.64 |
| 211186 | 2020-04-14 | $13.97 | First-Class Mail Stamped Letter | 3 | 0.15 lbs | $3.50 | $2.93 | $0.57 |
| 211187 | 2020-04-14 | $38.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.00 lbs | $8.50 | $7.65 | $0.85 |
| 211188 | 2020-04-14 | $45.10 | Priority Mail 2-Day | 14 | 3.50 lbs | $10.24 | $9.07 | $1.17 |
| 211190 | 2020-04-14 | $28.18 | Priority Mail 2-Day | 6 | 1.50 lbs | $10.84 | $9.99 | $0.85 |
| 211192 | 2020-04-14 | $48.81 | Priority Mail 3-Day | 1 | 1.70 lbs | $13.00 | $9.99 | $3.01 |
| 211194 | 2020-04-14 | $11.74 | First-Class Package Service | 3 | 0.51 lbs | $4.57 | $4.32 | $0.25 |
| 211196 | 2020-04-14 | $13.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.45 lbs | $8.50 | $7.65 | $0.85 |
| 211199 | 2020-04-14 | $12.38 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 211201 | 2020-04-14 | $26.97 | Priority Mail 3-Day Small Flat Rate Box | 3 | 0.23 lbs | $8.50 | $7.65 | $0.85 |
| 211202 | 2020-04-14 | $84.29 | Priority Mail 2-Day | 15 | 4.29 lbs | $10.24 | $9.39 | $0.85 |
| 211203 | 2020-04-15 | $41.15 | First-Class Package Service | 3 | 0.61 lbs | $5.65 | $5.40 | $0.25 |
| 211205 | 2020-04-15 | $13.88 | First-Class Mail Stamped Letter | 2 | 0.15 lbs | $3.50 | $2.93 | $0.57 |
| 211206 | 2020-04-15 | $43.19 | First-Class Package Service | 6 | 0.74 lbs | $5.65 | $9.98 | $-4.33 |
| 211208 | 2020-04-15 | $41.59 | Priority Mail 3-Day Padded Flat Rate Envelope | 1 | 0.55 lbs | $8.60 | $7.75 | $0.85 |
| 211209 | 2020-04-15 | $51.17 | Priority Mail 3-Day | 1 | 1.20 lbs | $11.39 | $10.54 | $0.85 |
| 211210 | 2020-04-15 | $32.42 | Priority Mail 1-Day | 8 | 2.95 lbs | $8.79 | $7.94 | $0.85 |
| 211211 | 2020-04-15 | $7.64 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.20 | $2.74 | $0.46 |
| 211212 | 2020-04-15 | $48.83 | Priority Mail 3-Day | 1 | 1.20 lbs | $12.04 | $11.19 | $0.85 |
| 211213 | 2020-04-15 | $33.59 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 2.57 lbs | $8.60 | $7.75 | $0.85 |
| 211214 | 2020-04-15 | $42.59 | Priority Mail 2-Day | 1 | 1.15 lbs | $9.61 | $8.76 | $0.85 |
| 211215 | 2020-04-15 | $187.27 | Ground | 10 | 24.51 lbs | $74.25 | $43.35 | $30.90 |
| 211218 | 2020-04-15 | $13.82 | First-Class Mail Stamped Letter | 3 | 0.15 lbs | $3.35 | $2.93 | $0.42 |
| 211219 | 2020-04-15 | $45.58 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.30 lbs | $8.00 | $7.65 | $0.35 |
| 211220 | 2020-04-15 | $6.34 | First-Class Mail Stamped Letter | 1 | 0.04 lbs | $3.35 | $2.78 | $0.57 |
| 211223 | 2020-04-15 | $27.46 | Priority Mail 2-Day | 1 | 0.70 lbs | $8.97 | $8.12 | $0.85 |
| 211225 | 2020-04-15 | $8.24 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.18 | $0.17 |
| 211226 | 2020-04-15 | $4.18 | First-Class Mail Stamped Letter | 2 | 0.02 lbs | $3.20 | $2.84 | $0.36 |
| 211227 | 2020-04-15 | $8.54 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.18 | $0.17 |
| 211229 | 2020-04-15 | $50.59 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.50 lbs | $8.50 | $7.65 | $0.85 |
| 211231 | 2020-04-15 | $18.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.02 lbs | $8.00 | $7.65 | $0.35 |
| 211234 | 2020-04-16 | $13.25 | First-Class Mail Stamped Letter | 10 | 0.04 lbs | $3.35 | $2.78 | $0.57 |
| 211235 | 2020-04-16 | $38.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.50 | $7.65 | $0.85 |
| 211236 | 2020-04-16 | $79.94 | Priority Mail 3-Day | 6 | 2.60 lbs | $13.00 | $10.42 | $2.58 |
| 211237 | 2020-04-16 | $7.34 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.18 | $0.17 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |