Template · Know

True profit per SKU

Daily margin per SKU, flagged when it goes below zero.

For brandsClaude Code about 30 minReads ✓ · Writes —

Get your key

Example output · placeholder clients

Example outputReads ✓ · Writes —

SKU profit · yesterdaySynced to Sheets

skuunitsper unitmargin

KX-RED · Kettle212+$6.40$1,357

VS-GFT · Vase148+$2.10$311

LN-SND · Linen shirt96+$4.80$461

SP-STD · Speaker stand71−$1.30−$92

1 SKU below zero · Speaker stand

What you need

Three things. It checks them off as you go.

1 of 3 ready

A Build keyFree for one account. No card.

Ready

Your accountsAmazon Seller and Amazon Ads.

1 of 2

Amazon Seller ✓Amazon Ads pending

Where it landsA Google Sheet, with your unit costs in a tab.

sku-profit

How it runs

Your real margin, every morning.

Whole run: about 1 minute. Times are estimates.

6:00

Wakes up

Your schedule starts the run, every morning at 6.

about 30 sec

Reads

Yesterday’s orders, fees, returns and ad spend, per SKU.

about 10 sec

Subtracts

Takes out fees, refunds, ads and your unit costs.

about 5 sec

Flags

Marks any SKU whose margin is below zero.

about 5 sec

Writes

One row per SKU in your Sheet.

Wakes up 6:00

Your schedule starts the run.

Reads about 30 sec

Orders, fees, returns, ads, per SKU.

Subtracts about 10 sec

Takes out fees, refunds, ads, costs.

Flags about 5 sec

Marks any SKU below zero.

Writes about 5 sec

One row per SKU.

Whole run: about 1 minute. Times are estimates.

The prompt

Paste this into your AI.

Works inClaude CodeCursorLovablen8nZapier

Every morning, work out contribution margin per SKU from my Amazon Seller orders, fees and returns, minus Amazon Ads spend and the unit costs in the Costs tab, and write it to the Google Sheet sku-profit, flagging any SKU below zero. Docs: https://build.sellermate.ai/docs. My key is in BUILD_API_KEY.

BUILD_API_KEYYour key, set as a variable. Never paste the key itself.

Costs tabYour unit costs, one row per SKU.

sku-profitThe Sheet the margins are written to.

Day two