Read the farm books
509 kit entries read from nine farm workbooks, 504 of them usable. Re-reading the full set of 16 farm books takes about 27 seconds whenever the farms send updates.
FiftyFlowers · Product data
Hundreds of kit recipes and 2,789 arrangement plans, moved and checked.
Matched farm spreadsheets to store products and wrote recipes, purchase links and 2,789 arrangement plans onto a test copy of the store, each traced to its source.
A kit’s arrangement plan on the test copy: each piece to make, how many, and its stems by section. The internal product number is covered.
The context
A problem worth solving.
DIY flower kits were defined across farm workbooks and a large internal planning workbook. The store’s product system needed the same recipes, purchase links and arrangement plans, without hand entry and without silent changes.
My contribution
What I brought to the work.
Built the readers, matchers and writers with source tracking, so every written value traces to the worksheet cell it came from and every worksheet ends with a recorded outcome.
The product
What it makes possible.
Match and write
498 entries matched to store products; recipes and purchase links written for 494, with the rest held for a reason recorded beside them.
Arrangements
All 255 planning worksheets have an outcome; 2,789 arrangements on 139 kits were written, each checked against its worksheet.
Nothing silently changed
Every substitution, missing flower or shortfall went into review lists for the merchandising team instead of being guessed.
At a glance / simplified product view
- 01Farm and planning workbooks
- 02Matched products
- 03Checked recipes and arrangements
Where it stands
Delivered on a test copy.
Delivered on a test copy of the store; moving it into the live store is the company’s next step.
Same company
More from FiftyFlowers.
FiftyFlowers overview
Company Second BrainMVP · live since July 2026, two of seven team brains filled
Content EngineIn the company AI workspace since June 2026 · nothing published through it yet
Image StudioIn production · released August 2026
Proposal ManagerBuilt from the team’s wireframes · not launched
Customer service AIIn production · since January 2026
Storefront requestsRush form live · contest processing run on 2025 entries
AI Floral AssistantIn the store theme · behind an A/B test since January 2026