Problem
When sales, stock, finance, support, and reporting sit in separate places, teams repeat work and make decisions from inconsistent information.
Connected E-commerce SystemConnected E-commerce + Finance SystemIdol Fairies
Portfolio demo — synthetic dataAI-assisted build
A live K-pop merchandise storefront feeds the same system used for orders, inventory, finance, customer support, and reporting. Staff and owners get different views of the same reliable business data instead of maintaining disconnected records.
Built with
Next.jsn8nSupabaseGeminiMetabaseGmail
Solution
One shared system connects every shopper action to the operational work that follows, from support and order handling to finance and reporting.
Result
Staff work from one operational view, while owners see clear performance without rebuilding the same records in multiple tools.
System Map
How the System Works
Start with the three system branches, then open the parts you want to inspect.
Idol Fairies Connected Commerce System
Demonstration
See the Automation in Action
Project Screenshots and Outputs
Explore the current storefront, operations, AI support, finance workflows, and management reporting behind the connected system.
Storefront & Ordering
Problem
A K-pop merch store needs an online storefront where customers can browse, check stock accurately, and check out — without the owner manually tracking what's sold out.
Solution
A public storefront (shop, category pages, product pages, cart, checkout) shows only two real states — In Stock or Sold Out — pulled from the same inventory data the rest of the system uses, so there's no separate 'website copy' of stock that can drift out of sync.
Result
No manual product/stock updates on a second system; what's shown to shoppers is always the same number used internally.
Verified Workflows
Download regression reportTest Results
41 of 41 tests passed across seven business workflows, with no blocking defects in the final tested implementations.
| Test Area | What We Verify | Result |
|---|---|---|
| B2C Sales Webhook | Order creation, duplicate protection, stock rules, multi-item orders, and invalid input | PASS — 5/5 |
| Wholesale Sales & AR | Existing and new resellers, negotiated prices, stock handling, and invalid input | PASS — 5/5 |
| AR Payment Reminder | Partial payments, duplicates, unmatched payments, invalid input, and overpayments | PASS — 5/5 |
| Inventory Purchase & AP | Supplier draft intake, item extraction, owner confirmation, and invalid or duplicate invoices | PASS — 5/5 |
| AP Payment Reminder | Full, partial, and credit payments; unmatched and invalid payments; duplicate protection | PASS — 6/6 |
| Expense Automation | Expense capture, file archival, duplicate prevention, supplier routing, and categorization | PASS — 10/10 |
| Refund Automation | Resellable and damaged refunds, quantity limits, and product or order validation | PASS — 5/5 |
Turn Disconnected Operations into One Dependable System.
Share where orders, support, inventory, or finance break apart today. I’ll map the clearest practical next step.