Inventory & Ops · from a YouTube video, Nov 6, 2026 · Added

Weekly KPI Sheet and Monday Action Email with Claude

Fill a weekly KPI sheet from Amazon data and email the brand manager five action items every Monday

94%

“a 94% fee spike”

Per source Self-reported by the source, not independently verified.

Copy-paste prompt

Copy-paste promptPrompt written by us, based on this case
Every Monday: from my Amazon data for last week and the week before, fill my KPI sheet [link] with sales, ad spend, TACoS and contribution after ads per brand. Then write a short email comparing the two weeks side by side and list five action items. Flag any SKU whose fee per unit changed by more than 20%. Don't change anything in Seller Central.

The source didn't publish its exact prompt. We wrote this starter so you can try the same workflow. Replace anything in [brackets].

See the original YouTube video

What they did

Dr. Travis Zigler built a Claude system for his own brands and his agency's clients that fills each brand's Google Sheet with weekly and monthly Amazon data (plus COGS). Every Monday it compares the last week with the week before, side by side, and emails his strategic brand consultants Amazon TACoS, blended TACoS and contribution after ads for each brand, then the top five things to do that week.

How it went

In the run he shows, it caught that the per-unit fees on his tinted lip balm went from 2.67 before deal week to 5.18 after it (the video title calls it a 94% fee spike), so he planned to open a case with his Amazon manager. It also flagged new ads that weren't serving yet. He disagreed with one suggestion to cut Shopify Meta campaigns at about 1 ROAS because they also push Amazon sales.

We only report what the source says. Results are self-reported unless noted.

Worth knowing

A short demo on his own brands; the brands also sell on Shopify, so blended figures include it. He doesn't say how the Amazon data reaches Claude in this clip.

Original source

YouTube videoDr. Travis Zigler (Profitable Pineapple) (Dr. Travis Zigler | Profitable Pineapple)Published Nov 6, 2026 · youtube.com https://www.youtube.com/watch?v=_kknRPKCjk4Open the source

Keep going

Related use cases

Inventory & Ops

Account P&L Cost-Creep Trends with the Helium 10 MCP

Catch slow fee and ad-spend creep across months, not just one snapshot ToolsHelium 10, ClaudeSourceBlog post · Lauren Stair (Helium 10)SharedAug 25, 2026PromptWritten by us
Show promptHide prompt for Account P&L Cost-Creep Trends with the Helium 10 MCP,Written by us

Inventory & Ops

Seller Central Monitoring and PPC Rules with Claude

Monitor account health, hijackers, stranded inventory and suppressed listings across brands ToolsClaudeSourceX post · Keith RichmanSharedMay 8, 2026PromptWritten by us
Show promptHide prompt for Seller Central Monitoring and PPC Rules with Claude,Written by us
Every morning at 8am, for each of my brands' Seller Central accounts, check: Account Health rating and any new policy warnings; any new sellers on my brand's ASINs (possible hijackers); stranded inventory; suppressed or inactive listings. Post one Slack message per brand with only what changed since yesterday, marked [urgent] or [FYI], and a link to the Seller Central page for each item.

Inventory & OpsShows real resultsOlder post · Apr 2026

SP-API MCP Server Built with Claude Code

Connect Claude to my own Seller Central data so I can ask questions in plain words
80%“he has automated 80% of the brand's operations” self-reported
ToolsClaude Code, ClaudeSourceBlog post · Mansour NorouziSharedApr 1, 2026PromptWritten by us
Show promptHide prompt for SP-API MCP Server Built with Claude Code,Written by us
I have SP-API developer credentials for my own seller account. Help me build a small read-only MCP server in TypeScript that exposes: sales by ASIN for a date range, FBA inventory, open orders, catalog item details and settlement summaries. Handle token refresh, rate limits, pagination and async report polling. Pin every dependency version, keep credentials in environment variables, and don't add any write endpoints.

Inventory & Ops

Retail Arbitrage Receipts to Listings and Shipping Plans with Claude

Turn a batch of retail arbitrage receipts into listings, a COGS sheet and an FBA shipping plan ToolsClaude, Amazon Seller AssistantSourceX post · Britton JewellSharedOct 25, 2026PromptWritten by us
Show promptHide prompt for Retail Arbitrage Receipts to Listings and Shipping Plans with Claude,Written by us
I'm an Amazon FBA seller doing retail arbitrage. The folder [folder] has photos of one receipt batch.
1. Read every receipt. For each item give store, date, item title, quantity and unit cost (include tax if it's on the receipt). Mark any line you can't read clearly instead of guessing.
2. Match each item to an ASIN and show me the match before listing anything.
3. After I approve, create the listings, then reconcile my quantity on hand against the receipt totals and flag any mismatch.
4. Add one row per item to my Google Sheet: date, item title, COGS, quantity, ASIN.
5. Draft the FBA shipping plan for the items I mark as prepped and packed. Don't submit it until I say so.

Inventory & OpsShows real results

Sourcing Purchase Tracker App with Claude

Replace a paid purchase-tracking sheet for an Amazon resale business with a self-built app
$468 a year“'$468 a year back.'” self-reported
ToolsClaudeSourceX post · CuriousCrateLabSharedOct 23, 2026PromptWritten by us
Show promptHide prompt for Sourcing Purchase Tracker App with Claude,Written by us
Build me a simple purchase tracker for my Amazon resale business. I want to log each sourcing buy with: date, source, item, quantity, cost per unit, shipping and tax, and the ASIN I plan to sell it under. Show running totals per month and a list of items bought but not yet sent to FBA. Keep the data in a file I own and let me export it as CSV. Start with the smallest version and ask me before adding features.

Inventory & Ops

Bookkeeping and FBA Shipment App with Claude

Replace InventoryLab and Sellerboard with a custom-built tool ToolsClaudeSourceX post · ParkerSharedOct 12, 2026PromptWritten by us
Show promptHide prompt for Bookkeeping and FBA Shipment App with Claude,Written by us
Help me design (don't code yet) a small bookkeeping app for my Amazon + Walmart + eBay business. It must track: sales by channel, refunds, Amazon reimbursements, expenses, shipping costs, inventory on hand by SKU with COGS, and cash flow. Propose the data model (tables and fields), what each channel's settlement/transaction report maps to, and the 5 screens I need. Ask me about anything you're unsure of.