Workcase 01 custom system

Multi-marketplace ERP

A hub for sellers on several channels at once. Accounts connect once and the system brings orders, customers, reputation, margin, listings and customer service together in one place. Product, design and code built from scratch.

8
channels integrated
marketplaces and own store
19
screens in the panel
in three groups
180
days of sales
in the bought-together analysis
90
days, at most
of personal data retention
Type
ERP
Year
2026
Scope
Product, design and code
Channels
Mercado Livre · Shopee · Magalu · TikTok Shop · SHEIN · Dafiti · Leroy Merlin · Nuvemshop
erp.yourstore.com/overview
Overview
Your sales and orders in the period
Total sales
R$1.084.512,30
▲31%
+R$ 256.641,10 vs. previous period
This periodR$ 1.084.512,30
Previous periodR$ 827.871,20
30 days agotoday
Sales by marketplaceSee orders
7.618orders in period
Mercado Livre5.18068%
Shopee1.90525%
TikTok Shop3815%
Nuvemshop1522%

The overview, recreated with sample data. Try changing the period.

01 · The challenge

Eight channels, eight dashboards.

Each channel shows orders, fees and reputation its own way, and none of them shows the whole business: what's really left after fees, which customer buys in more than one place, which account is close to losing its reputation, what to restock before it runs out.

02 · The solution

A hub organized around what the seller does.

Inside, a single model for orders, products and stock, with one adapter per channel. On screen, 19 screens grouped into monitor, sell and integrate. Every number comes with context and the next step, so it turns into a decision, not just a report.

03 · Channels

Eight channels, one adapter each.

Each integration talks to the channel's API and translates everything into the same format. Mercado Livre and Shopee are complete; the other six already read what matters and gain the rest over time.

Mercado Livre
Marketplace
orderscatalogreputationFullpaid adscustomer service
complete
Shopee
Marketplace
orderscatalogreviewswebhooks
complete
Magalu
Marketplace
orderscatalogsupport deskmarginpromotionsquestions
read
TikTok Shop
Marketplace
orderscatalogmarginreturnspromotionsvisits
read
SHEIN
Marketplace
ordersafter-salescatalog
read
Dafiti
Marketplace
orderscatalogreturnsmarginwebhooks
read
Leroy Merlin
Marketplace via Mirakl
orderscatalogreturnscouponscustomer service
read
Nuvemshop
Own store
orderscatalogcouponsabandoned carts
read

04 · The system

19 screens, three groups.

The ERP sidebar, opened up, with what each screen does. The ones marked as highlights appear up close below.

Monitor5
OverviewhighlightSales and orders in the periodAccount healthhighlightHow each marketplace rates the store
AdvertisingAd spend and its return
NoticesMarketplace notices for each account
ReviewsRating and comment from buyers
Integrations2
ConnectionsAccounts connected to each store
WebhooksOrder events for your ERP, CRM or n8n
Sales12
OrdersOrders from every channel, together
CustomersWho buys, matched by tax ID
Abandoned cartshighlightWho reached checkout and didn't buy
ListingsWhat's published, with the channel's badges
FulfillmentWarehouse stock: what to restock, what's left over
PromotionsEach account's campaigns
Deal pagesPublic links to share with the community
Bought togetherThe basis for bundles, cross-sell and coupons
Market intelligencehighlightWhere you stand in the niche and who leads
External ordersSales outside the channels, via spreadsheet
Customer serviceMarketplace conversations inside the hub
ReturnsClaims and the returns they bring

05 · Highlights

Five screens up close.

Recreated with sample data and interactive: switch tabs, reach out to carts, watch orders come in.

01 / 05

Overview

Revenue from every channel added up, with what needs attention at the top. When an order comes in, the numbers roll like an odometer, digit by digit, without reloading the screen.

by period and by storeurgent alerts firstlive numbers
erp.yourstore.com/overview
Total sales live
R$1.084.512,30
last 30 days, all stores
Orders
7.618
Average order
R$142,36
Incoming orders
#48212MagaluR$ 312,00
#48211ShopeeR$ 74,50
#48210Mercado LivreR$ 189,90
02 / 05

Account health

Each account's reputation on the marketplace's thermometer, with the metrics that drag the score down and the history of the last 90 days.

five-band thermometereach metric vs. its limitdaily history
erp.yourstore.com/account-health
ReputationDemo Store · Mercado Livreread 12 min ago
Red
Orange
Yellow
Light green
▼Green

Green for 60 days straight. Every metric within the marketplace limit.

Metricslast 60 days
Complaints0.6% / limit 1.0%
Mediations0.1% / limit 0.5%
Cancellations by you0.9% / limit 1.0%
Late shipments4.2% / limit 8.0%
History90 days
YellowLight greenGreen
03 / 05

Abandoned carts

Who reached the store's checkout and didn't buy, with the value left behind and the contact to bring them back. The recovery rate shows whether the effort pays off.

value stuck and recoveredcontact of who gave uprecovery rate
erp.yourstore.com/abandoned-carts
Value stuck in carts
R$690,60in 4 carts
AbandonedR$ 690,60
RecoveredR$ 0,00
Recovery rate
0%recovered
0 of 4 became orders
Pack of 3 basic cotton t-shirts
1 unit · contact available
Kids' play tent
2 units · contact available
Stainless thermos 1L + 2 items
3 units · contact available
Adjustable desk lamp
1 unit · contact available
04 / 05

Results and margin

