| Parent / Product | Units | Sales | Ref | Ref Cost | % Ref | Ads | Fees | COGS | Net Profit | Margin | R.ACOS | Sessions | USP | BB % | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Metal Solar Torch Lights | 292 | $22,985 | 24 | -$1,099 | 8.22% | -$2,767 | -$7,971 | -$8,561 | $1,903 | 8.28% | 12.04% | 4,187 | 6.97% | 99.86% | Thin |
| Flickering Light Bulbs (E12 + E26) | 995 | $17,638 | 44 | -$499 | 4.42% | -$4,037 | -$6,666 | -$5,575 | $476 | 2.70% | 22.89% | 8,697 | 11.44% | 99.88% | Monitor |
| Metal Solar Lanterns | 230 | $14,420 | 19 | -$674 | 8.26% | -$3,298 | -$4,608 | -$4,988 | $444 | 3.08% | 22.87% | 4,524 | 5.08% | 99.89% | Thin |
| Bluetooth Outdoor Speaker | 255 | $8,651 | 17 | -$545 | 6.67% | -$2,126 | -$3,036 | -$2,624 | $125 | 1.45% | 24.58% | 3,389 | 7.52% | 99.80% | Monitor |
| Rustic Solar Torch Lights | 151 | $7,328 | 2 | -$97 | 1.32% | -$1,092 | -$2,469 | -$2,395 | $1,071 | 14.62% | 14.90% | 1,787 | 8.45% | 95.37% | Healthy |
| Solar String Lights | 129 | $4,463 | 7 | -$182 | 5.43% | -$1,399 | -$1,512 | -$962 | $293 | 6.57% | 31.34% | 1,984 | 6.50% | 99.28% | Thin |
| Solar Pathway Lights | 91 | $3,468 | 7 | -$173 | 7.69% | -$878 | -$1,118 | -$955 | $233 | 6.72% | 25.32% | 1,229 | 7.40% | 99.63% | Thin |
| Classic Solar Pathway Lights | 48 | $2,140 | 3 | -$61 | 6.25% | -$441 | -$595 | -$681 | $295 | 13.81% | 20.61% | 700 | 6.86% | 98.15% | Healthy |
| Schoolhouse Solar Lanterns | 60 | $1,803 | 9 | -$168 | 15.00% | -$670 | -$662 | -$421 | -$166 | -9.23% | 37.16% | 1,113 | 5.39% | 99.77% | Loss-making |
| Modern Solar Lanterns | 54 | $1,783 | 17 | -$430 | 31.48% | -$1,194 | -$738 | -$458 | -$1,105 | -61.96% | 66.96% | 1,748 | 3.09% | 99.92% | Loss-making |
| 2.0 Metal Solar Lanterns | 22 | $1,728 | 2 | -$81 | 9.09% | -$304 | -$503 | -$599 | $187 | 10.80% | 17.62% | 458 | 4.80% | 99.48% | Thin |
| 2.0 Lantern, discontinued variation | 0 | $0 | 0 | $0 | 0.00% | $0 | -$38 | $0 | -$38 | 0.00% | 0.00% | 0 | 0.00% | 100.00% | Loss-making |
| Total (12 parents) | 2,327 | $86,407 | 151 | -$4,010 | 6.49% | -$18,206 | -$29,915 | -$28,219 | $3,717 | 4.30% | 21.07% | 29,816 | 7.80% | 99.58% |
| SKU | ASIN | Product | Units | Sales | Ref | Ref Cost | % Ref | Promo | Ads | Fees | COGS | Net Profit | Margin | R.ACOS | Sessions | USP | BB % |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FFMST4-FBA | B0D4P21Z9N | Metal Solar Torch Lights, Solar Tiki Torches | 102 | $12,722 | 9 | -$717 | 8.82% | -$118 | -$107 | -$4,710 | -$5,003 | $1,813 | 14.25% | 0.84% | 636 | 16.04% | 100.00% |
| FFMST2-FBA | B0D4PC4JV8 | Metal Solar Torch Lights, Solar Tiki Torches | 107 | $7,387 | 3 | -$118 | 2.80% | -$86 | -$846 | -$2,225 | -$2,544 | $1,420 | 19.22% | 11.45% | 1,277 | 8.38% | 99.82% |
| FFMLB1_1PK | B0FC8B47CH | Flickering Light Bulbs, E26 Base, 2000K Warm | 535 | $5,846 | 21 | -$142 | 3.93% | -$15 | -$2,509 | -$2,936 | -$1,490 | -$1,363 | -23.31% | 42.91% | 3,710 | 14.42% | 99.83% |
| FFMDL4-FBA | B0D4PKWHLT | Metal Solar Lanterns Outdoor Waterproof,Pate | 48 | $5,718 | 2 | -$126 | 4.17% | -$72 | -$176 | -$1,816 | -$2,096 | $1,319 | 23.07% | 3.07% | 428 | 11.21% | 100.00% |
| FFBT1B_1PK | B0FC7NG9LG | Bluetooth Outdoor Speaker, Patented Fire Eff | 160 | $5,550 | 13 | -$424 | 8.12% | -$11 | -$1,517 | -$1,678 | -$1,774 | $36 | 0.65% | 27.33% | 2,191 | 7.30% | 100.00% |
| FFMDL2-FBA | B0D4PJ7BTD | Metal Solar Lanterns Outdoor Waterproof,Pate | 86 | $5,351 | 6 | -$268 | 6.98% | -$32 | -$1,249 | -$1,662 | -$1,840 | $193 | 3.60% | 23.34% | 1,801 | 4.78% | 99.86% |
| FFCLB1_4pk | B0GS5N1RMH | Flickering Light Bulbs, E12 Base, 2000K Warm | 197 | $4,923 | 0 | $0 | 0.00% | $0 | -$630 | -$1,588 | -$1,858 | $749 | 15.21% | 12.81% | 1,951 | 10.10% | 99.96% |
| FFMLB1_4PK | B0FC8TDNKK | Flickering Light Bulbs, E26 Base, 2000K Warm | 154 | $4,798 | 14 | -$227 | 9.09% | -$14 | -$336 | -$1,521 | -$1,641 | $964 | 20.10% | 6.99% | 1,677 | 9.18% | 99.78% |
| FFPST2B_4pk | B0FC8CJQ6J | Rustic Solar Torch Lights, Solar Tiki Torche | 56 | $4,479 | 1 | -$70 | 1.79% | -$36 | -$369 | -$1,398 | -$1,677 | $840 | 18.76% | 8.23% | 648 | 8.64% | 92.01% |
| FFSSL1_1PK | B0FC8TFYPJ | Solar String Lights Outdoor Waterproof, Pate | 129 | $4,463 | 7 | -$182 | 5.43% | -$26 | -$1,399 | -$1,512 | -$962 | $293 | 6.57% | 31.34% | 1,984 | 6.50% | 99.28% |
| FFMDL1 | B0D4NJG2YM | Metal Solar Lanterns Outdoor Waterproof,Pate | 96 | $3,350 | 11 | -$280 | 11.46% | -$16 | -$1,873 | -$1,130 | -$1,052 | -$1,068 | -31.87% | 55.91% | 2,295 | 4.18% | 99.97% |
| FFBT1_1PK | B0FC88SR1Z | Bluetooth Outdoor Speaker, Patented Fire Eff | 95 | $3,101 | 4 | -$122 | 4.21% | -$10 | -$609 | -$1,358 | -$850 | $89 | 2.87% | 19.65% | 1,198 | 7.93% | 99.67% |
| FFMST1 | B0D4MQY6MT | Metal Solar Torch Lights, Solar Tiki Torches | 83 | $2,876 | 12 | -$264 | 14.46% | -$21 | -$1,814 | -$1,035 | -$1,013 | -$1,330 | -46.25% | 63.09% | 2,274 | 3.65% | 99.97% |
| FFPST2B_1PK | B0FC8CHYHQ | Rustic Solar Torch Lights, Solar Tiki Torche | 95 | $2,849 | 1 | -$26 | 1.05% | -$22 | -$723 | -$1,071 | -$718 | $231 | 8.11% | 25.38% | 1,139 | 8.34% | 99.16% |
| FSST3_6pk | B0FC7F3D1B | Solar Pathway Lights Outdoor Waterproof, Pat | 60 | $2,759 | 4 | -$122 | 6.67% | -$41 | -$579 | -$845 | -$814 | $303 | 10.98% | 20.98% | 753 | 7.97% | 99.68% |
| FSST4_6PK | B0FC7F42KM | Classic Solar Pathway Lights Outdoor Waterpr | 39 | $1,897 | 0 | $0 | 0.00% | -$22 | -$120 | -$530 | -$629 | $557 | 29.35% | 6.35% | 284 | 13.73% | 96.37% |
| FFCLB1_2pk | B0GS5B8T3B | Flickering Light Bulbs, E12 Base, 2000K Warm | 88 | $1,671 | 5 | -$84 | 5.68% | $0 | -$535 | -$493 | -$467 | $59 | 3.55% | 32.01% | 1,123 | 7.84% | 100.00% |
| FFPFL1_2PK | B0FC8NMB5Z | Modern Solar Lanterns Outdoor Waterproof, Pa | 33 | $1,280 | 9 | -$296 | 27.27% | -$18 | -$401 | -$500 | -$346 | -$308 | -24.05% | 31.33% | 649 | 5.08% | 100.00% |
| FFSHL1_2PK | B0FC8TSRC2 | Schoolhouse Solar Lanterns Outdoor Waterproo | 30 | $1,200 | 8 | -$153 | 26.67% | -$2 | -$236 | -$409 | -$279 | $97 | 8.11% | 19.64% | 443 | 6.77% | 99.82% |
| FFMDL1_2PK | B0GSCFW1MF | 2.0 Metal Solar Lanterns Outdoor Waterproof, | 16 | $1,008 | 2 | -$81 | 12.50% | -$19 | -$235 | -$295 | -$342 | $15 | 1.47% | 23.35% | 349 | 4.58% | 99.76% |
| FFMDL1_4PK | B0GSC33718 | 2.0 Metal Solar Lanterns Outdoor Waterproof, | 6 | $720 | 0 | $0 | 0.00% | $0 | -$69 | -$208 | -$257 | $172 | 23.86% | 9.60% | 109 | 5.50% | 100.00% |
| FSST3_2pk | B0FC7K7HRV | Solar Pathway Lights Outdoor Waterproof, Pat | 31 | $708 | 3 | -$52 | 9.68% | $0 | -$299 | -$272 | -$141 | -$70 | -9.88% | 42.20% | 476 | 6.51% | 100.00% |
| FFSHL1_1PK | B0FC8QT5FB | Schoolhouse Solar Lanterns Outdoor Waterproo | 30 | $603 | 1 | -$16 | 3.33% | -$10 | -$434 | -$253 | -$142 | -$264 | -43.75% | 72.01% | 670 | 4.48% | 100.00% |
| FFPFL1_1PK | B0FC8TKJ58 | Modern Solar Lanterns Outdoor Waterproof, Pa | 21 | $504 | 8 | -$134 | 38.10% | -$14 | -$793 | -$238 | -$111 | -$797 | -158.24% | 157.45% | 1,099 | 1.91% | 100.00% |
| FFMLB1_2PK | B0FC8DV484 | Flickering Light Bulbs, E26 Base, 2000K Warm | 21 | $399 | 4 | -$46 | 19.05% | -$3 | -$27 | -$129 | -$120 | $66 | 16.53% | 6.80% | 236 | 8.90% | 100.00% |
| FSST4_2PK | B0FC7H65MX | Classic Solar Pathway Lights Outdoor Waterpr | 9 | $243 | 3 | -$61 | 33.33% | -$1 | -$321 | -$65 | -$52 | -$261 | -107.56% | 131.95% | 416 | 2.16% | 100.00% |
| FFMDL1_1PK | B0GSC6TLNS | Upgraded Metal Outdoor Solar Lantern, Flicke | 0 | $0 | 0 | $0 | 0.00% | $0 | $0 | -$38 | $0 | -$38 | 0.00% | 0.00% | 0 | 0.00% | 0.00% |
| Total | 27 ASINs | 2,327 | $86,407 | 151 | -$4,010 | 6.49% | -$611 | -$18,206 | -$29,915 | -$28,219 | $3,717 | 4.30% | 21.07% | 29,816 | 7.80% | 99.63% |
| Marketplace | Units | Sales | Ref | Ref Cost | % Ref | Ads | Fees | COGS | Net Pft | Margin | R.ACOS | Sess | USP | BB % | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 🇺🇸 Amazon.com (US) | 2,327 | $86,357 | 151 | -$4,010 | 6.49% | -$18,206 | -$29,924 | -$28,200 | $5,405 | 6.26% | 21.08% | 29,816 | 7.80% | 99.59% | Stock constrained |
| Total (all channels) | 2,327 | $86,357 | 151 | -$4,010 | 6.49% | -$18,206 | -$29,924 | -$28,200 | $5,405 | 6.26% | 21.08% | 29,816 | 7.80% | 99.59% |
| Portfolio | Spend | Ad Sales | ACOS | CVR | Aug ACOS | Change | % of Spend | Status |
|---|---|---|---|---|---|---|---|---|
| FFMDL1 (Metal Lantern) | $2,970.35 | $6,336.38 | 46.88% | 2.72% | 34.57% | +12.31 pp | 16.3% | Monitor |
| Branded (Brand Defense) | $2,710.24 | $12,293.06 | 22.05% | 9.10% | 21.97% | +0.08 pp | 14.9% | Efficient |
| FFMLB1 (E26 Bulbs) | $2,315.99 | $4,593.80 | 50.42% | 9.27% | 40.70% | +9.72 pp | 12.7% | Monitor |
| All (catch-all) | $2,111.84 | $11,038.65 | 19.13% | 10.00% | 12.69% | +6.44 pp | 11.6% | Efficient |
| FFBT1 (Speakers) | $1,773.45 | $3,917.44 | 45.27% | 5.31% | 32.84% | +12.43 pp | 9.7% | Monitor |
| Unassigned | $1,323.69 | $5,881.44 | 22.51% | 3.76% | 28.29% | -5.78 pp | 7.3% | Efficient |
| FFSSL1 (String Lights) | $1,295.76 | $2,004.52 | 64.64% | 3.05% | 45.25% | +19.39 pp | 7.1% | Restructure |
| FFPFL1 (Modern Lantern) | $1,047.06 | $1,196.73 | 87.49% | 2.06% | 45.75% | +41.75 pp | 5.8% | Restructure |
| FSST3 (Path Torch) | $661.62 | $1,573.59 | 42.05% | 5.37% | 33.33% | +8.72 pp | 3.6% | Monitor |
| FFCLB1 (E12 Bulbs) | $629.90 | $1,607.31 | 39.19% | 4.12% | 45.99% | -6.80 pp | 3.5% | Healthy |
| FFPST2B (Rustic Torch) | $502.77 | $2,251.41 | 22.33% | 4.72% | 24.63% | -2.29 pp | 2.8% | Efficient |
| FFSHL1 (Schoolhouse) | $375.98 | $445.70 | 84.36% | 2.48% | 62.81% | +21.55 pp | 2.1% | Restructure |
| Torches (Metal + Rustic) | $333.47 | $477.65 | 69.81% | 2.01% | 65.58% | +4.23 pp | 1.8% | Restructure |
| FSST4 (Path Torch Elite) | $153.64 | $53.98 | 284.62% | 1.43% | 77.07% | +207.56 pp | 0.8% | Restructure |
| Total (Sponsored Ads export) | $18,205.76 | $53,671.66 | 33.92% | 5.63% | 31.45% | +2.47 pp | 100.0% |
Not applicable for this brand. FoxFlame does not currently run Subscribe and Save.
| ASIN | Product (SKU) | Sep Sales | FBA Units | Velocity (u/day) | Days of Supply | Inbound | Health |
|---|---|---|---|---|---|---|---|
| B0GS5N1RMH | FFCLB1_4pk | $4,923 | 0 | 0.28 | 0.0 days | 700 inbound | Out of stock |
| B0GS5B8T3B | FFCLB1_2pk | $1,671 | 1 | 3.85 | 0.3 days | 1,500 inbound | Critical |
| B0D4P21Z9N | FFMST4-FBA | $12,722 | 2 | 2.33 | 0.9 days | 280 inbound | Critical |
| B0FC8B47CH | FFMLB1_1PK | $5,846 | 17 | 17.23 | 1.0 days | 128 inbound | Critical |
| B0FC8DV484 | FFMLB1_2PK | $399 | 2 | 1.20 | 1.7 days | none | Critical |
| B0FC8TDNKK | FFMLB1_4PK | $4,798 | 6 | 3.01 | 2.0 days | 32 inbound | Critical |
| B0D4PJ7BTD | FFMDL2-FBA | $5,351 | 7 | 1.53 | 4.6 days | none | Critical |
| B0FC8CJQ6J | FFPST2B_4pk | $4,479 | 8 | 1.02 | 7.8 days | none | At risk |
| B0D4NJG2YM | FFMDL1, FFMDL2 | $3,350 | 74 | 4.32 | 17.1 days | none | At risk |
| B0D4PKWHLT | FFMDL4-FBA | $5,718 | 45 | 2.57 | 17.5 days | none | At risk |
| B0FC8CHYHQ | FFPST2B_1PK | $2,849 | 64 | 3.46 | 18.5 days | none | At risk |
| B0D4PC4JV8 | FFMST2-FBA | $7,387 | 113 | 6.05 | 18.7 days | 48 inbound | At risk |
| B0GSCFW1MF | FFMDL1_2PK | $1,008 | 19 | 0.88 | 21.6 days | none | Tight |
| Metric | As verified Oct 5 | Target | Status |
|---|---|---|---|
| Account Health Rating | 372 / 1000 | healthy band | Healthy |
| Order Defect Rate (60 days) | 0% (0 of 3,621 orders) | under 1% | Healthy |
| Negative Feedback | 0% | low | Healthy |
| A-to-z Guarantee Claims | 0% | low | Healthy |
| Chargeback Claims | 0% | low | Healthy |
| Late Dispatch / Cancel / Tracking | N/A (FBA) | n/a | FBA |
| Suspected IP Violations | 0 | 0 | Clean |
| Listing Policy Violations | 0 | 0 | Clean |
| Regulatory Compliance | 0 | 0 | Clean |
This is the single highest-value change available and it costs nothing. Spend was flat at $18,205.76 while ad sales fell 6.6%, because the budget stayed pointed at lines that could not ship. FFMDL1 took $2,970.35 at 46.88% ACoS and FFPFL1 $1,047.06 at 87.49%, while FFMST4, at 0.84% real ACoS and $1,812.59 of net profit, absorbed only $106.63 because it had no stock. Set a standing weekly review that caps spend on any SKU under seven days of cover and moves that budget to the SKUs with cover. Without it, October repeats September.
The August report committed to new stock mid-September and the new warehouse going live at the same time, ending the 3PL dependency. September closed with 8 SKUs at zero sellable units and 2,760 units inbound, so the wave had not fully landed by month end. Confirm in writing with Chris what has been received, what is still in transit and what the new warehouse lead times now are, before October advertising budgets are set against it.
FSST4 ran 284.62% ACoS on $153.64 of spend, FFSHL1 84.36%, FFPFL1 87.49% and FFSSL1 64.64%. Together they consumed $2,872.44 and returned $3,700.93. The August report flagged FSST4 and FFSHL1 for restructuring and both got worse. These are not budget-size problems; pull the search term reports, negative out the terms converting at zero, and if a portfolio cannot be brought under 45 per cent within October, take it to a defensive floor rather than carrying it into Q4.
Fees went from 33.2% of sales in August to 34.7% in September, which is worth roughly $1,218.35 of margin on its own and is the second half of the profit story after advertising. Inbound transportation was $1,899.59 and FBA inbound convenience and removal fees $1,239.04, both consistent with stock movement during a warehouse cutover rather than with normal trading. Confirm whether these are one-off cutover costs that disappear in October, because the Q4 plan depends on the answer.
Organic revenue rose +2.5% to $32,685.05 and organic share went from 35.7% to 37.8%, the first improvement in three months and the thing the August report said to watch. It happened despite the stock-outs, which means the listing and conversion work is holding. Unit session percentage improved from 6.56% to 7.80% on 13.6% fewer sessions. Keep the main-image A/B tests running to significance and do not let the October spend push drown the organic signal again.
The workbook books Indirect expense at $413.50 for September, a credit, where August carried -$1,787.31 as a charge. The SellerBoard dashboard, the parent export and this report all apply the standing 2 per cent 3PL fee ($1,727.13) and the $2,400.00 management cost, and the dashboard margin of 1.49 per cent confirms that treatment to two decimal places. The export row is inconsistent with all three. Have it corrected at source so the workbook and the dashboard agree before the Q4 reporting cycle.