Gross revenue is misleading. The margin deducts each channel's fee, shipping and refunds, sale by sale, to show what's actually left.

net over grosscost breakdownunpaid kept apart
erp.yourstore.com/margin
Estimated margin
R$786.157,80
of R$ 1.048.210,40 in sales (gross)
75.0%net
Estimated netR$ 786.157,8075%
Marketplace fees− R$ 152.990,1015%
Refunds− R$ 2.310,500%
Shipping you paid− R$ 106.752,0010%
Unpaid
164
R$ 15.210 that never came in
Awaiting
9
R$ 1.302 right now
The margin deducts everything: each marketplace's fee, shipping and refunds, sale by sale, to show what's actually left.
05 / 05

Market intelligence

The best sellers of each tracked category, read daily: where the seller's products show up, who rose and who fell, and the trending searches.

daily ranking7-day movementtrending searches
erp.yourstore.com/market
Sports & leisure› Camping ›Tentsdaily snapshot · today 06:00
position · 7 days
1
Waterproof 4-person dome tent
R$ 389,90
2
Kids' play tentyou
R$ 129,90
3
3
Double air mattress with pump
R$ 219,00
1
4
Rechargeable lantern, pack of 3
R$ 89,90
2
5
Folding beach chair
R$ 149,90
2
6
Cotton hammockyou
R$ 99,90
1
Who moved
3Kids' play tent
2Rechargeable lantern, pack of 3
1Cotton hammock
1Double air mattress with pump
Trending searches
4-person tent+38%kids tent+22%air mattress+17%rechargeable lantern+12%sleeping bag+9%

06 · And more

The rest of the system, in brief.

Eight more screens from the day-to-day: stock, catalog, integrations with other systems, customer service and what happens outside the channels.

Kids' tent + Air mattress
lift 2,4×38 orders together
Lanterns, 3 pack + Rechargeable batteries
lift 3,1×21 orders together

Bought together

People who buy one product also take another: the basis for bundles, cross-sell and coupons.

Dome tent 4pUrgent
Double mattressThis week
Beach chairSurplus
3 units stuck: damaged

Fulfillment

Stock in the marketplace warehouse: what to restock, by when, and what's stuck.

Kids' play tent
R$ 129,90 · 84 in stock
catalog showcaseprice above competitorslisting 92/100moderation ok

Listings

The channel's signals on each listing: moderation, showcase, price and listing quality.

POST https://your-erp.com/orders
X-Hub-Signature: sha256=9f2c…
{
"event": "order.paid",
"store": "mercado_livre",
"total": 189.9
}

Webhooks

Every paid order becomes a signed event for the ERP, the CRM, the invoicing tool or n8n.

deals.yourstore.com/camping
1.284 visits312 clicks● live
Send to the group

Deal pages

A public link with a promotion's deals, sent straight to the WhatsApp group.

Ana · order #4821
Bruno · exchange
Carla · delivery time
Will it arrive by Saturday?
Ships today, arrives Friday!

Customer service

Marketplace conversations inside the hub, with the list and the thread side by side.

Awaiting you 3In progress 7Closed 41
Item not receivedaffects reputation
Item not as describedaffects reputation

Returns

Claims sorted by what needs action now, flagging the ones that affect reputation.

retail-store-sales.xlsx
128 sales imported into the overview

External orders

Sales outside the connected channels, via spreadsheet, so revenue counts in full.

07 · Under the hood

Built to grow one channel at a time.

No business rule knows about a specific marketplace: a new channel is a new adapter, without touching the rest.

01
Panel
React · Vite

The 19 screens, in light and dark themes.

02
API
NestJS · TypeScript

Resolves the store and permissions, and orchestrates everything.

03
Queues
Redis · BullMQ

Imports, daily reads and events in the background.

04
Adapters
one per channel

Translate each API into the same order and product model.

stackTypeScriptReactViteNestJSPostgreSQLPrismaRedisBullMQDockerVitest

Encrypted credentials

Channel access tokens are stored encrypted (AES-256-GCM) and only opened in memory, at the moment of use.

Every store isolated

All data has an owner and every query is filtered by store. Forgetting the filter is hard, not easy.

Privacy by design

Buyer data is kept apart from the order, encrypted and deleted within 90 days (Brazil's LGPD).

Two-step login

App-based 2FA, with recovery codes so access is never lost.

Signed events

Webhooks go out with an HMAC signature, so the receiver can confirm they came from the hub.

No duplicate orders

A repeated marketplace event never becomes a second order: processing is idempotent.

08 · Craft

The details nobody asks for.

1.284

Odometer numbers

Each digit rolls to the new value, in the right direction and with a spring. The width follows the digit, so the text next to it doesn't wobble.

Total sales
R$1.084.512,30
▲ 31%
Total sales
R$1.084.512,30
▲ 31%

A real dark theme

Every color has its own dark version, including status colors, which must stay readable as text and not only as a background.

75%margin

Hand-made charts

Gauges, stacked bars and dot bars in SVG, no library: lightweight, themed, always with a label and number next to the color.

Read-only screens say so in their subtitle, and sales and customers show a "how it's counted" next to the numbers. A screen name that promises what it doesn't do is treated as a bug.
Systems · Web apps · Automations · Websites

Got a process still living in a spreadsheet? Tell me.

Fill in the form and the message arrives neatly organized on my WhatsApp. I reply personally, no bots in between.

What do you need? (pick as many as you like)
When do you need it?

Opens your WhatsApp or email with the message ready for you to review. Nothing is stored on this site.

WhatsApp